Importing data from another vendor. Convert number answer to text


We have exported data from another survey vendor.  A few questions were of type:

Please rate us on this, with answers ranging from Excellent to Poor.  

We duplicated the survey in SG with the same answer values.  The export from the other vendor provides a number as the answer to these questions (ie 1 = Poor and 5 = Excellent).  The new SG survey expects the word when we import, not the number.

Is there any way to have the system translate the number into a word value as part of the import process?  We are currently using Find/Replace in Excel before importing the files but it is becoming quite tedious.

ccooke asked

    It sounds like you were using reporting values with the other provider.  The numbers that are reported in place of the text answers are reporting values, and sg has reporting values too.  You just need to define them in your survey.  That would be easier than doing the find/replace thing you’re doing in excel I would think.  If you don’t know how to set the reporting values in sg, the tutorial they have explains them pretty well here:

    Hope that helps!

    Chad Wilco answered


      Question stats

      • Active
      • Views3070 times
      • Answers1 answer
      • Followers0 followers