Language Keys and Strings transfer

Hello fellow dolphineers again, heres another question I have - unfortunately.

OK, I have a test site in which I have a whole bunch of new language keys. About 42 forms worth of language keys.

The simple question is: whats the easiest way to copy all of my new language keys from the test site to the actual domain?

Originally, copied all of the keys from the lang_en.php file of my test domain to the lang_en.php file of the real domain, then cleared the cache and recompiled language and they all showed up just like they were supposed to - until i added a new key using the normal method of doing so - thats when all of the keys i had copied to the real domain disappeared.

Now - i probably could have exported my test lang file and then imported it into the new site, but my issue with that is that there are a bunch of keys that I created that I do not need. Either I messed up the Key, or I changed the text so didnt need certain keys anymore.

My next thought would be to copy the database of keys over, but there are so many keys that i got lost trying to go through and find all the keys i needed - I have over 8500 keys to search through. Now with this logic, it would be nice if i could export the old database of keys, and import into the new database, but I get an error each time it tries to insert a key that is already existing. If I could have it skip those that are already there, then that would work, although I still have a bunch that I am not using.

Again, any help would be appreciated, and as always, Thanks in Advance.

caredesign.net
Quote · 13 Apr 2013

Use on duplicate update.  Need to check the syntax; this is just a quick reply.

INSERT INTO table (key,col1) VALUES (1,2) ON DUPLICATE KEY UPDATE col1 = VALUES(col1)

As I said, get the mySQL guys to check this.

Geeks, making the world a better place
Quote · 14 Apr 2013

Maybe my languages merge tool will be useful for this, place this file in your Dolphin root folder.

This file should NOT be open for public access!

Export language file from local Dolphin and place its contents without open and close php tags into New Language field, and from production Dolphin site into Old Language field.

It will show you what language string was added/changed/deleted, without performing any real changes in the database.

_ml.php · 4.6K · 231 downloads
Rules → http://www.boonex.com/terms
Quote · 15 Apr 2013
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.