PHP script for bulk translation of XML with caching
PHP script for bulk translation of XML with caching
Task description:
A PHP script is needed that:
Downloads an XML file locally via HTTP or HTTPS from a specified URL
Translates the values of selected tags (specifies an array of tags and/or tag parameters for translation)
Caches translations in a local SQLite database (linked to a unique product identifier, for example, the
<id>tag or<item id="111">parameter to avoid duplicates and repeated API requests)Logs minimally:
Total number of processed products
Number of translations retrieved from cache
Number of translations actually sent to Google Translate API (GT)
Saves the processed XML file locally and uploads it to the specified FTP
Implementation requirements:
Language: PHP 7.4 (in theory, Python or Note.js could also be used)
Run via Cron
Translation cache in SQLite (to minimize API GT requests)
Translate only if records for the required tag/parameter are not in the database
Support simple logging to a txt file (date, total processed, retrieved from cache, actually translated)
Work with Google Translate API (key and settings — in a separate config.php)
Test file at roliki.ua (needs to be translated from RU to UA). https://roliki.ua/s/productstest.xml
Client's review of cooperation with Volodymyr Stetsenko
PHP script for bulk translation of XML with cachingEverything is excellent, Volodymyr met the deadlines, did everything with high quality. The task was to create a script, not the simplest one, but Volodymyr handled it perfectly, for which he deserves great thanks. We will definitely reach out again in the future.
Freelancer's review of cooperation with Igor Kovcheg
PHP script for bulk translation of XML with cachingThe deal went excellently, there are no comments.
The answers to the questions asked were provided in a timely manner.
Current freelance projects in the category PHP
Integration of Blade article template | Laravel | Frontend
100 USD
Integration of Blade template for article | Laravel | Frontend Task Essence The site is built on Laravel. A ready HTML/CSS layout for a premium blog article page. It needs to be integrated into the existing Blade structure of the site. The design is ready. You are not designing… PHP, Web Programming ∙ 2 hours 26 minutes back ∙ 36 proposals |
Implementation of a technical SEO audit on OpenCartGood day. Need to implement technical SEO fixes on the site softugo.com. The site is already developed but not fully launched yet. Platform: ocStore 3.0.2.0 / OpenCart + custom code. Hosting: Hostinger. Current PHP version: 7.3. (transition to PHP 8.2 is planned) A checklist… PHP, Web Programming ∙ 4 hours 28 minutes back ∙ 44 proposals |
Execution of work after SEO audit
334 USD
An experienced OpenCart developer is needed to perform SEO and technical improvements for the online store. Main tasks: Correction of the internal linking structure and menu. Adding links to the footer. Implementation of breadcrumbs with Schema.org microdata. Fixing the… PHP, Website Maintenance ∙ 3 days 4 hours back ∙ 61 proposals |
Integration needed: KeyCRM → Cash Register KashalotIt is necessary to set up integration between KeyCRM and the Cash Register Kahalot. When placing an order in KeyCRM, the data must be automatically transmitted to Kahalot: • order information • products, nomenclature • prices • quantity More details in private. Content Management Systems, PHP ∙ 6 days back ∙ 29 proposals |
A WordPress site using the Kadence theme and Kadence Blocks.
223 USD
We need to create a website on WordPress using the Kadence theme and Kadence Blocks. There will be no online store (although it may be added in the future). We need a homepage and several internal pages. The graphics are already prepared, the layout structure is mostly defined,… Content Management Systems, PHP ∙ 7 days 10 hours back ∙ 38 proposals |