List of Supported Formats

Search the Online Transformer Gallery

SDF3 Writer: Format Parameters

To access feature type parameters, click the gear icon on a feature type in the workspace to open the Feature Type Parameter Editor. To always display the editor in Workbench, you can select View > Windows > Parameter Editor.

All feature types share similar General Parameters. This includes Name and Writer Name. From here, you can also control Dynamic Properties.

These parameters apply only to a selected feature type, not to the entire writer.

Tip: If a feature type parameter listed here conflicts with a writer-level parameter, then the writer parameter will be ignored and this feature type parameter will be used.

Table Settings

ClosedWriter Mode

The writer mode can be specified on the feature type or on individual features.

At the feature type level, the writer mode is specified by this parameter. It may be superseded on individual features by the fme_db_operation format attribute.

Valid feature type writer modes are listed below:

Mode Description
INHERIT_FROM_WRITER
  • Inherit the value set in the Autodesk MapGuide Enterprise SDF Writer Parameters.
    		•
    INSERT

    Appends features to the end of the sheet, or writes them to an exact row and/or column.

    Any data that already exists in that location will be overwritten. If there is a row value specified for the Row Number Attribute, that row will be used instead.

    UPDATE

    Causes the row corresponding to the feature’s value specified in the Row Number Attribute to have its data changed to the values on the incoming feature.

    If an attribute is missing on the incoming feature, the existing cell value will not be overwritten.
    DELETE

    Deletes the values in the row corresponding to the feature’s value specified in the Row Number Attribute.

    Only a number of columns equal to the amount of columns on the incoming feature will have their data and formatting removed.
    ClosedOverwrite Table
    • No: The table will be created if it does not exist.
    • Yes: The table will be dropped if it exists, then created.
    • Truncate: If the table does not exist, it will be created. If the table does exist, then all its rows will be deleted.
    ClosedGeometry Column Name(s)

    A comma-separated list of the geometry column names for writing.

    Location columns will be created for each of the supplied geometry column names when creating a new table or matched against the existing geometry columns when writing to an existing table.

    Note: If the column names listed here conflict with any user attributes, the columns listed here take precedence.

    This parameter has no effect when the Writer Mode is DELETE.

    ClosedDefault auto-generated identity column

    Specifies the name of the default index attribute that is added to the feature type if no user attribute is specified with an IDENTITY index type. This parameter defaults to PRIMARYINDEX.