Author Topic: NANY 2010 Release: Anuran (Read 312,665 times)

skwire · « **Reply #125 on:** January 31, 2010, 12:39 AM »

Quote from: AEngineer on January 30, 2010, 10:25 PM

The date stamp algorithim in Excel is the days since January 1st, 1900 + Military Hours/24

Ugh...the lovely "1900 date" format. Honestly, what might be better would be for the user to choose a timestamp format, in Anuran, that Excel can recognise and convert itself. Your thoughts?

AEngineer · « **Reply #126 on:** January 31, 2010, 02:30 AM »

Sure.
You might have to help some people with the documentation on how to make the conversion.

If you can provide an output in CSV or Tab form that gives:
Year (4 digit)
Month
Day
Hour
Minute
Second

then it's easy to use the Date & Time formulas to create the timestamp in Excel.

skwire · « **Reply #127 on:** January 31, 2010, 03:00 AM »

The next couple questions are regarding the CSV format itself.

1) The CSV RFC says that linebreaks must be preserved. However, a LOT of so-called CSV readers will choke on this (thinking it's a new record). Your thoughts?
2) Did you want a header line?

AEngineer · « **Reply #128 on:** January 31, 2010, 03:07 AM »

No line breaks please, one line per record
I think a header line would be nice although my memory is that most csv and tab outputs don't have one.

You're amazing - it's Saturday night and you should be out carousing.

skwire · « **Reply #129 on:** January 31, 2010, 03:13 AM »

Quote from: AEngineer on January 31, 2010, 03:07 AM

No line breaks please, one line per record
I think a header line would be nice although my memory is that most csv and tab outputs don't have one.

Cool...no line breaks makes things easier.

Quote from: AEngineer on January 31, 2010, 03:07 AM

You're amazing - it's Saturday night and you should be out carousing.

Hehehe...I'm married with two daughters. No carousing here. =]

skwire · « **Reply #130 on:** January 31, 2010, 03:41 AM »

Website | Download v1.0.28 - 2010-01-30 * AnuVu v1.0.12 + Added capability to export current view as CSV format. Choose "File, Export current view to CSV format" from the menu. (Thanks, AEngineer)

Jim, see if this is what you were after. Double-quotes and commas within a note should be handled properly. If you want a header line, it's no trouble to add. Thanks.

doctorfrog · « **Reply #131 on:** January 31, 2010, 03:54 AM »

Glad to see CSV export is going to work out. I can see how this will add significant value to the app for some people.

skwire · « **Reply #132 on:** January 31, 2010, 05:27 AM »

Quote from: doctorfrog on January 31, 2010, 03:54 AM

Glad to see CSV export is going to work out. I can see how this will add significant value to the app for some people.

Were you able to test it out and see if it exported properly?

AEngineer · « **Reply #133 on:** January 31, 2010, 12:44 PM »

What a great use of a Saturday night (for me)!
Yes, it works splendidly.

For documentation purposes here's the formula that produces a timestamp, assuming that the date output field is in A1

=DATE(LEFT(A1,4),MID(A1,6,2),MID(A1,9,2))+ TIME(MID(A1,14,2),MID(A1,17,2),MID(A1,20,2))

Many thanks indeed.

doctorfrog · « **Reply #134 on:** January 31, 2010, 07:02 PM »

Works on my end as well. Nice addition.

doctorfrog · « **Reply #135 on:** January 31, 2010, 08:37 PM »

Request: Audio feedback when using "Archive now" hotkey. I think two "ribbits" will do for this, instead of just one, since the action is more "momentous."

AEngineer · « **Reply #136 on:** January 31, 2010, 10:39 PM »

Suggestion for others who want to import this to a database. I'm adopting a convention that I'll put my "category" at the beginning followed by a "-" That way I can easily parse the category in Excel.

e.g
Soccer - Watch Arsenal go down to Manu

doctorfrog · « **Reply #137 on:** February 02, 2010, 11:34 PM »

[attachimg=#]
[attach]

mouser · « **Reply #138 on:** February 04, 2010, 11:53 PM »

anuran featured on pcworld today:
http://www.pcworld.com/article/187521/log_your_activity_with_freebie_anuran.html

doctorfrog · « **Reply #139 on:** February 06, 2010, 06:04 AM »

Awesome. Congratulations, Skwire!

skwire · « **Reply #140 on:** February 06, 2010, 06:36 PM »

Thanks, froggy, and thanks to everybody for shaping Anuran into what it is today. =]

AEngineer · « **Reply #141 on:** February 06, 2010, 07:00 PM »

More on converting to Excel Timestamp.
I found, somewhat to my embarrassment, that AM/PM and the fact that noon is labeled as 12:00PM not 00:00 PM exported info fouled up my prior Excel timestamp. The following does work (I know it's ugly, but it's necessary), assuming that the exported timestamp is in A4.

=DATE(LEFT(A4,4),MID(A4,6,2),MID(A4,9,2))+ TIME( IF( AND(RIGHT(A4,2)="PM",VALUE(MID(A4,14,2))<12),MID(A4,14,2)+12,MID(A4,14,2) ), MID(A4,17,2),MID(A4,20,2))

It would be MUCH cleaner to export the time in military (24 hour) units.

skwire · « **Reply #142 on:** February 06, 2010, 07:39 PM »

Quote from: AEngineer on February 06, 2010, 07:00 PM

It would be MUCH cleaner to export the time in military (24 hour) units.

You know that you can use a military timestamp in your log entries, right? Simply use "HH" instead of "hh" in your timestamp format. Click the "i" information buttons for all the tokens you can use within your timestamp. Apologies if you were already aware of all this. =]

AEngineer · « **Reply #143 on:** February 06, 2010, 08:54 PM »

Ummm. I guess I saw it and didn't register. Thanks for informing me!

skwire · « **Reply #144 on:** February 06, 2010, 08:54 PM »

Website | Download v1.0.29 - 2010-02-06 * AnuVu v1.0.13 + Added toolbar button for CSV export format option. + Added option to play sound on archival. Options, Archive tab. (Thanks, doctorfrog). * Changed the icon look from the Silk set to the Fugue set found at http://www.pinvoke.com. This affects both Anuran's options and AnuVu's toolbar and configuration dialog.

New look:

DeVamp · « **Reply #145 on:** February 23, 2010, 04:03 PM »

I

the program.

It's perfect, because at work i always forget to stay up to date with what work i did for what client.

the only thing i have with it, is the way of archiving.

My archive log format is : yyyy_MM_dd_dddd

I used to set it to archive 1 day.

But then according to if my computer was running or not or sometimes anuran was not running, i ended up with entries from yesterday in the logs of today.

when i changed the archivetime to every 10 minutes, but now i get a new file every 10 minutes.
It's in the format Log_yyyy_MM_dd_dddd[number].anu
like Log_yyyy_MM_dd_dddd[1].anu and Log_yyyy_MM_dd_dddd[2].anu and Log_yyyy_MM_dd_dddd[3].anu

isn't it possible to just append to the file if it already exists in the format.

That still doesn't solve the fact that if i enter something just before closing the PC, it will be archived the next day.
For that, perhaps you can use the timestamp of the entry to calculate the timestamp of the archivefile.
And then just append to that file.

If i'm making it to complicated, no worries, i will find a way around it. :-)
Perhaps that the export to CSV gives me possibilities.

Tnx anyway for the program.

skwire · « **Reply #146 on:** February 26, 2010, 08:44 AM »

Quote from: DeVamp on February 23, 2010, 04:03 PM

I the program.

It's perfect, because at work i always forget to stay up to date with what work i did for what client.

Thanks for the compliment and sorry about the delay in replying.

Quote from: DeVamp on February 23, 2010, 04:03 PM

the only thing i have with it, is the way of archiving.

Hehehe...yeah, I know what you mean.

It's kind of tough to cover everybody's ideas regarding archiving without it becoming a huge mess of options.

Quote from: DeVamp on February 23, 2010, 04:03 PM

when i changed the archivetime to every 10 minutes, but now i get a new file every 10 minutes.
It's in the format Log_yyyy_MM_dd_dddd[number].anu
like Log_yyyy_MM_dd_dddd[1].anu and Log_yyyy_MM_dd_dddd[2].anu and Log_yyyy_MM_dd_dddd[3].anu

isn't it possible to just append to the file if it already exists in the format.

This is actually a very elegant way to solve the issue. Anybody else have thoughts on this?

Quote from: DeVamp on February 23, 2010, 04:03 PM

That still doesn't solve the fact that if i enter something just before closing the PC, it will be archived the next day.
For that, perhaps you can use the timestamp of the entry to calculate the timestamp of the archivefile.
And then just append to that file.

Another option is to use the Archive hotkey or the Archive entry in the tray. Thanks for the feedback.

tomos · « **Reply #147 on:** February 26, 2010, 09:29 AM »

Quote from: skwire on February 26, 2010, 08:44 AM

Quote from: DeVamp on February 23, 2010, 04:03 PM
when i changed the archivetime to every 10 minutes, but now i get a new file every 10 minutes.
It's in the format Log_yyyy_MM_dd_dddd[number].anu
like Log_yyyy_MM_dd_dddd[1].anu and Log_yyyy_MM_dd_dddd[2].anu and Log_yyyy_MM_dd_dddd[3].anu

isn't it possible to just append to the file if it already exists in the format.

This is actually a very elegant way to solve the issue. Anybody else have thoughts on this?

would that mean that you might archive every 10 minutes, but you would only have one archived text file for each day if your Log timestamp doesnt include hours or minutes ?

If so sounds very good to me

skwire · « **Reply #148 on:** February 26, 2010, 09:33 AM »

Quote from: tomos on February 26, 2010, 09:29 AM

would that mean that you might archive every 10 minutes, but you would only have one archived text file for each day if your Log timestamp doesnt include hours or minutes ?

If so sounds very good to me

Correct.

doctorfrog · « **Reply #149 on:** February 27, 2010, 08:23 AM »

Sweet crispy crap, why didn't I think of this?