I have managed to get this working using the Attribute Checker. If the version is 1 then insert into database. If any other version number then update the database.
The version number in the OS Mastermap update file specifies whether it is a new TOID or an existing one. Thanks for replies. --- In [email protected], "Jeff Konnen" <[EMAIL PROTECTED]> wrote: > > Hi! > > You could try the UpdateDetector from Custom Transformers: > > http://www.fmepedia.com/index.php/Example_Custom_Transformers#UpdateD etector > > UpdateDetector is based on ChangeDetector and enhances its capabilities by > distinguishing between features that were updated and features that were > added. In works pretty much the same way as ChangeDetector, but requires one > additional parameter - an attribute with unique ID common for the original > and revised versions. > > Jeff > > On 3/17/06, David <[EMAIL PROTECTED]> wrote: > > > > Rod, > > > > What I think you are going to need, is a workspace including the > > ChangeDetector. > > > > The answer I give here won't necessarily be the best or tidiest > > method, but it should work. > > > > The ChangeDetector can detect changes in Geometry or Attributes or > > Both. What I propose is a network of ChangeDetectors to work out what > > features are new, updated, unchanged, or removed. > > > > For this to work, you will nead to have your ESRI Personal Database as > > an input as well (so that FME knows which records are new are which > > are not). > > > > Consider a ChangeDetector that detects changes in both Geometry and > > Attributes. > > Unchanged Features will be output by the Unchanged Port. > > Updated Features will be output by the Deleted Port. (as the geom & > > atts don't match) > > Added Features will be output by the Added Port. > > Removed Features will be output by the Deleted Port. > > > > So we have > > Unchanged: Unchanged (Features) > > Added: Added (Features) > > Deleted: Updated, Removed (Features). > > > > Now consider a ChangeDetector that detects changes in Attributes only > > (i.e detecting only matches on the UID of the records in MM). > > Unchanged Features will be output by the Unchanged Port. > > Updated Features will be output by the Unchanged Port. > > Added Features will be output by the Added Port. > > Removed Features will be output by the Deleted Port. > > > > So we have > > Unchanged: Updated, Unchanged (Features) > > Added: Added (Features) > > Deleted: Removed (Features). > > > > So if we push our ESRI database and OS MM into each of these, we will > > output on the Added & Removed for the Attributes only, those features > > that are added and removed. So with the added features you can output > > that to an ESRI database in INSERT mode. > > The problem we have is determining the Updated Features. We could > > either just output the Unchanged Port of the Attributes only > > ChangeDetector, and let the DB decide that the update isn't necessary > > (which it probably won't do), or we can use another ChangeDetector > > (Geographic & Attributes), to filter out the Unchanged and Updated > > Features. > > > > To do this, we put the Unchanged port of the first (Geometry) > > ChangeDetector to our Original port of the new ChangeDetector. We put > > the Unchanged port of the second (Attributes) ChangeDetector to the > > Revised port of our new ChangeDetector. What we will get on the output > > ports are > > Unchanged: Unchanged Features > > Added: Updated Features > > Deleted: none > > > > From here you can port the data to your ESRI Personal Database in > > UPDATE mode, or anything else you like. > > > > I don't expect this to be super fast however. > > > > If you want the DB to do the hard work, just use the one > > ChangeDetector (the Attributes Only). The DB will receive updates for > > both updated records and unchanged records, but FME will do less work. > > > > I hope this helps. Many thanks, > > > > David Hayes > > > > --- In [email protected], "hanchard_goodwin" <hanchard_goodwin@> > > wrote: > > > > > > Hi, > > > > > > I am new to FME, so be gentle with me! > > > > > > I am trying to write OS MasterMap updates to an existing ESRI Personal > > > Geodatabase. If I run the translation in FME workbench using the INSERT > > > mode it appends all records to the geodatabase. If I use the UPDATE > > > mode it updates only the existing records, but won't add any new ones. > > > > > > How do I run a translation to both update exiting records and append > > > new ones? > > > > > > Thanks > > > > > > Rod > > > > > > > > > > > > > > > > > > > > > Get the maximum benefit from your FME, FME Objects, or SpatialDirect via > > our Professional Services team. Visit www.safe.com/services for details. > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
