Hi, Lohen

Thanks for reaching out to us.

 Once you create a table from a JSON file, if you update it with new data, 

you should not change the source file’s structure, so changes like these are not recommended:

• Renaming columns,
• Reordering columns,
• Deleting existing columns,
• Adding new columns.

If you make any of the above changes, the wpDataTable will break. If you make any of these changes, you will need to recreate the table again.

-

The documentation on the page you pointed out is the page where we covered everything we have on JSON with wpDataTables.

Let me know if i may be misunderstood the question, or if you have any other questions. Thank you.

Just wanted to point out that we have a sandbox/Demo site (https://sandbox.wpdatatables.com/), that you can use to try out some of the plugin's features;

and there is a 15-day money-back guarantee period,
so if you purchase the plugin, you can safely fully test it out,
we will assist along the way,
and if it doesn't fit your needs you can request and receive a refund in that period.

Hi, Lohen

Thank you for the explanation, now i can understand it better.

-

You are correct about this :

JSON source doesn't update a table saved in database. You fetch data from JSON file in server-side (vs ajax) each page request, then print-out it on the page to use it with the chart.

- We have to point out that the JSON file can not be imported in the database. That is why our documentation covers everything in that regard about JSON files.

JSON can be used only if a wpDataTable is linked to the file.

In that case, if you change the JSON then the wpDataTable will change with it.

We don't have a working solution to update a database table using any JSON file.

It can maybe be done with a custom solution, but we have never done something like that, and we are not sure how and if it is possible.

- Usually, if users need to reach out to someone to check if a custom solution is possible, we can only recommend teams such as WP Kraken, they do quality custom work, but we can't advise on their pricing.

-

Regarding connection to separate databases,  

yes, we have Multiple DB engine connections support (MySQL, MS SQL, Postgre SQL).

  More details on this page, if you'd like to check it out.

-

Regarding the Apex chart callbacks,

we currently don't have any ready documentation on Apex charts callbacks, the developers are working on finishing it as soon as possible.

They gave us an example on how we can change the colors of the * slices of an Apex pie chart:

[wpdatachart id=487]
<script type="text/javascript">
jQuery(window).on('load',function(){ if( typeof wpDataChartsCallbacks == 'undefined' ){ wpDataChartsCallbacks = {}; } wpDataChartsCallbacks[487] = function(obj){ obj.options.colors = ['#2E93fA', '#66DA26', '#546E7A', '#E91E63', '#FF9800', '#FFF800','#FFF','#000']; }
});
</script>

The colors are in hexadecimal format.

Please note that using hooks or wpDataTable and wpDataChart callbacks requires a certain level of programming skills and included support refers only to advice.