The info was given to illustrate a point. If translation was needed, then we could use it for a one time grab to capture the translated info and store it in a table / csv file like all the others. It was never intended to be used in a fully online manner.
Managed to translate 5000 records in 10 minutes and then Google cut the IP off for presumably excessive use. Local 512 Kbps line manages 200 records in 150 secs. Used a small progress bar script to do the job. Here is the script that may have some other use: ================= // Copy the ops301_de.csv to ops301_en.csv in the same folder as this script // Usage 1: http://domain.com/scriptname.php?s=1201&t=1500&d=1 // This will display the original lineand the translated line - debug mode - for lines 1201 to 1500 // Usage 2: http://domain.com/scriptname.php?s=1201&t=1500 // This will populate a new file ops301_out_en.csv with the contents of ops301_en.csv, replacing the lines 1201 to 1500 with their translated equivalent. // utf-8 is required to display characters properly header('Content-Type: text/html; charset=utf-8'); require_once('google.translator.php'); $stline = (isset($_REQUEST['s']) ? ($_REQUEST['s']-1) : 0); $toline = (isset($_REQUEST['t']) ? ($_REQUEST['t']+0) : 0); $debug = isset($_REQUEST['d']); $frlang = 'de'; $tolang = 'en'; $filename = "ops301_$tolang.csv"; $outfile = "ops301_out_$tolang.csv"; $handle = fopen($filename, "rb"); $contents = fread($handle, filesize($filename)); fclose($handle); $contents = str_replace(CHR(13), '', $contents); // strip the carriage returns $mylines = explode(CHR(10), $contents); $numlines = $toline-$stline+1; $pcperline = 100.00 / $numlines; $pc = 0.00; create_progress(); echo '<br><br><br><br>'; for ($i = $stline; $i < $toline; $i++) { $myline = FALSE; $myline = explode (";", $mylines[$i]); // Translatable text is in Fields 1, 2, 3 and 4 only for ($j = 1; $j < 5; $j++) { $mylinefld = trim($myline[$j]); if ( (strlen($mylinefld) > 0) && (!($mylinefld == ': N.n.bez.')) ){ $mylinefld = str_replace('"', '', $mylinefld); // Strip the double quotes for translation $mylinefld = str_replace('<br>', ' ### ', $mylinefld); // Strip the html BR for translation $mylinefld = '"' . Google_Translate_API::translate($mylinefld, $frlang, $tolang) . '"'; // put back the double quotes $mylinefld = str_replace(' # # # ', '<br>', $mylinefld); // Put back the html BR (extra spaces for UTF8) after translation } $myline[$j] = str_replace(': Nnbez.', ': N.n.bez.', $mylinefld); // just know that it is needed to work. N.n.bez. -> Not Specified Further } if ($debug) { echo $mylines[$i]; // Show Original echo CHR(13) . CHR(10) . '<br>'; // put back the carriage returns } $mylines[$i] = implode(';', $myline); if ($debug) { echo $mylines[$i]; // Show Translation echo CHR(13) . CHR(10) . '<br>' . '<br>'; // put back the carriage returns } $pc += $pcperline; $pc = round($pc,2); update_progress($pc); } if (!($debug)) { $fp = fopen($outfile, 'wb'); $cnt = count($mylines); for ($i = 0; $i < $cnt; $i++) { if (strlen(trim($mylines[$i])) > 0) { fwrite($fp, $mylines[$i]); fwrite($fp, CHR(13) . CHR(10) ); // put back the carriage returns } } fclose($fp); } function progressBar($percentage) { print "<div id=\"progress-bar\" class=\"all-rounded\">\n"; print "<div id=\"progress-bar-percentage\" class=\"all-rounded\" style=\"width: $percentage%\">"; if ($percentage > 5) {print "$percentage% ";} else {print "<div class=\"spacer\"> </div>";} print "</div></div>"; } function create_progress() { // First create our basic CSS that will control // the look of this bar: echo " <style> #text { position: absolute; top: 10px; left: 20%; margin: 0px 0px 0px -150px; font-size: 18px; text-align: center; width: 400px; } #barbox_a { position: absolute; top: 40px; left: 20%; margin: 0px 0px 0px -160px; width: 404px; height: 24px; background-color: black; } .per { position: absolute; top: 40px; font-size: 18px; left: 20%; margin: 1px 0px 0px 250px; background-color: #FFFFFF; } .bar { position: absolute; top: 42px; left: 20%; margin: 0px 0px 0px -158px; width: 0px; height: 20px; background-color: #0099FF; } .blank { background-color: white; width: 400px; } </style> "; // Now output the basic, initial, XHTML that // will be overwritten later: echo " <div id='text'>Script Progress</div> <div id='barbox_a'></div> <div class='bar blank'></div> <div class='per'>0%</div> "; // Ensure that this gets to the screen // immediately: flush(); } function update_progress($percent) { // First let's recreate the percent with // the new one: echo "<div class='per'>{$percent} %</div>\n"; // Now, output a new 'bar', forcing its width // to 4 times the percent, since we have // defined the percent bar to be at // 400 pixels wide. echo "<div class='bar' style='width: ", $percent * 4, "px'></div>\n"; // Now, again, force this to be // immediately displayed: flush(); } ================= Regards, Ap.Muthu > I don't think that we have to translate OPS 301. For all other views on > translation we might could think about that option to use remote but as > far I have read (quick cross read the google language API) it would need > permanent access to Google's remote servers. > Care2x should be placed on a server what do not have direct internet > access based on the matter of trust. We store medical and confidential > data and for that we should recommend conservative and strict proceudues > for it and not have internet access in our installation requirement > lists. > > I would recommend for care2x as well as other databases for ERP and CRM > in production use to place these server in an network isolated way, > called "Demilitarized Zone" (DMZ): > http://en.wikipedia.org/wiki/Demilitarized_zone_%28computing%29 > > Well, we cannot classify the internet as trusted network and so we might > not able to use it. > > Or had I an misinterpretation of the API? Does it work also offline? > > Robert > > > Am Dienstag, den 14.09.2010, 10:19 +0530 schrieb Ap.Muthu: >> While working on the easiest way to translate the OPS301 CSV files so >> that >> any language can be added on the fly from the original German file, I >> checked out the Google Translate APIs and here are the Links: >> >> Two Wrappers: >> 1. Official: http://code.google.com/p/php-language-api/ >> 2. Third-Party: http://code.google.com/p/gtranslate-api-php/ >> >> Here is some sample code: >> >> ====== >> >> require_once("GTranslate.php"); >> try{ >> $gt = new Gtranslate; >> echo "Translating [Hello World] from English to German => >> ".$gt->english_to_german("hello world")."<br/>"; >> echo "Translating [Ciao mondo] Italian to English => >> ".$gt->it_to_en("Ciao mondo")."<br/>"; >> } catch (GTranslateException $ge) >> { >> echo $ge->getMessage(); >> } >> >> // ==== >> >> echo "<br>"; >> echo "<br>"; >> >> // ==== >> >> // utf-8 is required to display characters properly >> header('Content-Type: text/html; charset=utf-8'); >> >> require_once('google.translator.php'); >> >> // translate apple from english to portuguese >> $str = Google_Translate_API::translate('Apple', 'pt', 'en'); >> >> // view the translated string >> var_dump($str); >> >> >> ====== >> >> Regards, >> Ap.Muthu ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
