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 8 months ago #218150 by orsayman
Export of non-anonymized survey was created by orsayman
Hello,

We are running a non-anonymized survey (therefore, the completion date is stored in the Participants tab). However, when I export the answers (in CSV or other formats), only the dummy date (1980-01-01) is present. Is this a bug or did I miss something ?

Thanks in advance,
Mathieu

LimeSurvey version: Version 3.27.0+210525
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 8 months ago #218151 by tpartner
Replied by tpartner on topic Export of non-anonymized survey
Did you set the datestamp to be collected?

Notifications & data --> Date Stamp - manual.limesurvey.org/Notifications_%26_data#Date_Stamp

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
  • orsayman
  • orsayman's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
2 years 8 months ago #218153 by orsayman
Replied by orsayman on topic Export of non-anonymized survey
The setting is disabled but I can't enable it (it says " Responses will not be date stamped. Cannot be changed ").
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 8 months ago #218155 by holch
Replied by holch on topic Export of non-anonymized survey
You can't change that while the survey is active, I think.

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 8 months ago #218156 by orsayman
Replied by orsayman on topic Export of non-anonymized survey
OK... Is it possible to deactivate and reactivate a survey ?
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 8 months ago #218157 by tpartner
Replied by tpartner on topic Export of non-anonymized survey
Deactivating causes the data to be removed. Always download the data before deactivating so you can merge it later.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
  • orsayman
  • orsayman's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
2 years 8 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 8 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 8 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 8 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 8 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 8 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.

Lime-years ahead

Online-surveys for every purse and purpose