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 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: www.limesurvey.org/manual/LimeSurvey_1.8...layout_documentation , which is no longer useful.

If anyone can provide the up-to-date database schema, it will be extremely helpful.

Thanks!

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

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.

I tried this API and it works! Thanks a lot!

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!