Sunday, 18 August 2013

How to export your RescueTime data


How you can export all your data stored in RescueTime. Note that this is only possible for premium members.

1: Generate an API key:


2: modify the link on the following format:
Change key to the key found in step 1, and alter the start and end dates. Check out the API doc for more details.

Export data entries, sorted by rank:
https://www.rescuetime.com/anapi/data?key=[yourKeyHere]&restrict_begin=2011-01-01&restrict_end=2013-12-01

Export data entries, grouped by year:
https://www.rescuetime.com/anapi/data?key=[yourKeyHere]&restrict_begin=2011-01-01&restrict_end=2013-12-01&perspective=interval&resolution_time=year

Export data entries, grouped by month:
https://www.rescuetime.com/anapi/data?key=[yourKeyHere]&restrict_begin=2011-01-01&restrict_end=2012-01-01&perspective=interval&resolution_time=month

Export data entries, grouped by day:
https://www.rescuetime.com/anapi/data?key=[yourKeyHere]&restrict_begin=2011-01-01&restrict_end=2012-01-01&perspective=interval&resolution_time=day

Example of exported data (CSV format):
Rank,Time Spent (seconds),Number of People,Activity,Category,Productivity
1,3343450,1,Gmail,Email,0
2,1119430,1,Hosted Google Docs,Writing,2
3,1108232,1,draft.blogger.com,Blogging,0
4,909023,1,komodo,Editing & IDEs,2
5,883763,1,Google+,General Social Networking,-2
6,679894,1,Windows Explorer,General Utilities,1
7,495396,1,facebook.com,General Social Networking,-2
8,377095,1,Google Chrome for Android,Browsers,0
9,367925,1,svn.dax.net,General Business,2
10,359020,1,chronicles.no,Blogging,0

3: Error handling
If you get the error
{"error":"# unsupported request"}
try smaller time intervals / a shorter reporting period.

If you get the error
{"error":null}
it might be your API key that is invalid.

No comments:

Post a Comment

Allowed HTML tags:
<b>bold</b>
<strong>strong</strong>
<i>italics</i>
<em>emphasis</em>
<a href="">hyperlink</a>


Please, show the courtesy of identifying yourself when adding a comment. Anonymous comments will, most likely, be removed.