Skip to main content
Solved

External File Assistant - Error uploading

  • August 9, 2021
  • 3 replies
  • 650 views
L
Sidekick (Partner)
Forum|alt.badge.img+7
  • Luiz R
  • Sidekick (Partner)
  • 20 replies

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

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.

 

 

This topic has been closed for replies.

3 replies

Chirantha
Hero (Partner)
Forum|alt.badge.img+8
  • Chirantha
  • Hero (Partner)
  • 70 replies
  • Answer
  • August 9, 2021

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.

 

 

Chirantha
L
Sidekick (Partner)
Forum|alt.badge.img+7
  • Luiz R
  • Author
  • Sidekick (Partner)
  • 20 replies
  • August 10, 2021

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

A
Hero (Customer)
Forum|alt.badge.img+16
  • Adam Bereda
  • Hero (Customer)
  • 735 replies
  • August 10, 2021

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. 

Regards, Adam
Terms & ConditionsCookie settingsAccessibility statement