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

  • RANGE_OF_VALUES

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