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: Feature Suggestions (/forumdisplay.php?fid=9)
+--- Thread: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db (/showthread.php?tid=22407)
Sort by date - Date currently showing up for pictures if the files dates (not EXIF)? - nabab - 2010-01-14 18:00
First, thank you big time for this amazing software!!
I have just installed a media center for my folks on their TV with a Logitech remote and it works awesome. However, they have started to put their photo album on the machine, and when we look at them in XBMC, ordered by Date, it's the file's date which is showing up, not the EXIF date. So teh Diaporama are not chronological, while we can still see the EXIF date and time if we do Info.
They use the Transparency skin (which has some great photo's specific features like the Polaroid view), but I've tried also with MediaStream, and got the same result.
They say that when they loaded the pics the first time they could see the rea date in the list, but not anymore...
Does someone have any idea? Is it normal? If so, is there a skin managing better the pictures?
Thanks a million!
- spiff - 2010-01-14 18:29
this would be skin independent. we would need a picture library for this to work, and nobody on the team atleast have expressed any interest in doing one.
Picture library - thor.magnus - 2010-01-15 15:53
is more than welcome :-)
please see if you guys can make time for implementing this.
Thank you for all your hard work!
- nabab - 2010-01-18 02:53
Thanks for the reply... Is it doable through a Python plugin or does it need to be part of a new release?
Would it be possible to know where exactly in the code to find these processes:
1/ Music or Video library's DB creation
2/ EXIF data reading (when clicking info in the context menu)
3/ Photos scan for creating thumbnails
According to JMarshall it's pretty hard to achieve (9 out of 9!) for a newbie like me, but still I'd like to have at least a little look...
- solexalex - 2010-04-10 23:51
Hi everybody !
Unfortunately, team doesn't seem to want to add a library feature inside picture section of XBMC...
I started a python library in that way one year ago, and stopped because I thought the team changed their mind...
One year later, nothing more for pictures and I need it for a new project using an old laptop with XBMC, I'm making my own digital photo frame with weather and some nice other features coming with time.
Anyway, my lib becomes pretty good at "databasing" (ie putting inside a database) exif and IPTC meta infos.
Then, with good requests I can sort pictures by date (from date to date) by camera model, by folder, by tags ....
That post to inform those of you doing the same or even better. It time to talk together as I don't want to go on if it is already close to be released.
For infos, I scan and feed my database of 1234 local files recursively in different folders, for about 30 seconds.I think it is pretty fast.
Tell me what you think about this feature coming to us soon hopefully.
- mhdebokx - 2010-04-12 19:54
Thanks for your reply. I was one of the believers too that a library feature should be added to XBMC. XBMC is the best media center, but it lacks this basic feature.
I hope you can develop a python script version for showing the pictures.
As you wrote, the minimal version should have the option to select picture from Exif, IPTC meta tags.
These features should also be available; but these are probably the basic from XBMC
- random play
- no transition / transition using pan and zoom
An other option is to use 'smartplaylist' like in the music database. Combining with regular expressions, the selection of pictures should be very comprehensive.
The selection of the pictures should contain the OR and AND functions.
If you need more specific info, send me an e-mail.
Please continue develop your script.
- solexalex - 2010-04-14 15:00
Hi and thank you for your interest.
Right now it stills work in progress but i promess you that you'll get a picture library on your favorite media center pretty soon.
In fact, my lib to get pics as a sqlite library is done. I got many different request too.
On an other way i worked to manage the xbmc slideshow feature right from python script. This part is too much 'alpha' to tell you more.
These couple of last days i tried to make everything works inside xbmc (i was developping from windows python) and the results are extremely encouraging :-)
Today i started the plugin part. This will have a home screen with :
- by dates
- by folders
- by keywords
Inside 'by dates' you will have the years. Then for a given year, the months and for a month the dates and then of course, the pictures. Of course you'll be able to show pictures for a whole year or whole month.
Inside 'by keywords' you ll get the list of your keywords and then pictures for the given keywords.
By folders view will show you only the relevant folders i.e ths which contains pictures.
Your ideas are interesting in that way that i was looking for a solution to enable users to set their very own filters.
I thought to a kind of playlist but was not able to find an open existing format to use. I may develop my own xml like or so picture playlist file afterwards.
Have you got some special filters you may want to use as root for the plugin ?
Can you send me a collection of your tagged pictures for more tests ? (i used picasa tagged pictures)
If you have more info to share it is welcome as i'm not very involved in picture tagging and 'databasing'
- solexalex - 2010-07-12 22:28
It has been a while seen my good promess, but I did not worked a lot on it.
Library was pretty good and very working for a beginning. The natural next step was to make an integration to use it inside xbmc. Plugin was the easiest way I think, but xbmc changed a lot since the start of my plugin.
I'm going to keep my 'old' xbmc release to finish the plugin, then I hope I could make it work for very early xbmc release.
ok, ok, a lot of promesses, but it is really what I want to do, but life does not help to do (all) what you want to...
hum, is there anyone continuing reading this ?? lol
keep showing me your interest as I need it to go ahead !
- solexalex - 2010-07-15 23:49
plugin in progress !
Right now I'm able to scan (pretty fast) my pictures and sort them by year, then months for a given year, then days for a given year/month, and finally get the pictures. When pictures are listing, you can run the slideshow.
It works pretty fast, the longest part is the scanning stuff to retrieve EXIF and IPTC metadatas when launching the plugin.
Next step will be the "keywords" extraction, then folders.
I'm going to develop a way to create and save custom filters (for example, to get all the pictures tagged "family" from date to date ...)
- RockDawg - 2010-07-16 02:51
Thanks for taking on this project. Pictures always seem to be an overlooked area of XBMC. This will be great! I can't wait!