topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Thursday March 28, 2024, 10:33 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Last post Author Topic: NANY 2010 Release: Anuran  (Read 206420 times)

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2010 Release: Anuran
« 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

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

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 54
    • View Profile
    • James E. Mitchell - Drexel University
    • Read more about this member.
    • Donate to Member
Re: NANY 2010 Release: Anuran
« 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.
Jim Mitchell

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2010 Release: Anuran
« 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

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 54
    • View Profile
    • James E. Mitchell - Drexel University
    • Read more about this member.
    • Donate to Member
Re: NANY 2010 Release: Anuran
« 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.
Jim Mitchell

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2010 Release: Anuran
« 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.

Cool...no line breaks makes things easier.

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

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

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2010 Release: Anuran
« 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

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 140
    • View Profile
    • Donate to Member
Re: NANY 2010 Release: Anuran
« 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

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2010 Release: Anuran
« 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.

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

AEngineer

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 54
    • View Profile
    • James E. Mitchell - Drexel University
    • Read more about this member.
    • Donate to Member
Re: NANY 2010 Release: Anuran
« 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.
Jim Mitchell

doctorfrog

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 140
    • View Profile
    • Donate to Member
Re: NANY 2010 Release: Anuran
« Reply #134 on: January 31, 2010, 01:02 PM »
Works on my end as well. Nice addition.

doctorfrog

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 140
    • View Profile
    • Donate to Member
Re: NANY 2010 Release: Anuran
« 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

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 54
    • View Profile
    • James E. Mitchell - Drexel University
    • Read more about this member.
    • Donate to Member
Re: NANY 2010 Release: Anuran
« 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   :mad:
Jim Mitchell

doctorfrog

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 140
    • View Profile
    • Donate to Member
Re: NANY 2010 Release: Anuran
« Reply #137 on: February 02, 2010, 05:34 PM »
2010-02-02_153448.png

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.
« Last Edit: February 02, 2010, 05:41 PM by doctorfrog »

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: NANY 2010 Release: Anuran
« 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

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 140
    • View Profile
    • Donate to Member
Re: NANY 2010 Release: Anuran
« Reply #139 on: February 06, 2010, 12:04 AM »
Awesome. Congratulations, Skwire!

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2010 Release: Anuran
« Reply #140 on: February 06, 2010, 12:36 PM »
Thanks, froggy, and thanks to everybody for shaping Anuran into what it is today.  =]

AEngineer

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 54
    • View Profile
    • James E. Mitchell - Drexel University
    • Read more about this member.
    • Donate to Member
Re: NANY 2010 Release: Anuran
« 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.
Jim Mitchell

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2010 Release: Anuran
« Reply #142 on: February 06, 2010, 01:39 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

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 54
    • View Profile
    • James E. Mitchell - Drexel University
    • Read more about this member.
    • Donate to Member
Re: NANY 2010 Release: Anuran
« Reply #143 on: February 06, 2010, 02:54 PM »
Ummm.  I guess I saw it and didn't register.  Thanks for informing me!  ;)
Jim Mitchell

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2010 Release: Anuran
« 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:

2010-02-06_141923.pngNANY 2010 Release: Anuran  2010-02-06_142044.pngNANY 2010 Release: Anuran

DeVamp

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 122
  • Let the coding begin :-)
    • View Profile
    • Donate to Member
Re: NANY 2010 Release: Anuran
« Reply #145 on: February 23, 2010, 10:03 AM »
I  :-* :-* the program.  :Thmbsup:

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

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2010 Release: Anuran
« Reply #146 on: February 26, 2010, 02:44 AM »
:-* :-* the program.  :Thmbsup:

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.

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

Hehehe...yeah, I know what you mean.  ;D  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.

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.

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

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,959
    • View Profile
    • Donate to Member
Re: NANY 2010 Release: Anuran
« 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.

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
Tom

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2010 Release: Anuran
« 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

Correct.

doctorfrog

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 140
    • View Profile
    • Donate to Member
Re: NANY 2010 Release: Anuran
« Reply #149 on: February 27, 2010, 02:23 AM »
Sweet crispy crap, why didn't I think of this?