0

I have an excel file of points which are resurveyed with updated Coordinates.Now I want to update my existing arcsde geodatabase. How can i update only coordinates in FME?

2

GEODB reader, Excel reader, featuremerger (objectid), VertexCreator (replace point), GEODB writer (update, objectid).


The SDE writer can create new tables but also, insert rows and update rows. I'm by no means an SDE export but I think OBJECTID is the unique ID created by SDE. This way only the rows that are merged with excel will get a new coordinate and only updated rows will be sent back to writer. With no attributes changed it will update the row with the same values and new geometry.

I would create a copy of the table in SDE for test, add table sde reader, duplicate on writer, AttributeExposer to get OBJECTID, AttributeKeeper to keep only OBJECTID, duplicate on sde writer, strip all attributes, set writer mode to update, set writer key to OBJECTID.


I built an example with the GDB API in FME 2016. The writer differs but the basics are the same: https://dl.dropboxusercontent.com/u/36253197/update_point.zip

enter image description here

7
  • As its an sde database and other applications are using it so i cant add XY in database schema.I need to update geometry
    – Sibghat
    Jul 20 '16 at 17:06
  • i have followed your steps and working fine up till vertex creator where i have selected the option replace with point and given the Coordinates X and Y from my excel sheet.when i am going for writer mode and giving only OBJECT ID to update errors appear "NULL pointer check failed. File: geodbfeatureclass.cpp Line #: 1010 A fatal error has occurred. Check the logfile above for details "
    – Sibghat
    Jul 21 '16 at 8:02
  • I will try to reproduce you error. What version of FME Desktop and what exact writer do you use? Jul 21 '16 at 8:18
  • FME version 2015.1.1.0 Win 64 Writer Mode -> Update Geometry-> geodb_point Update key field-> OBJECTID
    – Sibghat
    Jul 21 '16 at 9:10
  • Sounds OK to me. Can you share your workbench or printscreen writer parameters? Found only one hit on your errorlog. geonet.esri.com/thread/161845 where it seems they solved it but not stating how exactly... "It turned out I was not implementing the FMEobjects API properly." Jul 21 '16 at 9:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.