Tyler Data & Insights User Attributes

Readers: For information on the parameters in this dialog that are common to all readers, see:

Writers: For information on the parameters in this dialog that are common to all writers, see:

User attributes for this format are defined below.

Name

The name (fieldName) of the column to be written. This is the programmatic name, which should not contain spaces or uppercase. However, if the name contains spaces, the writer will replace them with underscores before attempting to use it as a fieldName.

Type/Description

The Tyler Data & Insights data type for the column. Refer to SODA Datatypes for more details.

Legacy Types

Data & Insights has some legacy data types, such as money and location. The reader will warn when encountering these types, and represent them as text.

Text

The text data type is used to represent string values.

Checkbox

The checkbox data type is used to represent boolean values.

URL

The url data type is used to represent links. These can be provided without a description (for example, https://safe.com) or with display text.

A URL with a description should be provided in the format <url_description> (<url>) (for example, Safe Software (https://safe.com))

Number

The number data type is used to represent numeric values of arbitrary precision

Date/Time

calendar_date

This data type represents a date or datetime. The reader returns values as-is from the server. The writer passes values as-is to the server, and lets the server infer the date/time format via schema scan.

Geometric Types

point, line, polygon, multipoint, multiline, multipolygon

These are the geometric data types. Their values are in Well Known Text (WKT) format.

  • Use the GeometryExtractor transformer to convert FME geometry into a WKT attribute.
  • Use the GeometryReplacer transformer to convert a WKT attribute into an FME geometry.

Index

Specifies the column to declare as the Row Identifier (RowID).

Values in this column must be unique. If a Row Identifier is specified, Tyler Data & Insights will validate all Row Identifier values in the dataset. Only one column may be declared as RowID.