Microsoft SharePoint List Writer: User Attributes

For information on the parameters in this dialog that are specific to all formats, see About Writer Feature Types: User Attributes

User attributes for this format are defined below.

Field Name

The name of the Field to be written.

Field Type

The table below specifies the types of Fields that the SharePoint Reader can read, and the types of Fields that the SharePoint Writer can create and write.

  • Not implemented: The SharePoint Reader/Writer has not yet added support for the Field type.
  • No: It is not possible to support the Field type.

Some Field types are only available for use within certain List types.

Field Type Read Write Description
Integer Yes Yes 32-bit signed integer value
Text Yes Yes Single line of text
Note Yes Yes Contains HTML to allow for line breaks and other paragraph styling
DateTime Yes Yes

SharePoint stores values in UTC time zone only.

The SharePoint web interface adjusts values to the local time zone.

The SharePoint reader converts values to FME datetime format.

The SharePoint writer accepts values in FME datetime format. If input values do not specify a time zone, the writer assumes the local time zone, adjusting for daylight saving time, if necessary.

Counter Yes Yes 32-bit signed integer value
Choice Yes Yes

String value.

When the SharePoint writer creates a field of this type, the field is configured to allow free-form input, and the SharePoint web interface will not show a list of values to choose from. Use the SharePoint web interface to configure the values that appear in the web interface’s drop-down for this field. Note that SharePoint API allows writing arbitrary values to Choice fields, regardless of whether the field is configured to allow free-form input. The free-form input restriction only applies to the web interface.

Lookup Not implemented Not implemented  
Boolean Yes Yes True or False
Number Yes Yes Floating point value
Currency Yes Yes Floating point value
URL Yes Yes String value, where either a forward slash or one of the following URL schemes is required: file://, ftp://, http://, https://, mailto://, mms://, news://, nntp://, rtsp://
Computed Yes Not implemented String value that was generated by SharePoint.
Threading No No  
Guid Yes Yes String representation of a GUID
MultiChoice Yes Yes

String value, where each choice is delimited by a semicolon.

The SharePoint writer creates fields of this type in a manner similar to the Choice type. However, fields of this type may appear to be read-only when viewed from the SharePoint web interface.

GridChoice No No  
Calculated Yes Not implemented String representing a formula
File No No  
Attachment Yes No Boolean stating whether an attachment exists on an Item
User Yes Yes String value of a valid SharePoint site user. Strings that represent invalid users (that is, they do not exist) will not be written.
Recurrence No No  
CrossProjectLink No No  
ModStat Yes Yes String value of the following options: Approved, Rejected, Pending, Draft, Scheduled (case-insensitive) or an integer value from 0 to 4 inclusive, representing the strings listed above.
Error No No  
ContentTypeId Yes No Integer value
PageSeparator No No  
ThreadIndex No No  
WorkflowStatus No No  
AllDayEvent No No  
WorkflowEventType Yes Yes Numeric string literal
GeoLocation Yes Yes String value that contains a latitude, longitude and an optional altitude, delimited by semicolons (for example, 45.0; 90.0; 100.0). Specifications for valid coordinates can be found in Microsoft documentation.
TaskOutcome Yes Yes String value