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