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

[Dan Stoica]

Do you mean field name containing ":"?  How about "." ?

-----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 8:06 PM
To: FDO Users Mail List
Subject: Re: [fdo-users] Re: OSM shape file limitations using with FDO due to : in column names

I'm sorry. The dialog that pops in esri when you try to create a field
name says invalid.




On Thu, Jan 13, 2011 at 3:09 PM, Dan Stoica <dan.stoica at autodesk.com> wrote:
> 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
> _______________________________________________
> 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