Kodi Community Forum
Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Development (https://forum.kodi.tv/forumdisplay.php?fid=32)
+--- Forum: Add-ons (https://forum.kodi.tv/forumdisplay.php?fid=26)
+--- Thread: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db (/showthread.php?tid=80845)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27


RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - fmronan - 2012-03-27

with 0.6.3, the script run and scan but after that every are empty.
same with 0.6.4Confused, no pictures, just one movie .avi , strange


RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Xycl - 2012-03-27

(2012-03-27, 19:33)fiveisalive Wrote: I wonder if you'd consider putting up your repo:

http://www.xycl.de/xbmc/repository.xycl.abandoned.dharma.zip

on the list at:

http://wiki.xbmc.org/index.php?title=Unofficial_add-on_repositories

that way the Repositories Installer Add-on can more easily install it. I had to manually search for the link to the zip file from your site, manually download it, then install it within XBMC. Thanks.

Done



RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Xycl - 2012-03-27

(2012-03-27, 20:30)fmronan Wrote: with 0.6.3, the script run and scan but after that every are empty.
same with 0.6.4Confused, no pictures, just one movie .avi , strange

Something in log file?

I deleted:
1) the archived zip file in addons/pakages directory
2) the directory addons/plugin.image.mypicsdb
3) userdata/Database/MyPictures.db

Then I installed from my repo mypicsdb and everything works.

Please open addons/plugin.image.mypicsdb/lib/resources/MypicsDB.py in an editor and find
PHP Code:
def DB_cleanup_keywords(): 
There should be the lines
PHP Code:
#cn.execute( "delete from TagsInFiles where idFile not in(select idFile from Files )")
#cn.execute( "delete from Tags where idTag not in (select idTag from TagsInFiles)") 
Important is the # at the beginning.

If there is a # then please delete your scanned path in mypicsdb and add it again.


RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - TPXBMC - 2012-03-28

Hi,

Does anyone know if there is a way to do an advanced search on the pictures. I haven't found a way yet. For Example:

-Pictures with Tag: Vacation and Tag: Mexico
-Pictures with Tag:Kids Name, Tag Birthday, Date range 2005-2008

So far the Global search does not seem to allow multiple phrases but perhaps I don't know the proper syntax. Even a view by tag within view by tag function would be good.

Thanks.



RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Xycl - 2012-03-28

(2012-03-28, 01:32)TPXBMC Wrote: Hi,

Does anyone know if there is a way to do an advanced search on the pictures. I haven't found a way yet. For Example:

-Pictures with Tag: Vacation and Tag: Mexico
-Pictures with Tag:Kids Name, Tag Birthday, Date range 2005-2008

So far the Global search does not seem to allow multiple phrases but perhaps I don't know the proper syntax. Even a view by tag within view by tag function would be good.

Thanks.

(2012-03-26, 22:16)Xycl Wrote: Suggestion for further development:
.....

3)
An advanced filter. Perhaps a wizard.
Select pictures from country abc with keyword xyz containing person def. Needs 1) otherwise it's not maintainable.

Any opinions?

Therefore currently the answer is no.


RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - fmronan - 2012-03-28

french translation

http://glass.googlecode.com/files/strings.xml


RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - fmronan - 2012-03-28

every thing works fine added 0.6.5 to repo passion


RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - fmronan - 2012-03-28

I can't adde the 0.6.5 because the repo said problem with stringsHuh


RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Xycl - 2012-03-28

(2012-03-28, 11:16)fmronan Wrote: I can't adde the 0.6.5 because the repo said problem with stringsHuh

Have you problems installing 0.6.5 in XBMC or problems adding mypicdb to your repo?


RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - fmronan - 2012-03-28

adding in the repo, works fine in xbmc, I do not understand because i can added the 0.6.2


RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - fmronan - 2012-03-28

Adding, the problem is my .zipConfused


RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - fungify - 2012-03-28

A few bugs I've encountered.

Adding a folder to exclude leads to GUI lockup for many seconds. When GUI responds again the chosen folder is not excluded. Repeating the proces does not lead to lock up, and the folder is excluded. I've tried deleting image-database, enabling debug, restarted XBMC and added a folder and two folder to exclude. Pastebin here: http://pastebin.com/9vDKi5wN

I've noticed problems with large number of photos as well. I've added several thousand photos, most of which are tagged with person and keywords. When selecting a person with a large number of images (>800) the addon throws an error. This does not happen when there is a smaller number of images attached to the person. Will post pastebin as soon as I've completed a rescan of the images.

FFY




RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Xycl - 2012-03-28

(2012-03-28, 12:08)fungify Wrote: Adding a folder to exclude leads to GUI lockup for many seconds. When GUI responds again the chosen folder is not excluded. Repeating the proces does not lead to lock up, and the folder is excluded. I've tried deleting image-database, enabling debug, restarted XBMC and added a folder and two folder to exclude. Pastebin here: http://pastebin.com/9vDKi5wN

I've the same problems. When selecting a directory, either to include or exclude, sometimes a progress dialog appears. Then you can be sure that it doesn't work.
Perhaps someone with more Python knowledge than me can have a look at show_roots() in default.py.
Currently I'm not able to find the reason for this progress dialog.

(2012-03-28, 12:08)fungify Wrote: I've noticed problems with large number of photos as well. I've added several thousand photos, most of which are tagged with person and keywords. When selecting a person with a large number of images (>800) the addon throws an error. This does not happen when there is a smaller number of images attached to the person. Will post pastebin as soon as I've completed a rescan of the images.

Alexsolex added a paging to the plugin. Annoyingly, this seems to be not fully implemented. You can set the max number of displayed pictures in the preference dialog of mypicdb to 100.000. Perhaps this will help.


RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - fungify - 2012-03-28

(2012-03-28, 14:18)Xycl Wrote: I've the same problems. When selecting a directory, either to include or exclude, sometimes a progress dialog appears. Then you can be sure that it doesn't work.
Perhaps someone with more Python knowledge than me can have a look at show_roots() in default.py.
Currently I'm not able to find the reason for this progress dialog.
Exactly what I'm experiencing. Hope someone casts some light on this bug.
(2012-03-28, 14:18)Xycl Wrote: Alexsolex added a paging to the plugin. Annoyingly, this seems to be not fully implemented. You can set the max number of displayed pictures in the preference dialog of mypicdb to 100.000. Perhaps this will help.
Tried playing around with it, but unfortunately it seemed to have no difference what so ever.

On a related note - I would like to help with the Danish translations, but I can't seem to find the strings to translate?

EDIT: Can anyone confirm that adding excluded folders before scanning dramatically increases scanning time? As is - hours suddenly. Working on the fourth hour to scan my 7-8 thousand pictures for the first time - each picture taking 5-10 seconds to add to the database.

FFY


RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Xycl - 2012-03-29

(2012-03-28, 20:33)fungify Wrote: On a related note - I would like to help with the Danish translations, but I can't seem to find the strings to translate?

Plugin directory in resource language. Take the english one.

(2012-03-28, 20:33)fungify Wrote: EDIT: Can anyone confirm that adding excluded folders before scanning dramatically increases scanning time? As is - hours suddenly. Working on the fourth hour to scan my 7-8 thousand pictures for the first time - each picture taking 5-10 seconds to add to the database.

Yes, an excluded directory is not scanned.
My Laptop scans several pictures per second (i7 2620m) but the pictures have a resolution of only 5 MPixels.
I know that the larger the pictures are the longer it will take to scan them.

EDIT: And I know that even videos are scanned. This takes a very long time.