[Xycl]

MyPicsDB 12.0.0

Changed:

• Version changed to 12 due to Frodo (Gotham will get 13).
  
• grrr's sugestion for memory mapped files in EXIF parser.
  
• Image rating fixed
  
• Video import fixed
  
• New language files from Transifex
  
• New database abstraction layer.
  

This is the MySql Release Candidate.

If you want to use a central picture database then do the following:

• You must create a database (this is different from music or video):
  CREATE DATABASE MyPicsDB CHARACTER SET utf8 COLLATE utf8_bin;
  
• Create a user (if not already done for music and movies):
  CREATE USER 'xbmc'@'%' IDENTIFIED BY 'xbmc';
  
• give him rights
  GRANT ALL ON *.* TO 'xbmc'@'%';
  
• Go to plugin settings and enable MySql. Set the correct user and password (they are case sensitive)!
  

Attention:

• If you already use a central database for video and music then (of course) use the same already existing user!
  
• Due to MySql index length constrains the path name of the pictures (w/o the file name) is limited to 200 chars in MySql (not in Sqlite).
  

2nd Attention:
I had to rewrite a lot of the source code responsible for the database access. Therefore there might be still some bugs (even if you don't use MySql)!

Xycl

[jopie]

Apologies for crossposting this but I am becoming a little desperate. I really appreciate the pictures database and used it all the time in Eden. Unfortunately it has become less than useful for MacMini users with dng files. This is NOT Xycl's fault. His database works fine but as soon as you try to view a dng file XBMC crashes. A separate thread has raised this issue but never got a decent response, despite the fact that people uploaded logs and despite the fact that it is many months old. I really would like anyone to acknowledge the problem and perhaps suggest a solution short of going back to Eden. Any ideas?

[Robotica]

Apologies for crossposting this but I am becoming a little desperate. I really appreciate the pictures database and used it all the time in Eden. Unfortunately it has become less than useful for MacMini users with dng files. This is NOT Xycl's fault. His database works fine but as soon as you try to view a dng file XBMC crashes. A separate thread has raised this issue but never got a decent response, despite the fact that people uploaded logs and despite the fact that it is many months old. I really would like anyone to acknowledge the problem and perhaps suggest a solution short of going back to Eden. Any ideas?

RAW support in general is sub par. I started a feature request topic but there is a general lack of interest in RAW-support. I think a stopgap solution could be upgrading CxImage to version 7 but other work is needs to be done to ditch CxImage in favor of FFMPEG (tagloader).

Some recent and good new trac-tickets (with logs!) would help at this time a think. Make sure to use a nightly when reporting since lots of work has been done lately.

ps. please reply in the Feature request topic.

[Robotica]

and @xcyl:
Big up for your continous work and support on this great AddOn. Looks the best picture addon, even for comming Gotham since Garbear (picture) Database work showed no results (yet).

[BenAtNVS]

Great Addon...Whaou!!! I just install it in MySQL mode.

But...
Impossible to find browse by person, location and many other options in the list.
I try locally (sqlight) without result.
Is it implemented in this new version?

Thank for this plugin and eExcuse me for my english.

[Xycl]

It's within "browse by tags" menu
There you can find all tags recognized by the parser like person, location etc.

Menu "translate your tags" lets you suppress tags (leave translation empty) or combine tags like 'Country/primary location name', 'Photoshop:Country' and 'Iptc4xmpExt:CountryName' to one 'Country' tag.

[BenAtNVS]

It's within "browse by tags" menu
There you can find all tags recognized by the parser like person, location etc.

Menu "translate your tags" lets you suppress tags (leave translation empty) or combine tags like 'Country/primary location name', 'Photoshop:Country' and 'Iptc4xmpExt:CountryName' to one 'Country' tag.

Thank you for the quick response.
I understand how to remove and add criteria using the menu translation.
however, I do not find in this list the exif tag "city." I have the GPS coordinates. the city is populated in the file.

[Xycl]

The tags for cities are in IPTC tags 'Photoshop:City', 'Iptc4xmpExt:City' and 'City'.
All three are automatically combined to 'City'.

But there is no EXIF tag for city.
All the camera manufactures have there own EXIF enhancements for city, country etc..
But this is not EXIF standard. Even not in EXIF standard version 2.3
You can use ExifTool to copy the city to an appropriated IPTC field.

GPS coordinates are stored in following EXIF tags

• GPS GPSLatitude
  
• GPS GPSLatitudeRef
  
• GPS GPSLongitude
  
• GPS GPSLongitudeRef
  

[BenAtNVS]

The tags for cities are in IPTC tags 'Photoshop:City', 'Iptc4xmpExt:City' and 'City'.
All three are automatically combined to 'City'.

But there is no EXIF tag for city.
All the camera manufactures have there own EXIF enhancements for city, country etc..
But this is not EXIF standard. Even not in EXIF standard version 2.3
You can use ExifTool to copy the city to an appropriated IPTC field.

GPS coordinates are stored in following EXIF tags

• GPS GPSLatitude
  
• GPS GPSLatitudeRef
  
• GPS GPSLongitude
  
• GPS GPSLongitudeRef
  

ok ... I made a small batch. all my photos are now tagged with the city. thank you so much for your guidance.
I spotted a small bug:
if tag 20 photos with a name, it will appear the number between parenthesis after the tag. if we delete 10 photos, we will always appear in front of the tag 20.
I hope you will understand.
Big thank you again for your work

[Xycl]

After changing pictures (deletion of pictures or new pictures) you've to rescan the path.
It's like video or music. Deleting music doesn't automatically remove the artist, album or track from the music database.

[BenAtNVS]

After changing pictures (deletion of pictures or new pictures) you've to rescan the path.
It's like video or music. Deleting music doesn't automatically remove the artist, album or track from the music database.

sorry, I misspoke.
I've done an update of the database after the deletion of photos.
The pictures do not appear, but the number in front of inscit tag has not diminished.

[Xycl]

Okay, I understood.

I will look on it.

[BenAtNVS]

What's a big work to tag 3 decades of picture !!!!
perhaps
a bug :
The global search seems returns an error. I use MySQL mode.
Big Thank for your work.

[Xycl]

I've done an update of the database after the deletion of photos.
The pictures do not appear, but the number in front of inscit tag has not diminished.

1) I confirm this bug. A commit is missing In the DB cleanup function.
2) Creating a period doesn't work with Sqlite.

What's a big work to tag 3 decades of picture !!!!
perhaps
a bug :
The global search seems returns an error. I use MySQL mode.
Big Thank for your work.

I'll look on this.
[EDIT] Found the bug.

[Xycl]

All currently reported bugs fixed with latest development release from my Github repo.