Appreciation Engine

Open navigation

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.




Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.