Messages

31

ThumbsPlus v10 Questions / Re: This Format Requires ThumbsPlus Professional Edition?

« on: 2023-01-31 22:09:25 »

No!  'Load file using' has nothing in it.

Alright, my filetype definition for the jpg extension looks like this:

=-=-=-=-=-=-=-=-=-=-=-=

Equivalent to type: (none)
Category:Image
Class: Raster

Load file using: Internal >>  (empty)
Edit file Using: Association >> (empty)
Print file using: Internal >>  (empty)

Not associated with ThumbsPlus
No linked extensions.

=-=-=-=-=-=-=-=-=-=-=-=

I believe these were the default settings, and they work fine here, on Win 11 Pro.

BTW, where is the last Pro version to download?

It's not a separate download. The 'Pro' features are unlocked when you enter a pro level license number.

32

ThumbsPlus v10 Questions / Re: This Format Requires ThumbsPlus Professional Edition?

« on: 2023-01-31 18:04:22 »

That's strange. If you have the Pro version, have you tried re-entering your license details? (Help | Enter Registration in the menu).

Are you sure that the files are actually JPG files and not some misnamed other type?

When you right-click on a JPG file and choose 'Configure File Type', does the 'Load file using' setting say 'Internal'?

Have you changed anything about ThumbsPlus or Windows in recent days? Like, installed a plug-in, changed user accounts, re-installed ThumbsPlus..?

33

ThumbsPlus v10 Questions / Re: Restrict search to Gallery - is it possible? - Would be a great feature

« on: 2023-01-25 16:55:11 »

I just realised that those old newsgroup messages must have been written with the old .TD4 database format in mind. Hopefully you can 'translate' the field names to those used by TP8 and higher.

34

ThumbsPlus v10 Questions / Re: Restrict search to Gallery - is it possible? - Would be a great feature

« on: 2023-01-25 16:49:06 »

Hi Ernst,

I don't know about those date searches. Maybe we can look into that later.

As for gallery searches: If you don't like SQL, a possible workaround is that you simply assign a unique keyword to all the files in that gallery, and then do a regular search for that keyword, plus your additional search criteria.

If you prefer an SQL method, I will copy 2 very old but relevant messages below from the old Cerious Newsgroups. They come without their original context (otherwise I'd have to copy and paste whole threads), but the information contained in them could still be helpful, I think.

Regards,

-Daan-

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=[ 1 ]=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
From: "Jose G. Filippa" <jose@cerious.com>
Newsgroups: cerious.support
Subject: Re: Thumbsplus 7.0 problem with gallery search
Date: Fri, 14 Apr 2006 10:14:46 -0300

Hi Chris,

In order to find those thumbnails which are included in at least one gallery
or sub-gallery but are not included in a specific gallery you should use the
following SQL statement:

tn.idThumb in (select gt.idThumb from GalleryThumb as gt) and tn.idThumb not
in (select GalleryThumb.idThumb from GalleryThumb inner join Gallery on
GalleryThumb.idGallery=Gallery.idGallery where Gallery.name like 'UF\%')

Now for a set of galleries and sub-galleries you should use:

tn.idThumb in (select gt.idThumb from GalleryThumb as gt) and tn.idThumb not
in (select GalleryThumb.idThumb from GalleryThumb inner join Gallery on
GalleryThumb.idGallery=Gallery.idGallery where Gallery.name in
('UF\Gallery1','Temp'))

(Note that you can not use wildcards when using the "in" operator.)

Or if you really need to use wildcards:

tn.idThumb in (select gt.idThumb from GalleryThumb as gt) and tn.idThumb not
in (select GalleryThumb.idThumb from GalleryThumb inner join Gallery on
GalleryThumb.idGallery=Gallery.idGallery where  (Gallery.name like 'UF\%' or
Gallery.name like 'Temp%'))

By the way, your query (the one that hung your ThumbsPlus) worked OK in
ThumbsPlus in my system. I will continue investigating about this issue.

Best regards,

José G. Filippa
Cerious Software



=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=[ 2 ]=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
From: Uwe Zimmermann <uwezi@/no_mail/sciencetronics.com>
Newsgroups: cerious.support
Subject: Re: Search Gallery
Date: Mon, 01 Nov 2004 12:56:16 +0100

Until galleries finally work like normal directories, you should be
able to use the additional SQL query:

this is for one specific gallery "galleryname"
-----------------------------------------------
exists (select idThumb from gallerythumb gt inner join gallery
ga on gt.idGallery = ga.idGallery where ga.name = 'galleryname' and
gt.idThumb = tn.idThumb)

this is for images in any gallery
-----------------------------------------------
exists (select idThumb from gallerythumb gt where
gt.idThumb = tn.idThumb)

    Uwe.

35

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

« 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.

36

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

« 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.

37

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

« on: 2022-06-10 20:10:53 »

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

38

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

« 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.

39

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

« 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.

40

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

« on: 2022-05-24 14:09:30 »

When you delete information from a database, the database file itself does not shrink because the information is not physically removed from the database. It is only flagged internally as deleted. This is because database files can get very large, and re-writing them everytime that a record is deleted would make them too slow.

So, to physically cleanse the database file of deleted records, you use a special function that you find in the menu as Database | Compact & Repair.

Before you use this function, you may want to do two other things first:

1) Remove thumbnails that you no longer need. You can do so by in several ways. For instance, you can select them and press Shift-Del. Or you can right-click on a folder name (in the tree) and use Remove from Tree, to remove all thumbnails pertaining to that folder and its subfolders (be very careful that you do not accidentily use just Del or Delete Folder because that would delete the actual image files from your harddrive!)

2) Remove 'orphaned' thumbnails. A thumbnail record is orphaned when the file that it describes no longer exists. To remove orphans, use Thumbnail | Remove | Orphans from the menu.

When you have done these things, you can use the Compact & Repair function that I mentioned earlier to re-gain a lot of space.

41

ThumbsPlus v10 Questions / Re: Is Cerious really still working?

« on: 2022-05-10 06:32:02 »

I'm just curious if anyone else has tried contacting them, and whether there was any response.

That's strange about the bug system response. Maybe you should just try again? I haven't talked to them recently either, but I'm also not seeing any complaints from people who have problems getting support or a key. Anyway, if you need HEIC support now, I'm not sure if you should keep waiting, seeing how long we already have been waiting.

42

ThumbsPlus v10 Questions / Re: Is Cerious really still working?

« on: 2022-05-08 11:08:49 »

Have you written to sales@thumbsplus.com ?

43

ThumbsPlus v10 Questions / Re: Thumbsplus items in context menus

« on: 2022-04-19 19:24:14 »

I don't think I've heard of this problem before, but I'd recommend that you try these two small freeware tools that deal with Explorer context menus and shell extensions:

https://www.nirsoft.net/utils/shell_menu_view.html
https://www.nirsoft.net/utils/shexview.html

Hopefully one of those will let you reenable TP's context menu entries!

44

ThumbsPlus v7-v9 Questions / Re: Any way to view HEIC in v7

« on: 2022-04-13 15:55:03 »

I just realized, you're also on the Ritlabs forum, aren't you?

Haha, yes I am!

45

ThumbsPlus v7-v9 Questions / Re: Any way to view HEIC in v7

« on: 2022-04-12 18:04:13 »

Hopefully someone still looks in this subforum.

I do, but I'm afraid I don't have any suggestions!