search

xibosignage / xibo

Xibo Digital Signage
https://xibosignage.com
GNU Affero General Public License v3.0
572 stars 164 forks source link

Dataset: Incorrect column alignment when importing CSV with semicolon delimiters #3455

Open ifarzana opened 2 months ago

ifarzana commented 2 months ago

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

  2. In Dataset Grid, access the DataSet.

  3. Go to Row Menu and select Import CSV

  4. 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