Import Formatting Guide for Importing Users

Browse by Topic

Platform Benefits
- Ecommerce
- Ecommerce
- Search Engine Optimization (SEO)
- Search Engine Optimization (SEO)
Platform Benefits
- Ecommerce
- Ecommerce
- Search Engine Optimization (SEO)
- Search Engine Optimization (SEO)
Ecommerce Integrations
- Bigcommerce
- Bigcommerce
- Shopify
- Shopify
- Volusion
- Volusion
- Woocommerce
- Woocommerce
Ecommerce Integrations
- Bigcommerce
- Bigcommerce
- Shopify
- Shopify
- Volusion
- Volusion
- Woocommerce
- Woocommerce
Sales Support
Sales Support
Feature Requests
Feature Requests
Public Q&A System
- Answering Questions
- Answering Questions
- Asking Questions
- Asking Questions
- Keyword Searches
- Keyword Searches
- Point System and Structure
- Point System and Structure
- Registration and Login
- Registration and Login
- Other
- Other
Public Q&A System
- Answering Questions
- Answering Questions
- Asking Questions
- Asking Questions
- Keyword Searches
- Keyword Searches
- Point System and Structure
- Point System and Structure
- Registration and Login
- Registration and Login
- Other
- Other
System Administration
- Category Management
- Category Management
- Content Management
- Content Management
- Customization
- Customization
- Integrating Your Site
- Integrating Your Site
- Moderation
- Moderation
- Reports
- Reports
- Third Party Login
- Third Party Login
- User Management
- User Management
- Other
- Other
System Administration
- Category Management
- Category Management
- Content Management
- Content Management
- Customization
- Customization
- Integrating Your Site
- Integrating Your Site
- Moderation
- Moderation
- Reports
- Reports
- Third Party Login
- Third Party Login
- User Management
- User Management
- Other
- Other
Billing and Payments
Billing and Payments
Report a Bug
Report a Bug
Frequently Used
Frequently Used
Other
Other

Column	Data	Data Type	Required	Character Limit	Special Instructions
Column 1	Account Email	Plain Text	Yes	50	Provide the email that will be used as the account email which the user will use to login to the system as well as receive system email notifications. This email will never be displayed publicly, and will only be manageable through the administration area or by the user.
Column 2	Password	Plain Text	Yes*	20	Provide the password that will be associated with this users account and the user will use to login. Note that as soon as you import this password, it will be encrypted as to ensure security. * Passwords are not required if you have Single Sign-On Authentication Enabled
Column 3	Username	Plain Text	Yes	50	Provide the username that the user will be referenced as on the system. This username will be displayed publicly on the user’s public profile.
Column 4	Display Name	Plan Text	No	50	Provide the display name that the user will be referenced as on the system. This display name will be displayed publicly throughout the system to link to the user’s public profile, as well as on all questions, answers, or comments that are associated with the user. If this field is left empty, the user’s display name will be the same as his username.
Column 5	First Name	Plain Text	No	50	Provide the First Name of the user. This name will not be displayed publicly.
Column 6	Last Name	Plain Text	No	50	Provide the Last Name of the user. This name will not be displayed publicly.
Column 7	About Me	Plain Text	No	1000	Provide the About Me text of the user, which is a brief description of the user and what their interests are. This information will be displayed publicly on the user’s public profile page.
Column 8	Website	Plain Text	No	1000	Provide the website URL of the user, which will be displayed publicly on the user’s public profile page. The format of this URL can be www.userwebsite.xyz or userwebsite.xyz. Adding the “http://” is not necessary.
Column 9	Twitter URL	Plain Text	No	50	Provide the Twitter URL of the user, which will be displayed publicly on the user’s public profile page. You should just provide the Twitter extension. For example, if a user’s twitter URL is “www.twitter.com/bob” then you would only put “bob” in this field.
Column 10	Region	Plain Text	No	100	Provide the region of the user, which will be displayed publicly on the user’s public profile page. This can represent the region, state, or city that the user lives in.
Column 11	Country	Plain Text	No	100	Provide the country of the user, which will be displayed publicly on the user’s public profile page. This country needs to match exactly one of the countries that are available in the Answerbase dropdown. See the end of this documentation for a full list of countries and the appropriate representation of their name.
Column 12	Contact Email	Plain Text	No	50	Provide the contact email of the user, which will be displayed publicly on the user’s public profile page. This needs to be in a proper email format, including the @ sign and URL at the end. Please note that this is a PUBLIC email and will be displayed publicly, not to be confused with the user’s account email listed earlier in this documentation.
Column 13	Home Phone	Plain Text	No	20	Provide the home phone of the user, which will be displayed publicly on the user’s public profile page.
Column 14	Office Phone	Plain Text	No	20	Provide the office phone of the user, which will be displayed publicly on the user’s public profile page.
Column 15	Mobile Phone	Plain Text	No	20	Provide the mobile phone of the user, which will be displayed publicly on the user’s public profile page.
Column 16	Fax Number	Plain Text	No	20	Provide the fax number of the user, which will be displayed publicly on the user’s public profile page.
Column 17	Company	Plain Text	No	50	Provide a company or organization name for your user, which will be displayed publicly on the user’s public profile page.
Column 18	User Profile Image Url	Plain Text	No	150	If you are using Single Sign On and your users manage their profile images elsewhere, you can add the url to that image so it will be displayed along with the user’s details on the Answerbase site.
Column 19	Unique ID	Plain Text	No	250	If you are using Single Sign On you need to provide a Unique ID that will be used internally to identify and associate the user every time he/she logs in.