[fdo-users] OSM shape file limitations using with FDO due to : in column names

Zac Spitzer zac.spitzer at gmail.com
Thu Jan 6 02:45:42 EST 2011


I've been playing around with some of the OSM shape file exports

http://downloads.cloudmade.com/oceania/australia/victoria

alas, FDO doesn't like the some of column conventions used

 Error: An exception occurred in FDO component.
        Invalid Feature schema element name 'ADDR:CITY'; must not contain ':'

which is because the feature class used : as a delimiter

as OSM data is pretty common and getting more and more popular,
would it be possible to remap those : characters to something else ie "_"
rather than just throwing an error and failing ?

i doubt many shape files have identical column names which only differ
between ":" and "_"

even without remapping, it would be nice if such incompatible columns could
just be ignored in the interim


z








-- 
Zac Spitzer
Solution Architect / Director
Ennoble Consultancy Australia
http://www.ennoble.com.au
http://zacster.blogspot.com
+61 405 847 168


More information about the fdo-users mailing list