This job can be achieved either with a web based program, or a desktop program, as long as it gets the job done.
I describe here the task when applied to a web based application. Desktop application should be able to do the same.
Background of the web database construct:
1. There will be a Master Database Table (let's call it Master) that has a primary key field using tinytext. The text it will hold would be just one single sentence.
2. This Master table has another field called 'translated'. It also holds tinytext.
3. Then there is a working database table called 'job_to_do'. This table has got one single field (called 'job_text') that holds tinytext.
4. Whenever the application starts, it will do the following:
a. ask user to specify source text language and 'destination text language' using dropdown menu.
b. It then iterrate the following tasks repeatedly:
(1) read in text from 'job_to_do'
(2) check to see whether this value is already in the primary key field of Master table. If true, go to next read text (no need to get translated text from Google as it is already done in the past)
(3) If false (not in Master table), then send query to Google via Translation API to get a 'translated text'.
(4) save the result in Master
Again I stress that I don't care whether this program is a Windows Desktop program, or a LAMP (Linux, Apache, MYSQL, PHP) application. As long as it can the above:
The final result must be a database table (Master), or a C.S.V file that can be directly read into a MYSQL database.
Important if you want to do a desktop application, you need to have a local database file to track previously created Master database so that only 'new text' needs to be sent to Google for translation. Preferably use ACCESS database for this purpose.
If you know of ways to use other translation engine, such as
Then please quote the surcharge for add each additional translation engine. I would consider favorably for those who knows how to code multiple translation engine.