I have a connection in Windows 2008 64bit to an Excel 2000 spreadsheet that works. I use a DSN connection. The spreadsheet has a named region set. On my feature source I define a key column and the geometry columns. Here is the config doc associated with the connection:
<?xml version="1.0" encoding="UTF-8" ?> - <fdo:DataStore xmlns:xs="http://www.w3.org/2001/XMLSchema"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xmlns:xlink="http://www.w3.org/1999/xlink"; xmlns:gml="http://www.opengis.net/gml"; xmlns:fdo="http://fdo.osgeo.org/schemas"; xmlns:fds="http://fdo.osgeo.org/schemas/fds";> - <gml:DerivedCRS gml:id="LL84"> <gml:remarks>WGS84 datum, Latitude-Longitude; Degrees</gml:remarks> <gml:srsName>LL84</gml:srsName> - <gml:validArea> - <gml:boundingBox> <gml:pos>-113.500000 -51.799999</gml:pos> <gml:pos>178.300003 74.000000</gml:pos> </gml:boundingBox> </gml:validArea> - <gml:baseCRS> - <fdo:WKTCRS gml:id="LL84"> <gml:srsName>LL84</gml:srsName> <fdo:WKT>GEOGCS["LL84",DATUM["WGS84",SPHEROID["WGS84",6378137.000,298.25722293]],PRIMEM["Greenwich",0],UNIT["Degree",0.01745329251994]]</fdo:WKT> </fdo:WKTCRS> </gml:baseCRS> <gml:definedByConversion xlink:href="http://fdo.osgeo.org/coord_conversions#identity"; /> <gml:derivedCRSType codeSpace="http://fdo.osgeo.org/crs_types";>geographic</gml:derivedCRSType> <gml:usesCS xlink:href="http://fdo.osgeo.org/cs#default_cartesian"; /> </gml:DerivedCRS> - <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"; targetNamespace="http://fdo.osgeo.org/schemas/feature/Default"; xmlns:fdo="http://fdo.osgeo.org/schemas"; xmlns:gml="http://www.opengis.net/gml"; xmlns:Default="http://fdo.osgeo.org/schemas/feature/Default"; elementFormDefault="qualified" attributeFormDefault="unqualified"> - <xs:element name="Country" type="Default:CountryType" abstract="false" substitutionGroup="gml:_Feature"> - <xs:key name="CountryKey"> <xs:selector xpath=".//Country" /> <xs:field xpath="COUNTRY_KEY" /> </xs:key> </xs:element> - <xs:complexType name="CountryType" abstract="false" fdo:geometryName="Geometry"> - <xs:complexContent> - <xs:extension base="gml:AbstractFeatureType"> - <xs:sequence> - <xs:element name="COUNTRY_KEY"> - <xs:annotation> <xs:documentation /> </xs:annotation> - <xs:simpleType> - <xs:restriction base="xs:string"> <xs:maxLength value="" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="COUNTRY_NAME" minOccurs="0"> - <xs:annotation> <xs:documentation /> </xs:annotation> - <xs:simpleType> - <xs:restriction base="xs:string"> <xs:maxLength value="" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="AREA" minOccurs="0"> - <xs:simpleType> <xs:restriction base="xs:double" /> </xs:simpleType> - <xs:annotation> <xs:documentation /> </xs:annotation> </xs:element> - <xs:element name="CAPITAL" minOccurs="0"> - <xs:annotation> <xs:documentation /> </xs:annotation> - <xs:simpleType> - <xs:restriction base="xs:string"> <xs:maxLength value="" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="GDP" minOccurs="0"> - <xs:simpleType> <xs:restriction base="xs:double" /> </xs:simpleType> - <xs:annotation> <xs:documentation /> </xs:annotation> </xs:element> - <xs:element name="INFLATION" minOccurs="0"> - <xs:simpleType> <xs:restriction base="xs:double" /> </xs:simpleType> - <xs:annotation> <xs:documentation /> </xs:annotation> </xs:element> - <xs:element name="UNEMPLOYMENT" minOccurs="0"> - <xs:simpleType> <xs:restriction base="xs:double" /> </xs:simpleType> - <xs:annotation> <xs:documentation /> </xs:annotation> </xs:element> - <xs:element name="EXPORTS" minOccurs="0"> - <xs:simpleType> <xs:restriction base="xs:double" /> </xs:simpleType> - <xs:annotation> <xs:documentation /> </xs:annotation> </xs:element> - <xs:element name="IMPORTS" minOccurs="0"> - <xs:simpleType> <xs:restriction base="xs:double" /> </xs:simpleType> - <xs:annotation> <xs:documentation /> </xs:annotation> </xs:element> - <xs:element name="POPULATION" minOccurs="0"> - <xs:simpleType> <xs:restriction base="xs:double" /> </xs:simpleType> - <xs:annotation> <xs:documentation /> </xs:annotation> </xs:element> - <xs:element name="GROWTH_RATE" minOccurs="0"> - <xs:simpleType> <xs:restriction base="xs:double" /> </xs:simpleType> - <xs:annotation> <xs:documentation /> </xs:annotation> </xs:element> - <xs:element name="BIRTH_RATE" minOccurs="0"> - <xs:simpleType> <xs:restriction base="xs:double" /> </xs:simpleType> - <xs:annotation> <xs:documentation /> </xs:annotation> </xs:element> - <xs:element name="DEATH_RATE" minOccurs="0"> - <xs:simpleType> <xs:restriction base="xs:double" /> </xs:simpleType> - <xs:annotation> <xs:documentation /> </xs:annotation> </xs:element> - <xs:element name="LIFE_MALE" minOccurs="0"> - <xs:simpleType> <xs:restriction base="xs:double" /> </xs:simpleType> - <xs:annotation> <xs:documentation /> </xs:annotation> </xs:element> - <xs:element name="LIFE_FEMALE" minOccurs="0"> - <xs:simpleType> <xs:restriction base="xs:double" /> </xs:simpleType> - <xs:annotation> <xs:documentation /> </xs:annotation> </xs:element> - <xs:element name="AREA_LAND" minOccurs="0"> - <xs:simpleType> <xs:restriction base="xs:double" /> </xs:simpleType> - <xs:annotation> <xs:documentation /> </xs:annotation> </xs:element> - <xs:element name="POPULATION_DEN" minOccurs="0"> - <xs:simpleType> <xs:restriction base="xs:double" /> </xs:simpleType> - <xs:annotation> <xs:documentation /> </xs:annotation> </xs:element> - <xs:element name="LITERACY" minOccurs="0"> - <xs:simpleType> <xs:restriction base="xs:double" /> </xs:simpleType> - <xs:annotation> <xs:documentation /> </xs:annotation> </xs:element> - <xs:element name="Geometry" type="gml:AbstractGeometryType" fdo:hasMeasure="false" fdo:hasElevation="false" fdo:srsName="LL84" fdo:geometricTypes="point" fdo:geometryTypes="point multipoint"> - <xs:annotation> <xs:documentation /> </xs:annotation> </xs:element> </xs:sequence> </xs:extension> </xs:complexContent> </xs:complexType> - <xs:complexType name="COUNTRY_KEYType" abstract="false" fdo:hasGeometry="false"> - <xs:complexContent> - <xs:extension base="gml:AbstractFeatureType"> - <xs:sequence> - <xs:element name="COUNTRY_KEY" minOccurs="0"> - <xs:annotation> <xs:documentation /> </xs:annotation> - <xs:simpleType> - <xs:restriction base="xs:string"> <xs:maxLength value="" /> </xs:restriction> </xs:simpleType> </xs:element> </xs:sequence> </xs:extension> </xs:complexContent> </xs:complexType> </xs:schema> - <SchemaMapping xmlns:rdb="http://fdordbms.osgeo.org/schemas"; xmlns="http://fdoodbc.osgeo.org/schemas"; provider="OSGeo.ODBC.3.5" name="Default"> - <complexType name="CountryType"> <Table name="Country" /> - <element name="COUNTRY_KEY"> <Column name="COUNTRY_KEY" /> </element> - <element name="COUNTRY_NAME"> <Column name="COUNTRY_NAME" /> </element> - <element name="AREA"> <Column name="AREA" /> </element> - <element name="CAPITAL"> <Column name="CAPITAL" /> </element> - <element name="GDP"> <Column name="GDP" /> </element> - <element name="INFLATION"> <Column name="INFLATION" /> </element> - <element name="UNEMPLOYMENT"> <Column name="UNEMPLOYMENT" /> </element> - <element name="EXPORTS"> <Column name="EXPORTS" /> </element> - <element name="IMPORTS"> <Column name="IMPORTS" /> </element> - <element name="POPULATION"> <Column name="POPULATION" /> </element> - <element name="GROWTH_RATE"> <Column name="GROWTH_RATE" /> </element> - <element name="BIRTH_RATE"> <Column name="BIRTH_RATE" /> </element> - <element name="DEATH_RATE"> <Column name="DEATH_RATE" /> </element> - <element name="LIFE_MALE"> <Column name="LIFE_MALE" /> </element> - <element name="LIFE_FEMALE"> <Column name="LIFE_FEMALE" /> </element> - <element name="AREA_LAND"> <Column name="AREA_LAND" /> </element> - <element name="POPULATION_DEN"> <Column name="POPULATION_DEN" /> </element> - <element name="LITERACY"> <Column name="LITERACY" /> </element> <element name="Geometry" xColumnName="LONGITUDE" yColumnName="LATITUDE" /> </complexType> - <complexType name="COUNTRY_KEYType"> <Table name="COUNTRY_KEY" /> - <element name="COUNTRY_KEY"> <Column name="COUNTRY_KEY" /> </element> </complexType> </SchemaMapping> </fdo:DataStore> -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of DGK Sent: Friday, August 06, 2010 1:41 PM To: [email protected] Subject: [mapguide-users] Re: FDO Exception when selecting feature. Jackie Ng wrote: > > Do you know if FDO is properly detecting the identity properties (primary > keys)? > > If you open that data source with FDO Toolbox, does that show the correct > properties as identity properties? > > - Jackie > Jackie and other forum members, Please accept my profuse apologies for this breach of forum etiquette but desperation has made me post twice on this topic in one day. Monday looms... I made the connection to the Excel sheet with FDO toolbox. The key field (SITE-x20-ID) is not an indentity property. Today I read your blog about "Using FDO Schema Overrides" and tried to follow your code examples for SQL and apply them to the Excel file from which I dumped the xml schema mapping. I tried editing the file, adding a key element, yet failed as I am woefully out of my league. On top of that, I am not sure how to incorporate the configuration file back into either MGE or the Excel file so it will allow me to select features in MGE and retrieve their associated data. I would be deeply in your debt if you could edit the xml file and tell me how to incorporate it appropriately back in MGE I have attached the source xcel file and the xml dump from it. I am trying to make "SITE-x20-ID" field the indentity properrty. Many Thanks, Dan http://osgeo-org.1803224.n2.nabble.com/file/n5381923/SampleData.xml SampleData.xml http://osgeo-org.1803224.n2.nabble.com/file/n5381923/SampleData.xls SampleData.xls -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/FDO-Exception-when-selecting-feature-tp5347905p5381923.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
