XBMC Community Forum
Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Printable Version

+- 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)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40


- fungify - 2012-03-07 09:26

You are right.

I did a little research with XNview, and it seems like the keywords are added to the picture, but as EXIF tags - not as IPTC tags.

I'll just have to find some small util to batch convert tags.

Sorry for reporting this as a bug.

EDIT: I now know what the cause of my problem was, and will note it here if others should be experiencing it as well. Some of my images were tagged with EXIF keywords (the field XPKeywords) others were not tagged with keywords at all. I recently started using Windows Live Photo Gallery 2011 to add tags, and all seemed to work as intended. WLGP2011 showed all my tags correctly, and I thoughh those were stored in IPTC keywords. But when actually exploring the tags I found something peculiar and unexpected. When WLGP saves tags in an image it seems to follow these rules:

If the image has an existing EXIF keyword tag, save the keywords to the existing EXIF keywords tag
If the image has an existing IPTC keyword tags, save the keywords to the existing IPTC keyword tag
If the image has neither EXIF or IPTC keywords, save the keywords to IPTC

In my case this meant that those of my images that only had EXIF tags added did not automatically get IPTC keyword tags when I edited the tags in WLGP2011. Suddenly I had a collection of images where some had keyword tags in EXIF, some had keywords in IPTC and some had tags in both.

The solution was actually simple - though it took some hours to find. Download exiftool and run the following command: "exiftool.exe -sep ; --struct -overwrite_original -r -charset iptc=UTF8 "-Keywords<xpkeywords" *.jpg"

FFY


- fmronan - 2012-03-07 12:06

The problem with installation for pictures db is
<import addon="script.module.dialogaddonscan" version="1.0.8"/>
because is for dharma
Frost change it edenNod
sorry for my English I'm french so...


- LoL - 2012-03-07 13:47

fmronan Wrote:The problem with installation for pictures db is
<import addon="script.module.dialogaddonscan" version="1.0.8"/>
because is for dharma
Frost change it edenNod
sorry for my English I'm french so...

So how do I get it to install?

Thx!


- fmronan - 2012-03-07 13:53

install the passion repo or install my skin "Glass" or the zip file http://passion-xbmc.org/addons/?Page=View&ID=script.module.dialogaddonscan


- Xycl - 2012-03-07 15:16

fmronan Wrote:install the passion repo or install my skin "Glass" or the zip file http://passion-xbmc.org/addons/?Page=View&ID=script.module.dialogaddonscan

It won't work for LoL because script.module.dialogaddonscan is already part of my repository due to dependency to My Picture Database. I changed it to version 1.0.8.
Because you have the same version in your repository it won't change anything for LoL.

Fungify managed to install My Pictures Database and I did yesterday evening a clean install of Eden RC2 + My Pictures Database and everything worked as expected.

Therefore there must be a different reason for LoLs problems.


- fmronan - 2012-03-07 15:29

Ok, I have added the 1.0.8 in the passion repo too so I don't know where is the problem of Lol


- mikebzh44 - 2012-03-08 11:55

For Lol and Xycl, the problem is specific to OpenELEC.

I'm running OpenELEC 2.0 (11.0 RC2) and MyPicsDB is broken.

I think is due to pysql : http://openelec.tv/forum/38-python-addons/11591-cdart-manager-dependacies-issues#14067

I will have a closer look this evening (French time).


- fiveisalive - 2012-03-08 20:27

Thanks for picking up this addon. A few questions:

1. will this work with Dharma?

2. does this contain all the changes that were also in the original SVN repo (I think there might have been a couple of unreleased changes, but I'm not sure):

http://code.google.com/p/xbmc-scripts/

http://code.google.com/p/xbmc-scripts/source/browse/#svn%2Ftrunk%2Fplugin.image.MyPicturesDatabase

3. would it be possible for you to ask for commit access to this original SVN repo, so we can keep the history, or alternatively if the original developer (alexsolex) isn't interested, consider migrating the repo to github, then we could create patches against github for bug fixes/new features.


- Robotica - 2012-03-08 21:06

I made the Dutch strings.xml more up to date with SVN R180 (solexalex's version). Maybe this could be updated?


- Xycl - 2012-03-09 19:33

fiveisalive Wrote:Thanks for picking up this addon. A few questions:

1. will this work with Dharma?

2. does this contain all the changes that were also in the original SVN repo (I think there might have been a couple of unreleased changes, but I'm not sure):

http://code.google.com/p/xbmc-scripts/

http://code.google.com/p/xbmc-scripts/source/browse/#svn%2Ftrunk%2Fplugin.image.MyPicturesDatabase

3. would it be possible for you to ask for commit access to this original SVN repo, so we can keep the history, or alternatively if the original developer (alexsolex) isn't interested, consider migrating the repo to github, then we could create patches against github for bug fixes/new features.

  1. I don't know.
  2. It's based on version 0.5.1(I think it's part of Dharma sources) whatever svn version this may be. The addon.xml in the xbmc-scripts google subversion repository trunk has version 0.1.1!
  3. I made the plugin Eden compatible because I liked it and wanted to use it with Eden. And because I thought that there are some guys who want to use it, too, I published it in my "abandoned" repository.

You said "We could created patches". That's of course okay. It's the intention of open source software. But I've to tell you that I don't have a lot of spare time.
Maybe we can ask fmronan to include it to passion-xbmc google svn because alexsolex is also one of the owner of passion-xbmc and fmronan is already a committer?Wink