Hello,

I have set up my spreadsheet in Datavyu to code three dependent measures in one column called help. This way, each cell provides all of the information for one measure. The cells include codes for "event"; which is the type of measure, "yesno", to describe if the participant helped or not; and "how", to describe how the participant acted.

I've managed to create a script to export all of the data, and the data appears in time order as expected. However, I would like to structure the file so that all of the data associated with a specific measure occurs in the same group of columns (all of the measures for measure 1 are in the first columns, regardless of the order the participant completes the measures). Is this possible?

I've tried to restructure my script using if/else statements, but it returned a blank .csv file. I tried to restructure it again, and I received a "No Methods" error (script below). Do you have any ideas?

Thanks! Amanda

require 'Datavyu_API.rb' begin out_file = File.expand_path("~/Desktop/SH043015.csv") out = File.new(out_file,'w') filedir = File.expand_path("~/Desktop/SH Coding/") filenames = Dir.new(filedir).entries for file in filenames if file.include?(".opf") and file[0].chr != '.' puts "Please hold..." + filedir+file $db,proj = load_db(filedir+ "/" +file) puts "YAY! Videos loaded correctly :)"

  subjinfo = getColumn("Subj_Info")
  help = getColumn("help")
     for scell in subjinfo.cells
        out.write(scell.subj+ ","+ scell.sex + "," + scell.age + "," + scell.first + ",")
       for hcell in help.cells
           out.write(hcell.onset.to_s[0] + ", " + hcell.offset.to_s[0] + ", " + hcell.event[0] + ", " +  hcell.yesno[0] + ", "  + hcell.how[0] + ", ")
           if scell.first == "n"
              out.write(hcell.onset.to_s[1] + ", " + hcell.offset.to_s[1] + ", " + hcell.event[1] + ", " +  hcell.yesno[1] + ", "  + hcell.how[1] + ", "+ 
                 hcell.onset.to_s[2] + ", " + hcell.offset.to_s[2] + ", " + hcell.event[2] + ", " +  hcell.yesno[2] + ", "  + hcell.how[2] + ", ")
           else
              out.write(hcell.onset.to_s[2] + ", " + hcell.offset.to_s[2] + ", " + hcell.event[2] + ", " +  hcell.yesno[2] + ", "  + hcell.how[2] + ", "+ 
                 hcell.onset.to_s[1] + ", " + hcell.offset.to_s[1] + ", " + hcell.event[1] + ", " +  hcell.yesno[1] + ", "  + hcell.how[1] + ", ")
        end
     end
  end
  out.write("\n")

end puts "Done!!!" end end