How can I transfer a file from th as/400 to my documents as a csv file using client access?

385 pts.
Tags:
AS/400 data transfer
Client Access Transfer
CSV file format
How can I transfer a file from th as/400 to my documents as a csv file. When I try to copy now I get a a bit map file with using 40 for blanks. I'm trying to use client access to move the data.

Answer Wiki

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

change your transfer to write the file out to a .CSV file for MS Excel.

-sarge

Discuss This Question: 5  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
  • Craig Hatmaker
    Sarge's answer is right on with what you asked; however, many times people who want to move files to csv don't want a csv per se - they want data in Excel as Sarge also alluded to. If you're looking to use AS/400 data in Excel, you may want to check out my blog that goes more in depth on that subject: Beyond Excel. The blog is not AS/400 specific but works very well with AS/400 data. The techniques presented there are my company's primary means for reporting AS/400 data. We also use it for some updates. A video demo of the final results can be viewed here: YouTube Video Demo I hope this is helpful.
    1,710 pointsBadges:
    report
  • TomLiotta
    When I try to copy now I get a a bit map file with using 40 for blanks. Although the whole question seems a little confused, this part seems to indicate a CCSID problem. The bit about "40 for blanks" makes me think of a file encoded as EBCDIC being viewed in hex. So, first, what does Client Access have to do with the transfer of a .CSV file? There should be no need for Client Access unless you're using a very old AS/400 or a very old PC. This kind of transfer would usually be done simply with drag/drop to or from a Windows mapped drive. You shouldn't even need to have Client Access installed. What are you using to view the file? What program tells you there are "40 for blank" positions in the file? I suspect that you have a .CSV on the AS/400. After you view a copy of it on your PC, you see what looks like a "bit map file" to you. Most likely in that case, you are only missing a configuration piece that converts from EBCDIC to ASCII for your PC, but it's not clear from your question where that configuration needs to be done. Tom
    125,585 pointsBadges:
    report
  • NullFields
    To get rid of this "bit map" view of the data, In client access properties, on the first tab named "Conversions", you can change under the general options to check the box next to "Convert CCSID 65535".
    880 pointsBadges:
    report
  • MDratwa
    I use the "CPYTOIMPF" command to copy a file to a ".csv" file. We have a "TRASH" directory in the IFS to use (it gets clears nightly). The command is: "CPYTOIMPF FROMFILE(youlib/filename) TOSTMF('/trash/filename.csv') STMFCODPAG(*PCASCII) RCDDLM(*CRLF)". This will copy all fields in the file with a comma between each field. It will be translated to ASCII and add a carriage return and line feed to the end of the record, then you can open it using a mapped drive for "/TRASH". You can use a program or SQL to select the fields/records from the original file. If you want to copy a ".csv" file back to an AS400 file. I moved a copy of the file into the "TRASH" directory (saves mapping a drive to where the file is stored). The command to use is: "CPYFRMIMPF FROMSTMF('/trash/a.csv') TOFILE(TRASH/A) MBROPT(*REPLACE) RCDDLM(*CRLF)". The fields in the PC file must line up with the fields in the fields in the file. You can replace the records (as above) or you can add records to a file using the "*ADD" instead of "*REPLACE" option.
    785 pointsBadges:
    report
  • TomLiotta
    When I try to copy... Have you solved the problem? If not, tell us how you did the "copy"? I would probably use Windows Explorer to open a mapped drive for a directory shared off the AS/400, then drag/drop the .CSV to my PC. There are too many ways to do the copy. We can't guess how you did it, so we can't know how you can make it work until you tell us. Tom
    125,585 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