Creates, deletes, modifies, and gets Microsoft Exchange tasks, and gets task attachments.
ColdFusion 8: Added this tag.
create <cfexchangetask required action = "create" task = "#task information structure#
" optional connection = "connection ID
" result = "variable for event UID
"> delete <cfexchangetask required action = "delete" uid = "task UID,task UID, ...
" optional connection = "connection ID
"> deleteAttachments <cfexchangetask required action = "deleteAttachments" uid = "task UID
" optional connection = "connection ID
"> get <cfexchangetask required action = "get" name = "query identifier
" optional connection = "connection ID
"> getAttachments <cfexchangetask required action = "getAttachments" name = "query identifier
" uid = "task UID
" optional attachmentPath = "directory path
" connection = "connection ID
"> modify <cfexchangetask required action = "modify"" task = "#task information structure#
" uid = "task UID
"> optional connection = "connection ID
">
cfexchangecalendar, cfexchangeconnection, cfexchangecontact, cfexchangefilter, cfexchangemail, "Interacting with Microsoft Exchange Servers" in the ColdFusion Developer's Guide.
The following table provides detailed information about each attribute. It lists the attribute name, the actions (action attribute values) to which it apples, whether it is required or optional for those actions, and its default value, if any, and provides a detailed description of the attribute and its valid values.
Attribute |
Action |
Req/Opt |
Default |
Description |
---|---|---|---|---|
action |
all |
Required |
|
The action to take. Must be one of the following values:
|
attachmentPath |
getAttachments |
Optional |
|
The filepath of the directory in which to put the attachments. If the directory does not exist, ColdFusion creates it. Note: If you omit this attribute, ColdFusion does not save any attachments. If you specify a relative path, the path root is the ColdFusion temporary directory, which is returned by the GetTempDirectory function. |
connection |
all |
Optional |
|
The name of the connection to the Exchange server, as specified in the cfexchangeconnection tag. If you omit this attribute, you must create a temporary connection by specifying cfexchangeconnection tag connection attributes in the cfexchangetask tag. |
name |
get getAttachments |
Required |
|
The name of the ColdFusion query variable that contains the returned task records or information about the attachments that were retrieved. For more information on the returned data, see Usage. |
result |
create |
Optional |
|
The name of a variable that contains the UID of the task that is created. You use this value in the uid attribute of other actions to identify the task to be acted on. |
task |
create modify |
Required |
|
A reference to the structure that contains the task properties to be set or changed and their values. You must specify this attribute in number signs (#). For more information on the event structure, see Usage. |
uid |
delete getAttachments modify |
Required |
|
A case-sensitive Exchange UID value that uniquely identifies the tasks on which to perform the action. For the delete action, this attribute can be a comma-delimited list of UID values. The deleteAttachments, getAttachments, and modify actions allow only a single UID value. |
When you specify the create or modify action, the task attribute must specify a structure that contains information that defines the events. The structure can have the following fields. You have to include only the fields that you are setting or changing.
Column |
Description |
---|---|
ActualWork |
A number in minutes. Cannot be less than zero. |
Attachments |
The pathnames of any attachments to include in the task. To specify multiple files, separate filepaths with semicolons (;) for Windows, and colons (:) for UNIX and Linux. You must use absolute paths. If you specify one or more attachments for a modify action, these are added to any existing attachments; the pre-existing attachments are not deleted. |
BillingInfo |
A string. |
Companies |
A string. |
DateCompleted |
A string in a date format that is valid in ColdFusion. If you omit this field and set the Status field to completed, or set the PercentCompleted field to 100, this value is set to the current date. If you set this date, the Status value is set to Completed and the PercentCompleted field is set to 100. |
DueDate |
A string in a date format that is valid in ColdFusion. |
Message |
A string containing the task description. |
Mileage |
A string. |
PercentCompleted |
A number in the range 0-100. If you set this field to 100, The following values are set:
If you set this value to a number with a value less than 100, the following values are set:
|
Priority |
One of the following values:
|
ReminderDate |
A string in a date format that is valid in ColdFusion. |
StartDate |
A string in a date format that is valid in ColdFusion. When you create a task, the default value defaults is the current date. |
Status |
The following values are valid: Not_Started, In_Progress, Completed, Waiting, or Deferred. If you omit this field and the PercentCompleted value is less than 100, the Status value it is set to In_Progress. If you set this field to Completed, the following values are also set:
If you set this field to a value other than Completed, the following values are also set:
|
Subject |
A String. |
TotalWork |
A number in minutes. Cannot be less than zero. |
The cfexchangetask tag manages task records on the Exchange server. Use the cfexchangetask tag to perform the following actions:
To use this tag, you must have a connection to an Exchange server. If you are using multiple tags that interact with the exchange server, such as if you are creating several task records, you should use the cfexchangeconnection tag to create a persistent connection. You then specify the connection identifier in each cfexchangetask, or any other ColdFusion Exchange tag, if you are also accessing calendar entries, contacts, or mail. Doing this saves the overhead of creating and closing the connection for each tag.
Alternatively, you can create a temporary connection that lasts only for the time that ColdFusion processes the single cfexchangetask tag. To do this, you specify the connection attributes directly in the cfexchangetask tag. For details on the connection attributes, see the cfexchangeconnection tag.
When you specify the delete action, you must specify a uid attribute with a comma-delimited list of one or more Exchange UIDs that identify the tasks to delete. You can use the get action, with an appropriate filter expression, to determine the UID values to specify.
If all UIDs that you specify are invalid, the cfexchangetask tag generates an error. If at least one UID is valid, the tag ignores any invalid UIDs and deletes the items specified by the valid UID.
When you specify the get action, the query object specified by the name attribute contains one record for each retrieved task. The query object has columns with the same names and data formats as the fields listed for the task attribute structure, with the following differences:
You use child cfexchangefilter tags to specify the messages to get. For detailed information, see cfexchangefilter.
When you use the getAttachments action, you must specify a single UID and a name attribute. The cfexchangetask tag populates a query object specified by the name attribute with the specified name. Each record has the following information about an attachment to the specified task:
Column name |
Description |
---|---|
attachmentFileName |
The filename of the attachment. |
attachmentFilePath |
The absolute path of the attachment file on the server. If you omit the attachmentPath attribute, this column contains the empty string. |
CID |
The content-ID of the attachment. Typically used in HTML img tags to embed images in a message. |
mimeType |
The MIME type of the attachment, such as text/html |
isMessage |
A Boolean value that specifies whether the attachment is a message. |
size |
The attachment size, in bytes. |
If you omit the attachmentPath attribute, ColdFusion does not get any attachments; it gets only the information about the attachments. This lets you determine the event's attachments without incurring the overhead of getting the attachment files.
If you specify the modify action, the uid attribute must specify a single Exchange UID. The task structure needs to specify only the fields that you are changing. Any fields that you do not specify remain unchanged. For a detailed description of the contents of the task structure, see the Attributes section.
If a task has attachments and you specify attachments when you modify the task, the new attachments are added to the previous attachments, and do not replace them. You must use the deleteAttachments action to remove any attachments.
The following example uses a transient connection to create a single task:
<!--- Create a structure with the task fields ---> <cfscript> stask=StructNew(); stask.Priority="high"; stask.Status="Not_Started"; stask.DueDate="3:00 PM 09/14/2007"; stask.Subject="My New Task"; stask.PercentCompleted=0; Message="Do this NOW!"; </cfscript> <!--- Create the task using a transient connection. ---> <cfexchangetask action="create" username ="#user1#" password="#password1#" server="#exchangeServerIP#" task="#stask#" result="theUID"> <!--- display the UID to confirm that the action completed. ---> <cfdump var="#theUID#">