Skip to main content
Eptura Knowledge Center

Import Department Hierarchy Data

Directory - Bulk Upload of Department Hierarchy - PREVIEW

This feature is in Preview and mentioned in the What's next article.

Level: Administrator

Your Administrator can upload the department hierarchy into the directory.

Step 1. Open the Import department data panel

  1. From the Home screen, click the Directory tool and the Directory screen displays.
  2. Click the Settings clipboard_eb474bae-4a85-4f96-a72e-af8d04cf3d00.png icon and the Module settings screen displays.
  3. Click the New deparment drop-down.

clipboard_58b090bf-2fa9-49bc-b692-c32a47466e01.png

  1. Click the Import departmnet data and the Import department data panel displays.

clipboard_36c2a917-aa0d-464f-9d20-11362369c742.png

Step 2. Download and prepare the file

  1. Click the Sample_departments.xlsx button and thefileis downloaded.
  2. Navigate to the downloads folder and open the file.
  3. Complete the data in the spreadsheet and the Data Requirements and Business Rules for the standard fields are listed below.

clipboard_bb3b6987-51ca-4d6f-851c-cf216c37a9d5.png

Step 3. Upload your file

  1. In the Upload your file area, either: drag and drop the file onto the area OR click the Browse file link to browse to the file and select it. Then the file uploads.

clipboard_00f92666-3175-40a2-84ff-7a8d4508a628.png

  1. Click the Review your data button.

clipboard_3117b37c-83c6-4a11-83d4-543110141779.png

  1. Click the Complete import button. The file import starts and you will see a notification with the message "Upload Completed and (number) departments created successfully.

clipboard_2e4d23bd-4962-4995-a792-0db79f0ff088.png

Data Requirements and Business Rules


This table lists the standard fields and the business rules.

Field Name Required Field Business Rules

Department Name

Yes

  • Accepts any value
  • Must be unique
  • Special characters not allowed

Parent Department

No

  • ID or name of the parent department
  • Maximum supported hierarchy depth is 15 levels

Department Code

No

  • Accepts any value

New Department Name

No

  • Only applicable for Update operation
  • Must be unique
  • Special characters not allowed

Delete

No

  • Default = No
  • Accepted value: Yes/No (Case insensitive)