Thanks for the tips Jeff and Mark...I had spent a morning trying to hack the fmw file with only a little success.
I've also come across a few other things since...you can't merge feature types for database features in a workspace - I'd never even tried before only for file and directory based datasets. And you can't get add database tables as a source to a workspace without importing them. There's no way of getting at the Table List from what I can see for GeoMedia SQL Server or for SQL Server (Attributes only). Not the end of the world but have to do a bit of rethinking. Tried GENTRANS but couldn't apply the pipeline. Not sure if I had the source and destination removed from the mapping file correctly. Is it just a matter of deleting everything before the feature factory calls...I have a feeling its not that simple as all the code in the fme file seemed to reference the source or destination. If you use this method can you add attributes to the destination feature or are you stuck with source schema? The GENTRANS page of fmepedia.com is good. I'm finding the FFS method slow and am getting huge temp files but I think its something to do with the particular translation so investigating this at the moment. If anyone has a sample .fme file used as a pipeline for GENTRANS I wouldn't mind taking a look. Thanks, Annette --- In [email protected], "mark2atsafe" <[EMAIL PROTECTED]> wrote: > > I was actually thinking of this Jeff, but I'm not sure it works well > for different schemas. Even though the format is generic I don't think > the schema is - it will be fixed. > > Still worth trying, but I'm not convinced it will work. > > Two other ideas... > > Save the workspace as a mapping file, and strip off the readers and > writers. Then use GENTRANS to run the translation, using the cut- down > mapping file as an included pipeline. > > Write to FFS. With STRICT_SCHEMA it's capable of keeping any > attributes that aren't even on the schema. Then convert to SQLServer - > even use a post-workspace TCL script to kick off the second translation. > > Hope that helps > > Mark > > --- In [email protected], "Jeff Konnen" <jaykayone@> wrote: > > > > Hi Annette, > > > > It think what you need is the GENERIC Writer ... thanks to Dale for > this one > > :-) > > > > Have a look at the latest betas. Basically it let's the output > format open > > so that you can specify it at runtime. > > Is that right, Dale? > > > > Greetings, > > Jeff > > > > On 3/30/07, annettefarrell <afarrell@> wrote: > > > > > > Hi, > > > > > > Set up a translation for our developers. > > > However, now they want the translation for any datasource. > > > > > > A merge filter should get all the source attributes but I can't think > > > of a way offhand of outputting unknown source attributes to the > > > destination for batch process. I've had a few thoughts at database > > > level - view, DTS etc but datasets will have different schemas > > > including primary key field. > > > > > > Source = GeoMedia SQL Server (lines and polygon tables with > > > different attributes) > > > Destination = SQL Server Attributes only (copy of the input tables > > > with a few more fields as well) > > > > > > The plan will be to batch the translation and there'll be an ASP.NET > > > interface to the run to the translation for user select tables. > > > > > > I'm probably missing something very simple but if anyone knows > > > offhand I'd appreciate it. > > > > > > Cheers, > > > > > > Annette > > > > > > > > > > > > > > > > > -- > > 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. Safe Software has also made slides available that outline enhancements planned for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2 of the FME Worldwide Users Conference. To view these slides, visit www.safe.com/2006uc. 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/
