Index

  1. Home
  2. Docs
  3. Index
  4. Data Explorer
  5. Export and import

Export and import

Data Explorer main page

On this level an SQL export file cotains a create table statement for every exported table and an insert into statement for every exported row.

Export table(s)

To export multiple tables at ones, select the desired tables, select Export Table from the Bulk Actions dropdown list and click Apply. This feature supports export to SQL1) only.

To export a single table, click on the Manage link for the desired table and click on the Export button on the Actions tab. This feature supports export to SQL1), XML, JSON, Excel and CSV.

Import table(s)

Click the Import data/Execute script(s) button at the top of the screen. Select the file you want to import and click Import file/Execute script(s).

Data Explorer table page

Use these features to export/import a selected number of rows from a specific table. The export file includes an insert into statement for every exported row. 2) It does not contain a create table statement.

Export table data

Use the search box to find the rows you want to export. If not all rows you want to export are visible, click on Screen Options (upper right corner of the page) and change Number of items per page accordingly. Select the rows you want to export. Select Export from the Bulk Actions dropdown list and click Apply. This feature supports export to SQL1), XML, JSON, Excel and CSV.

Import table data

Click the Import button on top of the screen. Select the file you to import and click Import File.

 

NOTES

  1. Export to SQL offers support for seemless export and import between WordPress databases that use different prefixes. The WordPress table prefix is replaced during export by variable {wp_prefix}, which is replaced by the WordPress table prefix on import. If you want to use another tool for import, disable checkbox “Export with variable WP prefix” in Back-End Settings on the Manage Plugin page. With “Export with variable WP prefix” disabled full table names will be written to the export file. (read more…)
  2. The import feature on a Data Explorer table page only supports the import of data into the table displayed on the page. Any other statement than an insert into the table on the page will be rejected. Use the import feature of the Data Explorer main page to import any valid import file.
Was this article helpful to you? Yes No

6 Replies to “Export and import”

  1. sir
    in every tutorial or post the data base is bitnomi_wordpress but the plugin i cant see such database in my case. is it making any issue in future or not… what shuould i select , mysql , information schema or the other one

    1. Hi Idrees,

      The bitnami_wordpress database in the video tutorials is the database where the WordPress tables are installed. You can safely select your own WordPress database.

      Sorry for not mentioning this in the tutorials! I should have explained this. Thank you for your feedback!

      Best regards,
      Peter

  2. Hi Peter,

    Is there any way to implement on a WordPress page a button to allow visitors to export table data?

    Thanks.

    Best regards.
    Javier.

    1. Hi Javier,

      There are two ways to do this:
      (1) Create a Data Project for your table and add your table to a web page with shortcode wpdadiehard. An export button will be added automatically. If your table should be read only, set the project page type to view.
      (2) Create a publication and add default or custom export buttons. This is only available with the premium version. This is documented here: https://wpdataaccess.com/docs/documentation/data-publisher/adding-buttons-premium/

      Does this help?

      Best regards,
      Peter

      1. I’m using the premium version actually. I didn’t realize I can use this feature. It works fine! Sorry for the inconvenience.

        But I have two questions now, with respect to the premium buttons feature:
        – An empty column is autogenerated at first position (using flat tables). When the table is exported, this column appears on files. Could I avoid this?
        – This way only allows to export the rows showed at the moment. It is any way to export the entire database or, if it’s not possible, any way to add an extra view of, for example, 1000 rows?

        Thanks Peter. I really appreciate the help.

        Best regards.
        Javier.

        1. Hi Javier,

          >>> An empty column is autogenerated at first position (using flat tables). When the table is exported, this column appears on files.

          Sounds like a bug. Can I see this somewhere? Doe you have a URL I can visit? I think the plugin needs to handle this.

          >>> This way only allows to export the rows showed at the moment. It is any way to export the entire database or, if it’s not possible, any way to add an extra view of, for example, 1000 rows?

          The default buttons do not support this , but you can add custom buttons. This is documented here:
          https://wpdataaccess.com/docs/documentation/data-publisher/custom-buttons-premium/

          Here is an example of code executed from a custom button:
          https://code-manager.com/code/?wpda_search_column_code_name=Code-Manager-Export

          Or use the Code Manager:
          https://code-manager.com/blog/docs/index/shortcodes/javascript-shortcodes/

          Let me know if you need help!

          Best regards,
          Peter

Leave a Reply

Your email address will not be published. Required fields are marked *

8 − seven =