Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db

solexalex · 2010-09-15 21:00

Hi all

V 0.1.3 is available :

Code:

2010/09/15 --> v 0.1.3

  In the Sort by folder view, the count of the pictures was counting only the pics within the concerned folder, not all the pics from its subfolders

2010/09/14

  Fixed an issue that appear when scanning non unicode IPTC metadatas

  The strings are now localized ready. Please submit string.xml in your language

    need a german update (maybe correct english lannguage too)

2010/09/13

  Added German language for settings

  fixed : unicode errors in the file path, filename

  Setting to force reinit of the database on each plugin start is by default set to False.

    Picture folder will be scanned only at the start of the plugin. Next start, only new pics will be added and pictures physically removed will be removed from the databasse too.

2010/09/10

  Count how many pics for each filter

2010/09/09

  New way to select pictures to add in the database.

    Many file extension can be added (as for now are : ".JPG",".TIF",".PNG",".GIF",".BMP")

    but only jpg will be scanned for EXIF and IPTC metadatas

It should be available from dharma update addons.
Hope you like it !

I need your help, this plugin is for you all. So feel free to post your language strings.xml file, report me any bug, anything you like or even you dislike, continue telling me what do you wish for this plugin.

Next release (if not too much bugs reported) I will try to add something I think it is a good thing. You should be able to save pics (individually or not) as selections. So you'll be able to make albums, easy then to display some holiday pictures wherever pictures are saved.

Robotica · 2010-09-15 21:31

Great!

Is it possible to store links to the pics in the database so I don't need to scan my folder everytime (maybe as an option)?

And about creating albums... Can you use smart playlists for this so you can combine those pics with other media..

btw: Is there a seperate download for the XBOX-users?

solexalex · 2010-09-15 21:40

Robotica Wrote:Is it possible to store links to the pics in the database so I don't need to scan my folder everytime (maybe as an option)?

You have this option, it is the last one, and now, it should default to False :
Initialize the database before scanning
Unmark it and then it should only scan for new pics, and remove pics that are not physically present on your drive

Robotica Wrote:And about creating albums... Can you use smart playlists for this so you can combine those pics with other media..

Why not. Do you know a format for this ? Does XBMC play pictures smartplaylists ?
If it is doable, then I may do that after 'picture selection' stuff

Robotica Wrote:btw: Is there a seperate download for the XBOX-users?

No unfortunately no... It would take me too much time to maintain the plugin for both XBMC version (pre-dharma and post dharma)
If someone fill like doing a xbox version, feel free to tell me, would love to talk about it !

Robotica · 2010-09-15 21:56

beta1 worked fine on XBOX...

solexalex · 2010-09-15 21:59

yes, the very first release was pre-dharma. But from this time I made many change, including necessary changes for dharma addon system.

(Oh, I hope I did'nt missed a news telling dharma was ported to xbox as well !!!)

solexalex · 2010-09-16 00:09

known bug :
if you choose a month from the 'by dates' filter, and you have any picture in this month, shooted the last day of the month, it bugs. It is because to select a whole day of pictures, I take all the pictures dated between the given day of the month, and the given day +1. So if the month contain only 30 days (for example April) it selects pics from yyyy/04/30 to yyyy/04/31, which python time module says to be wrong (of course)
The correct thing should be 04/30 to 05/01 for a whole day...
I have to fix that.

Tonight I made something to sort pictures from any date to any other, so that you can easily sort all pics for a whole WE or all pics of you whole holidays. You'll have to wait for next release Wink

or check my svn : https://xbmc-scripts.googlecode.com/svn/...e.mypicsdb

mhdebokx · 2010-09-16 12:01

dutch translation is send to your email adress
in the next release this will be available

pko66 · 2010-09-16 14:01

Just a suggestion, maybe is stupid at this point, but...

Both the picasa application and picasa web allow face recognition and (partially automatic) naming of the people in each picture, and it works pretty well, I have like a thousand photos face and name tagged. It would be great to have that information imported somehow into the database

Robotica · 2010-09-16 14:06

@pko66: Facebook does that also...

ppic · 2010-09-16 14:18

the plugin already read tag, so if picasa tag the picture, it will be available in the plugin.

Robotica Posting Freak Posts: 992 Joined: Aug 2010 Reputation: 3	2010-09-15 21:31 Post: #22 Great! Is it possible to store links to the pics in the database so I don't need to scan my folder everytime (maybe as an option)? And about creating albums... Can you use smart playlists for this so you can combine those pics with other media.. btw: Is there a seperate download for the XBOX-users?
	find

Robotica Posting Freak Posts: 992 Joined: Aug 2010 Reputation: 3	2010-09-15 21:56 Post: #24 beta1 worked fine on XBOX...
	find

solexalex Skilled Python Coder Posts: 706 Joined: Jul 2004 Reputation: 6	2010-09-15 21:59 Post: #25 yes, the very first release was pre-dharma. But from this time I made many change, including necessary changes for dharma addon system. (Oh, I hope I did'nt missed a news telling dharma was ported to xbox as well !!!)
	find

mhdebokx Member Posts: 58 Joined: Dec 2006 Reputation: 0 Location: Netherlands	2010-09-16 12:01 Post: #27 dutch translation is send to your email adress in the next release this will be available
	find

pko66 Senior Member Posts: 191 Joined: Dec 2006 Reputation: 0	2010-09-16 14:01 Post: #28 Just a suggestion, maybe is stupid at this point, but... Both the picasa application and picasa web allow face recognition and (partially automatic) naming of the people in each picture, and it works pretty well, I have like a thousand photos face and name tagged. It would be great to have that information imported somehow into the database
	find

Robotica Posting Freak Posts: 992 Joined: Aug 2010 Reputation: 3	2010-09-16 14:06 Post: #29 @pko66: Facebook does that also...
	find