Well I’m done. Mostly anyway. I set out when creating this application to get more familiar with SQLite, and I’ve certainly done that. Today I think the TimeTracker application is finally complete. A lot of folks helped out with it so I definitely can’t take all (or most) of the credit.
In this final build I added a few more features, including, the CSV export, which was pretty fun to build. Creating the CSV string was trivial. I even went the extra step and had the string properly handle data with commas and quotes.
To save the file, I used this excellent article by Mike Chambers. It’s pretty trivial actually to ask a user to pick a file and then save the data. AIR really does make this simple.
I also added some basic validation to the forms in the application to make it a bit more stable.
I will warn folks though - I wrote this to learn, and I wrote it as I needed a way to track hours. But frankly, I wouldn’t trust my code. If you want to really use it, I beg you to use the CSV export feature to make backups. I don’t want to be responsible for someone losing all their data.
It was also suggested that I put this application up on RIAForge. As I have an “in” with the manager, I was able to get the project approved pretty quickly. You can download both the AIR file and source here:
Now on to my next AIR project.