User Import Table Format

This article lists the expected format for user import CSVs as used in the process described in the Importing Users From Another Service article.

Supported Columns

Only the columns below are supported. Use these exact strings for the columns headings. 

• socialservice 
• source  (optional)
• lastname  (optional)
• firstname 
• sourceuid 
• email 
• dob 
• gender  (optional)
• phone  (optional)
• address (optional)
• zipcode  (optional)
• town  (optional)
• stateregion  (optional)
• country  (optional)
• appid 
• appsecret 
• authtoken 
• authsecret 
• uid 
• username 
• verified 
• domain 

For more information about the accepted values for each column, reference each sub-topic below.

socialservice

Expects a number.

The social service that was used to give the social permissions:

• 1  – Facebook
• 2  – Google+
• 3  – Twitter
• 4   – Spotify
• 5   – Deezer
• 6   – Email
• 8   – Instagram
• 9   – Google
• 10   – Tumblr

Additional codes can be added at your request. However, this may require additional development work.

source (optional)

Expects a string.

The service that was used by the user to create the account. May be as specific or broad as required.

Example: Janrain.

lastname (optional)

Expects a string.

firstname

Expects a string.

Use any valid display name for the user. Note that this field is required.

sourceuid

Expects a unique string.

This is the unique ID user for this member, used in the system from which you are importing.

email

Expects an email address.

The email address acquiring during the user's registration.

dob

Expects a date in the format DD/MM/YYYY.

The user's date of birth. This field requires a DD/MM/YYYY date format.

gender (optional)

Expects a string.

phone (optional)

Expects a string.

address (optional)

Expects a string.

zipcode (optional)

Expects a string.

town (optional)

Expects a string.

stateregion (optional)

Expects a string.

country (optional)

Expects a ISO 3166-1 Code Alpha-2.

The user's country code. You can see a list of all of the ISO 3166-1 alpha-2 codes at Nations Online.

appid

Expects a string.

The associated app ID for your social application. For example, your Facebook App secret key or your Twitter consumer key.

appsecret

Expects a string.

The associated app secret key for your social application. For example, your Facebook App ID or your Twitter consumer secret key.

authtoken

Expects a number.

Expects a number that corresponds with the service that the authorization token is from.

• 1  – Facebook
• 2  – Google+
• 3  – Twitter
• 4   – Spotify
• 5   – Deezer
• 6   – Email
• 8   – Instagram
• 9   – Google
• 10   – Tumblr

authsecret

Expects a string.

This field is required for proper tracking of a oauth1.0.a service. (Twitter.)

uid

Expects a string.

The unique ID of the user from the associated social network. The format of this string varies depending on the service. For example, a Twitter user ID looks like 93573247.

username

Expects a string.

The user's username from the social network.

verified domain

Expects a string.

The domain that you want this registration linked to. Do not include the http:// protocol in this field. For example, site.com or www.site.com.