Messages

1

ThumbsPlus v10 Questions / XMPNames and Userfields confused

« on: 2018-03-23 08:27:24 »

Since several days my T10-System is confused at the  automatic Import of xmp-/EXIF-Metadata into userfields. Seems that there is a change in the spelling/syntax of the Metadata fields. For example there was a xmp-Field spelling "FStop", now it is "F_Stop" or "GPSLongitude" now is "Longitude" etc. Is there any actual list of the Metadata fields with the exact spelling/syntax?
Attached Screenshot of my actual userfields Design and the "translation table" userfieldsinfo.

2

ThumbsPlus v10 Questions / SP2 4013

« on: 2018-03-18 19:51:40 »

same here.

3

ThumbsPlus v10 Questions / PS: T10 Build 4007: Limit for most recent used Keywords?

« on: 2016-01-20 10:00:50 »

PS:
the offline help states: "The last 20 assigned keywords (or lists) will appear on this menu." Seems to work not properly.

4

ThumbsPlus v10 Questions / T10 Build 4007: Limit for most recent used Keywords?

« on: 2016-01-20 00:29:41 »

The List of most recent used Keywords in Thumbnail/Keywords/Assign Keywords seems endless. Can i limit the length of the List? I come from T7, and i remember, that i limited the list to the last 16 Entries (somewhere in the T7-options).
Workaround: delete in thumbs.ini file under [Mru Keywords] the entries with a number > [individual limit], for example 16.

5

ThumbsPlus v10 Questions / Multiple Databases

« on: 2016-01-20 00:07:10 »

Daan,
move Thumbnails to files seems easy in T10 Buidl 4007, see Release notes:
"Added Database - Advanced - Move Thumbnails to Files to make the process easier (in earlier versions you had to type several Python commands)"

6

ThumbsPlus v10 Questions / Multiple Databases

« on: 2016-01-19 03:16:06 »

Daan.

thank for Your reply.

with the separate userfields-file database speed is same as in the standard configuration.
Mainreason for this dirty method: if yo try to reconfigure the userfiels structure with a databse near the 2GB-Limit, you will always run off this limit with data loss, either in T+ or in MS-Access. If you change/add userfiels in the the separate file, don't forget to change also the "switchboard"- table userfieldsinfo.

I use the MS-Jet-Databas format, because i make some of semi-automatic work in MS-Access Examples:
1. i generate the annotation mostly by concetaning a short title like "Church" and the userfield "city" and "sublocation" (i fill these userfiels semi-automatic by geonames.org)with an update query in MS-Access:

UPDATE auThumbs SET auThumbs.annotation = IIf([uf_City]<>[uf_Sublocation],[annotation] & " in " & [uf_City] & "-" & [uf_sublocation],[annotation] & " in " & [uf_City])
WHERE (((auThumbs.annotation) Not Like "* in *") AND ((auThumbs.Path.name) Like [Bitte Pfadnamen mit Platzhalter]) AND ((auThumbs.uf_City) Is Not Null) AND ((auThumbs.uf_Sublocation) Is Not Null));
Example annotation= "church" City = "Venlo", Sublacation= "Blerick": resukt is annotation = "Church in Venlo-Blerick"

2. i calculate the sheet Number of topographic map (1:25000) from the photo-coordinates using a self constructed Visual-Basic-Function. etc.

I made some work to generate these queries und functions. I do not want to lose big parts of this work by changing the databse format.

BTW: This flexibility and extensibility is the reason why I'm loyal to T + from 2001 until today.

Now i'm trying to migrate to T+ 10 Build 4007 - after several frustrating tries with earlier buggy versions. Big advantage: move thumbnails to files!

7

ThumbsPlus v10 Questions / Multiple Databases

« on: 2016-01-18 16:41:27 »

I found two ways for working around the 2 GigB-Limit of MS-Jet-Database:
1. the thumbanils stored in the databse file needs far more space then every other database field. So make the thuunbnail size small. I used the size of 144x108 px with 25% jpg-Quality, a little bit eye-powder:-(. With 38 user fields and 470,000 Thumbnails the database needed about 1.6 GB.
2. dirty trick: move the userfields table in MS-Access in a separate mdb-file and add a link to this table in the thumbs-database. The tables "thumbnail" and "userfields" are 1:1 related via the Keys "idThumb" <-> "idThumbUDF". In my case the 1.6 GB were divided in 1.2 GB for the Thumbs-Database and 0.4 GB for the userfields table. In this case run database-compact/repair operations within MS-Access and disable this command in T+.The other tables in the T+-database like Keyword, Galleries etc. are tiny compared to Thumnbnail and userfields.

8

ThumbsPlus v7-v9 Questions / Search db for pictures with specific date

« on: 2014-12-06 12:00:42 »

tn.[file_time_iso] is a text field in the standard iso format '[yyyy-mm-tt]' & 'T' & '[hh-mm-ss]'. A search compares character for character from left to right. So a search like between '2*' and '2000-01-13*' will find the files in the first 2 weeks of 2000. In T9 yon can compare direct, in T7 you had to use the function ^udate([yyyy-mm-tt]. The change in T9 makes the search easier IMHO.

9

ThumbsPlus v7-v9 Questions / Database Conversion Thumbsplus 7 to 9: Store thumbnails in F

« on: 2014-12-05 20:48:38 »

I converted the T+-dtabase from T7 (MS-Access-format) to T9 with the option "store thumbnails in files". I hoped to shrink the database size (nearly 1,8 GB in T7 with 37600 thumbnails near the 2 GB-limit of MS-Access)).
Instead of this hope: the databe in T9 (.tpdb8) wwas LARGER then before (2 GB). I openend the databse in MS-Access and found an OLE-Field "Thumbnail" in the "Thumbnail"-Table. I exported the table to a new Test-Database, deleted the field from the tabel and comperssd the database. Result: this OLE-Field needs about 1,2 GB space, more than 60% percent of the total database!
So obviously the thumbnails are stored in the database AND in the several subfolders of "tpdb_files". So the procedure makes no sense for me:-(
Now i can try the follwing: running a python script as in the tipps and tricks section ( http://forums.cerious.com/forum/index.php?mode=thread&id=484 ) or make the import a second time and then the python script. Anny tipp or help?