Convert Excel file to XML file and update database

Dear Coders I need to have some XML files updated and also a database need to be updated. You find the excel file in the attached folder. We will have to disscuess the implementation first so I am sure about you have understod the job to do. In the zip file called "energiberegner server" you will find a folder called "Dataentry" this one contains the XML files. All XML files starting with "glas" need to be updated with the data from the excel file. Please notice the excel file contains 3 sheets (The 3 tabs below in the document). We are a window and door manufactor and we have 5 systems (100,200,400,500,600) You will find the system data as headlines in the excel file. The excel file contains data about glazing for our window/door systems. Some of the glazing can be used for more than one system (Thats why the headline in the excel file has more then one system) The 3 tabs in the excel doc. is having the tab name 24mm,32mm,36mm it is the width of the glazing To find the right match from excel to XML you will have to look at the XML file name and the headline/tab in the excel file AND the correct tab All XML files with 1xx,2xx,4xx,5xx,6xx in the filename belongs to the System 100,200,400,500,600. Meaning ex. a 237 door use the system 200 glazing. When this is done upload the content of the file in the zip folder called "energiberegner server" to your server and let me have a look at it. The second half of the job is to make an equal update to the database in the "Base" zip file. Upload ect. Kind regards Tinus ## Deliverables * * *This broadcast message was sent to all bidders on Friday Feb 8, 2008 10:41:14 AM: In the zip file called "energiberegner server" you will find a folder called "Dataentry" this one contains the XML files. All XML files starting with "glas" need to be updated with the data from the excel file. Please notice the excel file contains 3 sheets (The 3 tabs below in the document). We are a window and door manufactor and we have 5 systems (100,200,400,500,600) You will find the system data as headlines in the excel file. The excel file contains data about glazing for our window/door systems. Some of the glazing can be used for more than one system (Thats why the headline in the excel file has more then one system) The 3 tabs in the excel doc. is having the tab name 24mm,32mm,36mm it is the width of the glazing To find the right match from excel to XML you will have to look at the XML file name and the headline/tab in the excel file AND the correct tab All XML files with 1xx,2xx,4xx,5xx,6xx in the filename belongs to the System 100,200,400,500,600. Meaning ex. a 237 door use the system 200 glazing. When this is done upload the content of the file in the zip folder called "energiberegner server" to your server and let me have a look at it. The second half of the job is to make an equal update to the database in the "Base" zip file. Upload ect. Kind regards Tinus * * *This broadcast message was sent to all bidders on Wednesday Feb 13, 2008 6:07:23 AM: Dear Coder If you need further more information regarding the project. Then I will be in the chatroom right now Kind regards Tinus