It's worked the last 4 tries (tho had to tweak each time), but now I just get basically one long field coming in. The comma delimitors are treated as just another character byte. While setting up a "power user" to take over this function (so no .fdf or other residuals from prior successful uploads), I took the steps ...
(A) Transfer (via Client Access) from iSeries to PC to create the .fdf (tried as .csv and as "no subscript" for PC target filename) (B) Save the desired spreadsheet as a .csv (C) Run transfer to iSeries using this .fdf and opting to replace the existing physical file member (all fields are character).
Result was the proper record count, but not delimited.
Any ideas on what I might be missing ? Alternate schemes ?
I did try using the .xls and also Excel add-ins (seems to not translate the character data this way). Tried creating new iSeries file (no better). The A, B, C steps seem like the best option, but ...
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!