Writer Directives – all GeoMedia Warehouses

The following directive applies to both GeoMedia Access Warehouses and GeoMedia SQL Server Warehouses.

The directives listed below are prefixed by the current <WriterKeyword> in a mapping file. By default, the <WriterKeyword> for GeoMedia Access Warehouse is FM0 and the <WriterKeyword> for GeoMedia SQL Server Warehouse is FM0_SQL.

The remaining writer-specific directives are discussed in Writer Directives – GeoMedia Access Warehouse and in Writer Directives – GeoMedia SQL Server Warehouse.

DATASET

The DATASET directive operates in the same manner as it does for the reader.

WAREHOUSE_VERSION

The value of this keyword implies compatibility with warehouses created by GeoMedia – the value does not correspond to GeoMedia versions.

GeoMedia Access Warehouse:

Required/Optional:Optional

Access warehouses created with GeoMedia version 4 are different from Access warehouses created with GeoMedia version 5 because of the changes to metadata tables. FME supports creating Access warehouses which are compatible with warehouses created by all the GeoMedia versions from 4 to 6. If OVERWRITE_DATAFILE is NO, then the writer will determine the version of the existing warehouse and write to it regardless of the setting of WAREHOUSE_VERSION. If the warehouse does not exist, the writer will create a new warehouse whose version will be determined by WAREHOUSE_VERSION keyword setting.

Range:4, 5 or 6

Default:5

By default, GeoMedia Access warehouse version 5 is created for a new warehouse or when overwriting an existing warehouse.
GeoMedia SQL Server Warehouse:

Required/Optional:Optional

With GeoMedia version 5.2, there have been changes to the metadata tables for SQL Server warehouses. FME can create new warehouses or write to existing SQL Server warehouses. When writing to an SQL Server warehouse, there is no option to overwrite, so if a warehouse already exists, then the value of this keyword will be ignored and data will be written to correspond to the warehouse version that exists. This keyword only applies when creating new SQL Server warehouses.

Range: 5, 5.2 or 6

Default:5

Example:

FM0_WAREHOUSE_VERSION 5

or

FM0_SQL_WAREHOUSE_VERSION 5.2

PLAIN_TEXT

Required/Optional: Optional

Note: This directive applies only to writing features of FME type fme_text.

By default, the GeoMedia Access Warehouse Writer will format text objects as rich text format (RTF) to insert the text size as part of the object, since text size cannot be set any other way during translation. In some cases, however, plain text may be desired instead of the default RTF text formatting.

Range:YES or NO

Default:YES

Example:

FM0_SQL_PLAIN_TEXT YES
FM0_PLAIN_TEXT NO

FONT_SIZE

Required/Optional: Optional

This directive allows you to specify the font size in points.

Range:1 - 1024

Default:10