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)QuestionSequence #
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|