If he's entering them programmatically, it should be a trivial matter
for the program to fill in many of the fields from the EXIF data.
-----Original Message-----
From: olympus-owner@xxxxxxxxxx [mailto:olympus-owner@xxxxxxxxxx] On
Behalf Of James N. McBride
Sent: Sunday, December 10, 2006 3:17 PM
To: olympus@xxxxxxxxxx
Subject: [OM] Re: My proposed database fields
It's a lot of data to enter for every image. /jmac
-----Original Message-----
From: olympus-owner@xxxxxxxxxx [mailto:olympus-owner@xxxxxxxxxx]On
Behalf Of Allan Mee
Sent: Sunday, December 10, 2006 12:22 PM
To: olympus@xxxxxxxxxx
Subject: [OM] My proposed database fields
Here's my first thoughts regarding database fields for the database I'm
going to write in VB - with a couple of made up examples of records.
Any thoughts? Have I missed anything obvious?
Allan
Fields:
RefNo: 000001 (Auto-generated by access)
FileSpec: C:\MyDocuments\MyPictures\DSC001.JPG
Date/Time: 12/12/2006 18:59:00
Subject: Roxie the cat
Shoot Desc: Rulers Of The Roost
Location: Home
Shot By: Me
Edited: No
Camera Make: Canon
Model: EOS DIGITAL REBEL 300D
Camera Type: DLSR
Flash Used: No
FlashType: Built-in
Lens Used: 18-50mm EFS
Focal Length: 70 mm
Exposure Time: 1/500 sec
Aperture: f/5.6
ISO: 200
Exposure Bias: -1/3
White Balance: AWB
Metering Mode: Matrix
Image Format: JPEG
JPEG Quality: High/Fine
Exposure Program: Aperture Priority
Focus Distance: 5m
CFCardRefNo:0001
ImageWidth: 1024
ImageHeight: 768
ColourInfo: 32-bit RGB+Alpha
Scanned: No
Image: (copy of actual image stored)
RefNo: 000002 (Auto-generated by access)
FileSpec: C:\MyDocuments\MyPictures\DSC002.JPG
Date/Time: 12/12/2006 20:04:17
Subject: Ben the dog
Shoot Desc: Rulers Of The Roost
Location: Garden
Shot By: Me
Edited: No
Camera Make: Canon
Model: A1
Camera Type: 35mm
Flash Used: No
FlashType: None
Lens Used: 28mm Cosina
Focal Length: 28 mm
Exposure Time: 1/250 sec
Aperture: f/4
ISO: 200
Exposure Bias: -1/3
White Balance: NA
Metering Mode: Centre-Weighted
Image Format: JPEG
JPEG Quality: High/Fine
Exposure Program: Aperture Priority
Focus Distance: 10m
CFCardRefNo:NA
ImageWidth: 800
ImageHeight: 600
ColourInfo: 16-bit RGB+Alpha
Scanned: Yes
Image: (copy of actual image stored)
PS No trees were harmed in the sending of this message and a very large
number of electrons were asked their permission to be terribly
inconvenienced. (And threw a party for them afterwards for being really
cool
about it).
Disrupting the unnatural balance that you, as a conscious human being
and a
confused mass of energy, have created.
-Disturb the mind -
_________________________________________________________________
It's Hotmail's 10th Birthday! Come and play Pass the Parcel
http://www.msnpasstheparcel.com
==============================================
List usage info: http://www.zuikoholic.com
List nannies: olympusadmin@xxxxxxxxxx
==============================================
==============================================
List usage info: http://www.zuikoholic.com
List nannies: olympusadmin@xxxxxxxxxx
==============================================
This message (and any associated files) is intended only for the use of the
individual or entity to which it is addressed, and may contain information that
is confidential, subject to copyright or constitutes a trade secret. If you are
not the intended recipient, you are hereby notified that any dissemination,
copying or distribution of this message or files associated with the message
are strictly prohibited. If you have received this message in error, kindly
notify us immediately by replying to the message and deleting it from your
computer
==============================================
List usage info: http://www.zuikoholic.com
List nannies: olympusadmin@xxxxxxxxxx
==============================================
|