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: Python Add-on Development (/forumdisplay.php?fid=26)
+--- Thread: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db (/showthread.php?tid=80845)
- mhdebokx - 2010-11-07 10:06
solexalex Wrote:I added in the code the ability to exclude a path from the scan.
That is great news. I'm waiting till the next beta version!
- solexalex - 2010-11-07 10:51
Another great news ?
I codded the things to set up the excluded paths. It is in the same place as the paths to scan.
Paths to scan are prepend with a green plus sign.
Paths to exclude are prepend with a red minus sign.
They all shown in the same place and i don t like it very much and may change this later. I will wait for your feedbacks first.
I think about adding a system of keyword exception so that picture name containing one of setted keyword exclusion will be excludefrom scan too
- The-Boxhead - 2010-11-07 19:12
Great work Guys ! very much appriciated. !
I understand it's not finished but just keep this as a
As a future request, im a hobby photografist and togheter
with all my regular jpg's i keep a folder with the raw images. Raw
images are larger files that comes straight out of a camera without any
post processing and are quite large. Raw files can have different file extensions depending on the brand of camera used.
A function to automaticly exlude raw data files would be great. Instead
of me manually exluding all the folders with raw files in them.
List of suggested excludes:
By having an option to exclude these types i don't get duplicates
and it speeds up the scanning. And i dont get dupes of all my images.
- solexalex - 2010-11-07 19:35
What is sometimes a bad thing, is sometimes a good thing.
The way I detect picture files is only based on the file extension.
Right now it is only hardcoded and these are extensions that will be scanned for exif and IPTC datas (note that a picture of any kind with not any of the exif nor IPTC metadatas will be added in the database, but maybe never shown in any results as many of them are based on one of the metadatas informations)
So in your case raw files should never be scanned. Maybe someone will tell me it is not a good idea and would want to handle raw files but... that's all I can do for the moment. Waiting for a way to edit files extension, users will have to edit the script.
Another way to detect file extension is ... I don't know. It may be based on the file content... that's why I can't do it, just because I don't know how it works.
Using simply the file extension, is pretty simple enough and does not consume too much processing time
- solexalex - 2010-11-08 00:24
I added the list of picture extension in the plugin settings.
Extensions are pipe separated and editable through the virtual keyboard.
I updated the svn (rev137) for those who follows it. Only the french strings.xml is uptodate, and other languages should be TOTALLY updated as many strings changed
- solexalex - 2010-11-09 00:23
Now I sorted a little bit the root paths to scan for pictures, then the excluded paths which should not be scanned.
It is much better.
I added a context menu that enables, from the 'sort by folder' view, to add directly from here a folder in the exclude list
- fiveisalive - 2010-11-10 14:34
solexalex Wrote:Now I sorted a little bit the root paths to scan for pictures, then the excluded paths which should not be scanned.
SVN update seems to work mostly fine (had to remove and rescan my database to get it to recognize new images since there was a new column). I have one issue in that 63 pics seem to be being recognized as "new" on every scan, despite the fact that they've already been added. I'll see if I can isolate on example.
Other bits that would be nice to implement/fix:
- solexalex - 2010-11-11 01:22
1 and 2 :
problem with slideshow over a folder item, is that the slideshow will check any of item in the folder.
For a keyword, no problems, every keyword contain only some pics with no sufolders
For date, a folder may contain a subfolder with some other subfolders.. and some pictures. But it contains as well the item you find in any subfolder which is the item to show all the pictures for the given date.
So for every folder, XBMC restarts in background the plugin in a loop to get recursively all the available pictures. The results is that a progress bar appear/disapear everytime the loop scan a subfolder and many pictures are duplicates because of the 'show all' items
This is the same for the folderview. The gui shows/hides/shows/hides... a progress bar for every subfolders. It finally looks uggly.
So I coded my own way to manually add only pictures and I will see later how to improve the diaporama context menu item
- Robotica - 2010-11-12 13:13
Since this project is adding a new picture experience to XBMC (and it's database in specific) I wonder:
This topic is discussing future database backend implementation. The picture library isn't within the scope. To me, it looks very useful to share all experiences from those topics so all aspects of a media database are considered.
- solexalex - 2010-11-12 14:51
oh well. It is a very good idea. But as english is not my first language, i don t feel to read the whole conversation.
Do you know if there is something to do to ask for thinking about a picture database ?
Sorry for being lazy on this but reading only the first topic is a hard work for me