<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Basics of API? How to read and dowload/save the results?"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Basics of API? How to read and dowload/save the results?"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Basics of API? How to read and dowload/save the results?</title>
				<description><![CDATA[ Hi there,
I've got about 2,000 spreadsheet entries with longitude and latitude co-ordinates but no country code so I'm looking for a way to add the country codes to each record. 

I stumbled upon geonames today and it looks as if I can submit individual URLs in this format

http://api.geonames.org/countryCode?lat=45.03&lng=8.2&username=demo

and the page then displays a country code.

But how do I "read/save" each page result back into my database??

I have purchased a basic scraper program as I thought I could scrap the results page but the results page contains no html to use as placemarkers so I'm stumped.

I'm not a developer or very technical so I don't know how to use APIs.

Any help gratefully received!
Jason ]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/4105.page#12167</guid>
				<link>http://forum.geonames.org/gforum/posts/list/4105.page#12167</link>
				<pubDate><![CDATA[Fri, 25 Jan 2013 06:46:29]]> GMT</pubDate>
				<author><![CDATA[ JasonAndrews]]></author>
			</item>
			<item>
				<title>Re:Basics of API? How to read and dowload/save the results?</title>
				<description><![CDATA[ Hi Jason

If it is an Excel spreadsheet, then this way >>>

1. Somewhere in the Workbook make a DataImport-WebQuery with your sample LatLon

2. In the datasheet comes a macro who goes through every row of data and >>>
- reconstructs the sample query string with the LatLon of this row
- sends the new string to the WebQuery and makes a Refresh
- gets the new result from the reply cell of the WebQuery
- puts the CountryCode in a cell of the data row

Regards

Urs 

]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/4105.page#12172</guid>
				<link>http://forum.geonames.org/gforum/posts/list/4105.page#12172</link>
				<pubDate><![CDATA[Sat, 26 Jan 2013 07:37:16]]> GMT</pubDate>
				<author><![CDATA[ saphir]]></author>
			</item>
			<item>
				<title>Re:Basics of API? How to read and dowload/save the results?</title>
				<description><![CDATA[ Great - thanks for your help. I tried to follow your example. Made it work with individual lines but couldn't work out how to make the macro so got a colleague to write a php script in the end. 

Thanks though - Jason]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/4105.page#12192</guid>
				<link>http://forum.geonames.org/gforum/posts/list/4105.page#12192</link>
				<pubDate><![CDATA[Tue, 29 Jan 2013 20:02:00]]> GMT</pubDate>
				<author><![CDATA[ JasonAndrews]]></author>
			</item>
	</channel>
</rss>