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

Reply via email to