Issue Summary

When importing a CSV file, if a column contains a double quote (") character and the value is not properly escaped, the import is finished without any error, but the rows are not fully imported.

Steps to Reproduce

• Create a CSV file with a column value containing an unescaped double quote.

Name,Type,Date
"John","1",2025-01-01
"Peter","2",2025-01-01
"Jack","3"",2025-01-01
"Alan","4",2025-01-01 

• Attempt to import the file.

• Observe that the application does not correctly parse the columns, resulting in missing objects.

The issue is commonly related to an Asset Data Manager export file, which doesn't add the escape character. 

Expected Results

All rows should be imported, or an error should be shown.

Actual Results

Only the rows before the unescaped value are imported.

Workaround

Any value containing a double quote, must escape it by using two consecutive double quotes (""). Or just remove it if not required.

Name,Type,Date 
"John","1",2025-01-01 
"Peter","2",2025-01-01 
"Jack","3""",2025-01-01 
"Alan","4",2025-01-01