Sansan

Common errors that happen in Import Card Data, and how to solve them, Part 1

When importing business cards, the import begins after all types of file error checks are complete.

Here we will explain common questions regarding Import Card Data and how to solve problems.

First of all

When checking the file, if an error message comes up on the screen, there is a problem in the file.

Please check "Errors and how to solve them" below, correct the file, and then perform the file check again.

List of error messages

The file selected is not in CSV format.

"Data format does not match. The first row will be used as the item name. Card holder user ID, company, and last name are required fields."

Import data not found.

Up to 10,000 items can be imported at once.

 

Errors and how to solve them

Error #1

The file selected is not in CSV format.

Please select a file that is in CSV format.

Cause 1: The file extension is ".xlsx" (the format for Excel).

Solution 1: Save the data as a ".csv" format file, and then do the file check again.

 

Cause 2: An English version OS is being used.

Cause 2: A format other than Shift JIS for the CSV file (UTF-8 format) may have been used when saving.

Solution 2: Please check if the import can be done after changing the language setting of Sansan to English.

 

Error #2

Data format does not match.

The first row will be used as the item name.

Card holder user ID, company, and last name are required fields.

Cause 3: Did you change the item names to different names?

Solution 3: Please download the format again, and remake the file.

 

Error #3

Import data not found.

Cause 4: Did you delete the top row (where the items names are) of the format?

Solution 4: Please download the format again, and remake the file.

 

Error #4

Up to 10,000 items can be imported at once.

Cause 5: Is the number of rows in the CSV file more than 10,000?

Solution 5: If you would like to do a data import of more than 10,000 items, please divide it into groups of less than 10,000 items each and do the processing one group at a time.

 

Cause 6: If the above error comes up even though you have less than 10,000 rows of data, then there is the possibility that in Excel you have some cells with invisible characters in them.

Solution 6: Please download the format again, and remake the file.