xibo icon indicating copy to clipboard operation
xibo copied to clipboard

Dataset: Incorrect column alignment when importing CSV with semicolon delimiters

Open ifarzana opened this issue 7 months ago • 0 comments

When importing a CSV file, columns are not properly aligned when the CSV file uses semicolons (;) as delimiters instead of commas (,).

Steps to Reproduce

  1. Example CSV content:
Column1;Column2;Column3
1;John;Doe
2;Jane;Smith
  1. In Dataset Grid, access the DataSet.

  2. Go to Row Menu and select Import CSV

  3. Configure Import Settings:

  • Add CSV Files: Select the CSV file with semicolon delimiters using the file upload.
  • Ensure Overwrite existing data is checked.
  • Ensure Ignore first row option is checked.

Expected Behaviour: The importer should correctly parse and align columns from CSV files

Actual Behaviour: The columns from CSV do not correctly mapped to corresponding fields in the DataSet, image

ifarzana avatar Jul 16 '24 12:07 ifarzana