- Posts: 4
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Can I edit end messages of surveys in batches?
- yongzhengqi
- Topic Author
- Offline
- New Member
Less
More
4 years 8 months ago #187052
by yongzhengqi
Can I edit end messages of surveys in batches? was created by yongzhengqi
Hi!
I've created more than 2,000 surveys by Remote Control API.
But now, I found out that the end message of each survey is wrong. So I have to find a way to edit end messages in batches.
I went through the Remote Control APIs but found no one helps. So if there's any other way out?
Thanks!
I've created more than 2,000 surveys by Remote Control API.
But now, I found out that the end message of each survey is wrong. So I have to find a way to edit end messages in batches.
I went through the Remote Control APIs but found no one helps. So if there's any other way out?
Thanks!
The topic has been locked.
- yongzhengqi
- Topic Author
- Offline
- New Member
Less
More
- Posts: 4
- Thank you received: 0
4 years 8 months ago #187053
by yongzhengqi
Replied by yongzhengqi on topic Can I edit end messages of surveys in batches?
I tried to modify the database directly, but the database is just too large. I waited for more than one hour for REHASH, and it didn't work out.
I found this out-of-date schema description: manual.limesurvey.org/LimeSurvey_1.8_dat...layout_documentation , which is no longer useful.
If anyone can provide the up-to-date database schema, it will be extremely helpful.
Thanks!
I found this out-of-date schema description: manual.limesurvey.org/LimeSurvey_1.8_dat...layout_documentation , which is no longer useful.
If anyone can provide the up-to-date database schema, it will be extremely helpful.
Thanks!
The topic has been locked.
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12880
- Thank you received: 3964
4 years 8 months ago #187058
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Can I edit end messages of surveys in batches?
If you have access to the database, so the following update sql should do it:
"UPDATE lime_surveys_languagesettings SET surveyls_endtext="myNewEndMessage" WHERE surveyls_survey_id=[surveyID] and surveyls_language=[languageCode]"
This is what you see in the database description and in phpMyAdmin or a similar tool.
Joffm
"UPDATE lime_surveys_languagesettings SET surveyls_endtext="myNewEndMessage" WHERE surveyls_survey_id=[surveyID] and surveyls_language=[languageCode]"
This is what you see in the database description and in phpMyAdmin or a similar tool.
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The following user(s) said Thank You: DenisChenu
The topic has been locked.
- Bigred01
- Offline
- Premium Member
Less
More
- Posts: 88
- Thank you received: 33
4 years 8 months ago #187060
by Bigred01
Replied by Bigred01 on topic Can I edit end messages of surveys in batches?
Have you tried set_language_properties? This looks to take an array of properties you want to update and the end text is stored in the language settings table. I have not tested this, but its worth a look.
The topic has been locked.
- yongzhengqi
- Topic Author
- Offline
- New Member
Less
More
- Posts: 4
- Thank you received: 0
4 years 8 months ago #187063
by yongzhengqi
Replied by yongzhengqi on topic Can I edit end messages of surveys in batches?
I tried this API and it works! Thanks a lot!
The topic has been locked.
- yongzhengqi
- Topic Author
- Offline
- New Member
Less
More
- Posts: 4
- Thank you received: 0
4 years 8 months ago #187064
by yongzhengqi
Replied by yongzhengqi on topic Can I edit end messages of surveys in batches?
I tried this command as well, and it works perfects. Though I chose to finish my job with API for it's safer, thank you a lot! You've been greatly helper!
The topic has been locked.