Home > IT Answers > AS/400 > File transfer to the iSeries problem.
Help

Question

  Asked: Jul 13 2005   10:11 AM GMT
  Asked by: bkr0963c

File transfer to the iSeries problem.


AS/400, OS/400, iSeries, i5, Backup & recovery, Hardware, Installation, Integration/Connectivity, Logical partitions, PC/Windows Connectivity, Performance/Tuning, Printing/Output, PTFs, Security, Server consolidation, System monitoring, Tools, tips and tricks

I am trying to transfer an excel speadsheet file to my AS/400. I have tried setting up a file transfer through client access and tried sending the file directly from Excel. Both times I get the following error

cwbtf0023 - pc file description file was not specified or is empty

The file is not empty. Any suggestions?

Also, through Excel I have tried numerous options like having it create the physical file and member for me on the AS/400 as well as the option of sending the info to a file already created on the AS/400. I continue to get the same error as above.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Jul 13 2005  10:31 AM GMT  by neilm1m




Do you have a drive mapped directly to the IFS? If so all you need to do is save it to there. No need to transfer files then.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on AS/400, Storage and DataCenter.

Looking for relevant AS/400 Whitepapers? Visit the Search400.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

WaltZ400  |   Jul 13 2005  12:42PM GMT

If you are trying to transfer Excel data into an AS/400 physical file, you need a PC description file on your PC to tell the upload how the columns and fields are laid out.

First create the PF on the AS/400 with DDS to define each field based on the columns in the Excel document.

Next do a Client Access download of the AS/400 file down to your PC. Make sure you take the option to create a PC description file specifying the file name and folder to store it in. Run the download. Don’t worry if you get a message saying no data transfered. All you are doing here is creating the field map file.

Next, I always find it easier to save the Excel spreadsheet as a CSV file before uploading the data.

Next, define an upload to the AS/400 specifying the CSV file you are copying, what AS/400 file to send it to and what the name of the PC description file is. Make sure you define the input PC file as a CSV in the upload.

Then run the upload. If all goes well the data should be in your PF on the AS/400. You might need to experiment as I have had problems sometimes with dates etc. since Excel stores these as offsets.

Hope this helps.

 

bkr0963c  |   Jul 14 2005  11:05AM GMT

Thanks guys. I was able to get it to work.

 

johnknight  |   Jul 19 2005  9:01AM GMT

Just another note, if you use the file transfer wizard in Client Access, it will analyze your spreadsheet & create the file description on the fly. It’s customizable & works very well.