Slightly off-topic, but it references something Jason mentioned

[mark.spencer@xxxxxxxxxxxxxx]

Jason mentioned that he has managed the following....

>Can Excel import XML?  I hacked a utility called asdbget which uses FTP and
>some AS/400 specific magic to retreive files from the 400 and put translate
>them in to ASCII XML format (which has a header describing the complete
>file layout).

Can you tell me how you managed this ? I am trying to work out a method of
converting AS400 spool files to ASCII so that I can then display them as part of
a web page. My thought is to give "manager-type" reports to the manager-types
without giving them access to the AS400 spool-files.

The steps I believe I need to take are:
1) Convert the spool-files to ASCII (or XML, or whatever...)
2) FTP them from the AS400 to the web-server (Sorry, it's NT-based IIS4.0)
3) Include the data in an HTML page for display bya a manager

The only part I am unclear on is the conversion. I have cobbled together scripts
to handle running the remote command, FTP'ing the files, and inserting the data
into the page, so hte missing link is the conversion.

Any help would be greatly appreciated by the trees of our planet, since it would
mean not printing thousands of pages daily.

Mark Spencer
mailto:marksspencer@home.com


+---
| This is the LINUX5250 Mailing List!
| To submit a new message, send your mail to LINUX5250@midrange.com.
| To subscribe to this list send email to LINUX5250-SUB@midrange.com.
| To unsubscribe from this list send email to LINUX5250-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---