Script for Clockwork and Hog Bay Notebook integration

I'm glad this is the direction you are hoping to head with your software. You've got my attention now. And thank you also for responding so quickly with the AppleScript.

However, I ran into a problem with selecting Alarm Actions. The actions appear to be locked (greyed, dimmed), and I wonder if this has to do with features locked before purchasing the license. If this feature was supposed to unlock when dragging the license over the application, it doesn't appear to have worked. I tried deleting preferences and data from Library/Application Support/Clockwork, starting with a new install of Clockwork and renewing the license by dragging the .clockworklicense file over the newly installed application. Still the same problem. Anything I can do?

Edit: Oops! I had the mode set to Stopwatch. I have solved the problem by switching the mode back to Alarm. I knew I had seen this feature before, but I couldn't figure out how to reenable it.

To sync the output of the script to the format I needed for QuickBooks, I needed to convert the displayTime variable (number of seconds) to an expression of the hours spent as a decimal fraction rounded to hundredths of an hour. So I modified the Synch AppleScript with the following:

on logAlarmStop(alarmName, displayTime)
tell application "Hog Bay Notebook"
tell front document
set e to entry named alarmName
if exists e then
set durValue to displayTime / 3600
set durRound to round (durValue * 100)
tell e to store attribute key "Hours" value (durRound / 100) as string
end if
end tell
end tell
end logAlarmStop

You'll notice that I have also changed the column name to "Hours".

The part that is working quite well is the selection of the corresponding file in Notebook. But so far, the value is entered only for "My Project". For any other name I create, no value is entered into the "Completed" (or "Hours") column. Any ideas about how to fix this, or what I am doing wrong?

Otherwise, this is working perfectly!

Edit: Again, I am missing the obvious. I did not select the Alarm Action for the newly created Timers. Once I clicked on the mode button for each time to set Alarm mode, selected the AppleScript for the Alarm Action and returned to Stopwatch mode, everything was working perfectly. Thank you, Jesse!

I've progressed about as far as I can go, I think, without knowing how to trigger scripts based on application events such as clicking on the start button or on the clear button. I am experiencing no results or unexpected results, depending on what I try with logAlarmStart and logAlarmFinish.

At any rate, this is what I've come up with as an Automatic Timesheet Entry script.

This requires setting up custom columns for Date, Start, Stop, Task, Hours, Rate and Amount. For now, rates and codes are hard-coded into the script, but ideally the script should retrieve values from a Tasks folder that lists Tasks and Rates.

The one glitch I have that I can't figure out how to get around is that the script creates double entries: one for the stop button and one for the clear button. This is fine for now, as it will automatically create a copy that I can store in the job folder (although I would rather it be an alias), but this was not the intended behaviour.


-- New Timesheet Entry
-- Hog Bay Clockwork AppleScript
-- based on script by Jesse Grosjean
-- by Stephen Bau
-- 04 Aug 2005
using terms from application "Clockwork"