Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

[SOLVED] Export of non-anonymized survey

  • orsayman
  • orsayman's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
2 years 9 months ago #218158 by orsayman
Replied by orsayman on topic Export of non-anonymized survey
Sorry for the newbie question. Is there a guide for that ?

Or maybe I can simply change some settings directly the DB.
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 9 months ago #218159 by holch
Replied by holch on topic Export of non-anonymized survey
As Tpartner says, export the data you collected so far, to be safe (ideally in the format you will want it later for analysis). This is just to make sure if something goes wrong, you still have the data you collected so far. Merging two data files later is relatively simple.

Then you can deactivate the survey, change your settings and then reactivate your survey. Usually, you should be asked if you want to import the old data again.

But I you most probably won't have the date for those that have answered up to this day. Only from now onwards.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The topic has been locked.
  • orsayman
  • orsayman's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
2 years 9 months ago #218161 by orsayman
Replied by orsayman on topic Export of non-anonymized survey
Thanks. If I understand the export options, the LSA format is the best suited for that.
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 9 months ago #218162 by tpartner
Replied by tpartner on topic Export of non-anonymized survey
No, export the data not the survey.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 9 months ago #218163 by holch
Replied by holch on topic Export of non-anonymized survey
LSA exports both, the survey structure plus the answers. It is good to have this as backup, just in case.

However, you should also export the data as CSV for example. In the rare case that you are not able to "un-archive" the date when reactivating the survey, you have the survey data as CSV up to the moment of the deactivation.

Later you just export the rest and bring the data sets together into one. Easy peasy. ;-)

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The following user(s) said Thank You: tpartner, orsayman
The topic has been locked.
  • orsayman
  • orsayman's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
2 years 9 months ago #218350 by orsayman
Replied by orsayman on topic [SOLVED] Export of non-anonymized survey
Thanks. I was able to deactivate the survey, change the setting, reactivate the survey and import results.

The only glitch is that the response IDs are not conserved (the new ones are follows the old ones).
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 9 months ago #218351 by holch
Replied by holch on topic [SOLVED] Export of non-anonymized survey

The only glitch is that the response IDs are not conserved (the new ones are follows the old ones).


I don't understand this part. What do you mean with the new ones follow the old ones? For me this sounds about right, that the new responses that you collect after the reactivation start after the ones that you re-imported. Or did I understand you wrong?

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The topic has been locked.
  • orsayman
  • orsayman's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
2 years 9 months ago #218361 by orsayman
Replied by orsayman on topic [SOLVED] Export of non-anonymized survey
Before the deactivation, there was 36 responses whose IDs range fro m1 to 36. After re-import the IDs of the imported responses range from 37 to 72 (there is no new responses for now).
The topic has been locked.
  • orsayman
  • orsayman's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
2 years 9 months ago #218362 by orsayman
Replied by orsayman on topic [SOLVED] Export of non-anonymized survey
Just to be complete: I did not reimported the responses from the CSV file; I used the builtin functionality to "re-use" the archived response table.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 9 months ago #218369 by DenisChenu
Replied by DenisChenu on topic [SOLVED] Export of non-anonymized survey
Yes,

This is the issue with get from old table … i prefer to use VV for this issue.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • orsayman
  • orsayman's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
2 years 9 months ago #218372 by orsayman
Replied by orsayman on topic [SOLVED] Export of non-anonymized survey
OK. Not a great problem but I will keep it in mind for the next time.
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 9 months ago #218380 by holch
Replied by holch on topic [SOLVED] Export of non-anonymized survey

Before the deactivation, there was 36 responses whose IDs range fro m1 to 36. After re-import the IDs of the imported responses range from 37 to 72 (there is no new responses for now).


OK, now I understand. I don't think it is a big deal, but yes, it would be nicer if they would come back with their original IDs, if you use the ID for example to identify them.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose