File transfer to the iSeries problem.
Home > IT Answers > Microsoft Windows > File transfer to the iSeries problem.
bkr0963c
0 pts.
0
Q:
File transfer to the iSeries problem.
Installation, Hardware, AS/400, OS/400, iSeries, i5, Security, Integration/Connectivity, Logical partitions, PC/Windows Connectivity, PTFs, Server consolidation, Tools, tips and tricks, System monitoring, Printing, Performance/Tuning, Backup & recovery
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.
ASKED: Jul 13 2005  10:11 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
neilm1m
0 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Jul 13 2005  10:31 AM GMT by neilm1m   0 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

WaltZ400   535 pts.  |   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   0 pts.  |   Jul 14 2005  11:05AM GMT

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

 

johnknight   0 pts.  |   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.

 
0