[RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags

  Thread Rating:
  • 1 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
Xycl Offline
Fan
Posts: 358
Joined: Feb 2012
Reputation: 7
Location: Germany
Post: #1
This add-on allows you to scan picture tags and to store them into a database.
It's an add-on originally developed by solexalex.

Features:
  • Recursive JPG picture scanning
  • EXIF, IPTC & XMP pictures metadata scanning
  • Filtering by date, folders or tags like keywords, categories, persons or country.
  • Advanced filter wizard that lets you select several tags at once.
  • Local or remote pictures (stored on a NAS).
  • Support of a central MySql database.
  • Sets home window properties for last added or shooted pictures and random pictures. Skinners look at thread WIP Glass
  • Screensaver: Support of Plugin Slideshow Screensaver from Ruuk. Thread http://forum.xbmc.org/showthread.php?tid=153057


Installation: (edit)
1) Install Xycl's repo
2) Install MyPicsDB from my repo.

Main menu
[Image: screenshot000.png]

Filter wizard:
[Image: screenshot001.png]

Browse by tags:
[Image: screenshot003.png]

No log no help.
How to submit a log file: XBMC-Wiki

Main page: https://github.com/Xycl
Repository: Xycl Repository
(This post was last modified: 2013-11-15 12:33 by Xycl.)
find quote
mikebzh44 Offline
Posting Freak
Posts: 1,789
Joined: Nov 2011
Reputation: 48
Location: Nantes - France
Post: #2
This addon is also available on Passion-XBMC repository : http://passion-xbmc.org/addons/?Page=Vie...e.mypicsdb

For skinners, you can use home properties set by this addon to populate widgets and statistics as in Glass :

[Image: 1339250492-screenshot014.png]

See Readme.txt or below to now to set and use properties :

a) MyPicsDB can be called with following parameters to populate window properties :

XBMC.RunScript(plugin.image.mypicsdb,0,?action='setproperties'&method='Latest|Random'&sort='Shooted|Added'&limit=10)

Parameters are :

- action='setproperties' to store in main window properties and in CommonCache DB

- method='Lastest' to get Latest pictures from DB
- method='Random' to get random pictures from DB

- sort='Shooted' to get latest pictures sorted by Shooted date (EXIF DateTimeOriginal)
- sort='Added' to get latest pictures sorted by Added in DB date (DateAdded)

- limit=10 to get only 10 pictures

Properties set to main window (ID=10000) :

MyPicsDB<Method>.Count = Number of pictures returned (max=limit)
MyPicsDB<Method>.1.Path = Path to picture #1
MyPicsDB<Method>.1.Name = Name of picture #1
MyPicsDB<Method>.1.Date = Shooted date of picture #1
MyPicsDB<Method>.2.Path = Path to picture #2
MyPicsDB<Method>.2.Name = Name of picture #2
MyPicsDB<Method>.2.Date = Shooted date of picture #2
...
...
...
MyPicsDB<Method>.10.Path = Path to picture #10
MyPicsDB<Method>.10.Name = Name of picture #10
MyPicsDB<Method>.10.Date = Shooted date of picture #10

b) To run a slideshow when user clicks on a picture :

<onclick>XBMC.RunScript(plugin.image.mypicsdb,0,?action='slideshow'&method='Random'&current=1)</onclick>

Parameters :

- action='slideshow' to run slide show

- method='Lastest' to get Latest pictures from DB
- method='Random' to get Random pictures from DB

- current=1 to start slideshow with Picture #1

c) Statistic properties

MyPicsDB<Method>.Categories = number of categories in DB
MyPicsDB<Method>.Collections = number of collections in DB
MyPicsDB<Method>.Folders = number of folders containing pictures in DB

MyPicsDBRandom.Categories = MyPicsDBLatest.Categories, same for Count, Collections and Folders but we don't know which method each skinner will use so I make the job twice Wink

Sorry for my english, but, you know, I'm French so ...

(This post was last modified: 2012-06-13 09:57 by mikebzh44.)
find quote
fungify Offline
Senior Member
Posts: 146
Joined: Jul 2010
Reputation: 2
Post: #3
Great to hear.

I've been trying the new version out and it's really nice. I especially like the new wizard - it really makes selecting the images easier. Though one question pops up: Am I right in asuming that the wizard only supports OR and not AND? Selecting for example to persons all the images where one or the other is included, and not as expected, where both of them are included?

FFY
(This post was last modified: 2012-06-13 10:26 by fungify.)
find quote
Xycl Offline
Fan
Posts: 358
Joined: Feb 2012
Reputation: 7
Location: Germany
Post: #4
Currently same tag types are combined with or and different tag types with and.
If you select person xycl & fungify and country germany & denmark then you'll get pictures which contain:
  • xycl & germany
  • xycl & denmark
  • fungify & germany
  • fungify & denmark

Edit: Only one tag of the above example isn't sufficient! The selected pictures must contain one selected person and one selected country.

Perhaps I can include a checkbox which enables an and for same tag types.

No log no help.
How to submit a log file: XBMC-Wiki

Main page: https://github.com/Xycl
Repository: Xycl Repository
(This post was last modified: 2012-06-13 10:44 by Xycl.)
find quote
fungify Offline
Senior Member
Posts: 146
Joined: Jul 2010
Reputation: 2
Post: #5
OK - that confirms my observations. Would really like to see a checkbox or something as this would make my life a bit easier Smile

Consider this scenario:

I need to find a picture of my son with his grandfather. I have about 3.500 pictures of my son and around 100 of his grandfather. Currently a search for both of these people would return a result of 3.600 pictures - which wouldn't make my life any easier. A search with and instead would return the 10 or so images that I'm really interested in.

This is a problem I've recently experienced but I'm sure there are many other scenarios where AND search would be nice.

Once again thank you for the effort. I've taken the liberty to point the developers of the Aeon Nox skin in the direction of this addon, as I would really like to see widgets included in that skin as well.

FFY
find quote
thethirdnut Offline
Donor
Posts: 692
Joined: Jun 2010
Reputation: 23
Location: western Canada
Post: #6
Will this Add-On do a 'better' job for general pic viewing as well?

This is one area - for whatever reason - that all my current Dharma installs really choke. Browsing to a folder of standard jpegs take several minutes.

As far as I understand it this is due to the lack of optimization for all things photo in current XBMC design. My question make sense?

TIA

If I helped out pls give me a +

XBMC1:
i3-540, GT430, Ubuntu 12.04 min + Frodo
-> HT: 58" plasma, Denon 3808CI, Paradigm Studio 60, CC-590, ADP-470, Seismic 12
XBMC2: Atom330, GT240, Ubuntu 12.04 min + Frodo
-> Main: 50" plasma, Rotel RX-1052, B&W 683
Server: 20TB FreeBSD + ZFS
find quote
fungify Offline
Senior Member
Posts: 146
Joined: Jul 2010
Reputation: 2
Post: #7
From experience - yes.

When navigating to a folder in regular XBMC all images seems to be read once (for thumbnails I would imagine). MyPicsDB doesn't do this, so viewing a regular folder is actually faster.

But the thing that MyPicsDB is actually best at is letting you navigate your images based on the tags you've (or your phone / camera has) included in the photo.

Want to find all pictures you've taken in London, England?
Want to find all pictures of your mom?
Want to find all pictures that shows your mom with a gorilla and a broom, taken in Holland during the 80's?

MyPicsDB currently does all of the above.

FFY
(This post was last modified: 2012-06-13 21:02 by fungify.)
find quote
Xycl Offline
Fan
Posts: 358
Joined: Feb 2012
Reputation: 7
Location: Germany
Post: #8
XBMC creates a thumbnail when a picture is displayed the first time in a list. The next times the already created one is used and therefore the lists are filled much faster.

And:
1) Make sure DDS fanart is enabled
2) Use Eden because of the new JPEG decoder. See changelog.

Of course, even with tags stored in a DB XBMC has to load the pictures to display it.

No log no help.
How to submit a log file: XBMC-Wiki

Main page: https://github.com/Xycl
Repository: Xycl Repository
find quote
fungify Offline
Senior Member
Posts: 146
Joined: Jul 2010
Reputation: 2
Post: #9
Yes - viewing the image takes the same amount of time, but entering a folder with (lots of) images in regular XBMC takes (on my HTPC with Core i5 and 8GB RAM) 10-15 seconds of precaching of the images each time. This does not happen when selecting Image Folder in MyPicsDB. This was what I meant above - sorry if that wasn't clear.

FFY
find quote
peppe_sr Offline
Fan
Posts: 668
Joined: Mar 2006
Reputation: 8
Location: Italia, Sicilia, Siracusa
Post: #10
i have installed right now the widget works but ignores the exif information. it does not rotate the photos.
it is skin or plug in related?
(This post was last modified: 2012-06-14 16:34 by peppe_sr.)
find quote
mikebzh44 Offline
Posting Freak
Posts: 1,789
Joined: Nov 2011
Reputation: 48
Location: Nantes - France
Post: #11
Which skin did you use ?

For me, it's related to skin.

Sorry for my english, but, you know, I'm French so ...

find quote
peppe_sr Offline
Fan
Posts: 668
Joined: Mar 2006
Reputation: 8
Location: Italia, Sicilia, Siracusa
Post: #12
i'm using aeon nox, could be related to my photos!
peppe
find quote
mikebzh44 Offline
Posting Freak
Posts: 1,789
Joined: Nov 2011
Reputation: 48
Location: Nantes - France
Post: #13
I don't know.

I think you should post your log to Aeon Nox thread.

Sorry for my english, but, you know, I'm French so ...

find quote
Xycl Offline
Fan
Posts: 358
Joined: Feb 2012
Reputation: 7
Location: Germany
Post: #14
(2012-06-14 16:27)peppe_sr Wrote:  i have installed right now the widget works but ignores the exif information. it does not rotate the photos.
it is skin or plug in related?

Does XBMC rotate your photos in the list view?
I ask because neither the add-on nor the skin displays the photo, XBMC displays it.

No log no help.
How to submit a log file: XBMC-Wiki

Main page: https://github.com/Xycl
Repository: Xycl Repository
find quote
peppe_sr Offline
Fan
Posts: 668
Joined: Mar 2006
Reputation: 8
Location: Italia, Sicilia, Siracusa
Post: #15
(2012-06-15 08:48)Xycl Wrote:  
(2012-06-14 16:27)peppe_sr Wrote:  i have installed right now the widget works but ignores the exif information. it does not rotate the photos.
it is skin or plug in related?

Does XBMC rotate your photos in the list view?
I ask because neither the add-on nor the skin displays the photo, XBMC displays it.

i tested, are my photos. xbmc in list view doesn't rotate them.
now some questions related to the random widget:
first of all i'm using aeon nox (so tell me if i have to post also in skin's thread).
1- i'm set "use the picture as fanart for picture" so when i'm on the windget i can see the photo as background. if the photo has a landscape format no problem but if it is a portrait the photo is showed as landscape ad so it is distorted.
2-throug the widjet i can see some information about the photo, name, date etc.... could be possible to see the name of the photo's folder? not the full path only the name of the folder.
3-how and how often the phots in the random widget are refreshed, i would like to see more photo's as possible not always the same.
that's all for the moment, great work.
peppe
find quote
Post Reply