on 04-12-2011 2:53 PM
Hi experts.
We're having a problem in File Sender Adpapter.
We've configured the adapter with FCC. We use the fieldSeparator = ; to convert the file to xml.
The problem arises when between two ; appears a quote. For insantce in this line:
HUMALVAL MASCOTAS S.L.;"AV/DE EUROPA SN;P.IND.ALCORCO;28922;ALCORCON;40.349968;-3.847452;
The adapter shows this error:
More elements in file csv structure than field names specified.
If the line was (without "):
HUMALVAL MASCOTAS S.L.;AV/DE EUROPA SN;P.IND.ALCORCO;28922;ALCORCON;40.349968;-3.847452;
everything would work correctly.
How could we solve this?
Thanks in advance.
Regards.
Thanks everybody.
The problem wasn't the ", the problem was that in the file travel more ; it has to be.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use
Record.enclosureSign: ''
Thanks
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please use xml.enclosureSign=u201C in your sender FCC.
Hopes this helps to you.
Regards,
P.Rajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.