Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Printable Version +- Kodi Community Forum (https://forum.kodi.tv) +-- Forum: Development (https://forum.kodi.tv/forumdisplay.php?fid=32) +--- Forum: Add-ons (https://forum.kodi.tv/forumdisplay.php?fid=26) +--- Thread: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db (/showthread.php?tid=80845) |
RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Joooonaaaas - 2012-05-06 Thanks for your quick reply Xycl. I decided to try the \\server\share\folder approach since my NAS does not support AFP. This was however not as easy as I hoped it would be. First I tried adding the path through the XBMC add source command, secondly I tried to enter the path directly in the sources.xml file where XBMC seams to store all available sources. Either way I was not able to use the path in the mypicsdb addon (it seams like xbmc automatically changes all '\' into '/' but I am not sure this is the main reason it won't work). I also spent some time looking for a list of paths for the my pictures database similar to sources.xml but I could not find it. Is there anyone who has any idea to overcome this problem? RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - fungify - 2012-05-10 (2012-05-05, 11:39)Xycl Wrote: 1)I agree. The right approach would IMO be to consolidate (all) the lists - so that "Bear, Car, House" and "Bear, Jack, Jill" would equal "Bear, Car, House, Jack, Jill". (2012-05-05, 11:39)Xycl Wrote: I don't know what's wrong with your picture. That is so strange. I'm using Windows Live Photo Gallery to tag the pictures, so I'm hoping that isn't the issue. Will test a lot more and get back with info. EDIT: Well - solved that problem. I deleted the captions with WLGP and re-inserted them again, and this time they were written correctly. Bizarre considering that is was WLPG that wrote the captions in the first place. FFY RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - mikebzh44 - 2012-05-16 Xycl, here is the full translation of strings.xml for French : http://xbmclogs.com/show.php?id=2660 RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - mikebzh44 - 2012-05-16 There is a little mistake in French translation given previous post : Correct translation Code: <string id="30209">Ajouté ces %s derniers jours</string> Is there a way to edit metadat from the addon ? For example, to add personn, category, keywords, ... If not, how to add those metadata to pictures ? RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Xycl - 2012-05-16 Tagging software Windows:
Other OS: Don't know. RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - fungify - 2012-05-25 Hi Xycl Need a bit of help. I'm trying to script a nightly update of the image-database, but am having some problems finding the right command to start a scan. Do I need to call scanpath.py directly, or ? Which action / command is the right one for update all paths in database and add new pictures and remove deleted ones? FFY RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Xycl - 2012-05-25 Hi Fungify, you only can start the scan from within XBMC. The command is: Code: RunScript("C:\Users\Name\AppData\Roaming\XBMC\addons\plugin.image.mypicsdb\scanpath.py",--database) You must use the full quailified path! Xycl RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - fungify - 2012-05-25 (2012-05-25, 17:13)Xycl Wrote: you only can start the scan from within XBMC.Actually - no The command you gave me works as a treat. I use wget and have scheduled a task that each night runs the following: Code: c:\_scripts\wget --directory-prefix=tmp --http-user=<xbmc username> --http-passwd=<xbmc password> "http://serveren:6500/xbmcCmds/xbmcHttp?command=ExecBuiltIn¶meter=XBMC.RunScript("<full path to plugin>\plugin.image.mypicsdb\scanpath.py",--database) Now my pictures database is automatically updated - no matter if it is me or my wife that has added or deleted pictures. Thanks for your help. FFY RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Xycl - 2012-05-26 Cool idea to use the HTTP api Xycl RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - mikebzh44 - 2012-05-30 Get an issue on OpenELEC 1.95.4 when adding somes pictures with accentueted names. For exemple : /storage/pictures/Coté.JPG I have put some debug in your code : Code: 21:21:30 T:140391854565120 NOTICE: MyPicsDB >> SQL > SELECT DISTINCT strPath FROM files So picfile is a string variable and contains Cot\xc3\xa9.JPG instead of Coté.JPG But it's quite strange because Fmronan used your addon under Ubuntu and I know that he get some accents in directories names and his pictures were scanned with no problems. He can't do more tests has he's upgrading his HTPC (HDD -> SSD). Are your running under Linux ? Did you have try with german letters in path or picture name ? RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Xycl - 2012-05-31 (2012-05-30, 21:33)mikebzh44 Wrote: So picfile is a string variable and contains Cot\xc3\xa9.JPG instead of Coté.JPG Hi Mikael, what do you see when using a console window? I mean do a "ls /storage/pictures". I'm pretty sure that the ls command don't list Coté but something else. I tried it with XBMCuntu in a VMWare session. When copying pictures from windows to ubuntu with winscp (protokoll scp) all unicode characters get lost because scp doesn't support utf-8 encoding, but Winscp displayed them correctly! When using Winscp with protokoll SFTP everything worked. Xycl RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - mikebzh44 - 2012-05-31 I have copy Coté.JPG and other files from my Windows 7 laptop to my OpenELEC HTPC using SMB sharing. On a puTTy terminal, I get : Code: root ~ # cd /storage/pictures/ But XBMC display good names : After changing my puTTy settings (Latin-1 to UTF-8), ls is OK : Code: root ~/pictures # ls -l How my openelec is set up by default : Code: root ~/.xbmc/temp # locale And now, scanning is KO : Code: 06:34:32 T:140422180857664 ERROR: Control 2006 in window 13000 has been asked to focus, but it can't Rename Coté.JPG to Cote.JPG and Arrière.JPG to Arriere.JPG and everything is OK. Has I never use accented characters in path or filename, it doesn't matter but I want to try my mods under Linux. RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Xycl - 2012-05-31 Please try: MyPicsDB 0.7.1.1 Beta It works with XBMCbuntu flawless. RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - mikebzh44 - 2012-05-31 I will try it this evening. I will install XBMCbuntu also on my HTPC for tests. Thanks. RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - fungify - 2012-05-31 Shouldn't this thread be moved to the forum Picture Add-ons? I would think that many users would like to try the addon, but simple doesn't know it exists. One of the participants of GSOC even seems to be coding a new image database - probably because he didn't know this one exists and works quite well. And another idea - It would be great to have a widget that could display the latest images added. Unfortunately I have no idea where to start, but someone else might? FFY |