What sort of problems are you facing Jason? I'm thinking it's not going to be easy to produce a one-solution-fits-all transformer, given the wide range of formats a date may be.
At the moment the DateFormatter only accepts dates of a known structure - there's no mechanism for defining a custom structure, and there's limits on what guesses FME can make. Anyway - I'm not trying to spread alarm and despondency, it does work pretty well. But if there's a specific problem you have then be sure to let us know. BTW - I worked on a project once for property records in Scotland. Some records were so old they were in a different calendar (Julian, not Gregorian) - and that caused more than a few problems! >From wikipedia... "In the British Empire Wednesday 2 September 1752 was followed by Thursday 14 September 1752" - also - "Russia remained on the Julian calendar until after the Russian Revolution (which is thus called the 'October Revolution' but occurred in November according to the Gregorian calendar)" Regards, Mark --- In [email protected], "Jason Birch" <[EMAIL PROTECTED]> wrote: > > I'd like to see improvements in date handling in FME overall. > > I've been working on a Cemetery application, and have to jump through tonnes of hoops because many of my dates are pre-1900. (at least, I think that's the point where FME's generally great date handling starts to break down) > > Jason > > ________________________________ > > From: [email protected] on behalf of n_antiform > Sent: Thu 2006-11-02 10:08 AM > To: [email protected] > Subject: [fme] Re: Invalid year using DateFormatter > > > > 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" <mark.ireland@> 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 > > support@ 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 > 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/
