Format of Amethyst 1 template CSV file for import
Each line represents one question.
Format : Each field must be separated by a pipe character "|"
Fields
-
Template Name
(max 30 chars) -
Category Name
(max 30 chars) Question
Sequence #
This is the sequence the questions must display inside its category.
NOTE! No Duplicate Sequence numbers allowed with in a category.
-
Answer type
(Value can be 0,1 or 2)
If this is a positive category:
0
= Yes/No
1
= Yes/Need Attention/No
2
= Poor/Below Average/Average/Above Average/Excellent.
If this is a negative or total fail category:
0
= leave this field 0 for all questions.
-
Weight in Category
(1-9999)
If this is a positive category, this is the number of points this question counts within the Section.
-
Comments
(max 50 chars) -
Category type
(Values are 0,1 or 2)
0
= Positive category
1
= Negative category
2
= Total fail category.
Negative total
If this is a negative category, this is the total marks for the entire category.
Need score
If this is a negative category, this is the number of points to deduct for a Needs Attention
answer.
Poor score
If this is a negative category, this is the number of points to deduct for a Poor
answer.
An example would looks like this:
Template Name|Category Name|Question|Sequence #|Answer type|Weighted Points|Comments|Category type|Negative total|Need score|Poor score|
MyTemplate|01 First Category|Did they greet?|1|0|5|Listen at the start|0|0|0|0|MyTemplate|01 First Category|Did they introduce company?|2|0|5|Listen at the start|0|0|0|0|
MyTemplate|02 Second Category|Did they know the product?|3|0|50|Do they know the products|0|0|0|0|