How-To - ArcFM - Export ArcFM Properties from a Personal/File Geodatabase for Import into an SDE Database

Version 2

    Organizations currently using an .mdb or .gdb may wish to upgrade to an enterprise-level database. In order to copy over the necessary ArcFM configuration, the ArcFM XML Import and ArcFM XML Export functions are used. These functions can be seen by right-clicking the database name in ArcCatalog.

     

    Tables in an enterprise database are prefixed with database and schema information, while tables in a personal geodatabase are not.  As an example, in personal geodatabases a primary overhead line will simply be listed as PrimaryOHLine. In a SQL Server environment, clients may have a database named GISDB and a schema named SDE, so the feature class will be listed as GISDB.SDE.PrimaryOHLine.

     

    When running ArcFM XML Export from a personal geodatabase, database and schema prefixes will not be added without the use of style sheets.  Errors will occur when importing this XML file into an SDE database; errors such as: Error importing Custom Object Type Information for PrimaryOHLine. The table could not be found in the database. This occurs because the XML file lists the table as PrimaryOHLine, while the table is actually GISDB.SDE.PrimaryOHLine in the SDE database.

     

    The XML file needs to be modified to accurately reflect the database and schema information of the target SDE database. Modification can be done with style sheets that are found in C:\Program Files (x86)\Miner and Miner\ArcFM Solution\Bin\Style Sheets. The two style sheets of interest are the prefix_Oracle.xsl and the prefix_SQLServer.xsl.

     

    1. Open the file appropriate for your DMBS to modify the Strings to append section (see below):

    KB1.png

     

    The variables refer to the following:

    • prefix: spatial feature classes
    • prefixsys: ArcFM MM process framework tables used for managing sessions and workflows
    • prefixobject: non-spatial object classes
    • prefixrelclass: relationship classes

     

     

    2. In ArcCatalog, right-click the personal geodatabase name and select ArcFM XML Export. In the ArcFM XML Export dialog, check the box for Apply Style Sheet and navigate to the .xsl file from Step 1. Now the XML file will be properly modified and all ArcFM configuration will be imported into the SDE database.

    KB2.png

     

     

    Exporting ArcFM properties from an SDE database into a personal geodatabase follows a similar process, please refer to: XXXXX

    Further information on other XML Style Sheets can be found here: http://resources.arcfmsolution.com/10.2.1a/Appendix/Stylesheets.html