How to upload new or add to an Organisation Structure via an Excel spreadsheet

OVERVIEW

Building or Adding to your organisation structure within Damstra Safety can be achieved by importing all the required details via an Excel spreadsheet formatted specifically for this purpose. The following procedure explains how to format the spreadsheet and input your unique organisational structure prior to uploading to Damstra Safety.

IMPORTANT NOTE: Please contact your Damstra Representative for advice before making any changes to your Org Structure to prevent data loss and/or any other issues that may arise as a result.

PROCEDURE

1.  Column Structure/Labels

• Within the Excel spreadsheet name each column in accordance with required depth of the organisational structure you wish to import.
• Each organisational Level in the structure is named and numbered sequentially via a specific naming convention - for example if you wished to build a 3 level structure you would name the levels:
  "l1name", "l2name", "l3name".
  Note: The last level stipulated using this naming convention will become the "Blue (site) level" within the structure built in Damstra Safety.
• If you also wish to include "Site Codes" within your structure you will need to name a further, final column as "code"

Note:

• Colour coding not required in spreadsheet, this was simply done to illustrate how the naming related to what is actually built.
• If adding to an existing organisation structure ensure the same levels structure and naming conventions are used to accomplish a seamless integration.

2.  Input structure details

• Populate each row with the intended "level", "site" and "site code" (if req'd) information.
• Delete all blank rows and columns.

Note: If you have used a formula to produce your site codes, ensure that the formula values are copied and pasted throughout the entire "code" column.

3.  Save .xlsx

• Save the Excel file as an ".xlsx" or as an "Excel 97-2003 workbook" 

3.  Upload Structure 

• From the Settings menu:
• Select Organisation Structure from the General Section.

• Click Upload Structure.

• Select the file you wish to upload

 4.  Upload Complete

•  Once completed you will receive a confirmation pop-up box advising of the Result of the Upload.