- While importing a CSV file does it not consider the first row as a header ?
When using the "databank for contents" just create a CSV file without a header line. Just drop that line before saving to CSV (I assume you'll store your original data in a different format liek XLSX oder ODS, anyway).
And yes, you're correct. Ignoring the first line during import would be an easy task that SoSci Survey should do. Yet, whenever we wanted to add this, some research project required a more-important, magnificant feature to implement...
- I would like to know is there any documentation or video to use the imported data from CSV file into the Questionnaire?
Depends on what your planning to do. The "database for content" is a very generic feature. You can use it to pass individual data from a different source into the questionnaire, you can use it to ask for passwords, you can use it to display a dropdown selection from 2000 options, you can use it for stimulus material in a conjoint analysis. I gues it would be a 2 hour video to discuss all these (and more) options :)
How many vignettes do you actually have in your vignette design? If your random numer was stored in IV01_01 (e.g., drawn via urnDraw()
), than this would be the code to display the content from your database:
$code1 = value('IV01_01');
$data1 = dbGet('EmployeeInfo'.sprintf('%02d', $code1));
$text1 = $data1[0];
// Same for the second, and third part with $text2, $text3, then
html('<p>'.$text1.' '.$text2.' '.$text3.'</p>');
The sprintf()
is just to make a two-digit number from the original code (e.g., 1 -> '01').