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" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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/
