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) ?
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.
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.
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.
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