Recent Posts

Pages: 1 ... 6 7 [8] 9 10
71
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
72
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.
73
Daan,
I did exactly what you said, but the resulting database was somehow corrupted.
Thank you very much.
thmbsatha
74
ThumbsPlus v10 Questions / Renewal of TP database from Access to SQLite
« Last post by runner on 2022-05-25 10:01:19 »
I have been using TP for image management for many years. During this time I have changed the computer and directories several times. I have looked at the tables with MDBPlus and found that there are many incorrect and nonsensical entries.

I would now like to convert the existing Access databases into Sqlite databases. I hope to have a better management of the data.

Does anyone have a tip on how I could do this most easily? The database structure is clear to me, but I want to do as little work as possible.

I am using TP10


Thanks and Greetings
Rainer

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

76
If a ThumbsPlus 10 database has reached its maximum size, we cannot use it again. We cannot search for new words again. Can we reduce the size of it so that we can use it again? It does not search for new word again, because it cannot construct new thumbnails due to the maximum size.
Thank you.
thumbsatha
77
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.
78
ThumbsPlus v10 Questions / Re: Is Cerious really still working?
« Last post by Warner_Young on 2022-05-09 19:04:27 »
Daan, yes, I did back in August of 2021. I got a reply back from bugsystem@thumbsplus.com instead of the sales address. Whoever it was didn't give a name other than "ThumbsPlus Team", and said they expected a public beta in a few months. They then went on to list the features in ThumbsPlus 10. Some of the English in the email seemed a little off, almost as if English wasn't the writer's native language. It certainly didn't sound like any previous emails I've gotten from Cerious.

I'm just curious if anyone else has tried contacting them, and whether there was any response.
79
Have you written to sales@thumbsplus.com ?
80
ThumbsPlus v10 Questions / Is Cerious really still working?
« Last post by Warner_Young on 2022-05-07 19:50:35 »
Has anyone been able to contact anybody at Cerious to confirm they're still working? I've finally found that I need something newer than TP 7, since I need to handle HEIC files. But I have no idea if I should still wait for TP 11 or not.
Pages: 1 ... 6 7 [8] 9 10