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 |