> On 5 Jun 2016, at 09:12, Roman Lebedev <[email protected]> wrote: > > On Sun, Jun 5, 2016 at 10:46 AM, Michael Hendry > <[email protected]> wrote: >>> On 4 Jun 2016, at 18:49, Frank J. <[email protected]> wrote: >>> >>> Am 04.06.2016 um 18:16 schrieb Michael Hendry: >>> .. >>>> I had downloaded a simpler script when first looking at making the >>>> transfer, and it crashed when there was a hierarchical tag involved. I >>>> think it was written by Antoine Beaupré. >>> >>> That was my start-point. >>> Look at line 6 of my script: >>> >>> # Based on an idea of Antoine Beaupre >>> http://redmine.darktable.org/issues/9461 >>> >>> I think I made it a bit more comfortable. >>> >>> >>>> You’re probably right, but I have found that darktable can handle a >>> hierarchical tag and a simple tag at the same time. >>> >>> Yes, sure it can handle multiple *different* tags. >>> Klick on first tag *OR* second tag finds the same picture. >>> >>> But importing the hierarchy from Shotwell means same tags, not different >>> tags. >>> >>> Example: >>> >>> Shotwell seems to search with "equal". >>> Tags are: >>> "/persons" >>> + "/persons/friends" >>> + "/persons/friends/John Do" >>> >>> Klick on "friends" searches: WHERE tags = '/persons/friends' >>> >>> Darktable seems to search with SQL-"like". >>> Tag is "persons|friends|John Do". >>> Klick on "friends" searches: WHERE tags LIKE '/persons/friends%'. >>> The Wildcard % includes "John Do". >>> >>> Wrong import: >>> "|persons" >>> + "|persons|friends" >>> + "|persons|friends|John Do" >>> >>> The SQL-LIKE-Search find more then one Tag pointing to the same set of >>> pictures. You have to use "SELECT DISTINCT .." to get every picture only >>> once. >>> >>> >>>> ... try to find anomalies in the tags. >>> >>> Ideas: >>> >>> - Do Ubuntu and Mac have the same coding (UTF-8)? >>> In Germany we have some special Characters (ä,ö,ü,ß) that can cause >>> some trouble. In Scandinavia they have some characters that I cant find >>> on my keyboard. When transferring the SQL-file (txt) from one system to >>> another you may use "save as ... UTF-8" in your editor. >>> Sometimes that is a problem when copying files from Windows (ANSI) to >>> Linux (UTF-8). Sometimes it is no Problem with characters like >>> a-z,A-Z,0-9 but often with special/national characters. >>> >>> - Do you have characters in the tag, that are used in SQL: % ; ' " \ >>> Darktable may handle this when typing it in the screen. >>> But you put it directly into the database. >>> >>> >>>> .. are you using darktable on a Mac now, or have you simple transferred >>>> from Shotwell to darktable in a Ubuntu environment? >>> >>> My System is Ubuntu 14.04 LTS (waiting for Upgrade to 16.04 LTS). >>> Shotwell and Darktable in the same environment. >>> >>> >>>> Regards, >>>> >>>> Michael >>> >>> >>> >>> Frank >> >> Thanks, Frank. >> >> You’ve given me a lot to worry about! >> >> Today I decided to rename dt’s library.db, and start the import all over >> again. >> >> I started recursively with the directory that holds all my Shotwell files, >> and the process crashed. >> >> After deleting the new library.db, I started again in a directory which I >> knew held files tagged “Portugal 1971”, because attempting to open all files >> with this tag had crashed dt in the past. This directory holds scanned >> images from black-and-white negative film taken in 1971 and scanned using a >> Nikon Coolscan IV. >> >> This crashed dt immediately. >> >> Inspecting the directory, I found a lot of “.nef” files, which are the raw >> files produced by the Nikon scanning program. A quick find, grep and wc -l >> reveals that I have 179 files of this type. >> >> I’ve tried importing a single image with the .nef extension, and this causes >> dt to crash. > Backtrace? > >> I’ve now checked the list of supported cameras, and the Coolscan isn’t there >> - I’ve put a comment here >> >> https://www.darktable.org/resources/camera-support/comment-page-1/#comment-49673 > Comment is not a bugreport. > https://redmine.darktable.org/projects/darktable/issues/new or did not happen. > (make sure it is not already reported, do provide all the necessary > sample files)
Working on it, but having problems getting a single example file across - the progress bar stalls at just over 50%, on an 11.9 MB file. Would a link to a Dropbox file be acceptable? Michael > >> Michael > Roman. > >> ____________________________________________________________________________ >> darktable user mailing list >> to unsubscribe send a mail to [email protected] ____________________________________________________________________________ darktable user mailing list to unsubscribe send a mail to [email protected]
