xibo
xibo copied to clipboard
Dataset: Incorrect column alignment when importing CSV with semicolon delimiters
When importing a CSV file, columns are not properly aligned when the CSV file uses semicolons (;
) as delimiters instead of commas (,
).
Steps to Reproduce
- Example CSV content:
Column1;Column2;Column3
1;John;Doe
2;Jane;Smith
-
In Dataset Grid, access the DataSet.
-
Go to Row Menu and select
Import CSV
-
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,