22 Jul 2019 
Support Center » Knowledgebase » Opinio » Opinio usage » I need to make some changes to the survey after it was published. The survey contains responses. How do I do this?
 I need to make some changes to the survey after it was published. The survey contains responses. How do I do this?
Solution It is not possible to change questions of a survey containing respondents. This is because the structure of the survey is very closely linked to the response data. Therefore the access to editing questions is restricted. We are looking into this, and will try to find better ways to handle this.

There are two ways to work around this:

  • Make a copy of your survey (export/import), and then make the change on this survey. Then start publish this one instead. The problem with this approach is that you will now have 2 sets with data. The current version does not support merging of these (it is in the plans for a later release).
  • Make the changes directly to the database. MAKE SURE YOU MAKE A BACKUP OF YOUR DATABASE FIRST! You will need to know some SQL. But the basic idea is this - connect to your database with an SQL tool (most database engines comes with some kind of SQL interface). Then type this command:

    SELECT QuestionId, QuestionText from OPS_Question

    this will list all questions in the system. Find the question you want to edit, and note down the QuestionId. It is important that you write the correct number.

    Then run this command to make the update of your text (replace NNN with the ID return from the SQL statement above):

    UPDATE OPS_Question SET QuestionText = 'Your new text' WHERE QuestionId = NNN

    Restart your application server.


Article Details
Article ID: 1
Created On: 12 Aug 2003 03:37 PM

 This answer was helpful  This answer was not helpful

 Login [Lost Password] 
Email:
Password:
Remember Me:
 
 Search
 Article Options
Home | Submit a Ticket | Knowledgebase
Language:

Help Desk Software By Kayako SupportSuite v3.10.02