In Progress

XML parsing script and webapplication

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.

Sample xml file.

Skills: Perl, PHP

See more: where to look for jobs, what is job id, truck jobs, schema update, real truck, process data structure, job values, jobs in xml, jobs id, job in xml, cvs jobs, cvs job, perl script xml parsing, xml parsing script, deleted values xml, xml &, xml script, xml c, webapplication, truck, schema, relation, import XML, php xml delete, database job candidates

About the Employer:
( 47 reviews ) Zurich, Switzerland

Project ID: #216518

Awarded to:

soner

Ready to work with you. I have a lot of experience in xml & db area. Please contact if interested.

$290 USD in 6 days
(125 Reviews)
8.1

8 freelancers are bidding on average $211 for this job

toinnisfree

pls chk pmb

$250 USD in 5 days
(599 Reviews)
8.0
marchent

pls check pmb.

$200 USD in 10 days
(165 Reviews)
6.3
Zuprem

I can create the application you need.

$300 USD in 12 days
(53 Reviews)
5.5
mickalo

we can provide the required Perl programming as outlined. Mickalo

$300 USD in 5 days
(3 Reviews)
3.9
spx2

hi, I can write this,I have written these kinds of applications before

$100 USD in 5 days
(2 Reviews)
2.0
megamerx

hi. i have exactly what you need. pls see pm bid. thanks!!

$150 USD in 0 days
(1 Review)
1.9
aquiles

Hello, I am an enginner with more than 3 years of experience in XML an PERL, Please see PM for more details.

$100 USD in 7 days
(0 Reviews)
0.0