Author Topic: Sorting thumbs by thumb creation date  (Read 3610 times)

0 Members and 1 Guest are viewing this topic.

farbauge

  • Member
  • **
  • Posts: 3
    • View Profile
Sorting thumbs by thumb creation date
« on: 2015-06-29 15:04:37 »
Hello everybody,

I am looking for a possibility to sort thumbs by their entry date into the database,
which means the same as thumbnail creation date.

In this forum I have read about the workaround: switch off automatic thumb generation,
tag the files somehow etc. But that's too late for me, the thumbs already exist and I would like too see the newest files added.

If you open the database in MS Access there is a field "thumbnail_time_iso" in the table "Thumbnail" which should do. But I don't know how to add this field as a sorting
criterion into the frontend. Is there any scripting possibility. I'm afraid I don't know the scripting languages used by ThumbsPlus, my only knowledge is in VBA.

If anyone has a solution or hint I would be grateful.

Best regards

Peter

Daan van Rooijen

  • Administrator
  • Sr. Member
  • *****
  • Posts: 933
    • View Profile
Sorting thumbs by thumb creation date
« Reply #1 on: 2015-06-29 15:37:01 »
The only thing that I can think of is that you'd make a suitable user field (Database | Setup User Fields) and then, from outside thumbsplus (e.g. using MS Access), copy the thumbnail creation date into that user field. You could then sort the thumbnail listing on it.
I'm volunteering as a moderator - I do not work for Cerious Software, Inc.

farbauge

  • Member
  • **
  • Posts: 3
    • View Profile
Sorting thumbs by thumb creation date
« Reply #2 on: 2015-06-29 16:47:32 »
Hi Daan,

thank you for your answer. Basically I think it is a very good idea.
I had a look into the tables in MS Access. It should even be possible
to fill the user field automatically, using the thumb id as key and some
SQL statement.

But...in the GUI of ThumbsPlus I don't see a possibility to sort by a
certain user field (maybe I don't see the forest because of so many trees,
as a German saying goes). There are only the given standard sorting criteria
and - as I think - no way to change them or add one. Hopefully I am wrong
and you tell me.

Best regards
Peter

Daan van Rooijen

  • Administrator
  • Sr. Member
  • *****
  • Posts: 933
    • View Profile
Sorting thumbs by thumb creation date
« Reply #3 on: 2015-06-29 17:04:04 »
Oh I forgot to tell -- When you make the userfield visible in the thumbnail listing, you can sort on it (click on the lightbulb icon above the thumbnail list).
I'm volunteering as a moderator - I do not work for Cerious Software, Inc.

farbauge

  • Member
  • **
  • Posts: 3
    • View Profile
Sorting thumbs by thumb creation date
« Reply #4 on: 2015-06-29 17:45:12 »
Perfect - got it.

Thanks a lot.
Peter