Photo Organizer

You can ask Photoshop Element to write the tags you assign to a picture in the exif/iptc/xmp? header.

When trying to import this kind of picture, the tags are not recognized and the import fails, even if it seems that exiftools can read them normally...

This picture was taken with a Powershot G3, imported successfully in PO. Then, I putted it in Photoshop Elements 5, assigned a tag, and asked Elements to write the tages in the picture. No luck to import in anymore :

Importing 'IMG_8205.jpg' (Joint Photographic Experts Group JFIF format) into folder test2 .

* Extracting Image Metadata (EXIF) ... done
* Extracting Image Metadata (XMP) ... done
* UNHANDLED: Orientation = Horizontal (normal)
* UNHANDLED: Y Cb Cr Positioning = Centered
* UNHANDLED: X Resolution = 180
* UNHANDLED: Y Resolution = 180
* UNHANDLED: Resolution Unit = inches
* UNHANDLED: Camera Model Name = Canon PowerShot G3
* UNHANDLED: Modify Date = 2007:08:15 16:49:37+02:00
* UNHANDLED: Creator Tool = Adobe Photoshop Elements 5.0
* UNHANDLED: Metadata Date = 2007:08:15 16:49:37+02:00
* UNHANDLED: Exif Version = 0.2.2.0
* UNHANDLED: Flashpix Version = 0.1.0.0
* UNHANDLED: Color Space = sRGB
* UNHANDLED: Compressed Bits Per Pixel = 3
* UNHANDLED: Exif Image Width = 2272
* UNHANDLED: Exif Image Length = 1704
* UNHANDLED: Date/Time Original = 2007:08:15 16:59:01+02:00
* UNHANDLED: Date/Time Digitized = 2007:08:15 16:59:01+02:00
* UNHANDLED: Exposure Time = 1/60
* UNHANDLED: F Number = 2.5
* UNHANDLED: Shutter Speed Value = 1/60
* UNHANDLED: Aperture Value = 2.5
* UNHANDLED: Exposure Compensation = 0
* UNHANDLED: Max Aperture Value = 2.5
* UNHANDLED: Metering Mode = Multi-segment
* UNHANDLED: Focal Length = 15.8mm
* UNHANDLED: Focal Plane X Resolution = 8114.28571428571
* UNHANDLED: Focal Plane Y Resolution = 8114.28571428571
* UNHANDLED: Focal Plane Resolution Unit = inches
* UNHANDLED: Sensing Method = One-chip color area
* UNHANDLED: File Source = Digital Camera
* UNHANDLED: Custom Rendered = Normal
* UNHANDLED: Exposure Mode = Auto
* UNHANDLED: White Balance = Auto
* UNHANDLED: Digital Zoom Ratio = 1
* UNHANDLED: Scene Capture Type = Portrait
* UNHANDLED: Native Digest = 36864,40960,40961,37121,37122,40962,40963,37510,40964,36867,36868,33434,33437,34850,34852,34855,34856,37377,37378,37379,37380,37381,37382,37383,37384,37385,37386,37396,41483,41484,41486,41487,41488,41492,41493,41495,41728,41729,41730,41985,41986,41987,41988,41989,41990,41991,41992,41993,41994,41995,41996,42016,0,2,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,20,22,23,24,25,26,27,28,30;0C3E0533A1B7353C9C4E78B4ABCE6D2E
* UNHANDLED: Components Configuration = Y, Cb, Cr, .
* UNHANDLED: Flash Fired = True
* UNHANDLED: Flash Return = No return detection
* UNHANDLED: Flash Mode = Auto
* UNHANDLED: Flash Function = False
* UNHANDLED: Flash Red Eye Mode = False
* Extracting Image Metadata (IPTC) ... done
* UNHANDLED: Application Record Version = 2
* Copying original image IMG_8205.jpg into repository ... done
* Generating preview image ... done. (700 pixels)
* Transferring metadata ... done.
* Generating thumbnail image ... done. (170 pixels)
* ERROR: syntax error at or near "," at character 398
* Failed to update database.
*

insert into photo_tech (identifier, photo, camera, lens, film, flash, scanner, filter, scan_resolution, aperture, focal_length, shutter, camera_metering, camera_program, flash_mode, exposure_comp, flash_comp, ev_difference, iso_override, support, scan_bitdepth, scan_multiscan, exif, iptc, latitude, longitude, altitude, img_direction, rdf)
values (nextval('photo_tech_id_sequence'), 364, , null,
null, null, null,
null, null, 11,
46, 35, null,
null, null, 21,
21, null, null,
null, null, null,
'ExifTool Version Number6.94File Size820 kBFile Modification Date/Time2007:08:15 16:50:02File TypeJPEGMIME Typeimage/jpegMakeCanonCamera Model NameCanon PowerShot G3OrientationHorizontal (normal)X Resolution180Y Resolution180Resolution UnitinchesSoftwareAdobe Photoshop Elements 5.0Modify Date2007:08:15 16:49:37Y Cb Cr PositioningCenteredExposure Time1/60F Number2.5Exif Version0220Date/Time Original2007:08:15 16:59:01Create Date2007:08:15 16:59:01Components ConfigurationYCbCrCompressed Bits Per Pixel3Shutter Speed Value1/60Aperture Value2.5Max Aperture Value2.5FlashOnFocal Length15.8mm (35mm equivalent: 75.3mm)Macro ModeNormalSelf-timer0QualityFineCanon Flash ModeAutoContinuous DriveSingleFocus ModeSingleRecord ModeJPEGCanon Image SizeLargeEasy ModePortraitDigital ZoomNoneContrastNormalSaturationNormalSharpnessNormalCamera ISOAutoMetering ModeEvaluativeFocus RangeAutoAF PointManual AF point selectionCanon Exposure ModeEasyLens TypeUnknown (-1)Long Focal28.8125mmShort Focal7.1875mmFocal Units32Max Aperture2.5Min Aperture8Flash Activity1Flash BitsE-TTL, Built-inFocus ContinuousContinuousAE SettingNormal AEZoom Source Width2272Zoom Target Width2272Photo EffectOffFocal TypeZoomFocal Plane X Size7.26mmFocal Plane Y Size5.46mmAuto ISO100Base ISO50Measured EV2.28Target Aperture2.5Target Exposure Time1/60Exposure Compensation0White BalanceAutoSlow ShutterOffShot Number In Continuous Burst0Optical Zoom Code7Flash Guide Number4.59375Flash Exposure Compensation0Auto Exposure BracketingOffAEB Bracket Value0Focus Distance Upper0.66Focus Distance Lower0Bulb Duration0Camera TypeCompactAuto RotateNoneND FilterOffSelf-timer 20Canon Image TypeIMG:PowerShot G3 JPEGCanon Firmware VersionFirmware Version 1.02File Number182-8205Owner NameCanon Model IDPowerShot G3Num AF Points1Canon Image Width2272Canon Image Height1704Canon Image Width As Shot2272Canon Image Height As Shot212Flashpix Version0100Color SpacesRGBExif Image Width2272Exif Image Length1704Interoperability IndexR98 - DCF basic file (sRGB)Interoperability Version0100Related Image Width2272Related Image Length1704Focal Plane X Resolution8114.286Focal Plane Y Resolution8114.286Focal Plane Resolution UnitinchesSensing MethodOne-chip color areaFile SourceDigital CameraCustom RenderedNormalExposure ModeAutoDigital Zoom Ratio1Scene Capture TypePortraitCompressionJPEG (old-style)Thumbnail Offset1486Thumbnail Length4165Image Width2272Image Height1704Encoding ProcessBaseline DCT, Huffman codingBits Per Sample8Color Components3Y Cb Cr Sub SamplingYCbCr4:2:2 (2 1)Aperture2.5Drive ModeSingle-frame shootingFlash TypeBuilt-In FlashISO50Image Size2272x1704Lens7.2 - 28.8mm (35mm equivalent: 34.2 - 137.2mm)Red Eye ReductionOffScale Factor To 35mm Equivalent4.8Shooting ModePortraitShutter Curtain Sync1st-curtain syncShutter Speed1/60Thumbnail Image(Binary data 4165 bytes, use -b option to extract)Circle Of Confusion0.006 mmHyperfocal Distance15.85 mLight Value9.6', 'Application Record Version2KeywordsTao', null, null, null, null, 'OrientationHorizontal (normal)Y Cb Cr PositioningCenteredX Resolution180Y Resolution180Resolution UnitinchesMakeCanonCamera Model NameCanon PowerShot G3Modify Date2007:08:15 16:49:37+02:00Creator ToolAdobe Photoshop Elements 5.0Metadata Date2007:08:15 16:49:37+02:00Exif Version0.2.2.0Flashpix Version0.1.0.0Color SpacesRGBCompressed Bits Per Pixel3Exif Image Width2272Exif Image Length1704Date/Time Original2007:08:15 16:59:01+02:00Date/Time Digitized2007:08:15 16:59:01+02:00Exposure Time1/60F Number2.5Shutter Speed Value1/60Aperture Value2.5Exposure Compensation0Max Aperture Value2.5Metering ModeMulti-segmentFocal Length15.8mmFocal Plane X Resolution8114.28571428571Focal Plane Y Resolution8114.28571428571Focal Plane Resolution UnitinchesSensing MethodOne-chip color areaFile SourceDigital CameraCustom RenderedNormalExposure ModeAutoWhite BalanceAutoDigital Zoom Ratio1Scene Capture TypePortraitNative Digest36864,40960,40961,37121,37122,40962,40963,37510,40964,36867,36868,33434,33437,34850,34852,34855,34856,37377,37378,37379,37380,37381,37382,37383,37384,37385,37386,37396,41483,41484,41486,41487,41488,41492,41493,41495,41728,41729,41730,41985,41986,41987,41988,41989,41990,41991,41992,41993,41994,41995,41996,42016,0,2,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,20,22,23,24,25,26,27,28,30;0C3E0533A1B7353C9C4E78B4ABCE6D2EComponents ConfigurationY, Cb, Cr, .Flash FiredTrueFlash ReturnNo return detectionFlash ModeAutoFlash FunctionFalseFlash Red Eye ModeFalseSubjectTao')

* Cleaning up the mess.