Author Topic: NANY 2011 Release: Snap DB (Read 213614 times)

skwire · « **Reply #125 on:** September 21, 2011, 09:29 AM »

Good to know. Thanks, TalksToPCs.

skwire · « **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 · « **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 · « **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 · « **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?
-steeladept (December 04, 2011, 04:59 PM)

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 #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 · « **Reply #131 on:** December 05, 2011, 12:22 PM »

What does "Run/execute cell data" do?

skwire · « **Reply #132 on:** December 05, 2011, 12:28 PM »

What does "Run/execute cell data" do?
-daddydave (December 05, 2011, 12:22 PM)

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 #133 on:** December 05, 2011, 12:40 PM »

What does "Run/execute cell data" do?
-daddydave (December 05, 2011, 12:22 PM)

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?
-skwire (December 05, 2011, 12:28 PM)

Yes, thanks.

skwire · « **Reply #134 on:** December 05, 2011, 12:46 PM »

Yes, thanks.
-daddydave (December 05, 2011, 12:40 PM)

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 #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 · « **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
-daddydave (December 29, 2011, 11:13 PM)

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

skwire · « **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 · « **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.

skwire · « **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.
-daddydave (December 30, 2011, 12:11 PM)

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.
-daddydave (December 30, 2011, 12:11 PM)

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 #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 · « **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 · « **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 · « **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 · « **Reply #144 on:** March 05, 2012, 08:27 AM »

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

Thank you :-)

skwire · « **Reply #145 on:** March 05, 2012, 08:28 AM »

You're welcome. Glad I could help.

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

Why not Alt-F4?

skwire · « **Reply #148 on:** April 02, 2012, 03:02 PM »

Why not Alt-F4?

-rgdot (April 02, 2012, 02:57 PM)

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

rgdot · « **Reply #149 on:** April 02, 2012, 03:07 PM »

True, please keep that in mind for next year