Author Topic: NANY 2010 Release: Anuran (Read 220440 times)

skwire · « **Reply #125 on:** January 30, 2010, 06:39 PM »

The date stamp algorithim in Excel is the days since January 1st, 1900 + Military Hours/24
-AEngineer (January 30, 2010, 04:25 PM)

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 30, 2010, 08:30 PM »

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 30, 2010, 09:00 PM »

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 30, 2010, 09:07 PM »

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 30, 2010, 09:13 PM »

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.
-AEngineer (January 30, 2010, 09:07 PM)

Cool...no line breaks makes things easier.

You're amazing - it's Saturday night and you should be out carousing.
-AEngineer (January 30, 2010, 09:07 PM)

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

skwire · « **Reply #130 on:** January 30, 2010, 09:41 PM »

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 30, 2010, 09:54 PM »

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 30, 2010, 11:27 PM »

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.
-doctorfrog (January 30, 2010, 09:54 PM)

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

AEngineer · « **Reply #133 on:** January 31, 2010, 06:44 AM »

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, 01:02 PM »

Works on my end as well. Nice addition.

doctorfrog · « **Reply #135 on:** January 31, 2010, 02: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, 04: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, 05:34 PM »

I threw together a quick proof of concept for a tail program for Anuran. I'm not a programmer, so I'm cribbing from other established tools, tail-f.exe from http://cybertiggyr.c...00040000000000000000 and console 2 from http://sourceforge.net/projects/console/

All it does is call forth a translucent terminal that tails ..\current.anu. To use it, unzip into a new directory inside your Anuran directory, and run Console.exe. To change how the window behaves, right click on the black space for a menu; I've hidden all of Console 2's widgetry. Also, the program will terminate if it doesn't find ..\current.anu.

This is by no means meant to be distributed, just something I've been thinking about for a bit as an addon for Anuran. It's meant as an always-on-bottom or desktop widget that allows you to quickly refer to your anuran log to see what you've been entering for the past n entries, without having to bring up AnuView.

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

anuran featured on pcworld today:
http://www.pcworld.c..._freebie_anuran.html

Screenshot - 2_4_2010 , 5_52_05 PM_thumb.png

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

Awesome. Congratulations, Skwire!

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

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

AEngineer · « **Reply #141 on:** February 06, 2010, 01: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, 01:39 PM »

It would be MUCH cleaner to export the time in military (24 hour) units.
-AEngineer (February 06, 2010, 01:00 PM)

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, 02:54 PM »

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

skwire · « **Reply #144 on:** February 06, 2010, 02: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:

NANY 2010 Release: Anuran

DeVamp · « **Reply #145 on:** February 23, 2010, 10:03 AM »

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, 02:44 AM »

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.
-DeVamp (February 23, 2010, 10:03 AM)

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

the only thing i have with it, is the way of archiving.
-DeVamp (February 23, 2010, 10:03 AM)

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.

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.
-DeVamp (February 23, 2010, 10:03 AM)

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

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.
-DeVamp (February 23, 2010, 10:03 AM)

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, 03:29 AM »

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.
-DeVamp (February 23, 2010, 10:03 AM)

This is actually a very elegant way to solve the issue. Anybody else have thoughts on this?
-skwire (February 26, 2010, 02:44 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

skwire · « **Reply #148 on:** February 26, 2010, 03:33 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
-tomos (February 26, 2010, 03:29 AM)

Correct.

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

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