1. Jerry Thomas
  2. Sherlock Holmes
  3. General
  4. Tuesday, 19 July 2016
  5.  Subscribe via email
When I double-click on a .csv file, it is opened in Excel. The csv-files have columns delimited with semicolons (not commas, but also a valid format).

Using a German Windows/Excel setup, the opened file is displayed correctly, the columns are separated where the semicolons existed in the csv-file. But when I do the same on an (US-) English Windows/Excel setup, only one column is imported, showing the whole data including the semicolons in the first column.

You can change the CSV separator in Matukio>configuration>setting>advanced>CSV Separator BUT this does not change the system fields 'Booking number';'Event title';'Booked places' which still have ; (semi colons).

Workaround -
1. Rename the file .txt and import into Excel
2. Add this on the first line of the CSV file: sep=; or sep=, This will override system setting ("list separator character";) and Excel will open the file correctly.

Most users will not know or want to do this, making CSV files useless for US customers.
Responses (2)


There are %s replies to this question. If you want to see them you need a valid subscription.
If you have a valid subscription, please login now.
Visit store now

Last questions

Link to maps.google.de in default.php
Hi, i have a question about the default.php under hotspot. i want to integrate...
0 Replies
Posted on Sunday, 19 May 2024
  • New
  • Veranstaltung im Frontend sichtbar obwohl nicht ve
    Hallo, folgendes Problem stellt sich mir: Wenn ich eine Veranstaltung dupl...
    4 Replies
    Posted on Friday, 09 February 2024
    Suche bei der Matukio - Fehler Ö Ä Ü..
    Hallo, evtl. könnt ihr mir weiterhelfen. Bei mir funktioniert die suche bei ...
    3 Replies
    Posted on Wednesday, 15 May 2024
  • New
  • When is CComment compatible with Joomla 5?
    When is CComment compatible with Joomla 5?...
    4 Replies
    Posted on Tuesday, 05 December 2023
    • #CComment
    • #Joomla 5
    _MATUKIO_NO_EVENTS appears in the frontend if no e
    Hello, there ist still the problem, that on the frontpage appears COM_MATUKIO...
    2 Replies
    Posted on Sunday, 12 May 2024
  • New