April 11, 2023

Bulk Import Data into JetEngine CCT (Custom Content Types)

Play Video

How do I import CCT into JetEngine?

Bulk import data into JetEngine CCT (Custom Content Types) is the focus of this tutorial by Moxet Khan. We’ll explore how to manually import multiple data entries into JetEngine CCT, a feature currently not provided by Crocoblock. This process is particularly useful when you have simple data to be stored in tables.

Steps to Bulk Import Data into JetEngine CCT

  1. Navigate to the Custom Content Type section in your WordPress dashboard. For this tutorial, we’re using a type called “leads” with two fields: “customer_name” and “location”.
  2. Create a dummy post to understand the structure and schema of the table. For instance, input a name and location.
  3. Check your MySQL database. You should see a new table, “wp_jet_cct_leads”, which is created whenever a CCT is made.
  4. Export a single record from this table to understand its structure.
  5. Add more records to your exported file. Remember to adjust the “cct_author_id” field to “1” for admin and increment the ID for each new record.
  6. To avoid having a fixed date, use the MySQL “NOW()” in the “cct_created” column, a function that will insert the current timestamp in the database. For the “cct_modified” field, use “NULL”.
  7. Add a “status” column to your data and set it to “publish”.
  8. Copy the data and paste it into a tool like Mr. Data Converter to convert it into MySQL format.
  9. Modify the table name to match your CCT table name in the database.
  10. Replace the quoted “NOW()” and “NULL” strings with their unquoted versions, as they are functions and not strings.
  11. Copy the modified data and execute it as an SQL command in your database.
  12. Check your CCT leads in your WordPress dashboard. You should see all the new data entries.
  13. Test the data insertion and updation by modifying a field in one of the entries.

Benefits of the Tutorial

This tutorial provides a workaround for bulk importing data into JetEngine CCTs, a feature not currently available. It streamlines the process of adding multiple entries, saving you time and effort. Moreover, it gives you a better understanding of how CCT works and how it interacts with your MySQL database.

Use Cases for Bulk Importing Data into JetEngine CCT

  • Importing a large number of customer leads into your WordPress site.
  • Migrating data from another platform into your WordPress CCT.
  • Regularly updating your CCT with new data from external sources.

Troubleshooting Common Issues

While the process of bulk importing data into Crocoblock’s Custom Content Type (CCT) is straightforward, you may encounter some issues along the way. Here are some common problems and their solutions:

Issue 1: Data Doesn’t Import Correctly

If your data doesn’t import correctly, it could be due to a formatting issue in your CSV file. Make sure that your data is correctly formatted and matches the structure of your CCT. Check for any missing or extra columns, incorrect data types, or improperly formatted dates.

Issue 2: SQL Command Errors

Errors in your SQL command can prevent your data from being imported. If you’re seeing SQL errors, double-check your command for any syntax errors. Make sure that your table name is correct and that you’re using the correct functions for the “NOW()” and “NULL” fields. If you’re still having trouble, consider using a tool like Mr. Data Converter to ensure your data is correctly formatted for MySQL.

Issue 3: Data Not Showing Up in WordPress

If your data imports successfully but doesn’t show up in your WordPress dashboard, it could be a caching issue. Try clearing your WordPress cache and refreshing your dashboard. If the data still doesn’t appear, check your CCT configuration to make sure it’s set to display the correct fields.

Issue 4: Permission Issues

If you’re having trouble accessing your MySQL database or executing SQL commands, it could be a permissions issue. Make sure that your user account has the necessary permissions to access the database and modify the CCT table.

Remember, when troubleshooting, it’s important to make changes one at a time and test after each change. This will help you identify exactly what’s causing the issue and avoid introducing new problems. If you’re still having trouble after trying these solutions, consider reaching out to Crocoblock’s support for assistance.

Required Resources

JetEngine Logo
Payment required
Credit to Moxet Khan
Moxet Khan is a YouTuber who specializes in solving complex WordPress scenarios with simple logic. He provides tutorials and walkthroughs on how to resolve various WordPress issues and challenges, such as fixing common errors, troubleshooting plugin conflicts, optimizing website performance, and more.
Bulk Import Data into JetEngine CCT (Custom Content Types)
Welcome back!
Enter your Helwp credentials to sign in.

No Account yet? Sign Up

My Account
Give Feedback
Describe your feedback *
Rate Helwp
Problem *
Describe the problem
Want us to reply?
Your E-Mail
Affiliate Disclosure

At Helwp, we’re committed to transparency and honesty. Therefore, we want to inform you that some of the links on our website are affiliate links. This means that, at no additional cost to you, we may earn a small commission if you click through and make a purchase.

We only promote products or services that we genuinely believe in. These affiliate commissions help us to maintain the website and continue to provide you with free, high-quality WordPress content.

If you are interested in how you can support us even further, check out our support page.