'Row has more values than columns' when Department Name contains a comma

1

Hello community,

I am facing an issue when importing my Department structure CSV file. Many of my department names contain a comma, for example: "Directorate of Finance, Risk Management & Human Capital".

The Issue: When I try to import the file, I get the error:

Row [X] Row has more values than columns

I have ensured that:

  1. The data is properly enclosed in double quotes (") in the CSV file, following standard CSV protocol.

  2. The header columns are correctly mapped (Department, Parent Department, Is Group).

My Question: Does the Frappe Data Import Tool have a known issue with handling commas in field values, even when they are correctly enclosed in double quotes? Is there an alternative separator I should use for the import process, or a setting I need to enable to correctly parse the quoted fields?

Thank you for any insight!

2

You have an option of uploading a XLS template as well. Maybe try that and see if it works for you.