Need to build an app to upload a dbf file remotely and update mysql database

Hi I am faced with a task where i have to build an application which has the following requirements:- 1.the users of an organisation upload dbf files(foxpro database files) remotely into my application 2.this dbf file is used to开发者_StackOverflow中文版 update the mysql database which is the central repository

This web application has to be built on php or python. Can someone please suggest some ways Thanks

---

There are at least two Python modules for accessing DBF file formats: dbfpy and dbf. Once you can parse the DBF file, you'll need to pass rows to a translation routine which constructs SQL statements to populate the MySQL tables, using the MySQLdb extension.

Also make sure to plan how to recover if an insert fails and a user has to re-upload the same file, like wrapping all your inserts/updates in a single transaction which can be rolled back.

If the files are quite large you might want to consider queuing the files and having a background process insert them, instead of doing it within the web request. It could keep a record of each file it has successfully completed, so users can check status, or email them once their job has run successfully, depending on your requirements.