External voucher upload error

Hello @Thej 

What is your separator ID and decimal symbols?

Can you copy screen shot from General tab of external file template? Also open csv file with notepad and copy it. Click RMB on the csv and open with notepad

Thanks

@Furkan Zengin ,

This is the general tab of the external file template.

@Thej 

looks like your seperator should be colon in stead of semi colon. 

so best is to save your excel as an csv and then open the file in notepad or so and double check if the seperator is a colon (,) or a semicolon (;). 

that should fix your issue.

(I would also suggest to remove your data from the forum as this seems to be client specific info)

Hell @Thej 

1. Change Separator ID to 4-Comma( , ).
2. Change Decimal symbol to dot ( . ).
3. Enter double quotes in Text Qualifier field ( " ) 
4. Change date format to D/M/YYYY

That should work then.

@Furkan Zengin ,

Still I am getting unpack error. But, nothing is there in error text field.

Hi @Thej,

in my opinion there is a problem with first column Voucher_no - could you please check if this column is empty in your file ?

The begging of line should looks like:

;2024;803010300;…

best regards,

Małgorzata

Hi @Thej   If Column Y is a text field I’m guessing IFS doesn’t like your special characters in a csv file.   The “&” in particular.