PHP: Import a large XML file using PHP

Finalizat Postat la Apr 17, 2008 S-au achitat serviciile după ce au fost prestate
Finalizat S-au achitat serviciile după ce au fost prestate

We currently have a fully operational Import module that imports product information from a XML file to a MySQL database using a small PHP module. The current import is about 1500 products (5 Mb file).

We are looking to scale this program to import 15000 products (25 Mb file). This may require either revising the module or re-writing using your new approach for scalability and PHP memory limits.

Environment:

- XML file is available as an URL (example: [url removed, login to view])

- PHP 4.x

- MySQL

Knowledge of MySQL is not required but preferred. Must have experience handling large files using PHP and some knowlege of XML DOM model.

Attached a sample file with 1 product information. The module must be able to import 15000 such products.

Successful bidder able to offer highly competitive bid, quick turnarounds and succesful result can expect a regular stream of projects from us.

## Deliverables

TYPICAL ITEM IN XML. IN OUR CURRENT XML WE HAVE ABOUT 15000 OF THESE:

<Item ID="z-ball-video-21-creative-games-ra327p" TableID="item.">

? ? ? <ItemField TableFieldID="promo-text" Value=""/>

? ? ? <ItemField TableFieldID="description" Value="Z-Ball Video 21 Creative Games"/>

? ? ? <ItemField TableFieldID="name" Value="Z-Ball Video 21 Creative Games"/>

? ? ? <ItemField TableFieldID="download" Value=""/>

? ? ? <ItemField TableFieldID="abstract" Value="Z-Ball Video 21 Creative Games."/>

? ? ? <ItemField TableFieldID="label" Value=""/>

? ? ? <ItemField TableFieldID="orderable" Value="t"/>

? ? ? <ItemField TableFieldID="taxable" Value="t"/>

? ? ? <ItemField TableFieldID="headline" Value="Z-Ball Video 21 Creative Games"/>

? ? ? <ItemField TableFieldID="keywords" Value="z-ball video 21 creative games, ra327p"/>

? ? ? <ItemField TableFieldID="inset" Value=""/>

? ? ? <ItemField TableFieldID="code" Value="0014-RA327P"/>

? ? ? <ItemField TableFieldID="bcode" Value="17.00"/>

? ? ? <ItemField TableFieldID="merchant-category" Value="DVD & Video > Creative Games > Fun Balls"/>

? ? ? <ItemField TableFieldID="medium" Value=""/>

? ? ? <ItemField TableFieldID="icon" Value=""/>

? ? ? <ItemField TableFieldID="caption" Value="<font color=&quot;cccccc&quot;><small>Z, Ball Video 21 Creative Games, Ra327P. </small></font></p>

<p>The original Z-Ball is BACK and BETTER!. . Z-Ball is now PATENTED and has been re-designed to make it even better. The new 7-knob design creates the same unpredictable bounces but eliminates the impossible bounces of the previous ball. New 2-color design increases visibility substantially on all surfaces. Use the blue and yellow ball on gym floors, use the orange and yellow ball on darker surfaces. The new Z-Ball is 40% bigger for easier handling and catching. Please specify your choice of color."/>

? ? ? <ItemField TableFieldID="gender" Value=""/>

? ? ? <ItemField TableFieldID="isbn" Value=""/>

? ? ? <ItemField TableFieldID="acode" Value="0014"/>

? ? ? <ItemField TableFieldID="age-group" Value=""/>

? ? ? <ItemField TableFieldID="upc" Value=""/>

? ? ? <ItemField TableFieldID="in-yshopping" Value="t"/>

? ? ? <ItemField TableFieldID="sale-price" Value="28.9"/>

? ? ? <ItemFieldOptions TableFieldID="options"/>

? ? ? <ItemField TableFieldID="manufacturer-part-number" Value="RA327P"/>

? ? ? <ItemField TableFieldID="image" Value=""/>

? ? ? <ItemField TableFieldID="ship-weight" Value="0.35"/>

? ? ? <ItemField TableFieldID="gift-certificate" Value=""/>

? ? ? <ItemField TableFieldID="price" Value="34"/>

? </Item>

? <Item ID="zinc-oxide-adhesive-tape-te099p" TableID="item.">

? ? ? <ItemField TableFieldID="promo-text" Value=""/>

? ? ? <ItemField TableFieldID="description" Value="Baseball Zinc Oxide Adhesive Tape"/>

? ? ? <ItemField TableFieldID="name" Value="Baseball Zinc Oxide Adhesive Tape"/>

? ? ? <ItemField TableFieldID="download" Value=""/>

? ? ? <ItemField TableFieldID="abstract" Value="Baseball Zinc Oxide Adhesive Tape."/>

? ? ? <ItemField TableFieldID="label" Value=""/>

? ? ? <ItemField TableFieldID="orderable" Value="t"/>

? ? ? <ItemField TableFieldID="taxable" Value="t"/>

? ? ? <ItemField TableFieldID="headline" Value="Baseball Zinc Oxide Adhesive Tape"/>

? ? ? <ItemField TableFieldID="keywords" Value="zinc oxide adhesive tape, te099p"/>

? ? ? <ItemField TableFieldID="inset" Value=""/>

? ? ? <ItemField TableFieldID="code" Value="0014-TE099P"/>

? ? ? <ItemField TableFieldID="bcode" Value="1.75"/>

? ? ? <ItemField TableFieldID="merchant-category" Value="Sports & Outdoors > Baseball > Sports Medicine > Tapes"/>

? ? ? <ItemField TableFieldID="medium" Value=""/>

? ? ? <ItemField TableFieldID="icon" Value=""/>

? ? ? <ItemField TableFieldID="caption" Value="<font color=&quot;cccccc&quot;><small>Zinc Oxide Adhesive Tape, Te099P. </small></font></p>

<p>Excellent tack and adhesion.? 11/2&quot;x 45&apos;."/>

? ? ? <ItemField TableFieldID="gender" Value=""/>

? ? ? <ItemField TableFieldID="isbn" Value=""/>

? ? ? <ItemField TableFieldID="acode" Value="0014"/>

? ? ? <ItemField TableFieldID="age-group" Value=""/>

? ? ? <ItemField TableFieldID="upc" Value=""/>

? ? ? <ItemField TableFieldID="in-yshopping" Value="t"/>

? ? ? <ItemField TableFieldID="sale-price" Value="3"/>

? ? ? <ItemFieldOptions TableFieldID="options"/>

? ? ? <ItemField TableFieldID="manufacturer-part-number" Value="TE099P"/>

? ? ? <ItemField TableFieldID="ship-weight" Value="0.2"/>

? ? ? <ItemField TableFieldID="gift-certificate" Value=""/>

? ? ? <ItemField TableFieldID="price" Value="3.5"/>

? </Item>

Inginerie MySQL PHP Gestionarea proiectului Arhitectură software Testare software XML XSLT

ID Proiect: #3876207

Detalii despre proiect

5 propuneri Proiect la distanță Activ Apr 18, 2008

Acordat lui:

vw6868760vw

See private message.

%selectedBids___i_sum_sub_7%%project_currencyDetails_sign_sub_8% USD în 14 zile
(51 Recenzii)
5.6

5 freelanceri plasează o ofertă medie de 61$ pentru proiect

apisdev

See private message.

$71.4 USD în 14 zile
(48 recenzii)
4.8
ramonalivio

See private message.

$59.49 USD în 14 zile
(35 recenzii)
4.2
soikatchakma

See private message.

$46.75 USD în 14 zile
(3 recenzii)
2.6
ashiscsedu

See private message.

$85 USD în 14 zile
(0 recenzii)
0.0