Skip to main content
Eptura Knowledge Center

Import Department Hierarchy Data

Eptura - Directory

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 department drop-down.

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

  1. Click the Import department data button 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 the file is 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

Note there is a panel that contains the fields and the descriptions; click the View formatting requirements and business rules link.

clipboard_9b8875ff-114c-4ed4-af73-771990798d91.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

From the drop-down, select either No or Yes.

Default = No