Glossary Terms Not updating

When importing a CSV for the purpose of updating existing records, you must include the record ID in the import and also configure the CSV Import to check the record ID and overwrite (update) the record if it finds a match.

When you import the CSV, you will see a status report telling you how many records were imported, how many were added as new records and how many were updated.

If you import without providing the record ID, then the import will create new records, so you should check to make sure you don’t have duplicate records.

After importing, open the “List Participants” page in the WP admin to see if the data was imported correctly.

I have checked and followed the instructions to upload the file again. Still no luck. Just like before, file has been uploaded, but the data importing takes forever. Even after few hours, not a single data was imported. Do you think it is due to words or line limits imposed upon??

Try importing in the foreground. The setting for that is in the Participants Database settings under the Advanced tab.

With the background import, the queue moves along according the the WP cron, but if your site is in development and doesn’t get any traffic, the queue won’t advance. My guess is that this is what is going on.

I got two challenges for foreground importing. Check the images: 

1. Only 25 from 500+ uploaded and imported. 

2. Tibetan language is not correctly shown even for those imported.?

This looks like a problem with the CSV format.

The unicode characters (in this case, Tibetan) you’re not getting is likely due to the CSV not using UTF-8 encoding. You don’t specify how you are creating the CSV, but most spreadsheet applications don’t export CSV files using UTF-8 encoding. You will need to find a setting somewhere in the application you are using to export the CSV to make sure that is happening.

From the feedback message you’re seeing, the file is not getting interpreted correctly, it may be the line delimiter that the the CSV file is using is not recognized by the importer, so it doesn’t get the correct number of lines. Try using a different line delimiter setting on the app that is generating the CSV. A good setting to try is “CR/LF”

If there is an error on importing, the plugin will let you know about that, although if the file is taking too long to import, it will just time out and may not give an error message.

500 records should not be too many, but what is too many also depends on the number of fields and the amount of data in the fields. What happens is if the import takes too long, php times out and stops the import. This is determined by the “maximum execution time” setting in php. Background importing avoids this limitation.