Hi there, we are about to purchase the plugin because it meets all our requirements. We have several envs for one site and we need to know if it is posible to export all datatables with its configurations to be imported in another site with wpDataTables pluging installed. Or maybe it is posible to have all datatables configurations exported to code (As Advanced Custom Fields plugin for example).
At this time, the only two ways to move all the Plugin tables/charts data along with their settings/options/styles etc, can be two ways : Either to migrate the entire Site+database with a tool like 'duplicator', or to manually only copy our Plugin tables to the other Site database.
We will go in more details for each method :
When you are moving on live site from local or stage site (or vice-versa) we can suggest using Plugin Duplicator. We use it and it's working fine because it will transfer all the files and also the tables to the database.
Other than cloning the site, another option would be to copy all database tables (wp_wpdatatable_#) along with tables wp_wpdatatables, wp_wpdatacharts, wp_wpdatatables_rows and wp_wpdatatables_columns. Then, in wp_options table, you would also need to export the following option_names:
wdtPreventDeletingTables
wdtUseSeparateCon
wdtSeparateCon
wdtTimepickerRange
wdtTimeFormat
wdtTabletWidth
wdtTablesPerPage
wdtSumFunctionsLabel
wdtRenderFilter
wdtRenderCharts
wdtIncludeBootstrap
wdtIncludeBootstrapBackEnd
wdtPreventDeletingTables
wdtParseShortcodes
wdtNumbersAlign
wdtBorderRemoval
wdtBorderRemovalHeader
wdtNumberFormat
wdtMobileWidth
wdtMinifiedJs
wdtMinFunctionsLabel
wdtMaxFunctionsLabel
wdtLeftOffset
wdtTopOffset
wdtInterfaceLanguage
wdtGeneratedTablesCount
wdtFontColorSettings
wdtDecimalPlaces
wdtCSVDelimiter
wdtDateFormat
wdtCustomJs
wdtCustomCss
wdtBaseSkin
wdtAvgFunctionsLabel
wdtInstallDate
wdtRatingDiv
wdtMDNewsDiv
wdtTempFutureDate
It is rather cumbersome to do all this, but unfortunately at the moment, it's the only way.
Important to note, for tables linked to an existing data source, you would need to change the file path, because at the moment the file path depends on the domain, so if you change the domain, the URL to the file will also have to be changed.
Our developers will be working on adding an easier solution to export everything, but we can't say an ETA on this.
- There are also certain export functionalities, to export individual tables using Table Tools.
- If you also need to switch domains;
In our store you can go to "My Licenses" and click on the "Manage Domains" button:
From there, you will be able to deactivate the old domain (while it's still active), and then simply activate the new domain in wpDataTables settings/Activation, once you move the site.
And i just wanted to point out that you can try wpDataTables before purchasing
on our sandbox Demo sites ( you can find links for the main plugin Demo,
as well as add-on Demos, in my signature),
and there is a 15-day money-back guarantee period,
so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)
Thanks for your answer. Unfortunately the flexibility of creating datatables and reports its limited by the fact you are no able to export and import your configuration. It should be an easy task. Just a json to import/export. Because we have staging and production envs. The current solution of copying manually the tables is not a very easy task to do frecuently.
I see what you mean and we completely understand that our users need an easy solution to export only the Plugin data without having to clone the entire Site. Our developers are actively working to implement this solution - we just can't say an exact ETA when it will be finished.
If you wish to affect the speed of this development -
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
Hi there, we are about to purchase the plugin because it meets all our requirements. We have several envs for one site and we need to know if it is posible to export all datatables with its configurations to be imported in another site with wpDataTables pluging installed. Or maybe it is posible to have all datatables configurations exported to code (As Advanced Custom Fields plugin for example).
Thanks in advance!
Hi Nicolas,
At this time, the only two ways to move all the Plugin tables/charts data along with their settings/options/styles etc, can be two ways : Either to migrate the entire Site+database with a tool like 'duplicator', or to manually only copy our Plugin tables to the other Site database.
We will go in more details for each method :
When you are moving on live site from local or stage site (or vice-versa) we can suggest using Plugin Duplicator. We use it and it's working fine because it will transfer all the files and also the tables to the database.
Other than cloning the site, another option would be to copy all database tables (wp_wpdatatable_#) along with tables wp_wpdatatables, wp_wpdatacharts, wp_wpdatatables_rows and wp_wpdatatables_columns. Then, in wp_options table, you would also need to export the following option_names:
It is rather cumbersome to do all this, but unfortunately at the moment, it's the only way.
Important to note, for tables linked to an existing data source, you would need to change the file path, because at the moment the file path depends on the domain, so if you change the domain, the URL to the file will also have to be changed.
Our developers will be working on adding an easier solution to export everything, but we can't say an ETA on this.
- There are also certain export functionalities, to export individual tables using Table Tools.
- If you also need to switch domains;
In our store you can go to "My Licenses" and click on the "Manage Domains" button:
From there, you will be able to deactivate the old domain (while it's still active), and then simply activate the new domain in wpDataTables settings/Activation, once you move the site.
And i just wanted to point out that you can try wpDataTables before purchasing
on our sandbox Demo sites ( you can find links for the main plugin Demo,
as well as add-on Demos, in my signature),
and there is a 15-day money-back guarantee period,
so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)
Let me know if you have any additional questions.
Kind Regards,
Miloš Jovanović
[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
Thanks for your answer. Unfortunately the flexibility of creating datatables and reports its limited by the fact you are no able to export and import your configuration. It should be an easy task. Just a json to import/export. Because we have staging and production envs. The current solution of copying manually the tables is not a very easy task to do frecuently.
Hope you can add that feature soon
Regards
Hi Nicolas,
I see what you mean and we completely understand that our users need an easy solution to export only the Plugin data without having to clone the entire Site.
Our developers are actively working to implement this solution - we just can't say an exact ETA when it will be finished.
If you wish to affect the speed of this development -
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
Kind Regards,
Miloš Jovanović
[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