output csv for breadth task version 1 (bv1)

[jaerikson]

can we have all this info in the output csv? is that nuts?

columns: date, partic, task_id, strand, breadth_id, item_num, img_type_click, position_click, time_click

some of these variables may not be part of the program yet...

• date: date of activity
• subj_id: participant ID
• task_id: bv1, etc.
• strand: 40, 50, 62, 63
• breath_id: b001, b002, b003, ..., b107, b108. unique ID for target words (e.g., "arachnid" is b001)
• item_order: item number based on order in which items are presented in randomized order

variables based on click:

• img_type_click: fp, fs, fx, tw
• position_click: p1, p2, p3, p4
• time_click: HH:MM:SS (tell me if another format is better though!)

[jaerikson]

@schoelen Please test the breadth component of the webapp and check if the output file (answers.xlsx) has all the columns described in this issue. If not, then modify the code to make this happen.

( written by @adarshp )

[adarshp]

With #21, the answers are no longer output to a CSV but written to a database. We have most of the stuff in this issue implemented, although with slightly different column names. Here is sample output from querying the db with the current (as of 2020-12-27) schema.

~/git/L4LabUA/scivocab (master) $ sqlite3 -header -csv app/app.db 'select child_id, strand_id, breadth_id, response_type, position, timestamp from breadth_task_response inner join word on breadth_task_response.target_word=word.id;'
child_id,strand_id,breadth_id,response_type,position,timestamp
test,63,b104,tw,top_left,"2020-12-27 20:12:08.617828"
test,63,b107,tw,top_left,"2020-12-27 20:12:09.688386"
test,63,b096,fs,top_left,"2020-12-27 20:12:09.839921"
test,63,b101,fp,top_left,"2020-12-27 20:12:10.008499"
test,62,b058,fx,top_left,"2020-12-27 20:18:08.161642"
test,62,b056,fs,top_left,"2020-12-27 20:18:08.662502"
test,62,b080,fp,top_left,"2020-12-27 20:18:08.829850"
test,62,b068,fs,top_left,"2020-12-27 20:18:09.182449"
test,62,b075,tw,top_left,"2020-12-27 20:18:09.342122"
test,62,b060,fs,top_left,"2020-12-27 20:18:24.316561"
test,62,b069,fx,top_left,"2020-12-27 20:18:24.950583"
test,62,b066,fx,top_left,"2020-12-27 20:18:25.116731"
test,62,b071,fx,top_left,"2020-12-27 20:18:25.294216"
test,62,b062,fx,top_left,"2020-12-27 20:18:25.471266"
test,62,b065,fs,top_left,"2020-12-27 20:18:25.899306"
test,62,b076,fs,top_left,"2020-12-27 20:18:26.065661"