I need to make some changes to the survey after it was published. The survey contains responses. How do I do this?
Article Details
URL:
https://support.objectplanet.com/esupport/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=1
Article ID:
1
Created On:
12 Aug 2003 09:37 AM
Answer
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.