Hi again, I have created a small sample fmw, which routes the data to a Visualizer. Using dates up to 20371231 works fine, and the output date field is added. But when using dates from 20380101 and up, no output date field appears.
So this is not a SDE/Oracle problem. This fmw was created using FME2006GB and WindowsXP sp2. And yes, I was writing to a date field in Oracle. The sample fmw is uploaded to the Yahoo site. Regards, Kjetil S-T --- In [email protected], "mark2atsafe" <[EMAIL PROTECTED]> wrote: > > Hi Kjetil, > Can you add a Visualizer transformer after the DateFormatter to show > the data at that point. I'm curious as to whether it is the > DateFormatter that is the problem, our SDE/Oracle writer or an > Oracle/OS problem. > > Everyone here (in support) is well and truly baffled by this. We'll > look into it and let you know what we find. I assume it is a date > field you are writing to? What is your Operating System? > > 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], "n_antiform" <kjetilsv@> wrote: > > > > Hi, > > > > I am loading dates into an ArcSDE Geodatabase (9.1) in Oracle 10. > > Formatting and loading dates using the DateFormatter works fine, > > except a few dates which ends up having <null> value in Oracle. > > > > Input format for all dates are YYYYMMDD and the output date > > format in the DateFormatter is %Y%m%d. > > > > All the dates that are rejected are in the range of Year 2041 - 2046. > > > > FME Help states that: > > "Not all platforms can represent the years 38-70, so an error may > > result if these years are used." > > > > Does this mean that I can't import these dates? > > Seems weird... > > > > I am using FME 2006 GB/Windows XP sp2. > > > > > > Regards, > > Kjetil S-T > > Norway > > > 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/
