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
Best answer by Chirantha
View original
+8
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
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
