Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db

  Thread Rating:
  • 2 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Closed
pedr0 Offline
Junior Member
Posts: 23
Joined: Feb 2011
Reputation: 0
Post: #331
Hi,

I'm having problems getting the scan to work (0 images found). I'm on XBMCbuntu Eden. Please could you tell me how to delete the database so I can start again.

Thanks.
find
Xycl Offline
Senior Member
Posts: 248
Joined: Feb 2012
Reputation: 6
Location: Germany
Post: #332
(2012-04-15 14:43)pedr0 Wrote:  Hi,

I'm having problems getting the scan to work (0 images found). I'm on XBMCbuntu Eden. Please could you tell me how to delete the database so I can start again.

Thanks.

The Database is in directory $HOME/.xbmc/userdata/Database and has the name MyPictures.db

Main page: https://github.com/Xycl
Repository: Xycl Repository
How to submit a log file: XBMC-Wiki
find
pedr0 Offline
Junior Member
Posts: 23
Joined: Feb 2011
Reputation: 0
Post: #333
(2012-04-15 16:41)Xycl Wrote:  The Database is in directory $HOME/.xbmc/userdata/Database and has the name MyPictures.db

Thanks.

I've been having trouble getting MyPicsDB to recognise my jpg files on an NFS network drive. But I've just re-read the op. Is it still the case that I need to mount network drives to a mount point (i.e. not just use the NFS in the Eden file browser list)?
find
Xycl Offline
Senior Member
Posts: 248
Joined: Feb 2012
Reputation: 6
Location: Germany
Post: #334
(2012-04-16 00:26)pedr0 Wrote:  I've been having trouble getting MyPicsDB to recognise my jpg files on an NFS network drive. But I've just re-read the op. Is it still the case that I need to mount network drives to a mount point (i.e. not just use the NFS in the Eden file browser list)?

You cannot connect to a network share from python because python uses the normal file functions.
E.g. you cannot
PHP Code:
ls nfs://ip-address/directory 
Therefore you must mount the share

2nd hint:
Don't use multipath sources!

Main page: https://github.com/Xycl
Repository: Xycl Repository
How to submit a log file: XBMC-Wiki
find
mgmartin Offline
Junior Member
Posts: 4
Joined: Mar 2012
Reputation: 0
Post: #335
(2012-04-10 11:34)Xycl Wrote:  [quote='mgmartin' pid='1070337' dateline='1333954155']
Still seems to have issues under Linux.
I have to trap exceptcions in the picentry={...stat...} code to successfully scan the folders.

Which directory permission is missing x or r?
I need it to know in order to test the plugin within a vmware linux.

The directory does not have "x".
find
Xycl Offline
Senior Member
Posts: 248
Joined: Feb 2012
Reputation: 6
Location: Germany
Exclamation  New repo location! Post: #336
Repos changed their location!

Link to repository: repository.xycl.abandoned.dharma
Direct link to MyPicsDB: MyPicsDb version 0.6.7

Main page: https://github.com/Xycl
Repository: Xycl Repository
How to submit a log file: XBMC-Wiki
find
Xycl Offline
Senior Member
Posts: 248
Joined: Feb 2012
Reputation: 6
Location: Germany
Post: #337
Version 0.6.8 released.
Update: Browse by Tags menu. This shows you all stored tags in a submenu like Persons, Keywords etc. From there you can select the desired content of the tags.
Hint: The menu uses 3 new tables which are not filled! In order to rescan your pictures without modifying them you must remove the source directory and readd it.


Edit: Please give feedback about performance and desired but still missing tags. E.g. from XMP only the person tag is imported.

Main page: https://github.com/Xycl
Repository: Xycl Repository
How to submit a log file: XBMC-Wiki
(This post was last modified: 2012-04-25 10:32 by Xycl.)
find
fungify Offline
Senior Member
Posts: 137
Joined: Jul 2010
Reputation: 2
Post: #338
Rescanning all images as I'm writing this, and will report results tomorrow.

FFY
find
fungify Offline
Senior Member
Posts: 137
Joined: Jul 2010
Reputation: 2
Post: #339
Hi

First impression after a rescan is that it works as intended. I see a lot of different fields like GPS coordinates, caption, keywords and more. There seems to be errors with unicode characters in the caption field, but I will check this in more detail in a few hours.

Regarding the scanning of more XMP-fields - I did find this handy chart of the relationship between IPTC and XMP fields - it might prove useful?

[Image: 2cz5wqx.png]

(Found here: http://answers.microsoft.com/en-us/windo...6b83e05cd)

FFY
find
fungify Offline
Senior Member
Posts: 137
Joined: Jul 2010
Reputation: 2
Post: #340
OK - back with some feedback.

I would really like to see all the various keyword fields scanned as previously mentioned. Right now I have to manually copy all information from one field to another to get the keywords added to the addon.

Title / Description seems to not be unicode-converted correctly. Below is an example of one of the images.

This is what the image description looks like in the addon:
[Image: og9us1.png]

And this is the raw XMP-data - as viewed by the exif-viewer at http://regex.info/exif.cgi:
Code:
<?xpacket begin='' id='W5M0MpCehiHzreSzNTczkc9d'?>
<x:xmpmeta xmlns:x="adobe:ns:meta/"><rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#">
<rdf:Description rdf:about="uuid:faf5bdd5-ba3d-11da-ad31-d33d75182f1b" xmlns:dc="http://purl.org/dc/elements/1.1/">
<dc:subject><rdf:Bag xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"><rdf:li>
Ferie</rdf:li><rdf:li>Distortion Copenhagen 2011</rdf:li><rdf:li>Mærkedag/Bryllupsdag</rdf:li>
<rdf:li>Dyr/And</rdf:li></rdf:Bag>
            </dc:subject></rdf:Description><rdf:Description rdf:about="uuid:faf5bdd5-ba3d-11da-ad31-d33d75182f1b" xmlns:dc="http://purl.org/dc/elements/1.1/">
<dc:title><rdf:Alt xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"><rdf:li xml:lang="x-default">
10 års bryllupsdag i København</rdf:li></rdf:Alt>
            </dc:title><dc:description><rdf:Alt xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#">
<rdf:li xml:lang="x-default">10 års bryllupsdag i København</rdf:li></rdf:Alt>
            </dc:description></rdf:Description><rdf:Description rdf:about="uuid:faf5bdd5-ba3d-11da-ad31-d33d75182f1b" xmlns:MicrosoftPhoto="http://ns.microsoft.com/photo/1.0/">
<MicrosoftPhoto:LastKeywordXMP><rdf:Bag xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#">
<rdf:li>Ferie</rdf:li><rdf:li>Distortion Copenhagen 2011</rdf:li><rdf:li>Mærkedag/Bryllupsdag</rdf:li>
<rdf:li>Dyr/And</rdf:li></rdf:Bag>
            </MicrosoftPhoto:LastKeywordXMP><MicrosoftPhoto:LastKeywordIPTC><rdf:Bag xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#">
<rdf:li>Ferie</rdf:li><rdf:li>Distortion Copenhagen 2011</rdf:li><rdf:li>Mærkedag/Bryllupsdag</rdf:li>
<rdf:li>Dyr/And</rdf:li></rdf:Bag>
            </MicrosoftPhoto:LastKeywordIPTC></rdf:Description><rdf:Description rdf:about="uuid:faf5bdd5-ba3d-11da-ad31-d33d75182f1b" xmlns:MicrosoftPhoto="http://ns.microsoft.com/photo/1.0/"/>
<rdf:Description xmlns:Iptc4xmpExt="http://iptc.org/std/Iptc4xmpExt/2008-02-29/">
<Iptc4xmpExt:LocationCreated><rdf:Bag xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#">
<rdf:li><rdf:Description xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#">
<Iptc4xmpExt:CountryName xmlns:Iptc4xmpExt="http://iptc.org/std/Iptc4xmpExt/2008-02-29/">
Denmark</Iptc4xmpExt:CountryName><Iptc4xmpExt:ProvinceState xmlns:Iptc4xmpExt="http://iptc.org/std/Iptc4xmpExt/2008-02-29/">
Copenhagen City</Iptc4xmpExt:ProvinceState><Iptc4xmpExt:City xmlns:Iptc4xmpExt="http://iptc.org/std/Iptc4xmpExt/2008-02-29/">
Copenhagen</Iptc4xmpExt:City></rdf:Description>
                    </rdf:li></rdf:Bag>
            </Iptc4xmpExt:LocationCreated></rdf:Description></rdf:RDF></x:xmpmeta>
<?xpacket end='w'?>

FFY
find
Thread Closed