Component RRTs

Component RRT ID

The RRT ID for this component is SPS.

Reserved Replacement Tag Names (RRTN)

The following table describes the reserved RTN values for this component.

Name Description
FileName The original file name value.
Counter An incremental counter based on the duplicate file names found within a directory. The counter value concatenated with a name provides a unique file name.
FileExt Original file extension value.
DocumentURL URL of the document stored in SharePoint 2007
ListURL URL of the target list. Can be used alone to refer to the list or jointly with the List Item ID to refer to the created item.
ListItemId Numeric identifier assigned to the list item stored (or updated) on SharePoint 2007 server. Can be used as a part of a URL to refer to the item.
ListItemURL URL of the list item stored in SharePoint 2007. The ~SPS::ListItemURL~ RRT is equivalent to ~SPS::ListURL~/DispForm.aspx?ID=~SPS::ListItemId~.

Examples of usage of the above RRTN include:

~SPS::FileName~~SPS::Counter~ is replaced with the filename created by using SharePoint 2007 component.

~SPS::DocumentURL~ is replaced with http://sp2007/New_site/Shared Documents/MyDocument.doc.

~SPS::ListURL~ is replaced with http://sp2007/New_site/Lists/Tasks.

~SPS::ListItemId~ is replaced with 26.

~SPS::ListItemURL~ is replaced with http://sp2007/New_site/Lists/Tasks/DispForm.aspx?ID=26.

Note:

~SPS::Counter~ can be used only on the Documents tab in Rename Schema field.

~SPS::ListItemId~ and ~SPS::ListItemURL~ cannot be used in the component configuration settings. This is because the numeric identifier is assigned to the list item only after the list item is added or updated on the SharePoint 2007 server.

Do not use ~SPS::DocumentURL~ and ~SPS::ListURL~ in Rename Schema field or Folder path field on the Documents tab, because the values of those RRTs contain backslashes and if you choose to use any of those RRTs in any of those fields, it will create an error since no file name or folder name can contain a backslash.

When using SharePoint 2007 eConnector component, do not use ~SPS::DocumentURL~, ~SPS::ListItemURL~ and ~SPS::ListURL~ RRTs in subsequent component Rename Schemas. This is because the values of those RRTs contain backslashes and if you choose to use any of those RRTs as part of a Rename Schema, it will create an error as no file name can contain a backslash.

Field Replacement Tag Names (FRTN)

This component does not have any FRTNs.

Special Set Replacement Tag Names (SSRTN)

This component supports the Date/Time tag names listed below:

SSRTN Description
%a Abbreviated English weekday name (Sun – Sat)
%A Full English weekday name (Sunday – Saturday)
%b Abbreviated English month name (Jan – Dec)
%B Full English month name (January – December)
%d Day of month as 2-digit decimal number (01 – 31)
%H Hour in 24-hour format (00 – 23)
%I Hour in 12-hour format (01 – 12)
%j Day of year as decimal number (001 – 366)
%m Month as decimal number (01 – 12)
%M Minute as decimal number (00 – 59)
%p Current locale's A.M./P.M. indicator for 12-hour clock
%S Second as decimal number (00 – 59)
%U Week of year as decimal number, with Sunday as first day of week (00 – 53)
%w Weekday as decimal number (0 – 6; Sunday is 0)
%W Week of year as decimal number, with Monday as first day of week (00 – 53)
%y Year without century, as decimal number (00 – 99)
%Y Year with century, as decimal number

Examples of usage of the above SSRTN include:

~SPS::%Y~-~SPS::%m~ will be replaced by 2010-04.