Friday - The Automatic FAQ Maker
Not in the manual, sadly! Below is the list you are looking for. Fields whose entries are italicised are not displayed in the field lists for either the Gallery's Customisation Options dialog or the Find dialog so cannot be used for display or search purposes (and not used via NetPublish/PortWeb). The number before each field's name is the order in which it is listed via the VB automation library:
| Index # | Field Name | Data Type (Number) [2] |
| 1 | Filename | Text (0) |
| 2 | Path | Text (0) |
| 3 | Extension (named Extension Win up to v6.1.x) | Text (0) |
| 4 | Short Filename Win | Text (0) |
| 5 | Description | Text (0) |
| 6 | Volume | Text (0) |
| 7 | Created | Date/Time (3) |
| 8 | Modified (Last Modified in older versions) | Date/Time (3) |
| 9 | Cataloged | Date/Time (3) |
| 10 | Changed (Last Updated in older versions) | Date/Time (3) |
| 11 | File Size | Number (1) |
| 12 | Keywords | Text (0) [3] |
| 13 | Thumbnail | Unknown (-4960) |
| 14 | Custom Thumbnail | Unknown (-5104) |
| 15 | File Type Mac | Text (0) |
| 16 | Creator Mac | Text (0) |
| 17 | Alias Mac | Unknown (-5536) |
| 18 | Zone Mac | Text (0) |
| 19 | Thumbnail Size | Number (1) |
| 20 | Color Mode | Number (1) |
| 21 | Horizontal Resolution | Decimal (2) [4] |
| 22 | Vertical Resolution | Decimal (2) [4] |
| 23 | Width | Number (1) |
| 24 | Height | Number (1) |
| 25 | Category | Number (1) |
| 26 | Number of Pages | Number (1) |
| 27 | Placeholder [1] | Number (1) |
| 28 | Watermarked | Number (1) |
| 29 | Watermark URL | URL (4) |
| 30 | FileStoreID | Number (1) [5] |
| 31 | Directory Path | Text (0) [5] |
| 32 | Item ID | Number (1) [6] |
| 33 | Cataloged By | Text (0) [6] |
| 34 | Changed By | Text (0) [6] |
| 35 | FullyCatalogued | Number (1) [7] |
| 36 | CorruptFile | Number (1) [7] |
| 37 | PartiallyRotated | Number (1) [7] |
| 38 | XMP | (Unknown) [8] |
Prior to v7, some of the data types had different names. Number was called Integer and Text was called String; the change in data type names had no affect on the functional behaviour of these fields. All other type descriptions are unaffected.
Notes:
[1] In some cases the internal name of fields may vary between internal use ('WatermarkURL') and on screen ('Watermark_URL'). The capitalisation shown throughout the list above is as revealed via VB scripting and used by the client UI. Note that if using field names in NetPublish (record.get('Extension Win')) or PortWeb macros (e.g. %Extension Win%) you must preserve the capitalisation and the spaces used by names as seen in the Portfolio UI or the macros will fail. The same principle holds true with any custom fields you create; though you can rename custom fields after creation - but you will need to also update any code pointing to the field.
[2] Field Types: 0 = String or Text Block, 1 = Integer, 2 = Decimal, 3 = Date/Time, 4 = URL
[3] Keywords is a true multivalue (MV) string field; one keyword = one value, although a single 'keyword' may consist of a phrase of more than one word.
[4] The Precision setting of these Decimal fields is unknown.
[5] These fields are only found in v6.x or later.
[6] These fields are only found in v7.x or later.
[7] These fields are only found in v8.0/1.x or later.
[8] These fields are only found in v8.5 or later.
Fields whose entries are italicised are not displayed in the fields lists for either the Gallery's Customisation Options dialog or the Find dialog so cannot be used for display or search purposes (not used via NetPublish/PortWeb). In addition the following fields are not displayed in the various panes of preferences: Short Filename Win, File Type Mac, Creator Mac, Zone Mac, Thumbnail Size, Watermarked, Watermark URL.
The list below is that used in NetPublish to map screen names to internal names:
# # Field mapping properties file # # Used to map the pre-defined database field names to their internal names. # # Only translate the field name on the LEFT of the '=' # # Note: When translating, this file must be encoded using UTF-8! # # # English Internal #-------- -------- Filename = Filename Extension = Extension Win Path = Path Short Filename Win = Short Filename Win Description = File Description Volume = Volume Created = Created Modified = Last Modified Cataloged = Cataloged Changed = Last Updated File Size = File Size Keywords = Keywords File Type Mac = Mac File Type Creator Mac = Mac Creator Alias Mac = Mac Alias Zone Mac = Mac Zone Thumbnail Size = Thumbnail Size Color Mode = Color Mode Horizontal Resolution = Horizontal Resolution Vertical Resolution = Vertical Resolution Width = Width Height = Height Category = Category Number of Pages = MultipageCount Placeholder = PlaceHolder Watermarked = Watermarked Watermark URL = WatermarkURL Directory Path = Directory Path Item ID = RID Cataloged By = Cataloged By Changed By = Updated By Routed To = Routed To
Question: Is there a full list of Portfolio's built-in fields? [FAQ00188.htm]
Last Update:- 24 April 2008
Site and articles © Mark Anderson 2001-2007 - Visit my home page