Suoritettu

XML to CSV Data Merge and Conversion

I have a supplier with product information stored in four different locations. This is a project to set up a system to merge that information into a single CSV file, on a daily basis.

The first thing that we have is a link to a zip file, that has 24 xml documents, which contain the descriptions of the products in the catalog. This file is updated once a month.

This file references a categories file, that has category information. This is also updated once a month.

Then we have a link to a zip file containing 24 xml documents, which pertain to in stock, out of stock, and which also contains additional product information. This is updated on a weekly basis, and contains the entire catalog of products. If a product is missing from that file it means it has been discontinued.

Finally we have a link to more zipped files, which are updated twice a day, with daily stock change and quantity amounts.

We need a system that merges the information from all of these different files into a single csv file. We also need to be able to append information to that file, which will permanently remain affixed to individual products.

Example of Descriptions XML

<part> <warehouseloc>1-55-AL-1 </warehouseloc>

<trackingnumber>435297</trackingnumber>

<partnumber>FW114272SM</partnumber>

<name>Sample Item Name</name>

<imagename>FW133372</imagename>

<origincountry>CHINA</origincountry>

<Shipping_Method>Ground Or Air Service</Shipping_Method>

<weight>1.19</weight>

<length>16.00</length>

<width>11.00</width>

<height>3.00</height>

<catalog_desc>2001 CATALOG # 35</catalog_desc>

<catalog_page>293</catalog_page>

<price>16.80</price>

<category1>Child</category1>

<category2>4-6</category2>

<web_category1>7</web_category1>

<web_category2>3</web_category2>

<web_category3>4</web_category3>

<web_category4>1</web_category4>

<gtin>555666777</gtin>

<Description>A lovely sample item to wear around the home </Description> </part>

The other XML files are similar, with different informational elements. All information is delivered via static links to zipped xml files. The output CSV doesn't have to be anything fancy, just rows of information layed out in appropriate order.

Let me know if you have any questions about this project. Thank you very much.

Taidot: Javascript, MySQL, PHP, Komentosarjan asennus, XML

Näytä lisää: the data supplier, supplier in china, height and length, file conversion service, description of the product and service, description of china product, air products, xml supplier, xml conversion, merge data, lovely, home air, fancy product, data merge, data elements products, csv data, php csv sample, stock conversion, csv merge, catalog similar item, php merge csv, lovely project, merge javascript, documents xml, xml weekly

Tietoa työnantajasta:
( 13 arvostelua ) atlanta, United States

Projektin tunnus: #2382320

Myönnetty käyttäjälle:

alrazon

Read your details and interested to work, thanks.

$80 USD 5 päivässä
(31 Arvostelua)
4.5

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

Georgia

If you are still interested please contact me.

$90 USD 7 päivässä
(99 arvostelua)
7.4
SunFlowerBiz

Hi, please check PM for our portfolio. Regards,

$150 USD 3 päivässä
(72 arvostelua)
7.0
srinichal

I can deliver an automated tool for the script

$250 USD 5 päivässä
(88 arvostelua)
6.9
k1ng440

Full time freelance web developer with over 8 years of commercial experience.

$120 USD 3 päivässä
(96 arvostelua)
6.5
ineedWorkJob

Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)

$100 USD 5 päivässä
(83 arvostelua)
6.0
creativeitechpvt

Our ability to develop quality products on-time and on-budget without scrificing quality. there will not be any communication gap. Waiting excited to hear and interact with you. I would like to thank you all for your t Lisää

$120 USD 2 päivässä
(43 arvostelua)
5.9
gangabass

I have completed several projects like this so I'm sure you'll be satisfied with my work. See PM for details.

$120 USD 2 päivässä
(132 arvostelua)
5.8
lafor

I can write you a PHP script you could set up as a cron job on your server to run daily and create a new CSV automatically.

$120 USD 2 päivässä
(51 arvostelua)
5.8
vnb400sl

can develop an app in .NET if it suits you.

$80 USD 3 päivässä
(99 arvostelua)
5.5
phpXpertbd

I specialize in similar projects. Please check PM for more details.

$180 USD 2 päivässä
(18 arvostelua)
5.4
sunlark

Hello, I'm ready to create such data merging tool for you.

$90 USD 4 päivässä
(7 arvostelua)
5.3
phanhuutri

Hello, I'm very interested your project. Please check your inbox for more details, thanks!

$100 USD 3 päivässä
(47 arvostelua)
5.2
retroshell

Hello I can do it for you, Please check my message.

$40 USD 3 päivässä
(18 arvostelua)
4.9
domybestsl

Can be done. That's it.

$100 USD 7 päivässä
(15 arvostelua)
4.8
jamesmart

Hi, Expert Here in SQL/PHP/AJAX/CSV and XML parsing.. with many experience and more.. ready to start asap.. james

$120 USD 1 päivässä
(10 arvostelua)
4.6
freshjah

I am ready to undertake this project.

$100 USD 2 päivässä
(15 arvostelua)
4.5
bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$150 USD 3 päivässä
(6 arvostelua)
4.4
mrbrave

Hi....I can develop a Excel based tool for you.....See PMB for a working sample..

$100 USD 1 päivässä
(10 arvostelua)
3.3
javaguru75

I have to compete with low bid amount of others but they can not compete my quality of work. i have done similar project before using java technologies. imported data from csv to DB, xml to csv and then to DB. any form Lisää

$350 USD 15 päivässä
(4 arvostelua)
3.2
ptbsolutions

Hello please check samples work on your inbox Thanks

$50 USD 2 päivässä
(1 arvostelu)
3.0