Thanks Mark & Jeff, I see what you mean now, I've got it working!
cheers, Rune --- In [email protected], "mark2atsafe" <[EMAIL PROTECTED]> wrote: > > Hi Rune, > I think that Jeff is saying that it's easier to use an SDE writer than > to use a transformer. I think I'd agree. In the past I have always > done it that way. > > What you'll probably want to do is read from the source data (TABLE_1) > use a Joiner to merge in attributes from the update data (TABLE_2) and > then write it back to the SDE database using the update mode. > > The update key attributes are set in the writer feature type > parameters - see http://www.fmepedia.com/index.php/Sandbox for an > example screenshot. > > I don't think you could write the update table straight to the > destination (even in update mode) unless it had ALL the information on > it you required - eg if it only had field_1 then that's all you'd get > on the destination (I think) > > Hope this helps > > Mark > > Mark Ireland, Senior Product Specialist > Safe Software Inc. Surrey, BC, CANADA > [EMAIL PROTECTED] http://www.safe.com > Solutions for Spatial Data Translation, Distribution and Access > > --- In [email protected], "gullstrom" <gullstrom@> wrote: > > > > Thanks for your answer Jeff, > > > > I don't get it though... > > > > What I'm trying to achieve is what would look in oracle like: > > UPDATE TABLE_1 A SET FIELD_1 = ( > > SELECT FIELD_2 FROM TABLE_2 B > > WHERE A.KEY = B.KEY) > > > > When I use the ARCSDEQUERIER, I select SDE_NONE in the 'Search > > Method' dialog, then define a link to the base sde table in > > the 'Where Clause' dialog (eg. a.key = b.key), then for 'Query Mode' > > I use UPDATE. > > > > The above doesn't seem to work. Maybe also because source feature > > class and target feature class are the same. > > > > Your remark that the update is always done on the objectid puzzles > > me. I see that when I use either of the last 2 options in > > the 'Combine Attributes' dialog I get all the attributes of both > > input feature classes. This would then enable me to map any > > attribute to any output attribute, or? > > > > thanx > > > > rune > > > > You say the updates are always done on the object field. > > --- In [email protected], "Jeff Konnen" <jaykayone@> wrote: > > > > > > Hi rune, > > > > > > to update data in SDE, > > > > > > you can also use the ArcSDE 3.0 writer, or the Geodatabase ArcSDE > > Writer. > > > What you have to do is define the KEY-Field for updating in the > > properties > > > of your destination featureset. > > > > > > The ArcSDEQuerier works in update mode, but the updates will > > always be done > > > on the OBJECTID - field, which is not necessariliy what you want. > > > > > > As for the Joiner Transformer, I do not think it can update > > features. It > > > gets you joined features and adds them to your querying feature, > > but the > > > update process has do be done by the ArcSDEQuerier or one of the > > ArcSDE > > > Writers. > > > > > > See this page for more infos: > > > > > > > > http://www.fmepedia.com/index.php/Which_READER_and_WRITER_should_I_us > > e_for_Geodatabase > > > > > > I do not know if these steps work on Informix, but I can assure > > you they > > > work on Oracle! > > > > > > Greetings, > > > Jeff > > > > > > On 5/14/07, gullstrom <gullstrom@> wrote: > > > > > > > > Hi all, > > > > > > > > I want to update attributes of a feature class (argis > > 9.2/informix/fme > > > > 2007) but I can't get it to work. It seems to me I have 2 > > options: the > > > > joiner transformer or the arcsdequerier. The joiner works fine > > but > > > > can't work with informix, the arcsdequerier doesn't work at all > > in > > > > update mode. How do you update attribute in a given feature class > > > > using (non spatial) info like a common key? > > > > > > > > thanks in advance, > > > > > > > > rune > > > > > > > > > > > > > > > > > > > > > > > > -- > > > Jeff Konnen > > > INSER SA > > > Switzerland > > > +41 (0) 21 643 77 11 > > > > > > For insights into what's up at Safe Software and what's on the development horizon, visit Safe's blog at spatial-etl.blogspot.com. Love FME? Then open your diary to March 6-7, 2008 and write this... "Second Worldwide FME User Conference - Must Attend!" See http://www.safe.com/company/fmeuc2008/index.php for more details. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/fme/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
