how to change the anonymous survey to non-anonymous?

More
3 years 9 months ago #104393 by iscar
iscar created the topic: how to change the anonymous survey to non-anonymous?
i already actived some anonymous survey. and now i plan to use non-anonymous type.
how to swith it? in mysql?

Please Log in to join the conversation.

More
3 years 9 months ago #104398 by tpartner
tpartner replied the topic: how to change the anonymous survey to non-anonymous?
You cannot do that without deactivating the survey. Note that deactivating the survey will reset the data.

Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

More
3 years 9 months ago #104405 by iscar
iscar replied the topic: how to change the anonymous survey to non-anonymous?
after deactive old survey,is it possible to convert the old table to new?

Please Log in to join the conversation.

More
3 years 9 months ago #104406 by tpartner
tpartner replied the topic: how to change the anonymous survey to non-anonymous?
Sorry, I can't offer a safe opinion about that.


.

Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

More
3 years 9 months ago #104416 by holch
holch replied the topic: how to change the anonymous survey to non-anonymous?
I think it is possible, but I wouldn't want to risk a 'go for it'.

Before you do anything, just export the survey results.

At the end of the day you will want to analyse in a external software anyway, right? You can just join the results there. If you don't change anything regarding questions, etc. this should be simple.

Now for the token tables there is an option to get the token table back into the survey. I don't know if this is possible with results tables. But I think there was an option for this. Try it with a small test survey. But ALWAYS, even if it works for the test survey, expect the unexpected. So download the results that you collected so far.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

More
3 years 9 months ago #104425 by DenisChenu
DenisChenu replied the topic: how to change the anonymous survey to non-anonymous?
You can not "get the old table' if something are changed in the survey.

Here, after save all like hlch say, and without any guarantee, you can
- Deactivate the survey
- Set anonymous to true
- Reactivate the survey
- In the old token table (phpMyAdmin access) : Add the column 'Token' like the new table
- Go to ls admin, response, and click the button to reload response from a old survey table.

It can do the trick.

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
3 years 9 months ago #104439 by iscar
iscar replied the topic: how to change the anonymous survey to non-anonymous?
i did it as below steps:
1.insert old survey_xxx_old table value into new table
2.insert ole survey_timing_old table value into new table
3.set new table token value to NULL.
4.set new table order by id
5.delete old survey_xxx_old,survey_timing_old table

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!