EDAMS Network Assets Management
How to Transfer NAM data using the Merge Utility?To transfer NAM data using the Merge Utility follow the steps below:
1) Restore the supplied [WUC_Blank_MSSQL_Database_4304.35.rar] MS SQL database using DB Manager. (Target Database). This is a blank EDAMS database into which the Oracle databases’ data will be transferred.
2) Backup the currently used Oracle Database from live environment. (Source Database) and restore it to another instance of Oracle, test environment. (NB!! This is important as during the merge process certain data in this database will be deleted).
3) Merge Utility. Run DB Manager. (Use supplied DB Manager [DBManager_2009_08_18.rar] or later version)
a) Select Other tasks
b) Select option Merge Assets database and select Begin
4) Connecting to the databases.
a) Fill in the details of the Source Database. This is the Oracle database from which the data will be migrated. Connect to the Test Environment Instance created in Step 2 above. Select Test. The version of the Source Database should now be shown.
b) Fill in the details of the Target Database. This is the MS SQL database into which the data will be migrated. Choose the supplied restored database (See 1 above) as the target database. Select Test. The version of the Target Database should now be shown.
c) NB! It is important that the source and Target versions are the same. In this case 4304.35
5) In preparation for the merge, we first cleanup any unwanted data from source and destination database.
a) Select the option. Verify Extra Data Tables (Src & Dst) (see below)
b) You will be asked to delete some data from either source or destination databases (see below). Select Yes to delete. This message will be given for all necessary deletes on tables in source and destination database.
c) Once the validation is complete you will see the Completed message
d) These actions are logged in merge.log in the db Manager Installation folder. Check it for any problems.
6) Performing the merge.
a) Select actions to be performed as per screen shot below (see below). Since the database does not have Sewer Network data. Select the Water Network Only option. De-select the Verify Extra Data Tables option (as that has been performed in step 5 above). Also select Zoning if this is used by the client.
b) Start the Merge routing. Select Process and wait for process to complete. This will take a while to run. You should see the progress bar appearing as each table’s data is saved.
c) Once the merge is completed the Completed message will be shown.
d) Now the merge is completed. Check the merge.log file for any problems.
e) Exit DB Manager.
7) Post Merge Checks.
a) Connect to the Target Database with NAM and validate that all data is correct. b) Perform any post merge settings required.
8) If the process needs to be repeated, run ALL steps again, including steps 1 and 2.
How can I load a shape file into an EDAMS database?This action can be performed using EDAMS Network Assets Managenent by following the steps below:
Press + to add new element 
Remember that the name here should not be the same as below
You may add any custom fields 3. Load data now from shape files to Database under the specific element just created
Load any attributes in Shape file as custom fields. Replace Ref
Problem with predefined Operational Conditions not being visible.We have a problem with element Pressure gauges with tab Conditional assessment. In that tab you cannot choose predefined conditions. When you open Pressure gauges and then tab operational condition you cannot see predefined conditions (see picture below)
In case the above problem appears go to system administration - reference files - operational condition types, and click the OK button without changing anything.
Problem with duplicate nodes and chains. I accidentally imported graphical data from GIS instead of refreshing graphical data. Is there an easy way to delete these duplicate records?A quick solution to rollback in such a case is to find a database backup in a desirable state and restore it to the current database that has duplicate elements. In order to do that you need to be certain that no other changes to the database were made from the time of the backup that is going to be restored. Otherwise all new changes to the database after the date of the backup will be lost! How can I set up house connections from my commercial database for use in EDAMS NAM?To set up house connections from your commercial database for use in EDAMS Network Asset Management please read the last chapter of the latest System Administration manual that fully describes the process. What is the difference between Water Connections and Geo Water Connections?Water Connections and Geo Water Connections are different entities. entities as explained below:
Geo Water Connections are Assets elements, and represent consumer connections pipes from the mains to the houses. They are represented by lines and they have connectivity and linked to chains. Those connections are controlled by Assets and are not visible in Billing. Is there a naming convention that I have to use for naming SDE Network Layers?It is completely up to you how to call network layers, but there are limitations on name prefix and suffix for SDE. What is the use of the key column in the import points from GIS layer to DTM?Key column is required because of the way the system accesses shapefiles, therefore it is important to select a column with unique values in the appropriate combo. If a key column is selected that contains not unique values all data from repeated key values will be lost. How can I represent the following pump station configuration in NAM?
This configuration is modeled as one pump station with 3 pumps in parallel.
Can I convert the display units in the EDAMS GIS interface to decimal degrees?Yes there is an option in EDAMS GIS for converting display units between X,Y and Lat Long (display coordinates in X, Y or Lat and Long) Can I capture point elements in NAM by specifying X and Y coordinates in decimal degrees ( lat , long)?There is a function in EDAMS NAM to insert either a node or point custom element by typing in its coordinates. When you click that button, you have to indicate the point position in GIS, and immediately after pops up the window where you can refine coordinates by typing. Note that for this to work, the corresponding point layer in GIS must have a defined geographic coordinate system which utilizes lats and longs and not meters. The form which pops up after insertion detects if it should display coordinates in degrees (from system settings).After that the system checks if the relevant point layer in the GIS has a Geographic coordinate system and if yes - it displays coordinates in degrees. The layer coordinate system will be used to convert x and y to lat and long, and vise versa. Can I modify the extends of a layer in EDAMS GIS?When I zoom to a specific layer the map zooms really out showing all data as a small dot on the map. There must be a problem with the extends of the specific layer. Can I modify the extends of this layer to overcome the problem. Yes you can do that by using the command line utility. How to use it: You must know the server name, password, username and service name or port number First, you should write a command to describe the layer: c:\>sdelayer -o describe_long -u sde -p sde -i 5153 -s panagiotis -l water_nodes,shape where in response, command output must look similar to this: ArcSDE 9.2 for SQL Server Build 1081 Sun Sep 17 16:01:22 2006 Layer Configuration ..: DEFAULTS The Important information to check in the above is the : after that you must run the command: c:\>sdelayer -o alter -u sde -p sde -i 5153 -s panagiotis -l water_nodes,shape -E 21403.93977,-3769203.76108,76752.32770,-3717800 which will alter layer envelope, coordinates listed as minx,miny,maxx,maxy How can I reset saved forms placement positions?You should clear registry brunch: Too many decimal places when labeling layer using annotation in EDAMS GIS.When creating an annotation query to label pipes in EDAMS GIS the labels appear with too many decimal places which is not desirable. How can I remove these unnecessary decimal places?
To overcome this problem you must re-write the query which is used for the annotation. Which attribute should I use for calculating total length of pipes?Which attribute field should I use for calculating total length of pipes I_LENGTH or GIS_LENGTH |
©1999 - 2009 Hydro-Comp Enterprises Ltd. All rights reserved