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
- 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”.
- Create a dummy post to understand the structure and schema of the table. For instance, input a name and location.
- Check your MySQL database. You should see a new table, “wp_jet_cct_leads”, which is created whenever a CCT is made.
- Export a single record from this table to understand its structure.
- 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.
- 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”.
- Add a “status” column to your data and set it to “publish”.
- Copy the data and paste it into a tool like Mr. Data Converter to convert it into MySQL format.
- Modify the table name to match your CCT table name in the database.
- Replace the quoted “NOW()” and “NULL” strings with their unquoted versions, as they are functions and not strings.
- Copy the modified data and execute it as an SQL command in your database.
- Check your CCT leads in your WordPress dashboard. You should see all the new data entries.
- 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.