neowutran / ShinraMeter

Tera DPS Meter
https://neowutran.ovh/updates/?C=M;O=D
MIT License
114 stars 80 forks source link

[Request] Data Export #41

Closed Casanova closed 8 years ago

Casanova commented 8 years ago

Hi,

An other request (Again :p)

As said in the title, I'd like to be able to export the DPS meter data to Excel, so CSV file should be enough.

The purpose is to allow a better data collection, for statistical purposes.

The export could trigger multiple CSV files creation, one containing the first screen data, meaning 8 columns: {class};{name};{damage_percentage};{crit_rate};{Crit};{dps};{hits_received};{damage_received}. The other extracts could come later and they would contain a file per each dps meter screen.

Kind regards,

Casanova

neowutran commented 8 years ago

Hi again =) Data export is already planned, but I intend to export everything in JSON. anyway json <--> CSV is not really a problem. The final goal will be to be able to generate web chart like this: https://google-developers.appspot.com/chart/interactive/docs/gallery/linechart . I don't intend to release data export before few weeks

Casanova commented 8 years ago

Hi,

The charts idea seems very interesting! :+1: It's also useful to have the raw data to be able to compile many fights for statistics :) As for the format JSON or CSV, it doesn't matter, as long as it could be put in a table in order to calculate averages ^_^

Casanova commented 8 years ago

Subject: Functional Specifications Warning: TEXT WALL :p

Hi,

Here is my attempt to clarify the idea I have in mind :)

• The new functionality extract the data that is already accessible via UI. • The new functionality will be triggered via a button in the UI, • This button will have a built-in cool down of 1 sec • The button turns to a different color once clicked, for a fight. When there is an other fight (new or history), the button color reset. • The extracted files can be used in spreadsheet program. • The data extracts will be sent to a folder, the path of this folder can be set in a configuration file (optional). • Every extract will create many files of the following format: DataType_YYYYMMDDHHMMSS (that's why there is a 1 second CD on the button), • The types are:

I hope it will be clear when you'll have time for it.

Many thanks,

Casanova

neowutran commented 8 years ago

Export to Json object have been done (sending data to teradps.io). Export to file is trivial now, will be added soon

Casanova commented 8 years ago

AMAZING! :+1:

Looking forward to it :)

neowutran commented 8 years ago

v0.92 => excel export

Casanova commented 8 years ago

How can we launch the export? and what are the new buttons? I can't find them on the wiki page.

Gl0 commented 8 years ago

Edit window.xml <excel>true</excel>

Gl0 commented 8 years ago

buttons are for chat and boss (teradps.io uploads) history

neowutran commented 8 years ago

(yup, haven't wrote the "tuto" on the wiki yet, do what Gl0 say & you will see the excel files in ./resources/logs/xxxxxxx)

Gl0 commented 8 years ago

May be add it as context menu item switch?

neowutran commented 8 years ago

hum, yup ^^ will add that

Gl0 commented 8 years ago

Added myself. =)

Casanova commented 8 years ago

Thanks for the explanation, it's working for me :+1: :)