In Progress

Import XML to SQL database

I am working on a website for a real estate agent who is using a program called "Console" for data input. This program creates a ZIP file for each listing. The ZIP contains an XML file with all the listing data, and all of the images. What is required: 1. Create a way to read data from this ZIP file and insert it into the mySQL database [url removed, login to view] ALL images from the ZIP to the server in a directory to be specified. Filenames must remain unchanged. 3. The XML file contains a LISTING ID. This ID MUST be used to create a new folder for storing of the listing images. 4. Upon successful importing of this data, the ZIP file MUST be deleted from the server. Optional: 1. Create the database tables for the XML file (or i can do this prior to commencement of the project) Notes: This is a Linux server, running cPanel. The files when uploaded are placed in the root directory of the site. Please ask any questions prior to placing your bid. I will provide samples of the ZIP files. I beleive there are several variations of the XML data based on each different listing type. However it is preferred that all the data be inserted to the same table. This table could have as many as 100 fields in it.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):

a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Linux

Skills: MySQL, PHP, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing, XML, XSLT

See more: xml coder, what is package in sql, sql database program, sql coder for hire, questions to ask a new hire, new hire questions to ask, hire real estate agent, database hire, cpanel mysql database, buyer agent, sql database website, mysql to sql, import XML, hire sql, hire agent, data source sql, console sql, import xml file mysql database php, mysql database import, linux create zip file, php insert xml, xml import mysql php, sql different, project real estate using php mysql, sql required

About the Employer:
( 111 reviews ) Brisbane, Australia

Project ID: #2912393

Awarded to:

danieladacruz

See private message.

$170 USD in 10 days
(131 Reviews)
6.4

21 freelancers are bidding on average $151 for this job

taro

See private message.

$340 USD in 10 days
(22 Reviews)
5.8
phosphorvw

See private message.

$127.5 USD in 10 days
(90 Reviews)
5.9
tofeeqsl

See private message.

$195.5 USD in 10 days
(36 Reviews)
5.8
xsixer

See private message.

$17 USD in 10 days
(127 Reviews)
6.0
CTVentures

See private message.

$170 USD in 10 days
(50 Reviews)
5.6
khalidamin

See private message.

$323 USD in 10 days
(44 Reviews)
5.1
csharpsourcescom

See private message.

$85 USD in 10 days
(33 Reviews)
4.7
satsust

See private message.

$85 USD in 10 days
(17 Reviews)
4.7
dexter01

See private message.

$85 USD in 10 days
(43 Reviews)
4.6
vw7258315vw

See private message.

$85 USD in 10 days
(49 Reviews)
4.8
technuts

See private message.

$85 USD in 10 days
(15 Reviews)
3.5
samarthinfotech

See private message.

$153 USD in 10 days
(4 Reviews)
2.8
majestysoftware

See private message.

$170 USD in 10 days
(4 Reviews)
3.1
manishmohania

See private message.

$25.5 USD in 10 days
(6 Reviews)
2.3
prosolutionvw

See private message.

$425 USD in 10 days
(8 Reviews)
4.6
softscribe

See private message.

$85 USD in 10 days
(4 Reviews)
1.2
Solvease

See private message.

$170 USD in 10 days
(2 Reviews)
0.6
dianapotlog

See private message.

$127.5 USD in 10 days
(0 Reviews)
0.0
tremendousSoft09

See private message.

$72.25 USD in 10 days
(1 Review)
0.0
kaligdss

See private message.

$170 USD in 10 days
(3 Reviews)
0.0