Welcome to the LimeSurvey Community Forum

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

Bulk translate prefixes and suffixes?

  • misterdot
  • misterdot's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 7 months ago #123568 by misterdot
Bulk translate prefixes and suffixes? was created by misterdot
Reposting to this category - I originally posted to the Installation & update issues category by mistake: www.limesurvey.org/en/forum/installation...refixes-and-suffixes

I've got a fairly long survey that I'm designing for English and Arabic in several countries. My process has been to create one survey then duplicate it, making small changes to localize it to each country. I've been able to do bulk changes by searching for strings in the database and replacing them. For example, this query replaces "dinar" with "riyal" wherever it occurs in an answer:
UPDATE limesurvey.lime_answers SET answer = REPLACE(answer, 'دينار', 'ريا') where answer like '%دينار%' and language = 'ar' and qid >= 12880

That has worked well for everything except prefixes and suffixes, which look like they need to be entered manually in the advanced question settings. I have numeric questions where I'd like to have the suffix be the local currency. Is there a way to do something similar to translate suffixes?
Thanks!
Matt
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose