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

[Zac Spitzer]

any chance of a backport to 3.5, MapGuide 2.2 hasn't been released
yet and this is a really useful fix?

On Fri, Jan 14, 2011 at 8:09 AM, 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
>



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