You could try the UpdateDetector from Custom Transformers:
http://www.fmepedia.com/index.php/Example_Custom_Transformers#UpdateDetector
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" <[EMAIL PROTECTED]>
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
<*> 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/
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
- Visit your group "fme" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
