Solved

External file type / header row

  • 17 March 2020
  • 5 replies
  • 878 views

Userlevel 3
Badge +4

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.

icon

Best answer by Shehan Almeida 27 March 2020, 09:35

View original

5 replies

Userlevel 7
Badge +15

Hi 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.

 

Userlevel 3
Badge +4

Hi

For some reason this doesn’t help.

My setup is like below:

And still the first line is transferred:

 

Any idea why?

Userlevel 7
Badge +15

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.

Userlevel 3
Badge +4

Yes, this helped :) Thank you a lot Shehan!

 

Br. Maaret

Badge +3

I 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