Importing data from text files on my server, data from a web page and data from an RSS feed into a MySQL database. Requires reformatting of data and some search and replace functionality. Will require a GUI with different settings for each source to be made to allow me to selectively change one or more fields in each record manually. The scripts will have to have some kind of history because on each import it will need to examine a date field on each record and determine if this record is already present in the database from a previous update.
I will supply you with table structure of my database and you can develop the scripts locally and send them to me for upload and testing prior to payment.
I am able to set up any tables on my server that the scripts need to hold data before it is finally imported into my main DB.
Also needed is a script that does basically the same thing, but with the source of the date coming from a unique URL that is dynamically updated.
Also needed it a script that takes information from an RSS feed.
So, in essence I need to be able to import data from a text file, a web page and an RSS feed and format it all to fit my current database configuration and import it into my database. Each source will be a little bit different but all contain the same basic data.
## Deliverables
The system will need to remember the settings I set for each source in the GUI so that it formats everything the same way every time and I don't have to format it every time.
The project will no doubt require the addition of extra tables to my database. You can give me the code to past in phpMyAdmin to make the tables or you can give me the table name, names ? and types of fields etc. and I will make it manually, either way is fine with me.
I have a sample of the two text documents it will import. They are different in format but the data we import from them is basically the same.
If you have any questions, feel free to contact me.
Please be sure you can do this within my timeline and read my description thoroughly, asking any questions you might have.
Thanks