Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

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

Login with username, password and session length
  • August 30, 2016, 12:15:34 PM
  • Proudly celebrating 10 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 92704 times)

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 4,612
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #125 on: October 31, 2011, 10:12:49 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: 4,612
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #126 on: December 03, 2011, 02:34:29 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,059
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #127 on: December 04, 2011, 04:59:33 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: 4,612
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #128 on: December 05, 2011, 12:07:48 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: 822
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #129 on: December 05, 2011, 04:40:00 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
If bad things happen to other people, it's karma. If bad things happen to me, it's kismat!

daddydave

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 822
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #130 on: December 05, 2011, 12:22:35 PM »
What does "Run/execute cell data" do?
If bad things happen to other people, it's karma. If bad things happen to me, it's kismat!

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 4,612
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #131 on: December 05, 2011, 12:28:56 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: 822
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #132 on: December 05, 2011, 12:40: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?

Yes, thanks. :)
If bad things happen to other people, it's karma. If bad things happen to me, it's kismat!

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 4,612
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #133 on: December 05, 2011, 12:46:27 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: 822
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #134 on: December 29, 2011, 11:13:40 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.
If bad things happen to other people, it's karma. If bad things happen to me, it's kismat!

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 4,612
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #135 on: December 30, 2011, 12:10:37 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: 4,612
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #136 on: December 30, 2011, 09:36:53 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: 822
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #137 on: December 30, 2011, 12:11:43 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.

If bad things happen to other people, it's karma. If bad things happen to me, it's kismat!
« Last Edit: December 30, 2011, 12:25:34 PM by daddydave »

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 4,612
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #138 on: December 30, 2011, 02:34:02 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: 4,612
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #139 on: March 04, 2012, 06:24:03 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: 116
  • Let the coding begin :-)
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #140 on: March 05, 2012, 04:46:30 AM »
Hi skwire.

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

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 4,612
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #141 on: March 05, 2012, 07:39:14 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: 116
  • Let the coding begin :-)
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #142 on: March 05, 2012, 07:50:57 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: 116
  • Let the coding begin :-)
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #143 on: March 05, 2012, 08:27:14 AM »
I did some quick test and it looks great. :-)

Thank you :-)

skwire

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

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 4,612
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #145 on: April 02, 2012, 01:57:31 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: 1,856
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #146 on: April 02, 2012, 02:57:25 PM »
Why not Alt-F4?

 ;D

skwire

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

 ;D

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

rgdot

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

lilsypha

  • Participant
  • Joined in 2012
  • *
  • default avatar
  • Posts: 1
    • View Profile
    • Donate to Member
Re: NANY 2011 Release: Snap DB
« Reply #149 on: June 03, 2012, 12:20:46 AM »
Hi skwire!

I'm getting quite a lot of use out of this little program -- it's a simpler replacement to Iliumsoft's Listpro. Listpro isn't portable, and doesn't look as if it's ever going to be, so onwards and upwards.

Is it possible that you might add the ability for multiple filters in the future?

For example, right now I can choose column 1 > contains > something. With that filter active, I'd love to be able to filter that data with column 3 > contains > something else.

Does that make sense?

Up to three filters would be lovely, more if it's configurable.

Cheers.  :)