As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
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.
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