Page 1 of 1

WitpLoadAE issue (SOLVED)

Posted: Mon Jun 03, 2013 12:42 am
by GaryChildress
Getting something weird happening using WITPLOADAE. When I export to CSV file the leader file seems to be skipping some numbers or fields or something. See below:



Image

RE: WitpLoadAE issue

Posted: Mon Jun 03, 2013 12:45 am
by PaxMondo
I don't think you can have quotation marks in name field. I would remove them and see what happens.

RE: WitpLoadAE issue

Posted: Mon Jun 03, 2013 12:53 am
by GaryChildress
Yep that was it. I took out the quotations (actually from the vanilla scen 1 I think) and it worked fine.

RE: WitpLoadAE issue

Posted: Mon Jun 03, 2013 2:18 am
by PaxMondo
There's probably some special formatting you can use for quotation marks, but that would have to be answered by Bill or Michael.

RE: WitpLoadAE issue

Posted: Mon Jun 03, 2013 4:16 pm
by inqistor
This is actually probably problem with EXCEL.

When you open file, it asks you which characters should be used for separation of fields - there should be only one of them: "," - but it probably shows also ", just uncheck any other