Metadata properties
Smartsite 7.1 - ...
When an image within a configured AssetFolder is synchronized, the metadata for that image is extracted and copied to the AssetMeta contenttype field.
The example below shows an example of this metadata.
| XML |
Copy Code
|
|---|---|
<metadata> <generalproperties> <property name="filename">P9130015.JPG</property> <property name="filetype">jpg</property> <property name="height">1536</property> <property name="width">2048</property> <property name="horizontalresolution">72</property> <property name="verticalresolution">72</property> <property name="size">612702</property> </generalproperties> <exif> <property name="colorspace" displayname="ColorSpace">sRGB</property> <property name="componentsconfig" displayname="Components Config">1 2 3 0</property> <property name="compressedbitsperpixel" displayname="Compressed Bits Per Pixel">2.0 bits</property> <property name="compressedimageheight" displayname="Compressed Image Height">1536 pixels</property> <property name="compressedimagewidth" displayname="Compressed Image Width">2048 pixels</property> <property name="contrast" displayname="Contrast">Normal</property> <property name="customrendered" displayname="Custom Rendered">Normal Process</property> <property name="datetime" displayname="DateStamp">9/13/2006 9:14:35 PM</property> <property name="datetimedigitized" displayname="DateStamp Digitized">9/13/2006 9:14:35 PM</property> <property name="datetimeoriginal" displayname="DateStamp Original">9/13/2006 9:14:35 PM</property> <property name="digitalzoomratio" displayname="Digital Zoom Ratio">0:100</property> <property name="exifversion" displayname="EXIF Version">0220</property> <property name="exposurebias" displayname="Exposure Bias">-20/10 EV</property> <property name="exposuremode" displayname="Exposure Mode">Manual Exposure</property> <property name="exposureprogram" displayname="Exposure Program">Normal Auto</property> <property name="exposuretime" displayname="Exposure Time">10/5000 sec</property> <property name="filesource" displayname="File Source">Digital Still Camera</property> <property name="flash" displayname="Flash">Flash Off</property> <property name="flashpixversion" displayname="Flashpix Version">0100</property> <property name="fnumber" displayname="F-Stop">f/8.7</property> <property name="focallength" displayname="Focal Length">5.8 mm</property> <property name="gaincontrol" displayname="Gain Control">None</property> <property name="imagedescription" displayname="Image Description">OLYMPUS DIGITAL CAMERA</property> <property name="interoperabilityindex" displayname="Interoperability Index">R98</property> <property name="isospeed" displayname="ISO Speed">ISO-64</property> <property name="jpeginterchangeformat" displayname="JPEG Interchange Format">4084</property> <property name="jpeginterchangelength" displayname="JPEG Interchange Length">2912</property> <property name="lightsource" displayname="Light Source">Unknown</property> <property name="make" displayname="Make">OLYMPUS CORPORATION</property> <property name="maxaperture" displayname="Max Aperture">f/3.1</property> <property name="meteringmode" displayname="Metering Mode">Pattern</property> <property name="model" displayname="Model">X250,D560Z,C350Z</property> <property name="orientation" displayname="Orientation">Normal</property> <property name="resolutionunit" displayname="Resolution Unit">Inch</property> <property name="saturation" displayname="Saturation">Normal</property> <property name="scenecapturetype" displayname="Scene Capture Type">Standard</property> <property name="scenetype" displayname="Scene Type">Directly Photographed Image</property> <property name="sharpness" displayname="Sharpness">Normal</property> <property name="software" displayname="Software">v774-75</property> <property name="thumbnailcompression" displayname="Thumbnail Compression">JPEG Compression</property> <property name="thumbnailresolutionunit" displayname="Thumbnail Resolution Unit">Inch</property> <property name="thumbnailxresolution" displayname="Thumbnail Horizontal Resolution">72 dpi</property> <property name="thumbnailyresolution" displayname="Thumbnail Vertical Resolution">72 dpi</property> <property name="whitebalance" displayname="White Balance">Auto White Balance</property> <property name="xresolution" displayname="Horizontal Resolution">72 dpi</property> <property name="ycbcrpositioning" displayname="YCbCr Positioning">CoSited</property> <property name="yresolution" displayname="Vertical Resolution">72 dpi</property> </exif> </metadata> |
|
As mentioned before, some of these metadata properties are copied to contenttype fields, such as height, width and (file)size.
However, if you want to display an individual metadata property which has not been configured to be copied to a contenttype field, you can easily query a single value using the example below.
| SQL |
Copy Code
|
|---|---|
select cast(Asset_Meta as xml).value('(/metadata/exif/property[@name="make"])[1]','varchar(100)')
from Contents
where Nr = 92479
|
|
You can even use a query to collect one or more metadata properties as recordset, see the example below.
| SQL |
Copy Code
|
|---|---|
WITH metaxml (meta)
AS (
select cast(Asset_Meta as xml) as meta
from Contents where Nr = 92479
)
select T.N.value('(@displayname)[1]', 'varchar(100)') as displayname, T.N.value('(.)[1]', 'varchar(250)') as propertyvalue
from metaxml as x
cross apply x.meta.nodes('/metadata/exif/property') as T(N)
|
|