Messages

1

ThumbsPlus v7-v9 Questions / SQL

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

2

ThumbsPlus v7-v9 Questions / SQL

« on: 2015-02-18 07:20:34 »

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

3

ThumbsPlus v7-v9 Questions / ADO code found in old newsgroups

« on: 2014-10-30 03:46:58 »

I can save a thumbnail into the DB as a JPEG and retrieve it OK. The problem is retrieving the ones that T+ has made.

4

ThumbsPlus v7-v9 Questions / Displaying Thumbnails in browser.

« on: 2014-10-29 14:19:54 »

It seems that whatever I try I can't get the thumbnails to display. The BLOB does not appear to be a raw JPEG. If I change the database format and select to store the thumbnails in files then they do get saved as JPEGS. However I can't see any way of identifying the path to the external file, there must be a way. This is a show stopper, if I can't find a solution to it then I'll have to abandon using T+ for my local school. I seem to remember there used to be a Web Client product that allowed access to the images. Can't find it now though.

5

ThumbsPlus v7-v9 Questions / Displaying Thumbnails in browser.

« on: 2014-10-29 03:27:47 »

Please Daan. I'll try without decoding too.

6

ThumbsPlus v7-v9 Questions / Displaying Thumbnails in browser.

« on: 2014-10-28 20:13:34 »

I'm trying to display the embedded thumbnail in a browser. The thumbnails are being stored as JPEG (Lossy). I'm using the PHP code:-

print ' ';

... however this doesn't worked and I'm stumped as to how to proceed. Does anyone have any ideas?

7

ThumbsPlus v7-v9 Questions / Thumbnail Types

« on: 2014-10-23 03:38:26 »

Thanks Daan

8

ThumbsPlus v7-v9 Questions / Thumbnail Types

« on: 2014-10-22 02:49:34 »

I don't want to have to run an export all the time so that's not a goer. I would like to make the script portable so anyone here can use it so I need to handle the thumbnail differently whether it's a tiff or a jpeg which is why I ask. Guess if I create a test DB I can see how those settings affect the values.

9

ThumbsPlus v7-v9 Questions / Thumbnail Types

« on: 2014-10-21 04:52:01 »

I'm working on a project that allows me to put up a simple browser view of images that are managed by T+. In order to make sure I am able to display the thumbnail I need to understand how the thumbnail is stored as a BLOB.

In the T+ database the thumbnail type size etc is stored in a table called ThumbsPlusDatabase. There are 4 entries I would welcome help on:-

thumbnail_type
thumbnail_compress
alias
volume_match

Can anyone help?

Charlie

10

ThumbsPlus v7-v9 Questions / ODBC for EXternal Access

« on: 2014-10-21 04:04:34 »

Daan

is there any way of formatting code on this board

11

ThumbsPlus v7-v9 Questions / ODBC for EXternal Access

« on: 2014-10-20 10:33:12 »

OK I've abandoned ODBC in favour of a DSNless connection it seems much easier. Here's some PHP code that establishes a PDO object:-

-------------------------------------------------------

    $strDBPath = 'path to db file';
    // Remember: escape the backslashes & include trailing backslash eg: c:\\T+DBFiles\\
    $strDBName = 'name of db file';
    // Just the name of the database eg: ThumbsPlus.tpdb8
    $strFullName = $strDBPath . $strDBName;
    if (!file_exists($strFullName)) {
        die("Could not find database file.");
    }
    $strCon =
        'odbc:Driver={Microsoft Access Driver (*.mdb)};' .
        'Dbq=' . $strFullName;
    $objThumbs = new PDO($strCon);
?>

-------------------------------------------------------

Sorry it looks kludgy but there's no code mark-up on this board. I'll post the whole project once it's finished.

NOTE: you need to have the access driver installed on your machine. If you have MS Office then you may well have this already. Otherwise get it [link=http://www.microsoft.com/en-us/download/details.aspx?id=13255]here[/link].

12

ThumbsPlus v7-v9 Questions / ODBC for EXternal Access

« on: 2014-10-17 12:41:21 »

Thanks Daan

All very helpful. I do some more investigations and post the results. I do have access as it happens although I never use it but we have the MS Action Pack I tend to keep it installed. I shall in fact be using PHP. I will also post the code once it's up and running, not that it will be beautiful just functional!!

Charlie

13

ThumbsPlus v7-v9 Questions / ODBC for EXternal Access

« on: 2014-10-17 02:50:28 »

Thanks for the speedy response. I have run c:\Windows\SysWOW64\odbcad32.exe but there is no specific reference to T+ MS:-



When I try and check the top two I get errors:-



The bottom one is used by Sophos.

14

ThumbsPlus v7-v9 Questions / ODBC for EXternal Access

« on: 2014-10-16 10:17:47 »

I want to make use of the T+ data file in order to create a simple interactive web page to search by keyword and display thumbnails and embed the path to the original image in a link.

I have T+ installed and running on our server which also IIS. The T+ data file is on the server too. I can't see any existing T+ ODBC set up on the server, do I have to create a new ODBC connection or is there an exsiting one I can locate and use?

15

ThumbsPlus v7-v9 Questions / Thumbnail Size

« on: 2014-03-27 05:11:20 »

The % setting controls the amount of space T+ allocates for the thumbnail and anything else you elect to display. It does not control the size of the thumbnail. See my previous post for that.