Get XML file to MySQL-DB through Perl

A script shall be provided to import XML-Files with articles (see example in attachement or below) and insert or update multiple tables of a MySQL-Database.

An xsl-template of the XML-File can be supplied but contains minor mistakes.

See [login to view URL] for XML file structure

One usual XML-File is about 1MB,

it contains multiple articles,

an article might contain a number of variants,

a variant might have pictures.

An XML might update article-attributes again but not contain variants, keep existing variants

An XML might update articles and variant-attributes but not contain variant-pictures, keep existing pictures.

Current database layout:

- Articles

PRIMARY KEY (pid), auto_increment - NOT the products_id from the XML!

UNIQUE (products_id)

- Variants

PRIMARY KEY (pid, first_order, second_order),

UNIQUE (products_id, first_order, second_order) - may get obsolete on your script

- Variant-Pictures

PRIMARY KEY (pid, first_order, second_order)

UNIQUE (products_id, first_order, second_order, file, ending) - may get obsolete on your script

Supportive MySQL-functions can be used (MySQL 5)

[login to view URL] XML-Structure:

<?xml version="1.0" encoding="ISO-8859-1"?>



<products_id>LKJ 297</products_id>



<dealer_name>John Doe Dealershop</dealer_name>




<manufacturer_name>Hewlett Packard</manufacturer_name>






<another_attribute>That is a test</another_attribute>


<matchcode_1>Printer supply</matchcode_1>












<name>option 5 name</name>

<description>longer text</description>





<ordercode>K7IOU O</ordercode>

<name>option 5 name</name>

<description>another longtext</description>






<name>option 5 name</name>

<description>another longtext</description>






<name>option 5 name</name>

<description>another longtext</description>



<name>variant Picture 1</name>
















<name>option 5 name</name>

<description>another longtext</description>



<picture type="pkg" page="1">











Taidot: Perl, XML

Näytä lisää: txt 2 jpg, price structure template, price file, perl get, mysql org, mysql db, john price, get layout, get get get, get $5, oiu899, perl post xml file mysql, xml &, mysql 5.1, your true, xml script, xml layout, xml c, update mysql, sdf

Tietoa työnantajasta:
( 7 arvostelua ) Praha 7, Czech Republic

Projektin tunnus: #159237

2 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


we can provide the necessary programming needed to parse your XML file and import it into the database. See PMB for addt'l info. - Mickalo

$200 USD 1 päivässä
(3 arvostelua)

Dear Sir, I am experienced Perl developer. I have already done similar job before. Nadeem

$200 USD 4 päivässä
(12 arvostelua)