• 1
  • 15
  • 16
  • 17(current)
  • 18
  • 19
  • 27
Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db
Xycl Wrote:Yesterday I successful managed to read the XMP people tag(s) from a test picture changed by Microsoft Photo Gallery.

Thumbs up - nice to hear.

FFY
This script is added in my skin so I have add the script in the french repo passion.
http://passion-xbmc.org/addons/?Page=Vie...e.mypicsdb

Image
fmronan Wrote:This script is added in my skin so I have add the script in the french repo passion.
http://passion-xbmc.org/addons/?Page=Vie...e.mypicsdb

also does not work for me.. installing failed on both win 7 rc2 as openelec rc2..

hope to use it soon Smile
install passion repo
http://passion-xbmc.org/addons/?Page=Vie...n.xbmc.org
fmronan Wrote:install passion repo
http://passion-xbmc.org/addons/?Page=Vie...n.xbmc.org

allready had that great repo offcourse, but still says "Broken"..

Windows and Openelec RC2 versions of XBMC Eden
right clic on the repo actualise or install by zip
sorry for my english
Changelog
Update: Unicode issues with IPTC keywords fixed. Keywords are assumed to have UTF-8 encoding and if not then CP1250 (windows western europe) encoding.
I hope this will fix most of the issues. Tested with IrfanView which seems to use default windows encoding and Microsoft Picture Gallery which displays the IrfanView keywords (CP1250 encoding) correctly but stores in UTF-8 encoding.Eek
Update: "Browse by keywords" replaced by "Browse by tags". IPTC keywords marked with "Keyword:" and XMP PersonDisplayName tags with "Person:"
Update: "No keyword in picture" under "Browse by tags" now correctly working. Error in select statement corrected.
Added: XMP PersonDisplayName tags retrieved.
Added: When adding a new path to the database a cleanup function is called which deletes unused keywords.


LoL Wrote:When I try to install from your repo, it says "Broken" and therefore won't install.. any ways around this?
The repository is okay, even the old one was correctly working. I don't know what's the problem but maybe you have installed an external repository which includes a broken version of My Picture Database with a higher version number than 0.5.4?
No log no help.
Main page: https://github.com/Xycl
Repository: Xycl Repository Leia
Repository: Xycl Repository Matrix
Great to see this addon ressurected! Thnx.

Together with some picture related improvements in Eden, this addon makes the picture viewing experience so much better.
Upgraded to 0.5.5 and can confirm that the unicode-bug seems to be solved. Great and fast work. The Person: tag seems also to work - at least on my small test selection, will try on the entire collection next.

One problem though - out of my 7 images in the test set, only keywords from a small subsection is actually added to the database.

I've uploaded a small .zip (http://rlyeh.dk/test.zip) with three images; two with keywords that aren't added and one where the keywords are added. Perhaps this will help track the bug.

Update: Just tried adding all of my images to the database, and it seems like all Person-tags are (mostly) added correctly - even the ones where keywords aren't. For testing purposes, I tried adding one of the persons as a keyword on the same pictures, and out of the 1371 images, the Person-tag where found on 1166 of them, but the keywords on the same pictures where only added 96 times.

FFY
fungify Wrote:One problem though - out of my 7 images in the test set, only keywords from a small subsection is actually added to the database.

The keywords are shown by Microsoft Picture Gallery but they are not stored as IPTC keywords. Can be tested with IrfanView.
I'll try to get infos where they are stored.
No log no help.
Main page: https://github.com/Xycl
Repository: Xycl Repository Leia
Repository: Xycl Repository Matrix
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
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...
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!
install the passion repo or install my skin "Glass" or the zip file http://passion-xbmc.org/addons/?Page=Vie...gaddonscan
fmronan Wrote:install the passion repo or install my skin "Glass" or the zip file http://passion-xbmc.org/addons/?Page=Vie...gaddonscan

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.
No log no help.
Main page: https://github.com/Xycl
Repository: Xycl Repository Leia
Repository: Xycl Repository Matrix
  • 1
  • 15
  • 16
  • 17(current)
  • 18
  • 19
  • 27

Logout Mark Read Team Forum Stats Members Help
Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db2