Collapse All Expand All

Version: 10.1

Resource Center Home

The ArcFM Data Source Wizard allows you to change the data sources for the layers in stored displays, documents, page templates, map books, and designs (Designer only). This is extremely useful when moving stored displays from one server to another. Note: When using the Data Source Wizard, ensure all of the layers being moved are available in the destination server. Any layers missing in the destination server will have broken data sources.

 

 

The ArcFM Data Source Wizard tool is enabled on the ArcFM Solution toolbar only when you have selected a geodatabase in ArcCatalog.

Follow these procedures to update data sources for your stored displays and documents:

1. Before updating data sources, back up the following tables in the geodatabase in which the stored displays and/or documents currently reside: MM_SYSTEM_STORED_DISPLAYS, MM_STORED_DISPLAYS, MM_SYSTEM_DOCUMENTS, MM_DOCUMENTS, MM_SYSTEM_PAGE_TEMPLATES, MM_PAGE_TEMPLATES, MM_SYSTEM_PACKAGES, MM_PACKAGES.
2. In ArcCatalog, select the geodatabase to which the stored displays, page templates, map books, and/or documents are currently connected and click the ArcFM Data Source Wizard button.
3. The initial screen in the wizard reminds users to back up certain ArcFM system tables. This is a critical step. If you have not backed up these tables yet, do so now. Click Next to continue.
4. Select the stored displays and documents whose data sources you wish to update. If you select the checkbox next a node that contains stored displays, documents, page templates or map books, all nodes below it will be included. The path at the right shows the database in which the items are currently stored. The stored displays associated with sessions and designs may be included as well. These are discussed further in the section below. Click Next to continue.

   

   Sessions, Designs, and Mobile Designs

   Stored displays, page templates and map books associated with sessions and designs may also be included in the update. When these are displayed in the Data Source Wizard, they are shown by the IDs assigned by ArcFM rather than the user-defined values in the Name field. If you wish to update the data sources for a particular session or design, be sure to look for it with this ID.

   In Session Manager, use the Session ID displayed at the top of the right-hand window when the session is selected. In Workflow Manager, use the value in the Work Request Number field.

   If you have included a design with multiple data sources (e.g., mobile designs), the connection to the workspace is updated (the connection to the mobile packet remains). The user will be prompted to select a data source when the design is opened. The user may elect to connect data to the workspace or the mobile packet. Generally users on the enterprise will connect to the workspace and users in the field will connect to the mobile packet.

5. Choose whether to set all data sources or only a single data source.
   • Set All Data Sources: The data sources of all layers in the selected stored displays, documents, page templates and map books will be updated, regardless of their current data source connection. This option should not be used for data that uses multiple servers or mobile designs (or any designs with multiple data sources). This option sets ALL connections to the same data source.
   • Set Single Data Source: All layers that are currently connected to a specific data source will be updated. This option requires that you specify an original data source. Only layers connected to the specified original data source will be updated.

   SDE Connections: When setting database connections in steps 6 and 7, you may be prompted to enter a user name and password by Esri's Database Connection window. Enter the requested information and click OK. The Select Version window may prompt you to choose a version. Select and click OK. Cancelling either of these windows leaves the ArcSDE Database fields empty.

6. If you selected Set All Data Sources, skip to step 7. If you selected Set Single Data Source, you will need to specify an original data source. All layers connected to this data source will be updated to connect to the destination data source (specified in step 7). Click the "Choose data source" button to browse to the connection (either ArcSDE or personal geodatabase). Click Next to continue.

   

7. Indicate the destination data source. This is the database to which the layers in the selected items will be connected. Click the "Choose data source" button to browse to the connection (either ArcSDE or personal geodatabase). Click Next to continue.

   Authentication: If you're using an ArcSDE geodatabase, you may select the type of Authentication. Database authentication requires the user to enter their user name and password when logging into an ArcFM application. Operating system authentication (or single sign-on) uses the user's Windows login name and password.

   SQLServer: If you're connecting to a SQLServer database, enter the database in which the feature data is stored. DO NOT enter the database in which the ArcFM system tables are stored. Entering the wrong database will result in broken data source connections.

8. The final screen displays a summary of what this tool will do when executed. It displays the number of stored displays, documents, page templates and map books, and the destination data source. If you selected Set Single Data Source, the original data source is displayed as well. Click Next to begin updating the data sources.

   Note that this process may take an extended period of time, depending on the number of layers being connected. Once this process has started, it cannot be stopped or cancelled. If errors occur during the process, it will not be stopped. All errors are appended to the log file which may be accessed after the conversion is complete.

   While the tool is connecting the layers, there are a few instances in which you may be prompted by Esri's connection dialog. If you are attempting to connect layers to the same database to which they are already connected, you may be prompted to enter your user name/password information by Esri's connection dialog. If you are prompted to connect to the correct database, enter the required information and click OK. If you click Cancel, layers will no longer be connected to that database. Another instance in which you may be prompted for login information is when the stored display contains joins and relates. Again, if you are prompted to enter login information and the database is the correct one, enter the required information and click OK.

   

9. When the wizard has finished setting the data sources, it writes information to a log file. This log file includes a list of the items that were converted as well as any errors that occurred. The final screen will provide a warning that failures occurred and suggest the user view the log file. To view the log file, select the checkbox. You may also save the log to a new location. Click the Browse button and browse to the location at which you wish to save the file. Then click OK.

   

If you included designs in your update, you may wish to update the design workspaces as well. Use the Workflow Manager Data Source Wizard to do this.

 

 

 

---

Send Comment to documentation@schneider-electric.com