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 - denywinarto - 2012-07-11

Sorry if its a little out of topic, but can your script be used for listing 10 last movies /episodes from a specific folder? The default recently added functions mixes all movies / episodes into one. While i have several custom favourites (Asian movie, west movie, west serial, cartoom, etc) and i want them to have separate recently added.


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

No this is not possible


RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - mikebzh44 - 2012-07-11

Hi Deny.

I didn't say that MyPicsDB can solve your problem but that someone have to write an addon similar to MyPicsDB that scan folder for videos and make is own database in order to get last added movies :

http://forum.xbmc.org/showthread.php?tid=122448&pid=1144475#pid1144475

So if you have any skill in Python, you can try Wink


RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - mikebzh44 - 2012-07-23

Hi Xycl.

I was looking to Deny WINATRO problem.

I think that MyPicsDB can do the job as you can scan for videos and not only for pictures with your addon.

I have add .MKV extension to scann some HD movies, your script work and I can display recently added movies but scanning is VEEEEEERRRRRY long.

And my HDD is 100% used (led is not blinking but always light on). It's like your script is scanning every MKV file (and with 4 Gb files, it's take time).

Can you tell me where such a scan can be desable in your code ?


RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - Xycl - 2012-07-24

Hi Mikebzh44,

I never used the video functionality.
If the code tries to get picture tags from a video then this is bad.
But it should not be very difficult to stop this behavior.


RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - mikebzh44 - 2012-07-24

Slowing down is due to function MPDB.fileSHA :

Code:
"sha":str(MPDB.fileSHA(join(dirname,picfile))),

If I mod the fileSHA function :

Code:
data = file.read(65536)
        digest.update(data)
        """
        while len(data) != 0:
            digest.update(data)
            data = file.read(65536)
        """
        file.close()

scan is very fast (as fast as for pictures) but movies are not inserted into DB :

Code:
13:21:08 T:3444   ERROR: MyPicsDB >> >>> DB_file_insert ...
13:21:08 T:3444   ERROR: MyPicsDB >> <type 'exceptions.Exception'> - table files has no column named EXIF DateTimeOriginal
13:21:08 T:3444   ERROR: MyPicsDB >> INSERT INTO files('sha','DateAdded','mtime','strFilename','UseIt','EXIF DateTimeOriginal','strPath','ftype','idFolder') values (?,?,?,?,?,?,?,?,?)
13:21:08 T:3444   ERROR: MyPicsDB >>



RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - Xycl - 2012-07-25

The error is indepent from your changes.
I don't know when I'll get the time to correct it.
Perhaps next week.


RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - mikebzh44 - 2012-07-25

Take your time. I guess that anybody use this addon for movies actually so ... Big Grin


RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - Xycl - 2012-07-30

(2012-07-11, 00:47)Robotica Wrote: XBMC sorts on file date(See code; DateTime class, which uses FILETIME as it's base.) not on EXIF-date, which is much more usefull for pictures (i.e. many file dates are changed moving pictures around, definetly by FTP). So using default XBMC views requires a patch for this (is possible since XBMC also contains an EXIF parser) or plugins should create their own views with sorting based on EXIF data.


See also: http://trac.xbmc.org/ticket/10519


I had the time to look into the source code. MyPicsDB sets the "date" infolabel which means that the real EXIF date is used.
Confluence skin shows the date on the right list view side when sorting by date.
Problem: You can only set the date but not the time!


RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - Xycl - 2012-07-30

Version 0.9.2
Update: Sha not calculated for videos


RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - mikebzh44 - 2012-07-30

Version 0.9.2 also available on Passion-XBMC repository :

http://passion-xbmc.org/addons/?Page=View&ID=plugin.image.mypicsdb

I will have a look on videos tomorrow.

Thanks.


RE: [RELEASE] MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags - fiveisalive - 2012-07-31

(2012-07-30, 19:53)Xycl Wrote:
(2012-07-11, 00:47)Robotica Wrote: XBMC sorts on file date(See code; DateTime class, which uses FILETIME as it's base.) not on EXIF-date, which is much more usefull for pictures (i.e. many file dates are changed moving pictures around, definetly by FTP). So using default XBMC views requires a patch for this (is possible since XBMC also contains an EXIF parser) or plugins should create their own views with sorting based on EXIF data.


See also: http://trac.xbmc.org/ticket/10519


I had the time to look into the source code. MyPicsDB sets the "date" infolabel which means that the real EXIF date is used.
Confluence skin shows the date on the right list view side when sorting by date.
Problem: You can only set the date but not the time!

Right, that was exactly my understanding. It is using the EXIF date (not the file date), but not the time within the EXIF. You can tell if you try to get info on each picture within the default pics app, it only shows the date, but not the time. So I infer from this that if time support was added to the EXIF support in core XBMC, that this would just automatically make this add-on "Do The Right Thing". The question is, in the meantime, is there any potential to code a workaround within the add-on. (I did try the "Default" sort, which works sort of, but has the problem that the add-on seems to forget about your setting when you leave and re-enter a particular directory. It also has the issue that the date information is not used in the Label2 field if you use the "Default" sort).



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

French translation for 0.9.2 with new strings for wizard and tag translation :

http://xbmclogs.com/show.php?id=5959


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

(2012-07-31, 19:48)fiveisalive Wrote: Right, that was exactly my understanding. It is using the EXIF date (not the file date), but not the time within the EXIF. You can tell if you try to get info on each picture within the default pics app, it only shows the date, but not the time. So I infer from this that if time support was added to the EXIF support in core XBMC, that this would just automatically make this add-on "Do The Right Thing". The question is, in the meantime, is there any potential to code a workaround within the add-on. (I did try the "Default" sort, which works sort of, but has the problem that the add-on seems to forget about your setting when you leave and re-enter a particular directory. It also has the issue that the date information is not used in the Label2 field if you use the "Default" sort).

No, that's not correct.
Like Robotica already said XBMC uses the file date when sorting pictures by date.
But MyPicsDB uses the EXIF date.
The problem is that the date infolabel doesn't accept a timestamp.

To clarify:
The "Sort by date" of the view uses the so called date infolabel. XBMC fills it with the file date and MyPicsDB with the EXIF date.


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

Version 1.0.0 including needed script.module.dialogaddonscan (v 1.1.0) now in official XBMC repository.


This forum uses Lukasz Tkacz MyBB addons.