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.
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
If you have a valid subscription, please login now.
Visit store now
Last questions
Hi,
i have a question about the default.php under hotspot.
i want to integrate...
0 Replies
Posted on Sunday, 19 May 2024
Hallo,
folgendes Problem stellt sich mir:
Wenn ich eine Veranstaltung dupl...
4 Replies
Posted on Friday, 09 February 2024
Hallo,
evtl. könnt ihr mir weiterhelfen. Bei mir funktioniert die suche bei ...
3 Replies
Posted on Wednesday, 15 May 2024
When is CComment compatible with Joomla 5?...
4 Replies
Posted on Tuesday, 05 December 2023
- #CComment
- #Joomla 5
Hello,
there ist still the problem, that on the frontpage appears COM_MATUKIO...
2 Replies
Posted on Sunday, 12 May 2024