WhatPulse Forums » Feature requests » Client software v » Export Statistics to Excel Welcome back, Guest.


Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Export Statistics to Excel
02-23-2014, 05:33 PM
Post: #1
Export Statistics to Excel
I would like to be able to export my daily keystroke count into Excel to graph it. Also I noticed the premium only feature showing a graph of keystrokes in the last 7 days. How far does it keep track of the data? If I've used Whatpulse for 1 year and then get premium, do the "show daily usage in past week" show the statistics from before I got premium?
Find all posts by this user
Quote this message in a reply
02-23-2014, 07:29 PM
Post: #2
RE: Export Statistics to Excel
Exporting to csv will be available from the client in the next version. The client actually keeps all stats, as long as you don't reset it.
Visit this user's website Find all posts by this user
Quote this message in a reply
02-24-2014, 03:12 PM
Post: #3
RE: Export Statistics to Excel
I would like to see the export feature too. Thanks for planning it!
Find all posts by this user
Quote this message in a reply
02-24-2014, 09:14 PM
Post: #4
RE: Export Statistics to Excel
Meanwhile you can do this yourself, if you familiar with SQL. Or take any tool which supports sqlite and csv export.
Find all posts by this user
Quote this message in a reply
07-09-2018, 07:18 AM
Post: #5
RE: Export Statistics to Excel
(02-24-2014 09:14 PM)Megachip Wrote:  Meanwhile you can do this yourself, if you familiar with SQL. Or take any tool which supports sqlite and csv export.

How can you do this?
I find that you can from the client choose to export from either a day, a week, a month. But I want ALL info as a CSV file so I can plot the data myself using Python.
Find all posts by this user
Quote this message in a reply
07-12-2018, 05:57 PM
Post: #6
RE: Export Statistics to Excel
(07-09-2018 07:18 AM)Azergoo Wrote:  
(02-24-2014 09:14 PM)Megachip Wrote:  Meanwhile you can do this yourself, if you familiar with SQL. Or take any tool which supports sqlite and csv export.

How can you do this?
I find that you can from the client choose to export from either a day, a week, a month. But I want ALL info as a CSV file so I can plot the data myself using Python.

WhatPulse stores its statistics in a SQLite database at this location (Windows):

Code:
%localappdata%\whatpulse\whatpulse.db

Python has a library called sqlite3 you can use to open the database:

Code:
>>> import sqlite3
>>> conn = sqlite3.connect('whatpulse.db')
<sqlite3.Connection object at 0x000001820231B2D0>

From there, you can execute SQLite queries, such as this one which shows all the tables:

Code:
>>> c.execute('SELECT name FROM sqlite_master WHERE type="table"').fetchall()                                           [('last_update_time',), ('settings',), ('unpulsed_stats',), ('applications',), ('application_ignore',), ('pending_applications_stats',), ('keypresses',), ('keypress_frequency',), ('keypress_frequency_application',), ('keycombo_frequency',), ('keycombo_frequency_application',), ('mouseclicks',), ('mousepoints',), ('mouseclicks_frequency',), ('mouseclicks_frequency_application',), ('input_per_application',), ('uptimes',), ('application_uptime',), ('application_active_hour',), ('network_interfaces',), ('network_interfaces_ignore',), ('network_interface_bandwidth',), ('application_bandwidth',), ('country_bandwidth',), ('network_protocol_bandwidth',), ('fact',), ('geekwindow_labels',), ('sqlite_sequence',), ('computer_info',), ('milestones',), ('milestones_log',)]

Or this, if you wanted to get the history of all timestamps by day:

Code:
>>> c.execute('SELECT * FROM keypresses').fetchall()                                                                    [('2018-06-12', 8, 573), ('2018-06-12', 9, 2360), ('2018-06-12', 10, 3622), ('2018-06-12', 11, 3452), ('2018-06-12', 12, 1173), ('2018-06-12', 13, 1927), ('2018-06-12', 14, 61), ('2018-06-12', 15, 2123), ('2018-06-12', 16, 2857), ('2018-06-12', 19, 0), ('2018-06-13', 8, 398), ('2018-06-13', 9, 4698), ('2018-06-13', 10, 3791), .......
Find all posts by this user
Quote this message in a reply
Post Reply 


Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  Further Statistics Schdief 5 4,071 11-20-2014 08:40 PM
Last Post: Strazdas
  Backup And Restore Local Statistics Inquizitor 3 5,207 07-10-2013 03:24 PM
Last Post: smitmartijn
  Bandwidth statistics. Shawn 3 4,966 06-05-2009 10:44 PM
Last Post: Quarzi

Forum Jump:


User(s) browsing this thread: 1 Guest(s)