Welcome Guest.   Make a donation to an author on the site April 24, 2014, 07:06:19 PM  *

Please login or register.
Or did you miss your validation email?


Login with username and password (forgot your password?)
Why not become a lifetime supporting member of the site with a one-time donation of any amount? Your donation entitles you to a ton of additional benefits, including access to exclusive discounts and downloads, the ability to enter monthly free software drawings, and a single non-expiring license key for all of our programs.


You must sign up here before you can post and access some areas of the site. Registration is totally free and confidential.
 
Read the Practical Guide to DonationCoder.com Forum Search Features
   
   Forum Home   Thread Marks Chat! Downloads Search Login Register  
Pages: Prev 1 2 3 4 5 [6] 7 8 9 Next   Go Down
  Reply  |  New Topic  |  Print  
Author Topic: NANY 2010 Release: Anuran  (Read 73603 times)
skwire
Charter Member
***
Posts: 3,912



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #125 on: January 30, 2010, 06:39:22 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?
Logged

AEngineer
Supporting Member
**
Posts: 42


View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #126 on: January 30, 2010, 08:30:33 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.
Logged

Jim Mitchell
skwire
Charter Member
***
Posts: 3,912



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #127 on: January 30, 2010, 09:00:55 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?

Logged

AEngineer
Supporting Member
**
Posts: 42


View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #128 on: January 30, 2010, 09:07: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.

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

Jim Mitchell
skwire
Charter Member
***
Posts: 3,912



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #129 on: January 30, 2010, 09:13:32 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.  =]
Logged

skwire
Charter Member
***
Posts: 3,912



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #130 on: January 30, 2010, 09:41:37 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.
Logged

doctorfrog
Supporting Member
**
Posts: 134


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #131 on: January 30, 2010, 09:54:39 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.
Logged
skwire
Charter Member
***
Posts: 3,912



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #132 on: January 30, 2010, 11:27:38 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?
Logged

AEngineer
Supporting Member
**
Posts: 42


View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #133 on: January 31, 2010, 06:44:20 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.
Logged

Jim Mitchell
doctorfrog
Supporting Member
**
Posts: 134


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #134 on: January 31, 2010, 01:02:25 PM »

Works on my end as well. Nice addition.
Logged
doctorfrog
Supporting Member
**
Posts: 134


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #135 on: January 31, 2010, 02:37:31 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."
Logged
AEngineer
Supporting Member
**
Posts: 42


View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #136 on: January 31, 2010, 04:39:11 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
Logged

Jim Mitchell
doctorfrog
Supporting Member
**
Posts: 134


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #137 on: February 02, 2010, 05:34:23 PM »

* anutail.7z (562.18 KB - downloaded 194 times.)

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.com/tl...CTION00040000000000000000 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:45 PM by doctorfrog » Logged
mouser
First Author
Administrator
*****
Posts: 32,701



see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #138 on: February 04, 2010, 05:53:32 PM »

anuran featured on pcworld today:
http://www.pcworld.com/ar..._with_freebie_anuran.html

Logged
doctorfrog
Supporting Member
**
Posts: 134


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #139 on: February 06, 2010, 12:04:11 AM »

Awesome. Congratulations, Skwire!
Logged
skwire
Charter Member
***
Posts: 3,912



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #140 on: February 06, 2010, 12:36:12 PM »

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

AEngineer
Supporting Member
**
Posts: 42


View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #141 on: February 06, 2010, 01:00:12 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.
Logged

Jim Mitchell
skwire
Charter Member
***
Posts: 3,912



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #142 on: February 06, 2010, 01:39:46 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.  =]
Logged

AEngineer
Supporting Member
**
Posts: 42


View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #143 on: February 06, 2010, 02:54:09 PM »

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

Jim Mitchell
skwire
Charter Member
***
Posts: 3,912



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #144 on: February 06, 2010, 02:54:47 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:

 
Logged

DeVamp
Supporting Member
**
Posts: 90



Let the coding begin :-)

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #145 on: February 23, 2010, 10:03:33 AM »

I  Kiss Kiss 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.
Logged
skwire
Charter Member
***
Posts: 3,912



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #146 on: February 26, 2010, 02:44:49 AM »

Kiss Kiss 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.  Grin  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.
Logged

tomos
Charter Member
***
Posts: 8,067



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #147 on: February 26, 2010, 03:29:52 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
Logged

Tom
skwire
Charter Member
***
Posts: 3,912



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #148 on: February 26, 2010, 03:33:18 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.
Logged

doctorfrog
Supporting Member
**
Posts: 134


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #149 on: February 27, 2010, 02:23:26 AM »

Sweet crispy crap, why didn't I think of this?
Logged
Pages: Prev 1 2 3 4 5 [6] 7 8 9 Next   Go Up
  Reply  |  New Topic  |  Print  
 
Jump to:  
   Forum Home   Thread Marks Chat! Downloads Search Login Register  

DonationCoder.com | About Us
DonationCoder.com Forum | Powered by SMF
[ Page time: 0.05s | Server load: 0.09 ]