1. Overall objective
Create machine translations of web pages or database fields using Google Translate, and cycling through using cron job to update translations at frequency to be configured. Must be in compliance of Google Translate API terms at [login to view URL]
[login to view URL] methodology
Should basically be a modified implementation of the detailed and useful method set out in Google groups by "siteowner" which I lack time to understand:-
- [login to view URL]
- Script to be called every hour: [login to view URL]
- Translate() function: [login to view URL]
This method uses ASP & MS SQL. We use classic ASP/VBScript, and MS SQL 2000.
The solution may resemble an ASP/MS SQL version of the Wordpress plugin Global Translator Pro ([login to view URL]). We have a test Wordpress site with the free version of the plugin (we can provide admin link to this if needed).
3. Specific requirements:-
Source to be translated: configurable to be either field(s) from database, or part of webpage (eg within defined tags, eg body)
Max characters per translation request: as Google sets 5,000 as limit, suggest 4,000
Request frequency: configurable as % of oldest pages or every x days
Min interval between requests: configurable, min 10 mins
Translated results: configurable to go either to a cache (replacing older version), to a database (updated the record unless the first translation in which case insert a new record), or both. Cache should be folders named by 2-letter language code (as done by Global Translator).
4. Testing & implementation
We would like to be kept involved in design issues, and can if necessary provide access to online MS SQL 2000 server.
We need help to modify to our production situation, and make sure the coding works. This should not prove difficult, but is a key part.