How to Import Approval Groups

The following article outlines how to import Approval Groups. Due to customization, your interface text may differ. In this article, we are using the default labels Location and Department. Learn more here.

Steps:

1. Download the template, available at the bottom of the following article, titled Approval Group Import.csv

2.  Review the list below for a definition of each column and an example. Fill out the required columns and save the file to your computer.

   • Column A: Group Name- A unique name for the Approval Routing (Required Field) 
   • Column B: Type - Requests that the group will be approving for: Order, Expense, or Travel (Required Field). Type keyword **ALL** (include asterisks) to have the condition apply to all request types. It is not possible to include more than one request type in the field. It must be either one module (either Order, Expense or Travel) or **ALL**. 
   • Column C: Location - The Location names that this group will be approving for (Required Field). Review Locations by accessing Settings → Manage Location. (Use **ALL** if it applies to all Locations)
   • Column D: Department- Department name that this group will be approving for (Required field).  Review departments by accessing Settings→ Manage Locations. (Use **ALL** if it applies to all Departments)
   • Column E: Sequence - The group's priority if the Request was submitted with the same type, Location, **Department that trigger amongst multiple groups
   • Column F: Action of Duplicate   
     • Option 1: Use keyword IGNORE if you would like to ignore it in the row. Every letter in keyword must be capitalized.
     • Option 2: Use keyword DELETE to deactivate the group (as long as there is no pending approval for users within the group). Every letter in keyword must be capitalized.
     • Option 3: Use keyword UPDATE to clear any current group condition settings in the system and update with what is on this template. Every letter in keyword must be capitalized.
3. Once done, select Settings→  Import Data
4. Select Import CSV File beside Approval Routing 
5. Select Browse & Upload CSV 
6. Select Import

If there were any errors, make the required changes before re-uploading the CSV. You have successfully finished the import! 

** If you're domain doesn't use the naming organization of Location & Department you can still use your naming convention in these columns as needed. Example: Lab=Location & Team=Department.