Check out the LimeSurvey source code on GitHub!

how to change the anonymous survey to non-anonymous?

More
3 years 3 weeks ago #104393 by iscar
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 3 weeks ago #104398 by tpartner
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 3 weeks ago #104405 by iscar
after deactive old survey,is it possible to convert the old table to new?

Please Log in to join the conversation.

More
3 years 3 weeks ago #104406 by tpartner
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 3 weeks ago #104416 by holch
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 3 weeks ago #104425 by DenisChenu
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).

Please Log in to join the conversation.

More
3 years 3 weeks ago #104439 by iscar
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.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form