Assets Module Setup: Importing an Asset Checklist Via a .csv File
Assets Module Setup: Importing an Asset Checklist Via a .csv File
Purpose
The purpose of this article is to inform users how to import an asset checklist in the Assets Module Setup using the First Due Checklist Import Template.
Video
Directions
1. Click on Assets.
2. Click on Setup.
3. Click on Check List.
4. Click on Import CSV.
5. Click on Download sample spreadsheet.
6. Locate and complete the file on your computer titled "bulk_checklist_import_sample.csv"
Inspection Type - The name of the checklist.
Section - The name of the section that the question will be located in within the checklist.
Question - The checklist question.
Description - A description of the checklist question.
Question Type - The type of checklist question. (See the images below for a description of each question type.)
single_select
multi_select
pass_or_fail
user_defined
field_update - (This question type is reserved for future use. Field update questions cannot currently be imported using this template, if this answer type is chosen, the question WILL NOT IMPORT.)
Answers - The answers that will be available for the questions. Answer options must be typed in the following format "Answer 1,Answer 2,Answer 3"
Required - If the question is a required question for checklist completion type "True", otherwise leave blank.
Fields - This field is reserved for future use and currently has no function. Leave blank.
- The below images display an example of each question type.
Note: Apparatus and Equipment checks will provide the option to create "Field Update" questions. "Field Update" questions require a user to input a value, once entered that value will be updated on that specific asset's master record. Examples of "Field Update" questions include but are not limited to: Engine Hours, PTO Hours, Mileage, Aerial Hours, and Pump Hours, etc. Currently"Field Update" questions must be created in the First Due system and CANNOT be imported via .csv.
7. When the .csv file has been completed, Click on Import CSV.
8. Click on Choose File.
9. Attach the completed .csv checklist file.
10. Click on Import.
Warning: If there are any errors during the import process, the system will generate a .csv file titled "ErrorLogFileChecklistItems.csv" The error log will display the items that were unable to be imported and a reason specifying what happened. The below image shows that a question could not be imported because it was not a unique question name for the specified section.
Info: Although importing a checklist may save an abundance of time, there are limitations to importing a checklist into the system via a .csv file. Once the checklist is imported the user must locate the checklist and specify what the checklist applies to. Also, many advanced checklist features such as enabling a bulk check, attaching checklist instructions, enabling work order creation upon question failure, creating "field update" questions, and other features will require the user to edit the imported checklist from within the First Due System.
11. Locate the newly imported checklist and click the Edit icon in the Actions column.
12. After all additional changes have been made, click Save. The checklist is now available to be scheduled for use in the First Due Checklist Scheduler.
Purpose The purpose of this article is to inform users how to create an asset checklist in the Assets Module Setup. Video Directions 1. Click on Assets. 2. Click on Setup. 3. Click on Check List. 4. Click on Add Check List. 5. Complete the following ...
Purpose The purpose of this article is to inform users how to bulk import equipment into the First Due System using First Due's Bulk Import Wizard. The sample CSV Template is attached to the bottom of this article. Info: Kits can be created in bulk ...
Purpose The purpose of this article is to demonstrate how to find and import checklist templates from the Assets Checklist Library. More templates will be added to the Checklist Library as they become available. Related Articles Assets Module Setup: ...
Purpose To explain the Checklist Completion Status Report for the Assets module. How is this report helpful? This report allows you to track what Checklists have been completed. This report tracks all Incomplete Checklists. This reports tracks ...
Purpose To provide instructions for importing multiple pieces of inventory using the inventory import template. The Sample CSV template is attached to the bottom of this article. Video Directions 1. Navigate to Assets > Inventory List. 2. Select the ...