Hi, I think one issue is that the api that is used to read the data doesn't actually take account of the cell types as defined in Excel. What it does is scan the data to find the most common type and use that. In some cases it causes a problem when the most common type is numeric, but the column also contains text values.
I'm still surprised that it occurs during reading - can you throw a logger or visualizer into the workflow after reading to make sure it is actually the reading that is the issue (and not it being dropped on writing to geodb)? If it is a reading issue then send us a copy to [EMAIL PROTECTED] and we'll take a further look - but it may be the developer just says that the api doesn't support it so we can't really do anything. Regards, Mark --- In [email protected], "arnotts_x4" <[EMAIL PROTECTED]> wrote: > > > Steve/Mark > > I have a similar problem with FME 2006GB. The Excel file I am > trying to import contains a date field, formatted as such in Excel, > but when exporting the data as a geodatabase table the date field > ends up empty. If I import a csv file instead of the Excel > worksheet it works fine. I have tried changing the format of the > export field from date to text but it produces the same result. > > Any suggestions? > > Steve > > > --- In [email protected], "Steve Nelson" <steve.nelson@> wrote: > > > > Thanks for the responce Mark, I'm using FME 2006 build 2182. > > > > Unfortunately, we're not able to install any software until our IT > > department approves it, so I'm kinda stuck with 2006 for now. > > > > Although, I was able to find a workaround outside of FME, I just > have > > to do a 'Save As' to CSV. This works for now, looking forward to > > trying the GB version to see if some of the Excel read/write bugs > are > > worked out. > > > > (An ugly way to automate this is I've just put a copy/paste > command in > > a .bat file to copy the xls and paste/rename the file to .csv > > extension, then call the FME which reads the .csv - it works for > now.) > > > > Thanks again, > > Steve > > > 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/
