I'm trying to upload an excel file that haves multiple time and date cells, wean I upload to wpdatatable only one time and one date cells shows but not the rest.
I looked at your file, and the issue is the same on my end as well. After inspection I found that the date columns were set as "text" not date:
There's something wrong in the file, definitely (maybe the character set), because even the first date column is wrong:
When I use the table with similar entries, only in English, it works fine, so I'm betting the character set (UTF-16) needs to be changed. Try UTF-8 and see if it makes any difference.
I modified the file, and I believe I got it working. There are a couple of issues in your original file. There was a column without the header and without the content, so I deleted it. Then, you had multiple columns entitled "Date" and "Time", so I changed them to "Date1", "Time1", and so on.
When you're importing the file, just make sure to go through the columns setting and apply "Date" and "Time" to every column. I did that and it looks just fine on my end.
I'm trying to upload an excel file that haves multiple time and date cells, wean I upload to wpdatatable only one time and one date cells shows but not the rest.
Hi Arturas.
If that file doesn't contain any sensitive information, could you please send it to us, so we can test it locally?
You can attach it here, just make sure to enable the "Private" reply slider, so no one else sees it but us.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Hi Arturas.
I looked at your file, and the issue is the same on my end as well. After inspection I found that the date columns were set as "text" not date:
There's something wrong in the file, definitely (maybe the character set), because even the first date column is wrong:
When I use the table with similar entries, only in English, it works fine, so I'm betting the character set (UTF-16) needs to be changed. Try UTF-8 and see if it makes any difference.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
No UTF-8 dindint help there still the same problem
Hello again Arturas.
I modified the file, and I believe I got it working. There are a couple of issues in your original file. There was a column without the header and without the content, so I deleted it. Then, you had multiple columns entitled "Date" and "Time", so I changed them to "Date1", "Time1", and so on.
When you're importing the file, just make sure to go through the columns setting and apply "Date" and "Time" to every column. I did that and it looks just fine on my end.
I hope this helps.
Best regards
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Hello Aleksandr.
This works with my original file and all date shows up.
Thank you.
Best regard Arturas
You're welcome Arturas
Glad I could help.
If you have any more issues or questions feel free to open a new ticket, we will gladly help.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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