Checklist Import

L2L Support can assist in mass uploading checklists to your site by uploading using our Checklist import sheet found at the top of the Checklist Import screen. Additionally, existing checklists can be updated through the upload process as long as the external I.D. for these existing documents is provided on the upload sheet.

You'll find the ability to import checklists under the Standard Work/ Document Center tab.

Please note: You can only import one checklist at a time.

Under Option 1, there is a template for use for building your spreadsheet.

Preparing your Spreadsheet:

On your template, you'll see a top row with the 'Header' names. 

Column A, 'Name': This column is the simply the name of the Checklist.

Column B, 'Description': This column is a brief description of what the Checklist entails.

Column C, 'Category Code': This column needs to be populated with the 'Category Code' for the Checklist to be associated with. Categories will need to be set up ahead of time, as this field is required.

Column D, 'Require Complete All': This column requires a yes or no response and is used when all questions must be answered to close the checklist.

Column E, 'Require Dispatch Closed': This column requires a yes or no response and is used when the checklist must be closed to complete and close the Dispatch it's tied to.

Column F, 'External I.D.': This column is another naming convention and can be the same as column one. If this is an update to existing checklists, the checklist will already have an external ID. You can find that ID when you export checklists from the Document Center.

Column G, 'Task Text': This column is the information that you want answered.

Column H, 'Task Type': L2L has multiple types of answers to tasks to choose from depending on the question asked; text, datetime, dropdown, checkbox, input, yes_no, longinput, numeric

Column I, 'Allow not Applicable': This option allows your users to not answer that question if it doesn't apply to the situation. The column needs a yes/no response.

Column J, 'Dropdown Values': This column is used for the task type of 'dropdown' from column G. If you've selected dropdown, this is where you'll populate the answers to choose from using a comma. If you don't have any dropdown task types, enter 'None' in the column.

Column K, 'Reject Limit Low': This column is the low value required to launch a Dispatch for a Numeric Input question.

Column L, 'Reject Limit High': This column is the high value required to launch a Dispatch for a Numeric Input question.

Column M, 'Control Limit Low': This column is the low value for a lower control limit in a Numeric Input question.

Column N, 'Control Limit High': This column is the high value for the higher control limit in a Numeric Input question.

Importing your Spreadsheet:

Select the file you just created from the template and click 'Next Step'.

The next screen gives you an overview of the top three rows of your spreadsheet. There is also a dropdown to select sheets from the spreadsheet if the intended one is not the default.

Next, click 'Do Import'.

Once the import is complete, you'll see your import results. The results will let you know if the import succeeded or list any errors if it did not. Note: If you need help deciphering errors, please email us at support@l2l.com