| Using fileStats() functions to obtain EXIF tags and metadata from multimedia files |
fileStats(filePath, type)
This function returns:
filePath
A textual field containing full file paths (or a directly entered fixed string). File paths from a given folder or entire disk partitions can be loaded with the "Tools > Verify Files" functions.
type
A numeric code representing one of two type of extracted tags, depending on the file type:
if the path points to a photo or other JPG/TIFF/PNG/BMP/ICO, this code represent an extracted EXIF tag,
if the path points to a multimedia video or sound file, this code represent a multimedia file metadata.
NOTE: this functions should be used in calculated Text fields.
For best performance for very large tables that you update at once, increase the number of processor cores to use
for calculations in the Settings > Options > General window.
=fileStats(images, 1) return GPS latitude for the location where the image was taken
=fileStats("e:\photo3.jpg', 6) return GPS altitude for the location where the image was taken
=fileStats(images, hex2dec("132")) returns the 0x132 property value - a date
=fileStats(images, hex2dec("132")) returns the 0x132 property value for a given image
=fileStats(images, -1) returns the list of all EXIF tags encoded in a given image.
=fileStats(videos, 3)
=fileStats("e:\some_file.avi", 3)
=fileStats(videos, 20)
=fileStats(videos, 11)
EXIF property values (hexadecimal) codes for photos and other JPG/TIFF/EXIF/PNG/BMP/ICO images:
ImageWidth(0x100)
ImageHeight(0x101)
EquipMake(0x10f)
EquipModel(0x110)
Orientation(0x112)
XResolution(0x11a)
YResolution(0x11b)
ResolutionUnit(0x128)
SoftwareUsed(0x131)
DateTime(0x132)
YCbCrPositioning(0x213)
ExifExposureTime(0x829a)
ExifFNumber(0x829d)
ExifExposureProg(0x8822)
ExifISOSpeed(0x8827)
ExifVer(0x9000)
ExifDTOrig(0x9003)
ExifDTDigitized(0x9004)
ExifCompConfig(0x9101)
ExifShutterSpeed(0x9201)
ExifAperture(0x9202)
ExifBrightness(0x9203)
ExifExposureBias(0x9204)
ExifMaxAperture(0x9205)
ExifSubjectDist(0x9206)
ExifMeteringMode(0x9207)
ExifFlash(0x9209)
ExifFocalLength(0x920a)
ExifMakerNote(0x927c)
ExifDTSubsec(0x9290)
ExifDTOrigSS(0x9291)
ExifDTDigSS(0x9292)
ExifFPXVer(0xa000)
ExifColorSpace(0xa001)
ExifPixXDim(0xa002)
ExifPixYDim(0xa003)
ExifSensingMethod(0xa217)
ExifSceneType(0xa301)
GpsVer(0x0)
GpsLatitudeRef(0x1)
GpsLatitude(0x2)
GpsLongitudeRef(0x3)
GpsLongitude(0x4)
GpsAltitudeRef(0x5)
GpsAltitude(0x6)
GpsGpsTime(0x7)
GpsGpsDop(0xb)
ThumbnailData(0x501b)
ThumbnailImageWidth(0x5020)
ThumbnailImageHeight(0x5021)
ThumbnailCompression(0x5023)
ThumbnailOrientation(0x5029)
ThumbnailResolutionX(0x502d)
ThumbnailResolutionY(0x502e)
ThumbnailResolutionUnit(0x5030)
JPEGInterFormat(0x201)
JPEGInterLength(0x202)
ChrominanceTable(0x5091)
LuminanceTable(0x5090)
ICCProfile(0x8773)
Multimedia metadata tag codes for video/sound files:
Digital Living Network Alliance(DLNA) profile identifier. (1)
Number of audio channels. (2)
Average audio bit rate, in bits per second. (3)
Audio subtype. (4)
Indicates whether the audio stream uses variable bit - rate encoding. (5)
Peak volume level of audio content. (6)
Audio sample rate in samples per second. (7)
Number of bits per audio sample. (8)
Identifier of the audio stream. (9)
Author. (10)
A comment attached to a file. (11)
Copyright information. (12)
Indicates whether the content is protected using digital rights management. (13)
Keywords. (14)
Language. (15)
URL of the author's website. (16)
Average volume level of audio content. (17)
The string representation of a GUID that identifies the primary class of media. (18)
The string representation of a GUID that identifies the secondary class of media. (19)
The string representation of a GUID that identifies the collection group. (20)
The string representation of a GUID that identifies the collection. (21)
Distributor of the content. (22)
The string representation of a GUID that identifies the collection. (23)
Time when the content was encoded. (24)
Original release date. (25)
Duration, in 100 - nanosecond units. (26)
Digital video disc identifier. (27)
Name of the person or group that encoded the content. (28)
Description of the settings used to encode the content. (29)
Music CD identifier.This value is used to identify a CD. (30)
Name of the metadata content provider. (31)
Name of the producer of the content. (32)
URL of a website offering a promotion related to the content. (33)
Rating of the content as assigned by the metadata content provider. (34)
Style or genre of the content as assigned by the metadata content provider. (35)
Publisher. (36)
Subtitle. (37)
A generic string that can be to identify the file. (38)
Writer. (39)
Year the content was published. (40)
Primary artist for the album. (41)
Album title. (42)
Artist. (43)
Beats per minute. (44)
Composer. (45)
Conductor. (46)
Description of the content (boxed set or series). (47)
Genre. (48)
The initial key of the music. (49)
Indicates whether the music file is part of a compilation. (50)
Lyrics. (51)
Mood. (52)
The part number and the total number of parts. (53)
Period. (54)
Track number. (55)
Parental rating. (56)
Reasons for the assigned parental rating. (57)
User rating. (58)
Thumbnail image. (59)
Title. (60)
Video subtype. (61)
Director. (62)
Average video bit rate, in bits per second. (63)
The FOURCC of the video encoding format. (64)
Video frame height. (65)
Video frame rate, expressed as frames per second × 1000. (66)
Video frame width. (67)
The horizontal component of the pixel aspect ratio. (68)
Indicates whether the video stream contains stereo video content. (69)
Identifier of the video stream. (70)
Total data rate for all video and audio streams, in bits per second. (71)