Project

General

Profile

I have faced the situation when i needed to use all that tags i choosen for my files shot long before the age of my using dt

What i'm used to in my workflow is:

1. cp /mnt/myCFcard/path/to/CR2_files /my_photo_storage_tmp

2. cd /my_photo_storage_tmp

3. mkdir -p {all my subject hierachy like: mountain,cape,aya,outskirts,arch,people,e.t.c.}
after what i have a tree like:

   arch
   arch/door
   arch/window
   concept
   flora
   flora/berries
   flora/berries/rosehip
   flora/berries/yellow_berries
   flora/cones
   flora/flowers
   flora/flowers/chrysanthemum
   flora/inktree
   flora/ivy
   flora/moss
   flora/platan
   flora/vineyard
   landscape
   misc
   misc/wine_degustation
   moon
   people
   sea
   sea/seascape
   sea/waves
   sky
   sky/clouds
   sky/clouds/.qiv-select
   sky/evening
   sky/golden_light
   sky/morning
   sky/rainbow
   sky/sunset
   texture
   texture/bark
   texture/bark/cypres
   texture/bark/oak
   texture/bark/pine
   texture/oak.barkless
   texture/stone
   texture/water
   texture/water_drops

4. move files to the relevant directories according the subject

Please, remember to exit dt first and to BACKUP your db BEFORE sql injection, from here you are on your own !!!

What i needed to transfer my scheme to dt db was:

1. prepare the tag file:

2. cd desired_directory_to_process

3. find . -type f -name "*.CR2" -print > tag-file.txt

it looks like:

     ./concept/IMG_8579.CR2
     ./concept/IMG_8580.CR2
     ./flora/berries/black_berries/IMG_7287.CR2
     ./flora/berries/black_berries/IMG_7288.CR2
     ./flora/berries/kizil/IMG_8077.CR2
     ./flora/berries/kizil/IMG_8078.CR2
     ./flora/berries/kizil/IMG_8079.CR2
     ./flora/berries/kizil/IMG_8080.CR2
     ./flora/berries/red_berries_01/IMG_7269.CR2
     ./flora/berries/red_berries_01/IMG_7270.CR2
     ./flora/berries/red_berries_01/IMG_7271.CR2

4. edit tag-file.txt to make it look like:
     IMG_8579.CR2;concept
     IMG_8580.CR2;concept
     IMG_7287.CR2;flora,berries,black_berries
     IMG_7288.CR2;flora,berries,black_berries
     IMG_8077.CR2;flora,berries,kizil
     IMG_8080.CR2;flora,berries,kizil
     IMG_7270.CR2;flora,berries,red_berries_01
     IMG_7271.CR2;flora,berries,red_berries_01

5. to generate sql injection with attached bellow shots-tag.pl script (it contains POD or run it with --help)

6. to inject it to db

please, remember to exit dt first and to BACKUP your db BEFORE sql injection, from here you are on your own !!!

p.5 and p.6 can be combined to

shots-tag.pl -r vac.200905 -t vac.200905.tags | sqlite3 ~/.config/darktable/library.db

all this worked for me, do it on you own risk ;)

Also available in: PDF HTML TXT

Go to top