Common problems with imports and how to solve them
Thousands of different files and pieces of data are uploaded to Plytix all the time. We've seen a lot of spreadsheets come through, so we've also noticed that there are common problems and errors when it comes to importing into our system. In this article, we will highlight some of the most common errors we encounter and how to fix them.
*Skip to any section in this article by clicking on the links above
Corrupted File or Funky Characters
This means that something is off within the spreadsheet and it may not be visually apparent to you (sometimes they are literally invisible). This usually happens with text fields.
If this happens, it is likely that when you import your CSV and see this screen:
This means our importer tried to read the file and failed. Sometimes this can be fixed by changing the Charset and the other file settings, but sometimes not. If your case is the latter try to do this:
Solution 1: Re-Export
- Import your spreadsheet into another system like Google Sheets.*
- Download your CSV in CSV format.
- Try to upload again to our system.
⚠️ *Don't use Excel for this. It is notorious for corrupting files with formulas and formatting styles.
Usually this works because these systems are simply better at reading and cleaning up all kinds of corrupted files. We just haven't been around as long.
Also, this will tell you if your CSV is corrupted beyond repair. If those systems can't read it, then it is likely something else is going on.
Solution 2: Remove Rich Text or long text fields
This is mostly just to test and identify which columns are the ones messing up your import.
- Remove long text fields.
- Try to import again.
- If successful, review the text fields you removed for any characters or formatting issues that may have thrown things off.
Solution 3: Re-Export in UTF-8
The most common and standard Charset is UTF-8.
For this reason it is probably the safest bet in terms of reading/parsing the majority of characters. Try to re-export your CSV using UTF-8 and import again.
Wrong File Settings
If you see the screen above, and you believe your data is not corrupted, check the file settings.
Make sure your Charset has been properly matched. Our system tries to guess this the best it can, but there are times when it doesn't guess right. You can also check your delimiters and separators by checking the properties of your CSV file.
Solution: Reconfigure File Settings
- In the file preview, it will give you options for delimiters and character sets, change these to the settings of your CSV file
- The correct file settings will show you a preview with data split correctly among columns
⚠️ Sometimes the preview may appear correct for some attributes, but not all. Please check your actual file settings to ensure you are importing data correctly.
If your import was successful, but some information didn't appear in your account, check your Import Logs.
Learn more about Import Logs here.
ℹ️ If you can't figure it out, reach out. Make sure to send over the CSV you are struggling with and we will see what we can do.
- Learn about Import Logs to view more information about your imports
- Learn how to set up your CSV for import
- Learn how to use Import Profiles to match faster
If you have any questions just click on the chat box in the bottom-right corner and we'll be happy to answer them...
and please let us know 👇