I successfully translated the English file into Dutch today, it took me about two hours to figure it out.
Here is what I did. You need to use the following programs, MS Word, Excel and Wordpad .. and maybe a PHP editor the one i use you can find here : http://notepad-plus-plus.org/
Export your english language file from boonex to a .txt file.
Open the .TXT file with wordpad.
1) replace ALL => symbols with ËÄË
SELECT MATCH CASE
and save the file as lang1.txt
Start Excel, and open lang1.txt ... a dialog box will open, TEXT IMPORT WIZZARD.
Select Delimited and click next, in the next screen you have to select Other, make sure you did not selected anything else. We are going to use the ËÖË codes to seperate the code from each other.
Type in at other Ë .. this will seperate the text and make two columns, and you will also see that Ä will be put in its seperate row.
Example of a row:
| A | B | C | |
| 1 | 'Name' | Ä | 'nl', |
Now the tricky part will come .. we must remove all the ' - signs, its at the beginning of the text, in the middle and at the end.
Step 1
First remove all PHP code \'
Select entire row C from the first to the last. Its important to only select row C, because ROW A must NOT CHANGE!
Now CTRL+F .. this will open the find/replace dialog box
go to the replace tab, and type at "find what" exactly this (\') (all the text between the brackets, SO DO NOT INCLUDE the brackets)
and type at replace with: ë .. SMALL ë not the big Ë ! very important.
SELECT MATCH CASE
Now click at replace all .. all PHP code for astrophe are replaced with ë
Step 2
Select entire row C again
if dialog is closed, do CTRL+F again,
find what : ' .. this single astrophen .. no spaces, nothing before or after .. just the '
Replace with : ËÖË
Step 3
Select entire ROW C again
Now we must delimit entire row C again. So find in your version of Excel "TExt TO Columns" (in office 2010 its under tab DATA)
Dialog box will open, select Delimeted click next
select OTHER .. and as symbol Ë ..
SELECT MATCH CASE and then click finish
If all went well, you have this now;
| D | E | F | G | |
| 1 | Ö | nl | Ö | , |
In column D .. the letter Ö
in Column E the english text
in column F another Ö
and finally the comma.
All good? okay lets translate.
Translation is done via google, because its a huge file you cannot translate it at once, you need to break it in 2 or 3 parts. I did in two parts.
IN the English file i translated, there are about 3000 rows. select the first 1500 rows, of ROW E only, the row with the english text that we want to translate.
Copy this, and paste in a new notepad. Save this file as LANG2.txt
Go back to excel, select row 1500 - till the end .. copy .. and paste in a new notepad, save as file LANG3.txt
Now upload those files to your webserver, and go to google. And translate both files.
When all is done, copy the text from your webbrowser back to excel .. copy them over the ENGLISH ROW that you want translated.
if you have done this, you are almost done.
You must delete all the astrophen out of the translated language .. so select the entire translated row, and CTRL+F .. find ' <-- the astrophen, replace with ë ..SMALL ë !!!
We have to put the code back together ...
Copy the entire EXCEL sheet into a new wordpad file.
CTRL+F .. find and replace MATCH WHOLE CASE !!
Find Ä .. replace with =>
Ctrl+F again
Find : Ö replace with ' <-- the astrophen. MATCH WHOLE CASE !!
CTRL+F ..
find </ a> replace with </a> for some reason google puts a space in these codes between the / and the 'a' , there are a few more .. so check the HREF html code etc.
Copy paste entirely to MS WORD
Find and replace ^t .. we are going to remove all TABS .. replace with nothing.
Save as .txt file ..
You have almost your translated file. Notepad, word and wordpad .. they put some code before the text and after it.. so we need a PHP editor to remove this.
Find a PHP editor ,, i gave a link, open the text file .. now remove all spaces before (most likely row 1 is a blank line and the last line is blank too) remove those
save as
lang_lang.php
upload to Boonex
voila.
