[mapguide-users] Re: Fdo2Fdo tool
Iulia Tamas
iulia_tamas30 at yahoo.com
Fri Nov 18 02:42:58 EST 2011
Hello,
I have followed Dennis's procedure (that was very well explained):
1) Create the .xml file in Fdo2Fdo tool containing the "Copy Task Definition"
2) In command line navigate to the directory where the tool is installed and add the following command:
f2fcmd CopyTask "Path to the .xml file created at 1)"
Iulia
________________________________
From: Zac Spitzer <zac.spitzer at gmail.com>
To: Iulia Tamas <iulia_tamas30 at yahoo.com>; MapGuide Users Mail List <mapguide-users at lists.osgeo.org>
Sent: Friday, November 18, 2011 4:15 AM
Subject: Re: [mapguide-users] Re: Fdo2Fdo tool
Care to share your command line for other's who might be trying to
do this (of course edit out any sensitive info)?
On Fri, Nov 18, 2011 at 3:18 AM, Iulia Tamas <iulia_tamas30 at yahoo.com> wrote:
> Thank you very much for your answers! With your help, I have managed to set
> up the connection and copy .sdf to Oracle from command line
> Iulia
>
> ________________________________
> From: djonio <DJonio at miami-airport.com>
> To: mapguide-users at lists.osgeo.org
> Sent: Thursday, November 17, 2011 5:44 PM
> Subject: [mapguide-users] Re: Fdo2Fdo tool
>
> As Dave notes you certainly require DB connectivity. I would recommend using
> the latest instantclient.
> This is how I go from Oracle TO sdf files...
>
> Put something like these 3 lines in a bat/cmd file ... obviously fix'em for
> your situation.
>
> c:
> cd \SDF_Conversions
> "C:\FDO2FDO\7_7\Release\F2fcmd.exe" CopyTask test_copy_mv0_4.xml
> ------------------------------------
> ------------------------------------
> The following are the contents of "test_copy_mv0_4.xml" shown above....
>
> <FdoCopyTask>
>
> <SourceConnection>
> <FdoProvider>King.Oracle.0.1.1</FdoProvider>
>
> <FdoConnectionString>Username=GISMIA;Password=;Service=MAPGUIDE;OracleSchema=GISMIA;</FdoConnectionString>
> </SourceConnection>
>
> <DestinationConnection>
> <FdoProvider>OSGeo.SDF.3.2</FdoProvider>
>
> <FdoConnectionString>File=C:\SDF_Conversions\mv0_4_floorplan.sdf;</FdoConnectionString>
> </DestinationConnection>
>
> <ClassCopyDefinition>
> <SourceClassName>KingOra:GISMIA~MV0_4~GEOMETRY</SourceClassName>
>
> <DestinationClassName>KingOra:GISMIA~MV0_4~GEOMETRY</DestinationClassName>
> <CopyFilter></CopyFilter>
> <PropertyCopyDefinition>
> <SourcePropertyName>MVID</SourcePropertyName>
> <DestinationPropertyName>MVID</DestinationPropertyName>
> </PropertyCopyDefinition>
> <PropertyCopyDefinition>
> <SourcePropertyName>ID</SourcePropertyName>
> <DestinationPropertyName>ID</DestinationPropertyName>
> </PropertyCopyDefinition>
> <PropertyCopyDefinition>
> <SourcePropertyName>ALTKEY</SourcePropertyName>
> <DestinationPropertyName>ALTKEY</DestinationPropertyName>
> </PropertyCopyDefinition>
> <PropertyCopyDefinition>
> <SourcePropertyName>VALIDFLG</SourcePropertyName>
> <DestinationPropertyName>VALIDFLG</DestinationPropertyName>
> </PropertyCopyDefinition>
> <PropertyCopyDefinition>
> <SourcePropertyName>NAME</SourcePropertyName>
> <DestinationPropertyName>NAME</DestinationPropertyName>
> </PropertyCopyDefinition>
> <PropertyCopyDefinition>
> <SourcePropertyName>FLOOR</SourcePropertyName>
> <DestinationPropertyName>FLOOR</DestinationPropertyName>
> </PropertyCopyDefinition>
> <PropertyCopyDefinition>
> <SourcePropertyName>SRCNAME</SourcePropertyName>
> <DestinationPropertyName>SRCNAME</DestinationPropertyName>
> </PropertyCopyDefinition>
> <PropertyCopyDefinition>
> <SourcePropertyName>LAYER</SourcePropertyName>
> <DestinationPropertyName>LAYER</DestinationPropertyName>
> </PropertyCopyDefinition>
> <PropertyCopyDefinition>
> <SourcePropertyName>AREASQFT</SourcePropertyName>
> <DestinationPropertyName>AREASQFT</DestinationPropertyName>
> </PropertyCopyDefinition>
> <PropertyCopyDefinition>
> <SourcePropertyName>PERIMETERFT</SourcePropertyName>
> <DestinationPropertyName>PERIMETERFT</DestinationPropertyName>
> </PropertyCopyDefinition>
> <PropertyCopyDefinition>
> <SourcePropertyName>TXTCONTENTS</SourcePropertyName>
> <DestinationPropertyName>TXTCONTENTS</DestinationPropertyName>
> </PropertyCopyDefinition>
> <PropertyCopyDefinition>
> <SourcePropertyName>GEOMETRY</SourcePropertyName>
> <DestinationPropertyName>GEOMETRY</DestinationPropertyName>
> </PropertyCopyDefinition>
> </ClassCopyDefinition>
>
> <CopyTaskAttributes>
> <ExecuteApplySchema>TRUE</ExecuteApplySchema>
> <ApplySchemaXMLFile></ApplySchemaXMLFile>
> <CreateSpatialContext>TRUE</CreateSpatialContext>
> <SpatialContextXMLFile></SpatialContextXMLFile>
> <MagicClassName>TRUE</MagicClassName>
> <MagicDataTypes>TRUE</MagicDataTypes>
> <DeleteDestinationData>TRUE</DeleteDestinationData>
> </CopyTaskAttributes>
>
> <CopyToSDFAttributes>
> <SDF_CreateFileIfMissing>TRUE</SDF_CreateFileIfMissing>
> <SDF_OverwriteFile>TRUE</SDF_OverwriteFile>
> </CopyToSDFAttributes>
>
> <CopyToOracleAttributes>
> <Oracle_SRID></Oracle_SRID>
> </CopyToOracleAttributes>
>
> </FdoCopyTask>
> ---------------------------------------------------
>
> .... this XML was produced from the GUI tool. I am way to lazy to write such
> stuff myself.
> r,
> dennis
>
> --
> View this message in context:
> http://osgeo-org.1803224.n2.nabble.com/Fdo2Fdo-tool-tp7003610p7004527.html
> Sent from the MapGuide Users mailing list archive at Nabble.com.
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>
--
Zac Spitzer
Solution Architect / Director
Ennoble Consultancy Australia
http://www.ennoble.com.au
http://zacster.blogspot.com
+61 405 847 168
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20111117/6c2d5be6/attachment.html
More information about the mapguide-users
mailing list