Jet Engine Data Import

 

WP Ultimate CSV Importer lets you import Jet engine plugin fields content in your WordPress site. You can import, update, schedule, and export Jet engine’s Custom Post Types data, Custom Taxonomies, and Custom Meta Boxes data.

Supported Modules

JetEngine CPT

Posts	Pages	Custom Posts
Location	Recurring Events	Users
WooCommerce Attributes	WooCommerce Categories	WooCommerce Tags
WP eCommerce	WooCommerce	Taxonomies
Categories	Custom Reviews	Tags
Event	eShop	MarketPress

JetEngine MetaBox

Posts	Pages	Custom Posts
Location	Recurring Events	Users
WooCommerce Attributes	WooCommerce Categories	WooCommerce Tags
WP eCommerce	WooCommerce	Taxonomies
Categories	Custom Reviews	Tags
Event	eShop	MarketPress

JetEngine Relations

Posts	Pages	Custom Posts
Location	Recurring Events	Users
WooCommerce Attributes	WooCommerce Categories	WooCommerce Tags
WP eCommerce	WooCommerce	Taxonomies
Categories	Custom Reviews	Tags
Event	eShop	MarketPress

JetEngine Taxonomy

Posts	Pages	Custom Posts
Location	Recurring Events	Users
WooCommerce Attributes	WooCommerce Categories	WooCommerce Tags
WP eCommerce	WooCommerce	Taxonomies
Categories	Custom Reviews	Tags
Event	eShop	MarketPress

JetEngine CCT

Posts	Pages	Custom Posts	Jet Engine CPT
Location	Recurring Events	Users	MarketPress
WooCommerce Attributes	WooCommerce Categories	WooCommerce Tags	eShop
WP eCommerce	WooCommerce	Taxonomies	Event
Categories	Custom Reviews	Tags

 

Refer the below table as sample to add values in your CSV file:

Jet Engine fields	Description	CSV Sample Value
Text	Add your single line text.	WP Ultimate CSV Importer
Date	Mention the date value (YYYY/MM/DD) Here	2020-12-04
Time	Specify the time (HH:MM)	03:33 19:19
Date Time	Specify the Date and time (YYYY/MM/DDTHH:MM)	2020-12-05T03:29
Text Area	Add your text with multiple lines.	WP Ultimate CSV Importer lets you import, update and export jet engine content on your WordPress website.
WYSIWYG	Any type of text value is supported.	WP Ultimate CSV Importer * Import/ Update * Instant/ Scheduled import
Switcher	Use the value true to turn on and to turn off the value, specify the value false.	true false
Checkbox	Specify the values for the checkbox. If you want to enable multiple checkboxes values use the comma separator.	one,two,three
Iconpicker	Provide the text value of the icon	fa-music
Media	Specify the WordPress media url or any publicly accessible external URL.	https://cdn.smackcoders.com/wp-content/uploads/2018/08/mobile_app_development_home_page.png
Gallery	Specify the WordPress media image url of any publicly accessible external url. Multiple image urls are separated with comma separator.	https://cdn.smackcoders.com/wp-content/uploads/2018/08/mobile_app_development_home_page.png,https://cdn.smackcoders.com/wp-content/uploads/2018/08/application_integration_home_page.png
Radio	Mention the radio button value to be selected.	Male Female
Select	Provide the values that are to be selected in the select field. To select multiple values, specify values with comma separator.	One,two,three Green,Blue,Yellow
Number	Specify the number value here.	12
Colorpicker	Mention the color code in Hexa value.	#0000ff #e5e5e5
Post	Mention the pages or posts name/ID. To add multiple values, use the comma separator.	Custompost1 Post1,Post2,Page1

CSV Values for Jet Engine Repeater Field

To add a repeater field value in your CSV file, include the values with pipeline (|) separator. Consider we have two repeater fields (Author name) text, and (Post Publish date)date. You can add two additional columns in your CSV, one for the Author name and the other for Post Publish date. Then mention the values in pipeline separator like below:

Author name – Jack|Harry|Clara

Post Publish date – 2020-12-04|2020-12-31|2021-01-02

JetEngine Post Relations

Post Relations in JetEngine lets you build connections between post types. It is categorized in three ways: one-to-one, one-to-many, and many-to-many. For importing Post relations with WP Ultimate CSV Importer, add two more columns in your CSV file along with your existing post content.

1. Slug – To get the Post Relation slug from JetEngine and add it to your CSV.

2. Post Relation – Mention the ‘Post ID’ or ‘Post Title’ of the child post that you want to relate to the parent post.

One-to-one relation

One-to-one relation is used when you want to relate a single child post to the single parent post.

Eg: Bus(B1,B2,B3) and Driver(D1, D2, D3) – Each Bus will have unique Drivers and Each Driver only can drive one bus.

• Post Title(B2) – Any required information
• Slug – bus-and-drivers
• Post Relation – D2

One-to-many Relations

This is used to relate one post type to many posts in another post type. 

Eg: Sport(Football,Cricket) and Player(Lionel Messi, Cristiano Ronaldo, Neymar, Dhoni, Virat Kohli, Sachin Tendulkar). Each sport has many players but no one player can be in two sports.

• Post Title(Football) – Your necessary info
• Slug – sport-players
• Post relation – LionelMessi,CristianoRonaldo,Neymar

Many-to-many Relations

Many-to-many relation is typically used to relate many custom post types to many different post types.

Eg: Sportshoes(Nike, Puma, Adidas) and Color(White,Green,Red) – Each Brand shoes will be in multiple colors and each color can be available in multiple shoe brands.

• Post Title(Adidas) – Your necessary info
• Slug- shoe-color
• Post relation – White,Green,Red

JetEngine New Relations Import

JetEngine refactored the relationship field from scratch. It now supports custom post types, custom content types, taxonomy, and users relations. And also, inside the relation, you can create meta fields that can be assigned to parent or child relation or both. We have upgraded our CSV Importer plugin to support the latest JetEngine Relations.

As the different post relation types aforementioned, here we can see how to prepare CSV to import JetEngine relations into the website.

Add extra fields inside CSV

To import relations, you need to include additional fields in your CSV along with the existing fields headers and values.

One to specify the relation post and the others are relation meta fields.

Add the field ‘jet_related_post’ and give child post id as value to relate the child post with the parent post.

Relation	Description	Sample CSV value
jet_related_post	Mention the child relation post id here.	124

 

The above is applied for one-to-one relation.

In some cases, you may have to relate multiple child posts with a parent post. Then this relation must be a ‘one-to-many’, or ‘many-to-many’ relation. For that, mention ids in pipeline separator like below:

jet_related_post

Mention the multiple child post ids with pipeline separator.

124|212|347

 

In relations, as previously mentioned you can create meta fields for each related post. If you want to add values to the meta fields created for the relations, specify the field headers and include appropriate values inside the CSV. JetEngine supports 9 field types for the Relations. The field types are text, date, time, datetime, textarea, checkbox, media, radio, and select.

Follow the below values format to include values for the meta fields in your CSV file.

Meta Fields	Description	Sample CSV Values
Text	Enter any text values for this field in your CSV	text here
Date	Provide date value in this format(YYYY/MM/DD)	2020/04/23
Time	Provide time in this format (HH:MM)	19:04
Datetime	Enter datetime value in this format(YYYY/MM/DDTHH:MM)	2022-03-04T11:18
Textarea	Enter texts in multiple lines.	CSV Importer is compatible with JetEngine. You can import and export data easily.
Checkbox	Input the checkbox values to select. For example: The checkbox has below options to select. Green Orange Blue	blue, green
Media	Specify media image url or id here.	148
Radio	Specify a radio button value to be selected. For example: you have options like yes and no. You need to choose one value.	yes
Select	Provide values for the select fields to be selected. If you enabled multiple select values, then specify values with a comma separator.  Eg: One Two Three	one, two

 

The above table shows the meta fields values format of a single child post. If you want to relate multiple child posts, follow the below table.

Meta Fields	Description	Sample CSV Values
Text	To include text values for multiple child posts, give values in comma separator.	Text value for child post1, Text value for child post2, Text value for child post3
Date	Provide date field values for multiple child posts in comma separators.	2020/04/23, 2020/03/25, 2019/11/29
Time	Provide time field values for multiple child posts.	19:04, 16:24, 09:19
Datetime	Specify datetime field values for multiple child posts.	2022-03-04T11:18, 2020-02-03T17:21, 2022-03-25T07:17
Textarea	Input multiple line text values for many child posts here.	CSV Importer is compatible with JetEngine. You can import and export data easily., textarea values for child post2, textarea values for child post3
Checkbox	Separate multiple posts checkbox values with pipelines.	blue, green|red, yellow|green, red
Media	Specify urls or id for multiple media image fields.	148, 321, 134
Radio	Specify a radio button value for multiple posts separated with pipelines.	yes|no|yes
Select	Provide select field values for many child posts separated with pipelines separator.	one, two|two, three|three, one

 

Prepare your CSV with jet_related_post, and meta fields. Next upload and import CSV with CSV Importer plugin.

Refer to this Import documentation of CSV Importer and import your CSV file.

Export JetEngine Relations

Exporting JetEngine relations data is similar to other data exports.

Choose the module you want to export. If you want to export Custom Post Types or Custom Content Types select ‘Custom Posts’ option in the export page and choose the CCT or CPT name from the dropdown. Continue to move forward to export.

Give a name for the export file name field and choose one file type. To know how to use advanced filters and export, refer to our export documentation. Click ‘Export’ to instantly export your data. Now download the exported file.

The exported file has post relations data and relations meta fields data along with other fields data. You can see the meta fields and post relation field headers have relation id.

Import of Terms field Information

WP Ultimate CSV Importer lets you add custom categories with default field information in JetEngine plugin.

Exporting the Jet Engine Content

To export the Jet engine field values, navigate to CSV Importer then move on to the Export tab. Select the module by clicking on the radio button. If you want to export the Custom Posts values, click ‘Custom Posts’ and select the custom post from the dropdown. If you want to export custom taxonomies values, select ‘Taxonomies’ then choose the taxonomies value you created with Jet engine plugin. After choosing the module, move on to do further by clicking the ‘Continue’ button. Then continue doing the same steps you do for exporting. Once your export is done, you can download it on your local desktop.

Update Jet engine fields data

Initially make modifications to your CSV file. Upload the new modified CSV file. Choose Existing items options as you’re updating the existing Jet engine field content and select the post type/taxonomy type from the ‘Import each record as’ dropdown. Click continue and map the fields. Enable the Featured media handling section if you want to import any external images. In the import section, Click on the “Import’ button to replace the old Jet engine field data with the new data in your WordPress website.

Custom Content Types data Import Export

JetEngine Custom Content Types helps make your website faster and also keeps your website convenient for the users. With WP Ultimate CSV/XML Importer you can import and export Custom Content Types of JetEngine easily into and from your WordPress website. Below you will know how to import and update CCT CSV/XML to WordPress, and how to export Custom Content Types data of JetEngine plugin from WordPress using WP Ultimate CSV Importer plugin.

Once you manually create a Custom Content Type and fields inside JetEngine, the next step is to add or import values into it.

Import/Update JetEngine Custom Content Types

Once you prepare your CSV/XML file, navigate to your WordPress dashboard and locate the Ultimate CSV Importer Pro plugin. Check the table above to know how to mention values for CCT fields in your CSV file.

Upload your CSV/XML file in any of the preferred locations, then select ‘New items’ to import new CCT data otherwise select ‘Existing items’ to update existing CCT data.

Next, choose the JetEngine Custom Content Type you have created from the dropdown menu. Click Continue. Start mapping the CSV Headers with WP fields and save the mapping with a name in ‘Save this mapping as’. Make sure to map JetEngine CCT fields.

Continue to the next step. Configure media handling to import/update external images into WordPress. Read this documentation to know more about media handling. On the next page click the ‘Import’ button to import new CCT content in your WordPress.

For updating old content, Enable the ‘Do you want to handle the duplicate on existing records?’ option and select id. Then click the ‘Update’ button to update your old CCT data.

Export JetEngine Custom Content Types data

Exporting your Custom Content Types data from your WordPress website is similar to other data exporting with WP Ultimate CSV Importer. Move to the ‘export’ tab, select Custom Posts. Here choose your JetEngine custom content type from the dropdown.

Provide the filename to be exported, and select the file type. You can use advanced filters to filter and export the data. Refer to this documentation to know more about exporting data with WP Ultimate CSV Importer. Click the export button to export the data and download the files on the local desktop. You can also schedule your export, refer to this link to know how to schedule your data export.