• 1
  • 3
  • 4
  • 5(current)
  • 6
  • 7
  • 53
Release MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags
#61
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.
Reply
#62
No this is not possible
No log no help.
Main page: https://github.com/Xycl
Repository: Xycl Repository Leia
Repository: Xycl Repository Matrix
Reply
#63
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...pid1144475

So if you have any skill in Python, you can try Wink
Sorry for my english, but, you know, I'm French so ...

Main HTPC : Odroid-C2 running CoreELEC with Titan Bingie
Secondary HTPC : Freebox Mini 4K running Android TV with Titan Bingie
Reply
#64
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 ?
Sorry for my english, but, you know, I'm French so ...

Main HTPC : Odroid-C2 running CoreELEC with Titan Bingie
Secondary HTPC : Freebox Mini 4K running Android TV with Titan Bingie
Reply
#65
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.
No log no help.
Main page: https://github.com/Xycl
Repository: Xycl Repository Leia
Repository: Xycl Repository Matrix
Reply
#66
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 >>
Sorry for my english, but, you know, I'm French so ...

Main HTPC : Odroid-C2 running CoreELEC with Titan Bingie
Secondary HTPC : Freebox Mini 4K running Android TV with Titan Bingie
Reply
#67
The error is indepent from your changes.
I don't know when I'll get the time to correct it.
Perhaps next week.
No log no help.
Main page: https://github.com/Xycl
Repository: Xycl Repository Leia
Repository: Xycl Repository Matrix
Reply
#68
Take your time. I guess that anybody use this addon for movies actually so ... Big Grin
Sorry for my english, but, you know, I'm French so ...

Main HTPC : Odroid-C2 running CoreELEC with Titan Bingie
Secondary HTPC : Freebox Mini 4K running Android TV with Titan Bingie
Reply
#69
(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!
No log no help.
Main page: https://github.com/Xycl
Repository: Xycl Repository Leia
Repository: Xycl Repository Matrix
Reply
#70
Version 0.9.2
Update: Sha not calculated for videos
No log no help.
Main page: https://github.com/Xycl
Repository: Xycl Repository Leia
Repository: Xycl Repository Matrix
Reply
#71
Version 0.9.2 also available on Passion-XBMC repository :

http://passion-xbmc.org/addons/?Page=Vie...e.mypicsdb

I will have a look on videos tomorrow.

Thanks.
Sorry for my english, but, you know, I'm French so ...

Main HTPC : Odroid-C2 running CoreELEC with Titan Bingie
Secondary HTPC : Freebox Mini 4K running Android TV with Titan Bingie
Reply
#72
(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).
Reply
#73
French translation for 0.9.2 with new strings for wizard and tag translation :

http://xbmclogs.com/show.php?id=5959
Sorry for my english, but, you know, I'm French so ...

Main HTPC : Odroid-C2 running CoreELEC with Titan Bingie
Secondary HTPC : Freebox Mini 4K running Android TV with Titan Bingie
Reply
#74
(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.
No log no help.
Main page: https://github.com/Xycl
Repository: Xycl Repository Leia
Repository: Xycl Repository Matrix
Reply
#75
Version 1.0.0 including needed script.module.dialogaddonscan (v 1.1.0) now in official XBMC repository.
No log no help.
Main page: https://github.com/Xycl
Repository: Xycl Repository Leia
Repository: Xycl Repository Matrix
Reply
  • 1
  • 3
  • 4
  • 5(current)
  • 6
  • 7
  • 53

Logout Mark Read Team Forum Stats Members Help
MyPicsDB: Pictures DB with EXIF, IPTC & XMP tags1