[AccessD] Access files by date

Rocky Smolin rockysmolin at bchacc.com
Wed Aug 2 09:03:53 CDT 2017


Cool. But the list you posted is even more helpful.  Are those 296 fields
all standard (if unused) in a jpg file?  DO you know of a link to a site
with more description of those fields?  

Tia

R
 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Stuart McLachlan
Sent: Tuesday, August 01, 2017 2:43 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access files by date

On 1 Aug 2017 at 7:56, Rocky Smolin wrote:
> ' search jpg header fields to find which one is the original date
...
> objFolder.GetDetailsOf(objFolderItem, 16) ' turns out to be field 12

> GetProperty = objFolder.GetDetailsOf(objFolderItem, 12)

FWIW,..
replacing
objFolder.GetDetailsOf(objFolderItem, 16) with
objFolder.GetDetailsOf(objFolder.Items, i) will return the Name of the item
instead of its value.

I came across th list below of GetDetailsOf item numbers.

Seems MS have just added  items haphazardly to a list as they have
identified EXIF and other metadata tags used by different types of files.

If you want the Lat/Lon so that you can track your photos geographically,
that's item 39.

Experimenting, there is no error if you ask for an item Detail that doesn't
exist.  I looped through a folder asking for item details up to 1000 without
any error



'0   Name
'1   Size
'2   Item type
'3   Date Modified
'4   Date created
'5   Date accessed
'6   Attributes
'7   Offline Status
'8   Offline availability
'9   Perceived type
'10  owner
'11  Kind
'12  Date taken
'13  Contributing artists
'14  Album
'15  Year
'16  Genre
'17  Conductors
'18  Tags
'19  rating
'20  Authors
'21  Title
'22  Subject
'23  Categories
'24  Comments
'25  copyright
'26  #
'27  Length
'28  Bit Rate
'29  Protected
'30  Camera model
'31  Dimensions
'32  Camera maker
'33  Company
'34  File Description
'35  Program Name
'36  Duration
'37  Is online
'38  Is recurring
'39  Location
'40  Optional attendee addresses
'41  Optional attendees
'42  Organizer Address
'43  Organizer Name
'44  Reminder Time
'45  Required attendee addresses
'46  Required attendees
'47  Resources
'48  Meeting Status
'49  Free/busy status
'50  Total Size
'51  Account Name
'52  task Status
'53  computer
'54  Anniversary
'55  Assistant 's name
'56  Assistant 's phone
'57  Birthday
'58  Business Address
'59  Business City
'60  Business Country / region
'61  Business P.O.box
'62  Business postal code
'63  Business State Or province
'64  Business Street
'65  Business fax
'66  Business home page
'67  Business phone
'68  Callback Number
'69  Car phone
'70  Children
'71  Company main phone
'72  Department
'73  E-mail address
'74  e -mail2
'75  e -mail3
'76  E-mail list
'77  E-mail display name
'78  File as
'79  First Name
'80  Full Name
'81  Gender
'82  Given Name
'83  Hobbies
'84  Home Address
'85  Home City
'86  Home Country / region
'87  Home P.O.box
'88  Home postal code
'89  Home State Or province
'90  Home Street
'91  Home fax
'92  Home phone
'93  IM addresses
'94  Initials
'95  Job Title
'96  Label
'97  last Name
'98  Mailing Address
'99  Middle Name
'100 Cell phone
'101 Nickname
'102 Office Location
'103 Other Address
'104 Other City
'105 Other Country / region
'106 Other P.O.box
'107 Other postal code
'108 Other State Or province
'109 Other Street
'110 Pager
'111 Personal Title
'112 City
'113 Country/region
'114 P.O.box
'115 Postal code
'116 State or province
'117 Street
'118 Primary e - mail
'119 Primary phone
'120 Profession
'121 Spouse/Partner
'122 Suffix
'123 TTY/TTD phone
'124 Telex
'125 Webpage
'126 Content Status
'127 Content type
'128 Date acquired
'129 Date archived
'130 Date completed
'131 Device Category
'132 Connected
'133 Discovery Method
'134 Friendly Name
'135 Local computer
'136 Manufacturer
'137 model
'138 Paired
'139 Classification
'140 Status
'141 Client ID
'142 Contributors
'143 Content created
'144 last printed
'145 Date last saved
'146 Division
'147 Document ID
'148 Pages
'149 Slides
'150 Total editing time
'151 Word Count
'152 Due Date
'153 End date
'154 File Count
'155 FileName
'156 File Version
'157 flag Color
'158 flag Status
'159 Space free
'160 Bit Depth
'161 Horizontal resolution
'162 Width
'163 Vertical resolution
'164 Height
'165 Importance
'166 Is attachment
'167 Is deleted
'168 Encryption Status
'169 Has flag
'170 Is completed
'171 Incomplete
'172 Read Status
'173 Shared
'174 Creators
'175 Date
'176 Folder Name
'177 Folder Path
'178 Folder
'179 Participants
'180 Path
'181 by Location
'182 Type
'183 Contact Names
'184 Entry type
'185 Language
'186 Date visited
'187 Description
'188 link Status
'189 link Target
'190 URL
'191 Media created
'192 Date released
'193 Encoded by
'194 Producers
'195 Publisher
'196 Subtitle
'197 User web URL
'198 Writers
'199 attachments
'200 Bcc addresses
'201 Bcc
'202 Cc addresses
'203 Cc
'204 Conversation ID
'205 Date Received
'206 Date sent
'207 From addresses
'208 From
'209 Has attachments
'210 Sender Address
'211 Sender Name
'212 Store
'213 To addresses
'214 To do title
'215 To
'216 Mileage
'217 Album artist
'218 Album ID
'219 Beats -per - Minute
'220 Composers
'221 Initial Key
'222 Part of a compilation
'223 Mood
'224 Part of set
'225 Period
'226 Color
'227 Parental rating
'228 Parental rating reason
'229 Space used
'230 EXIF Version
'231 Event
'232 Exposure bias
'233 Exposure Program
'234 Exposure Time
'235 F-stop
'236 Flash Mode
'237 Focal Length
'238 35mm focal length
'239 ISO speed
'240 Lens maker
'241 Lens model
'242 Light Source
'243 Max aperture
'244 Metering Mode
'245 Orientation
'246 People
'247 Program Mode
'248 saturation
'249 Subject distance
'250 White Balance
'251 Priority
'252 Project
'253 Channel Number
'254 Episode Name
'255 Closed captioning
'256 Rerun
'257 SAP
'258 Broadcast Date
'259 Program Description
'260 Recording Time
'261 Station call sign
'262 Station Name
'263 Summary
'264 Snippets
'265 Auto Summary
'266 Search ranking
'267 Sensitivity
'268 Shared with
'269 Sharing Status
'270 Product Name
'271 Product Version
'272 Support link
'273 Source
'274 Start Date
'275 Billing Information
'276 Complete
'277 task owner
'278 Total file size
'279 Legal trademarks
'280 Video compression
'281 Directors
'282 Data Rate
'283 Frame Height
'284 Frame Rate
'285 Frame Width
'286 Total bitRate
'287 Primary disk
'288 Memory
'289 Machine Status
'290 Configuration File
'291
'292
'293
'294
'295 Masters Keywords (debug)
'296 Masters Keywords (debug)
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list