[pierre8991]

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 ?

[mikebzh44]

Pierre, it's skin related, not script related

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

[pierre8991]

Ok merci je vais me rapprocher du skin

Thank's I will see with the skin

[fmronan]

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

[mikebzh44]

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 :

[Xycl]

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

1. 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.
   
2. 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.
   

---

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?

[herve502]

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 ?

[Xycl]

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.

[herve502]

Thanks one more time, it works!
Oh my god, how many times I try a solution just for a so tiny little comma!
I'll propose you the modification as soon as possible.

[Xycl]

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!

[paul5]

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

[Xycl]

Why do you think that a date is appended?

[paul5]

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.

[Miso]

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

[Xycl]

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