Sansan

About Import Status / Rules to Create Card Import Files

About Import Status

After import is confirmed, status will change according to the processed stage.
Details of each status are given below:

Status Description
Waiting for Process to Start After the import is confirmed, this is the status before the actual import process starts.
Depending on the server, this status may continue for a while.
Importing This is the status of the actual data import.
The amount of time required for the import process to begin will vary according to the amount of data you are trying to process and the data processing situation of other users.
Import Complete Import has completed.
An email will be sent to the users who performed the business card data import function to notify them that the process has been completed.
There are Errors. When import completed, this shows there are data that failed to import due to errors.
Information such as the number of failed import data will be sent in the completion notification Email.
Error data can be downloaded from the ""error data"" list.

 

 

About Files to Import

CSV files will be used to import files
The first line will be used as item name. Please enter data starting from the second line.

Maximum Data:

10,000 lines per import

Rules to Import Available Items and Data Input

Items Required Entry Characters Available to Use Word Count Description
Card Holder User ID Alphabets, Numbers, Symbols - This is the user ID for Sansan.
Specify which user the imported data will belong to.
Exchanged Date   Numbers, Some Symbols (/-) - This is the date cards were exchanged.
Please use date format.
Example: 2010/01/01, 2010-01-01
Tags   - Max. 50 characters Specify Tag to be attached to imported card.
To attach multiple tags, separate tag names by semi-colon.
Company Name - Max. 250 characters Specify company name.
If company name is left blank, "(None)" will be imported as company.
Company Name (English)   Alphabets, Numbers, Symbols Max. 250 characters Use when the company name can be read in English.
Company Name (Kana)   Kana, Alphabets, Numbers, Symbols Max. 250 characters Search Kana, use in sort function of list view.
Entry is recommended for your convenience.
Department Name   - Max. 250 characters Specify department name.
Title   - Max. 250 characters Specify title.
Name [Last] - Max. 250 characters Specify last name of individual.
If last name is blank, "(None)" will be imported as last name.
Name [First]   - Max. 250 characters Specify first name of individual.
Name (Kana) [Last]   Kana, Alphabets, Numbers, Symbols Max. 250 characters Specify Kana for last name.
Search Kana, use in sort function of list view.
Entry is recommended for your convenience.
Name (Kana) [First]   Kana, Alphabets, Numbers, Symbols Max. 250 characters Specify Kana for first name.
Search Kana, use in sort function of list view.
Entry is recommended for your convenience.
Zip Code(1)   Numbers, Some Symbols (-) Max. 7 characters, not including hyphens. Specify Zip Code.
These will be registered without hyphens.
Address(1) [All]   - Max. 1,000 characters Specify address.
Address will be automatically separated and saved in 3 parts: 1)Prefecture 2) City 3) Town/Number/Building.
* Foreign addresses will not be automatically separated.
TEL-1(1)   Numbers, Some Symbols (+-().) Max. 30 characters Specify phone number.
Symbols such as parentheses and periods will be automatically converted to hyphens and saved.
Example: 0120.1111.2222 -> 0120-1111-2222
* Words such as (Main) and (Extension) will not be saved.
* Hyphens and periods can be registered except at the beginning or the end of an entry.
* Parentheses can only be registered if they are used in pairs.
* Plus marks (+) can only be registered at the beginning of entries.
TEL-2(1)   Numbers, Some Symbols (+-().) Max. 30 characters Specify phone number.
Symbols such as parentheses and periods will be automatically converted to hyphens and saved.
Example: 0120.1111.2222 -> 0120-1111-2222
* Words such as (Main) and (Extension) will not be saved.
* Hyphens and periods can be registered except at the beginning or the end of an entry.
* Parentheses can only be registered if they are used in pairs.
* Plus marks (+) can only be registered at the beginning of entries.
FAX(1)   Numbers, Some Symbols (+-().) Max. 30 characters Specify FAX number.
Symbols such as parentheses and periods will be automatically converted to hyphens and saved.
Example: 0120.1111.2222 -> 0120-1111-2222
* Words such as (Main) and (Extension) will not be saved.
* Hyphens and periods can be registered except at the beginning or the end of an entry.
* Parentheses can only be registered if they are used in pairs.
* Plus marks (+) can only be registered at the beginning of entries.
Mobile(1)   Numbers, Some Symbols (+-().) Max. 30 characters Specify mobile number.
Symbols such as parentheses and periods will be automatically converted to hyphens and saved.
Example: 090.1111.2222 -> 090-1111-2222
* Words such as (Main) and (Extension) will not be saved.
* Hyphens and periods can be registered except at the beginning or the end of an entry.
* Parentheses can only be registered if they are used in pairs.
* Plus marks (+) can only be registered at the beginning of entries.
Email(1)   Alphabets, Numbers, Symbols Max. 250 characters Specify Email address.
Use Email address format.
URL(1)   Alphabets, Numbers, Symbols Max. 250 characters Specify URL.
Only URLs starting in http://, https:// or ftp:// can be registered.
Zip Code(2)   Numbers, Some Symbols (-) Max. 7 characters, not including hyphens. Specify Zip Code.
These will be registered without hyphens.
Address(2) [All]   - Max. 1000 characters Specify address.
Address will be automatically separated and saved in 3 parts: 1)Prefecture 2) City 3) Town/Number/Building.
* Foreign addresses will not be automatically separated.
TEL-1(2)   Numbers, Some Symbols (+-().) Max. 30 characters Specify phone number.
Symbols such as parentheses and periods will be automatically converted to hyphens and saved.
Example: 0120.1111.2222 -> 0120-1111-2222
* Words such as (Main) and (Extension) will not be saved.
* Hyphens and periods can be registered except at the beginning or the end of an entry.
* Parentheses can only be registered if they are used in pairs.
* Plus marks (+) can only be registered at the beginning of entries.
TEL-2(2)   Numbers, Some Symbols (+-().) Max. 30 characters Specify phone number.
Symbols such as parentheses and periods will be automatically converted to hyphens and saved.
Example: 0120.1111.2222 -> 0120-1111-2222
* Words such as (Main) and (Extension) will not be saved.
* Hyphens and periods can be registered except at the beginning or the end of an entry.
* Parentheses can only be registered if they are used in pairs.
* Plus marks (+) can only be registered at the beginning of entries.
FAX(2)   Numbers, Some Symbols (+-().) Max. 30 characters Specify FAX number.
Symbols such as parentheses and periods will be automatically converted to hyphens and saved.
Example: 0120.1111.2222 -> 0120-1111-2222
* Words such as (Main) and (Extension) will not be saved.
* Hyphens and periods can be registered except at the beginning or the end of an entry.
* Parentheses can only be registered if they are used in pairs.
* Plus marks (+) can only be registered at the beginning of entries.
Mobile(2)   Numbers, Some Symbols (+-().) Max. 30 characters Specify mobile number.
Symbols such as parentheses and periods will be automatically converted to hyphens and saved.
Example: 090.1111.2222 -> 090-1111-2222
* Words such as (Main) and (Extension) will not be saved.
* Hyphens and periods can be registered except at the beginning or the end of an entry.
* Parentheses can only be registered if they are used in pairs.
* Plus marks (+) can only be registered at the beginning of entries.
Email(2)   Alphabets, Numbers, Symbols Max. 250 characters Specify Email address.
Use Email address format.
URL(2)   Alphabets, Numbers, Symbols Max. 250 characters Specify URL.
Only URLs starting in http://, https:// or ftp:// can be registered.
Memo   - Max. 2,000 characters Insert memo.