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.


Messages - David Dyer-Bennet

Pages: [1] 2
1
Lightroom is now also a factor; can't really use Thumbs Plus with Lightroom since the Lightroom changes to metadata prefer going to XMP files, and must go there for some file formats.  Yeah, one could just ignore Thumbs Plus and use Lightroom as the main index also, but I don't want to do that, it's not nearly as good as TP -- except for this minor issue that TP won't find the metadata in more and more of my photos.  Making TP more and more nearly useless....

2
ThumbsPlus v10 Questions / Database conversion
« on: 2016-10-17 02:28:25 »
I let it run for a long time and it finally reached a "system resources exhausted" error; it apparently can't cope with a Thumbnail table the size of mine.

3
ThumbsPlus v10 Questions / Database conversion
« on: 2016-10-17 02:02:19 »
MDB viewer plus appears to hang whenever I try to touch the Thumbnail table (including in an SQL query), or just click on that tab, so that's not working out.

4
ThumbsPlus v10 Questions / Database conversion
« on: 2016-10-17 01:25:43 »
.mdb is older access, 2003 and earlier; is .tpdb8 that, and not the later .accdb (Access 2007)?  I was having failures earlier tonight using Libre Office database functions to read it (actually, to read a much smaller test db I created, indexing just one directory of photos), and this might explain it.

I'll also try the reader product you suggest.

I've done things with text exports before, and yeah, in fact it screwed up a bunch of my keywords back then.  However, text export and then parsing it carefully might be another way for me to get the data that may be lost in a reindexing.

5
ThumbsPlus v10 Questions / Database conversion
« on: 2016-10-16 20:50:06 »
I've got an existing Thumbs.tpdb8 file of 1.762 GB (limit is 2GB, right?); so I'm not out of space yet but I'm getting worried.  

I believe I have quite a few keywords in the db that aren't embedded in the original files -- I think that's what I ended up with when keywording RAW formats that TP doesn't know how to modify for example.  So I can't just trash my database, create a new one, and let it do a massive reindex.  There might I suppose also be other data not embedded in the files, I can't prove otherwise.

Is there any other way to convert to SQlite?

Alternatively, is there a way to check whether in fact the database reflects only file data?  Or is there a way to extract from the database a list of keywords at least that *aren't* also embedded in the files?  

As a desperation move I suppose I could export a complete set of keyword / image file pairs, rebuild the database, and then add back all those pairs (which would be a waste of time for the ones already found in the image files, but would fill in the missing ones. I suspect it would take a while, too.  Also not completely sure how I could export such a list, I don't have Access.

Any other ideas?  Is there  a free DB tool, or a Perl or Python library, or something, that will read the .tpdb8 file format (I think that's a version of Access, but whatever it really is)?

6
I seem to remember this being inconsistently troublesome forever.  Maybe it's me.

Anyway, right now, NEFs shot vertically (with my Nikon D700) are oriented wrong when thumbnails are made of them in TP 9 SP2 B3 (build 3943).  

I have the Digicam Raw plug-in options set to NOT rotate based on EXIF (bottom checkbox in the General tab), and TP 9 Preferences / Metadata / Rotate based on XMP/EXIF orientation is checked.  This seems to be the recommended settings from the release notes.

7
ThumbsPlus v7-v9 Questions / Question about search/find
« on: 2014-11-04 16:33:56 »
I think you need both, actually.  Something like:

    SELECT * FROM table WHERE Column LIKE "%test%";

(That's the underlying bit of SQL needed).  Not sure how to get from the search form to that, but I believe you can resort to writing raw SQL if you need to.)

8
General Discussion / A few more clues?
« on: 2014-11-03 15:11:21 »
I believe so -- things like ThumbsPlus/Python/Lib/thmpls/facebook.py for example, and the whole facebook subdirectory there (also there's a flickr subdirectory there with .py files).  I think I've got lots of examples of their code, at least.

9
General Discussion / Running python itself
« on: 2014-11-03 15:03:25 »
Yep, quite right.  One step higher up the tree than I ran my search from :-(.  I greatly appreciate your help, perhaps especially when it consists of pointing out where I've screwed up.

So, that strongly suggests the Python distribution is complete and workable after all, which is more elegant.  I share your intuition that with the right setup of various environment variables the Python distribution will work just fine.

(While I'm typing, I'll say I've finished my quick review of Python; there'll be lots to learn in practice, but I've at least seen the bones of the rules.  I haven't programmed in Python beyond minor play before, but I've programmed Perl and Bash pretty seriously and all sorts of compiled languages over 45 years, so I'm not really worried about "one more" language.)

10
General Discussion / A few more clues?
« on: 2014-11-02 12:26:27 »
There are references to tpuser.py in mkcmddefs.py, tpcmd.py, and tpui.py -- but no actual tpuser.py file is present.  And the references are only in comments; this kind of suggests that the code to use tpuser.py isn't present.  So this is probably not going to lead anywhere.

However, the files defining the official TP commands that are in Python may well be illuminating.

11
General Discussion / Running a python script
« on: 2014-11-01 17:40:17 »
Okay, that entry box at the left of the Python window seems to be input to an actual Python interpreter.  If you enter
    print "Hello, world!"
there, it prints "Hello, world!" in the space below for example.  You don't actually have to click the "run" button, hitting enter suffices.

You can also set variables there and such; presumably any valid Python but I haven't tested extensively.  

So, what it doesn't actually do is provide a way to run a script.  I guess it can call functions that are defined, though.  And there are probably library ways to do something equivalent to Perl / shell "eval", eh?  You can probably import a library from there; yeah, "import invalid" gives an error indicating it tried to import and couldn't find a module named "invalid", so that looks hopeful.

It's not as simple as just being the same as an interactive Python interpreter, though; you can't type arithmetic expressions and have the result printed out, for example.

12
General Discussion / Running python itself
« on: 2014-11-01 17:14:48 »
Thumbs Plus seems to contain a full Python installation, with extra TP goodness packaged in;  on my Windows 7 system I have C:\Program Files (x86)\ThumbsPlus9\Python, and in that file python.exe and pythonw.exe and the LICENSE.txt, NEWS.txt, and README.txt files that I believe a normal Python install has.  Plus the subdirectories with various things in them.

But, when I run (locally, or via PATH) python.exe from there, I get "The program can't start because python27.dll is missing from your computer."  And, looking through those directories, there is in fact no python27.dll. (What I tried precisely is, from  a Windows command window, "python.exe --version".  It clearly found python.exe, but couldn't go much beyond that.)  

I do see C:\Program Files (x86)\ThumbsPlus9\Python\libs\python27.lib and also libpython27.a, which suggests that maybe the Python in Thumbs Plus is statically linked rather than built as a DLL, which seems weird off the top of my head but I've never done a Python embedding so I don't know what the issues are.  So, in that case, the appearance of having a Python distribution present isn't real, maybe?  (And those exe files that look so tempting but can't work under that theory shouldn't be there, then; save space in the installer and on my system, avoid a source of confusion, etc.)

I can of course install another Python installation and do my initial testing on that (I was hoping to use the TP one to avoid having possibly different versions for when I ran something within TP and when I ran standalone).  And soon I'll probably (I hope) be tied into TP internals and thus unable to run my scripts anywhere else.  This may not make much difference.

But at the moment it looks weird, like an anomaly, and I hate leaving anomalies I don't understand behind me as I dive into things; too often they prove I really don't understand them by biting me in the ass later.  

I don't imagine anybody but some of the actual developers can actually *answer* this, and it's probably not important to that many people anyway.  But just in case, and to document what I'm doing, I'm posting it.

13
General Discussion / Running a python script
« on: 2014-11-01 15:24:28 »
Well, let's see how far we can get.  Maybe we can get a pointer now and then if we're actually stuck.  

Yeah, indicating particular images (one or more) (or directories) as info passed to a script is important (right-click, keyboard shortcut, menu, toolbar, or whatever), we'll certainly want that in the long run.  

I'm kind of guessing that the work for a good clean interface for that stuff is only partly done, or something (and as you say has been taking a lower priority than other things; there's a LOT of stuff that would be desirable to do, I'm not sure how I'd prioritize it myself if I had the full list in front of me.  And there's a rumor that not everybody completely agrees with me on what's important :-).  

I had a bunch of Perl scripts (still have them) for moving stuff from TP to my web gallery, and replacing images when I updated them and such, that I could run from the toolbars.  Worst case, maybe we can hook things up that way temporarily.

We'll see how much time I have, might have time and energy to get somewhere on this for a few weeks now.

14
General Discussion / Running a python script
« on: 2014-11-01 15:18:41 »
Okay, I'm apparently not paying attention.  I knew that existed, but didn't think of it as a way to start a script.  Clearly it can be, thanks for pointing it out!  

That's sufficient for early playing around, debugging, and even quite a lot of use (having to type the name each time or even navigate the drop-down is inconvenient relative to menu or toolbar for some kinds of things, but it's a useful start).

I'm somewhat familiar with Python and very familiar with programming and scripting languages (45 years making my living writing computer software), and as I said the examples of Python scripts that are part of Thumbs Plus should give me some examples of how to access various things I'll want access to (like the database, in particular).  So we'll see what of the things on my list I can actually accomplish.

15
General Discussion / Running a python script
« on: 2014-10-31 17:23:42 »
Does anybody have the faintest idea how to run a Python script?  I've found the directory the ones supplied with TP are in, which gives me some hints about what libraries to access to do various things, but I don't have the faintest idea how to invoke a Python script from within Thumbs Plus.  

This seems like the most basic thing to document -- with this, we can get started experimenting, but without this, we're groping completely in the dark to do anything at all.

Pages: [1] 2