Here we will introduce common errors when importing card data.
Errors during import
The following error occurred: "Header's field names do not match the format. Please download the latest format and import again.
You may have changed the item name or used an incorrect format. Download the format again and recreate the file.
This error message can also appear if you use a non-.csv file extension, such as .xlsx. Recreate the file using a .csv extension.
The following error occurred: "File is empty."
Please ensure you haven’t deleted the top row of the template. If you did, please re-download the template and create the file again.
The following error occurred: "Only up to 100,000 cards are allowed per import."
Please ensure that you don’t have more than 100,000 rows in your CSV file.If you want to import more than 100,000 cards, please divide into groups of less than 100,000 and import in batches.
If the above error is displayed even though you have less than 100,000 rows, you may have some cells containing invisible characters. Please re-download the template and create the file again.
The import won’t begin.
It may take a while to start the import depending on the number of other users importing.
Errors after import
If there are any errors in the imported CSV file, ‘Error’ will appear in the status column. You can download the file to check for errors.
For example, you can see that in the second row in the image below that there is an error regarding the User ID.
The following error occurred. "User ID of business card holder: This User ID cannot be used."
Please check the following:
- Is the User ID registered in Sansan?
- Is the "Start Using Date" not a future date?
- Have you entered the User ID, and not the username or email address?
- Are there any unnecessary spaces in the User ID?
- Is the first character of the User ID a 0 (zero)? If not, please make sure it is.
(In Excel, change the format of the “Holder ID” column to text, then save. If you open the CSV file after saving it, the zero will disappear again, so start the import without opening the file).
If you cannot solve the problem by doing the above, please re-download the template and create the file again.
If the characters are garbled, please change the character code of the CSV file.