A little confused about language keys

As posted in another thread, I have cloned a site but will still want to import language key settings.   I use just English, but I make lots of changes to the language keys as I don't like many of the terms Dolphin uses as I am working on business sites an it has a dating site legacy. I don't want to have to make these changes in both sites if I can avoid it, but I am not clear on what the different language tables do.   Is this all off them?:

sys_localization_categories
sys_localization_keys
sys_localization_string_params
sys_localization_strings

Which table do I need to import and restore to clone my language string settings?  All of those?  Is there anything I need to do besides recompiling the language after the restore?

Thanks

Rob

Oh come on, someone must know this here.   To transfer my string definitions from one site to another, do I need to "restore" all these tables?   I'm not ever sure what the "_categories" and the "_string_params" tables are.    Could someone give me a clue on this.

Thanks

Rob

3 if them at least.

When you add a language key, your asked to place it in a catagory. Such as System which is the default if you don't select a different one.

The categories are stored in sys_localization_categories.

That category is referenced in sys_localization_keys which stores the keys and the category it belons to.

And sys_localization_strings holds the strings for each defined key and also has a reference to the language.

I do not know what sys_localization_string_params is, and mine is empty so i think you can skip that one. But the other 3 are needed.

Sorry to bump this old post, but I was trying to do the same thing tonight.  Suppose I haven't added any custom categories, and I just want to transfer language keys from one site to another - would transferring the "sys_localization_strings" suffice?  The reason I don't want to get involved with the categories, is that I have just paired down the country table, and I don't want it to get rebuilt.

Unlikely.

System is the category for the main system language keys, however each module has its own category and third-party modules also are in their own category.

So you will most likely need all of them

Ok, thanks Deano.   Maybe it would be easier to just wait till the next upgrade and then replace the one English language file - that would update everything, right?

The one english language file? Explain.

If you're refering to the language file in the lang folder, that is basically just a cache file of the languages. Generated when the language is compiled. So replacing that file will be of no use as it will get over written when the languages are recompiled.

If you need to preserve all your keys, your really need a database export.

Deano,  the very last step of the upgrade procedure says the following:

NOTE: You can also update your custom language translations if you create the appropriate translated files for your custom language, BEFORE THE UPGRADE PROCESS, in upgrade/files/7.0.3-7.0.4/ and upgrade/files/7.0.3-7.0.4/modules/*/ directories. There arelang_en.php files by default in these directories. Create a translated copy of lang_en.php for your custom language. For example, if you have the Russian language installed you can add lang_ru.php files. Then all new language keys for your custom language will be added automatically.

Doesn't this mean that if you have updated language key, that you should just replace the lang_eng.php file in the upgrade directory before you do anything else?  Took me forever to figure this out, probably because they put this instruction at the bottom, rather than the top where it belongs.

Why not install a D7 in a subdomain and test out the theory and let us know what happens.  No risk to you and valuable data obtained that will answer your question one way or the other.

Because I don't have the two hours or so it would take for an install, and someone here should know and be able to answer in seconds.

It would make sence that puting new keys in the upgrade folders would do it. But i can't confirm it. I have not tried it.

 I'm sorry if I offended you Mr. Caltrade.  I was just trying to make a useful suggestion that would give you the answer you sought.  Your right, you don't have the 2 hours it would take to find out the way I suggested.  It was much quicker to ask this question on December 19th, 2010 and obtain a possible answer without a definitive positive on February 8th, 2011.  Much kudos to you for seeing the quickest way to find your answer. 

Well, Mr. Ropeman "your right" - I don't have the time for your witty sarcasm.  I really just come to this form for technical support, and to give it when I can.  I don't have much time for games.

 Again, I apologize Mr. Caltrade.  I truly just wanted to help you make the most of your time knowing how important time is to a man who runs a business networking site.  Please accept my apologies for any "witty sarcasm" that may have been interpreted in my post to you.  It was not meant by any means to offend you.  Can we be friends?

Can't you just export the language from one site, change the name to 'en2' in the exported file, then import it into the other site as a second language?  Then you could just use the second language as the default language.

Then, if it works out OK, you can delete 'en' and rename 'en2' to 'en'.

 Yes you can do that .....   or use the same install of dolphin but create a second database and point it to that database and play with that one....    no need to upload another dolphin install.   on a side note an install should take 5 minutes or less. (just my two cents)

Maybe one of us should do it and report back the results so others don't have to waste "Two Hours" of their time trying to figure it out.

hi can u guys help

i have added some html and text into templates/base/_sub_footer.html

when its an English version of site it is ok but when i want to change different language its still in English . how can i translate also this add?

I've tried to add some parameters to lang files but no results. maby u can provide some step by step information ?

thanks a lot !!