PowerShell Script for Processing TimeManagment CSV Data

If you are a code geek I highly suggest looking at the An App A Day site to see some cool open source projects that were designed and created in less 24 hours. I have been using the TimeManagment program to create my time cards for a few years now, although because of it's lack of analysis tools I haven't been able to do much else with the data. If you are interested in tracking and analyzing time spent on your computer, RescueTime is much more stable and has many, many more features, but TimeManagment is a great way to create an audit log and do customized tracking.

Even something as simple as creating a time card can be a bit of a pain, since all of the data is stored in a single CSV file. You end up having to open the file in Excel and scan through thousands of lines like these to find what you were doing at any given time:

03/04/2009,10:31:46,Idle,,0.334114583333333 03/04/2009,10:32:06,javaw,GmailAssistant,0.166666666666667 03/04/2009,10:32:16,explorer,,0.1671875 03/04/2009,10:32:26,chrome,Gmail - Google Chrome,0.0833333333333333 03/04/2009,10:32:31,chrome,Gmail - Inbox (4) - Google Chrome,0.166666666666667 03/04/2009,10:32:41,chrome,Gmail - New Issues and a Top Priority list - Google Chrome,0.0833333333333333 03/04/2009,10:32:46,chrome,Gmail - Total Protection Service Summary Report - Google Chrome,0.25 03/04/2009,10:33:01,chrome,Gmail - Search results - Google Chrome,0.0833333333333333 03/04/2009,10:33:06,chrome,Gmail - McAfee Registration Details - Google Chrome,0.0833333333333333

I finally got fed up with it and created a PowerShell script to do the job for me (including removing 1 hour each day for lunch). Now I can click a button and out pops a nice little report listing my hours for any given date range:

Start processing file: TimeManagement 2009MAR03.csv Start processing file: TimeManagement.csv Fill empty days from 3/13/2009 to 3/15/2009 Force Change data From: 3/3/2009 11:53:11 AM 3/3/2009 1:18:12 PM 01:25:01 to 10:00 AM 6:00 PM Force Change data From: 3/13/2009 11:56:26 AM 3/13/2009 5:59:43 PM 06:03:17 to 9:30 AM 6:00 PM Total Processing time 6.28 seconds for 16,619 valid csv entries and 623 unknown entries. Start Timecard 03/01/2009 - 03/02/2009 07:38:19 Hours 10:50 AM-7:28 PM 1 HR lunch 03/03/2009 07:00:00 Hours 10:00 AM-6:00 PM 1 HR lunch 03/04/2009 05:31:47 Hours 10:32 AM-5:03 PM 1 HR lunch 03/05/2009 06:29:37 Hours 10:39 AM-6:09 PM 1 HR lunch 03/06/2009 05:16:34 Hours 10:29 AM-4:45 PM 1 HR lunch 03/07/2009 - 03/08/2009 - 03/09/2009 08:20:59 Hours 10:26 AM-7:47 PM 1 HR lunch 03/10/2009 06:25:30 Hours 10:08 AM-5:33 PM 1 HR lunch 03/11/2009 07:14:26 Hours 11:00 AM-7:14 PM 1 HR lunch 03/12/2009 05:45:33 Hours 11:17 AM-6:02 PM 1 HR lunch 03/13/2009 07:30:00 Hours 9:30 AM-6:00 PM 1 HR lunch 03/14/2009 ? 03/15/2009 ? Total Time this period is 67.2 hours for 10 days. Average 6.7 hours per day. Projected: Total Hours 70.6, Total Pay $1,764.33, Take Home $1,369.12 End Timecard

You can see that it is not perfect (It still things that I plan on coming in and working a few hours this weekend. Fat Chance!), but if you are interested here is a link to the PowerShell script file. Should come in handy for anyone else using the TimeManagment program or just interested in processing CSV data files using PowerShell.

Enjoy!