Goal:
- Importing Approval Groups into Procurify
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:
- Download the template, available at the bottom of the following article, titled Approval Group Import.csv
-
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). This field has a character limitation of 100.
- 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.
- Once done, select Settings→ Import Data
- Select Import CSV File beside Approval Routing
- Select Browse & Upload CSV
- 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.
Additional Information:
- Why isn't my CSV formatting saving?
- The group name can only appear once per template. The group name must be unique.
- It is only possible to assign one or all Locations and Department via the import
- If the import finds a matching existing group, the group conditions will clear and replace it with what is in this template.
- Every location, department, must be exactly the same as the information entered in the system to be able to map successfully.
- After these groups are imported, do not forget to use the approval routing import to assign users to the groups
- Customized Organizational Catagories