Page 1 of 1

print file to XML on PC/UNIX

PostPosted: Thu Oct 14, 2010 3:26 am
by smithsummit
Hi,

I am new to IBM mainframe. We are receiving print files from an outside source and I need to load the information contained in them to an Oracle database on AIX. Does there exist a program that will parse the print file and output, say, XML?

Thanks!

Best Regards,


Rob

Re: print file to XML on PC/UNIX

PostPosted: Thu Oct 14, 2010 8:03 am
by dick scherrer
Hello and welcome to the forum,

Is there some reason why this data is not received directly on the Unix system?

If the selected/reformatted data is to be loaded into a database, suggest you consider creating a delimited file to be used as input to an Oracle load.

Re: print file to XML on PC/UNIX

PostPosted: Thu Oct 14, 2010 11:56 pm
by smithsummit
Hi,

The print files are FTP'd to me as is from an outside source. So far this appears to be the only way data can be supplied, though I am continuing to ask for delimited text or XML...

Regards,


Rob

Re: print file to XML on PC/UNIX

PostPosted: Fri Oct 15, 2010 12:33 am
by dick scherrer
Hello,

While the "sender" may not be willing to create the files differently, it is fairly easy to read a "report" and generate a delimited file from the report. This could either be done on the mainframe or on the unix system if the data can be sent directly there.

Re: print file to XML on PC/UNIX

PostPosted: Fri Oct 15, 2010 1:32 am
by smithsummit
Hi,

How do you read a "report" file in a UNIX env?

Thanks,

Rob

Re: print file to XML on PC/UNIX

PostPosted: Fri Oct 15, 2010 2:40 am
by dick scherrer
Hello,

As they told me when i first started working with unix - "Everything is a file" :)

That the content is a formatted report does not matter - it is all just data when read by code.

Whether from the mainframe or from the report creator, the ftp process will put the file onto some directory on the unix system. Suggest you talk with the unix admins to learn where this data should be stored. How the directories are managed on that system are completely site-dependent. SOmetimes, there are separate directories for inbound ftp transmissions. Sometimes, these are put in a "project" directory. Sometimes, in a user directory. Your support people will be able to provide guidance.