Automate translations in LimeSurvey - Save Time in translating surveys

More
4 years 19 hours ago - 4 years 19 hours ago #98306 by ajparag
ajparag created the topic: Automate translations in LimeSurvey - Save Time in translating surveys
Follow this procedure to translate all surveys in the desired language quick and easy

Step 1: Setup LimeSurvey

A. Install all new fonts in the Computer/ Server
B. Add language folders in ~\htdocs\locale
C. Go to ~\htdocs\application\helpers and insert commands for the desired languages in SurveyRuntimeHelper.php
D. Go to ~\ htdocs\third_party\ckeditor\_source\plugins\font and edit Plugin.js file using notepad++. Press ctrl+f and search for ‘verdana’. Add all the fonts that you have installed in step A.
E. Go to ~\htdocs\third_party\ckeditor and edit ckeditor.js file using notepad++. Press ctrl+f and search for ‘verdana’. Add all the fonts that you have installed in step A.
Note: Step 1 is to be performed only once. You can skip this step for all subsequent projects.

Step 2: Export Survey

A. Export your Survey in .txt (UTF-8 format).
B. Open the .txt file in excel.

Step 3: Import Translations

A. Look for the language code in the .txt file. Copy all ‘en’ entries of the questions (with their respective answer options) on a new excel sheet.
B. Now open the translated excel sheet shared by the client and perform vlookup. Check for errors and incomplete translations.
C. Once all translations are done, copy the translated entries and paste them in automated translations.xlsx sheet.
D. Final step. Now, copy the output generated from the automated translations.xlsx sheet and paste it in the .txt file.

Step 4: Save and Upload

A. Save the .txt file in the same format i.e. Tab Delimited.
B. Now open LimeSurvey and Import the survey.

You have just translated your complete questionnaire!
Attachments:
Last Edit: 4 years 19 hours ago by ajparag.
The following user(s) said Thank You: Mazi, first

Please Log in to join the conversation.

More
4 years 12 hours ago #98314 by Mazi
Mazi replied the topic: Automate translations in LimeSurvey - Save Time in translating surveys
Please add this information to our manual at manual.limesurvey.org/Workarounds:_Furth..._by_LimeSurvey_users .
The forum is cleaned up regularly, so sooner or later your valuable solution might get lost. Therefore, the manual is the better place.

Thanks!


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

More
3 years 11 months ago #98333 by DenisChenu
DenisChenu replied the topic: Automate translations in LimeSurvey - Save Time in translating surveys
Hello,
Why first step ? New fonts are not necessary.

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
3 years 11 months ago #98349 by ajparag
ajparag replied the topic: Automate translations in LimeSurvey - Save Time in translating surveys
For languages like Hindi, urdu, chinese, etc. that have a different form of writing script, it is recommended (by me) that the scripter installs it in LimeSurvey.

Please Log in to join the conversation.

More
3 years 11 months ago #98378 by DenisChenu
DenisChenu replied the topic: Automate translations in LimeSurvey - Save Time in translating surveys
Oh, think :

1st : i rarely use HTML editor (need to track this).
2nd: i use GNU/Linux workstation and default caracter set are realy in utf8.


I think it's a good feature request : can write directly in Hindi, urdu, chinese, in all browser : think there are already some fonts on ls core.

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
3 years 8 months ago #101635 by first
first replied the topic: Automate translations in LimeSurvey - Save Time in translating surveys
I have few queries in step 1,

Point C:-Do I need to edit file "SurveyRuntimeHelper.php" or surveytranslator_helper.php in ~\htdocs\application\helpers directory


Point D and E:-I don't see folder "ckeditor" in ~\ htdocs\third_party\ directory.

Thanks

Survey Designer and Programmer

Please Log in to join the conversation.

Did you already participate in our customer survey?

Don't miss your chance for great prices.

Please click here to participate:

Start now

Start now!

Just create your account and start using Limesurvey today.

Register now