[Bug 293297] New: Digitaglinktree does not process any photos even if tags exists under People category

https://bugs.kde.org/show_bug.cgi?id=293297

           Summary: Digitaglinktree does not process any photos even if
                    tags exists under People category
           Product: digikam
           Version: 2.1.1
          Platform: Ubuntu Packages
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Export
        AssignedTo: [hidden email]
        ReportedBy: [hidden email]


Version:           2.1.1 (using KDE 4.7.4)
OS:                Linux

I have tagged a lot of people under people category.

If I select the "tags" table
********************************************
select * from tags where pid="9" or  id="9"
********************************************
"id", "pid", "name", "icon", "iconkde"
"9", "0", "People", "0", ""
"10", "9", "Unknown", "0", ""
"25", "9", "cyril", "0", ""
"26", "9", "irene", "0", ""
"27", "9", "amelie", "0", ""
"28", "9", "liam", "0", ""
"29", "9", "theo", "0", ""

Tagtree table shows
************************************************
select * from tagstree where pid="9" or  id="9"
************************************************
"id", "pid"
"9", "0"
"10", "9"
"27", "9"
"25", "9"
"26", "9"
"28", "9"
"29", "9"

If I take one of the tags I can find associated images
****************************************
select * from imagetags where tagid="29"
****************************************
"imageid", "tagid"
"12018", "29"
"12020", "29"

When I lauch the script
****************************************************
digitaglinktree -l my_target -d my_digikam_directory
****************************************************
Processed 0 photos.



Reproducible: Always

Steps to Reproduce:
Every time I launch the script

Actual Results:  
Processed 0 photos

Expected Results:  
complete tree for People category tags

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=293297





--- Comment #1 from  <cyril raphanel gmail com>  2012-02-04 14:34:18 ---
Script version
Version: 1.7.0

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=293297





--- Comment #2 from  <cyril raphanel gmail com>  2012-02-05 12:21:50 ---
What language is written digitaglinktree?

Where could I find the source code without installing the whole digikam source
package?

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=293297


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]




--- Comment #3 from Gilles Caulier <caulier gilles gmail com>  2012-02-05 12:23:39 ---
It's a stand alone script :

https://projects.kde.org/projects/extragear/graphics/digikam/repository/revisions/master/show/utilities/scripts/digitaglinktree

Gilles Caulier

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=293297





--- Comment #4 from  <cyril raphanel gmail com>  2012-02-05 12:57:48 ---
Thanks,

old perl script (last version is 2008) so probably not fully compatible with
current sql schema.

Is there an alternative from the user interface (kipi export plugin?) that
would fo the same?

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=293297





--- Comment #5 from Gilles Caulier <caulier gilles gmail com>  2012-02-05 13:20:36 ---
No alternative. script must be adapted...

Gilles Caulier

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=293297





--- Comment #6 from  <cyril raphanel gmail com>  2012-02-05 14:27:00 ---
Now I get stuck in my investigation

Problem seems around this part, it systematically skip all files

###############################################################################
    # $refImages always contains all images from all albums. For Mode -A
    # in digikam 0.10 it may happen that some albums are not on the same
filesystem
    # like the photoRoot. in this case this album is not cloned to another
    # directory buth neverless
    # refImages contains also data about photos in this album. But since it is
    # not cloned, the cloned root # does not exits and so the photo therin does
    # not exist. Thats what we check here.
        # CR
    print "BEFORE -- ${photoRootDir}$path/$image\n";
    print "PHOTOROOTDIR -- ${photoRootDir}\n";
    print "PATH -- $path\n";
    print "image -- $image\n";
    # RC
    next if( ! -r "${photoRootDir}$path/$image" );
        # CR
    print "AFTER -- ${photoRootDir}$path/$image\n";
    # RC
    $count++;
###############################################################################

I can see "BEFORE" log
##############################################
BEFORE -- /photos/thumb/canond30_IMG_1041.jpg
PHOTOROOTDIR -- /photos
PATH -- /thumb
image -- canond30_IMG_1041.jpg
##############################################

but never reach the "AFTER" log

I would need some help from a PERL Guru ....

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=293297





--- Comment #7 from  <cyril raphanel gmail com>  2012-02-05 14:34:10 ---
Somehow make sense as "photoRootDir" is not the correct full path here. So if
the script check if the file exist it never find it ...

Need to figure out how the "photoRootDir" is compiled/read

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=293297





--- Comment #8 from  <cyril raphanel gmail com>  2012-02-05 14:52:31 ---
Is my database data correct?

***************************
select * from  albumroots;
***************************
"id", "label", "status", "type", "identifier", "specificPath"
"1", "photos", "0", "1", "volumeid:?uuid=560e6bbb-a2ae-498f-a335-4a8592005e47",
"/photos"

Should "specificPath" contains the exact album path?

My "photos" directory is not under root file system but under an hardrive
mounted under "/media/disk1".

Correct complete path of my root for album is "/media/disk1/photos" and not
"/photos".

Is it now:
- a bug in digkam data management?
- a bug in the script?
- a configuration setting I should do in digikam?

Thanks

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=293297





--- Comment #9 from  <cyril raphanel gmail com>  2012-02-05 15:00:28 ---
I have edited manually the "specificPath" to the real album path
"/media/disk1/photos".

Script is now working perfectly but is it consistent for digikam data model?

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=293297





--- Comment #10 from  <cyril raphanel gmail com>  2012-02-05 17:07:15 ---
I originally add the directory as "Local collections" would it make any
difference for the "SpecificPath" attribute if I had the directory with
"Removable Media" or "Networkd shares"?

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=293297





--- Comment #11 from  <cyril raphanel gmail com>  2012-02-05 19:06:59 ---
Reading some related bug
https://bugs.kde.org/show_bug.cgi?id=236730

could it be that simple that the script should include "identifier" information
to define the complete path?

how do you do that in perl/bash script?

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=293297





--- Comment #12 from  <cyril raphanel gmail com>  2012-02-05 19:19:48 ---
uuid is the one of the hardrive I have my collection
/dev/sdb: LABEL="disk1" UUID="560e6bbb-a2ae-498f-a335-4a8592005e47" TYPE="ext4"

I mount it on "/media/disk1" directory ...

Is there a smarter way to make so it is understood by digikam and the script?

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=293297





--- Comment #13 from  <cyril raphanel gmail com>  2012-02-06 19:04:32 ---
Created an attachment (id=68572)
 --> (http://bugs.kde.org/attachment.cgi?id=68572)
-r option enable again for digikam version > .10.

Following lines commented
    # Now Process all albums found
    # if( defined($opt_r) ){
    #   warn "\n$0: Hint: Album root definitions given by \"-r\" ignored \n",
    #        "for digikam version >= 0.10 . Instead all Albums defined in
digikams \n",
    #        "database are used. Continuing work ... \n\n";
    #}


Following lines added
      # NEW CODE
      # Interprete -r as base for all albums
      $albumRoots{$i}="$opt_r$albumRoots{$i}";
      # END NEW CODE

This has been tested with
digitaglinktree -l target_directory -d digikam_database -r
directory_where_partition_including_albums_is_attached

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=293297


[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|                            |FIXED




--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=293297





--- Comment #14 from  <cyril raphanel gmail com>  2012-02-06 19:30:21 ---
Might need more testing and a bit of documentation.

Potential improvement:
Add "date" parameter which would add time directory below each tag
People->paul->2001->image1.jpg
            ->2002->image2.jpg

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=293297


[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |UNCONFIRMED
         Resolution|FIXED                       |




--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=293297


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Digitaglinktree does not    |Digitaglinktree does not
                   |process any photos even if  |process any photos even if
                   |tags exists under People    |tags exists under People
                   |category                    |category [patch]




--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=293297





--- Comment #15 from  <cyril raphanel gmail com>  2012-02-07 16:34:37 ---
Created an attachment (id=68595)
 --> (http://bugs.kde.org/attachment.cgi?id=68595)
New Version 1.8.0 - proposal for patch

# 1.7.0 -> 1.8.0 2012/02/07 Cyril Raphanel, [hidden email]
# Added (-r) option for new digikam database as root directory for a set of
albums below same file system
# Added (-Y) option to add "year" directory below each tag

Tested with
  -l <tagdir>  path to directory where the tag directory structure with
               links to the original images should be created
  -d <dbfile>  full path to the digikam database file
  -r <rootdir> path to digikams root directory containing all photos.
               For digikam vers >= 0.10 root directory of a set of albums,
               Script has to be used as many time as there is different root
                   directories.
               Mandatory for earlier digikam versions!
  -Y           Add Year directory below each tag directory
  -h           Print this help
  -v           Print scripts version number
Using Digikam 2.1.1

Not tested with
  -A <ardir>   Create selfcontained archive of photos and tags in directory
               ardir. rootdir and arDir have to be on the *same* filesystem!
  -C           If -A <archdir> was given this option will put hardlinks of all
               photos in the "Photos" directory not only of those with tags.
  -a           Create absolute symbolic links instead of relative ones
  -H           Use hard links instead of symbolic links in linktree.
  -f           If there are hierarchical tags (tags that have subtags)
               create a flat tag directory hierarchy. So directories for
               subtags are at the same directory level like their parent tags

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=293297


[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Digitaglinktree does not    |Digitaglinktree does not
                   |process any photos even if  |process any photos even if
                   |tags exists under People    |tags exists under People
                   |category [patch]            |category + new option for
                   |                            |year subdirectory [patch]




--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel