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.

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)

Supported Date formats are listed below:

MM/DD/YYYY

DD/MM/YYYY

Month Date Year

MM-DD-YYYY

DD-MM-YYYY

MM.DD.YYYY

DD.MM.YYYY

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 2.11.4 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 version 2.11.4 which includes the compatible for relationship field.

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. As for now, JetEngine supports only 9 field types for relations. 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.

export-jet-engine-data-using-csv-importer-plugin

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.

jetengine-cct-file-upload-csv-importer

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.

jetengine-cct-fields-mapping-csv-importer

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.

select-jetengine-cct-to-export

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.

 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.