Hi,
for problem 1:
You have activated the DataTables JavaScript library for this table, but you also have cells which are “colspanned”. This currently is not supported by the DataTables library and gives this error. You will simply need to uncheck the “Use JavaScript library” checkbox on the table’s “Edit” screen to fix this.
for problem 2:
This sounds as if there is a problem with the character encoding in the file. Are you maybe using “weird” characters in it, like characters from foreign languages, or typographically nice signs?
Can you try again with a very simple CSV file with just a few letters?
Regards,
Tobias
Hi Tobias,
Many thanks as always for the very prompt response.
im trying it out now…let’s see
I seem to have fixed problem 1.
But for problem 2, each time after i import the csv, it disappears.
funny thing is whenever the csv is imported, it shows under table information – description as ‘xxx.csv (application/vnd.ms-excel)’ instead of ‘xxx.csv test.csv (application/csv)’
This only stopped when i saved the excel as csv ms-dos. previously, i was able to import a csv comma seperated value. is there anything wrong here?
Hi,
the mime type should not really matter, as the plugin will only look at the content at text.
Can you try to export and existing (and working) table from WP-Table Reloaded and then try to re-import the downloaded CSV file as a new table? Does that work?
Regards,
Tobias
yes that works! one thing i noticed is, in the past, all the csv tables i imported showed as ‘xxx.csv(application/csv). now for the working table which i exported, renamed as ‘testing’ and reimported, it shows as testing.csv (application/vnd.ms-excel). does it matter?
Hi,
thanks for testing this. Then I assume that there is indeed something wrong with the character encoding of the CSV files that are not working, like characters from a different language, or other “special” characters (that are not directly visible on a keyboard).
The mime type (application/csv or application/vnd.ms-excel) does not matter, it is only shown for information. It probably changed after an update in the server software.
Regards,
Tobias
Alright, thanks once again you’re a life-saver!
Hi,
no problem, you are very welcome!
Best wishes,
Tobias
