Well, I am happy to say no cacti were harmed during the editing of the fmf and your idea worked perfectly! Thanks and I hope your Oracle dev is ok.
--- In [email protected], "mark2atsafe" <[EMAIL PROTECTED]> wrote: > > Hi, > I can't think of a standard setting anywhere that will let you do > this, so I suspect that the only method would be to change the > attr_type_map in a metafile. > > eg in C:\Program Files\FME\metafile\oracle8i.fmf look for the line... > > ATTR_TYPE_MAP char(width) fme_char(width) \ > > ...and change it to... > > ATTR_TYPE_MAP varchar2(width) fme_char(width) \ > > Or you could find the equivalent Shape metafile and change that to > create fme_varchars from Shape char fields. > > In fact, now I think of it, instead of editing the line you should > probably just add a new mapping. So that part of the file would read... > > ATTR_TYPE_MAP varchar2(width) fme_char(width) \ > char(width) fme_char(width) \ > varchar2(width) fme_varchar(width) \ > > ...that way you aren't removing "char" as a type from the Oracle > reader, just mapping what happens when you write to Oracle. > > HOWEVER - I can't emphasise enough that editing metafiles like this is > NOT recommended behaviour. Our Oracle developer will probably choke on > his coffee when he sees what I've told you to do. I make no guarantees > over what such a change would do to your data or to your FME, and I > don't even guarantee it will work. But if someone was holding me to > ransom, saying "re-map my attributes, or your cactus plant gets it" > then this is where I'd start to experiment. > > Hope this helps, > > Mark > > PS - I mean it. You try this one at your own risk. > > > --- In [email protected], "mark_watts01" <mark_watts01@> wrote: > > > > Is there a way to change the default mappings for data types? > > For example converting a CHAR field from an shape file to oracle > > spatial results in a fixed length CHAR field in oracle. I would > > prefer CHAR to map to an Oracle Varchar2 without having to change > > each field manually. > > > 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/
