Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db

  Thread Rating:
  • 2 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Closed
fmronan Offline
Fan
Posts: 600
Joined: Dec 2010
Reputation: 4
Post: #286
with 0.6.3, the script run and scan but after that every are empty.
same with 0.6.4Confused, no pictures, just one movie .avi , strange
(This post was last modified: 2012-03-27 20:35 by fmronan.)
find
Xycl Offline
Fan
Posts: 351
Joined: Feb 2012
Reputation: 7
Location: Germany
Post: #287
(2012-03-27 19:33)fiveisalive Wrote:  I wonder if you'd consider putting up your repo:

http://www.xycl.de/xbmc/repository.xycl....dharma.zip

on the list at:

http://wiki.xbmc.org/index.php?title=Uno...positories

that way the Repositories Installer Add-on can more easily install it. I had to manually search for the link to the zip file from your site, manually download it, then install it within XBMC. Thanks.

Done

No log no help.
How to submit a log file: XBMC-Wiki

Main page: https://github.com/Xycl
Repository: Xycl Repository
find
Xycl Offline
Fan
Posts: 351
Joined: Feb 2012
Reputation: 7
Location: Germany
Post: #288
(2012-03-27 20:30)fmronan Wrote:  with 0.6.3, the script run and scan but after that every are empty.
same with 0.6.4Confused, no pictures, just one movie .avi , strange

Something in log file?

I deleted:
1) the archived zip file in addons/pakages directory
2) the directory addons/plugin.image.mypicsdb
3) userdata/Database/MyPictures.db

Then I installed from my repo mypicsdb and everything works.

Please open addons/plugin.image.mypicsdb/lib/resources/MypicsDB.py in an editor and find
PHP Code:
def DB_cleanup_keywords(): 
There should be the lines
PHP Code:
#cn.execute( "delete from TagsInFiles where idFile not in(select idFile from Files )")
#cn.execute( "delete from Tags where idTag not in (select idTag from TagsInFiles)") 
Important is the # at the beginning.

If there is a # then please delete your scanned path in mypicsdb and add it again.

No log no help.
How to submit a log file: XBMC-Wiki

Main page: https://github.com/Xycl
Repository: Xycl Repository
(This post was last modified: 2012-03-27 21:08 by Xycl.)
find
TPXBMC Offline
Junior Member
Posts: 2
Joined: Mar 2012
Reputation: 0
Post: #289
Hi,

Does anyone know if there is a way to do an advanced search on the pictures. I haven't found a way yet. For Example:

-Pictures with Tag: Vacation and Tag: Mexico
-Pictures with Tag:Kids Name, Tag Birthday, Date range 2005-2008

So far the Global search does not seem to allow multiple phrases but perhaps I don't know the proper syntax. Even a view by tag within view by tag function would be good.

Thanks.
find
Xycl Offline
Fan
Posts: 351
Joined: Feb 2012
Reputation: 7
Location: Germany
Post: #290
(2012-03-28 01:32)TPXBMC Wrote:  Hi,

Does anyone know if there is a way to do an advanced search on the pictures. I haven't found a way yet. For Example:

-Pictures with Tag: Vacation and Tag: Mexico
-Pictures with Tag:Kids Name, Tag Birthday, Date range 2005-2008

So far the Global search does not seem to allow multiple phrases but perhaps I don't know the proper syntax. Even a view by tag within view by tag function would be good.

Thanks.

(2012-03-26 22:16)Xycl Wrote:  Suggestion for further development:
.....

3)
An advanced filter. Perhaps a wizard.
Select pictures from country abc with keyword xyz containing person def. Needs 1) otherwise it's not maintainable.

Any opinions?

Therefore currently the answer is no.

No log no help.
How to submit a log file: XBMC-Wiki

Main page: https://github.com/Xycl
Repository: Xycl Repository
find
fmronan Offline
Fan
Posts: 600
Joined: Dec 2010
Reputation: 4
Post: #291
french translation

http://glass.googlecode.com/files/strings.xml
find
fmronan Offline
Fan
Posts: 600
Joined: Dec 2010
Reputation: 4
Post: #292
every thing works fine added 0.6.5 to repo passion
find
fmronan Offline
Fan
Posts: 600
Joined: Dec 2010
Reputation: 4
Post: #293
I can't adde the 0.6.5 because the repo said problem with stringsHuh
find
Xycl Offline
Fan
Posts: 351
Joined: Feb 2012
Reputation: 7
Location: Germany
Post: #294
(2012-03-28 11:16)fmronan Wrote:  I can't adde the 0.6.5 because the repo said problem with stringsHuh

Have you problems installing 0.6.5 in XBMC or problems adding mypicdb to your repo?

No log no help.
How to submit a log file: XBMC-Wiki

Main page: https://github.com/Xycl
Repository: Xycl Repository
find
fmronan Offline
Fan
Posts: 600
Joined: Dec 2010
Reputation: 4
Post: #295
adding in the repo, works fine in xbmc, I do not understand because i can added the 0.6.2
find
fmronan Offline
Fan
Posts: 600
Joined: Dec 2010
Reputation: 4
Post: #296
Adding, the problem is my .zipConfused
find
fungify Offline
Senior Member
Posts: 143
Joined: Jul 2010
Reputation: 2
Post: #297
A few bugs I've encountered.

Adding a folder to exclude leads to GUI lockup for many seconds. When GUI responds again the chosen folder is not excluded. Repeating the proces does not lead to lock up, and the folder is excluded. I've tried deleting image-database, enabling debug, restarted XBMC and added a folder and two folder to exclude. Pastebin here: http://pastebin.com/9vDKi5wN

I've noticed problems with large number of photos as well. I've added several thousand photos, most of which are tagged with person and keywords. When selecting a person with a large number of images (>800) the addon throws an error. This does not happen when there is a smaller number of images attached to the person. Will post pastebin as soon as I've completed a rescan of the images.

FFY
(This post was last modified: 2012-03-28 12:09 by fungify.)
find
Xycl Offline
Fan
Posts: 351
Joined: Feb 2012
Reputation: 7
Location: Germany
Post: #298
(2012-03-28 12:08)fungify Wrote:  Adding a folder to exclude leads to GUI lockup for many seconds. When GUI responds again the chosen folder is not excluded. Repeating the proces does not lead to lock up, and the folder is excluded. I've tried deleting image-database, enabling debug, restarted XBMC and added a folder and two folder to exclude. Pastebin here: http://pastebin.com/9vDKi5wN

I've the same problems. When selecting a directory, either to include or exclude, sometimes a progress dialog appears. Then you can be sure that it doesn't work.
Perhaps someone with more Python knowledge than me can have a look at show_roots() in default.py.
Currently I'm not able to find the reason for this progress dialog.

(2012-03-28 12:08)fungify Wrote:  I've noticed problems with large number of photos as well. I've added several thousand photos, most of which are tagged with person and keywords. When selecting a person with a large number of images (>800) the addon throws an error. This does not happen when there is a smaller number of images attached to the person. Will post pastebin as soon as I've completed a rescan of the images.

Alexsolex added a paging to the plugin. Annoyingly, this seems to be not fully implemented. You can set the max number of displayed pictures in the preference dialog of mypicdb to 100.000. Perhaps this will help.

No log no help.
How to submit a log file: XBMC-Wiki

Main page: https://github.com/Xycl
Repository: Xycl Repository
find
fungify Offline
Senior Member
Posts: 143
Joined: Jul 2010
Reputation: 2
Post: #299
(2012-03-28 14:18)Xycl Wrote:  I've the same problems. When selecting a directory, either to include or exclude, sometimes a progress dialog appears. Then you can be sure that it doesn't work.
Perhaps someone with more Python knowledge than me can have a look at show_roots() in default.py.
Currently I'm not able to find the reason for this progress dialog.
Exactly what I'm experiencing. Hope someone casts some light on this bug.
(2012-03-28 14:18)Xycl Wrote:  Alexsolex added a paging to the plugin. Annoyingly, this seems to be not fully implemented. You can set the max number of displayed pictures in the preference dialog of mypicdb to 100.000. Perhaps this will help.
Tried playing around with it, but unfortunately it seemed to have no difference what so ever.

On a related note - I would like to help with the Danish translations, but I can't seem to find the strings to translate?

EDIT: Can anyone confirm that adding excluded folders before scanning dramatically increases scanning time? As is - hours suddenly. Working on the fourth hour to scan my 7-8 thousand pictures for the first time - each picture taking 5-10 seconds to add to the database.

FFY
(This post was last modified: 2012-03-28 21:38 by fungify.)
find
Xycl Offline
Fan
Posts: 351
Joined: Feb 2012
Reputation: 7
Location: Germany
Post: #300
(2012-03-28 20:33)fungify Wrote:  On a related note - I would like to help with the Danish translations, but I can't seem to find the strings to translate?

Plugin directory in resource language. Take the english one.

(2012-03-28 20:33)fungify Wrote:  EDIT: Can anyone confirm that adding excluded folders before scanning dramatically increases scanning time? As is - hours suddenly. Working on the fourth hour to scan my 7-8 thousand pictures for the first time - each picture taking 5-10 seconds to add to the database.

Yes, an excluded directory is not scanned.
My Laptop scans several pictures per second (i7 2620m) but the pictures have a resolution of only 5 MPixels.
I know that the larger the pictures are the longer it will take to scan them.

EDIT: And I know that even videos are scanned. This takes a very long time.

No log no help.
How to submit a log file: XBMC-Wiki

Main page: https://github.com/Xycl
Repository: Xycl Repository
(This post was last modified: 2012-03-29 10:16 by Xycl.)
find
Thread Closed