#4 CSV File Format

[Stephen]

This program looks great. Thanks.

Here are a few enhancements that I think would be useful:

(1) Spanning Midnight

I would prefer that you save a full Date/Time column instead of the existing Time-only column. (You could then remove the existing Date column, if you want.)

The reason is that if you work past midnight, as I sometimes do, then all activity before midnight gets the wrong Date and wrong Day of Week. It looks like you never worked on the day before midnight. This forces me to either correct the date, or save/shutdown TT just before midnight with the correct date, and then restart after midnight.

If you prefer to keep the Date a separate column, that's fine too, but it should reflect the before/after midnight dates correctly. Right now the Date is basically a save file date, not the true activity date.

(2) Consistent CSV Line Format

Your program writes an initial separator of "******" in the first date column for each new append. This means that different lines have incompatible CSV formats. A separator line is fine, but you might save the asterisks in the Window Caption column, which is a string not a date. You could still have a normal date and day in the initial columns if you like. A consistent line format is better for importing the .csv file into a database or spreadsheet. (I use an Access database.)

(3) Fractional Hours with 4 Decimals

The fractional hour column is very useful for adding up total time. I would like to see 4 decimals, consistent with your sampling rate of 1 second, so that small intervals do not get lost in the total. Currently you seem to round to 2 decimals, which has a 36 second resolution. Of course, I can always use your hh:mm:ss column, which does have1 second resolution, but it seems the fractional hours should be comparable.

Thanks for your work on this program, it's great!

- Stephen

[Nobody/Anonymous]

Logged In: NO

I would add
(4) I've seen some apps (Oracle sqldeveloper) that have a carriage return in the window name (for errors).
This messes up the csv. It would be nice to replace CRs by a space or some other character of your choice.