Add periods support to Filter Wizard

Now productive

ERROR: [My Pictures Database] line   274 in dbabstractionlayer.py object Database abstraction layer >> The request failed :
ERROR: [My Pictures Database] line   275 in dbabstractionlayer.py object Database abstraction layer >> <type 'exceptions.Exception'> - 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ecole_') AND strFilename='XXXX.jpg'' at line 1
ERROR: [My Pictures Database] line   279 in dbabstractionlayer.py object Database abstraction layer >> SQL > DELETE FROM Files WHERE idFolder = (SELECT idFolder FROM Folders WHERE FullPath Like 'smb://HOSTNAME/Database/XXX_arrive_a_l'ecole_') AND strFilename=?

Related code : (SELECT idFolder FROM Folders WHERE FullPath Like '%s_')

It seams as the person tags are not imported to the persons table anymore. Please fix this problem.

It would also be nice to have the iptc xmp persons in image tag in this table. The Tag is named: Iptc4xmpExt:PersonInImage

I want to use a shared MySQL, having just set up my video and music databases to do so. Readme.txt says enable MySQL and enter the user & password in the plugin settings. There are no such controls in the plugin settings or they are so hidden I failed to find them.

I see 4 tabs: General, Files, Menu Items and Debugging and nothing about MySQL on any of them.

How do I enable MySQL? And as part of that, where do I enter the URL of the SQL server? That is not even mentioned in the Readme.txt.

I have version 12.3.14 running in Gotham.

BTW, why is this plugin no longer in the official XBMC repository?

Hi Guys, I am quite new to MyPicsDB but I love it! I finally found a nice workflow:

• Import and Edit photos with Shotwell / Darktable

• Rsync the photos to my pi device with

  rsync -aHAXxv --numeric-ids --delete --progress --exclude RAW/ -e "ssh -T -c arcfour -o Compression=no -x" Pictures/ [email protected]:/home/kodi/Pictures

• Go to the interface and launch the updater

It would be nice to have the possibility to launch a curl command like for videos and music from the remote, to launch the scan / clean.

Latest mypics db pulled from github, but unable to load it to xbmc 13 alpha 10.

Addon script.module.dialogaddonscan requires xbmc.python version 2.0 which is not a
vailable

Hy Xycl
MyPicsDB doesn't recognizes the rating im my pictures.
Here ist a part of the xmp:

<rdf:Description xmlns:xap="http://ns.adobe.com/xap/1.0/" rdf:about="" xap:CreatorTool="IDimager V5 - Digital Image Manager (5.1.1.1-ProSL)" xap:MetadataDate="2011-11-27T22:18:18.155+01:00" xap:Rating="5" xap:CreateDate="2007-01-14T09:42:25+01:00"/>

The reason seams to be the xap:Rating instead of xmp:Rating.

Is it possible to fix this problem?

Thanks
Schirru

Remote file support now productive

This plugin does not work under Frodo because of an error in MypicsDB.py. The error seams to occur on this line:
makepath=xbmc.translatePath(os.path.join)

I've just commented out the try, except part and the plugin works again:

try:

#import xbmc
#makepath=xbmc.translatePath(os.path.join)

except:

import xbmc
makepath=os.path.join

Its just a workarround, so please find a better solution to this problem.

Scanning images stopped on one image which does not have a metadata block (exif, xmp, …) at all with error: kodi.log

I could fix this by changing lines 407 and 428 in scanpath.py from picentry['Image Rating'] to picentry.get('Image Rating'). I am not a Python person at all and have no experience in writing kodi plugind, therefore I am not sure this is the right way to do it:

Line 407: if picentry.get('Image Rating') is None or picentry['Image Rating'] == '' or picentry['Image Rating'] < '1':
Line 428: if picentry.get('Image Rating') is None or len(picentry['Image Rating']) == 0:

Thanks for your work!

Klaus