Merging/Converting Kismet Logs?

Eyecannon · 01-03-2004

How are you cats merging your kismet logs together? It sucks having to convert 20 seperate files, I'd rather consolidate them all then just convert the one big file.

Also, I don't remember how I used to do it, so how are you all converting kismet logs into something that stumbverter can use?

Thanks!

Evil2000 · 01-03-2004

you can try this

Eyecannon · 01-03-2004

Quote:

Originally posted by Evil2000
you can try this

erm, this seems to just take a CSV and divide it into seperate files based on if there's GPS info or whatnot... I want a script that takes multiple CSV's (like *.csv) and turns it into one CSV.

Evil2000 · 01-03-2004

sorry, seems like i didn't understand you properly

i don't know about an app merging summaries, but i've written something similiar: i've created a mysql database to which you can upload netstumbler and kismet logs. you can export the whole list to a text file which then can be turned into a map using my own little VB-app and mappoint 2004 (not really nice coded, just quick-'n'-dirty

)
if there are peeps interested in this thingie i'll code it a bit nicer, translate it into english and release it

Kazig · 01-03-2004

Quote:

Originally posted by Eyecannon
erm, this seems to just take a CSV and divide it into seperate files based on if there's GPS info or whatnot... I want a script that takes multiple CSV's (like *.csv) and turns it into one CSV.

How about some quick and dirty old DOS commands, I'm sure there are some Linux equivalents.

type *.csv>>BigCSV.CSV

Madhadder · 01-03-2004

Quote:

Originally posted by Kazig
How about some quick and dirty old DOS commands, I'm sure there are some Linux equivalents.

type *.csv>>BigCSV.CSV

I always used copy file1.csv + file2.csv + file3.csv biffile.csv

Kazig · 01-03-2004

Quote:

Originally posted by Madhadder
I always used copy file1.csv + file2.csv + file3.csv biffile.csv

Doing it that way works too. But you need to write a batch file to create each merge. The copy file method is more efficient with processor/disk usage also. It just takes more effort.

Evil2000 · 01-03-2004

Quote:

Originally posted by Kazig
How about some quick and dirty old DOS commands, I'm sure there are some Linux equivalents.

type *.csv>>BigCSV.CSV

this will work for CSV-files, but not XML (thats what i use)

Wanderer · 01-03-2004

Quote:

Originally posted by Eyecannon
How are you cats merging your kismet logs together? It sucks having to convert 20 seperate files, I'd rather consolidate them all then just convert the one big file.

Convert in what way? Why would you need to merge the logs together, anyway?

Eyecannon · 01-03-2004

Quote:

Originally posted by Wanderer
Convert in what way? Why would you need to merge the logs together, anyway?

Because I have 20 or so CSV's representing a particular roadtrip, and it would be much easier to merge them, convert them, then stumbvert them, instead of converting 20 things, then merging them in netstumbler or something, then stumbverting.

As far as concatinating CSV's, are you guys sure that it works? Only reason I ask is because CSV's have a header, then each entry is numbered....

Madhadder · 01-03-2004

ah...

Now that I think of it NS, can merge .NS1,Summary & ???
files that it can output. No ext. prog. needed.

Once you get them all in one big .NS1, export to summary
and Stumbvert them.

Eyecannon · 01-03-2004

Quote:

Originally posted by Madhadder
ah...

Now that I think of it NS, can merge .NS1,Summary & ???
files that it can output. No ext. prog. needed.

Once you get them all in one big .NS1, export to summary
and Stumbvert them.

But NS doesn't take anything but NS1 files, so I'd have to convert the 20 CSV's into 20 NS1's then merge them, which is what I'm trying to avoid.

Warglue (well warkizniz and warbabel) do the job, but have no batch processing....

Madhadder · 01-03-2004

I used to merge the Summary or Wi-scan formatted text files
into .ns1 with NS.. Try it

sparafina · 01-03-2004

I don't recall if warglue has a merge utility. The CoWF site seems to be gone, but it seems to be archived in a lot of places.

Eyecannon · 01-03-2004

OK, the solution I have come up with is this:

1) use Kismet Log Viewer to merge the XML's into one big XML
2) use warbabel to convert the big XML into a Wiscan Summary

Then you can use the wiscan summary in either NS or SV.

01-03-2004	#1 (permalink)
Eyecannon Ward River Join Date: Aug 2002 Location: Santa Monix Posts: 679	Merging/Converting Kismet Logs? How are you cats merging your kismet logs together? It sucks having to convert 20 seperate files, I'd rather consolidate them all then just convert the one big file. Also, I don't remember how I used to do it, so how are you all converting kismet logs into something that stumbverter can use? Thanks! __________________ No, officer, YOU are under arrest! http://eyecannon.com/wardrive.html

01-03-2004	#11 (permalink)
Madhadder General "Noob Basher" Join Date: Apr 2002 Location: Munich, Germany Posts: 1,620	ah... Now that I think of it NS, can merge .NS1,Summary & ??? files that it can output. No ext. prog. needed. Once you get them all in one big .NS1, export to summary and Stumbvert them. __________________ Legends may sleep, but they never die!!!!

01-03-2004	#13 (permalink)
Madhadder General "Noob Basher" Join Date: Apr 2002 Location: Munich, Germany Posts: 1,620	I used to merge the Summary or Wi-scan formatted text files into .ns1 with NS.. Try it __________________ Legends may sleep, but they never die!!!!

01-03-2004	#15 (permalink)
Eyecannon Ward River Join Date: Aug 2002 Location: Santa Monix Posts: 679	OK, the solution I have come up with is this: 1) use Kismet Log Viewer to merge the XML's into one big XML 2) use warbabel to convert the big XML into a Wiscan Summary Then you can use the wiscan summary in either NS or SV. __________________ No, officer, YOU are under arrest! http://eyecannon.com/wardrive.html

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

01-03-2004	#2 (permalink)
Evil2000 Registered Member Join Date: Sep 2003 Posts: 40	you can try this

01-03-2004	#4 (permalink)
Evil2000 Registered Member Join Date: Sep 2003 Posts: 40	sorry, seems like i didn't understand you properly i don't know about an app merging summaries, but i've written something similiar: i've created a mysql database to which you can upload netstumbler and kismet logs. you can export the whole list to a text file which then can be turned into a map using my own little VB-app and mappoint 2004 (not really nice coded, just quick-'n'-dirty ) if there are peeps interested in this thingie i'll code it a bit nicer, translate it into english and release it

01-03-2004	#14 (permalink)
sparafina Registered Member Join Date: May 2002 Location: Julie Speed Posts: 1,430	I don't recall if warglue has a merge utility. The CoWF site seems to be gone, but it seems to be archived in a lot of places.