Reader Directives

The directives that are processed by the Schema (From Table) reader are listed below.

The suffixes shown are prefixed by the current <ReaderKeyword> in a mapping file. By default, the <ReaderKeyword> for the Schema (From Table) reader is SCHEMAFROMTABLE.

DATASET

The Schema (From Table) reader uses this directive to specify a source dataset that will be passed on to the underlying reader.

A dataset can be one or more files, a folder, a URL, or a database name.

• For file-based readers like MIF and Shape that have well-known extensions, the reader will guess the format name from the extension if no format was specified.
• For readers that require a folder as the source dataset, a filename will be used to get the enclosing folder by removing the filename part from the path. For example, if at runtime the Schema (From Table) reader was given a source dataset of c:/data/roads/arcinfo/test.adf, and was told to read using PATH reader, then c:/data/roads would be used as the input dataset for the PATH reader.

Required/Optional

Required

SCHEMA_TABLE_NAME

This directive specifies the name of the table from the source dataset that is used for retrieving the schema information.

SCHEMAFROMTABLE_SCHEMA_TABLE_NAME myTable

Required/Optional

Required

Workbench Parameter

Schema Table

FEATURE_TYPE_COLUMN

This directive specifies the column name that contains the feature type name to use when creating schema information feature. The output attribute that will be set is fme_feature_type_name.

Mapping File Syntax

SCHEMAFROMTABLE_FEATURE_TYPE_COLUMN Layer_Name

Required/Optional

Required

Workbench Parameter

Feature Type Column

ATTRIBUTE_NAME_COLUMN

This directive specifies the column name that contains the attribute names to use when creating schema information feature. Output attributes that will be affected will be of the form attribute{n}.name.

Mapping File Syntax

SCHEMAFROMTABLE_ATTRIBUTE_NAME_COLUMN Attribute_Name

Required/Optional

Required

Workbench Parameter

Attribute Name Column

ATTRIBUTE_TYPE_COLUMN

This specifies the column name that contains the attribute’s type to use when creating schema information feature.

Attribute type must be one of: {fme_char(width), fme_varchar(width), fme_buffer, fme_datetime, fme_date , fme_time, fme_decimal(width,decimal), fme_real32, fme_real64, fme_int32, fme_boolean, fme_int16, fme_buffer}.

Output attributes that will be affected will be of the form attribute{n}.fme_data_type.

Mapping File Syntax

SCHEMAFROMTABLE_ATTRIBUTE_TYPE_COLUMN Attribute_Type

Required/Optional

Required

Workbench Parameter

Attribute Type Column

GEOMETRY_TYPE_COLUMN

This directive specifies the column name that contains the geometry type, to use when creating schema information feature. If no column is designated to contain geometry type, FME will add all possible geometry types to the generated schema feature.

The value of geometry type could be one or more from the following list (as documented in fme_type):

{fme_arc, fme_area, fme_collection, fme_ellipse, fme_line, fme_no_geom, fme_point, fme_raster, fme_solid, fme_surface, fme_text, fme_point_cloud}

Multiple values can be specified using the delimiter specified in the MULTI_VALUE_SEPARATOR parameter. The default is a semicolon (;).

Output attributes that will be affected will be of the form fme_geometry{n}.

Mapping File Syntax

SCHEMAFROMTABLE_GEOMETRY_TYPE_COLUMN fme_line;fme_arc;fme_ellipse

Required/Optional

Optional

Workbench Parameter

Geometry Type Column

MULTI_VALUE_SEPARATOR

This directive specifies the delimiter value to use when a column contains multiple values. For example, the value of GEOMETRY_TYPE_COLUMN can contain multiple values.

Mapping File Syntax

SCHEMAFROMTABLE_MULTI_VALUE_SEPARATOR delimiter

Required/Optional

Optional

Workbench Parameter

Multivalue Separator

ATTRIBUTE_NAME_SEQUENCE_COLUMN

This specifies the column name that contains information about how to order the schema attributes. In the example table shown in the Reader Overview, the schema will have the attributes in the following order:

• Park ID
• Park Name
• Park Short Name

Mapping File Syntax

SCHEMAFROMTABLE_ATTRIBUTE_NAME_SEQUENCE_COLUMN Attribute_Order

Required/Optional

Optional

Workbench Parameter

Attribute Name Sequence Column