[fdo-users] King Fdo2Fdo copy problem

zspitzer zac.spitzer at gmail.com
Tue Feb 12 19:02:36 EST 2008 

Is the export restricted to the columns listed listing like below? 

   <PropertyCopyDefinition>
      <SourcePropertyName>XTAB</SourcePropertyName>
      <DestinationPropertyName>XTAB</DestinationPropertyName>
    </PropertyCopyDefinition>

Can i substitute oracle commands on a column? 
ie something like <SourcePropertyName>NVL(XTAB,'EMPTY')</SourcePropertyName>
?




Binter Jan wrote:
> 
> We want to use command line version - F2FCmd.exe. But we are not able to
> copy data, using CopyTask parameter. I am attaching XML definition which
> works in GUI version, but does not work in command line. Please can you
> help us?
> 	Thanks Jan 
> 
> 
> <FdoCopyTask>
>   <SourceConnection>
>     <FdoProvider>King.MsSqlSpatial.0.1.1</FdoProvider>
>    
> <FdoConnectionString>Username=sa;Password=cjmcjm;DSN=EOP;KingFdoClass=ST.MD_KINGFDO;</FdoConnectionString>
>   </SourceConnection>
>   <DestinationConnection>
>     <FdoProvider>OSGeo.SDF.3.2</FdoProvider>
>     <FdoConnectionString>File=D:\Program
> Files\Fdo2Fdo\Budovy2.sdf;</FdoConnectionString>
>   </DestinationConnection>
>   <ClassCopyDefinition>
>     <SourceClassName>MsSqlSpatial:dbo~BUDOVY~GEOM</SourceClassName>
>    
> <DestinationClassName>MsSqlSpatial:dbo~BUDOVY~GEOM</DestinationClassName>
>     <CopyFilter>
>     </CopyFilter>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>GEOM</SourcePropertyName>
>       <DestinationPropertyName>GEOM</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>OID</SourcePropertyName>
>       <DestinationPropertyName>OID</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>PATRI_HPC</SourcePropertyName>
>       <DestinationPropertyName>PATRI_HPC</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>oldID</SourcePropertyName>
>       <DestinationPropertyName>oldID</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>XTAB</SourcePropertyName>
>       <DestinationPropertyName>XTAB</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>XIDSDF</SourcePropertyName>
>       <DestinationPropertyName>XIDSDF</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>MAPY_ID</SourcePropertyName>
>       <DestinationPropertyName>MAPY_ID</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>VRSTVY_ID</SourcePropertyName>
>       <DestinationPropertyName>VRSTVY_ID</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>OBVODY_ID</SourcePropertyName>
>       <DestinationPropertyName>OBVODY_ID</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>ULICE_ID</SourcePropertyName>
>       <DestinationPropertyName>ULICE_ID</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>NAZEV</SourcePropertyName>
>       <DestinationPropertyName>NAZEV</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>POPIS</SourcePropertyName>
>       <DestinationPropertyName>POPIS</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>ODBERNE_MISTO</SourcePropertyName>
>       <DestinationPropertyName>ODBERNE_MISTO</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>USEK</SourcePropertyName>
>       <DestinationPropertyName>USEK</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>DOSTUPNY_VYKON</SourcePropertyName>
>       <DestinationPropertyName>DOSTUPNY_VYKON</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>CISLO_ODBERU</SourcePropertyName>
>       <DestinationPropertyName>CISLO_ODBERU</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>MAJITEL</SourcePropertyName>
>       <DestinationPropertyName>MAJITEL</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>SPRAVCE</SourcePropertyName>
>       <DestinationPropertyName>SPRAVCE</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>POCET_PODLAZI</SourcePropertyName>
>       <DestinationPropertyName>POCET_PODLAZI</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>CH_BUDOVY</SourcePropertyName>
>       <DestinationPropertyName>CH_BUDOVY</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>POCET_BJ</SourcePropertyName>
>       <DestinationPropertyName>POCET_BJ</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>VYTAP_PLOCHA_BYTY</SourcePropertyName>
>       <DestinationPropertyName>VYTAP_PLOCHA_BYTY</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>VYTAP_PLOCHA_VYB</SourcePropertyName>
>       <DestinationPropertyName>VYTAP_PLOCHA_VYB</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>VYTAP_PLOCHA_PRUM</SourcePropertyName>
>       <DestinationPropertyName>VYTAP_PLOCHA_PRUM</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>OBEST_PROST_BYTY</SourcePropertyName>
>       <DestinationPropertyName>OBEST_PROST_BYTY</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>OBEST_PROST_VYB</SourcePropertyName>
>       <DestinationPropertyName>OBEST_PROST_VYB</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>OBEST_PROST_PRUM</SourcePropertyName>
>       <DestinationPropertyName>OBEST_PROST_PRUM</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>PROJ_PRIK_UT</SourcePropertyName>
>       <DestinationPropertyName>PROJ_PRIK_UT</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>PROJ_PRIK_VZD</SourcePropertyName>
>       <DestinationPropertyName>PROJ_PRIK_VZD</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>PROJ_PRIK_TUV</SourcePropertyName>
>       <DestinationPropertyName>PROJ_PRIK_TUV</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>PROJ_TEP_SPAD</SourcePropertyName>
>       <DestinationPropertyName>PROJ_TEP_SPAD</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>SKUT_PRIK_UT</SourcePropertyName>
>       <DestinationPropertyName>SKUT_PRIK_UT</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>SKUT_PRIK_VZD</SourcePropertyName>
>       <DestinationPropertyName>SKUT_PRIK_VZD</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>SKUT_PRIK_TUV</SourcePropertyName>
>       <DestinationPropertyName>SKUT_PRIK_TUV</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>TLAK_ZTRATA</SourcePropertyName>
>       <DestinationPropertyName>TLAK_ZTRATA</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>KONSTR_TLAK_UT</SourcePropertyName>
>       <DestinationPropertyName>KONSTR_TLAK_UT</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>UT_DN</SourcePropertyName>
>       <DestinationPropertyName>UT_DN</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>UT_PN</SourcePropertyName>
>       <DestinationPropertyName>UT_PN</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>UT_TYP</SourcePropertyName>
>       <DestinationPropertyName>UT_TYP</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>UT_VC_VODOMER</SourcePropertyName>
>       <DestinationPropertyName>UT_VC_VODOMER</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>UT_VC_POCITADLO</SourcePropertyName>
>       <DestinationPropertyName>UT_VC_POCITADLO</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>UT_VC_TEPLOMER1</SourcePropertyName>
>       <DestinationPropertyName>UT_VC_TEPLOMER1</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>UT_VC_TEPLOMER2</SourcePropertyName>
>       <DestinationPropertyName>UT_VC_TEPLOMER2</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>UT_OVERENO</SourcePropertyName>
>       <DestinationPropertyName>UT_OVERENO</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>TUV_DN</SourcePropertyName>
>       <DestinationPropertyName>TUV_DN</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>TUV_PN</SourcePropertyName>
>       <DestinationPropertyName>TUV_PN</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>TUV_TYP</SourcePropertyName>
>       <DestinationPropertyName>TUV_TYP</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>TUV_VC</SourcePropertyName>
>       <DestinationPropertyName>TUV_VC</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>TUV_OVERENO</SourcePropertyName>
>       <DestinationPropertyName>TUV_OVERENO</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>CIRK_DN</SourcePropertyName>
>       <DestinationPropertyName>CIRK_DN</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>CIRK_PN</SourcePropertyName>
>       <DestinationPropertyName>CIRK_PN</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>CIRK_TYP</SourcePropertyName>
>       <DestinationPropertyName>CIRK_TYP</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>CIRK_VC</SourcePropertyName>
>       <DestinationPropertyName>CIRK_VC</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>CIRK_OVERENO</SourcePropertyName>
>       <DestinationPropertyName>CIRK_OVERENO</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>DRUH_VYTAPENI</SourcePropertyName>
>       <DestinationPropertyName>DRUH_VYTAPENI</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>DRUH_TOPIDLA</SourcePropertyName>
>       <DestinationPropertyName>DRUH_TOPIDLA</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>OTOPNA_TELESA</SourcePropertyName>
>       <DestinationPropertyName>OTOPNA_TELESA</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>VYKON_KOTLE</SourcePropertyName>
>       <DestinationPropertyName>VYKON_KOTLE</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>DRUH_PALIVA</SourcePropertyName>
>       <DestinationPropertyName>DRUH_PALIVA</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>SPOTREBA</SourcePropertyName>
>       <DestinationPropertyName>SPOTREBA</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>ROK_PRIPOJENI</SourcePropertyName>
>       <DestinationPropertyName>ROK_PRIPOJENI</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>GEOM_Envelope_MinX</SourcePropertyName>
>      
> <DestinationPropertyName>GEOM_Envelope_MinX</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>GEOM_Envelope_MinY</SourcePropertyName>
>      
> <DestinationPropertyName>GEOM_Envelope_MinY</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>GEOM_Envelope_MaxX</SourcePropertyName>
>      
> <DestinationPropertyName>GEOM_Envelope_MaxX</DestinationPropertyName>
>     </PropertyCopyDefinition>
>     <PropertyCopyDefinition>
>       <SourcePropertyName>GEOM_Envelope_MaxY</SourcePropertyName>
>      
> <DestinationPropertyName>GEOM_Envelope_MaxY</DestinationPropertyName>
>     </PropertyCopyDefinition>
>   </ClassCopyDefinition>
>   <CopyTaskAttributes>
>     <ExecuteApplySchema>TRUE</ExecuteApplySchema>
>     <ApplySchemaXMLFile>
>     </ApplySchemaXMLFile>
>     <CreateSpatialContext>TRUE</CreateSpatialContext>
>     <SpatialContextXMLFile>
>     </SpatialContextXMLFile>
>     <MagicClassName>TRUE</MagicClassName>
>     <MagicDataTypes>TRUE</MagicDataTypes>
>     <DeleteDestinationData>FALSE</DeleteDestinationData>
>   </CopyTaskAttributes>
>   <CopyToSDFAttributes>
>     <SDF_CreateFileIfMissing>FALSE</SDF_CreateFileIfMissing>
>     <SDF_OverwriteFile>FALSE</SDF_OverwriteFile>
>   </CopyToSDFAttributes>
>   <CopyToOracleAttributes>
>     <Oracle_SRID>
>     </Oracle_SRID>
>   </CopyToOracleAttributes>
> </FdoCopyTask>
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
> 
> 

-- 
View this message in context: http://www.nabble.com/King-Fdo2Fdo-copy-problem-tp12035903s18162p15434486.html
Sent from the fdo-users mailing list archive at Nabble.com.

More information about the fdo-users mailing list