326876 Read/write translation into db

Completado Publicado Jun 10, 2009 Pagado a la entrega
Completado Pagado a la entrega

Hi, thanks for looking at our project! This is an interesting one.

We have a tab-delineated flatfile text database (not sql) on our server. We need a script which will translate some of the text in this database from English to Spanish. (Note: this is not a request for translation services -- the contents of our file change every day, so we need a solution that's automated).

If you know of a Linux server-based solution for this, let me know, but otherwise, I beileve that our best option will be a script that will feed the text into (and out of) Google Translate.

Here is an example of what we need translated:

[url removed, login to view]

and here is the result when feeding that URL into Google Translate:

[url removed, login to view]

(As you can see, Google Translate only translates the first 600 records or so, for some reason.)

So -- since there is currently no Google API that will automate translating a file, what we need is a "workaround" script that will do the following:

1.) Make a copy of our database. (let's call this document "[url removed, login to view]").

2.) Copy the contents of **column 6 only** of the first 500 records to a temp file. This will look similar to [url removed, login to view] above (the 500 records at a time is to get around the "600 records" limitation mentioned above).

3.) Feed that URL into Google translate (as above), then capture the output. Write this back to column 6 of the first 500 records of database_es. ULTRA IMPORTANT: Each record's column 6 must be the right one ... the same record as before, translated. In other words, it is essential that the carriage returns separating records must be maintained throughout the process, and that the translation output is is processed so it fits exactly where it belongs on the db.

4.) Continue this process with each set of the 500 records until the file is done (the current source database file is approx. 3700 records, but might grow in the future).

This should be something that we can set up and run as a reliable daily cron job.

If you have any better ideas for how to do this, please let us know, otherwise, please take a look and we welcome your bids and input. Thanks :)

Odd Jobs PHP

Nº del proyecto: #2072683

Sobre el proyecto

1 propuesta Proyecto remoto Activo Jul 11, 2012

Adjudicado a:

kskulkarni

Hello, I'm ready to work on this. Thank you for the info in the PMB. Ketan Kulkarni

$200 USD en 4 días
(3 comentarios)
3.2