New Translation System

[MixMan]

Here you go. It is PAINFULLY slow, but it goes through all the rows. I turned off screen updating, so you won't see the data until it is finished. It displays a message box saying "Done" when it completes. Let me know if this isn't what you were looking for.

Many, many thanks.
It works very well.
Wish I hade this macro years ago.
It would have saved me days of copy and pasting cell values.
It didn't take me many minutes to import the translation updates that I have recieved.
Aslo got new Portugese translations.

[dhgb256]

Glad it worked, let me know if you need help with anything else.

[MixMan]

I would like to have some of you who has translated in the past, testing the new translation system. It would be good to know how it works.

Send me a PM if you are interested

[dfdario]

Here is the file I currently use on my system.

[Mr. Camaro]

You don't need a macro to do this. You can use VLOOKUP and the values will instantly come over to the sheet. I've attached an example to show you.

The code is simple, this is from cell B1 on the spreadsheet.

Code:

=IFERROR(VLOOKUP(A1,Data!A:L,2,FALSE),"")

The only problem with the above code is "IFERROR" does not work in Excel 2003. The "ISERROR" is used to prevent "N/A" from showing up in the sheet where there is no data.

Code:

=IF(NOT(ISNA(VLOOKUP(A1,Data!A:L,2,FALSE))),VLOOKUP(A1,Data!A:L,2,FALSE),"")

The above is more complicated but will work in all versions of excel.

Is this what you are trying to do? If I knew exactly what you wanted to do I can modify this a bit to help you. For example it would be easy to have several columns of languages in Sheet2, and then add a drop-down or something in Sheet1 where you could select the language that you want to copy over. It would also be easy to generate a XML file like the one in the post above by just selecting the language that you want and clicking a button.

[MixMan]

You don't need a macro to do this. You can use VLOOKUP and the values will instantly come over to the sheet. I've attached an example to show you.

The code is simple, this is from cell B1 on the spreadsheet.

Code:

=IFERROR(VLOOKUP(A1,Data!A:L,2,FALSE),"")

The only problem with the above code is "IFERROR" does not work in Excel 2003. The "ISERROR" is used to prevent "N/A" from showing up in the sheet where there is no data.

Code:

=IF(NOT(ISNA(VLOOKUP(A1,Data!A:L,2,FALSE))),VLOOKUP(A1,Data!A:L,2,FALSE),"")

The above is more complicated but will work in all versions of excel.

Is this what you are trying to do? If I knew exactly what you wanted to do I can modify this a bit to help you. For example it would be easy to have several columns of languages in Sheet2, and then add a drop-down or something in Sheet1 where you could select the language that you want to copy over. It would also be easy to generate a XML file like the one in the post above by just selecting the language that you want and clicking a button.

Thank you presenting this solution. I tested it and it works.
But I preferr the macro solution, since I will pull in translations from several sheets to build the translation for the new system.
I have sent the sheet with macros to dhgh256. He will take a look at it, to see if it is possible to minimize the all the copy and pasting I have to do now.

[MixMan]

I am building an updated Excel sheet with new strings for plugins.

I have added all strings for Music and CD plugins.

Any other plugins strings that should be added, please post strings.

[MixMan]

Here is the file I currently use on my system.

Thanks, but the translation I had some more strings translated.
Must have gotten it from somebody else.
Anyway I combined both translations. You might have to adjust some strings.

[MixMan]

Thanks to dhbg256 that helped with the excel macro and mvallevand, that made string converstion utility.
We now has a working easy to use translation function.
I have ported all old translations into the "system" and strings that where not translated, I had Google translate.
I have also made it possible to translate languages that didn't have any translations earlier, but they are all Google translations.
But they might be good anyway, and it should definatly be easier, than doing the translation from scratch.

Go and have a look at:
http://gbpvr.com/pmwiki/pmwiki.php/Manual/Translation

There will be more that 50 languages translatable. Current are:

*Afrikaans
*Albanian
*Arabic
*Belarusian
*Bulgarian
*Catalan
*Chinese (Simple)
*Chinese (Traditional)
*Czech
*Croatian
*Danish
*Dutch
*English
*Estonian
*Farsi
*Filipino
*Finnish
*French
*Galician
*German
*Greek
*Hausa
*Hebrew
*Hindi
*Hungarian
*Icelandic
*Indonesian
*Irish
*Italian
*Japanese
*Korean
*Latvian
*Lithuanian
*Macedonian
*Malay
*Maltese
*Norwegian
*Pashto
*Polish
*Portuguese
*Portuguese (Brazil)
*Romanian
*Russian
*Serbian
*Slovak
*Slovenian
*Spanish
*Spanish (Mexico)
*Swahili
*Swedish
*Thai
*Turkish
*Ukrainian
*Vietnamese
*Yiddish

[MixMan]

Just uploaded the last batch of languages to the wiki.
The zip now contains 55 translatable languags.
*Afrikaans
*Albanian
*Arabic
*Belarusian
*Bulgarian
*Catalan
*Chinese (Simple)
*Chinese (Traditional)
*Czech
*Croatian
*Danish
*Dutch
*English
*Estonian
*Farsi
*Filipino
*Finnish
*French
*Galician
*German
*Greek
*Hausa
*Hebrew
*Hindi
*Hungarian
*Icelandic
*Indonesian
*Irish
*Italian
*Japanese
*Korean
*Latvian
*Lithuanian
*Macedonian
*Malay
*Maltese
*Norwegian
*Pashto
*Polish
*Portuguese
*Portuguese (Brazil)
*Romanian
*Russian
*Serbian
*Slovak
*Slovenian
*Spanish
*Spanish (Mexico)
*Swahili
*Swedish
*Thai
*Turkish
*Ukrainian
*Vietnamese
*Yiddish

Go ahead and translate !!!