This thread is resolved. Here is a description of the problem and solution.
Problem: I have two custom post types in a one-to-many post relationship. Province is the parent (one) and District is the child (many). I would like to generate an export CSV that includes each District title and its parent Province title.
Solution: Go to wp-admin > All Export > New Export. The first step is to choose a specific post type, and choose District as that post type. Then click "customize export file" to move on to the next step. Usually ID, Title and Content are already in place in the builder. You can drag the ID and Content blocks out of the box since you don't want to include those items.
Next click "Add Field" below the builder area to add a new custom column for the Province Title. Choose the option to select a field to export, and select the ID field. You may need to reset the column name information after choosing the ID field. Check the checkbox to export a value from a PHP function, type prov_parent_title in the function name field, and paste this function in the function editor to define the custom prov_parent_title function:
[php]Relevant Documentation:
https://toolset.com/forums/topic/export-custom-post-type-data-and-related-repeatable-field-group-data/
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 |
|---|---|---|---|---|---|---|
| 8:00 – 12:00 | 8:00 – 12:00 | 8:00 – 12:00 | 8:00 – 12:00 | 8:00 – 12:00 | - | - |
| 13:00 – 17:00 | 13:00 – 17:00 | 13:00 – 17:00 | 13:00 – 17:00 | 13:00 – 17:00 | - | - |
Supporter timezone: America/New_York (GMT-04:00)
This topic contains 4 replies, has 2 voices.
Last updated by 3 years, 5 months ago.
Assisted by: Christian Cox.
Okay just to be clear, usually post titles alone are not enough to enable importing these posts in another site. Normally you need unique identifiers like post IDs or GUIDs. If you're exporting for a different purpose, then obviously whatever information you want to include is fine. For something simple like this you could probably use Views to generate this information, then copy + paste it into a simple text file and save that with a .csv extension. A View is usually the simplest practical approach when there is a relatively small amount of data to include, and that data can be easily output by Views using its dynamic content features. Otherwise you need to use custom PHP functions in the Export builder to fetch information from related posts.
If you want to use the exporter plugin, you'll go to wp-admin > All Export > New Export. The first step is to choose a specific post type, and choose District as that post type. Then click "customize export file" to move on to the next step. Usually ID, Title and Content are already in place in the builder. You can drag the ID and Content blocks out of the box since you don't want to include those items.
Next click "Add Field" below the builder area to add a new custom column for the Province Title. Choose the option to select a field to export, and select the ID field. You may need to reset the column name information after choosing the ID field. Check the checkbox to export a value from a PHP function, type prov_parent_title in the function name field, and paste this function in the function editor to define the custom prov_parent_title function:
<?php
function prov_parent_title($id)
{
$parent_id = toolset_get_related_post( $id, 'relationship-slug', 'parent');
$prov_title = get_the_title($parent_id);
return $prov_title;
}
?>
Replace relationship-slug in this code with the slug of your Province-District post relationship. See the screenshot here for an example.
That's pretty much all you need to configure in the builder. Continue with the remaining default configurations and generate your export. Let me know if you have questions about this.
