Skip to main content
Solved

External file type / header row

  • March 17, 2020
  • 5 replies
  • 1097 views

Forum|alt.badge.img+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.

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.

5 replies

Shehan Almeida
Superhero (Partner)
Forum|alt.badge.img+18
  • Superhero (Partner)
  • March 17, 2020

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.

 


Forum|alt.badge.img+4
  • Author
  • Do Gooder (Customer)
  • March 27, 2020

Hi

For some reason this doesn’t help.

My setup is like below:

And still the first line is transferred:

 

Any idea why?


Shehan Almeida
Superhero (Partner)
Forum|alt.badge.img+18
  • Superhero (Partner)
  • Answer
  • March 27, 2020

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.


Forum|alt.badge.img+4
  • Author
  • Do Gooder (Customer)
  • March 27, 2020

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

 

Br. Maaret


Forum|alt.badge.img+3
  • Do Gooder (Customer)
  • December 5, 2022

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?