[open] How to merge my .csv files with Data merger?

marjoleinn92

Hello,

Recently I've been collecting data with opensesame, and now that I'm done I'd like to have one file with all the data. I have 45 .csv files I want to merge in one file, so I can analyse the data with SPSS.

I found the Datamerger program written by Daniel Schreij on this site, but when I try to select the files in the "source folder" box, the program doesn't recognize the files, so I can't select them. I also copied the files to the "resources" folder (when you click "select" this is the first folder you see), but the files don't show up here either.

Does someone know why this happens and how I can solve this problem?

Best,

Marjolein

Daniel

Hi Marjolein,

In data merger you do not select individual files you want to merge, but a single folder which contains all files you like to see merged. Datamerger will then traverse through all the files in this folder and use those which are mergeable.

Basically you thus have to do the following:

1. Create an empty folder
2. Place the csv/xls/xlsx files you want to merge in this folder. Be careful not to copy OpenSesame files like defaultlog.csv (which is 0 bytes) and such to this folder as Datamerger chokes on them (for now)
3. Select this folder in datamerger as the folder you want to merge from (thus no individual files)
4. Enter a file name and location to which the output should be saved
5. Press the merge button

This might be a bit counerintuitive, I know, but since datamerger also had to work from the command line it was the best way to implement it for now.

Let me know if it worked out for you.

Daniel

Andres

Hello,

I am having troubles with data merger.
I have 60 .csv files I got as output data from OpenSesame, and I am trying to merge them.
Every time I start merging files I get the following error:

Traceback (most recent call last):
File "/Users/dschreij/Documents/Datamerger/build/datamerger_osx/out00-PYZ.pyz/libdatamerger.datamerger_ui", line 159, in startMerge
File "/Users/dschreij/Documents/Datamerger/build/datamerger_osx/out00-PYZ.pyz/libdatamerger.sheet_io_tools", line 303, in mergeFolder
UnboundLocalError: local variable 'errorCount' referenced before assignment___

Does anybody knows how can I fix this?

Thank you in advance!

Andres

sebastiaan

Hi Andres,

You'll want to take a look at this discussion:

• http://forum.cogsci.nl/index.php?p=/discussion/3021

Cheers,
Sebastiaan