Hi Gentlemen, the topic I am referring to , but I have not found a satisfactory answer. I need to migrate tables (or the whole addon) from the old webserver to the new one . However I need to migrate only wpdatatable addon - not the whole site. Or at least separate tables that are but from a JSON endpoint. I don't need their content but the settings of each of them (conditional formatting, column settings, visibility etc.) Is there any way to achieve this ?
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
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.
But i realise you said that this is not convenient, since you do not want to move the entire site, but just our plugin settings for tables.
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
That would move all the options+settings as well.
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 sources 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.
-
I hope this helps, let us know if you have any questions.
Hi Gentlemen, the topic I am referring to , but I have not found a satisfactory answer. I need to migrate tables (or the whole addon) from the old webserver to the new one . However I need to migrate only wpdatatable addon - not the whole site. Or at least separate tables that are but from a JSON endpoint. I don't need their content but the settings of each of them (conditional formatting, column settings, visibility etc.) Is there any way to achieve this ?
Hi, Martin.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
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.
But i realise you said that this is not convenient, since you do not want to move the entire site, but just our plugin settings for tables.
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:
That would move all the options+settings as well.
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 sources 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.
-
I hope this helps, let us know if you have any 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