Skip to main content

Hello,

 

I’m trying to upload a Bank Statement, using the following template:

 

 

However, when I try to finish the process, there’s a error message:

 

 

As decimal I’m using dot “.” and the columns are from the template.

 

Any thoughts?

 

Thanks

Hi,

You can simply check whether your file contains the correct decimal symbol as per your external file template.

If you are dealing with a user defined external file template, go to the general tab and change the decimal symbol. If it is a system defined one, you can copy the template and change thereafter.

Alternatively, you can change the decimal symbols in the file details as well.

Also you need to check whether you get a characters for number columns in the file.

Hope this might help you in someway.

 

Best Regards,|
Chirantha.

 

 


Hey @Chirantha, thanks for your help.

 

I am using a system defined template, as below:

I extracted the info/template through the Output menu:

However, the output was this:

In this sense, I formatted to this, basically changing rows into columns:

And filling the information as this:

 

 

Any thoughts about what may be wrong?

 

Thanks once again.

 

Best regards


Please open your load file in notepad and make sure your file has columns separate by semicolons and not commas (the way Excel saves csv file depends on language used). Make sure as well your date data are provided in correct date format, as per template shared it should be YYYY-MM-DD and I can see DDMMYYYY in your file.