I'd upload a .xlsx file with a date column, in my native file the date is "19/05/1934" but when file is upload, the table on my website display "01/01/1970".
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
Yes, we currently have this bug, for dates, if you use .xlsx extention.
Here is the screenshot from my end, when i load your data
For example, the first row says 01/01/1970
But if i save your file as any other Excel extension, like .xls, now it works.
Our developers isolated the bug, and they'll add it to their queue for fixing.
They will do their best to build a fix as soon as possible.
We don't have an ETA on when the fix will be available, but please keep a lookout on our wpDataTables changeLog.
It will be stated there during updates which bug fixes have been implemented at each update.
For the time being, if you can please avoid only the .xlsx format, you can use .ods or .xls ,
and it should work OK,
as long as you match the right Date Format in main Plugin settings,
and in the column date settings - in this case it should be as m/d/Y.
Hello,
Sorry for my bad english, i'm french...
I'd upload a .xlsx file with a date column, in my native file the date is "19/05/1934" but when file is upload, the table on my website display "01/01/1970".
The plugin have a "minimum" date ?
Attachment : the native .xlsx file if you want to compare with this link (https://prbr-famille.fr/etat-civil-bourthes-62/)
Thanks a lot.
Antoine Pruvot
Attached files: rel_bourthes.xlsx
Hi Antoine,
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
Yes, we currently have this bug, for dates, if you use .xlsx extention.
Here is the screenshot from my end, when i load your data
For example, the first row says 01/01/1970
But if i save your file as any other Excel extension, like .xls, now it works.
Our developers isolated the bug, and they'll add it to their queue for fixing.
They will do their best to build a fix as soon as possible.
We don't have an ETA on when the fix will be available, but please keep a lookout on our wpDataTables changeLog.
It will be stated there during updates which bug fixes have been implemented at each update.
For the time being, if you can please avoid only the .xlsx format, you can use .ods or .xls ,
and it should work OK,
as long as you match the right Date Format in main Plugin settings,
and in the column date settings - in this case it should be as m/d/Y.
Let me know if you have any questions.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables