You have chosen to sponsor your bid up to a maximum amount of .
1) Setup Joomla on a Web Server with a given design with mockups in PSD/JPEG
2) Implement the Open Patent Service Webservice Interface to gain access to the European Patent Register (specification is enclosed in [url removed, login to view])
3) Develop or choose a suitable Joomla component that parses XML documents to determine the structure of their XML nodes and that automatically creates tables and fields in a MySQL database based on the structure of the XML nodes; for each XML node there must be a corresponding field in the database, wherein the automatically created tables and fields represent a normalized database with relationships derived from the structure of the XML document.
4) Provide a user configurable interface to download XML documents from the European Patent Register based on a given query (user input, storable in search profiles) and storing the XML documents in the MySQL database according to step 3). The user configurable interface comprises a selection which XML nodes to be processed and to be stored in the database. A list of all detected XML nodes is presented to the user and the user selects the nodes of interest.