Empirisoft Support

    Welcome to Empirisoft Support
Results 1 to 6 of 6

Thread: Problems with responses.xls file (case 25302)

  1. #1
    Join Date
    Jul 2013
    Posts
    28

    Problems with responses.xls file (case 25302)

    I'm having trouble getting participants' previous responses to appear in follow-up questions. Would it be possible for you to review the attached .que and responses files and see if there is something I'm doing incorrectly?responses.xlsTEST.que
    Last edited by jason_reed; 11-08-2016 at 08:24 AM.

  2. #2
    Join Date
    Feb 2013
    Posts
    1,090
    Hi there,

    If I'm not mistaken, we dealt with and solved this exact problem before here in this thread:

    http://www.empirisoft.com/support/sh...ighlight=cam15

    The solution there seemed to be using names for the items in the responses.xls file with the Excel formulas with the text that are different from any of the item names in the .que file. Did you try that yet with the current files?
    Jason Reed
    Empirisoft Software Support Specialist

  3. #3
    Join Date
    Jul 2013
    Posts
    28

    Response to feedback from previous thread

    Hi Jason,

    If you take a look at the responses.xls file I attached, I do have the variables names and equations in the file.

    The TOBdsm11a is the first question. The items TOBdsm11a_01 through TOBdsm11a_07 are the response options, which are coded '0' and '1' in the output. The new variable names are TOBdsm11a01 through TOBdsm11a07, which have the equations in the "value" column.

    The second question is similar, with ALCdsm11a the original question, ALCdsm11a_01 through ALCdsm11a_09 as response options, and ALCdsm11a01 through ALCdsm11a09 as the variables with equations to display the answer.

    I copied the previous version of this questionnaire's responses.xls and edited it for this questionnaire so I'm not sure where I'm going wrong here.

  4. #4
    Join Date
    Feb 2013
    Posts
    1,090
    When I said different names, I meant using names in the responses.xls file that are completely different than anything item names from the .que file. For example, instead of TOBdsm11a01 use a name like new1 or a1. Did you try that yet? I ask because it seemed to work that way the first time we encountered this issue.
    Jason Reed
    Empirisoft Software Support Specialist

  5. #5
    Join Date
    Jul 2013
    Posts
    28

    Response to previous post

    Quote Originally Posted by jason_reed View Post
    When I said different names, I meant using names in the responses.xls file that are completely different than anything item names from the .que file. For example, instead of TOBdsm11a01 use a name like new1 or a1. Did you try that yet? I ask because it seemed to work that way the first time we encountered this issue.

    I changed the variable names to ones that were not similar to those previously used and the files are now working properly. Thanks for the help!

  6. #6
    Join Date
    Feb 2013
    Posts
    1,090
    Thanks for the update that everything is working!
    Jason Reed
    Empirisoft Software Support Specialist

Similar Threads

  1. problems with directRT input file (case 17696)
    By shimrit in forum MediaLab v2018: Troubleshooting
    Replies: 7
    Last Post: 01-15-2015, 11:10 AM
  2. how to make a responses file
    By kaylamart09 in forum MediaLab Older Versions: How Do I...
    Replies: 0
    Last Post: 10-26-2011, 01:25 PM
  3. problems with bat-file
    By moritz in forum MediaLab Older Versions: General Questions
    Replies: 3
    Last Post: 10-27-2010, 11:06 PM
  4. How do you create your responses.xls file?
    By emat in forum MediaLab Older Versions: How Do I...
    Replies: 0
    Last Post: 12-15-2009, 06:10 PM
  5. Responses xls file
    By clare66 in forum MediaLab Older Versions: General Questions
    Replies: 0
    Last Post: 09-15-2009, 01:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •