WhatPulse Forums
Is it possible to export all of my keypress data to a .csv file? - Printable Version

+- WhatPulse Forums (https://whatpulse.org/forums)
+-- Forum: Support (https://whatpulse.org/forums/forum-38.html)
+--- Forum: Website (https://whatpulse.org/forums/forum-60.html)
+--- Thread: Is it possible to export all of my keypress data to a .csv file? (/thread-7972.html)



Is it possible to export all of my keypress data to a .csv file? - KBurchfiel - 10-14-2021

Hi there,

I've been using WhatPulse for about 13 years and have really enjoyed it. I'd like to export all of my keypress data to a .csv file in order to perform data analysis. I was able to access the data on the whatpulse.db files for my 2 most recent computers using SQL, but that only covers the last 13 months or so. Meanwhile, using both the API (e.g. api.whatpulse.org/pulses.php?format=json&start=1000000000&end=1634181281&user=kburchfiel) and the Pulses section of the My Stats page, I'm only able to access data from August 2021 onward even when I set a longer timeframe.

Is there a way to download all of my keypress and/or pulse data (since 2008)?

Thanks!


RE: Is it possible to export all of my keypress data to a .csv file? - smitmartijn - 10-15-2021

Hi,

That data is only available in the client - the website doesn't keep that a detailed view. Is there a way you can recover your older local databases?


RE: Is it possible to export all of my keypress data to a .csv file? - KBurchfiel - 10-15-2021

Hi,

Thank you for the prompt response! I might indeed be able to recover my older databases. Is there a limit to how many years each database stores? I only ask because I used my previous computer for about 5 years, but the whatpulse.db file on that computer only covered about 7 months of data. This may have been because of a hard drive change or client reinstall, however.


RE: Is it possible to export all of my keypress data to a .csv file? - smitmartijn - 10-18-2021

The client doesn't delete anything by default, so the full history should be there. The only exception is when you enable the option to delete the mouse heat map points after 3 months (which is just to limit the loading time of the heat map).


RE: Is it possible to export all of my keypress data to a .csv file? - KBurchfiel - 10-20-2021

Got it, thanks! I'll try to find more of the data in that case.