Most databases have odd behavior when working with dates,

If I remember correctly, MySQL stores datetime as a long integer and will convert the strings from the query to long int for processing it. However, I'm not sure about that and this approach should be way faster. A problem with the keys might be, that the primary key spans several fields and not only starttime, i.e., the key will probably be stored as a hash and not an integer.
A simple solution might be to modify the table to reflect a better structure for the mentioned query, e.g., by introducing another index for starttime, as also mentioned by gadget.

BUT, the table is not a pluto/LMCE table but a Myth table if I understand correctly. Is this correct? I think we should not alter these tables but rather use the vanilla packages.

Another approach could be to use an on-update/on-insert trigger to fill a temporary table with the required information.

Thom, do you know which query is used by MythTV itself?

MySQL isn't using any keys/indexes to process the query, you could try if it gets any better if you add a 'USE INDEX(starttime, endtime)' or even 'FORCE INDEX(starttime, endtime)'.

br,
/chriss

Me too

No, please do not overwrite an existing language! You have to add another entry to the database table pluto_main.Language. It should then show up in HADesigner.

HTH,
/chriss

BTW, I remember there were some things hardcoded, i.e. they couldn't be translated easily. Don't know, if that has been fixed yet...

murcel,
I'll check if I can find my old files somewhere on my harddisk tonight. They should still be in my DB at least...

/chriss

I did a german re-translation quite some time ago but I think it didn't make it into the regular builds yet. The files are in the old bug tracker and there's only a link left on Trac [1]. IMHO at least Hari has access to the old system. You should probably contact him, get the files and make a review of the translation...

br,
/chriss

[1] http://svn.linuxmce.org/trac.cgi/ticket/5

edit: there might also be an old thread on the dev forum.

Great idea!

Okay, did that for now.

edit: Ticket #217, http://svn.linuxmce.org/trac.cgi/ticket/217

Hi there,

I'm ready to integrate the first working patch (reading and mapping four EXIF attributes to LMCE media attributes). Since this will add another dependency (libexiv2/libexiv2-dev) I don't dare to just commit the changes to not break the build process. What do I have to doe to properly include the dependency?

thanks,
/chriss

Thom,

got that. But I think, a lot of this information is really useful when "managing" you photographs. On the other hand I would never use it to search photos from the frontend. I think we have to separate between the management which can easily be done on the backend, i.e. lmce admin or whatever, and the user interface of the frontend, i.e., orbiter.
This comes down to having only few attributes that need to be searchable or sortable by the frontend. Is there a way to exclude certain attributes from showing up on the orbiter? Maybe we could introduce another table field "hide_from_orbiter" or something?

/chriss

Hi there,

got the reading of EXIF attributes working. Thanks to exiv2 lib it's quite easy

Code:

10      05/24/09 16:20:38.175           Activating Pluto Media Identifier... <0xb6ac06c0>                           
10      05/24/09 16:20:38.176           Pluto Media Identifier activated. Extensions 27 <0xb6ac06c0>                 
10      05/24/09 16:20:38.176           MediaState::LoadDbInfo ready to run big query <0xb6ac06c0>                   
10      05/24/09 16:20:38.179           MediaState::LoadDbInfo got 2 rows <0xb6ac06c0>                               
10      05/24/09 16:20:38.179           UpdateMedia::ReadDirectory ./testdir <0xb6ac06c0>                           
10      05/24/09 16:20:38.180           UpdateMedia::ScanFiles dir ./testdir: files found: 1 <0xb6ac06c0>           
10      05/24/09 16:20:38.180           Need to update file because it's not in the database ./testdir/3.jpg <0xb6ac06c0>
10      05/24/09 16:20:38.180           Sync mode for ./testdir/3.jpg: modeBoth <0xb6ac06c0>                             
05      05/24/09 16:20:38.180           # PlutoMediaFile STARTED: dir ./testdir file 3.jpg <0xb6ac06c0>                 
10      05/24/09 16:20:38.180           # PhotoFileHandler::LoadAttributes: loading 0 attributes in the attribute file ./testdir/3.jpg <0xb6ac06c0>                                                                                                       
Exif.Image.Make                              0x010f Ascii      18  NIKON CORPORATION                                         
Exif.Image.Model                             0x0110 Ascii      11  NIKON D300                                               
Exif.Image.XResolution                       0x011a Rational    1  300/1                                                     
Exif.Image.YResolution                       0x011b Rational    1  300/1                                                     
Exif.Image.ResolutionUnit                    0x0128 Short       1  2                                                         
Exif.Image.Software                          0x0131 Ascii      28  Adobe Photoshop CS3 Windows                               
Exif.Image.DateTime                          0x0132 Ascii      20  2009:05:23 22:26:54                                       
Exif.Image.Artist                            0x013b Ascii      14  Janet Johnson                                             
Exif.Image.Copyright                         0x8298 Ascii      33  Copyright (C) 2009 Janet Johnson                         
Exif.Image.ExifTag                           0x8769 Long        1  276                                                       
Exif.Photo.ExposureTime                      0x829a Rational    1  1/320                                                     
Exif.Photo.FNumber                           0x829d Rational    1  11/1                                                     
Exif.Photo.ExposureProgram                   0x8822 Short       1  3                                                         
Exif.Photo.ISOSpeedRatings                   0x8827 Short       1  200                                                       
Exif.Photo.ExifVersion                       0x9000 Undefined   4  48 50 50 49                                               
Exif.Photo.DateTimeOriginal                  0x9003 Ascii      20  2009:05:23 15:16:28                                       
Exif.Photo.DateTimeDigitized                 0x9004 Ascii      20  2009:05:23 15:16:28                                       
Exif.Photo.ShutterSpeedValue                 0x9201 SRational   1  8321928/1000000                                           
Exif.Photo.ApertureValue                     0x9202 Rational    1  6918863/1000000                                           
Exif.Photo.ExposureBiasValue                 0x9204 SRational   1  0/6                                                       
Exif.Photo.MaxApertureValue                  0x9205 Rational    1  44/10                                                     
Exif.Photo.MeteringMode                      0x9207 Short       1  5                                                         
Exif.Photo.LightSource                       0x9208 Short       1  4                                                         
Exif.Photo.Flash                             0x9209 Short       1  0                                                         
Exif.Photo.FocalLength                       0x920a Rational    1  460/10                                                   
Exif.Photo.SubSecTimeOriginal                0x9291 Ascii       3  17                                                       
Exif.Photo.SubSecTimeDigitized               0x9292 Ascii       3  17                                                       
Exif.Photo.SensingMethod                     0xa217 Short       1  2                                                         
Exif.Photo.FileSource                        0xa300 Undefined   1  3                                                         
Exif.Photo.SceneType                         0xa301 Undefined   1  1                                                         
Exif.Photo.CFAPattern                        0xa302 Undefined   8  2 0 2 0 0 1 1 2                                           
Exif.Photo.CustomRendered                    0xa401 Short       1  0                                                         
Exif.Photo.ExposureMode                      0xa402 Short       1  0                                                         
Exif.Photo.WhiteBalance                      0xa403 Short       1  1                                                         
Exif.Photo.DigitalZoomRatio                  0xa404 Rational    1  1/1                                                       
Exif.Photo.FocalLengthIn35mmFilm             0xa405 Short       1  69                                                       
Exif.Photo.SceneCaptureType                  0xa406 Short       1  0                                                         
Exif.Photo.GainControl                       0xa407 Short       1  0                                                         
Exif.Photo.Contrast                          0xa408 Short       1  0                                                         
Exif.Photo.Saturation                        0xa409 Short       1  0                                                         
Exif.Photo.Sharpness                         0xa40a Short       1  2                                                         
Exif.Photo.SubjectDistanceRange              0xa40c Short       1  0                                                         
Exif.Thumbnail.Compression                   0x0103 Short       1  6                                                         
Exif.Thumbnail.XResolution                   0x011a Rational    1  72/1                                                     
Exif.Thumbnail.YResolution                   0x011b Rational    1  72/1                                                     
Exif.Thumbnail.ResolutionUnit                0x0128 Short       1  2                                                         
Exif.Thumbnail.JPEGInterchangeFormat         0x0201 Long        1  0                                                         
Exif.Thumbnail.JPEGInterchangeFormatLength   0x0202 Long        1  14557
10      05/24/09 16:20:38.208           MergePictures: merging 0 pictures from our tag with 0 pictures from PIC tags <0xb6ac06c0>
10      05/24/09 16:20:38.208           Processing path ./testdir, file 3.jpg. Found 0 attributes, 0 long attributes in file <0xb6ac06c0>

Now, the big question is how to do the attribute mapping. Please find a suggestion below. I listed all exif fields I would like to handle as well as a draft mapping to already existing AttributeType definitions. Any additions/changes you would like to see? All the other values will get their own AttributeType later on. BTW is there any problem with creating that much AttributeTypes?

Code:

ImageWidth
ImageLength
Orientation
DateTime -> Year
ImageDescription -> Title
Make
Model
Software
Artist -> Composer/Writer
UserComment
ExposureTime
FNumber
ExposureProgram
ISOSpeedRatings
ShutterSpeedValue
ApertureValue
BrightnessValue
ExposureBiasValue
MaxApertureValue
SubjectDistance
MeteringMode
LightSource
Flash
FocalLength
FlashEnergy
SceneCapturedType
GPSLatitude
GPSLongitude
GPSAltitude
GPSSpeed
GPSTrack
GPSImageDirection
GPSDestLatitude
GPSDestLongitude

br,
/chriss

Well, I'm working on it  Got my dev environment up, I'm able to compile UpdateMedia and currently I'm extending it to take care of exif data in jpg files... I'll keep you posted on how it goes.

/chriss

please send the output of lshwd not lshw

Oops, my fault...

Code:

00:00.0 Host bridge: VIA Technologies, Inc.|VT3351 Host Bridge (unknown)
00:00.1 Host bridge: VIA Technologies, Inc.|VT3351 Host Bridge (unknown)
00:00.2 Host bridge: VIA Technologies, Inc.|VT3351 Host Bridge (unknown)
00:00.3 Host bridge: VIA Technologies, Inc.|VT3351 Host Bridge (unknown)
00:00.4 Host bridge: VIA Technologies, Inc.|VT3351 Host Bridge (unknown)
00:00.5 IO(X)-APIC: VIA Technologies, Inc.|VT3351 I/O APIC Interrupt Controller (unknown)
00:00.7 Host bridge: VIA Technologies, Inc.|VT3351 Host Bridge (unknown)
00:01.0 PCI bridge: VIA Technologies, Inc.|[K8T890 North / VT8237 South] PCI Bridge (unknown)
00:02.0 PCI bridge: VIA Technologies Inc.|K8T890 PCI-to-PCI Bridge (unknown)
00:03.0 PCI bridge: VIA Technologies Inc.|K8T890 PCI-to-PCI Bridge (unknown)
00:03.1 PCI bridge: VIA Technologies Inc.|K8T890 PCI-to-PCI Bridge (unknown)
00:03.2 PCI bridge: VIA Technologies Inc.|K8T890 PCI-to-PCI Bridge (unknown)
00:03.3 PCI bridge: VIA Technologies Inc.|K8T890 PCI-to-PCI Bridge (unknown)
00:09.0 Multimedia controller: Philips Semiconductors|SAA7135HL Multi Media Capture Device (saa7134)
00:0a.0 Multimedia controller: Philips Semiconductors|SAA7135HL Multi Media Capture Device (saa7134)
00:0b.0 PCI bridge: Digital Equipment Corp.|DECchip 21152 (unknown)
00:0f.0 IDE interface: VIA Technologies Inc.|VT8237A SATA 2-Port Controller (unknown)
00:0f.1 IDE interface: VIA Technologies Inc.|VT82C586 IDE [Apollo] (via82cxxx)
00:10.0 USB Controller|UHCI: VIA Technologies Inc.|VT82C586B USB (uhci_hcd)
00:10.1 USB Controller|UHCI: VIA Technologies Inc.|VT82C586B USB (uhci_hcd)
00:10.2 USB Controller|UHCI: VIA Technologies Inc.|VT82C586B USB (uhci_hcd)
00:10.3 USB Controller|UHCI: VIA Technologies Inc.|VT82C586B USB (uhci_hcd)
00:10.4 USB Controller|EHCI: VIA Technologies Inc.|VT8235 USB Enhanced Controller (ehci-hcd)
00:11.0 ISA bridge: VIA Technologies Inc.|VT8237A PCI to ISA Bridge (unknown)
00:11.7 Host bridge: VIA Technologies Inc.|VT8251 Ultra VLINK Controller (unknown)
00:13.0 Host bridge: VIA Technologies Inc.|VT8237A PCI to PCIE Bridge (unknown)
00:18.0 Host bridge: Advanced Micro Devices|K8 [Athlon64/Opteron] HyperTransport Technology Configuration (unknown)
00:18.1 Host bridge: Advanced Micro Devices|K8 [Athlon64/Opteron] Address Map (unknown)
00:18.2 Host bridge: Advanced Micro Devices|K8 [Athlon64/Opteron] DRAM Controller (unknown)
00:18.3 Host bridge: Advanced Micro Devices|K8 [Athlon64/Opteron] Miscellaneous Control (amd64-agp)
06:00.0 VGA compatible controller: nVidia Corp.| (nv)
03:00.0 Ethernet controller: Realtek Semiconductor|RTL-8168 PCI-E Gigabit Ethernet (r8169)
02:00.0 Non-VGA unclassified device: JMicron Technologies, Inc.|JMicron 20360/20363 AHCI Controller (ahci)
02:00.1 IDE interface: JMicron Technologies, Inc.|JMicron 20360/20363 AHCI Controller (ahci)
07:04.0 Ethernet controller: Digital Equipment Corp.|ANA-6944A/TX Fast Ethernet (tulip)
07:05.0 Ethernet controller: Digital Equipment Corp.|21140 Fast Ethernet (tulip)
07:06.0 Ethernet controller: Digital Equipment Corp.|21140 Fast Ethernet (tulip)
07:07.0 Ethernet controller: Digital Equipment Corp.|21140 Fast Ethernet (tulip)
80:01.0 Non-VGA unclassified device: VIA Technologies Inc.|VIA High Definition Audio Controller (snd-hda-intel)
---:--- Mouse: Generic PS/2 Wheel Mouse [/dev/psaux] (msintellips/2)

3) The install did not install the nvidia drivers (as it should do according to the front page article) my system is still running on nv driver instead.

Interesting. Would you mind pasting the output of lspci and lshwd.

Here we go. This is my lspci output

Code:

00:00.0 Host bridge: VIA Technologies, Inc. K8T890CF Host Bridge
00:00.1 Host bridge: VIA Technologies, Inc. VT3351 Host Bridge
00:00.2 Host bridge: VIA Technologies, Inc. VT3351 Host Bridge
00:00.3 Host bridge: VIA Technologies, Inc. VT3351 Host Bridge
00:00.4 Host bridge: VIA Technologies, Inc. VT3351 Host Bridge
00:00.5 PIC: VIA Technologies, Inc. VT3351 I/O APIC Interrupt Controller
00:00.7 Host bridge: VIA Technologies, Inc. VT3351 Host Bridge
00:01.0 PCI bridge: VIA Technologies, Inc. [K8T890 North / VT8237 South] PCI Bridge
00:02.0 PCI bridge: VIA Technologies, Inc. K8T890 PCI to PCI Bridge Controller
00:03.0 PCI bridge: VIA Technologies, Inc. K8T890 PCI to PCI Bridge Controller
00:03.1 PCI bridge: VIA Technologies, Inc. K8T890 PCI to PCI Bridge Controller
00:03.2 PCI bridge: VIA Technologies, Inc. K8T890 PCI to PCI Bridge Controller
00:03.3 PCI bridge: VIA Technologies, Inc. K8T890 PCI to PCI Bridge Controller
00:09.0 Multimedia controller: Philips Semiconductors SAA7131/SAA7133/SAA7135 Video Broadcast Decoder (rev d0)
00:0a.0 Multimedia controller: Philips Semiconductors SAA7131/SAA7133/SAA7135 Video Broadcast Decoder (rev d0)
00:0b.0 PCI bridge: Digital Equipment Corporation DECchip 21152 (rev 03)
00:0f.0 IDE interface: VIA Technologies, Inc. VT8237A SATA 2-Port Controller (rev 80)
00:0f.1 IDE interface: VIA Technologies, Inc. VT82C586A/B/VT82C686/A/B/VT823x/A/C PIPC Bus Master IDE (rev 07)
00:10.0 USB Controller: VIA Technologies, Inc. VT82xxxxx UHCI USB 1.1 Controller (rev a0)
00:10.1 USB Controller: VIA Technologies, Inc. VT82xxxxx UHCI USB 1.1 Controller (rev a0)
00:10.2 USB Controller: VIA Technologies, Inc. VT82xxxxx UHCI USB 1.1 Controller (rev a0)
00:10.3 USB Controller: VIA Technologies, Inc. VT82xxxxx UHCI USB 1.1 Controller (rev a0)
00:10.4 USB Controller: VIA Technologies, Inc. USB 2.0 (rev 86)
00:11.0 ISA bridge: VIA Technologies, Inc. VT8237A PCI to ISA Bridge
00:11.7 Host bridge: VIA Technologies, Inc. VT8251 Ultra VLINK Controller
00:13.0 Host bridge: VIA Technologies, Inc. VT8237A Host Bridge
00:18.0 Host bridge: Advanced Micro Devices [AMD] K8 [Athlon64/Opteron] HyperTransport Technology Configuration
00:18.1 Host bridge: Advanced Micro Devices [AMD] K8 [Athlon64/Opteron] Address Map
00:18.2 Host bridge: Advanced Micro Devices [AMD] K8 [Athlon64/Opteron] DRAM Controller
00:18.3 Host bridge: Advanced Micro Devices [AMD] K8 [Athlon64/Opteron] Miscellaneous Control
02:00.0 SATA controller: JMicron Technologies, Inc. JMicron 20360/20363 AHCI Controller (rev 02)
02:00.1 IDE interface: JMicron Technologies, Inc. JMicron 20360/20363 AHCI Controller (rev 02)
03:00.0 Ethernet controller: Realtek Semiconductor Co., Ltd. RTL8111/8168B PCI Express Gigabit Ethernet controller (rev 01)
06:00.0 VGA compatible controller: nVidia Corporation NV44 [GeForce 6200 LE] (rev a1)
07:04.0 Ethernet controller: Digital Equipment Corporation DECchip 21140 [FasterNet] (rev 22)
07:05.0 Ethernet controller: Digital Equipment Corporation DECchip 21140 [FasterNet] (rev 22)
07:06.0 Ethernet controller: Digital Equipment Corporation DECchip 21140 [FasterNet] (rev 22)
07:07.0 Ethernet controller: Digital Equipment Corporation DECchip 21140 [FasterNet] (rev 22)
80:01.0 Audio device: VIA Technologies, Inc. VT1708/A [Azalia HDAC] (VIA High Definition Audio Controller) (rev 10)

lshw output is attached for it exceeded maximum allowed length of the post...

HTH
/chriss