Re: XML downloaded...how to upload?

[Ken.Slaugh@xxxxxxxxxx]

Have you opened the file with NotePad? Does the file contain any CRLFs what
so ever? If the CRLFs are imbedded, per usual, then the file can be saved
on an iSeries NetServer share, as is.

Once the file is located on the iSeries, the CPYFRMSTMF or CPYTOPCD can be
used to convert it to EBCDIC and store the data in a native file with a
fixed record length. Then the RPG program opens the file and uses the ML
procedures to parse the data.

Creating XML data from RPG and delivering it in ASCII is similar. RPG
writes to a fixed record length file and CPYTOSTMF or CPYTOPCD is used to
convert it to ASCII.

Hope this helps.

Ken Slaugh  (707) 795-1512 x118
Chouinard & Myhre, Inc.
AS/400 Professional Administrator/MSE
Client Access Specialist
http://www.cm-inc.com/



                    "Rick Rayburn"
                    <the400man@hotmail.        To:     midrange-l@midrange.com
                    com>                       cc:
                    Sent by:                   Subject:     Re: XML 
downloaded...how to
                    midrange-l-admin@mi        upload?
                    drange.com


                    08/16/2002 10:16 AM
                    Please respond to
                    midrange-l






The file is coming in directly to a PC. I need to transport it into EBCDIC
from that environment and I have no clue what to use for that procedure.


>From: Ken.Slaugh@cm-inc.com
>Reply-To: midrange-l@midrange.com
>To: midrange-l@midrange.com
>Subject: Re: XML downloaded...how to upload?
>Date: Fri, 16 Aug 2002 09:29:36 -0700
>
>
>If you wish to have access to RPG procedures that process XML...
>
>Check out
>http://www.cm-inc.com/Apps/iSeries/Utilities/DspSrcPFM.asp?Library=BOGP&File=CMGPSRC&Member=ML1_PROCS

>
>With these procedures your RPG programs can parse and create the XML data.
>You certainly could convert XML to CSV but if your program can handle the
>XML itself then the conversion may not be required.
>
>Ken Slaugh  (707) 795-1512 x118
>Chouinard & Myhre, Inc.
>AS/400 Professional Administrator/MSE
>Client Access Specialist
>http://www.cm-inc.com/
>
>
>
>                     "Rick Rayburn"
>                     <the400man@hotmail.        To:
>midrange-l@midrange.com
>                     com>                       cc:
>                     Sent by:                   Subject:     XML
>downloaded...how to upload?
>                     midrange-l-admin@mi
>                     drange.com
>
>
>                     08/16/2002 06:04 AM
>                     Please respond to
>                     midrange-l
>
>
>
>
>
>
>We just closed an agreement to receive an EDI - type transmission in which
>the data file will be sent and retrieved in XML format. Having virtualy no
>experience with XML, I have no idea about how or what software might:
>
>1. convert the file to a CSV or text - type format
>2. convert to EBCDIC and land it on the AS400
>
>Thanks much.
>
>Rick Rayburn
>
>
>_________________________________________________________________
>Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.
>
>
>
>
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.




_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.