<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">&nbsp;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">&nbsp;&nbsp;&nbsp; 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 &lt;zac.spitzer@gmail.com&gt;<br> <b><span style="font-weight: bold;">To:</span></b> Iulia Tamas &lt;iulia_tamas30@yahoo.com&gt;; MapGuide Users Mail List &lt;mapguide-users@lists.osgeo.org&gt; <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 &lt;<a ymailto="mailto:iulia_tamas30@yahoo.com" href="mailto:iulia_tamas30@yahoo.com">iulia_tamas30@yahoo.com</a>&gt; wrote:<br>&gt; Thank you very much for your answers! With your help, I have managed to set<br>&gt; up the connection and copy .sdf to Oracle from command line<br>&gt; Iulia<br>&gt;<br>&gt; ________________________________<br>&gt; From: djonio &lt;<a ymailto="mailto:DJonio@miami-airport.com" href="mailto:DJonio@miami-airport.com">DJonio@miami-airport.com</a>&gt;<br>&gt; To: <a ymailto="mailto:mapguide-users@lists.osgeo.org" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>&gt; Sent: Thursday, November 17, 2011 5:44 PM<br>&gt; Subject: [mapguide-users] Re: Fdo2Fdo tool<br>&gt;<br>&gt; As Dave notes you certainly require DB connectivity. I
 would recommend using<br>&gt; the latest instantclient.<br>&gt; This is how I go from Oracle TO sdf files...<br>&gt;<br>&gt; Put something like these 3 lines in a bat/cmd file ... obviously fix'em for<br>&gt; your situation.<br>&gt;<br>&gt; c:<br>&gt; cd \SDF_Conversions<br>&gt; "C:\FDO2FDO\7_7\Release\F2fcmd.exe" CopyTask test_copy_mv0_4.xml<br>&gt; ------------------------------------<br>&gt; ------------------------------------<br>&gt; The following are the contents of "test_copy_mv0_4.xml" shown above....<br>&gt;<br>&gt; &lt;FdoCopyTask&gt;<br>&gt;<br>&gt; &nbsp; &lt;SourceConnection&gt;<br>&gt; &nbsp; &nbsp; &lt;FdoProvider&gt;King.Oracle.0.1.1&lt;/FdoProvider&gt;<br>&gt;<br>&gt; &lt;FdoConnectionString&gt;Username=GISMIA;Password=;Service=MAPGUIDE;OracleSchema=GISMIA;&lt;/FdoConnectionString&gt;<br>&gt; &nbsp; &lt;/SourceConnection&gt;<br>&gt;<br>&gt; &nbsp; &lt;DestinationConnection&gt;<br>&gt; &nbsp; &nbsp;
 &lt;FdoProvider&gt;OSGeo.SDF.3.2&lt;/FdoProvider&gt;<br>&gt;<br>&gt; &lt;FdoConnectionString&gt;File=C:\SDF_Conversions\mv0_4_floorplan.sdf;&lt;/FdoConnectionString&gt;<br>&gt; &nbsp; &lt;/DestinationConnection&gt;<br>&gt;<br>&gt; &nbsp; &lt;ClassCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &lt;SourceClassName&gt;KingOra:GISMIA~MV0_4~GEOMETRY&lt;/SourceClassName&gt;<br>&gt;<br>&gt; &lt;DestinationClassName&gt;KingOra:GISMIA~MV0_4~GEOMETRY&lt;/DestinationClassName&gt;<br>&gt; &nbsp; &nbsp; &lt;CopyFilter&gt;&lt;/CopyFilter&gt;<br>&gt; &nbsp; &nbsp; &lt;PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;SourcePropertyName&gt;MVID&lt;/SourcePropertyName&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;DestinationPropertyName&gt;MVID&lt;/DestinationPropertyName&gt;<br>&gt; &nbsp; &nbsp; &lt;/PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &lt;PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;SourcePropertyName&gt;ID&lt;/SourcePropertyName&gt;<br>&gt;
 &nbsp; &nbsp; &nbsp; &lt;DestinationPropertyName&gt;ID&lt;/DestinationPropertyName&gt;<br>&gt; &nbsp; &nbsp; &lt;/PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &lt;PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;SourcePropertyName&gt;ALTKEY&lt;/SourcePropertyName&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;DestinationPropertyName&gt;ALTKEY&lt;/DestinationPropertyName&gt;<br>&gt; &nbsp; &nbsp; &lt;/PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &lt;PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;SourcePropertyName&gt;VALIDFLG&lt;/SourcePropertyName&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;DestinationPropertyName&gt;VALIDFLG&lt;/DestinationPropertyName&gt;<br>&gt; &nbsp; &nbsp; &lt;/PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &lt;PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;SourcePropertyName&gt;NAME&lt;/SourcePropertyName&gt;<br>&gt; &nbsp; &nbsp; &nbsp;
 &lt;DestinationPropertyName&gt;NAME&lt;/DestinationPropertyName&gt;<br>&gt; &nbsp; &nbsp; &lt;/PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &lt;PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;SourcePropertyName&gt;FLOOR&lt;/SourcePropertyName&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;DestinationPropertyName&gt;FLOOR&lt;/DestinationPropertyName&gt;<br>&gt; &nbsp; &nbsp; &lt;/PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &lt;PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;SourcePropertyName&gt;SRCNAME&lt;/SourcePropertyName&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;DestinationPropertyName&gt;SRCNAME&lt;/DestinationPropertyName&gt;<br>&gt; &nbsp; &nbsp; &lt;/PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &lt;PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;SourcePropertyName&gt;LAYER&lt;/SourcePropertyName&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;DestinationPropertyName&gt;LAYER&lt;/DestinationPropertyName&gt;<br>&gt; &nbsp;
 &nbsp; &lt;/PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &lt;PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;SourcePropertyName&gt;AREASQFT&lt;/SourcePropertyName&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;DestinationPropertyName&gt;AREASQFT&lt;/DestinationPropertyName&gt;<br>&gt; &nbsp; &nbsp; &lt;/PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &lt;PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;SourcePropertyName&gt;PERIMETERFT&lt;/SourcePropertyName&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;DestinationPropertyName&gt;PERIMETERFT&lt;/DestinationPropertyName&gt;<br>&gt; &nbsp; &nbsp; &lt;/PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &lt;PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;SourcePropertyName&gt;TXTCONTENTS&lt;/SourcePropertyName&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;DestinationPropertyName&gt;TXTCONTENTS&lt;/DestinationPropertyName&gt;<br>&gt; &nbsp; &nbsp; &lt;/PropertyCopyDefinition&gt;<br>&gt; &nbsp;
 &nbsp; &lt;PropertyCopyDefinition&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;SourcePropertyName&gt;GEOMETRY&lt;/SourcePropertyName&gt;<br>&gt; &nbsp; &nbsp; &nbsp; &lt;DestinationPropertyName&gt;GEOMETRY&lt;/DestinationPropertyName&gt;<br>&gt; &nbsp; &nbsp; &lt;/PropertyCopyDefinition&gt;<br>&gt; &nbsp; &lt;/ClassCopyDefinition&gt;<br>&gt;<br>&gt; &nbsp; &lt;CopyTaskAttributes&gt;<br>&gt; &nbsp; &nbsp; &lt;ExecuteApplySchema&gt;TRUE&lt;/ExecuteApplySchema&gt;<br>&gt; &nbsp; &nbsp; &lt;ApplySchemaXMLFile&gt;&lt;/ApplySchemaXMLFile&gt;<br>&gt; &nbsp; &nbsp; &lt;CreateSpatialContext&gt;TRUE&lt;/CreateSpatialContext&gt;<br>&gt; &nbsp; &nbsp; &lt;SpatialContextXMLFile&gt;&lt;/SpatialContextXMLFile&gt;<br>&gt; &nbsp; &nbsp; &lt;MagicClassName&gt;TRUE&lt;/MagicClassName&gt;<br>&gt; &nbsp; &nbsp; &lt;MagicDataTypes&gt;TRUE&lt;/MagicDataTypes&gt;<br>&gt; &nbsp; &nbsp; &lt;DeleteDestinationData&gt;TRUE&lt;/DeleteDestinationData&gt;<br>&gt; &nbsp;
 &lt;/CopyTaskAttributes&gt;<br>&gt;<br>&gt; &nbsp; &lt;CopyToSDFAttributes&gt;<br>&gt; &nbsp; &nbsp; &lt;SDF_CreateFileIfMissing&gt;TRUE&lt;/SDF_CreateFileIfMissing&gt;<br>&gt; &nbsp; &nbsp; &lt;SDF_OverwriteFile&gt;TRUE&lt;/SDF_OverwriteFile&gt;<br>&gt; &nbsp; &lt;/CopyToSDFAttributes&gt;<br>&gt;<br>&gt; &nbsp; &lt;CopyToOracleAttributes&gt;<br>&gt; &nbsp; &nbsp; &lt;Oracle_SRID&gt;&lt;/Oracle_SRID&gt;<br>&gt; &nbsp; &lt;/CopyToOracleAttributes&gt;<br>&gt;<br>&gt; &lt;/FdoCopyTask&gt;<br>&gt; ---------------------------------------------------<br>&gt;<br>&gt; .... this XML was produced from the GUI tool. I am way to lazy to write such<br>&gt; stuff myself.<br>&gt; r,<br>&gt; dennis<br>&gt;<br>&gt; --<br>&gt; View this message in context:<br>&gt; http://osgeo-org.1803224.n2.nabble.com/Fdo2Fdo-tool-tp7003610p7004527.html<br>&gt; Sent from the MapGuide Users mailing list archive at <a target="_blank" href="http://Nabble.com">Nabble.com</a>.<br>&gt;
 _______________________________________________<br>&gt; mapguide-users mailing list<br>&gt; <a ymailto="mailto:mapguide-users@lists.osgeo.org" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>&gt; http://lists.osgeo.org/mailman/listinfo/mapguide-users<br>&gt;<br>&gt;<br>&gt;<br>&gt; _______________________________________________<br>&gt; mapguide-users mailing list<br>&gt; <a ymailto="mailto:mapguide-users@lists.osgeo.org" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>&gt; <a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>&gt;<br>&gt;<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>