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!
Hello,
I would like to display tables (and graphs) date data that are timestamped in Unix using the Epoch format.
I am consuming them using JSON.
What is the approach to displaying my data in both tabular and graph mode in human readable format, (with the format conversion taking place in wpDatatable and not in the source) ?
Here is the original JSON:
http://api.metadataoxford.com/metrics/custom_my_summary_count
For your information:
https://www.epochconverter.com/
Last but not least. In the example JSON I provided we cannot consume it because it contains "introductory information" i.e.
{"series":[{"name":"Gmail:2345","values":Are there any plans so that we can remove this information and to be able to consume them? I think this work is not unrelated to the work that you are doing for graphs when giving the option to chose the x/y axes in the charts.
Hello again Dimitris
The epoch time format cannot be recognized by wpDataTables, so it needs to arrive into wpDataTables already in a human-readable format. With SQL query-based tables, you can convert the format through the query itself, so it arrives as the format you defined in wpDataTables settings, but with JSON I don't know if this can be achieved.
I forwarded the ticket to one of our developers for review, and as soon as I hear from him, I will let you know.
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 again Dimitris.
There are hooks for filtering every type of column, so this one would probably be a string, where you could create logic in the hook, to convert it to what you need it to be. You can check them out in our filters and hooks.
For formatting the JSON itself, you would need to create a PHP adapter, and then create a table linked to a serialized PHP Array, where the given data from the API would be converted to serialized array format for wpDataTables.
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