mappoint 2004 bug?

localhost · 05-01-2004

I wrote a program that converts netstumbler summary files into tab delimited files for importing with mappoint.

part of the script is that it breaks apart the channel bits into comma separated channels. i.e. 0440 becomes 6,10.

but the problem is when i import it into netstumbler, everything works fine except the channel column.

ANY data in the channel column with a comma gets replaced with "", while anything without it works fine.

I tried copying/pasting the data into an excel spreadsheet and then importing that into netstumbler and it worked like a charm.

has anyone else noticed this bug? any workarounds?

iceburn68 · 05-01-2004

Quote:

Originally Posted by localhost

I wrote a program that converts netstumbler summary files into tab delimited files for importing with mappoint.

part of the script is that it breaks apart the channel bits into comma separated channels. i.e. 0440 becomes 6,10.

but the problem is when i import it into netstumbler, everything works fine except the channel column.

ANY data in the channel column with a comma gets replaced with "", while anything without it works fine.

I tried copying/pasting the data into an excel spreadsheet and then importing that into netstumbler and it worked like a charm.

has anyone else noticed this bug? any workarounds?

Wait, re-write that making sure you used NS and Mappoint in the right places, cause how i read it now I don't see what your trying to accomplish . . .

localhost · 05-01-2004

Sorry, you're right. here is the fix.

I wrote a program that converts netstumbler summary files into tab delimited files for importing with mappoint.

part of the script is that it breaks apart the channel bits into comma separated channels. i.e. 0440 becomes 6,10.

but the problem is when i import it into mappoint, everything works fine except the channel column.

ANY data in the channel column with a comma gets replaced with "", while anything without it works fine.

I tried copying/pasting the data into an excel spreadsheet and then importing that into mappoint and it worked like a charm.

has anyone else noticed this bug? any workarounds?

iceburn68 · 05-01-2004

Ok, I'm looking at an export as we speak, but I'm not sure what channel bits is? I get 400, 800, 200, 40, 20, 10, etc . . .

So what exactly are those numbers?

Once i know what they are suppost to convert into I can help you with your script?

also, just a question but is there a reason you don't like using Stumbverter?

I know the streets and trips community would like this script your writing though . . . they are outta luck in 0.4.0 last i heard . . .

localhost · 05-01-2004

its the 9th field i think in the summary file...

its a sorta-bit-like setup: here is how it goes

1234 -

4 represents channels 1, 2 and 3
3 represents channesl 4,5,6,7
2 represents 8,9,10,11
1 represents 12,13,14

so

4884 would be channels 3, 7, 11, and 14

but if i break that number into 3,7,11,14 then when i import it mappoint will just replace it with ""

a channel bit of 0001 which is channel 1 would show up fine.

im not too big on stumbverter because you dont have too much control over it and i also have my program generate statistics about the data.

Thorn · 05-01-2004

localhost,
Try changing the comma to some other punctuation symbol such as a dash. I've encountered a similare problem with S&T converting fields that contain commas. I suspect it has to do with internal conversions on CSV imports, although it is purely a guess.

==================================================

Quote:

Originally Posted by iceburn68

Ok, I'm looking at an export as we speak, but I'm not sure what channel bits is? I get 400, 800, 200, 40, 20, 10, etc . . .

So what exactly are those numbers?
...

Perhaps you should consider using the SEARCH function before posting.

http://forums.netstumbler.com/showth...t=channel+bits

Quote:

Originally Posted by iceburn68

I know the streets and trips community would like this script your writing though . . . they are outta luck in 0.4.0 last i heard . . .

Say who? My script works just fine. (Again, try the SEARCH.)

iceburn68 · 05-01-2004

Now I'm really confused, if I put any kind of symbol in, your right it shows up blank, even if I use ":" marks which are used in the MAC address without problem, it shows up blank . . . I'll keep trying stuff, this has become quite the challenge . . .

localhost · 05-01-2004

the problem is not in the delimiter itself. i used tabs for the sole reason that i didnt want it to confuse it with a .csv file.

the problem lies in the number of delimiters per element.

0:0:4:3 and 14:0:0:3 works fine
4:3 and 14:3 does not

i think it EXPECTS a certain number of delimiters based on what it has already read in ... or something like that. so far the only way i've found around is to just do it like the first example that i said in this reply

iceburn68 · 05-01-2004

Here is one solution I found, make it look like hte following, without hte quotes: "[2,3,11]" . . . seemed to work for me . . .

iceburn68 · 05-01-2004

Quote:

Originally Posted by Thorn

localhost,
Try changing the comma to some other punctuation symbol such as a dash. I've encountered a similare problem with S&T converting fields that contain commas. I suspect it has to do with internal conversions on CSV imports, although it is purely a guess.

==================================================

Perhaps you should consider using the SEARCH function before posting.

http://forums.netstumbler.com/showth...t=channel+bits

Say who? My script works just fine. (Again, try the SEARCH.)

Sorry bout that . . .

A. I thought i was having more of a conversation with him thats why i asked him about the bits

B. I didn't know you wrote a script for Streets and Trips, I just remember someone compalining cause StreetStumbler no longer worked, since I've upgraded to Mappoint I haven't been following it anymore, my appologies.

05-01-2004	#1 (permalink)
localhost I'm always at 127.0.0.1 Join Date: Mar 2004 Posts: 26	mappoint 2004 bug? I wrote a program that converts netstumbler summary files into tab delimited files for importing with mappoint. part of the script is that it breaks apart the channel bits into comma separated channels. i.e. 0440 becomes 6,10. but the problem is when i import it into netstumbler, everything works fine except the channel column. ANY data in the channel column with a comma gets replaced with "", while anything without it works fine. I tried copying/pasting the data into an excel spreadsheet and then importing that into netstumbler and it worked like a charm. has anyone else noticed this bug? any workarounds?

05-01-2004	#4 (permalink)
iceburn68 Registered Member Join Date: Feb 2004 Posts: 206	Ok, I'm looking at an export as we speak, but I'm not sure what channel bits is? I get 400, 800, 200, 40, 20, 10, etc . . . So what exactly are those numbers? Once i know what they are suppost to convert into I can help you with your script? also, just a question but is there a reason you don't like using Stumbverter? I know the streets and trips community would like this script your writing though . . . they are outta luck in 0.4.0 last i heard . . . __________________ My Wardriving Website

05-01-2004	#7 (permalink)
iceburn68 Registered Member Join Date: Feb 2004 Posts: 206	Now I'm really confused, if I put any kind of symbol in, your right it shows up blank, even if I use ":" marks which are used in the MAC address without problem, it shows up blank . . . I'll keep trying stuff, this has become quite the challenge . . . __________________ My Wardriving Website

05-01-2004	#9 (permalink)
iceburn68 Registered Member Join Date: Feb 2004 Posts: 206	Here is one solution I found, make it look like hte following, without hte quotes: "[2,3,11]" . . . seemed to work for me . . . __________________ My Wardriving Website

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

05-01-2004	#3 (permalink)
localhost I'm always at 127.0.0.1 Join Date: Mar 2004 Posts: 26	Sorry, you're right. here is the fix. I wrote a program that converts netstumbler summary files into tab delimited files for importing with mappoint. part of the script is that it breaks apart the channel bits into comma separated channels. i.e. 0440 becomes 6,10. but the problem is when i import it into mappoint, everything works fine except the channel column. ANY data in the channel column with a comma gets replaced with "", while anything without it works fine. I tried copying/pasting the data into an excel spreadsheet and then importing that into mappoint and it worked like a charm. has anyone else noticed this bug? any workarounds?

05-01-2004	#5 (permalink)
localhost I'm always at 127.0.0.1 Join Date: Mar 2004 Posts: 26	its the 9th field i think in the summary file... its a sorta-bit-like setup: here is how it goes 1234 - 4 represents channels 1, 2 and 3 3 represents channesl 4,5,6,7 2 represents 8,9,10,11 1 represents 12,13,14 so 4884 would be channels 3, 7, 11, and 14 but if i break that number into 3,7,11,14 then when i import it mappoint will just replace it with "" a channel bit of 0001 which is channel 1 would show up fine. im not too big on stumbverter because you dont have too much control over it and i also have my program generate statistics about the data.

05-01-2004	#8 (permalink)
localhost I'm always at 127.0.0.1 Join Date: Mar 2004 Posts: 26	the problem is not in the delimiter itself. i used tabs for the sole reason that i didnt want it to confuse it with a .csv file. the problem lies in the number of delimiters per element. 0:0:4:3 and 14:0:0:3 works fine 4:3 and 14:3 does not i think it EXPECTS a certain number of delimiters based on what it has already read in ... or something like that. so far the only way i've found around is to just do it like the first example that i said in this reply