Darkwind - Viewing Topic: Data Export Tool
Welcome Guest! » Darkwind » Testing » Suggestions » Data Export Tool

Pages: << prev 1, 2 next >> Reply to Topic Create New Topic Create New Poll
Data Export Tool, For the data geeks
Zephyr
River City Gamblers
Darkwind Guru

Evan Reds Faction

Member Level

Group: Subscribers
Posts: 551
Joined: Dec 12, 2009

Send an email to Zephyr Send a personal messsage to Zephyr Reply with a quote from this post Go to the top of the page

So I'm a data geek, and I would like to be able to track my gang's data. but all that manual re-typing is a pain. I would like an ability to export the data about my gang into a file I can upload into Excel or some other spreadsheeting software, so I can better track the growth in my gangers' skills and stats. Would this be difficult to implement?
.........................
vet wv

Posted Sep 21, 2010, 1:01 am
Marrkos
88 MPH
Darkwind Guru

Renegade

Avatar

Member Level

Group: Members
Posts: 3,711
Joined: Mar 28, 2006

Send an email to Marrkos Visit Marrkos's web site Send a personal messsage to Marrkos Reply with a quote from this post Go to the top of the page

Long ago, in the days of yore..
.........................
vet wv community

Posted Sep 21, 2010, 1:29 am
Zephyr
River City Gamblers
Darkwind Guru

Evan Reds Faction

Member Level

Group: Subscribers
Posts: 551
Joined: Dec 12, 2009

Send an email to Zephyr Send a personal messsage to Zephyr Reply with a quote from this post Go to the top of the page

You know, before i created this topic, I searched on "Excel," "spreadsheet" and "export," and got zero hits. Argh.


so anyway... did anything come of this thread you mention?
.........................
vet wv

Posted Sep 21, 2010, 1:48 am Last edited Sep 21, 2010, 1:49 am by Zephyr
Marrkos
88 MPH
Darkwind Guru

Renegade

Avatar

Member Level

Group: Members
Posts: 3,711
Joined: Mar 28, 2006

Send an email to Marrkos Visit Marrkos's web site Send a personal messsage to Marrkos Reply with a quote from this post Go to the top of the page

Nope.

I assume Sam put it on his list, but it probably got bumped down pretty quick.
.........................
vet wv community

Posted Sep 21, 2010, 1:55 am
*goat starer*
Special Circumstances
Darkwind Guru

Evan Reds Faction

Avatar

Member Level

Group: Contributors
Posts: 10,908
Joined: Oct 29, 2007

Send an email to *goat starer* Send a personal messsage to *goat starer* Reply with a quote from this post Go to the top of the page

Marrkos said:
Nope.

I assume Sam put it on his list, but it probably got bumped down pretty quick.


he filed it in the special round 'In Tray' under his desk...

the same one that all my bug reports go into  :cyclops:
.........................
vet wv zom pvp4 cont community deathrceL1 marshal pvp3 pvp2

Posted Sep 21, 2010, 8:28 am
*sam*
The Salthill Sluggerz
Darkwind Guru

Renegade

Avatar

Member Level

Group: Lead Developer
Posts: 16,781
Joined: Jan 19, 2006

Send an email to *sam* Send a personal messsage to *sam* Reply with a quote from this post Go to the top of the page

I have actually written some data export functions, for nbk_redspy who was working on a Helper app. that he was going to make available..

He seems to have stalled in this development however.. lemme see what I can find..
.........................
marshal vet deathrce1 paintladder combat1 wv ped1 cont slay2013

Posted Sep 21, 2010, 8:29 am
*sam*
The Salthill Sluggerz
Darkwind Guru

Renegade

Avatar

Member Level

Group: Lead Developer
Posts: 16,781
Joined: Jan 19, 2006

Send an email to *sam* Send a personal messsage to *sam* Reply with a quote from this post Go to the top of the page

goat starer said:
Marrkos said:
Nope.

I assume Sam put it on his list, but it probably got bumped down pretty quick.


he filed it in the special round 'In Tray' under his desk...

the same one that all my bug reports go into  :cyclops:



LOL, good one  ;-)

It's actually a big black binliner, goat.

I used to joke with my students, telling them to file their assignments in the bin in the corner... before I realised this was politically incorrect to say that... er... I mean before I realised how important it was to read them.
.........................
marshal vet deathrce1 paintladder combat1 wv ped1 cont slay2013

Posted Sep 21, 2010, 8:42 am
*sam*
The Salthill Sluggerz
Darkwind Guru

Renegade

Avatar

Member Level

Group: Lead Developer
Posts: 16,781
Joined: Jan 19, 2006

Send an email to *sam* Send a personal messsage to *sam* Reply with a quote from this post Go to the top of the page

OK.. new option under the "Characters" menu - check it out!

(You need to refresh the DW website if you don't see a new option there under the (by town) option..)
.........................
marshal vet deathrce1 paintladder combat1 wv ped1 cont slay2013

Posted Sep 21, 2010, 9:28 am
Zephyr
River City Gamblers
Darkwind Guru

Evan Reds Faction

Member Level

Group: Subscribers
Posts: 551
Joined: Dec 12, 2009

Send an email to Zephyr Send a personal messsage to Zephyr Reply with a quote from this post Go to the top of the page

Awesome! First time I tried it, it crashed my browser. But second time, it exported properly to a spreadsheet. Though it dropped one long, comma-delimited line at a time. Easy solution, though. ctrl-a, ctrl-c, open notepad, paste, save as .txt file; then open new spreadsheet in excel, go to data --> import data --> from file, choose the .txt file, choose 'delimited,' on next screen check the 'comma' box, click ok... boom, done. A beautiful data tracking spreadsheet.

Piece of pie. I do this kind of thing in my day job all the time. I can't wait to do a statistical analysis on my gangers' skill and stat growths. Immediate use: identify the lamest individual in the gang so I know who to fire.

Thank you very much Sam (bows).

.........................
vet wv

*Posted Sep 21, 2010, 10:12 am
*sam*
The Salthill Sluggerz
Darkwind Guru

Renegade

Avatar

Member Level

Group: Lead Developer
Posts: 16,781
Joined: Jan 19, 2006

Send an email to *sam* Send a personal messsage to *sam* Reply with a quote from this post Go to the top of the page

You're welcome  :-)

Quote:
it dropped one long, comma-delimited line at a time


It probably depends on your version of Excel/Windows.. it launches fine into a properly parsed file, for me..
.........................
marshal vet deathrce1 paintladder combat1 wv ped1 cont slay2013

Posted Sep 21, 2010, 10:31 am
lordbam
Nephilim Rising
Darkwind Guru

Anarchists Faction

Member Level

Group: Members
Posts: 1,410
Joined: Dec 9, 2007

Send an email to lordbam Send an ICQ messsage to lordbam Send a personal messsage to lordbam Reply with a quote from this post Go to the top of the page

Zephyr said:
Awesome!  First time I tried it, it crashed my browser.  But second time, it exported properly to a spreadsheet.  Though it dropped one long, comma-delimited line at a time.  Easy solution, though.  ctrl-a, ctrl-c, open notepad, paste, save as .txt file; then open new spreadsheet in excel, go to data --> import data --> from file, choose the .txt file, choose 'delimited,' on next screen check the 'comma' box, click ok... boom, done.  A beautiful data tracking spreadsheet. 


or you could download openoffice which does it correctly from the start.
.........................
vet wv zom0,3,0

Posted Sep 21, 2010, 11:02 am Last edited Sep 21, 2010, 12:08 pm by lordbam
*Tango*
2ManyRads CI
Darkwind Guru

Deathrace Mafia Faction

Member Level

Group: Marshals
Posts: 2,543
Joined: Mar 21, 2010

Send an email to *Tango* Send a personal messsage to *Tango* Reply with a quote from this post Go to the top of the page

*sam* said:
OK.. new option under the "Characters" menu - check it out!

(You need to refresh the DW website if you don't see a new option there under the (by town) option..)


Nice!  Thanks Sam!
.........................
marshal vet wv pvp5 pvp4 combat1 pvp3 zom community

Posted Sep 21, 2010, 11:41 am
kometen
Road Lords
Racer

Privateers Faction

Member Level

Group: Members
Posts: 190
Joined: Feb 2, 2008

Send an email to kometen Send a personal messsage to kometen Reply with a quote from this post Go to the top of the page

ooh, nifty
.........................
vet wv deathrce10,4,1

Posted Sep 21, 2010, 2:31 pm
*Dark Tempest*
The Black Legion
Darkwind Guru

Mutants Faction

Member Level

Group: Marshals
Posts: 2,049
Joined: Jan 27, 2010

Send an email to *Dark Tempest* Send a personal messsage to *Dark Tempest* Reply with a quote from this post Go to the top of the page

I was working with nbk_redspy on that program of his, it tracked skills gains over time and was very useful.

It is still a bit buggy but I know he still wants to work on it if he gets time.
.........................
vet wv marshal pvp2

Posted Sep 21, 2010, 3:08 pm
*sam*
The Salthill Sluggerz
Darkwind Guru

Renegade

Avatar

Member Level

Group: Lead Developer
Posts: 16,781
Joined: Jan 19, 2006

Send an email to *sam* Send a personal messsage to *sam* Reply with a quote from this post Go to the top of the page

*Dark Tempest* said:
I was working with nbk_redspy on that program of his, it tracked skills gains over time and was very useful.

It is still a bit buggy but I know he still wants to work on it if he gets time.


Yep, no worries :-)
I was talking to him not so long ago..
It just occurred to me that what I'd done could already be useful as a .csv exporter..
.........................
marshal vet deathrce1 paintladder combat1 wv ped1 cont slay2013

Posted Sep 21, 2010, 3:14 pm
d0dger
an0maly
Darkwind Guru

Deathrace Mafia Faction

Avatar

Member Level

Group: Members
Posts: 2,492
Joined: Jan 24, 2010

Send a personal messsage to d0dger Reply with a quote from this post Go to the top of the page

I'm assuming the general health rating not coming through was intentional and not an oversight? Mybae because this export gives hard numbers and you only want that displayed in the range categories?
.........................
vet wv combat1 combatL1 paintladder pvp5 sssc deathrceL1 pvp4 zom race1 semiprocombat deathrce1 raceL1 pvp3 pvp2 ww pvp1 paintball santa2 gwped4,16,10

Posted Sep 21, 2010, 8:58 pm
nbk_redspy
Greasy Bolts
Sunday Driver

Renegade

Member Level

Group: Members
Posts: 59
Joined: May 13, 2009

Send an email to nbk_redspy Send a personal messsage to nbk_redspy Reply with a quote from this post Go to the top of the page

*sam* said:
I have actually written some data export functions, for nbk_redspy who was working on a Helper app. that he was going to make available..

He seems to have stalled in this development however.. lemme see what I can find..


*Sam* was kind enough to create a lot of exports for my helper app.  Unfortunately I've been slammed at work so it has been stalled a bit. :(

dark_tempest was kind enough to email me to give me a bump so I'll fix the current issue and post a link tonight.

Edit:  Posted http://www.dark-wind.com/forums2/index.php?a=topic&t=15094
.........................
vet wv

Posted Sep 22, 2010, 1:03 am Last edited Sep 22, 2010, 2:20 am by nbk_redspy
*sam*
The Salthill Sluggerz
Darkwind Guru

Renegade

Avatar

Member Level

Group: Lead Developer
Posts: 16,781
Joined: Jan 19, 2006

Send an email to *sam* Send a personal messsage to *sam* Reply with a quote from this post Go to the top of the page

Thanks nbk. No worries with the helper app.. when it's ready, it's ready! .. I know it's a fairly complex bit of work.. I'm pleased that some of the export work I did for it has found another use.
.........................
marshal vet deathrce1 paintladder combat1 wv ped1 cont slay2013

Posted Sep 22, 2010, 7:53 am
*sam*
The Salthill Sluggerz
Darkwind Guru

Renegade

Avatar

Member Level

Group: Lead Developer
Posts: 16,781
Joined: Jan 19, 2006

Send an email to *sam* Send a personal messsage to *sam* Reply with a quote from this post Go to the top of the page

d0dger said:
I'm assuming the general health rating not coming through was intentional and not an oversight? Mybae because this export gives hard numbers and you only want that displayed in the range categories?


Yeah.
I *could* turn it into a set of integers of course (5=excellent, 4=good, etc.)
.........................
marshal vet deathrce1 paintladder combat1 wv ped1 cont slay2013

Posted Sep 22, 2010, 7:54 am
d0dger
an0maly
Darkwind Guru

Deathrace Mafia Faction

Avatar

Member Level

Group: Members
Posts: 2,492
Joined: Jan 24, 2010

Send a personal messsage to d0dger Reply with a quote from this post Go to the top of the page

*sam* said:
d0dger said:
I'm assuming the general health rating not coming through was intentional and not an oversight? Mybae because this export gives hard numbers and you only want that displayed in the range categories?


Yeah.
I *could* turn it into a set of integers of course (5=excellent, 4=good, etc.)


Kind of what I was thinking... it'd be a nice addition, if it's simple enough to add.
.........................
vet wv combat1 combatL1 paintladder pvp5 sssc deathrceL1 pvp4 zom race1 semiprocombat deathrce1 raceL1 pvp3 pvp2 ww pvp1 paintball santa2 gwped4,16,10

Posted Sep 22, 2010, 12:28 pm
Reply to Topic Create New Topic Create New Poll E-mail me when replies are made to this topic View Printable
» Darkwind » Testing » Suggestions » Data Export Tool

0.1458 seconds - 30 queries - 0.32 load