Merge fields of a .DBF locel foxpro database to a online MySQL database

The objective it to do the following :

Replace available quantity and price from a local foxpro .DBF database to a online hosted Prestashop MySQL database on certain selected products,

User selectable family of products to do de query from, search that products and replace 2 fields , price and quantity to be replaced in mySQL database from local .DBF database data.

at the end, make a report of the changed products and the not found products, also report all product with a "0" inventory.

be able to select from .DBF database which products to do the export to SQL database

only the products from the selected ¨Families" should be considered

This should be programmed on an automated scrip so it runs periodically fromo our local server, 2003 windows server.

more details on the attached file

MySQL PHP 软件构架

项目ID： #2513383

关于项目