Hey everyone!
With the holiday season upon us, we want to share our upcoming working hours:
- New Year: Our team will be off on January 1st and 2nd. We’ll be back on Friday, January 3rd, to respond to any messages received during this time.
- Weekend: As usual, we don’t work on weekends, so January 4th and 5th will also be non-working days.
- Orthodox Christmas: Our office will be closed on Monday and Tuesday, January 6th and 7th for the holiday.
After that, we’ll return to our regular schedule and assist you as quickly as possible.
In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.
Thanks a bunch for your understanding and support!
Warm regards and happy holidays!
TMS
I've tried with both a CSV and XLS file, but I keep getting Internal Server Error. Host has checked the error logs and found nothing. They suggested contacting you, as they claim it is an issue with the plugin.
Hi Ed
Thank you for reaching out to us.
This usually happens if the source file is not formatted correctly.
Please note that there are some limitations when using Google spreadsheets to create tables in wpDataTables. Formatting applied in the original file (font families, color, size, fill color, etc.) will not be copied over to the wpDataTable, but you can make whatever adjustment you may need in WpDataTables.
Please refrain from using any special formatting in the source file as the plugin may not be able to read the data properly and may result with an error.
Also please provide us with some screenshots or a screen recording of the issue and the source file used to create the table so we can try and recreate the issue.
Hi Blaženka,
Thank you for your reply... since I've tried both XLS and CSV formatted files and still get the same error, I'm thinking that it's not a formatting issue; CSV file is pretty much just text, no?
Thank you,
Ed
Hi Ed
Also please provide us with some screenshots or a screen recording of the issue and the source file used to create the table so we can try and recreate the issue.
Hi Blazenka,
I've attached a screen recording -- please let me know if I'm doing this correctly. Hope this helps.
Thanks,
Ed
Oh, and the xls file
Thanks,
Ed
Hi Ed
This is how the file looks like when we try to open it, there are no headers in the table, the data is all scrambled and there seems to be some custom formatting applied which should be removed.
Please have a look at the example document and reformat your table accordingly
https://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-excel/
Wow... that is a mess. I'll need to look into fixing it. Since I didn't create it, perhaps I can revise or reformat and try again. Thanks for your help!
You are most welcome
If there is anything else we can assist you with please don't hesitate to open a new ticket.
Have a wonderful day!
Hi Blazenka,
Thank you for your insight about my XLS file. I've reformatted it and am now getting a different error:
Bad gateway
What do you suppose that means?
Thanks!
Ed
Hi Ed,
thank you for contacting back
A 502 Bad Gateway Error is a general indicator that there's something wrong with a website's server communication. Since it's just a generic error, it doesn't actually tell you the website's exact issue.
You would need to reach out to your server hosting to check with them where did the communication stop / was blocked.