XML parsing script and webapplication

XML parsing script and webapplication is project number 216518 posted at GetAFreelancer.com. Click here to post your own project.

Closed
(Selected Service Provider soner)

Status:	Closed
Budget:	$100-300
Created:	01/22/2008 at 8:14 EST
Bidding Ends:	03/22/2008 at 8:14 EDT
Project Creator:	globetrotter77   Buyer Rating: (45 reviews)
Description:	You will have to implement a perl script that will parse some xml files and publish the data to a mysql database. The structure of the tables and the relation bettwen tables will have to match the structure of the xml schema. This script will run as a cronjob and it will look for new files in a given folder and then parse those files and insert them to the database. The XML files will conatin 2 main entities: - job offers - candidates cvs For each of them we will get Insert/Update/Delete command so you will have to update the tables based on that. The data will be saved on 4 databases as follows: - ca_real - this will save all the tables that are related to the candidates and will have all the update/delete commands procesed, this means modified records will get updated and deleted records will get deleted - jobs_real - this will save all the tables that are related to the jobs and will have all the update/delete commands procesed, this means modified records will get updated and deleted records will get deleted - ca_all - this will save all the tables that are related to the candidates but it will only process the insert commands from the xml file, no updates and no deletes - jobs_all - this will save all the tables that are related to the jobs but it will only process the insert commands from the xml file, no updates and no deletes Some fields from the xml file will contain numbers like "<Degree>13</Degree>" and into the xml file schema you will get a description for each numbers, so for those cases you will have to make 3 tables: - the raw table where the numbers are inserted - a help table from the schema with what each the id and values for each - the final table where the id will get replaced with the real value. For exaple we could have a table DrivingLicence with values like 23466;1 , 23466;5 etc,(where lets say 23466 is a candidate id) then a help table called DrivingLicense_help where we could have values like: 1->'motocycle' 2->'truck' (the lables for each value) and a final table DrivingLicence_final that could contain data like: 23466;'motocycle',23466;'truck'. We will also need a small webapplication made in perl or php where we could get information about the imports, like total, new, updates, inserted, deleted on each if the 4 databases since last import. Additional information submitted: 01/22/2008 at 8:15 EST: Sample xml file. Additional files submitted: sample_xml_file.xml
Job Type:	Perl/CGI PHP
Database:	MySQL
Operating system:	Linux
Bid count:	8
Average bid:	$ 211