I already have a working music festival listing website where festivals are directly entered onto the html pages, so no website or graphic design is needed.
I now wish for festival pages to be automatically created by importing from [url removed, login to view]'s API.
[url removed, login to view] uses XML-RPC calls to output a list of upcoming music festivals in XML form. I have an API key from [url removed, login to view] and I have permission from [url removed, login to view] to use this data as requested.
I first want a mySQL database created with the necessary tables. I then want a process to be designed that once a week, an import of the XML's with festival data from [url removed, login to view] be imported into the website.
Any new festivals imported must have that data exported onto a template html file so that every festival has its own page.
I have already created this template html with appropriate markers where the data needs to be inserted.
When festivals with updated information are imported into the database, I want the existing html page to be updated with the new information.
I also have six different index pages, each for a different continental region, I would like for these to be populated with summary information about every upcoming festival, linking to the festivals html page, separated by country, sorted chronologically.