Custom Delimiters in Data Import not working as expected

ERPNext
,
1

Today I wanted to import a bank statement from a csv file. We are located in Europe hence commas for amounts are , instead of .

Therefore as delimiter mostly a semicolon is used ;

Noe the problem, even if I check the “custom delimiter” box and populate it with ; normal commas are still recognized as delimiter. Which leads to errors like: “Row has more values than columns” due to the fact, that a description might have some commas in it.

image
image1852×625 70.2 KB

to my question now, is this the expected behavior or not? Also how can I solve this problem, is there anything I’m missing?

2

@thefox Before importing, open the file in LibreOffice Calc or Excel:

  • File → Save As → CSV → set delimiter to comma, decimal to dot
  • This converts it to standard RFC 4180 CSV that Frappe’s importer handles cleanly
3

Hi @thefox

@Falguni_Satat_Tech has given a good work-around but it seems to be a bug so better report it on: -

4

Exactly, also in the example, where in some descriptions commas are used this workaround wouldn’t work. @asieftejani if you think this is bug I will report it.

thanks