Description
The Smallworld FME Translator 4.2.2 (released December 2010) now supports incremental updates to the Smallworld VMDS. The attached FME Template illustrates how this is done using a source GML update file.
Requirements
- Smallworld 4.2 (or Smallworld 4.2 TSB)
- Smallworld FME Translators 4.2.2
- FME Smallworld Edition (2011 or higher) - the example workspace was created using FME 2012
This example uses the Cambridge Electricity database. Before running the example workspace you should create a target alternative (version) in the Electricity database.
Approach
FME Translator 4.2.2 does not change the approach to loading Smallworld geometries using FME and this is described in:
Writing Multiple Geometry features to Smallworld v4 (List Based).
Set the fme_db_operation attribute to INSERT, UPDATE or DELETE (AttributeValueMapper is usually a good choice for doing this)
- For INSERTS, remove the sys_id field, in this illustration it is the "id" attribute.
- Ensure the sworld_geometry{}.sworld_name attribute is set to the correct geometry field name.
In general, the hardest part of loading incremental updates into Smallworld is determining which records are inserts, updates or deletes. In this example the GML data has an update_type attribute with values I,D, or U which can be mapped to fme_db_operation.
The
Spatial Business Systems Smallworld reader/writer plug-in is an alternative reader/writer and also uses the fme_db_operation.