ActiveCollab 3.0 Timer Issue: Resolved
With the recent growth of the company, we’re now focusing on improving the scaleability of our team – to allow further growth. As a part of this effort, we’ve been trying out several solutions for time tracking and project management.
Currently, we’re doing a trial with ActiveCollab, a web based project management solution, which allows sharing specific pieces of information (such as a prototype estimation breakdown) in an elegant manner.
In combination with ActiveCollab, we’ve been using the ActiveCollab Timer application, to allow us to continue tracking time, even when the Internet connection or ActiveCollab hosting would be down.
Due to an automatic upgrade to ActiveCollab 3.0, which happened yesterday evening, the Timer application ceased working, and some timer entries were stick in the sending queue (not visible any more in the application, nor sent and stored in the web based system). After contacting ActiveCollab Support, it seemed that there would be no way to recover the lost data.
Luckily, we’ve found that you can read this data from a file on your disk.
This is what you need to do in case you’d need to recover this lost data:
- Download SQLite Database Browser.
- Use it to open the file activeCollabTimer.db in the ~/Library/Application Support/A51/activeCollabTimer directory (Windows users can search for the activeCollabTimer.db file to locate it).
- You’ll see that the data you’re looking for is stored in the actimesubmit_time column of the actimesubmit table (as it can be seen in the screenshot).