In Progress

XML to MYSQL to XML

Hi, I am looking for someone to write a simple AP that will call a web service every 10 mins (to be configurable by me in the future) download the XML data from this web service and populate a MYSQL database with asset data.

From the Database I then need to be able to select and filter specific assets to form another Web service Feed out of the Database to be called by another server.

Possibly a simple UI to manage the outbound XML web service asset filter

All assets are uniquely ID with an 8 digit number...

Example of the inbound XML below...

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

<VESSELS>

<vessel MMSI="264162572" TIME="2011-04-12 10:50:11 GMT" LONGITUDE="[url removed, login to view]" LATITUDE="[url removed, login to view]" COG="237.4" SOG="6.6" HEADING="511" NAVSTAT="5" IMO="0" NAME="SULINA1" CALLSIGN="YP2572" TYPE="70" A="68" B="12" C="6" D="2" DRAUGHT="2.4" DEST="ROTTERDAM" ETA="03-15 10:00" />

<vessel MMSI="244670509" TIME="2011-04-12 10:44:54 GMT" LONGITUDE="[url removed, login to view]" LATITUDE="[url removed, login to view]" COG="117" SOG="5.6" HEADING="511" NAVSTAT="15" IMO="0" NAME="VALENCIA" CALLSIGN="PD2667" TYPE="79" A="74" B="11" C="0" D="10" DRAUGHT="1.4" DEST="" ETA="01-16 13:10" />

<vessel MMSI="366993070" TIME="2011-04-12 10:50:27 GMT" LONGITUDE="[url removed, login to view]" LATITUDE="[url removed, login to view]" COG="353.5" SOG="0" HEADING="511" NAVSTAT="0" IMO="0" NAME="KOOLCAT" CALLSIGN="WDC2431" TYPE="31" A="3" B="24" C="5" D="2" DRAUGHT="15.5" DEST="WORKING GNOTS FLEET" ETA="09-01 00:00" />

<vessel MMSI="211177720" TIME="2011-04-12 10:50:26 GMT" LONGITUDE="[url removed, login to view]" LATITUDE="[url removed, login to view]" COG="0" SOG="0" HEADING="511" NAVSTAT="0" IMO="0" NAME="DETTMER TANK 83" CALLSIGN="DB4027" TYPE="80" A="64" B="16" C="6" D="3" DRAUGHT="0" DEST="" ETA="00-00 24:60" />

<vessel MMSI="246538000" TIME="2011-04-12 10:50:24 GMT" LONGITUDE="[url removed, login to view]" LATITUDE="[url removed, login to view]" COG="263.2" SOG="0" HEADING="511" NAVSTAT="0" IMO="7700180" NAME="SIRIUS" CALLSIGN="PBRW" TYPE="52" A="6" B="20" C="3" D="5" DRAUGHT="4.8" DEST="IJMUIDEN" ETA="12-31 00:00" />

<vessel MMSI="211506060" TIME="2011-04-12 10:50:00 GMT" LONGITUDE="[url removed, login to view]" LATITUDE="[url removed, login to view]" COG="296.2" SOG="7" HEADING="511" NAVSTAT="5" IMO="0" NAME="BERLENA" CALLSIGN="DA4565" TYPE="79" A="70" B="15" C="3" D="7" DRAUGHT="0" DEST="ROTTERDAM" ETA="00-00 24:60" />

</VESSELS>

I will provide windows 2008 virtual server to work on...

Any questions please contact me directly...

Andy

Skills: HTML, MySQL, PHP, Software Architecture, XML

See more: xml mysql, xml mysql 2011, xml web server, populate xml database, mysql questions, mysql database download windows, download mysql database windows, call andy, mysql ui, andy d, download mysql, vessel, longitude, iso 7, fleet, ap, andy, web service php mysql, mysql select filter, feed data xml, mysql specific, write mysql, mysql windows server 2008, mysql server example, xml web service mysql

About the Employer:
( 12 reviews ) Shoreham By Sea, United Kingdom

Project ID: #1280547

Awarded to:

intechwebworks

hello Sir we are ready for this job.please check PM! Thankyou.

$85 USD in 1 day
(18 Reviews)
5.4

22 freelancers are bidding on average $139 for this job

toinnisfree

pls chk pmb

$200 USD in 3 days
(581 Reviews)
8.0
SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$120 USD in 1 day
(246 Reviews)
7.8
ambar

Dear Sir/Madam, We have a few suggestion about this project. Please check my private message. Thanks

$130 USD in 7 days
(96 Reviews)
7.5
srinichal

I can deliver the app asap

$150 USD in 4 days
(101 Reviews)
7.2
phpgenin

hi andy.interested in building your app. alex

$120 USD in 3 days
(73 Reviews)
7.0
Sphinks

I can start working on this project today. Regards, Sphinks!

$150 USD in 1 day
(88 Reviews)
6.6
gsala81

Hello, 10+ years exp full time freelancer here, can deliver a quality & professional work in the timeframe posted. Please contact me via PM for any question, Thanks.

$150 USD in 1 day
(46 Reviews)
6.4
qtorixsystems

hi please check pm.

$250 USD in 4 days
(24 Reviews)
6.3
Linkbuild

Kindly have a look at PMB, Thank You

$220 USD in 7 days
(35 Reviews)
6.4
gangabass

I can do this for you. See PM for details.

$100 USD in 2 days
(136 Reviews)
5.9
freelancerbuzzo

Ready to start right now.

$100 USD in 2 days
(13 Reviews)
4.4
MovEdx01

Hello, i can write windows application for you, i will make it fully configurable. Please see my message in your PMB.

$72 USD in 2 days
(13 Reviews)
4.0
kpremkumarcse

This is a simple work i can do it in no time.

$100 USD in 5 days
(4 Reviews)
3.8
HardwareDesign

hi i m PHP5/Ajax/Xml/Jquery developer i can do it ready to start and so motivated Regards

$75 USD in 3 days
(9 Reviews)
3.3
freelanceroct09

hi please check pmb

$200 USD in 4 days
(1 Review)
1.0
emilst

Hi, i am ready to start.

$100 USD in 1 day
(1 Review)
1.0
kyrmit

Hello, I am happy to help with this interesting task.

$200 USD in 5 days
(0 Reviews)
0.0
manuambady

Hi, We are an Indian based company working on multiple platforms. Our resources are well experienced and dedicated. We can deliver quality results. Regards, Manu

$150 USD in 5 days
(0 Reviews)
0.0
prashantniva

this is my expertise to do it very fast. need more info please send me demo work.

$100 USD in 2 days
(0 Reviews)
0.0
nhthai2207

Hi sir! I like your project. Please let me perform it for you!

$100 USD in 5 days
(0 Reviews)
0.0