<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Troubleshooting with Excel XmlMap"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Troubleshooting with Excel XmlMap"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Troubleshooting with Excel XmlMap</title>
				<description><![CDATA[ Hi,

I am experiencing some troubleshooting with the XL macro I developped to geocode list of locations placed in my spreadsheet. That macro was running perfectly a month ago and is not working anymore.

I tried the following example, once directly by typing the URL in Internet Explorer and secondly using XL macro :
           sendstring = "http://ws.geonames.org/postalCodeSearch?postalcode=9011&maxRows=10"
           ActiveWorkbook.XmlMaps("Geo_Zip").Import URL:=sendstring

The URL works fine with IE but not with XL (And belive me I have the proper XMLMAP in the XL file)  :?: 

Is there any limitation for XL users ?  :? 

David.]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/157.page#823</guid>
				<link>http://forum.geonames.org/gforum/posts/list/157.page#823</link>
				<pubDate><![CDATA[Tue, 12 Sep 2006 21:56:09]]> GMT</pubDate>
				<author><![CDATA[ Anonymous]]></author>
			</item>
			<item>
				<title>Re:Troubleshooting with Excel XmlMap</title>
				<description><![CDATA[ Hi David

There is certainly no limitation for XL users. I am not sure when the totalResultsCount element was introduced, it is possible that this broke your code.

Regards

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/157.page#830</guid>
				<link>http://forum.geonames.org/gforum/posts/list/157.page#830</link>
				<pubDate><![CDATA[Wed, 13 Sep 2006 16:19:00]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:Troubleshooting with Excel XmlMap</title>
				<description><![CDATA[ Thank you Marc for the answer.

However, I tride to simply import data in XL : Data->Import Exter. Data-> Import Data.

I tried with the following URL :
http://api.search.yahoo.com/WebSearchService/V1/webSearch?appid=YahooDemo&query=Dan+Rather&results=10

And it works fine.

Then I tried with : 
http://ws.geonames.org/search?q=london&maxRows=10

And I get an error : Could Not open 'http://ws.geonames.org/search?q=london&maxRows=10'

So I think that my problem come from geonames Vs Excel since I get the pefect answer with IE 6.0.And it works well in july.

Any idea ?

David.
]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/157.page#839</guid>
				<link>http://forum.geonames.org/gforum/posts/list/157.page#839</link>
				<pubDate><![CDATA[Thu, 14 Sep 2006 21:07:54]]> GMT</pubDate>
				<author><![CDATA[ Anonymous]]></author>
			</item>
	</channel>
</rss>