I have tried the excel translation...it works for some questions...but when i substitue the translated text in the ensligh colum and import again to Lime...it gives error importing....

it gives error importing.

Which error? Why don't you show it?

BUT:
Did you empty the first two columns?
You see, here is the questionID. In the database this is an autoincrement field to identify the question.
Therefore it has to be unique.
If you do not remove the values here you will get duplicated keys - and an error.

BTW: I saw that you used this stone-age, outdated "condition designer"
Don't do it. Use ExpressionScript! This is mightier,much more flexible and faster.

The good news: When you import the txt file, rhe conditions are transformed.

Joffm
 

I have used the excel TRANSLATE to change from english to dutch where language colum is NL for the general questions then for the choice cards of utrecht i have also tranlsated the tables html formt....this text file (tab separated) is let's say dutch translated....but when importing to lime it gives me this error 

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

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.

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. 

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.

how should i save it correctly using libreoffice?

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? 

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. 

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.