ThumbsPlus

All forums => ThumbsPlus v7-v9 Questions => Topic started by: Charlie Markwick on 2015-02-18 07:20:34

Title: SQL
Post by: Charlie Markwick on 2015-02-18 07:20:34

What's the best way of producing a report of files that don't have a thumbnail?

Title: SQL
Post by: Daan van Rooijen on 2015-02-18 12:26:34

If they have no thumbnail record, they don't exist in the database and there'd be nothing for an SQL-query to find.

What you can do though is set TP to display all files, and to show thumbnails last so that all non-thumbnailed files (red X icon) are shown first in the thumbnail list. Select them and press Shift-Alt-C to copy their filenames to the clipboard. Depending on your settings, the list may not include Hidden and System files and files in subfolders.

Title: SQL
Post by: Charlie Markwick on 2015-02-19 07:47:35

Thanks Daan

Looking back at the DB I can see that it was a foolish question. There are too may photos to try your suggestion I'm afraid I'll just have to regularly rescan the tree.