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

[Dan Stoica]

For clarification: per DBF specification ":" and "." are not illegal characters. Instead there is an FDO limitation at this time in the sense it cannot create property names containing ":" or "."

The trouble was that there are products out there able to create DBF files with columns containing ':' and the SHP provider was not able to read them.

-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Brad Nesom
Sent: Thursday, January 13, 2011 4:02 PM
To: FDO Users Mail List
Subject: Re: [fdo-users] Re: OSM shape file limitations using with FDO due to : in column names

That is ESRIs implementation also. They automatically convert illegal
chars in the name to _ and also truncate field names by 2 and add
numeric.   My_extralong_field_name, becomes my_ext1 subsequent
duplications are numered sequentially.



On Thu, Jan 13, 2011 at 10:56 AM, Greg Boone <greg.boone at autodesk.com> wrote:
> The following change sets illustrate the changes made in the SHP provider to allow DBF files that have columns containing ":" and "." to be read and processed by FDO
>
> http://trac.osgeo.org/fdo/changeset/5858
>
> http://trac.osgeo.org/fdo/changeset/5859
>
> If ":" or "." are found, these characters are replaced by "_" when the DBF Physical schema is read and exposed as logical FDO Schema. Thus columns that are physically defined as a:b will be exposed logically as a_b.
>
> Greg
>
>
> -----Original Message-----
> From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Frank Warmerdam (External)
> Sent: Thursday, January 13, 2011 11:36 AM
> To: fdo-users at lists.osgeo.org
> Subject: Re: [fdo-users] Re: OSM shape file limitations using with FDO due to : in column names
>
> On 11-01-13 11:25 AM, Greg Boone wrote:
>> This issue has been resolved:
>>
>> http://trac.osgeo.org/fdo/ticket/737
>
> Greg,
>
> I can't help but notice that the ticket is closed without any indication of whether the problem was reproduced, action was taken, what it was, etc.  Here I assumed you referred people to the ticket so they could read the whole conversation.
>
> Best regards,
> --
> ---------------------------------------+--------------------------------
> ---------------------------------------+------
> I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
> light and sound - activate the windows | http://pobox.com/~warmerdam
> and watch the world go round - Rush    | Geospatial Programmer for Rent
>
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>
>
_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users