importing csv data into inquisit script?


Author
Message
elobot10
elobot10
Partner Member (746 reputation)Partner Member (746 reputation)Partner Member (746 reputation)Partner Member (746 reputation)Partner Member (746 reputation)Partner Member (746 reputation)Partner Member (746 reputation)Partner Member (746 reputation)Partner Member (746 reputation)
Group: Forum Members
Posts: 11, Visits: 59
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!
Dave
Dave
Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)
Group: Administrators
Posts: 12K, Visits: 98K
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.

seandr
seandr
Supreme Being (142K reputation)Supreme Being (142K reputation)Supreme Being (142K reputation)Supreme Being (142K reputation)Supreme Being (142K reputation)Supreme Being (142K reputation)Supreme Being (142K reputation)Supreme Being (142K reputation)Supreme Being (142K reputation)
Group: Administrators
Posts: 1.3K, Visits: 5.6K
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


Dave
Dave
Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)
Group: Administrators
Posts: 12K, Visits: 98K
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

Andrew Papale
Andrew Papale
Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)
Group: Forum Members
Posts: 62, Visits: 230
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.

Dave
Dave
Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)
Group: Administrators
Posts: 12K, Visits: 98K
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.
Andrew Papale
Andrew Papale
Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)
Group: Forum Members
Posts: 62, Visits: 230
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.

Andrew Papale
Andrew Papale
Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)Partner Member (807 reputation)
Group: Forum Members
Posts: 62, Visits: 230
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

Dave
Dave
Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)Supreme Being (1M reputation)
Group: Administrators
Posts: 12K, Visits: 98K
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!
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Reading This Topic

Explore
Messages
Mentions
Search