topbanner_forum
  *

avatar image

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

Login with username, password and session length
  • Tuesday October 8, 2024, 10:48 pm
  • 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 2011 Release: Snap DB  (Read 209792 times)

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #125 on: September 21, 2011, 09:29 AM »
Good to know.  Thanks, TalksToPCs.

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #126 on: October 31, 2011, 10:12 AM »
Website | Download
v1.3.3 - 2011-10-31
    + Numeric columns should now sort properly for CSV files.  (Thanks, Wayne)

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #127 on: December 03, 2011, 02:34 PM »
Website | Download
v1.3.4 - 2011-12-03
    + Added option to disable Ctrl+A within an edit field when adding/editing a
      record.  This helps with some non-English keyboards when entering accented
      characters.  (Thanks, J. Zebrowski)
    ! Printing didn't maintain the column order.  (Thanks, J. Elmes)
    ! Copying row(s) to the clipboard didn't maintain column order.

steeladept

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 1,061
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #128 on: December 04, 2011, 04:59 PM »
I noticed some of the recurring themes on implementation of requests are limited by the ListView control.  I am not much of a programmer, and even less wrt AHK, but perhaps a solution to many of these requests would be a second "read-only" mode that uses a different control for display?  I realize that takes away a lot of the simplicity of "open, enter, close" flat-file databases, but for some users, the tradeoff may be worth it (for a mulitline view, for example).  It may solve some of your other issues regarding the ListView limitations.

Just a thought....

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #129 on: December 05, 2011, 12:07 AM »
I noticed some of the recurring themes on implementation of requests are limited by the ListView control.  I am not much of a programmer, and even less wrt AHK, but perhaps a solution to many of these requests would be a second "read-only" mode that uses a different control for display?

Thanks for the feedback, steeladept, I appreciate it.  Yes, I'm limited in certain ways because of the listview control but I really don't mind since Snap DB serves a niche role in regards to databases.  If a user needs more than what Snap DB offers, I feel there are many solutions already out there (I use some of them).  You know?

daddydave

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 867
  • test
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #130 on: December 05, 2011, 04:40 AM »
Very handy! (I just happened to have a UTF-8 tab separated file lying around on my desk, so I thought I'd share.)

Screenshot - 12_5_2011 , 5_38_27 AM.png

daddydave

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 867
  • test
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #131 on: December 05, 2011, 12:22 PM »
What does "Run/execute cell data" do?

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #132 on: December 05, 2011, 12:28 PM »
What does "Run/execute cell data" do?

It will attempt to "run" the contents of a cell.  So, say you had folder path, it would launch that folder path.  Or, the path to an exe, image file, etc.  You can also put, say, email addresses in a cell and it will launch those, too.  Kind of like a poor man's address book.  Make sense?

daddydave

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 867
  • test
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #133 on: December 05, 2011, 12:40 PM »
What does "Run/execute cell data" do?

It will attempt to "run" the contents of a cell.  So, say you had folder path, it would launch that folder path.  Or, the path to an exe, image file, etc.  You can also put, say, email addresses in a cell and it will launch those, too.  Kind of like a poor man's address book.  Make sense?

Yes, thanks. :)

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #134 on: December 05, 2011, 12:46 PM »
Yes, thanks. :)

Right on.  Basically, anything you can stuff into the Windows "Run" box should work in a Snap DB cell.  BTW, nice screenshot.  Thanks for sharing.  =]

daddydave

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 867
  • test
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #135 on: December 29, 2011, 11:13 PM »
I was going to ask if there were any plans to allow exporting while in filter mode, but I just noticed Print kind of does that.

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #136 on: December 30, 2011, 12:10 AM »
I was going to ask if there were any plans to allow exporting while in filter mode

Hmmm...I'm not sure why I don't allow that.  Let me see what I can do.

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #137 on: December 30, 2011, 09:36 AM »
@daddydave: From what I can tell, Export to CSV is available in Filter mode.  Is this what you meant?

Website | Download
v1.3.5 - 2011-12-30
    + Added a new "Web search this cell" option to the context menu.  The
      default is to use Google but you can configure any search engine in the
      Options dialog.
    * Changed the filter mode so a subset of the Edit menu is available.

daddydave

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 867
  • test
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #138 on: December 30, 2011, 12:11 PM »
Downloaded the version and I don't see any change in behavior I was referring to.
I am referring to File > Export rows to CSV file. The whole File menu disappears when I click on the checkbox for Filter/Read-Only mode.

To clarify further, it would be nice to be able to export a subset of records based on the filtered rows that are displayed.

I like the Web Search. I set it to search pronunciations from Forvo: http://www.forvo.com/search-hi/$$1 It works great from the right click menu, but nothing happens when I press Ctrl-W (which I think is generally used for "close window", but I don't know if that matters.

UPDATE:
Well "Copy Selected Rows" wasn't there before in Filter mode, right? I think I'd rather use that than export to CSV anyway, and I get tab separators. Excellent. That's probably all I need.

« Last Edit: December 30, 2011, 12:25 PM by daddydave »

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #139 on: December 30, 2011, 02:34 PM »
Downloaded the version and I don't see any change in behavior I was referring to.
I am referring to File > Export rows to CSV file. The whole File menu disappears when I click on the checkbox for Filter/Read-Only mode.
To clarify further, it would be nice to be able to export a subset of records based on the filtered rows that are displayed.

Sorry, I was focused on the toolbar button which was still available.  I've added back a subset of the File menu, while in filter mode, in this next build.

I like the Web Search. I set it to search pronunciations from Forvo: http://www.forvo.com/search-hi/$$1 It works great from the right click menu, but nothing happens when I press Ctrl-W (which I think is generally used for "close window", but I don't know if that matters.

Uh...yeah...about that.   :-[  See the latest build.    :D  Let me know if that works how you like.

Website | Download
v1.3.6 - 2011-12-30
    * Changed the filter mode so a subset of the File menu is available.
    ! If you're going to hotkey an action, it helps to actually add the code for
      said hotkey.  Ctrl+W now works for the new web search functionality added
      in the previous version.  (Thanks, daddydave)

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #140 on: March 04, 2012, 06:24 PM »
Website | Download
v1.3.7 - 2012-03-04
    + Added calendar buttons to the add/edit record dialogues.
    + Added functionality to export current data views to external scripts
      or programs.  See Help > Contents for more details.

DeVamp

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 122
  • Let the coding begin :-)
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #141 on: March 05, 2012, 04:46 AM »
Hi skwire.

Is it possible that you haven't updated the link with the newest vesion?

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #142 on: March 05, 2012, 07:39 AM »
Nope, the newest version is there.  You might try clearing your cache or using a different browser.

DeVamp

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 122
  • Let the coding begin :-)
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #143 on: March 05, 2012, 07:50 AM »
That problem again.

It's not the first time I have the problem. :-)

Got it now. Thanks.

Lets test :-)

DeVamp

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 122
  • Let the coding begin :-)
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #144 on: March 05, 2012, 08:27 AM »
I did some quick test and it looks great. :-)

Thank you :-)

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #145 on: March 05, 2012, 08:28 AM »
You're welcome.  Glad I could help.   :D

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #146 on: April 02, 2012, 01:57 PM »
Website | Download
v1.3.8 - 2012-04-02
    + Added F4 hotkey for adding a new record.
    * Toolbar is now toggle-able.  Use the View menu or Ctrl+T hotkey.
    * Took out the button icons in the add/edit dialog to speed things up.

rgdot

  • Supporting Member
  • Joined in 2009
  • **
  • Posts: 2,193
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #147 on: April 02, 2012, 02:57 PM »
Why not Alt-F4?

 ;D

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #148 on: April 02, 2012, 03:02 PM »
Why not Alt-F4?

 ;D

That would have been for a release yesterday, no?  =]

rgdot

  • Supporting Member
  • Joined in 2009
  • **
  • Posts: 2,193
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #149 on: April 02, 2012, 03:07 PM »
True, please keep that in mind for next year  ;)