Kodi Community Forum
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)



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

You must create a picture source.
Due to the 404 Not Found error with path "http://www.gazeteoku.com/gazete/60000/13-12-2013" it won't work.

(2013-11-28, 18:40)Livin Wrote: I use NFS (connecting to Synology) and with the native 'Pictures' section I get thumbnails. I'm running XBMC on Win7 x64, nothing fancy. I'll install this Add-On and let you know what I find... I've been meaning to get this installed since the native XBMC 'Pictures' sux. Smile

One month later.... without a reply

I can confirm that there is not a general NFS problem.
My Windows XBMC can use NFS to show pictures stored on an XBMCbuntu machine.
You can even use non latin characters for path or file name without any problems.


RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - risigvalue - 2013-12-16

(2013-12-16, 10:07)Xycl Wrote: You must create a picture source.
Due to the 404 Not Found error with path "http://www.gazeteoku.com/gazete/60000/13-12-2013" it won't work.

i cant get how it doesnt work :S it works just fine

Image



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

You must create a picture source and the path to this souce gives back a 404 error!
I didn't talk about the picture but the path "http://www.gazeteoku.com/gazete/60000/13-12-2013"

See: http://wiki.xbmc.org/?title=Userdata/sources.xml/Source_types#HTTP_.28Hypertext_Transfer_Protocol_.29_Client


Ynt: RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - risigvalue - 2013-12-17

(2013-12-17, 13:30)Xycl Wrote: You must create a picture source and the path to this souce gives back a 404 error!
I didn't talk about the picture but the path "http://www.gazeteoku.com/gazete/60000/13-12-2013"

See: http://wiki.xbmc.org/?title=Userdata/sources.xml/Source_types#HTTP_.28Hypertext_Transfer_Protocol_.29_Client

i can open pic source.. open pic source is not problem for me.. do you have any idea how to make pic watchable?


RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - nemj - 2013-12-18

Thanks for a great plugin! I just changed my old ATV for a Raspeberry Pi with raspbmc, and your plugin makes it useful also for using my picture colection as screensaver. A tip/suggestion to add:
I wanted to use your plugin together with ruuk's screensaver plugin to display random pictures from my collection. I have right now a bit more than 20000 pictures, adding this in default.py, method 'show_pics(self)' works:

Code:
elif self.args.method == "Random":
      picfanart = join(PIC_PATH,"fanart-date.png") #Just to have something, not needed?
      filelist = [row for row in MPDB.cur.request( """SELECT strPath,strFilename FROM Files WHERE RANDOM() %% 100 == 0 ORDER BY RANDOM() LIMIT 250 OFFSET %s"""%(offset) )]

This is obviously too hardcoded, but could be possible to make nice(?) I found the trick WHERE RANDOM() %% k somewhere on the web, works great for largeish tables. k should ideally be set by k = COUNT(*) / limit

Maybe something to add, also as option in main menu ("View x random pictures")?


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

(2013-12-17, 18:28)risigvalue Wrote: i can open pic source.. open pic source is not problem for me.. do you have any idea how to make pic watchable?

I cannot open the pic source. Entering http://www.gazeteoku.com/gazete/60000/13-12-2013 into the address bar of a browser gives me a 404 Error.


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

(2013-12-18, 01:50)nemj Wrote:
Code:
elif self.args.method == "Random":
      picfanart = join(PIC_PATH,"fanart-date.png") #Just to have something, not needed?
      filelist = [row for row in MPDB.cur.request( """SELECT strPath,strFilename FROM Files WHERE RANDOM() %% 100 == 0 ORDER BY RANDOM() LIMIT 250 OFFSET %s"""%(offset) )]

This is obviously too hardcoded, but could be possible to make nice(?) I found the trick WHERE RANDOM() %% k somewhere on the web, works great for largeish tables. k should ideally be set by k = COUNT(*) / limit

Maybe something to add, also as option in main menu ("View x random pictures")?

Good idea, especially for using with ruuk's screensaver.

But I don't see a reason for the where condition because
Code:
ORDER BY RANDOM() LIMIT 250
already gives back a random list of 250 pictures.


RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - nemj - 2013-12-18

But it is the where-condition that makes it useful with many pictures in the database. I tried first with

SELECT strPath,strFilename FROM Files ORDER BY RANDOM() LIMIT 250

but it takes forever on a raspeberry pi and a few thousand pictures in the database. I think since it selects all rows in the db and then sort them, which is too much for a very limited HW.

Im not sure if 'ORDER BY RANDOM()' gives anything though. Im thinking it might be a bit faster than to use randomizing in ruuks plugin after "delivery", and will make me not always see pictures in the same order they were inserted into the database.


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

MyPicsDB 12.2.6

available in my repository.

New menus
  • N random pictures
  • Saved filter wizard settings
especially for use with ruuk's plugin slideshow screensaver.
Thanks to nemj.

(2013-12-18, 10:37)nemj Wrote: But it is the where-condition that makes it useful with many pictures in the database. I tried first with

SELECT strPath,strFilename FROM Files ORDER BY RANDOM() LIMIT 250

but it takes forever on a raspeberry pi and a few thousand pictures in the database. I think since it selects all rows in the db and then sort them, which is too much for a very limited HW.

Im not sure if 'ORDER BY RANDOM()' gives anything though. Im thinking it might be a bit faster than to use randomizing in ruuks plugin after "delivery", and will make me not always see pictures in the same order they were inserted into the database.

I didn't see your response before releasing the new MyPicsDB Sleepy

Raspberry Pi?
Makes sense to limit the possible result set with the where condition.
I tried it with 11k pictures an a Core i7, Sqlite and MySql. There was no performance gain with this where condition.

Okay then there will be a new version with this limiting condition.Wink


RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - nemj - 2013-12-18

I tried the new release and it works perfectly! Thanks a lot!


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

(2013-12-18, 09:47)Xycl Wrote: I cannot open the pic source. Entering http://www.gazeteoku.com/gazete/60000/13-12-2013 into the address bar of a browser gives me a 404 Error.
i have made a source for you.. is this usefull boss??

http://happyfeets.net78.net/HFOTV/gazeteler.xml


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

No it's not usefull.

We were talking about the possibility to access pictures stored on web servers.
This is possible because XBMC supports webdav.
But with your originally URL it's not possible due to the 404 error you get when you try to access the directory in which the picture is stored.

Now you gave me an xml file which contains links to pictures.
Despite the fact that the xml structure is invalid you need to write a parser which inserts the links into MyPicsDB database.
Ex.:
Code:
-- create the root path
select max(idRoot)+1 from Rootpaths;
-- result is the first value of insert (in this case the 5)
insert into Rootpaths values (5, 'http://media.cdn.t24.com.tr/media/papers/full', 1, 1, 0);

-- create the entry for the first folder
insert into Folders values(null, 'full', null, 'http://media.cdn.t24.com.tr/media/papers/full', 1);

-- insert the pictures
select max(idFolder) from Folders;
-- result is the first value of insert (in this case the 313)
insert into Files values(null, 313, 'http://media.cdn.t24.com.tr/media/papers/full', 'hurriyet_2013-12-18.jpg', 'pictures', curdate(), null,null,null,0);
insert into Files values(null, 313, 'http://media.cdn.t24.com.tr/media/papers/full', 'sabah_2013-12-18.jpg', 'pictures', curdate(), null,null,null,0);
insert into Files values(null, 313, 'http://media.cdn.t24.com.tr/media/papers/full', 'vatan_2013-12-18.jpg', 'pictures', curdate(), null,null,null,0);
insert into Files values(null, 313, 'http://media.cdn.t24.com.tr/media/papers/full', 'posta_2013-12-18.jpg', 'pictures', curdate(), null,null,null,0);

commit;

Of course, the automatic scanning for new pictures won't work because (surprise) you get also an "access denied" error when accessing the path.
But MyPicsDB is able to display the four inserted pictures.


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

http://www.yenigazetesi.com/gazeteler/images.php?dosya_adi=19.12.2013/sozcu_191213.jpeg

images.php --> pictures url

dosya_adi --> folder name

19.12.2013 --> date of the newspapers folder

sozcu_ --> newspaper name

191213 --> date of newspaper

sorry for giving you headache :S


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

(2013-12-19, 14:06)risigvalue Wrote: images.php --> pictures url

A source contains files (in our case pictures).
A source lists these files like a directory in a filesystem!
Calling http://www.yenigazetesi.com/gazeteler/images.php doesn't do anything.

Suggestion: Install Apache with mod_dav and then create a picture source within XBMC using "dav://server/directory" as path.


RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - Xycl - 2014-01-06

MyPicsDB 12.3.1

available in my repository.

New:
  • Works with Gotham Alpha 10
  • New Language Files

script.module.dialogaddonscan and script.module.myconnpy don't work with Gotham but are/were needed by MyPicsDB.
Increasing their version number and changing xbmc.python to version 2.1.0 didn't work with december Gotham release.
Therefore I decided to include the needed code locally.


This forum uses Lukasz Tkacz MyBB addons.