Hello,

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.

Let us know if that helps.

Hello,

no problem at all, i am happy to help.

Let us know if you encounter any issues when you try this , we will do our best to help if needed as quickly as possible.

Thank you.

Hi Mike,

i am happy to hear that you successfully cloned the wpDataTables instance, great to hear that!

I can see what you mean, yes - right now we have those issues that can happen,

i will pass this feedback to our developers, they will do their best to improve this.

-

And also in regards to making a possible plugin that could serve to copy the files of the wpDataTables,

we will also pass this as a suggestion for our developers.

Thank you for this feedback once again,

and please don't hesitate to open new tickets if anything else comes up, we will be happy to advise.