Small Script Needed to run file, query URL, get XML result and update SQL file
$30-250 USD
Pagado a la entrega
I have an excel file of cities and their latitude and longitude. I need a script created that will grab run through the each line of the script, grab the lat & long for that city, then query a URL.
The URL will return an XML or JSON response of the 11 closest cities to that location. The script then needs to parse the results, ignore the first result (it will be the original city and we only want the closest cities) grab the city names and states of the other 10 results, then update the db with the names and their associated states. It will do this for each line of the db (as said, it's currently an excel file, but can be converted to MySQL).
Nº del proyecto: #13981827
Sobre el proyecto
11 freelancers están ofertando un promedio de $159 por este trabajo
Dear Prospective Client, As based on my initial review I can confirm its feasibility & as I am great fit technically and have good understanding of the domain & your requirement & would submit a detailed response so Más
hello, can you please send me sample excel file? it seems interesting thing (I haven't done exactly same thing but did something with geolocation), so I can try to do this.
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Más
Hello! Please send the sample Excel file. With 98% to 99% completion rate, 1000+ successfully completed projects, and a 4.99 reputation (maximum possible, 5.0) (can be verified on my profile page [login to view URL] Más
Hello, I am interested to work on your project. I understand your requirements. I am available now and can work on it right away. Looking forward to hear from you. Thanks