Create script (powershell, python, etc.) to sync AuctionWizard2000 database and OpenCart Database -- 3
Budget: $250 – $750 USD
I need a skilled (also must speak Russian, due the data in the database) developer to create a set of scripts that will synchronize data between my AuctionWizard2000 database and my Opencart (cubecart, oscommerce) database.
I have a python script done by previous contractor who dropped the project for the personal reason, so there is no issues with source and target db structures, mapping of the fields. etc. Need an to refresh and do an extra polish.
My specific requirements are as follows:
1) Learn the structure of AW 2000 database (old Paradox format, but work fine via Windows ODBC) - download here http://www.auctionwizard2000.com/Download.htm setup exe file, install it, run trial, restore inventory database from the link I will provide and use this data for the export-import. Paradox DB files are in \database folder.
2) Learn the structure of DB of opencart (or cubecart, or oscommerse) and ensure you understand it
3) review the mapping of the data fields between source and target databases.
4) Update the existing script which will update products on the server from source database on my desktop. Main tables for the import: inventory, invimages, invcategory. I need the data about the products in "inventory" and related tables imported to the online shop, including names, parsed descriptions, pictures, etc.
5) Script must parse item description in RTF format, split it to two part using tegs in the text, one for English description in the shop, another - for different language, delimiters --en-- and --ru--
6) Script must do initial upload first, and then be able to update target database - add new, change existing, delete removed items, update quantities. I will run script on my desktop with AW2000 installed periodically to update online store.
You can use OSCommerce or CubeCart as an alternative target system if OpenCart is too difficult. I have them all installed on the target server.
p.s. the budget is final, thank you for understanding.
p.p.s. You must speak Russian to get the project.
I have a python script done by previous contractor who dropped the project for the personal reason, so there is no issues with source and target db structures, mapping of the fields. etc. Need an to refresh and do an extra polish.
My specific requirements are as follows:
1) Learn the structure of AW 2000 database (old Paradox format, but work fine via Windows ODBC) - download here http://www.auctionwizard2000.com/Download.htm setup exe file, install it, run trial, restore inventory database from the link I will provide and use this data for the export-import. Paradox DB files are in \database folder.
2) Learn the structure of DB of opencart (or cubecart, or oscommerse) and ensure you understand it
3) review the mapping of the data fields between source and target databases.
4) Update the existing script which will update products on the server from source database on my desktop. Main tables for the import: inventory, invimages, invcategory. I need the data about the products in "inventory" and related tables imported to the online shop, including names, parsed descriptions, pictures, etc.
5) Script must parse item description in RTF format, split it to two part using tegs in the text, one for English description in the shop, another - for different language, delimiters --en-- and --ru--
6) Script must do initial upload first, and then be able to update target database - add new, change existing, delete removed items, update quantities. I will run script on my desktop with AW2000 installed periodically to update online store.
You can use OSCommerce or CubeCart as an alternative target system if OpenCart is too difficult. I have them all installed on the target server.
p.s. the budget is final, thank you for understanding.
p.p.s. You must speak Russian to get the project.