NetStumbler.org Forums

Go Back   NetStumbler.org Forums > NetStumbler Community > Scripts
Reload this Page Simple excel export script?
Register Search Today's Posts Mark Forums Read

Reply
 
LinkBack Thread Tools Display Modes
Old 10-17-2004   #1 (permalink)
webrunner
Registered Member
 
Join Date: Sep 2004
Location: Norway
Posts: 2
Simple excel export script?
I still haven't found a simple way to import Netstumbler data into Excel, preserving information like MAC address, SSID, Channel, detected speed, Vendor name, type, AP/AH, Encryption type, and the other fields available in Netstumbler.

I've tried to import the summary export data from Netstumbler, as well as importing data converted into MapSource (.wpt) etc...

I would *really* like to see some tool/script that could export all the available fields as seen in Netstumbler using semicolon ( as the separator into a simple textfile. Since i'm completely braindead on programming, i'm writing this to ask if anyone should have something like this already available...

Regards,
Webrunner
webrunner is offline   Reply With Quote
Old 10-17-2004   #2 (permalink)
King_Ice_Flash
Alien Paranoid Stumbler
 
King_Ice_Flash's Avatar
 
Join Date: May 2003
Location: WI
Posts: 2,626
Why can't you just import the summary export from NetStumbler into Excel?

Just import it from excel using "tab" as the delimiting character. Works for me.
__________________
"Yeah," said a voice from under the table, "you go to pieces so fast people get hit by the shrapnel."
King_Ice_Flash is offline   Reply With Quote
Old 10-17-2004   #3 (permalink)
wrzwaldo
I amuse you?
 
Join Date: Dec 2003
Posts: 9,127
Not sure what you are doing but I just opened a summary text file in Excel and everything is there.
wrzwaldo is offline   Reply With Quote
Old 03-07-2006   #4 (permalink)
hoosierguy
Registered Member
 
Join Date: Mar 2006
Posts: 1
I have the same problem this guy does. Exporting gives me: # Latitude Longitude ( SSID ) Type ( BSSID ) Time (GMT) [ SNR Sig Noise ] # ( Name ) Flags Channelbits BcnIntvl DataRate LastChannel

The ones I really need are WEP and Vender. Any ideas how I can accomplish this? Thanks!
hoosierguy is offline   Reply With Quote
Old 03-07-2006   #5 (permalink)
streaker69
Psychic Amish Stumbler
 
streaker69's Avatar
 
Join Date: Jul 2004
Location: Virginville, BlueBall, Bird In Hand, Intercourse, Paradise, PA
Posts: 11,838
Quote:
Originally Posted by hoosierguy
I have the same problem this guy does. Exporting gives me: # Latitude Longitude ( SSID ) Type ( BSSID ) Time (GMT) [ SNR Sig Noise ] # ( Name ) Flags Channelbits BcnIntvl DataRate LastChannel

The ones I really need are WEP and Vender. Any ideas how I can accomplish this? Thanks!
Yep, you can do the same thing I did when I needed an answer to that question. I searched the forums.
__________________
"One of these days, I'm going to cut you to pieces."

If you're offended by this post, please feel free to report it to one of the many helpful moderators of this forum.

Thank you.
streaker69 is offline   Reply With Quote
Old 03-07-2006   #6 (permalink)
beakmyn
root\.workspace\.garbage.
 
Join Date: Aug 2003
Posts: 4,805
Quote:
Originally Posted by webrunner
I still haven't found a simple way to import Netstumbler data into Excel, preserving information like MAC address, SSID, Channel, detected speed, Vendor name, type, AP/AH, Encryption type, and the other fields available in Netstumbler.

I've tried to import the summary export data from Netstumbler, as well as importing data converted into MapSource (.wpt) etc...

I would *really* like to see some tool/script that could export all the available fields as seen in Netstumbler using semicolon ( as the separator into a simple textfile. Since i'm completely braindead on programming, i'm writing this to ask if anyone should have something like this already available...

Regards,
Webrunner
Points to Signature
__________________
Daughter with arms inside shirt: "Daddy I'm not Armish"

┌──────────────────────────────┐
╞ NS Icons Explained|et hoc genus omne ╡
└──────────────────────────────┘
beakmyn is offline   Reply With Quote
Old 03-07-2006   #7 (permalink)
streaker69
Psychic Amish Stumbler
 
streaker69's Avatar
 
Join Date: Jul 2004
Location: Virginville, BlueBall, Bird In Hand, Intercourse, Paradise, PA
Posts: 11,838
Quote:
Originally Posted by beakmyn
Points to Signature
Reminds Beak to look at the date of the OP's post. I don't think you had that in your sig when it was posted.
__________________
"One of these days, I'm going to cut you to pieces."

If you're offended by this post, please feel free to report it to one of the many helpful moderators of this forum.

Thank you.
streaker69 is offline   Reply With Quote
Old 03-07-2006   #8 (permalink)
beakmyn
root\.workspace\.garbage.
 
Join Date: Aug 2003
Posts: 4,805
Quote:
Originally Posted by streaker69
Reminds Beak to look at the date of the OP's post. I don't think you had that in your sig when it was posted.
Ah crap, there goes my Karma.
__________________
Daughter with arms inside shirt: "Daddy I'm not Armish"

┌──────────────────────────────┐
╞ NS Icons Explained|et hoc genus omne ╡
└──────────────────────────────┘
beakmyn is offline   Reply With Quote
Reply

« A simple VBScript to update MS Access Database | Help with normalizing NS & Kismet signal levels »

Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



Google
 
Web NetStumbler.org

All times are GMT -7. The time now is 04:43 PM.

Contact Us - NetStumbler.org - NetStumbler.com - Online Backup - Archive - Top

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0 ©2007, Crawlability, Inc.


All messages express the views of the author and are for entertainment purposes only. Netstumbler.org cannot be held responsible for the authenticity of the content or the actions of its members. By using this site and its services, you warrant that you will not post any messages that are discriminating, obscene, hateful, threatening, or otherwise violates any laws and you release Netstumbler.org from any future claims of any kind whatsoever including, but not limited to, addiction and loss of productivity. All forum messages, private messages and any other content are properties of Netstumbler.org. Even if publicly available, personal or copyrighted information are not to be posted without the consent of the owner. Distribution of licensed and copyrighted materials in any way not endorsed by the copyright owner is strictly prohibited. You may not use this site and its resources to spam other sites or individuals or perform any action that violates any law. Items sold or bought in the For Sale forum are sold as is and no warranty or insurance of any kind is provided. Netstumbler.org cannot be held responsible for the outcome of any transactions and no warranty of any kind is provided, either express or implied. Vulgar words are not allowed in the subject lines ; they may be used in the message body in any forum. The Administrator, Super Moderators and Moderators of Netstumbler.org have the right to remove, edit, move or close any thread for any reason and to reveal your identity and other known information in the event of a complaint or legal action arising from any message posted by you.