Welcome to the LimeSurvey Community Forum

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

Automating .LSS Survey Translation to Multiple Languages (German, French, etc.)

More
2 months 1 week ago #270742 by danielaarias25
This is my complete finished english survey in (.txt) and (.lss)....and I have a few days to find a way to translate it into: Dutch, German, Hungarian, French and Flemish. What will you do? I want to cry xD

Please Log in to join the conversation.

More
2 months 1 week ago #270744 by Joffm
Pragmatic way to check:
Removed the dutch part -> everything is fine.
So you have to revise this.

Furthermore: At first sight I saw some strange characters in the file (e.g. 8085 - 8121)

But there were still values in the first columns in your "last.txt"
 

Joffm

I saw your next post.
Later I will have a look at it.

Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in to join the conversation.

More
2 months 1 week ago #270745 by danielaarias25
Attached is the text file of the survey I have been working more recently. Ths one has the translations into all the languages form excel...But when I import the survey I get the screenshot error....I dont know what I did wrong. 

Please Log in to join the conversation.

More
2 months 1 week ago #270746 by holch
My first guess would be that you did not save the file in the right format. TXT files are not created equal.

In Excel you can save TXT files in different formats. I see a lot of special characters (in German and in Hungarian) are substituted with weird symbols.

How did you save the file from excel to TXT? Unicode? All in all, Excel is always tricky when it comes to CSV and TXT files. We usually recomment to use Openoffice or Libreoffice, as it tends to export better flat files.

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.

Please Log in to join the conversation.

More
2 months 1 week ago #270747 by danielaarias25
how should i save it correctly using libreoffice?

Please Log in to join the conversation.

More
2 months 1 week ago #270749 by danielaarias25
Ok...I have tranlsated all the survey....but the import doesnt work. ON the other hand i have a working import file but is not translated....so i zipped both to see if enayone can help me to see the difference between them (besides translatons being done)....about formating and why i keep getting this error. I tried opening up in lbreoffice and saving with the unicode format...but  dont know how to do it>..can somebody do the formatting fix? 

Please Log in to join the conversation.

More
2 months 1 week ago #270757 by danielaarias25
I am having an euroka moment here!!! 

I managed to translate all using excel and solved the unicode formatting and the import worked!!! thank you all for helping me in such a fast manner. I am crying of happiness. 

Please Log in to join the conversation.

More
2 months 1 week ago #270762 by holch

I am having an euroka moment here!!! 

This is great! Congratulatins.

I managed to translate all using excel and solved the unicode formatting and the import worked!!! 

If you could describe the steps that were finally sucessful, this would for sure help others that come to the forum with the same challenge.

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.

Please Log in to join the conversation.

Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose