Overview<\/h3>\n\nIn TopTeam<\/i>, you can import user accounts from an Excel <\/i>file using Import Users from Excel<\/i> feature. Following are the methods using which you can import user accounts <\/font>into TopTeam <\/i>repository:
\n1. Download a sample Excel<\/i> file and add user accounts manually to it.<\/font>
\n2. From an existing Excel<\/i> file that you may have exported from active directory, etc.<\/p>\nThis article explains how to import user accounts from Excel<\/i> into TopTeam <\/i>repository.<\/i><\/p>\n<\/div><\/div>\n\nWho should read this?<\/h3>\n\n\n- TopTeam Administrators<\/li>\n<\/ul>\n<\/div><\/div>\n\n
Prerequisites<\/h3>\n\nYou should have System Administrator<\/i> or Manage User Accounts<\/i> permissions for managing user accounts in TopTeam<\/i>.<\/font><\/p>\n<\/div><\/div>\n\nStep 1. Navigate to the Administration page of TopTeam Web<\/h3>\n\n![\"media_1515677809645-1-1-1-1-1-1-1-1-4.png\"](\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\")
\n<\/div>\n<\/p><\/div>\n\nStep 2. Administration page opens, click Manage User Accounts<\/h3>\n\n\n<\/div>\n<\/p><\/div>\n\nStep 3. Click Manage User Accounts<\/h3>\n\n\n<\/div>\n<\/p><\/div>\n\nManage User Accounts page opens with a grid view of all TopTeam users<\/h3>\n\n\n<\/div>\n<\/p><\/div>\n\nStep 4. Select the Import Users from Excel option<\/h3>\n\n\n<\/div>\n<\/p><\/div>\n\nIt is recommended that you must download the sample file to get an understanding about the required format for importing<\/h3>\n\n\n<\/div>\n<\/p><\/div>\n\nSample Excel File<\/h3>\n\n\n<\/div>\n<\/p><\/div>\n\nNOTE:<\/h3>\n\n\n- Excel<\/font><\/i> column header names must match with the user field names in TopTeam<\/i>. The values of only matched columns will be imported into TopTeam<\/i> repository.<\/font><\/li>\n<\/ul>\n
\n- Username<\/font><\/i> column is mandatory for importing user accounts.<\/font><\/li>\n<\/ul>\n
\n- Allowed values for User Type<\/i> are Author<\/i>, Collaborator<\/i> and Viewer<\/i>. If User Type<\/i> column is NOT found, ALL user accounts will be imported as Author<\/i> (internal<\/i>) user accounts.<\/font><\/li>\n<\/ul>\n
\n- Allowed values for Authentication Type<\/i> are Native<\/i>, LDAP <\/i>and External<\/i>. If Authentication Type<\/i> column is NOT found, ALL user accounts will be imported with Authentication Type <\/i>as Native Authentication<\/i>. <\/font><\/li>\n<\/ul>\n
\n- It is recommended to reset password of all user accounts whose Authentication Type <\/i>is Native Authentication<\/i>, as password of the imported user accounts will be empty.<\/font><\/li>\n<\/ul>\n
Limitation<\/font><\/strong>: Column header in Excel<\/i> file must be left aligned. <\/font><\/p>\n<\/div><\/div>\n\nIf you have an Excel file containing user accounts exported from some other application, follow the steps to prepare it in the required format:<\/h3>\n\n1. Ensure that all the column headers are left aligned.<\/font>
\n2. Rename column headers in Excel<\/i> file to map them with the corresponding fields in a TopTeam<\/i> user account. Following are the available field names in a TopTeam<\/i> user account:<\/font><\/p>\n\n- Username<\/li>\n
- Display Name<\/li>\n
- User Type<\/li>\n
- Authentication Type<\/li>\n
- Email Id1<\/li>\n
- Consultant<\/li>\n
- First name<\/li>\n
- Middle name<\/li>\n
- Last Name<\/li>\n
- Address<\/li>\n
- City<\/li>\n
- State<\/li>\n
- Country<\/li>\n
- Zip<\/li>\n
- Mobile<\/li>\n
- Office<\/li>\n
- Pager<\/li>\n
- Fax<\/li>\n
- Home<\/li>\n
- Job Title<\/li>\n
- Description<\/li>\n<\/ul>\n
3. Save file.<\/font><\/p>\n<\/div><\/div>\n\nStep 5. Select an Excel file that you want to import <\/h3>\n\n\n<\/div>\n<\/p><\/div>\n\nStep 6. Enter header row number and click Import<\/h3>\n\n\n<\/div>\n<\/p><\/div>\n\nStep 7. User accounts are imported from the Excel file into TopTeam repository<\/h3>\n\n\n<\/div>\n<\/p><\/div>\n\nSee Also<\/h3>\n\nHow to add\/remove Team Members to a Project (TopTeam Web)<\/a>
\nGetting Started with User Accounts<\/a><\/p>\n<\/div><\/div>\n\n\nRevised: March 6th, 2018<\/p>\n<\/div><\/div>\n<\/p><\/div>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Overview In TopTeam, you can import user accounts from an Excel file using Import Users from Excel feature. Following are the methods using which you can import user accounts into TopTeam repository: 1. Download a sample Excel file and add user accounts manually to it. 2. From an existing Excel file that you may have exported from active directory, etc. This article explains how to import user accounts from Excel into TopTeam repository. Who should read this? TopTeam Administrators Prerequisites You should have System Administrator or Manage User Accounts permissions for managing user accounts in TopTeam. Step 1. Navigate to <\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[50],"tags":[292,167,46,298,302],"class_list":["post-37411","post","type-post","status-publish","format-standard","hentry","category-topteam-web","tag-authentication","tag-excel","tag-import","tag-topteam-web","tag-user-accounts"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-9Jp","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/37411","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/comments?post=37411"}],"version-history":[{"count":12,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/37411\/revisions"}],"predecessor-version":[{"id":46431,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/37411\/revisions\/46431"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=37411"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=37411"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=37411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
In TopTeam<\/i>, you can import user accounts from an Excel <\/i>file using Import Users from Excel<\/i> feature. Following are the methods using which you can import user accounts <\/font>into TopTeam <\/i>repository: This article explains how to import user accounts from Excel<\/i> into TopTeam <\/i>repository.<\/i><\/p>\n<\/div><\/div>\n You should have System Administrator<\/i> or Manage User Accounts<\/i> permissions for managing user accounts in TopTeam<\/i>.<\/font><\/p>\n<\/div><\/div>\n Limitation<\/font><\/strong>: Column header in Excel<\/i> file must be left aligned. <\/font><\/p>\n<\/div><\/div>\n 1. Ensure that all the column headers are left aligned.<\/font> 3. Save file.<\/font><\/p>\n<\/div><\/div>\n How to add\/remove Team Members to a Project (TopTeam Web)<\/a> Revised: March 6th, 2018<\/p>\n<\/div><\/div>\n<\/p><\/div>\n <\/p>\n","protected":false},"excerpt":{"rendered":" Overview In TopTeam, you can import user accounts from an Excel file using Import Users from Excel feature. Following are the methods using which you can import user accounts into TopTeam repository: 1. Download a sample Excel file and add user accounts manually to it. 2. From an existing Excel file that you may have exported from active directory, etc. This article explains how to import user accounts from Excel into TopTeam repository. Who should read this? TopTeam Administrators Prerequisites You should have System Administrator or Manage User Accounts permissions for managing user accounts in TopTeam. Step 1. Navigate to <\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[50],"tags":[292,167,46,298,302],"class_list":["post-37411","post","type-post","status-publish","format-standard","hentry","category-topteam-web","tag-authentication","tag-excel","tag-import","tag-topteam-web","tag-user-accounts"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-9Jp","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/37411","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/comments?post=37411"}],"version-history":[{"count":12,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/37411\/revisions"}],"predecessor-version":[{"id":46431,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/37411\/revisions\/46431"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=37411"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=37411"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=37411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n1. Download a sample Excel<\/i> file and add user accounts manually to it.<\/font>
\n2. From an existing Excel<\/i> file that you may have exported from active directory, etc.<\/p>\nWho should read this?<\/h3>\n
\n
Prerequisites<\/h3>\n
Step 1. Navigate to the Administration page of TopTeam Web<\/h3>\n
\n<\/div>\n<\/p><\/div>\n
Step 2. Administration page opens, click Manage User Accounts<\/h3>\n
\n<\/div>\n<\/p><\/div>\n
Step 3. Click Manage User Accounts<\/h3>\n
\n<\/div>\n<\/p><\/div>\n
Manage User Accounts page opens with a grid view of all TopTeam users<\/h3>\n
\n<\/div>\n<\/p><\/div>\n
Step 4. Select the Import Users from Excel option<\/h3>\n
\n<\/div>\n<\/p><\/div>\n
It is recommended that you must download the sample file to get an understanding about the required format for importing<\/h3>\n
\n<\/div>\n<\/p><\/div>\n
Sample Excel File<\/h3>\n
\n<\/div>\n<\/p><\/div>\n
NOTE:<\/h3>\n
\n
\n
\n
\n
\n
If you have an Excel file containing user accounts exported from some other application, follow the steps to prepare it in the required format:<\/h3>\n
\n2. Rename column headers in Excel<\/i> file to map them with the corresponding fields in a TopTeam<\/i> user account. Following are the available field names in a TopTeam<\/i> user account:<\/font><\/p>\n\n
Step 5. Select an Excel file that you want to import <\/h3>\n
\n<\/div>\n<\/p><\/div>\n
Step 6. Enter header row number and click Import<\/h3>\n
\n<\/div>\n<\/p><\/div>\n
Step 7. User accounts are imported from the Excel file into TopTeam repository<\/h3>\n
\n<\/div>\n<\/p><\/div>\n
See Also<\/h3>\n
\nGetting Started with User Accounts<\/a><\/p>\n<\/div><\/div>\n