Completed

Data Manipulation/joining of multiple XML into mySQL output a csv file

Looking for an individual/company for this project and future DBA/PHP/Data Manipulation work.

1- Automate the download of the files to our webserver from a FTP. (cron job from webserver to pull from a FTP)

2- Import those xml files into our mySQL database on the server we just transferred the files to.

3- Create a daily formatted XML export file based on that information.

This is a fairly large amount of data. (Main xml file is 80 meg), secondary file is tiny(1meg) and there is just over 150,000 tiny (1-3kb) supplemental xml files that are referenced in the main xml file.

I am open to faster approaches to getting me the file requested if there is a easier way. The key to this project is that it should be all automated.

Attached are documentation on XML structure of the files([login to view URL]) and a sample of the master itemsindex([login to view URL]), the entire [login to view URL], 2 example parts xml files([login to view URL],[login to view URL]) (used in the [login to view URL] file) and the Output file how I want to final export to look.

This is part one of the project as more tweaks will be done in mySQL for "phase 2" of this project.

Skills: XML, PHP, MySQL, Linux

See more: mysql query csv file, update mysql tables csv file, php mysql create csv file, writing output csv file format python, updating mysql database csv file, output csv file javascript, mysql updating csv file, query mysql export csv file, script mysql query csv file email, python script output csv file, save output csv file, export nunit output csv file, file output csv file php, output csv file perl, vb extracting data mssql output csv file, export mysql table csv file perl

About the Employer:
( 7 reviews ) Omaha, United States

Project ID: #20614133

Awarded to:

ankurshap

Hi, First of all thanks for providing in-depth detail of your project work. It really helps us to estimate correctly and providing the right solution. I have reviewed your requirement and can import your data into My More

$600 USD in 7 days
(62 Reviews)
6.9

17 freelancers are bidding on average $490 for this job

liangjongai

Hi, sir I have read carefully about your requirements. I have best skills and much experiences in website developing. I have already completed so much projects and get good reviews from employers. I am sure I can compl More

$500 USD in 7 days
(277 Reviews)
7.9
gursukh

Hi I have 5 year experience I can show you my previous work. I'm Individual freelancer I have no timing issue I can do work any time day/nights. so can we discuss once thanks.

$277 USD in 4 days
(265 Reviews)
7.0
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. Here are my working result for php, mysql, api integration, ajax, jquery etc. [login to view URL] More

$250 USD in 10 days
(121 Reviews)
6.9
TakaAlex

Dear I have read your description carefully to get a clear understanding of what you want and what I should achieve. Now I want to say that I am really interested in your task and I can do it successfully. I have exper More

$700 USD in 7 days
(18 Reviews)
5.6
rodweb

Hello, You are looking for someone to deal with your csv file uploading. I have right skill with in php programming and also with MySQL. Don’t hesitate to work with me

$250 USD in 7 days
(54 Reviews)
5.7
expertcoder1vw

Hi, I'm an expert database / MySQL / XML / FTP automation / PHP / web developer , and can automate this process of downloading XML , importing them to MySQL , and exporting to CSV. I can deliver in 2 weeks or less (e More

$750 USD in 15 days
(33 Reviews)
5.5
bluebear1888

Dear my employer! ****************** I have just read your description carefully. So i think as follows. Among of many developers ,to select good developer for your project is very difficult. Perhaps i may be a good se More

$500 USD in 7 days
(31 Reviews)
5.4
maximwang8661

Hello sire. Can donwload from FTP server. I have over 5 years experience with SQLDatabase management in various systems. High-quality & Fast-delivery is promised! As a highly skilled full stack developer and I can help More

$500 USD in 1 day
(17 Reviews)
5.1
SecureForYou

Hi there. I hope you are doing great. I am very good at process automation and also I am good at algorithmic programming and can deal with large sized files to parse their content to add to your mysql db. I am pretty More

$500 USD in 7 days
(6 Reviews)
4.8
MykolaDudych

Hello, I am interested in your offer and I am ready to cooperate. I have experience writing programs for information processing. I have experience in writing scripts in javascript , php, mysql.

$500 USD in 30 days
(13 Reviews)
3.8
Appicsoftwares

Hi, The job description provided by you is part of my niche and I am pretty much confident to accomplish it in a feasible timeline. I am Solution Architect and have my own Development, Designing, and Marketing Team i More

$500 USD in 7 days
(6 Reviews)
3.1
cooolwriter

Hi there, Your PHP designer and developer here. Graduated recently from California, USA; I have been doing numerous Website and app design projects. I feel I will be comfortable to work with you and perform tasks as p More

$500 USD in 7 days
(4 Reviews)
3.6
fisasti

I can do this job easily. I have more than 15 years of experience in PHP, MySQL, Javascript, web security and data scraping. I can start today. Thanks, Federico

$450 USD in 5 days
(2 Reviews)
2.2
laibailyas

Hello there, How are you doing? I have read the description, I have great experience doing similar jobs related to these skills Linux, MySQL, PHP, XML. Right now I am placing a place holder bid, We will decide the p More

$555 USD in 8 days
(2 Reviews)
1.9
scottwalker3

I can do your project perfectly according to your requirement. Your project seems a little confused, but if you listen to my advice, then every thing would be clear. I am willing to provide you my fresh idea, and then More

$500 USD in 7 days
(0 Reviews)
0.0
nnyxest

with 20 Years of experience mainly in banking undustry i am sure i can automate this whole process for you Money back guaranteed if end results is not satisfactory. 1 month free support after delivery

$500 USD in 3 days
(0 Reviews)
0.0