0

Knowledge Base

Jet Engine Data Import

WP Ultimate CSV Importer lets you import JetEngine plugin field content in your WordPress site (Jet Engine Import). 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
PostsPagesCustom Posts
LocationRecurring EventsUsers
WooCommerce AttributesWooCommerce CategoriesWooCommerce Tags
WP eCommerceWooCommerceTaxonomies
CategoriesCustom ReviewsTags
EventeShopMarketPress

JetEngine MetaBox

PostsPagesCustom Posts
LocationRecurring EventsUsers
WooCommerce AttributesWooCommerce CategoriesWooCommerce Tags
WP eCommerceWooCommerceTaxonomies
CategoriesCustom ReviewsTags
EventeShopMarketPress

JetEngine Relations

PostsPagesCustom Posts
LocationRecurring EventsUsers
WooCommerce AttributesWooCommerce CategoriesWooCommerce Tags
WP eCommerceWooCommerceTaxonomies
CategoriesCustom ReviewsTags
EventeShopMarketPress

JetEngine Taxonomy

PostsPagesCustom Posts
LocationRecurring EventsUsers
WooCommerce AttributesWooCommerce CategoriesWooCommerce Tags
WP eCommerceWooCommerceTaxonomies
CategoriesCustom ReviewsTags
EventeShopMarketPress

JetEngine CCT

PostsPagesCustom PostsJet Engine CPT
LocationRecurring EventsUsersMarketPress
WooCommerce AttributesWooCommerce CategoriesWooCommerce TagseShop
WP eCommerceWooCommerceTaxonomiesEvent
CategoriesCustom ReviewsTags 

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

Jet Engine fieldsDescriptionCSV Sample Value
TextAdd your single line text.WP Ultimate CSV Importer
DateMention the date value (YYYY/MM/DD) Here2020-12-04
TimeSpecify the time (HH:MM)03:33 19:19
Date TimeSpecify the Date and time (YYYY/MM/DDTHH:MM)2020-12-05T03:29
Text AreaAdd your text with multiple lines.WP Ultimate CSV Importer lets you import, update and export jet engine content on your WordPress website.
WYSIWYGAny type of text value is supported.WP Ultimate CSV Importer * Import/ Update * Instant/ Scheduled import
SwitcherUse the value true to turn on and to turn off the value, specify the value false.true false
CheckboxSpecify the values for the checkbox. If you want to enable multiple checkboxes values use the comma separator.one,two,three
IconpickerProvide the text value of the iconfa-music
MediaSpecify the WordPress media url or any publicly accessible external URL.https://cdn.smackcoders.com/wp-content/uploads/2023/11/software-developments-services.webp
GallerySpecify the WordPress media image url of any publicly accessible external url. Multiple image URLs are separated with comma separators.https://cdn.smackcoders.com/wp-content/uploads/2023/11/software-developments-services.webp
RadioMention the radio button value to be selected.Male Female
SelectProvide the values that are to be selected in the select field. To select multiple values, specify values with a comma separator.One,two,three Green,Blue,Yellow
NumberSpecify the number value here.12
ColorpickerMention the color code in Hexa value.#0000ff #e5e5e5
PostMention 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

CSV Import for Jet Engine supports the repeater field type. To add a repeater field value in your CSV file, include the values with the 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 the publish date. Then mention the values in the 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 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 a single parent post.

Ex: 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.

Ex: 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.

Ex: 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 user relations. Also, inside the relation, you can create meta fields that can be assigned to parent or child relations 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 field’s headers and values. One is to specify the relation post and the others are relation meta fields.

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

RelationDescriptionSample CSV value
jet_related_postMention the child relation post id here.124

The above is applied to one-to-one relations. Sometimes, 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 the pipeline separator like below:

jet_related_postMention 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
            TextEnter any text values for this field in your CSVtext here
           DateProvide date value in this format(YYYY/MM/DD)2020/04/23
           TimeProvide time in this format (HH:MM)19:04
          DatetimeEnter datetime value in this format(YYYY/MM/DDTHH:MM)2022-03-04T11:18
         TextareaEnter texts in multiple lines.CSV Importer is compatible with JetEngine.You can import and export data easily.
           CheckboxInput the checkbox values to select.For example:The checkbox has below options to select.GreenOrangeBlueblue, green
            MediaSpecify media image url or id here.148
            RadioSpecify a radio button value to be selected.For example: you have options like yes and no. You need to choose one value.yes
            SelectProvide values for the select fields to be selected. If you enabled multiple select values, then specify values with a comma separator.Eg:OneTwoThreeone, 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
                   TextTo include text values for multiple child posts, give values in a comma separator.Text value for child post1, Text value for child post2, Text value for child post3
                   DateProvide date field values for multiple child posts in comma separators.2020/04/23, 2020/03/25, 2019/11/29
                   TimeProvide time field values for multiple child posts.19:04, 16:24, 09:19
                DatetimeSpecify datetime field values for multiple child posts.2022-03-04T11:18, 2020-02-03T17:21, 2022-03-25T07:17
               TextareaInput 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
               CheckboxSeparate multiple posts checkbox values with pipelines.blue, green|red, yellow|green, red
                MediaSpecify URLs or IDs for multiple media image fields.148, 321, 134
                 RadioSpecify a radio button value for multiple posts separated with pipelines.     yes|no|yes
                 SelectProvide 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 the 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 the ‘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 the JetEngine plugin.

Exporting the Jet Engine Content

To export the JetEngine 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 taxonomy values, select ‘Taxonomies’ then choose the taxonomies to value you created with the 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 help make your website faster and also keep your website convenient for 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 learn how to import and update CCT CSV/XML to WordPress, and how to export Custom Content Types data of JetEngine plugin from WordPress using the WP Ultimate CSV Importer plugin. If you want to learn more about CCT please refer to official JetEngine documentation.

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. Continue to the next step.
map jetengine cct fields csv importer
  • 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, and select Custom Posts. Here choose your JetEngine custom content type from the dropdown. Provide the filename to be exported, and select the file type.

select jetengine cct to

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 (JetEngine or Jet Data 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

FAQ (Frequently Asked Questions)

How do I export my JetEngine listing?

To export your JetEngine listing, you typically need to use the built-in export functionality provided by the JetEngine plugin. Here are the step-by-step instructions on how to do it:

  1. Access your WordPress Dashboard: Log in to your WordPress website where JetEngine is installed.
  2. Navigate to JetEngine Listings: Look for the “JetEngine” menu item in the WordPress dashboard. Hover over it, and then click on “Listings”.
  3. Select the Listing to Export: Choose the listing you want to export from the list of available listings.
  4. Export the Listing: Look for an option to export the listing. This could be in various formats such as CSV, XML, JSON, etc. The exact method may vary depending on the version of JetEngine you’re using and any additional plugins or extensions you have installed.
  5. Follow Prompts: Once you select the export option, follow any on-screen prompts or instructions to complete the export process.
  6. Download the Exported File: After the export process is complete, you’ll typically be given a link to download the exported file. Click on this link to download the file to your local computer.
  7. Verify the Exported File: Before you proceed, it’s a good idea to verify that the exported file contains all the data you need. You can open it using a text editor or spreadsheet software to ensure that the data is intact.
  8. Save the Exported File: Save the exported file to a safe location on your computer for future reference or for importing into another system if needed.

Remember, the exact steps may vary slightly depending on the version of JetEngine you’re using and any customizations you’ve made to your WordPress website. 

How do I import taxonomy into WordPress?

To import taxonomy into WordPress, you typically have a few options depending on the complexity of your taxonomy structure and your technical expertise:

  1. Manual Entry: If you have a small number of taxonomy terms, you can manually enter them using the WordPress dashboard. Simply navigate to the “Posts” or “Custom Post Types” section, click on “Categories” or “Tags” (depending on the taxonomy you want to add), and then click on “Add New” to create individual terms.
  2. CSV Import: If you have a large number of taxonomy terms or want to import them from an external source, then install the WP Ultimate CSV Importer Pro plugin that supports importing taxonomy terms from CSV files. These plugins allow you to map CSV columns to taxonomy fields and import terms in bulk.
  3. Custom Script: For more advanced users, you can write a custom script using WordPress functions like wp_insert_term() to programmatically import taxonomy terms from an external source. This method requires some coding knowledge but provides more flexibility and control over the import process.

How do I export a WordPress listing?

To export a WordPress listing, you can follow these steps:

  1. Navigate to the Listings Section: Log in to your WordPress dashboard, and go to the section where your listings are managed. This could be a custom post type or managed by a specific plugin like JetEngine or another directory plugin.
  2. Select the Listings to Export: Choose the listings you want to export. You may have options to filter or select specific listings based on categories, tags, or other criteria.
  3. Export Listings: Look for an export option within your listings management interface. Depending on the plugin or method you’re using, this could be a built-in export feature or a third-party plugin that allows you to export listings to a CSV, XML, or JSON file format.
  4. Choose Export Format: Select the desired file format for your export. CSV is commonly used for exporting data that can be opened in spreadsheet applications like Excel. At the same time, XML and JSON are more suitable for structured data that may be imported into other systems or websites.
  5. Confirm and Export: Follow any on-screen prompts or instructions to confirm the export process. Once confirmed, the plugin or tool will generate the export file containing your listing data.
  6. Download Exported File: After the export process is complete, you’ll typically be provided with a download link or option to save the exported file to your computer.

How do I export taxonomy from WordPress?

You can export taxonomy from WordPress using plugins or custom scripts. 

Taxonomy Export Using Plugins: . Install and activate the WP CSV  importer pro plugin. Navigate to its settings, and select the taxonomies you want to export.  Provide the file name and the file format. You can also export the file using an advanced filter. Then, initiate the export process to generate the export file.

WP Ultimate CSV Importer Pro

WP Ultimate CSV Importer Pro

Get Ultimate CSV/XML Importer to import data on WordPress faster, quicker and safer.