Pygaze TSV File - Tobii Pro SDK

Comments

• heliocuve

  March 2019

  Sorry the photos where not attached to the post.

  here is the example of the problem

  

  this is how a similar message should be logged

  

  and the column labels

  

  
  
• Damien

  March 2019

  Hello,

  I am sorry, I can't help. I just post because I am facing exactly the same problem with X3-120 Tobii tracker... And yes, it seems quite difficult to correct that through a script (I am currently trying in VBA).

  I am also curious to know the reasons of this.

  Best regards,

  Damien
• Damien

  March 2019

  Hello,

  While waiting the issue is solved, I have created a small VBA (Excel ; sorry ! :) ) program that seems to handle this problem. I am definitly not an expert, so the program is probably not optimal, and it likely contains some bugs (though, as far as I know, it worked well for me). I provide it as such as it might help.

  Sub modif_Tobii_OS_errors()
  
      Dim var_cell As Object
      Dim string_to_modify As String
      Dim num_line_error As Long
      Dim num_column_error As Long
      Dim last_line As Long
      Dim c As Range
      
      last_line = Cells(100000, "A").End(xlUp).Row                            'determine the last row of the table
      num_line_error = Cells(1, 1).End(xlDown).Row                            'find the first problem row (i.e. with first cell empty)
      
      While num_line_error < last_line
             
          'find the problematic cell in the row (i.e. containing "var", or "start" or "stop")
          Set var_cell = Rows(num_line_error).Find("var")
          If var_cell Is Nothing Then
              Set var_cell = Rows(num_line_error).Find("start")
              If var_cell Is Nothing Then
                  Set var_cell = Rows(num_line_error).Find("stop")
              End If
          End If
          
          num_column_error = var_cell.Column - 1
          string_to_modify = Cells(num_line_error, num_column_error)
      
          'move temporarily the second line cells on the right
          Range(Cells(num_line_error + 1, num_column_error + 1), Cells(num_line_error + 1, 14)).Value _
                  = Range(Cells(num_line_error + 1, 2), Cells(num_line_error + 1, 15 - num_column_error)).Value
          Range(Cells(num_line_error + 1, 2), Cells(num_line_error + 1, 15 - num_column_error)).ClearContents
          
          'Determine the "normal" length of the cell to modify (I check the cell just above, which is a bit hazardous, but I did not found a better way...)
          len_string = Len(Cells(num_line_error, num_column_error).End(xlUp))
          'and then move the "excess" toward the second line first cell
          Cells(num_line_error + 1, 1) = Right(string_to_modify, Len(string_to_modify) - len_string)
          'and clear it
          Cells(num_line_error, num_column_error) = Left(string_to_modify, len_string)
          
          'Move the "var" cell content
          Cells(num_line_error + 1, 2) = Cells(num_line_error, num_column_error + 1)
          Cells(num_line_error, num_column_error + 1).ClearContents
          
          'move definitly the second line cells on the top (first line)
          Range(Cells(num_line_error, num_column_error + 1), Cells(num_line_error, 14)).Value _
                  = Range(Cells(num_line_error + 1, num_column_error + 1), Cells(num_line_error + 1, 14)).Value
          Range(Cells(num_line_error + 1, num_column_error + 1), Cells(num_line_error + 1, 14)).ClearContents
          
          'Go to the next problematic line
          num_line_error = Cells(num_line_error + 2, 1).End(xlDown).Row
              
      Wend
      
  End Sub
  

  Now, I will try to automatize the modification of several files at once.

  @heliocuve please tell me if it helps and works for you. Please also tell me if you have news !

  Cheers,

  Damien
• Damien

  March 2019

  Hello,

  While waiting the issue is solved, I have created a small VBA (Excel ; sorry ! :) ) program that seems to handle this problem. I am definitly not an expert, so the program is probably not optimal, and it likely contains some bugs (though, as far as I know, it worked well for me). I provide it as such as it might help.

  Sub modif_Tobii_OS_errors()
  
      Dim var_cell As Object
      Dim string_to_modify As String
      Dim num_line_error As Long
      Dim num_column_error As Long
      Dim last_line As Long
      Dim c As Range
      
      last_line = Cells(100000, "A").End(xlUp).Row                            'determine the last row of the table
      num_line_error = Cells(1, 1).End(xlDown).Row                            'find the first problem row (i.e. with first cell empty)
      
      While num_line_error < last_line
             
          'find the problematic cell in the row (i.e. containing "var", or "start" or "stop")
          Set var_cell = Rows(num_line_error).Find("var")
          If var_cell Is Nothing Then
              Set var_cell = Rows(num_line_error).Find("start")
              If var_cell Is Nothing Then
                  Set var_cell = Rows(num_line_error).Find("stop")
              End If
          End If
          
          num_column_error = var_cell.Column - 1
          string_to_modify = Cells(num_line_error, num_column_error)
      
          'move temporarily the second line cells on the right
          Range(Cells(num_line_error + 1, num_column_error + 1), Cells(num_line_error + 1, 14)).Value _
                  = Range(Cells(num_line_error + 1, 2), Cells(num_line_error + 1, 15 - num_column_error)).Value
          Range(Cells(num_line_error + 1, 2), Cells(num_line_error + 1, 15 - num_column_error)).ClearContents
          
          'Determine the "normal" length of the cell to modify (I check the cell just above, which is a bit hazardous, but I did not found a better way...)
          len_string = Len(Cells(num_line_error, num_column_error).End(xlUp))
          'and then move the "excess" toward the second line first cell
          Cells(num_line_error + 1, 1) = Right(string_to_modify, Len(string_to_modify) - len_string)
          'and clear it
          Cells(num_line_error, num_column_error) = Left(string_to_modify, len_string)
          
          'Move the "var" cell content
          Cells(num_line_error + 1, 2) = Cells(num_line_error, num_column_error + 1)
          Cells(num_line_error, num_column_error + 1).ClearContents
          
          'move definitly the second line cells on the top (first line)
          Range(Cells(num_line_error, num_column_error + 1), Cells(num_line_error, 14)).Value _
                  = Range(Cells(num_line_error + 1, num_column_error + 1), Cells(num_line_error + 1, 14)).Value
          Range(Cells(num_line_error + 1, num_column_error + 1), Cells(num_line_error + 1, 14)).ClearContents
          
          'Go to the next problematic line
          num_line_error = Cells(num_line_error + 2, 1).End(xlDown).Row
              
      Wend
      
  End Sub
  

  Now, I will try to automatize the modification of several files at once.

  @heliocuve please tell me if it helps and works for you. Please also tell me if you have news !

  Cheers,

  Damien
• heliocuve

  March 2019

  Hi @Damien

  
  

  thanks so much for this, it's really cool that this solution works for you. I will try it tomorrow once I get to the lab and will let you know.

  
  

  Cheers,

  Helio
• Edwin

  June 2019

  Thanks for the workaround, @Damien!

  The issue should now be resolved. See here for details: https://github.com/esdalmaijer/PyGaze/issues/123
• Art

  October 2019

  @heliocuve Sorry if the question is lame, but how did you get event names logged alongside the start_recording timestamps?
• heliocuve

  October 2019 edited October 2019

  Hi @Art if you want it together with start and stop messages, if you have defined the variable in your loop table for instance called stimuli_name, then just add [stimuli_name] after the start_trial status message that is sent in the pygaze_start_recording

  Alternatively, if you want to log it separately from the start_recordig item, you could simply use the pygaze_log item and deactivate the "automatically log all variables options" and in the log message field put [stimuli_name] or whatever it is you want to log.Cheers

  Helio
• Art

  October 2019

  Great, thanks!
• Paula

  June 2021

  Hi! I just wanted to say that I still get this logging issue... anybody else experiencing it with Tobii?