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 - greeknl - 2013-02-28

Sounds nice,
But a few questions pop up:
- don't you inevitably end up with lots of overlapping picture sets? (year 2012, summer 2012, winter 2012, 2 week vacation 2012, Xmas holidays 2012, and so on)
what about if e.g. the Xmas holidays is from Dec 20, 2012 until Jan 05, 2013?
- can you filter using multiple sets?
- can you save a particular filter? (as long as set is also stored)

But then again, maybe better to try your new version first. so looking forward....


edit: just downloaded new version 2.0.5 and playing with it. Looks nice!

after playing a bit I noticed:
1 - Collection (waiting for updates to see what you have in mind), but promising if it can be used in filtering
2 - The manual input procedure for data range need some tweaking, cant see what i am entering, maybe wider input box (also make clear what you enter, month day year, because different input sequence for different countries
3 - when displaying the data range can you add in front of saved range the number of pics in the range
4 - maybe use simple form for selecting data range. (if you have over 10 years of pictures the list for selecting start and end date will be enormously long)
5 - The browse by folder method shows only the source, not the actual folders within this source which would be nice.
6 - when loading or saving filter it would be nice if the said filter name would be displayed in a nice color
7 - in the filter wizard please split the YYYY-MM option, because as it is now it lists every month over the years (long list if you have a 10-year collection)

I hope you understand my points mentioned. I dont want to sound like I do not appreciate the work you've put into this. I do. But an outsider always sees thing differently that the inventor (in my line of work this helps a lot when improving procedures and reporting standards)


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

(2013-02-28, 13:57)greeknl Wrote: Sounds nice,
But a few questions pop up:
- don't you inevitably end up with lots of overlapping picture sets? (year 2012, summer 2012, winter 2012, 2 week vacation 2012, Xmas holidays 2012, and so on)
what about if e.g. the Xmas holidays is from Dec 20, 2012 until Jan 05, 2013?
With the picture sets you'll be able to enter a start and end date instead of a stored period.
I always tag my pictures with keywords like "vacation 2012", "child 1st school year" or "Xmas 2011". I know it's a lot of work to tag "Xmas 1799" till "Xmas 2100" but it helps.Wink
And if you tagged keyword="vacation 2012" with cities="London" and "Madrid" then it's easy to select the holiday pictures you want to see. No need to limit the selection with dates.

(2013-02-28, 13:57)greeknl Wrote: - can you filter using multiple sets?
Not in the beginning

(2013-02-28, 13:57)greeknl Wrote: - can you save a particular filter? (as long as set is also stored)
Yes, since version 2.0.5 but currently of course without a set.

(2013-02-28, 13:57)greeknl Wrote: after playing a bit I noticed:
2 - The manual input procedure for data range need some tweaking, cant see what i am entering, maybe wider input box (also make clear what you enter, month day year, because different input sequence for different countries
It's an XBMC dialog box. No chance to change it. (I think so)

(2013-02-28, 13:57)greeknl Wrote: 3 - when displaying the data range can you add in front of saved range the number of pics in the range
Yes, but has not a very high priority.

(2013-02-28, 13:57)greeknl Wrote: 4 - maybe use simple form for selecting data range. (if you have over 10 years of pictures the list for selecting start and end date will be enormously long)
That's true, but you can enter the dates manually and other users like the list.

(2013-02-28, 13:57)greeknl Wrote: 5 - The browse by folder method shows only the source, not the actual folders within this source which would be nice.
Don't know what you mean. Select a source and you see the folders.

(2013-02-28, 13:57)greeknl Wrote: 6 - when loading or saving filter it would be nice if the said filter name would be displayed in a nice color
I hate designing GUIs, but displaying the name of the used filter would be nice.

(2013-02-28, 13:57)greeknl Wrote: 7 - in the filter wizard please split the YYYY-MM option, because as it is now it lists every month over the years (long list if you have a 10-year collection)
This tag is only a test. I don't think that it makes sense because if you want to see pictures from 2 months with child1 and child2 then you cannot use this new tag because you need an OR condition for the 2 months and an AND condition for the 2 children. The filter wizard doesn't support this.


RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - greeknl - 2013-03-01

(2013-02-28, 20:02)Xycl Wrote:
(2013-02-28, 13:57)greeknl Wrote: after playing a bit I noticed:
2 - The manual input procedure for data range need some tweaking, cant see what i am entering, maybe wider input box (also make clear what you enter, month day year, because different input sequence for different countries
It's an XBMC dialog box. No chance to change it. (I think so)
I really hope this can be change, cause this input box is not really user friendly. I assume you get the same as me.

(2013-02-28, 20:02)Xycl Wrote:
(2013-02-28, 13:57)greeknl Wrote: 4 - maybe use simple form for selecting data range. (if you have over 10 years of pictures the list for selecting start and end date will be enormously long)
That's true, but you can enter the dates manually and other users like the list.
fair enough

(2013-02-28, 20:02)Xycl Wrote:
(2013-02-28, 13:57)greeknl Wrote: 5 - The browse by folder method shows only the source, not the actual folders within this source which would be nice.
Don't know what you mean. Select a source and you see the folders.
I have added a path to database a source which contains subfolders. When i select browse by folder it shows me the source with the number of pictures in it and when i click on that it only shows me the parent directory (the two dots ..) and no subdirectories

(2013-02-28, 20:02)Xycl Wrote:
(2013-02-28, 13:57)greeknl Wrote: 6 - when loading or saving filter it would be nice if the said filter name would be displayed in a nice color
I hate designing GUIs, but displaying the name of the used filter would be nice.
Nice, this would help a lot to see what filter is active (after resetting it should disappear of course)

(2013-02-28, 20:02)Xycl Wrote:
(2013-02-28, 13:57)greeknl Wrote: 7 - in the filter wizard please split the YYYY-MM option, because as it is now it lists every month over the years (long list if you have a 10-year collection)
This tag is only a test. I don't think that it makes sense because if you want to see pictures from 2 months with child1 and child2 then you cannot use this new tag because you need an OR condition for the 2 months and an AND condition for the 2 children. The filter wizard doesn't support this.
Yeah i can imagine that AND OR filtering would be nasty.
I really like the YYYY-MM option, and I think others will too.
But as it is now you either select "Match all tags" (meaning AND to all selections) or you dont select it (meaning OR to all conditions).
However for the dates the only logical filtering option is OR, there is only one date per picture.
So with "Match all tags" off -> (child1 OR child2 OR month1 OR month2)
with "Match all tags" on -> (child1 AND child2) AND (month1 OR month2)
But you say this isnt supported, so maybe the dates tag should be treated as a range -> (child1 AND child2) AND (date BETWEEN month1-year1 AND month2-year2) or otherwise
child1 AND child2 AND date>month1-year1 AND date<month2-year2.
This poses however a difficulty on the wizard. but maybe a workaround is to use saved date ranges


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

(2013-03-01, 09:38)greeknl Wrote:
(2013-02-28, 20:02)Xycl Wrote:
(2013-02-28, 13:57)greeknl Wrote: after playing a bit I noticed:
2 - The manual input procedure for data range need some tweaking, cant see what i am entering, maybe wider input box (also make clear what you enter, month day year, because different input sequence for different countries
It's an XBMC dialog box. No chance to change it. (I think so)
I really hope this can be change, cause this input box is not really user friendly. I assume you get the same as me.
You mean this box? I think it's very usable.

Image

(2013-03-01, 09:38)greeknl Wrote:
(2013-02-28, 20:02)Xycl Wrote:
(2013-02-28, 13:57)greeknl Wrote: 5 - The browse by folder method shows only the source, not the actual folders within this source which would be nice.
Don't know what you mean. Select a source and you see the folders.
I have added a path to database a source which contains subfolders. When i select browse by folder it shows me the source with the number of pictures in it and when i click on that it only shows me the parent directory (the two dots ..) and no subdirectories
After selecting one of the sources in "Browse by folder":
Image
Did you forget to set the scan to be recursive?
Because otherwise pictures in subdirectories won't be scanned.

(2013-03-01, 09:38)greeknl Wrote:
(2013-02-28, 20:02)Xycl Wrote:
(2013-02-28, 13:57)greeknl Wrote: 7 - in the filter wizard please split the YYYY-MM option, because as it is now it lists every month over the years (long list if you have a 10-year collection)
This tag is only a test. I don't think that it makes sense because if you want to see pictures from 2 months with child1 and child2 then you cannot use this new tag because you need an OR condition for the 2 months and an AND condition for the 2 children. The filter wizard doesn't support this.
Yeah i can imagine that AND OR filtering would be nasty.
I really like the YYYY-MM option, and I think others will too.
But as it is now you either select "Match all tags" (meaning AND to all selections) or you dont select it (meaning OR to all conditions).
However for the dates the only logical filtering option is OR, there is only one date per picture.
So with "Match all tags" off -> (child1 OR child2 OR month1 OR month2)
with "Match all tags" on -> (child1 AND child2) AND (month1 OR month2)
But you say this isnt supported, so maybe the dates tag should be treated as a range -> (child1 AND child2) AND (date BETWEEN month1-year1 AND month2-year2) or otherwise
child1 AND child2 AND date>month1-year1 AND date<month2-year2.
This poses however a difficulty on the wizard. but maybe a workaround is to use saved date ranges
The Filter Wizard is quite complex.
Will try to except the YYYY-MM from AND condition.
I don't know if it will work, but if it works then I'll divide the tag into two tags for years and months.


RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - greeknl - 2013-03-01

Wow, it appears totally different on my screen.
I changed skin back to confluence and all ok. I used aeon nox (no cancel buttton?)

I scanned recursively, all pictures are present but still cannot see the directories.
when going to path of picture folder - add a folder to exclude and select a source i can see all subdirectories just fine.
I will fiddle a bit and maybe find the cause.
edit: i initialised the database on start up, removed all source and rescanned. Now the folder show.

Thank you for the YYYY-MM trial. Keep my fingers crossed


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

I have a little question :

what's the way to use mypicsdb collections ?
I understand it's possible to create a collection and add pics but is it possible to create a list of pics and to add it to a collection.

Because I use picasa 3 (essentially to modidy my pics), it's easy to create an album. I don't find a simply way to extract this album but it's possible to create an html file of an album. A very short example is presented below:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>albumtest1</title>
<link rel="stylesheet" href="style.css" type="text/css">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<span class="textbg">albumtest1 (3 images)</span><br>
<span class="textsm"></span>
<p class="desc"><p><span class="textreg">Cliquez sur une photo pour obtenir une vue agrandie.</span><br>
<hr size="1">
<a href="target0.html"><img align="center" src="thumbnails/img4812.jpg" width="154" height="106" title="img4812.jpg" border="0"></a>
<a href="target1.html"><img align="center" src="thumbnails/img_4813.jpg" width="154" height="106" title="img_4813.jpg" border="0"></a>
<a href="target2.html"><img align="center" src="thumbnails/img_5546_500x333.jpg" width="154" height="106" title="img_5546_500x333.jpg" border="0"></a>
<map name="Map">
<area shape="rect" coords="95,1,129,44" href="frameset.htm">
</map>
</body>
</html>

there is the title (here albutest1) and the pics of the album (here mg4812.jpg, img_4813.jpg, /img_5546_500x333.jpg). It's also possible to create an xml rather than html.

The idea will be to construct a collection from this kind of files.

Is it possible or a crazy idea ?

Thanks.


RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - greeknl - 2013-03-02

Have a look here:
http://www.anvo-it.de/wiki/avpicfacexmptagger:main


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

@greeknl: very nice soft I have tried too (but not easy to understand), but I'm not sure it can solve my problem.
This soft can only change person tags from picassa format to picture format (even it realise his job very well).
It can't work with albums Wink


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

error


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

(2013-03-02, 13:25)herve502 Wrote: The idea will be to construct a collection from this kind of files.

Is it possible or a crazy idea ?

Thanks.
Basically it would be possible if someone writes an import interface for the html/xml file.
I'm really open for enhancements done by users/developers, but I won't do it.Tongue
I encourge everyone to fork MyPicsDB, learn Python and then to help me improving MyPicsDB.


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

I understand Nod I hope my demand does'nt take an offense for you. Otherwise, I apologize.

Why not to realise an import button in category. I know a few programmation... but i have to learn python. For an elder, it is not possible in some days Cool.
We come back in some few days, oppss ... weeks Tongue In a first time, I try to decode a little your code to know my abbilities.

[EDIT] I read some .py, ouch it's hard Rolleyes!


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

Everything is okay, but I don't have the time to do it.

I like the idea to enhance MyPicsDB and I like the idea to import already available data from other programms like Picasa.
Look at first at the database. You've to create an Entry in table "Collection" and then fill table "FilesInCollections".
We assume that the files are already inserted into the database Wink
"All" you've to do is to find the mentioned picture from xml/html file in table Files and to insert the idFile key into table FilesInColletions.


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

I really Hope I will have a success for this operation. Just time is needed betwen children / house to finish / and geek wich want to work but i will found it!

Thanks for the first idea. Perharps (I'm sure if you are agree of course), I will contact you for some information.

Cheers RV


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

(2013-03-04, 00:05)herve502 Wrote: Just time is needed betwen children / house to finish ...

That's my problem, too. Wink


RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - greeknl - 2013-03-13

you removed the YYYY-MM from filter?


This forum uses Lukasz Tkacz MyBB addons.