The Prefix .xsl is used when you are exporting properties from a personal geodatabase and wish to import them into an SDE database.

The resulting XML refers to a specific table name from the export database. For example, it refers to the “Transformer” table if you are exporting from a personal geodatabase with a feature class called "Transformer". Prefix.xsl is used because all SDE databases have the name of the table owner appended to the beginning of the table name. For example, if our business table owner's name was "ARCFM8.", the Transformer feature class would actually be called "ARCFM8.Transformer".

If you do not use a style sheet to append "ARCFM8." to the beginning of the table name, on import the XML will look for "Transformer" and not find it, because the table name is "ARCFM8.Transformer." All the properties from the Transformer feature class will not be imported.

The sample Prefix.xsl uses "ARCFM8." as an example. Modify Prefix.xsl to reflect the business table owner in your database. The code sample below displays how the "prefix" variable should be modified to reflect your business table owner.

<!--  Strings to append  -->
  <xsl:variable name="prefix" select="'ARCFM8.'" />
  <xsl:variable name="prefixsys" select="'sde.'" />>
  <xsl:variable name="prefixobject" select="'arcfm.arcfm.'" /> 

Modify the Select attribute for the "prefix" variable name. For example:

 <!--  Strings to append  -->
  <xsl:variable name="prefix" select="'SampleDB.'" />
  <xsl:variable name="prefixsys" select="'sde.'" />
  <xsl:variable name="prefixobject" select="'arcfm.arcfm.'" />

Send Comment to documentation@schneider-electric.com