Checklist upload template
The table shown below explains each cell in the template and provides an example of the type of data to enter into the cell.
Tip: You can download a spreadsheet template by selecting the Sample File () button on the Data Upload pane.
Tip: Try creating a checklist manually first to better understand how each field works.
Fields on the checklist upload template
SNO | Sheet Name | Field Name | Description | Example |
---|---|---|---|---|
1 |
Checklist |
Checklist_Name_ENG |
Name of the checklist. |
OBRC26' |
2 |
Checklist |
Checklist_Name_Language |
Name of the checklist in the second language. |
OBRC |
3 |
Checklist |
Description_ENG |
Detailed description of the checklist. |
One Bed Room Checklist |
4 |
Checklist |
Description_Lang |
Detailed description in the second language. |
張床房間清單 |
5 |
Checklist |
Group_ENG |
Name of the group that will access the checklist. |
Housekeeping |
6 |
Checklist |
Group_Lang |
Name of the group in the second language. |
亞洲時報 |
7 |
Checklist |
Checklist_For |
Whether the checklist is for a department, location, equipment, or other. |
LOCATION |
8 |
Checklist |
Select Location |
You can only select locations only once the data has been imported. |
|
9 |
Checklist |
Text_Input_Label_Eng |
Description or purpose for the checklist. |
TEST |
10 |
Checklist |
Text_Input_Label_Lang |
Description or purpose for the checklist in second language. |
TEST |
11 |
Checklist |
Checklist_Type |
Define the method of scoring. You can select only of the of following options:
|
PASS_FAIL |
12 |
Checklist |
Pass_Text_Eng |
This must be "Pass_Eng". |
Pass_Eng |
13 |
Checklist |
Pass_Text_Lang |
Enter “Pass_” with the language code. |
Pass_Lang |
14 |
Checklist |
Fail_Text_Eng |
This must be the "Fail_Eng". |
Fail_Eng |
15 |
Checklist |
Fail_Text_Lang |
Enter “Fail_” with the language code. |
Fail_Lang |
16 |
Checklist |
Enabled |
Enter Y to activate the checklist. |
Y |
17 |
Checklist |
Capture_Comments |
Enter Y if the Comments field is active. Otherwise, enter N. |
Y |
18 |
Checklist |
Capture_Comments_Mandatory |
Enter Y if the Comments field is mandatory. Otherwise, enter N. |
N |
19 |
Checklist |
Capture_Images |
Enter Y if the Images field is active. Otherwise, enter N. |
Y |
20 |
Checklist |
Capture_Images_Mandatory |
Enter Y if the Images field is mandatory. Otherwise, enter N. |
N |
21 |
Checklist |
Allow_Triton_Calls |
Enter Y if to enable. Otherwise, enter N. |
Y |
22 |
Checklist |
Must_Rate_All_Items |
Enter Y if all items must be rated. Otherwise, enter N. |
N |
23 |
Checklist |
Checklist_Name_ENG |
Same as row 1. |
OBRC26' |
24 |
Checklist |
Checklist_Name_Language |
Same as row 2. |
OBRC |
25 |
Checklist |
Checklist_Category_ENG |
Category as provided by the client. |
Door Bell |
26 |
Checklist |
Checklist_Category_Lang |
Category in secondary language. |
門鈴 |
27 |
Checklist |
Checklist_Item_ENG |
Enter the check list item. |
No Power door bell |
28 |
Checklist |
Checklist_Item_Lang |
Enter the check list item in a secondary language. |
無電源門鈴 |
29 |
Checklist |
Capture_Comments_Mandatory |
Enter Y if the Comments field is mandatory. Otherwise, enter N. |
N |
30 |
Checklist |
Capture_Images_Mandatory |
Enter Y if the Images field is mandatory. Otherwise, enter N. |
N |
31 |
Checklist |
Must_Rate_This_Item |
Enter Y if the item must be rated. Otherwise, enter N. |
N |
32 |
Checklist |
Checklist_Name_ENG |
Same as row 1. |
OBRC26' |
33 |
Checklist |
Checklist_Name_Language |
Same as row 2. |
OBRC |
34 |
Checklist |
Display_Text_Eng |
Name of the scoring field. |
TEST1 |
35 |
Checklist |
Display_Text_Lang |
Name of the scoring field in the secondary language. |
TEST1 |
36 |
Checklist |
Value |
Value that you want the field to have. |
1 |