- Posts: 15
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Is it possible to change the setting "Date stamp" once a survey is active
- ictfinance
- Topic Author
- Offline
- New Member
Less
More
4 years 3 months ago #192267
by ictfinance
Is it possible to change the setting "Date stamp" once a survey is active was created by ictfinance
Hi,
I know that changing the setting "Date stamp" in an active survey is normally not possible. But I need to do it for the following reason:
We upgraded our instance of Limesurvey from version 1.92 to 3.18, in several steps. Migration went well: the database structure was appropriately upgraded.
But we face a very annoying problem: in the active surveys the answers were datestamped when running on the old version. But after the upgrade process they are not datestamped anymore. We can see in the survey settings that they are indeed not datestamped, and this value cannot be changed. The only way to change this setting is to inactivate the survey, then changing the setting, and re-activate it again. But then previous answers are archived. I tried this procedure, and re-imported answers after having re-activated the survey, but the datestamp info has gone. So I guess that datestamp info was not archived because the survey was set to not save this data.
If I export the answers before inactivating the survey and re-import them after re-activation, the problem is the same: datestamp info has gone.
It seems that the upgrade process didn't convert the setting for "date stamp" from the old version to the new one.
We host our own LS server, so I can access the database and the LS code. If anyone has a suggestion for changing the "date stamp" setting on active surveys, he's welcome.
best regards,
Pierre
I know that changing the setting "Date stamp" in an active survey is normally not possible. But I need to do it for the following reason:
We upgraded our instance of Limesurvey from version 1.92 to 3.18, in several steps. Migration went well: the database structure was appropriately upgraded.
But we face a very annoying problem: in the active surveys the answers were datestamped when running on the old version. But after the upgrade process they are not datestamped anymore. We can see in the survey settings that they are indeed not datestamped, and this value cannot be changed. The only way to change this setting is to inactivate the survey, then changing the setting, and re-activate it again. But then previous answers are archived. I tried this procedure, and re-imported answers after having re-activated the survey, but the datestamp info has gone. So I guess that datestamp info was not archived because the survey was set to not save this data.
If I export the answers before inactivating the survey and re-import them after re-activation, the problem is the same: datestamp info has gone.
It seems that the upgrade process didn't convert the setting for "date stamp" from the old version to the new one.
We host our own LS server, so I can access the database and the LS code. If anyone has a suggestion for changing the "date stamp" setting on active surveys, he's welcome.
best regards,
Pierre
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
4 years 3 months ago #192294
by DenisChenu
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.
Replied by DenisChenu on topic Is it possible to change the setting "Date stamp" once a survey is active
Question : did you have a direct access to the DB ?
If yes : you can
1. Check on lime_survey_XXXX if : startdate and datestamp exist : if not create as datetime
2. Control submitdate type : must be datetime
3. Set datestamp to Y in lime_surveys for this survey.
to control if datestamp is enable before upgrade : check if submitdate have real date or not.
If yes : you can
1. Check on lime_survey_XXXX if : startdate and datestamp exist : if not create as datetime
2. Control submitdate type : must be datetime
3. Set datestamp to Y in lime_surveys for this survey.
to control if datestamp is enable before upgrade : check if submitdate have real date or not.
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 following user(s) said Thank You: cdorin, ictfinance
The topic has been locked.
- ictfinance
- Topic Author
- Offline
- New Member
Less
More
- Posts: 15
- Thank you received: 0
4 years 3 months ago #192364
by ictfinance
Replied by ictfinance on topic Is it possible to change the setting "Date stamp" once a survey is active
Hi,
Thanks a lot for the answer. It works perfectly.
Best wishes for the new Year.
Pierre
Thanks a lot for the answer. It works perfectly.
Best wishes for the new Year.
Pierre
The topic has been locked.
- hugo2jusdado
- Offline
- New Member
Less
More
- Posts: 7
- Thank you received: 0
3 years 8 months ago #203001
by hugo2jusdado
Replied by hugo2jusdado on topic Is it possible to change the setting "Date stamp" once a survey is active
Hi,
I´ve tried to do this but still wrong. My version is 3.22.25.
Thanks,
Hugo
I´ve tried to do this but still wrong. My version is 3.22.25.
Thanks,
Hugo
The topic has been locked.
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12881
- Thank you received: 3965
3 years 8 months ago #203010
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Is it possible to change the setting "Date stamp" once a survey is active
What exactly did you do?
Did you follow the steps?
1. Check on lime_survey_XXXX if : startdate and datestamp exist : if not create as datetime
2. Control submitdate type : must be datetime
3. Set datestamp to Y in lime_surveys for this survey.
Joffm
Did you follow the steps?
1. Check on lime_survey_XXXX if : startdate and datestamp exist : if not create as datetime
2. Control submitdate type : must be datetime
3. Set datestamp to Y in lime_surveys for this survey.
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The following user(s) said Thank You: hugo2jusdado
The topic has been locked.
- hugo2jusdado
- Offline
- New Member
Less
More
- Posts: 7
- Thank you received: 0
3 years 8 months ago #203011
by hugo2jusdado
Replied by hugo2jusdado on topic Is it possible to change the setting "Date stamp" once a survey is active
Yes, I did.
First, add columns startdate and datestamp as datetime types.
Second, control submitdate as datetime type.
Third, change datestamp value to Y.
The only difference i am able to see is columns startdate anda datestamp would be created at the end instead of next to seed column.
May be it´s neccesary to restart or something like that for applying changes?
Thanks,
Hugo.
First, add columns startdate and datestamp as datetime types.
Second, control submitdate as datetime type.
Third, change datestamp value to Y.
The only difference i am able to see is columns startdate anda datestamp would be created at the end instead of next to seed column.
May be it´s neccesary to restart or something like that for applying changes?
Thanks,
Hugo.
The topic has been locked.
- hugo2jusdado
- Offline
- New Member
Less
More
- Posts: 7
- Thank you received: 0
3 years 8 months ago #203013
by hugo2jusdado
Replied by hugo2jusdado on topic Is it possible to change the setting "Date stamp" once a survey is active
I tried to restore original values in tables lime_surveys and lime_survey_xxxxx, and started again with the process. Now it works.
Thanks a lot,
Hugo.
Thanks a lot,
Hugo.
The topic has been locked.