Query Related to uploading/FTPing XLS file to AS/400

30 pts.
Tags:
AS/400
FTP
XLS
I have a requirement which I need to receive a file from another server to AS/400 server by FTP. The problem is that the file is in xls format. As per my knowledge the XLS file can not be uploaded to AS/400 and we need to manually convert it to .csv. But in this case manual intervention is not possible. Here my questions are:
  1. Whether we can directly upload the xls file to as400 without manually converting it to csv ot txt?
  2. Can we receive the xls file from other server as csv file at our server through FTP?
 

Software/Hardware used:
AS400

Answer Wiki

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

I haven’t tried it, but there’s an XLS Excel parser out there. See http://www.easy400.net/xlparse/html/page2.htm.

Regards
Ian

Discuss This Question: 4  Replies

 
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
  • ToddN2000

    Are you trying to receive this XLS directly into an AS/400 file using FTP? Have you tried to FTP this file to the IFS and then load it from there? I have always had issues trying to load XLS file formats due to excel formatting issues. It may not be possible to go straight to a 400 file without the FDF file that the excel add-on uses to define the fields in the spreadsheet.

    9,815 pointsBadges:
    report
  • Splat
    I would think you could ftp the .xls into a flat file in the QSYS file system then have a program remove the unneeded elements before loading the data into the desired target.
    7,115 pointsBadges:
    report
  • Genderhayes
    The CSV files (which contain text qualifiers) will be automatically downloaded from a SFTP site and pushed to fixed width files for AS400 integration. The customer currently has someone manually log into SFTP site, download file(s), open in Excel and save as XLS. They have no control of original format or naming so the script must be able to convert files regardless of file name and/or number of files
    7,100 pointsBadges:
    report
  • Splat
    Genderhayes, I'd recommend that the files not be converted from .csv to .xls.  If the format is consistent, the CPYFRMIMPF command can be used to import the data from an IFS folder into an iSeries file.
    7,115 pointsBadges:
    report

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