ns2kml - Netstumbler to Google Earth

flipo · 07-07-2005

Hello!

Google Earth Rocks!

It's pretty simple to integrate outside information, so I wrote a small app to import Netstumbler's Summary Files (File/Export/Summary...) into google earth's own .kml Files.

(it was developed using vb.net, so you probably need .net framework)

Full source is included and you can do whatever you want with it.
(I'm no programmer, so be gentle on the critics

)

To do list:
- different icons for Encrypted/Non encrypted networks
- kmz file generation (just zip the kml and change extension!)
- ideas?

FlipO'2005

G8tK33per · 07-07-2005

Moved to scripts.

spanner · 09-20-2005

This script is pretty cool. Is there a size limit to what it can handle? I've got a 4.3mb (900+ AP) .ns1 file that distills down to something like 100kb, but I keep running into an error when I try opening the .kml file in Google Earth:

Open of file "G:/allsummary.kml" failed: Parse error: Parse error: Unterminated entity reference at line: 480 at line:480

NS 0.4.0 b554 opens the summary file happily.

beakmyn · 09-20-2005

Hmm, what's on line 480 of the file?

spanner · 09-20-2005

No idea. I don't have a text editor that gives me line numbers...

I did some poking around, and got most of the file imported. I'll try to find the offending entry at home tonight.

goldfndr · 09-20-2005

Quote:

Originally Posted by spanner

No idea. I don't have a text editor that gives me line numbers...

Yes you do: EDIT.COM!!! Check it out!

beakmyn · 09-20-2005

or TextPad

Madhadder · 09-21-2005

Iv'e tried this script on 10 different NS1 files ranging in size from 50k to 10MB
and every time it gives an error "Something funky going on here" etc...
.
Looks like you need to go back thru the code and find some bugs...

theprez98 · 09-21-2005

Quote:

Originally Posted by Madhadder

Iv'e tried this script on 10 different NS1 files ranging in size from 50k to 10MB
and every time it gives an error "Something funky going on here" etc...
.
Looks like you need to go back thru the code and find some bugs...

I've had the same problem with any files I tried.

spanner · 09-21-2005

Thanks to goldfndr, I've got an idea what may be happening.

The entry that is causing the problem seems to have reserved characters in the name.

Line 479:
<Placemark><description><![CDATA[SSID: D&J's Radio Network BSSID: a6:00:93:02:f7:02 Last Update: 2002-01-19 - 17:29:12 (GMT) [SNR Signal Noise]: [ 29 78 49 ]]]></description>

Line 480:
<name>D&J's Radio Network</name><styleUrl>root://styles#default+icon=0x307</styleUrl>
<Point><coordinates>-84.5151833,39.1032000,0</coordinates></Point>

Line 481:
</Placemark>

The only thing that's different between those three lines and the surrounding ones are the & and ' characters. HTML doesn't like un-escaped & characters, and since it has the same basic structure as KML, the same may apply.

beakmyn · 09-21-2005

Quote:

Originally Posted by spanner

Thanks to goldfndr, I've got an idea what may be happening.

The entry that is causing the problem seems to have reserved characters in the name.

Line 479:
<Placemark><description><![CDATA[SSID: D&J's Radio Network BSSID: a6:00:93:02:f7:02 Last Update: 2002-01-19 - 17:29:12 (GMT) [SNR Signal Noise]: [ 29 78 49 ]]]></description>

Line 480:
<name>D&J's Radio Network</name><styleUrl>root://styles#default+icon=0x307</styleUrl>
<Point><coordinates>-84.5151833,39.1032000,0</coordinates></Point>

Line 481:
</Placemark>

The only thing that's different between those three lines and the surrounding ones are the & and ' characters. HTML doesn't like un-escaped & characters, and since it has the same basic structure as KML, the same may apply.

Yes, the kml format doesn't like anything but numbers ans letters in the description and name fields. It's HTML sensitive. You'll have to use the <![CDATA[ ] structure to tell Google earth to ignore it.

I.E. <name><![CDATA[D&J's Radio Network]</name>

Scruge · 09-21-2005

Quote:

Originally Posted by spanner

This script is pretty cool. Is there a size limit to what it can handle? I've got a 4.3mb (900+ AP) .ns1 file that distills down to something like 100kb.

I've been able to load 60k+ APs into GE with beakmyn's NSrecovery tool and using 5x5 icons and no descriptions.
Another trick is to load each of your kml's individually into GE. GE will setup a new folder for each and append the master kmz file and allow you to select what you want displayed.

The only down side I've found is the startup time for GE increases to 3-4minutes with 60k POIs in the kmz.

dschumann · 10-06-2005

You could always replace ' with ' to prevent errors in the reading of the xml.

Replace(SomeString, "'", "'")
Replace(SomeString, "&", "&")

07-07-2005	#2 (permalink)
G8tK33per Asshole Emeritus Join Date: May 2003 Location: S.E. VA. Posts: 5,939	Moved to scripts. __________________ "Benjamin is nobody's friend. If Benjamin were an ice cream flavor, he'd be pralines and dick." Sons of Confederate Veterans

09-20-2005	#4 (permalink)
beakmyn root\.workspace\.garbage. Join Date: Aug 2003 Posts: 4,805	Hmm, what's on line 480 of the file? __________________ Daughter with arms inside shirt: "Daddy I'm not Armish" ┌──────────────────────────────┐ ╞ NS Icons Explained\|et hoc genus omne ╡ └──────────────────────────────┘

09-20-2005	#7 (permalink)
beakmyn root\.workspace\.garbage. Join Date: Aug 2003 Posts: 4,805	or TextPad __________________ Daughter with arms inside shirt: "Daddy I'm not Armish" ┌──────────────────────────────┐ ╞ NS Icons Explained\|et hoc genus omne ╡ └──────────────────────────────┘

09-21-2005	#8 (permalink)
Madhadder General "Noob Basher" Join Date: Apr 2002 Location: Munich, Germany Posts: 1,620	Iv'e tried this script on 10 different NS1 files ranging in size from 50k to 10MB and every time it gives an error "Something funky going on here" etc... . Looks like you need to go back thru the code and find some bugs... __________________ Legends may sleep, but they never die!!!!

09-21-2005	#10 (permalink)
spanner Registered Member Join Date: May 2002 Posts: 13	Thanks to goldfndr, I've got an idea what may be happening. The entry that is causing the problem seems to have reserved characters in the name. Line 479: <Placemark><description><![CDATA[SSID: D&J's Radio Network <br> BSSID: a6:00:93:02:f7:02<br>Last Update: 2002-01-19 - 17:29:12 (GMT) <br> [SNR Signal Noise]: [ 29 78 49 ]]]></description> Line 480: <name>D&J's Radio Network</name><styleUrl>root://styles#default+icon=0x307</styleUrl> <Point><coordinates>-84.5151833,39.1032000,0</coordinates></Point> Line 481: </Placemark> The only thing that's different between those three lines and the surrounding ones are the & and ' characters. HTML doesn't like un-escaped & characters, and since it has the same basic structure as KML, the same may apply.

09-20-2005	#3 (permalink)
spanner Registered Member Join Date: May 2002 Posts: 13	This script is pretty cool. Is there a size limit to what it can handle? I've got a 4.3mb (900+ AP) .ns1 file that distills down to something like 100kb, but I keep running into an error when I try opening the .kml file in Google Earth: Open of file "G:/allsummary.kml" failed: Parse error: Parse error: Unterminated entity reference at line: 480 at line:480 NS 0.4.0 b554 opens the summary file happily.

09-20-2005	#5 (permalink)
spanner Registered Member Join Date: May 2002 Posts: 13	No idea. I don't have a text editor that gives me line numbers... I did some poking around, and got most of the file imported. I'll try to find the offending entry at home tonight.

10-06-2005	#13 (permalink)
dschumann Registered Member Join Date: Oct 2005 Posts: 1	You could always replace ' with ' to prevent errors in the reading of the xml. Replace(SomeString, "'", "'") Replace(SomeString, "&", "&")

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode