Import CSV - encoding ormat
April 5, 2006 12:00 AM
If you go to the file/import/CSV Question File tool within Lectora there is a "File Format" button, which contains detailed information about the specifications of the CSV formatting required for import. It also inlcudes several example quesitons.Here is the contents of the help file:CSV Question import file format===============================The following question types can be imported with the CSV Import filter:- True/False- Multiple Choice- Essay- Short AnswerThe format is the same for each question type. All fields are separated by a comma, and all text fields are enclosed in quotes. Each question record starts on a new line. There can be line breaks within quoted fields. This is the default export format from Excel and Access when exporting to CSV.Each line is formatted as follows:[question id],,,<# of choices>,,,,,,.........The first field, , is optional. The import filter will check the validity of the field to determine whether or not a question id field is present. For that reason, none of the possible values for are allowed in the field.If is specified, the name will be used for the name of the page the question is on, the name of the question, and the name of the variable for the question. The must be unique for each question.The next field, can contain the following values:True/False or TFMultiple Choice or MCEssay or ESShort Answer or SAThe field is not case sensitive and should be enclosed in quotesThe next field is the actual question text, enclosed in quotes.Short Answer and Essay questions end here with no more fields on the line.The next field is the number of choices, a numeric value that indicates how many choice/feedback pairs will follow.The next field is the correct choice, a numeric value which starts at 1, that indicates which of the choice/feedback pairs is correct.After that follows a variable number of choice/feedback pairs that matches the previous number of choices field. If there is no feedback for a choice, empty quotes or no entry can be used. Each filed should be enclosed in quotes.The following are examples of valid questions:"Question ID 1","True/False","This is a True/False Question",2,1,"True","Correct Feedback","False","Incorrect Feedback""Question ID 2","Multiple Choice","This is a Multiple Choice Question",3,1,"Choice 1","Correct Feedback","Choice 2","","Choice 3","""Question ID 3","Essay","This is an Essay Question""Question ID 4","Short Answer","This is a Short Answer Question"
Discussions have been disabled for this post