Holiday Notice – Support Unavailable on April 18 and April 21

We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!

In the meantime, if you need any help, feel free to:

Amelia YouTube Channel

wpDataTables YouTube Channel

Thank you for your understanding, and we wish you a wonderful holiday weekend!

Okay
  Public Ticket #3750941
Exporting / importing tables for subdomain
Closed

Comments

  • Dave Hafer started the conversation

    Is there a way to export a table and all of its settings I've created on one domain so that I can import it onto a subdomain on my same site?

  •  1,894
    Miloš replied

    Hi Dave,

    A sub-domain will be regarded as another Site, so you would need to do the same 'process' as if you were moving the Plugin data like tables/charts, etc from Site A to Site B.

    Here are more details :

    When you are moving the Plugin's data from one Site to another, 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.

    I hope that helps.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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