Bill
Apr 25 2006, 07:16 PM
I loaded UL and everything seems to be running fine. I exported my .XLS to a .CSV format but only the first 16 records transfer and rejjects the other 600+. I cut the first 16 and tried it again but it does the same thing. I saw someone else had this problem in this forum but there was no answer posted. I really need to get this running ASAP so any thoughts would be greatly appreciated. I attached tmy CSV file but please do not post it. Thanks!
Brian
Apr 25 2006, 08:49 PM
Your CSV file had 3 commas at the end of each record on lines 1 through 16. On line 17 and beyond, it did not have these 3 commas (field placeholders).
That was causing all records after 16 to get skipped.
All records must have commas separating all 23 fields, even if they are blank.
I have addressed this issue better in your trouble ticket and have edited your file as well.