How was it possible the skip first row when transferring CSV-file with external file / voucher assistant? It was some setup in External file template, but can remember it. We are using Apps9.
Solved
External file type / header row
Best answer by Shehan Almeida
Hi,
It always depend on your file template and columns. I think in your case you are missing the control string. Please see my setup below.
The header is skipped successfully.
Hope this helps..
Best Regards,
Shehan Almeida.
+18Hi Maaret,
This can be done in the ‘External file Template Control’ window. RMB on the ‘Input File’ tab of the template and select ‘‘External file Template Control’
Hope this is how you did it before.
Best Regards,
Shehan Almeida.
Hi
For some reason this doesn’t help.
My setup is like below:
And still the first line is transferred:
Any idea why?
+18Hi,
It always depend on your file template and columns. I think in your case you are missing the control string. Please see my setup below.
The header is skipped successfully.
Hope this helps..
Best Regards,
Shehan Almeida.
+3I have the same problem. I need to tell IFS to ignore the first row of the CSV file. I follow the directions above but still received an unpack error. Row one is the header row to be ignored.
External file template:
What do I put in the external file template control for the control string?
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.