Access Control Import: Import Group - User Assignment

  1. Log on as the Administrator.
  2. Select Admin > Access Control Imports.
  3. Highlight the Import Group - User Assignments option, and click the Select Files button.
  4. Specify the location on your workstation or network in which the Excel .csv import file for new groups resides.
  5. Select the correct location where the .csv import file resides. Only files with the filename extension “.csv”, which typically designates a comma-delimited file, are allowed for Access Control Import.
  6. When the correct file and location are selected, click the Open button on the Browse for Folder dialog. The Browse for Folder dialog is immediately closed, and the file in the selected folder with a filename extension of “.csv” appears in the file Upload dialog.
  7. To start the import of the selected file, click the Upload button. To cancel the import, click the Clear List button.
  8. The data from the selected file is imported into Access Control in a single operation which does not require your intervention. When the import is complete, the Group - User Assignments Import results appear, and the data from the import file and the import status of each record appear.
  9. Click the Continue button to end the import process and return to the Access Control Imports screen.

Import Group - User Assignment Data Format

The following table shows the data fields for the group user assignments import file. Each data field must be followed by a comma except the last data field in the record (row). Each record must be followed by a carriage return.

Field # Contents Explanation
1 Group name Group name, alphanumeric and spaces, maximum 20 characters
2 Group Location Group Location, alphanumeric and spaces, maximum 20 characters
3 User Login ID User Login ID
4 User Location

User Location, alphanumeric and spaces, maximum 20 characters

Import Group - User Assignment Data Examples

Following is an example of a record containing one user membership to a Group; data fields are explained in the preceding table:

Dallas_Admin,Dallas,JDOE,Dallas

Following is an example of records containing multiple user memberships to a Group; data fields are explained in the preceding table:

LA_Preparers,Los Angeles,MSmith,Los Angeles

New York_Preparers,New York,SJones,New York

Dallas_Preparers,Dallas,RGreen,Dallas

 

 

 

RS Resources/exp_imports_5.htm/TY2021

Last Modified: 06/30/2020

Last System Build: 09/25/2022

©2021-2022 Thomson Reuters/Tax & Accounting.