Author Topic: NANY 2011 Release: Snap DB (Read 290,378 times)

skwire · « **Reply #125 on:** October 31, 2011, 03:12 PM »

Website | Download v1.3.3 - 2011-10-31 + Numeric columns should now sort properly for CSV files. (Thanks, Wayne)

skwire · « **Reply #126 on:** December 03, 2011, 08: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 · « **Reply #127 on:** December 04, 2011, 10: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 · « **Reply #128 on:** December 05, 2011, 06:07 AM »

Quote from: steeladept on December 04, 2011, 10: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?

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 · « **Reply #129 on:** December 05, 2011, 10: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.)

[attachimg=#]

daddydave · « **Reply #130 on:** December 05, 2011, 06:22 PM »

What does "Run/execute cell data" do?

skwire · « **Reply #131 on:** December 05, 2011, 06:28 PM »

Quote from: daddydave on December 05, 2011, 06:22 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 · « **Reply #132 on:** December 05, 2011, 06:40 PM »

Quote from: skwire on December 05, 2011, 06:28 PM

Quote from: daddydave on December 05, 2011, 06:22 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 · « **Reply #133 on:** December 05, 2011, 06:46 PM »

Quote from: daddydave on December 05, 2011, 06:40 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 · « **Reply #134 on:** December 30, 2011, 05:13 AM »

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 · « **Reply #135 on:** December 30, 2011, 06:10 AM »

Quote from: daddydave on December 30, 2011, 05:13 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 · « **Reply #136 on:** December 30, 2011, 03:36 PM »

@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 · « **Reply #137 on:** December 30, 2011, 06: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.

skwire · « **Reply #138 on:** December 30, 2011, 08:34 PM »

Quote from: daddydave on December 30, 2011, 06: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.

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.

Quote from: daddydave on December 30, 2011, 06:11 PM

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.

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 · « **Reply #139 on:** March 05, 2012, 12:24 AM »

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 · « **Reply #140 on:** March 05, 2012, 10:46 AM »

Hi skwire.

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

skwire · « **Reply #141 on:** March 05, 2012, 01:39 PM »

Nope, the newest version is there. You might try clearing your cache or using a different browser.

DeVamp · « **Reply #142 on:** March 05, 2012, 01:50 PM »

That problem again.

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

Got it now. Thanks.

Lets test :-)

DeVamp · « **Reply #143 on:** March 05, 2012, 02:27 PM »

I did some quick test and it looks great. :-)

Thank you :-)

skwire · « **Reply #144 on:** March 05, 2012, 02:28 PM »

You're welcome. Glad I could help.

skwire · « **Reply #145 on:** April 02, 2012, 06: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 · « **Reply #146 on:** April 02, 2012, 07:57 PM »

Why not Alt-F4?

skwire · « **Reply #147 on:** April 02, 2012, 08:02 PM »

Quote from: rgdot on April 02, 2012, 07:57 PM

Why not Alt-F4?

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

rgdot · « **Reply #148 on:** April 02, 2012, 08:07 PM »

True, please keep that in mind for next year

lilsypha · « **Reply #149 on:** June 03, 2012, 05:20 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.