+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Development (/forumdisplay.php?fid=32)
+--- Forum: Python Add-on Development (/forumdisplay.php?fid=26)
+--- Thread: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db (/showthread.php?tid=80845)
RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - pedr0 - 2012-04-15 14:43
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.
RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Xycl - 2012-04-15 16:41
(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
RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - pedr0 - 2012-04-16 00:26
(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)?
RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Xycl - 2012-04-16 18:36
(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
2nd hint:
Don't use multipath sources!
RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - mgmartin - 2012-04-19 07:10
(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".
New repo location! - Xycl - 2012-04-19 11:03
Repos changed their location!
Link to repository: repository.xycl.abandoned.dharma
Direct link to MyPicsDB: MyPicsDb version 0.6.7
RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Xycl - 2012-04-25 10:04
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.
RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - fungify - 2012-04-26 00:06
Rescanning all images as I'm writing this, and will report results tomorrow.
FFY
RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - fungify - 2012-04-26 06:28
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]](http://i47.tinypic.com/2cz5wqx.png)
(Found here: http://answers.microsoft.com/en-us/windows/forum/windows_7-pictures/is-there-anyway-to-get-windows-7-to-properly/9fad8312-3fe5-4ff1-b2e3-f2ab5cb281b7?msgId=f271db5d-4766-432c-8bca-2456b83e05cd)
FFY
RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - fungify - 2012-04-30 09:54
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]](http://i48.tinypic.com/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