Recent Posts

81

ThumbsPlus v10 Questions / Re: TP10/Windows 11/Folder Icons

« Last post by Daan van Rooijen on 2022-11-04 12:45:36 »

The help file suggests that ThumbsPlus will show the Windows folder icon ("Display folders -- Include folders in the thumbnail display. With this option checked, ThumbsPlus will also make thumbnails for folders, based on the current Windows thumbnail").

So, if you can get Win 11 to show those XP-style thumbnails, hopefully TP will adopt those too.

82

ThumbsPlus v10 Questions / TP10/Windows 11/Folder Icons

« Last post by Gary on 2022-11-04 12:02:44 »

Prior to Win11 22H2, M$ removed folder thumbnails so TP10 only displays a plain folder thumbnail for any new or refreshed folders.  Win11 22H2 restored a pitiful version of folder thumbnails so at least we get a stupid looking cropped single image thumbnail.  WTF M$?  Is there any way to make TP10 create folder thumbnails similar to XnViewMP?  i.e. folder thumbnail with 1 to 4 image thumbnails within.

83

ThumbsPlus v10 Questions / Re: Where did the sql examples go?

« Last post by Daan van Rooijen on 2022-10-09 00:45:12 »

It has been cataloged in the Archive.org 'Way Back Machine', see:

https://web.archive.org/web/20170925061254/http://www.cerious.com/faq_sql.shtml

This particular page shows the last capture from sometime in 2017, but there have been many earlier captures as well.

84

ThumbsPlus v10 Questions / Where did the sql examples go?

« Last post by Street Mann on 2022-10-08 11:27:11 »

Am trying to find that help file concerning how to structure my sql to searches of my annotations for a particular word. I hit the examples link in the help for the sql but it seems broken....  http://www.cerious.com/faq_sql.shtml

has that page been moved. Where?

I found that was very helpful.

85

ThumbsPlus v10 Questions / Re: How to query files based on the Date Taken

« Last post by Daan van Rooijen on 2022-06-10 20:10:53 »

Thanks Bernard! It's interesting that no conversion is required for the taken_time_iso field!

86

ThumbsPlus v10 Questions / Re: How to query files based on the Date Taken

« Last post by Bernie on 2022-06-10 13:33:09 »

Hi,

Many Thanks!
I finally managed searching files using following syntax:
( tn.[taken_time_iso] >  '2022-05-07 00:00:00') AND ( tn.[taken_time_iso] <  '2022-05-08 00:00:00')

Regards
Bernard

87

ThumbsPlus v10 Questions / Re: How to query files based on the Date Taken

« Last post by Daan van Rooijen on 2022-06-04 08:01:30 »

Most dates and times in the database are stored in unix format, i.e. seconds that have passed since jan 1, 1970. You can use the Udate command to convert them into the less cryptic ISO format that Windows uses. This is a sample query that queries the regular file date:

    tn.file_time = ^udate(yyyy-mm-dd HH:mm:ss)

For a range of times/dates, you'd combine two expressions using the AND operator, like this:

    (tn.file_time >= ^udate(2022-02-10))
    AND (tn.file_time < ^udate(2022-02-11))

Hopefully these examples will also work when you use the  tn.[taken_time_iso] field instead.

88

ThumbsPlus v10 Questions / How to query files based on the Date Taken

« Last post by Bernie on 2022-06-04 05:05:02 »

Hi,

Searching (quering) feature is great.

Let consider I see following in My Metadata pane
Info > Date Taken : display 31/05/2022 13:59:50.825

How could I search all files from that same 'Date Taken' date : 31/05/2022 ?

I did try various combinaison like:
 tn.[taken_time_iso] like '2022:%:% %:%:%'
or
 tn.[taken_time_iso] = '31/05/2022 13:59:50.825'
in query Advanced pane but none give me results!

Thanks in advance
Regards
Bernie

89

ThumbsPlus v10 Questions / Re: Can We Somehow Use a Database of Maximum Size?

« Last post by Daan van Rooijen on 2022-05-28 00:14:14 »

I did exactly what you said, but the resulting database was somehow corrupted.

I'm very sorry to hear that - and surprised! Did you see any error messages? The Compact & Repair function that ThumbsPlus uses is actually part of the Windows operating system, and one of its main purposes is to prevent corruption, not cause it. I hope you've been able to restore a backup.

90

ThumbsPlus v10 Questions / Re: Can We Somehow Use a Database of Maximum Size?

« Last post by thmbsatha on 2022-05-27 18:57:06 »

Daan,
I did exactly what you said, but the resulting database was somehow corrupted.
Thank you very much.
thmbsatha