Author Topic: Aurora Dashboard (Graph data over time tool)  (Read 7304 times)

0 Members and 1 Guest are viewing this topic.

Offline GangaSauce (OP)

  • Leading Rate
  • *
  • G
  • Posts: 7
  • Thanked: 11 times
Aurora Dashboard (Graph data over time tool)
« on: April 27, 2020, 09:21:05 PM »
I've made a simple utility, AuroraDashboard, that periodically opens the AuroraDB. db database in read only mode, then (if time has progressed in the selected Game) reads out all the population's mineral amounts, and a few other variables and stores them in another database called DashboardDB. db. 

It then displays the information in a graph.  (See attached image!)

I'll be adding additional variables and objects to display, any requests? On the todo list is also different color schemes. 

Name: AuroraDashboard. exe
Size: 545280 bytes (532 KiB)
SHA256: 1CD44C2822590C3AE67EC44ABA482D30E9E38E9B65CBB208E71576005DB9911F

Name: AuroraDashboard v1. 7z
Size: 3603469 bytes (3519 KiB)
SHA256: E86B0D9BD987FC03D386416A91323026B9FEDB66D34A8F514E63EBC37E1009BA

This mod/utility has been approved by Steve. 

Please do not include this utility in any mod packs / mod suites.  I have not obfuscated the binary, aside from compiling it in release mode. 

Cheers,
Ganga
 
The following users thanked this post: vorpal+5, QuakeIV, Marslettuce, skoormit, AP GIRL, Migi, AJS1956, Chrisianak, Ehndras

Offline GangaSauce (OP)

  • Leading Rate
  • *
  • G
  • Posts: 7
  • Thanked: 11 times
Re: Aurora Dashboard (Graph data over time tool)
« Reply #1 on: April 27, 2020, 09:22:56 PM »
Oh, please extract this into a different directory from Aurora, please do not unzip this directly into your Aurora directory. 
 

Offline skoormit

  • Commodore
  • **********
  • Posts: 764
  • Thanked: 310 times
Re: Aurora Dashboard (Graph data over time tool)
« Reply #2 on: April 28, 2020, 06:58:09 AM »
Oh, please extract this into a different directory from Aurora, please do not unzip this directly into your Aurora directory.

You should edit your first post to include this line.

Also: thanks! This is an amazingly useful idea.
 

Offline Graymane

  • Warrant Officer, Class 2
  • ****
  • G
  • Posts: 53
  • Thanked: 15 times
Re: Aurora Dashboard (Graph data over time tool)
« Reply #3 on: May 07, 2020, 09:15:35 AM »
Using 1. 9. 5 Aurora.   Everything opens up ok but nothing graphs when I select it.   Just an empty window.
 

Offline Ehndras

  • Voidwalker
  • Warrant Officer, Class 1
  • *****
  • E
  • Posts: 90
  • Thanked: 10 times
Re: Aurora Dashboard (Graph data over time tool)
« Reply #4 on: May 07, 2020, 07:51:30 PM »
Awaiting update <3 Can't wait to use this
"Boop!" goes the thermonuclear missile salvo
 

Offline GangaSauce (OP)

  • Leading Rate
  • *
  • G
  • Posts: 7
  • Thanked: 11 times
Re: Aurora Dashboard (Graph data over time tool)
« Reply #5 on: May 09, 2020, 07:12:57 AM »
Quote from: Graymane link=topic=11123. msg131529#msg131529 date=1588860935
Using 1.  9.  5 Aurora.    Everything opens up ok but nothing graphs when I select it.    Just an empty window.
Thank you, working on update now. 
 

Offline Mr.Nap

  • Warrant Officer, Class 1
  • *****
  • Posts: 75
  • Thanked: 16 times
Re: Aurora Dashboard (Graph data over time tool)
« Reply #6 on: May 09, 2020, 08:06:29 AM »
A tool that will quickly become essential!
 

Offline GangaSauce (OP)

  • Leading Rate
  • *
  • G
  • Posts: 7
  • Thanked: 11 times
Re: Aurora Dashboard (Graph data over time tool)
« Reply #7 on: May 09, 2020, 11:06:30 PM »
Quote from: Graymane link=topic=11123. msg131529#msg131529 date=1588860935
Using 1.  9.  5 Aurora.    Everything opens up ok but nothing graphs when I select it.    Just an empty window.

I just tested the original v1 against 1. 9. 5 and it works fine, you need to save the game, let time pass (say, 5 days) then save the game again all while the dashboard is running. 
 

Offline Froggiest1982

  • Gold Supporter
  • Vice Admiral
  • *****
  • F
  • Posts: 1331
  • Thanked: 590 times
  • Gold Supporter Gold Supporter : Support the forums with a Gold subscription
    2021 Supporter 2021 Supporter : Donate for 2021
    2022 Supporter 2022 Supporter : Donate for 2022
    2023 Supporter 2023 Supporter : Donate for 2023
Re: Aurora Dashboard (Graph data over time tool)
« Reply #8 on: May 10, 2020, 12:30:24 AM »
Quote from: Graymane link=topic=11123. msg131529#msg131529 date=1588860935
Using 1.  9.  5 Aurora.    Everything opens up ok but nothing graphs when I select it.    Just an empty window.

I just tested the original v1 against 1. 9. 5 and it works fine, you need to save the game, let time pass (say, 5 days) then save the game again all while the dashboard is running.

You should add a readme file in the installation. For examole when you launch the application it's not really clear you need to select the aurora database.

You could also add the information on the instsllation and how to make it works from your previous posts.

Just a suggestion.

Good work anyway, I love your tool so far.

Offline GangaSauce (OP)

  • Leading Rate
  • *
  • G
  • Posts: 7
  • Thanked: 11 times
Re: Aurora Dashboard (Graph data over time tool)
« Reply #9 on: May 10, 2020, 01:42:49 AM »
Quote from: froggiest1982 link=topic=11123. msg132192#msg132192 date=1589088624
Quote from: GangaSauce link=topic=11123. msg132191#msg132191 date=1589083590
Quote from: Graymane link=topic=11123.  msg131529#msg131529 date=1588860935
Using 1.   9.   5 Aurora.     Everything opens up ok but nothing graphs when I select it.     Just an empty window. 

I just tested the original v1 against 1.  9.  5 and it works fine, you need to save the game, let time pass (say, 5 days) then save the game again all while the dashboard is running. 

You should add a readme file in the installation.  For examole when you launch the application it's not really clear you need to select the aurora database.

You could also add the information on the instsllation and how to make it works from your previous posts.

Just a suggestion.

Good work anyway, I love your tool so far.

That is a good idea, I will include a readme in the next release.

Thank you! Any ideas on additional things to graph?
 
The following users thanked this post: Ehndras

Offline JyeGuru

  • Leading Rate
  • *
  • Posts: 12
  • Thanked: 4 times
Re: Aurora Dashboard (Graph data over time tool)
« Reply #10 on: May 17, 2020, 02:18:22 AM »
Quote from: GangaSauce link=topic=11123. msg132195#msg132195 date=1589092969
Any ideas on additional things to graph?

The entire set of terraforming data would be really interesting to map, although there's a lot of values to track.
 

Offline Graymane

  • Warrant Officer, Class 2
  • ****
  • G
  • Posts: 53
  • Thanked: 15 times
Re: Aurora Dashboard (Graph data over time tool)
« Reply #11 on: May 18, 2020, 03:42:35 PM »
There are so many graphs and pie charts I'd love to see it isn't even funny!
 
The following users thanked this post: Ehndras

Offline GangaSauce (OP)

  • Leading Rate
  • *
  • G
  • Posts: 7
  • Thanked: 11 times
Re: Aurora Dashboard (Graph data over time tool)
« Reply #12 on: May 20, 2020, 10:46:08 AM »
Quote from: Graymane link=topic=11123. msg133800#msg133800 date=1589834555
There are so many graphs and pie charts I'd love to see it isn't even funny!
Please please list your ideas
 

Offline GangaSauce (OP)

  • Leading Rate
  • *
  • G
  • Posts: 7
  • Thanked: 11 times
Re: Aurora Dashboard (Graph data over time tool)
« Reply #13 on: May 20, 2020, 10:46:33 AM »
Quote from: JyeGuru link=topic=11123. msg133479#msg133479 date=1589699902
Quote from: GangaSauce link=topic=11123.  msg132195#msg132195 date=1589092969
Any ideas on additional things to graph?

The entire set of terraforming data would be really interesting to map, although there's a lot of values to track.
I'll add that
 
The following users thanked this post: JyeGuru

Offline JyeGuru

  • Leading Rate
  • *
  • Posts: 12
  • Thanked: 4 times
Re: Aurora Dashboard (Graph data over time tool)
« Reply #14 on: May 21, 2020, 06:31:38 AM »
Quote from: GangaSauce link=topic=11123. msg134128#msg134128 date=1589989593
Quote from: JyeGuru link=topic=11123.  msg133479#msg133479 date=1589699902
Quote from: GangaSauce link=topic=11123.   msg132195#msg132195 date=1589092969
Any ideas on additional things to graph?

The entire set of terraforming data would be really interesting to map, although there's a lot of values to track. 
I'll add that

Even if it's not fully integrated with the graphing (not sure how you'd filter so many things with tick boxes in the current UI!) but if you are able to pull the data into the database I can report on it in Excel which is good enough.  :)

Also, is this open source? I'd be happy to potentially contribute to things if it's in a language I can work with.  👍