What i basically need is a php script (running on my server) that picks up an XML or CSV file from a url location which i have to give the script and lets me store it in a table in my database. I need to be able to select one of the tables in my database to store the data to. I need to be able to assign the colums of the feed to the colums of the database. When assigning the colums i need to be able to select from a couple of datamodifiying functions, like: leave field blank, SEO rewrite the value to import, set value to fixed predefined value, append and/or prepend the value to import with a tekst string, make the value unique, identify a colum’s value as unique id. Then I need to be able to schedule (recurring) a check for updates in the original feed, and updating the data in the database. (eg daily/weekly/monthly at a set time). I need to be able to set more than one feed, (eg 2 or 3 feeds in the same database), i need to be able to change the configuration of the feed to import later.
The script has to run at php [url removed, login to view] environment and Mysql [url removed, login to view]