How to Import a Checklist Template
Who is this article for?Auditors responsible for managing checklists.
Audit admin permissions are required.
Audit checklists can be created manually using the Coruson interface, however if your checklist is large then you may want to design this in Microsoft Excel and then import the checklist into Coruson. This is done using the attached CSV template.
This article outlines the steps on how to import a checklist to Coruson. If you would prefer to manually create the checklist then please see How to Create an Audit Checklist Template for details.
- How to Use the Checklist Creator
- How to Import the Checklist Template
- Email Notifications
- Troubleshooting
- Further Reading
- Attachments
1. How to Use the Checklist Creator
In order to create a new checklist, open the Checklist Template Import Creator and you will be presented with the empty template. There are 38 columns within which to enter the information required to import the checklist. You may add extra columns if additional area of standards wish to be imported (see Area of Standards for more information). You cannot import a checklist that has more than 500 questions on it.
Checklist Template
The first row entered should always be the name of the checklist template - together with a description, whether to allow auditor actions on the checklist and the Guid of the Organisational Unit (see troubleshooting for finding the Guid of an Organisational Unit) that you wish the checklist to be associated with.
It is important to note at this point that if you do not enter anything in the OrgUnitId cell, then the checklist will be associated to the default Organisational Unit.
Note: Do not enter any text within any other columns on this row as this will cause the import to fail.
The following rows are used to enter the information relating to your checklist – i.e. Sections and Questions. The order that they are entered is the order they will appear on the checklist.
Sections
The only columns in which data should be entered are the Section and Location columns:
- Section: The name of the section to be created
- Location: The section location that the section is to be located. If this is left blank, then this will be in the root folder of the checklist. The location should be entered in the form of a hierarchical path (see Entering Hierarchical Paths for more information).
Note: When entering a location for a section or question, please ensure that the section is above any items that should be contained therein.
Entering data in the Section column and any other column other than Location will result in the import failing and an email will be sent (see Emails for more information).
Area of Standards
When importing area of standards, the application checks whether the area of standard exists already within the system and if so adds that existing standard to the question. If it doesn’t exist a new area of standard will be created and linked to the question. If the area of standard exists within the system but is archived, then the import will fail. You will be prompted in an email to either alter the area of standard to be imported or else re-instate the archived area of standard within the system.
An unlimited number of area of standards can be imported on each question. Initially this is set to 15, however if you wish to increase the number then simply add as many extra columns in the first row as is needed, following the naming same conventions - I.e. AOS16, AOS17 etc.
Note: Do not alter, move or remove any other columns and do not alter other column header names – doing so will invalidate the import.
Questions
When entering information pertaining to a question, information should be entered in the following columns:
- Question: The name of the question to be entered.
- Location: The section location that the question is to be located. If this is left blank, then this will be in the root folder of the checklist. The location should be entered in the form of a hierarchical path (see Entering Hierarchical Paths for more information).
- Guidance: The guidance that is to be associated with the question.
- AA1 to AA15: Within each column the Auditor Action wishing to be imported should be entered within the cell. Any cells left blank will not be imported as an auditor action. These actions are hierarchical and will appear in the order of 1-15. Auditor Actions are limited to 15.
Entering data in the Question column and any other column other than the ones stated above will result in the import failing and an email will be sent (see Emails for more information).
Entering Hierarchical Paths
When entering paths, they must follow a specific hierarchical pattern. For example, if you were to have a question within a section which is in the root directory, the section (as it is in the root) would have an
empty cell within its Location column. The question however would have the name of the section.
If there are multiple layers to the path, such as is the case with area of standards, then the location would be split by a forward slash “/”. For example if the hierarchy is:
IOSA Standards
Then the path would be “IOSA Standards/Clause 1” (see images below). This also applies to Questions and Sections (see images below). This can be used for any level of hierarchy, however when creating questions, you must ensure that the location has been created before adding it as a location.
Note: Please ensure that you do not use a forward slash “/” character in the names of your standards, sections or questions as this will cause the import to fail. Only use a forward slash “/” specifically to delineate a new layer to the location or area of standard.
2. How to Import the Checklist Template
Note: Only csv files in the CSV UTF-8 (Comma delimited) (*.csv) format are valid to upload, and any other type of file will receive an error message.
Once you have completed the Checklist Template Import Creator, save the spreadsheet as a CSV UTF-8 (Comma delimited) (*.csv). Any other format is not supported.
To import the checklist:
- Log in to Coruson.
- Go to Administration, then Audit Admin and then select Checklist Templates.
- Click on the Add icon.
- Click Import Checklist Template.
- Browse and select your saved CSV file.
- Click Import.
Important Note: The checklist is imported in the background. You will receive an email once the import has been processed. The email will confirm if the import succeeded or failed.
3. Email Notifications
The user who performed the import will receive an email on either the success or failure of the import.
A detailed description of any failures will be included in the email.
If for any reason the import has failed after validation (i.e. during the execution of the import) then an email will also be sent informing of this failure. In this situation you should attempt to import the checklist again.
4. Troubleshooting
Formatted Characters
It is important to note formatted characters are not supported within the import. If copying text from an external source, please ensure it is plain text and not formatted in anyway, as this could cause the import to fail or import data incorrectly.
GUID’s
To find the Guid of an Organisational Unit navigate to Administration> People and Security > Organisational Unit Management.
Select the Organisational Unit you wish to get the Guid for, then within the address bar the id is located between ‘node’ and ‘archived’, minus the slashes.