Skip Headers
Oracle® Calendar Application Developer's Guide
10g Release 1 (10.1.2)

Part Number B25489-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

A Oracle Connector for Outlook Components and Properties

The following appendix describes Oracle-specific components and properties supported by Oracle Connector for Outlook.

Components of iCalendar

The following tables describe Oracle-specific properties of the iCalendar components VEVENT, VTODO, and VJOURNAL that are supported by Oracle Connector for Outlook. The following tables also describe the Oracle-specific component X-ORACLE-STICKYNOTE.

The following are clarifications of some of these table's headings and abbreviations:

VEVENT

Describes appointments, daily notes, day events, and holidays.

Table A-1 Component Properties of VEVENT

Component Property Minimum Occurrences Maximum Occurrences Data Type

X-ORACLE-DESCRIPTION-COMPRESSEDRTF


0

1

compressed RTF format

X-ORACLE-OBJECTOWNER


0

1

TEXT


VTODO

The VTODO component describes tasks stored in the Oracle Calendar server.

Table A-2 Component Properties of VTODO

Component Property Minimum Occurrences Maximum Occurrences Data Type

X-ORACLE-BILLINGINFO


0

1

TEXT

X-ORACLE-DESCRIPTION-COMPRESSEDRTF


0

1

compressed RTF format

X-ORACLE-ESTIMATEDTIME


0

1

TEXT

X-ORACLE-MILELAGE


0

1

TEXT

X-ORACLE-TIMESPENT


0

1

TEXT


X-ORACLE-STICKYNOTE

An Oracle-specific component that describes personal notes that are appended to a Calendar entry.

Table A-3 Component Properties of X-ORACLE-STICKYNOTE

Component Property Minimum Occurrences Maximum Occurrences Data Type

CREATED

0

1

DATE-TIME

DESCRIPTION

0

1

TEXT

DTSTAMP

0

1

DATE-TIME

LAST-MODIFIED

0

1

DATE-TIME

UID

0

1

TEXT

X-ORACLE-COLORID


1

1

INTEGER

X-ORACLE-DESCRIPTION-COMPRESSEDRTF


0

1

compressed RTF format

X-ORACLE-GEOMETRY


1

1

four INTEGER values separated by semicolons

X-ORACLE-STICKYNOTE-GUID


0

1

TEXT


VJOURNAL

Describes records and tracking information for important activities of all types.

Table A-4 Component Properties of VJOURNAL

Component Property Minimum Occurrences Maximum Occurrences Data Type

X-ORACLE-DESCRIPTION-COMPRESSEDRTF


0

1

compressed RTF format

X-ORACLE-ENTRYTYPE


1

1

TEXT


VEVENT, VTODO, VALARM, X-ORACLE-STICKYNOTE Component Properties

The following describes Oracle-specific component properties of the VEVENT, VTODO, VALARM, VJOURNAL, and X-ORACLE-STICKYNOTE calendar components.

X-ORACLE-BILLINGINFO

Describes information related to billing for the task described by the VTODO, such as account information. The property can be specified once in the VTODO calendar component. The following is a list of colors and their corresponding ID:

The following is an example of this property:

X-ORACLE-BILLINGINFO:J. Smith & Ass.\, $45.00/hour

X-ORACLE-COLORID

Represents the display color of a sticky note. The property can be specified once in the X-ORACLE-STICKYNOTE calendar component.

Table A-5 Sticky Node Colors and Color IDs

Color Color ID

Blue

0

Green

1

Pink

2

Yellow

3

White

4


The following is an example of this property:

X-ORACLE-COLORID:2

X-ORACLE-DESCRIPTION-COMPRESSEDRTF

Represents the description in compressed RTF format. If users modify this property, they should take care to ensure that the plain-text version in the DESCRIPTION property is also appropriately modified. The property can be specified in the "VEVENT", "VTODO", "VJOURNAL", and "X-ORACLE-STICKYNOTE" calendar components.

The property is defined by the following notation:

x-oracle-description-compressedrtf =
                       "X-ORACLE-DESCRIPTION-COMPRESSEDRTF"
                       x-oracle-description-compressedrtfparam
                       ":" binary CRLF
 
x-oracle-description-compressedrtfparam = 2*( 
 
                       ; the following are REQUIRED,
                       ; but MUST NOT occur more than once
 
                       (";" valuetypeparam) /
                       (";" encodingparam ) /
 
                       ; the following are optional,
                       ; but MUST NOT occur more than once
                    
                       (";" languageparam) /
                       (";" x-oracle-internal-checksumparam ) /
 
                       ; the following is optional,
                       ; and MAY occur more than once
 
                       (";" xparam)
 
                       )

The following is an example of this property:

X-ORACLE-DESCRIPTION-COMPRESSEDRTF;VALUE=BINARY;ENCODING=BASE64:

X-ORACLE-ENTRYTYPE

Specifies the type of activity or item that the journal item is keeping record of.

X-ORACLE-ESTIMATEDTIME

Represents the number of minutes of work allocated to complete the task described by the VTODO.

The following is an example of this property:

X-ORACLE-ESTIMATEDTIME:+PT300M

X-ORACLE-GEOMETRY

Represents the size and position on screen of the displayed sticky note. The value is four semicolon separated integer values. Each of these integers represent (in sequence) horizontal coordinate of the top left pixel, vertical coordinate of the top left pixel, width of the note, and height of the note. The property may be specified once in the X-ORACLE-STICKYNOTE component.

The following is an example of this property:

X-ORACLE-GEOMETRY:556;121;90;83

X-ORACLE-MILELAGE

Specifies mileage accrued while working on the task described by theVTODO, for billing purposes.

The following is an example of this property:

X-ORACLE-MILEAGE:137km

X-ORACLE-OBJECTOWNER

Describes the organizer of a meeting. This is the user that created the meeting. The property can be specified once in the "VEVENT" calendar.

The following is the definition of this property:

x-oracle-objectowner = "X-ORACLE-OBJECTOWNER" x-oracle-objectownerparam ":"
                       text CRLF

x-oracle-objectownerparam = *(

                            ; the following is optional,
                            ; but MUST NOT occur more than once
 
                            (";" cnparam) /
 
                            ; the following is optional,
                            ; and MAY occur more than once
 
                            (";" xparam)
 
                            )

The following is an example of this property:

X-ORACLE-OBJECTOWNER;CN="John Smith":mailto:jsmith@example.com

X-ORACLE-STICKYNOTE-GUID

Uniquely identifies X-ORACLE-STICKYNOTE components.

X-ORACLE-TIMESPENT

Specifies the number of hours spent on the task described by the VTODO. (See X-ORACLE-ESTIMATEDTIME).

Parameters of iCalendar Component Properties

The following describes Oracle-specific parameters (that are supported by Oracle Connector for Outlook) of iCalendar component properties.

X-ORACLE-FILENAME

Specifies the file name of an attachment.

The following is an example of this parameter:

ATTACH;X-ORACLE-FILENAME=test.txt;ENCODING=BASE64;VALUE=BINARY:
  MIICajCCAdOgAwIBAgICBEUwDQYJKoZIhvcNAQEEBQAwdzELMAkGA1UEBhMCVV
  MxLDAqBgNVBAoTI05ldHNjYXBlIENvbW11bmljYXRpb25zIENVBAoTI05ldHNX
  <...remainder of "BASE64" encoded binary data...>

X-ORACLE-INTERNAL-CHECKSUM

Specifies the checksum of the DESCRIPTION property at the time the X-ORACLE-DESCRIPTION-COMPRESSEDRTF property was last modified.

The following is an example of this parameter:

X-ORACLE-DESCRIPTION-COMPRESSEDRTF;X-ORACLE-INTERNAL-CHECKSUM=17262384;
  VALUE=BINARY;ENCODING=BASE64:aMIICajCCAdgAwI
  BAgICBEUxLDABgkasdjflwr84rdnBvcmF==

X-ORACLE-LABELID

Integer representing the attendee's chosen display label of the event.

The following is an example of this parameter:

ATTENDEE;X-ORACLE-LABELID=3:mailto:john.smith@example.com

Components of vCard

The following table describes the Oracle-specific components of vCard.

VCARD

Describes business and personal contacts in a Calendar user's address book.

Table A-6 Component Properties of vCard

Component Minimum Occurrences Maximum Occurrences Data Type

X-ORACLE-ACCOUNTID


0

1

TEXT

X-ORACLE-ANNIVERSARY


0

1

Date value

X-ORACLE-ASSISTANTNAME


0

1

TEXT

X-ORACLE-BILLINGINFO


0

1

TEXT

X-ORACLE-CHILDREN


0

n*

TEXT

X-ORACLE-COMPANYNAME-YOMI


0

1

TEXT

X-ORACLE-COMPUTERNETWORK


0

1

TEXT

X-ORACLE-CONTACT


0

n

TEXT

X-ORACLE-CONTACT-EMAIL-SELECTORS


0

1

Single structured text value, separated by an escaped COMMA character (ASCII decimal 44).

X-ORACLE-CONTACT-EXTRA-SELECTORS


0

1

Single structured text value, separated by an escaped COMMA character (ASCII decimal 44).

X-ORACLE-CONTACT-FILESELECTOR


0

1

Integer value

X-ORACLE-CUSTOMERID


0

1

TEXT

X-ORACLE-DISTRIBUTIONLIST-MEMBER


0

1

TEXT values separated by semicolons

X-ORACLE-FIRSTNAME-YOMI


0

1

TEXT

X-ORACLE-FOLLOWUPINFO


0

1

TEXT values separated by semicolons

X-ORACLE-FTPURL


0

1

TEXT

X-ORACLE-GENDER


0

1

TEXT

X-ORACLE-GOVERNMENTID


0

1

TEXT

X-ORACLE-HOBBIES


0

1

TEXT

X-ORACLE-INSTANTMSGADDRESS


0

1

TEXT

X-ORACLE-LANGUAGEINFO


0

1

TEXT

X-ORACLE-LASTNAME-YOMI


0

1

TEXT

X-ORACLE-MANAGERNAME


0

1

TEXT

X-ORACLE-MILEAGE


0

1

TEXT

X-ORACLE-NOTE-COMPRESSEDRTF


0

1

TEXT (Must have an X-ORACLE- INTERNAL- CHECKSUM parameter)

X-ORACLE-OBJECTTYPE


0 (Minimum one occurrence for a distribution list)

1

TEXT

X-ORACLE-ORGANIZATIONID


0

1

TEXT

X-ORACLE-REFERREDBY


0

1

TEXT

X-ORACLE-SENSITIVITY


0

1

TEXT

X-ORACLE-SPOUSE


0

1

TEXT

X-ORACLE-USERFIELD1


0

1

TEXT

X-ORACLE-USERFIELD2


0

1

TEXT

X-ORACLE-USERFIELD3


0

1

TEXT

X-ORACLE-USERFIELD4


0

1

TEXT


vCard Component Properties

The following describes the iCalendar and Oracle-specific component properties of vCard.

X-ORACLE-ACCOUNTID

Specifies an account identifier for the object the vCard represents.

X-ORACLE-ANNIVERSARY

Specify the anniversary of the object the vCard represents.

X-ORACLE-ASSISTANTNAME

Specifies the name of the assistant of the object the vCard represents.

X-ORACLE-BILLINGINFO

Specifies information related to billing for the object the vCard represents.

X-ORACLE-CHILDREN

Specifies the children of the object the vCard represents. The free-form format of this type allows for descriptive elements in addition to a list of names.

The following are examples of this property:

X-ORACLE-CHILDREN:Jane, John (step-son)

X-ORACLE-CHILDREN:Smith\, Jane, Smith\, John

X-ORACLE-COMPANYNAME-YOMI

Specifies Yomi representation of the company name of the object the vCard represents.

The following is an example of this property:

X-ORACLE-COMPANYNAME-YOMI:=83J=83^=83J-83i

X-ORACLE-COMPUTERNETWORK

Specifies the computer network name of the object the vCard represents.

X-ORACLE-CONTACT

Specifies a contact of the object the vCard represents.

X-ORACLE-CONTACT-EMAIL-SELECTORS

Specifies additional information that Microsoft Outlook preserves for the object the vCard represents.

The following is an example of this property:

X-ORACLE-CONTACT-EMAIL-SELECTORS:32896\,329121\,32928

X-ORACLE-CONTACT-EXTRA-SELECTORS

Specifies additional information that Microsoft Outlook preserves for the object the vCard represents.

X-ORACLE-CONTACT-FILESELECTOR

Specifies the format in which the "File As" should be displayed in Microsoft Outlook for this vCard.

X-ORACLE-CUSTOMERID

Specifies the assigned customer ID of the object the vCard represents.

X-ORACLE-DISTRIBUTIONLIST-MEMBER

Specifies a member of a distribution list. Not applicable to conventional vCards representing an individual. This structured value type value corresponds, in sequence, to the Address Type, the Address, and Display Name. The text components are separated by the SEMI-COLON character (ASCII decimal 59).

The following table describes the property parameters of X-ORACLE-DISTRIBUTION-MEMBER:

Table A-7 Parameters of X-ORACLE-DISTRUBUTIONLIST-MEMBER

Parameter Description

X-ORACLE-ADDRESSTYPE

Text value, specifies the address type of a member of a distribution list

X-ORACLE-MEMBERNAME

Text value, specifies the name of a member of a distribution list


The following is an example of this type:

X-ORACLE-DISTRIBUTIONLIST-MEMBER;X-ORACLE-MEMBERNAME=John Smith;
  X-ORACLE-ADDRESSTYPE=OCS:john.smith@example.com

X-ORACLE-FIRSTNAME-YOMI

Specifies the Yomi representation of the first name of the object the vCard represents.

The following is an example of this property:

X-ORACLE-FIRSTNAME-YOMI:=83J=83^=83J-83i

X-ORACLE-FOLLOWUPINFO

Specifies a followup note for the object the vCard represents. This structured type value corresponds, in sequence, to the Followup Date and Followup Note.

The following table describes the property parameters of X-ORACLE-DISTRIBUTION-MEMBER:

Table A-8 Parameters of X-ORACLE-FOLLOWUPINFO

Parameter Description

X-ORACLE-COMPLETIONTIME

DATE-TIME value (iCalendar format, not vCard), specifies the completion time of a followup note

X-ORACLE-COMPLETED


X-ORACLE-FOLLOWUPDATE

DATE-TIME value (iCalendar format, not vCard), specifies the date for the followup.


The following is an example of this property:

X-ORACLE-FOLLOWUPINFO;X-ORACLE-COMPLETIONTIME=20050516T201900Z;
  X-ORACLE-COMPLETED=1;X-ORACLE-FOLLOWUPDATE=20050516T201900Z:
  Follow up note.

X-ORACLE-FTPURL

Specifies the FTP URL of the object the vCard represents.

X-ORACLE-GENDER

Specifies the gender of the object the vCard represents.

X-ORACLE-GOVERNMENTID

Specifies the assigned government ID number of the object the vCard represents.

X-ORACLE-HOBBIES

Specifies a list or description of the hobbies of the object the vCard represents.

X-ORACLE-INSTANTMSGADDRESS

Specifies the instant messaging address of the object the vCard represents.

X-ORACLE-LANGUAGEINFO

Specify language-related information about the object the vCard represents.

X-ORACLE-LASTNAME-YOMI

Specifies the Yomi representation of the last name of the object the vCard represents.

X-ORACLE-MANAGERNAME

Specify the name of the manager of the object the vCard represents.

X-ORACLE-MILEAGE

Specify mileage accrued in activities related to the object the vCard represents, for billing purposes.

X-ORACLE-NOTE-COMPRESSEDRTF

Specifies the NOTE type in compressed RTF format. This property must have an X-ORACLE-INTERNAL-CHECKSUM parameter. If users modify this type, they should ensure that the plain-text version in the NOTE type is also appropriately modified to remain in sync.

The following is an example of this type:

X-ORACLE-NOTE-COMPRESSEDRTF;X-ORACLE-INTERNAL-CHECKSUM=23452342;
  ENCODING=BASE64:dGhpcyBpcyBub3QgcnRmCg==

X-ORACLE-OBJECTTYPE

Specifies the type of object that the vCard represents. Valid values for this type are "PERSON" and "DISTRIBUTION LIST".

X-ORACLE-ORGANIZATIONID

Specifies the assigned organization ID of the object the vCard represents.

X-ORACLE-REFERREDBY

Specifies the referrer of the object the vCard represents. The referrer could be a person or organization.

X-ORACLE-SENSITIVITY

Specifies the sensitivity of the information in the vCard. Valid values for this property are "NORMAL", "PERSONAL", "PRIVATE", and "CONFIDENTIAL".

X-ORACLE-SPOUSE

Specifies the spouse of the object the vCard represents.

X-ORACLE-USERFIELD1

Specifies the contents of the first user-defined field of the object the vCard represents. The semantics of this type are dependent on the user's field definition, and can vary from user to user.

X-ORACLE-USERFIELD2

Specifies the contents of the second user-defined field of the object the vCard represents. The semantics of this type are dependent on the user's field definition, and can vary from user to user.

X-ORACLE-USERFIELD3

Specifies the contents of the third user-defined field of the object the vCard represents. The semantics of this type are dependent on the user's field definition, and can vary from user to user.

X-ORACLE-USERFIELD4

Specifies the contents of the fourth user-defined field of the object the vCard represents. The semantics of this type are dependent on the user's field definition, and can vary from user to user.