Is there a full list of Portfolio's built-in fields?


<< Can I generate email from ...
Back to Portfolio FAQ index
Can I rename a built-in f ... >>

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


<< Can I generate email from ...
Back to Portfolio FAQ index
Can I rename a built-in f ... >>

Quick Search of PortfolioFAQ (word, words or phase): or try the Advanced Search

User-to-User Forums  |  Report error/typo/broken link  |  Request new topic  |  Ask a question

Site and articles © Mark Anderson 2001-2007 - Visit my home page


This FAQ is created and maintained using
Friday logo
Friday - The Automatic FAQ Maker