This thread is resolved. Here is a description of the problem and solution.
Problem:
The user would like to manage the data stored in external MySQL tables, create forms, views, and export data.
Solution:
Toolset uses the default database tables to store custom posts types posts and custom taxonomies terms:
- wp_postmeta
- wp_posts
- wp_terms
- wp_termmeta
- wp_term_relationships
- wp_term_taxonomy
https://codex.wordpress.org/Database_Description
Toolset Types is not designed to use custom tables that have custom schemas than WordPress tables.
If you would be using the same WordPress schema but separating custom post types and taxonomies to other tables, you can look at a 3rd party plugin, at your own risk, such as https://github.com/gschoppe/WP-Isolation
Custom post types are stored as posts and they can be exported with any plugin/code that aims to export WordPress content. We have some articles about 3rd party plugins for import/export:
- The Pro version of the WordPress Ultimate CSV Importer plugin
- The CSV Importer plugin
- WP All Import Pro and WP All Import – Toolset Types Add-On plugins
Here:
- https://toolset.com/documentation/user-guides/export-import/how-to-import-content-into-wordpress-using-csv/how-to-import-data-from-a-csv-file-using-the-wp-all-import-toolset-types-add-on-plugin/
- https://toolset.com/documentation/user-guides/export-import/how-to-import-content-into-wordpress-using-csv/
And a technical article on how Toolset stores data and relationships:
- https://toolset.com/documentation/user-guides/export-import/importing-content-from-csv-with-post-relationships/
Relevant Documentation:
- https://toolset.com/documentation/user-guides/export-import/how-to-import-content-into-wordpress-using-csv/how-to-import-data-from-a-csv-file-using-the-wp-all-import-toolset-types-add-on-plugin/
This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.
Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| 9:00 – 13:00 | 9:00 – 13:00 | 9:00 – 13:00 | 9:00 – 13:00 | - | - | 9:00 – 13:00 |
| 14:00 – 18:00 | 14:00 – 18:00 | 14:00 – 18:00 | 14:00 – 18:00 | - | - | 14:00 – 18:00 |
Supporter timezone: Africa/Casablanca (GMT+01:00)
This topic contains 5 replies, has 3 voices.
Last updated by 4 years, 5 months ago.
Assisted by: Jamal.
