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

Comments

• Daniel

  December 2013 edited December 2013

  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

  June 2017

  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

  June 2017

  Hi Andres,

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

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

  Cheers,
  Sebastiaan

  
  
  Check out SigmundAI.eu for our OpenSesame AI assistant!