I have a comparison website and like to build a simple automatic importer from xml / csv to phpmyadmin that import every night.
What is needed: I need to be able to 'map' the fields of the csv or xml, so that your cronjob knows which fields belong where in the phpmyadmin table. So for example if there's a dutch field 'prijs' we need to map it in mysql field 'Price'. There are like 10-15 different productfeeds now and I like to add more in the future.
In the attachment I have put three files:
jpg: this is the mysql database table in which we need to import
xml: this is a xml productfeed example
csv: this is a csv productfeed example
There's no problem if I have to do a lot of manual stuff every time I have a new productfeed. As long as we can create new productfeed imports every time and this small software thing isn't too expensive.
By the way: if you don't read, your reply is ignored. Please state: 'cursusvoor' in the reply