Release - MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags

Release MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Add-on Support (https://forum.kodi.tv/forumdisplay.php?fid=27)
+---- Forum: Picture Add-ons (https://forum.kodi.tv/forumdisplay.php?fid=150)
+---- Thread: Release MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags (/showthread.php?tid=133905)

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 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53

RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - pierre8991 - 2013-04-05

Hello
With MyPicsDB when i start Diaporama and hit the "O" key I display all EXIF/ITC information which is great but it will be fantastic to have the possibility to select only the items I want to be displayed.

Is it possible or will it be possible ?

RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - mikebzh44 - 2013-04-05

Pierre, it's skin related, not script related Wink

Pierre, c'est le skin qui gère ça, pas le script Wink

RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - pierre8991 - 2013-04-06

Ok merci je vais me rapprocher du skin

Thank's I will see with the skin

RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - fmronan - 2013-04-08

Is it possible to edit IPTC or EXIF info with PicturesDB?
I thing not so can you make something for that?

RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - mikebzh44 - 2013-04-08

Is it normal that when I browse my pictures without using MyPicsDB, metadata are displayed (especially file size in this case) :

But if I browse my picture with MyPicsDB, the same picture didn't have size :

Even when pressing I :

It's not related to skin as the problem occure in Confluence :

Default browsing :

MyPicsDB browsing :

RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - Xycl - 2013-04-08

(2013-04-08, 14:29)fmronan Wrote: Is it possible to edit IPTC or EXIF info with PicturesDB?
I thing not so can you make something for that?

I've 2 reasons to reject your wish

For Mac, Linux and Windows there are a lot of programs which can edit tags. It doesn't make sense to write the next one which would be worse than the existing programs.
I think that XBMC is designed for remote control use. I use a Logitech Harmony with AutoHotkey (Windows). With the remote I control the complete PC. Even killing and restarting XBMC, controlling PowerDVD or closing Kylo (TV-Browser) works. But entering text is no fun.

(2013-04-08, 15:54)mikebzh44 Wrote: Is it normal that when I browse my pictures without using MyPicsDB, metadata are displayed (especially file size in this case) :
But if I browse my picture with MyPicsDB, the same picture didn't have size :

I already noticed the missing picture size, but I don't know the reason.
Perhaps MyPicsDB has to set an InfoLabel?

RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - herve502 - 2013-04-09

Hi,

I continue to work on the file default.py and create a def structure import_xml_picasa to clean the show_collection.
I would like to propose the import in 3 passes.

The first pass is just to extract the picture name in import file and them import it if exist in Mypics database.
For this, i would like to find the picture file and picture path in the database only with the filename extract for import file (and not with the associated path file).

Your previous request works right:

picfile, picpath = MPDB.RequestWithBinds("select strFilename, strPath from files where lower(strFilename) and lower(strPath)= ? ",
(filename.lower(), pathname.lower() ) )[0]

work but when I try to write:

picfile, picpath = MPDB.RequestWithBinds("select strFilename, strPath from files where lower(strFilename) = ? ",
(filename.lower() ) )[0]

it doesn't work. Did I miss something ?

RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - Xycl - 2013-04-09

(2013-04-09, 10:14)herve502 Wrote: picfile, picpath = MPDB.RequestWithBinds("select strFilename, strPath from files where lower(strFilename) = ? ",
(filename.lower() ) )[0]

it doesn't work. Did I miss something ?

The parameter must be a tuple: (filename.lower() , )
See the comma.

RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - herve502 - 2013-04-09

Thanks one more time, it works!
Oh my god, how many times I try a solution just for a so tiny little comma! Big Grin

I'll propose you the modification as soon as possible.

RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - Xycl - 2013-04-11

Upcomming MySql Release

If you install my GitHub XBMC repo then you'll get MyPicsDB 2.2.2 which supports MySql.
Keep in mind that this is a release candidate which means that there might be some broken functionality!

You must create a database:

Code:
CREATE DATABASE MyPicsDB CHARACTER SET utf8 COLLATE utf8_general_ci;

Create a user (if not already done for music and movies):

Code:
CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';

And give him rights

Code:
GRANT ALL ON *.* TO 'xbmc';

Go to plugin settings and enable MySql.
Database MyPicsDB with user XBMC and password XBMC is preconfigured.

Restrictions:
Due to MySql's index size limitations the picture path length is limited to 255 characters!

RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - paul5 - 2013-04-19

Is there an option to keep the original file names and not have the date appended?
Thanks.

RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - Xycl - 2013-04-19

Why do you think that a date is appended?

RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - paul5 - 2013-04-26

Sorry, my bad.
The picture folder that I've added is a library backup created by Windows8 Backup. The Windows8 Backup utility has appended the date, not the plugin.

RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - Miso - 2013-05-05

Hello,

It seems that picture rating scanning does not work with the recent versions of the addon - no ratings are displayed for the pictures. I tried using XBMC 12.2 and addon versions 2.2.2 as well as development 2.2.6. Used OS is Windows 8.
It worked OK with version 12.0 and 1.2.9.

Is this a known issue or should report it somewhere else.

Thanks, great work otherwise!

Regards

Miso

RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - Xycl - 2013-05-05

I'll look on it next week.
Didn't know that there's an issue with the ratings because I don't own any pictures with ratings.

Thanks
Xycl