Millisecond Forums

importing csv data into inquisit script?

https://forums.millisecond.com/Topic24883.aspx

By elobot10 - 5/13/2018

Hello,

Is it possible to import data from a csv into an Inquisit script? We are running at two-part experiment on mTurk in which participants first fill out some questionnaires and then return at a later date to do a task. For the second part, we want to be able to give participants certain information based on our analysis of their performance on the first part, which will be stored in a csv along with their mTurk IDs. Is there any straightforward way of importing the info directly from the csv?

Many thanks!
By Dave - 5/14/2018

elobot10 - Monday, May 14, 2018
Hello,

Is it possible to import data from a csv into an Inquisit script? We are running at two-part experiment on mTurk in which participants first fill out some questionnaires and then return at a later date to do a task. For the second part, we want to be able to give participants certain information based on our analysis of their performance on the first part, which will be stored in a csv along with their mTurk IDs. Is there any straightforward way of importing the info directly from the csv?

Many thanks!

No, you cannot import from an CSV. Inquisit scripts can read in code from external files via <include> elements, however those files need to conform to standard Inquisit syntax.
By seandr - 5/14/2018

Hello,
Although there isn't a way to import CSV data directly into an Inquisit script, you could fairly easily use a spreadsheet app such as Excel to automatically generate a text file from the CSV data that formats the data as Inquisit syntax for elements such as <values>, <item> or <list> depending on how you wish to use those data. You can then include the generated file using the <include> command. 

-Sean

By Dave - 5/14/2018

Dave - Monday, May 14, 2018
elobot10 - Monday, May 14, 2018
Hello,

Is it possible to import data from a csv into an Inquisit script? We are running at two-part experiment on mTurk in which participants first fill out some questionnaires and then return at a later date to do a task. For the second part, we want to be able to give participants certain information based on our analysis of their performance on the first part, which will be stored in a csv along with their mTurk IDs. Is there any straightforward way of importing the info directly from the csv?

Many thanks!

No, you cannot import from an CSV. Inquisit scripts can read in code from external files via <include> elements, however those files need to conform to standard Inquisit syntax.

This post may possibly of interest in this context, too: https://www.millisecond.com/forums/FindPost15778.aspx
By AndrewPapale - 4/25/2023

Dave - 5/14/2018
Dave - Monday, May 14, 2018
elobot10 - Monday, May 14, 2018
Hello,

Is it possible to import data from a csv into an Inquisit script? We are running at two-part experiment on mTurk in which participants first fill out some questionnaires and then return at a later date to do a task. For the second part, we want to be able to give participants certain information based on our analysis of their performance on the first part, which will be stored in a csv along with their mTurk IDs. Is there any straightforward way of importing the info directly from the csv?

Many thanks!

No, you cannot import from an CSV. Inquisit scripts can read in code from external files via <include> elements, however those files need to conform to standard Inquisit syntax.

This post may possibly of interest in this context, too: https://www.millisecond.com/forums/FindPost15778.aspx

Is it still not possible to import csv's into inquisit in V6?  Just checking before I start manually coding a whole bunch of values.
By Dave - 4/25/2023

AndrewPapale - 4/25/2023
Dave - 5/14/2018
Dave - Monday, May 14, 2018
elobot10 - Monday, May 14, 2018
Hello,

Is it possible to import data from a csv into an Inquisit script? We are running at two-part experiment on mTurk in which participants first fill out some questionnaires and then return at a later date to do a task. For the second part, we want to be able to give participants certain information based on our analysis of their performance on the first part, which will be stored in a csv along with their mTurk IDs. Is there any straightforward way of importing the info directly from the csv?

Many thanks!

No, you cannot import from an CSV. Inquisit scripts can read in code from external files via <include> elements, however those files need to conform to standard Inquisit syntax.

This post may possibly of interest in this context, too: https://www.millisecond.com/forums/FindPost15778.aspx

Is it still not possible to import csv's into inquisit in V6?  Just checking before I start manually coding a whole bunch of values.

No, Inquisit 6 cannot read CSVs.
By AndrewPapale - 4/25/2023

Dave - 4/25/2023
AndrewPapale - 4/25/2023
Dave - 5/14/2018
Dave - Monday, May 14, 2018
elobot10 - Monday, May 14, 2018
Hello,

Is it possible to import data from a csv into an Inquisit script? We are running at two-part experiment on mTurk in which participants first fill out some questionnaires and then return at a later date to do a task. For the second part, we want to be able to give participants certain information based on our analysis of their performance on the first part, which will be stored in a csv along with their mTurk IDs. Is there any straightforward way of importing the info directly from the csv?

Many thanks!

No, you cannot import from an CSV. Inquisit scripts can read in code from external files via <include> elements, however those files need to conform to standard Inquisit syntax.

This post may possibly of interest in this context, too: https://www.millisecond.com/forums/FindPost15778.aspx

Is it still not possible to import csv's into inquisit in V6?  Just checking before I start manually coding a whole bunch of values.

No, Inquisit 6 cannot read CSVs.

Ok I'm going to write an R function to convert csv's into Inquisit lists.  We have >100k values to write.  If this works perhaps it will be of general use.
By AndrewPapale - 4/25/2023

AndrewPapale - 4/25/2023
Dave - 4/25/2023
AndrewPapale - 4/25/2023
Dave - 5/14/2018
Dave - Monday, May 14, 2018
elobot10 - Monday, May 14, 2018
Hello,

Is it possible to import data from a csv into an Inquisit script? We are running at two-part experiment on mTurk in which participants first fill out some questionnaires and then return at a later date to do a task. For the second part, we want to be able to give participants certain information based on our analysis of their performance on the first part, which will be stored in a csv along with their mTurk IDs. Is there any straightforward way of importing the info directly from the csv?

Many thanks!

No, you cannot import from an CSV. Inquisit scripts can read in code from external files via <include> elements, however those files need to conform to standard Inquisit syntax.

This post may possibly of interest in this context, too: https://www.millisecond.com/forums/FindPost15778.aspx

Is it still not possible to import csv's into inquisit in V6?  Just checking before I start manually coding a whole bunch of values.

No, Inquisit 6 cannot read CSVs.

Ok I'm going to write an R function to convert csv's into Inquisit lists.  We have >100k values to write.  If this works perhaps it will be of general use.

My solution is here for anyone interested.  Inquisit compiled with the lists copied and pasted into my iqx file.  https://github.com/UNCDEPENdLab/clock2/blob/main/code/convert_csv_to_inquisit_list.R
By Dave - 4/25/2023

AndrewPapale - 4/25/2023
AndrewPapale - 4/25/2023
Dave - 4/25/2023
AndrewPapale - 4/25/2023
Dave - 5/14/2018
Dave - Monday, May 14, 2018
elobot10 - Monday, May 14, 2018
Hello,

Is it possible to import data from a csv into an Inquisit script? We are running at two-part experiment on mTurk in which participants first fill out some questionnaires and then return at a later date to do a task. For the second part, we want to be able to give participants certain information based on our analysis of their performance on the first part, which will be stored in a csv along with their mTurk IDs. Is there any straightforward way of importing the info directly from the csv?

Many thanks!

No, you cannot import from an CSV. Inquisit scripts can read in code from external files via <include> elements, however those files need to conform to standard Inquisit syntax.

This post may possibly of interest in this context, too: https://www.millisecond.com/forums/FindPost15778.aspx

Is it still not possible to import csv's into inquisit in V6?  Just checking before I start manually coding a whole bunch of values.

No, Inquisit 6 cannot read CSVs.

Ok I'm going to write an R function to convert csv's into Inquisit lists.  We have >100k values to write.  If this works perhaps it will be of general use.

My solution is here for anyone interested.  Inquisit compiled with the lists copied and pasted into my iqx file.  https://github.com/UNCDEPENdLab/clock2/blob/main/code/convert_csv_to_inquisit_list.R

Thanks for sharing your solution!