Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - hockeyrink

Pages: [1]
1
I've successfully connected TB10 to my SQL Server 2017, and it creates the data, but how can I access the data outside of TB10?

I'm doing some website-to-image reconciliations, and having the TB database available natively via an system-level ODBC connector is great (having imported copies of it previously), but having access to the latest "LIVE" data would be great. I created the table using the "Thumbs9_mssql.sql" script and successfully connected TB10 to it.

I can see the database show up in my MS SQL Server Management studio, I can expand it to see the table names, but I CANNOT expand any table to show data. All queries come back as "successful", but with zero rows! I've tried other ODBC clients too, with no success. The "Properties / Permissions" tab doesn't show anything weird, and they're the same as the other 2 databases I have running on the server at the same time (one being the imported TB database, the other the webserver database). The only think I can think of is I must be missing some sort of username permission?

The only sure-fire way to access the data is through TB10 application. Why can't I connect to this dataset via ODBC with any other client?

edit: I did find mention of the alias for dbo called "ThumbsUser" in the guide7.pdf. No luck. Plus, couldn't find reference to that in the setup sql script. Checked the "Security\Users\dbo" properties, and they match the same properties I use in the other 2 databases..

edit2: Found that I *could* open the "ThumbsPlusDatabase" table... whichk reports exacty 0 thumbnail _files. BUH?!? TB10 says (under "Thumbnail Database Statistics" there are over 141,585 Thumbnail records. Somehow, these seem to be looking at two different databases? Using the same 32-bit system ODBC connector settings? Weird. The digging continues...

edit3: FOUND IT. I must have done something wrong during configuration, as it dumped all the TB10 tables under the MASTER database. Grrr. Ok, now how to fix it without having to regen 3 hours of indexing.  >:(


2
I have a website, and many of the images are low-res. My hi-res imagery on the server has some issues where the website product image ("img1234.jpg") should have been "img1234-SKU.jpg", but ISN'T.

So when I did a search for the largest version of "img1234.jpg" from my webserver, it often got it wrong, finding a different version of "img1234.jpg".

I'd like to know if the image similarity feature could work this out for me. Like:
  • FIND the website's image name & similarity metric
  • COMPARE it to all other images of the same name, then
  • SORT by metric, THEN by filesize.

Is this possible in a TB database, or am I gonna have to build an ugly BASH script using imagemagik?  :-[

3
I LOVE the SQL query feature in TP10. My question is how can I edit the SQL query saved in the "Found Files" gallery so I can manipulate the string / source directory? I think I must be missing something obvious.

Perhaps this is more of a feature request. I'd like to be able to specify my "Restrict search to:" selection to a manually entered location.

Now that I've looked for 15 minutes, typed in my question to the forum, I'm SURE to figure this out 30 seconds after posting my question... :o
(Yeah. Kludge fix is to just copy the SQL from the old saved "Found Files" to a new one)

4
Making jump from V7 to v8, and for some stupid (user) reason, I can't double-click or ctrl-enter an thumbnail to have it display in large view. I'm searching through settings, but can't seem to locate where/what I did wrong to disable this functionality.

Please, can somebody point a finger to the right menu for me?

Thx,
Dave

Pages: [1]