i have an old php-Smarty backed by mySql website. It's here [login to view URL]
I have started to adapt a Wordpress template to switch my old website to. It is here [login to view URL]
Now i have two migration problems for the old news article database:
1. The new database of the wp site is capable of registering key word tags. In order that i populate the old database with tags this is only possible by text analysis. On [login to view URL] you can find two three algorithms that can return a list of tags after analysis of an URL.
So i need you to build a migration application (i want you to use java language) that is feeding the algorith on [login to view URL] all articles in the database (~20000) and collects the tags in the target database for WP site. The problem is the text of the news articles is in Romanian, so i belive that before feeding it to algorithmia there is an intermediary step necessary to get an automatic English translation. The tags in English can be translated back to Romanian.
Since we are translating, the new database should retain the automatic translation of the Romanian articles where it doesn't find one (some of the articles have a translation in a special field but most not).
2. This one is a nice to have, request. The old articles database does not contain a representative picture for each article. Based on the tags, maybe it could be possible to automatically google-find a representative picture for each article. I am aware that the matching might be problematic. I don't know if algorithmia has anything that could cover this.
Then regarding the new WP site i have another problem to solve:
* I have a theme that i bought (The Voux - A Comprehensive Magazine WordPress Theme). In my old website i had a php=Smarty newsletter template generator. In WP there are plugins that can solve this but i don't think i can handle the setup of such plugin myself, it has to be same reliable as the old newsletter generation engine (template needs also to be updated in terms of design, i might want to have two or three templates, and maybe to permit later easy modifications or new templates invention). If i start with your help to add code to the new WP site i then probably will loose the updatability of the Voux theme? this is another concern that i have.
Looking forward to your answers,
Hi, Greetings! We have read and understood your need to migrate the SQL from a website .We are confident about the work . Awaiting for your response to move ahead. Regards, Priya