We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
This was a private ticket but nobody was answering me. I am using a temporary solution by having to update each table manually when I cache it. It's a terrible temporary solution.
_____
I am using Google Sheets to feed my wpDataTables and I'm getting these errors: Auto update error message: Data array from source and cache do not have same keys(columns).
I know for a fact that the columns aren't changing in the tables and I've verified that the columns are correct in each table. I'm not sure why I'm getting this error.
What information do you need?
Here's a link to one my Google Sheets: https://docs.google.com/spreadsheets/d/1v9_2cDaQ39BS3ZoLc-x6afoQHQiZkQK-ic18xJG73lg/edit?gid=1192460929#gid=1192460929
https://docs.google.com/spreadsheets/d/1v9_2cDaQ39BS3ZoLc-x6afoQHQiZkQK-ic18xJG73lg/edit?usp=sharing
In an effort to figure it out, I manually set each column to FLOAT type from Int type. That didn't work. One more thing is that my data frequently has zero values in the columns. However, it's stupid if that's the reason why my tables aren't caching from Google Sheets. I don't want the values to be imported as strings because the data is being used to generate charts. Here's where the 7 day chart data gets used, as an example.
https://houstonpollen.com/common-allergens/
Error still persists after updating to 7.01.
Note that it's always different tables on different refreshes.
table_id updated_time log_errors
7 11/14/2024 10:53 AM 2024-11-14 11:30:30 - Auto update error message: Data array from source and cache do not have same keys(columns).
8 11/14/2024 10:53 AM 2024-11-14 11:30:31 - Auto update error message: Data array from source and cache do not have same keys(columns).
16 11/14/2024 04:56 PM
19 11/14/2024 04:57 PM
20 11/14/2024 05:00 PM
21 11/14/2024 05:01 PM
24 11/14/2024 10:53 AM
25 11/14/2024 10:53 AM
27 11/14/2024 10:53 AM 2024-11-14 11:30:32 - Auto update error message: Data array from source and cache do not have same keys(columns).
29 11/14/2024 10:53 AM 2024-11-14 11:30:33 - Auto update error message: Data array from source and cache do not have same keys(columns).
30 11/14/2024 10:53 AM 2024-11-14 11:30:34 - Auto update error message: Data array from source and cache do not have same keys(columns).
31 11/14/2024 10:53 AM
Using Table7 as an example:There's no reason why the column keys should be erroring out.
, here's my Table7 data from WPDataTables.
And my Table7 data from GoogleSheets (source)
This bug has persisted since I wrote this. Any update?
Why would you close this ticket without responding at all?