How to recieve a excel file via AS2 running on iSeries

5 pts.
Tags:
Excel to iSeries
iSeries import/export
Microsoft Excel
I need to schedule to download reorts from Walmat retail link. The reports are generated in excel format and downloaded using AS2 protocol.

When I receive the file in iSeries it is not readable. I need to convert the excel format into data base file format. Any thoughts



Software/Hardware used:
Iseries, AS2software by bTrade

Answer Wiki

Thanks. We'll let you know when a new response is added.

An Excel file needs an Excel file processor (or Excel itself) to read it. Did you study the Excel file format documentation to learn how to read and process them and write such a processor? …or download such a utility from the web?

I have a database file named ACCPTH on my system. If I FTP it to your system, how would you know what to do with it? Ideally, I would FTP it as a savefile that you could restore. In effect, that would bring a kind of “processor” along with it — the file description itself that would provide the info to DB2 to let it know where the boundaries between fields are, what the data types and lengths are, what CCSIDs are involved and everything else that might be needed.

An Excel file has all of that included but not in any form that DB2 can understand. You need to provide the routines that can read the formatting info and apply to the data. (Some of the “formatting” is simply in knowing the general structure.}

Also, you need to ensure that your system is properly configured to receive such files from other (ASCII?) systems. For example, you should start by verifying that your QCCSID system value is <b>not</b> set as 65535 but rather for your correct CCSID (probably 37). Even if you have everything needed to process the Excel format, the bit patterns of every byte that gets transferred to your system need to be converted according to their intended encodings.

If you don’t have any Excel processors, start by reviewing <a href=”http://www.javaworld.com/javaworld/javaqa/2001-06/04-qa-0629-excel.html”>Read MS Excel files with Java</a> and <a href=”http://poi.apache.org/”>Apache POI – the Java API for Microsoft Documents</a> to get initial info.

Tom

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following