[fme] Re: Problems with Access writer

[Bill Voigt]

The Access destination was defined by the Workspace Dialog from the X & Y (state plane) coordinates in the source data.  I had negelected to check the destination table for compatibility with coordinates reprojected to Lat/Lon coordinates. However, I feel that the data should still have been written, unless it is a failure of Access.

 

I did a test by setting up attributes with varying data types (String(20), integer, decimal(20,10), decimal(13,2), single, double) to recieve the same output field representing the Latitude coordinate.  All fields but the decimal(13,2) accepted data. However, if I send the original X or Y (decimal(13,2) values to the Access decimal(13,2) attribute, the values are taken. 

 

mark2atsafe wrote:

 

You mean that FME had a defined size of 20 in the schema, and the
access database has 13, and because of this no data is written at all?
Even when it would fit in the 13 digit range?

I did see a similar issue yesterday. With a Joiner the translation
stopped with ugly errors when the join attribute was longer than the
size of the Access join key. The ugliness of the error (apart from
stopping the translation with no good reason) was in telling me the
data types didn't match (incorrect).

If you can confirm my interpretation of your problem then I'll ask the
developers to look into it.

Regards,

Mark

 

William G Voigt           (415) 485-3366 voice
GIS Analyst               (415) 485-3334 fax
Dept Public Works         111 Morphew St
City of San Rafael  San Rafael, CA 94901

 

__._,_.___

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.

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___

SSCaps.dbf
Description: SSCaps.dbf