Millisecond Forums » Millisecond Forums » Inquisit 5 » importing csv data into inquisit script?

importing csv data into inquisit script?

elobot10 — Tue, 25 Apr 2023 17:30:02 GMT

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!

RE: importing csv data into inquisit script?

Dave — Tue, 25 Apr 2023 17:30:02 GMT

+x[quote]

[b]AndrewPapale - 4/25/2023[/b]
+x[quote]

[b]AndrewPapale - 4/25/2023[/b]
+x[quote]

[b]Dave - 4/25/2023[/b]
+x[quote]

[b]AndrewPapale - 4/25/2023[/b]
+x[quote]

[b]Dave - 5/14/2018[/b]
+x[quote]
[b]Dave - Monday, May 14, 2018[/b]
+x[quote]
[b]elobot10 - Monday, May 14, 2018[/b]
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!
[/quote]

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.
[/quote]

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

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.
[/quote]

No, Inquisit 6 cannot read CSVs.
[/quote]

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.
[/quote]

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
[/quote]

Thanks for sharing your solution!

RE: importing csv data into inquisit script?

AndrewPapale — Tue, 25 Apr 2023 17:06:50 GMT

+x[quote]

[b]AndrewPapale - 4/25/2023[/b]
+x[quote]

[b]Dave - 4/25/2023[/b]
+x[quote]

[b]AndrewPapale - 4/25/2023[/b]
+x[quote]

[b]Dave - 5/14/2018[/b]
+x[quote]
[b]Dave - Monday, May 14, 2018[/b]
+x[quote]
[b]elobot10 - Monday, May 14, 2018[/b]
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!
[/quote]

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.
[/quote]

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

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.
[/quote]

No, Inquisit 6 cannot read CSVs.
[/quote]

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.
[/quote]

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

RE: importing csv data into inquisit script?

AndrewPapale — Tue, 25 Apr 2023 16:03:34 GMT

+x[quote]

[b]Dave - 4/25/2023[/b]
+x[quote]

[b]AndrewPapale - 4/25/2023[/b]
+x[quote]

[b]Dave - 5/14/2018[/b]
+x[quote]
[b]Dave - Monday, May 14, 2018[/b]
+x[quote]
[b]elobot10 - Monday, May 14, 2018[/b]
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!
[/quote]

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.
[/quote]

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

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.
[/quote]

No, Inquisit 6 cannot read CSVs.
[/quote]

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.

RE: importing csv data into inquisit script?

Dave — Tue, 25 Apr 2023 15:51:43 GMT

+x[quote]

[b]AndrewPapale - 4/25/2023[/b]
+x[quote]

[b]Dave - 5/14/2018[/b]
+x[quote]
[b]Dave - Monday, May 14, 2018[/b]
+x[quote]
[b]elobot10 - Monday, May 14, 2018[/b]
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!
[/quote]

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.
[/quote]

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

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.
[/quote]

No, Inquisit 6 cannot read CSVs.

RE: importing csv data into inquisit script?

AndrewPapale — Tue, 25 Apr 2023 15:29:00 GMT

+x[quote]

[b]Dave - 5/14/2018[/b]
+x[quote]
[b]Dave - Monday, May 14, 2018[/b]
+x[quote]
[b]elobot10 - Monday, May 14, 2018[/b]
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!
[/quote]

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.
[/quote]

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

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.

RE: importing csv data into inquisit script?

Dave — Mon, 14 May 2018 12:04:44 GMT

[quote]

[b]Dave - Monday, May 14, 2018[/b]

[quote]

[b]elobot10 - Monday, May 14, 2018[/b]

[/quote]

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.

[/quote]

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

RE: importing csv data into inquisit script?

seandr — Mon, 14 May 2018 10:42:58 GMT

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

RE: importing csv data into inquisit script?

Dave — Mon, 14 May 2018 09:03:17 GMT

[quote]

[b]elobot10 - Monday, May 14, 2018[/b]

[/quote]

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.