Use tools in the DB Editor to preserve active field mappings when updating exchange clusters.
Tutorial resources
These downloadable resources will be used to complete this tutorial:
Transcript
00:04
Once you have created a GIS exchange cluster, in anticipation of updating a model,
00:08
you may need to update the exchange cluster to use a new GIS
00:11
database.
00:13
Instead of using the GIS gateway,
00:16
you can use a tool in the DB editor to preserve the active field mappings
00:21
by editing the updated GIS data path using this method,
00:24
the GIS field mapping will not be reset,
00:27
which is what happens when you select a new
00:28
GIS data source inside an existing GIS exchange cluster
00:34
to begin double click the desired project dot APR
00:37
file to open Argi
00:39
Pro.
00:41
Once the project starts,
00:42
click the info water pro tab to open the info water pro ribbon.
00:46
In the project panel, click initialize.
00:51
In this example, the GIS exchange cluster has been configured for new pipe creation
00:57
on the info water pro ribbon. In the edit panel, click DB editor
01:02
under data table, expand the advanced application data for advanced user folder,
01:08
select GIS gateway cluster and click OK.
01:13
In the DB editor expand the database column width. So you can see the full file paths.
01:21
You can see the new exchange cluster
01:23
that was previously created called pipe update,
01:27
double click the file path in the database columns for pipe update to highlight it.
01:32
Then right click and select copy
01:36
next, select the file path in the database column for the entry to the pipes cluster.
01:41
Double click to select and highlight the path.
01:43
And then right click and select. Paste
01:48
the file path for the pipes cluster should now
01:50
match the path for the new cluster pipe update.
01:53
Click save and then exit to close the DB editor.
01:58
You can verify these changes in the GIS gateway
02:01
on the info water pro ribbon edit panel, click GS gateway
02:07
in the GIS exchange cluster section, select pipes
02:10
and click edit
02:12
in the GI
02:13
exchange cluster dialogue.
02:15
Note that the GIS data source is displaying the
02:17
updated file path you set in the DB editor
02:21
in the field mapping tab scroll through the network slash GIS
02:24
data field mapping list to verify that the field mapping remains in place.
02:30
The GIS fields,
02:31
comment install yr material length and diameter should all be present
02:38
by updating the file path. In the DB editor.
02:40
These field mappings from the pipe update cluster are preserved.
02:44
If you were to update the GIS data
02:46
source directly within the exchange cluster dialogue,
02:49
all the field mappings would be cleared and you would need to remap all the fields.
02:54
Click OK to exit the exchange cluster dialogue
02:57
and then click close to exit the GIS gateway
00:04
Once you have created a GIS exchange cluster, in anticipation of updating a model,
00:08
you may need to update the exchange cluster to use a new GIS
00:11
database.
00:13
Instead of using the GIS gateway,
00:16
you can use a tool in the DB editor to preserve the active field mappings
00:21
by editing the updated GIS data path using this method,
00:24
the GIS field mapping will not be reset,
00:27
which is what happens when you select a new
00:28
GIS data source inside an existing GIS exchange cluster
00:34
to begin double click the desired project dot APR
00:37
file to open Argi
00:39
Pro.
00:41
Once the project starts,
00:42
click the info water pro tab to open the info water pro ribbon.
00:46
In the project panel, click initialize.
00:51
In this example, the GIS exchange cluster has been configured for new pipe creation
00:57
on the info water pro ribbon. In the edit panel, click DB editor
01:02
under data table, expand the advanced application data for advanced user folder,
01:08
select GIS gateway cluster and click OK.
01:13
In the DB editor expand the database column width. So you can see the full file paths.
01:21
You can see the new exchange cluster
01:23
that was previously created called pipe update,
01:27
double click the file path in the database columns for pipe update to highlight it.
01:32
Then right click and select copy
01:36
next, select the file path in the database column for the entry to the pipes cluster.
01:41
Double click to select and highlight the path.
01:43
And then right click and select. Paste
01:48
the file path for the pipes cluster should now
01:50
match the path for the new cluster pipe update.
01:53
Click save and then exit to close the DB editor.
01:58
You can verify these changes in the GIS gateway
02:01
on the info water pro ribbon edit panel, click GS gateway
02:07
in the GIS exchange cluster section, select pipes
02:10
and click edit
02:12
in the GI
02:13
exchange cluster dialogue.
02:15
Note that the GIS data source is displaying the
02:17
updated file path you set in the DB editor
02:21
in the field mapping tab scroll through the network slash GIS
02:24
data field mapping list to verify that the field mapping remains in place.
02:30
The GIS fields,
02:31
comment install yr material length and diameter should all be present
02:38
by updating the file path. In the DB editor.
02:40
These field mappings from the pipe update cluster are preserved.
02:44
If you were to update the GIS data
02:46
source directly within the exchange cluster dialogue,
02:49
all the field mappings would be cleared and you would need to remap all the fields.
02:54
Click OK to exit the exchange cluster dialogue
02:57
and then click close to exit the GIS gateway
Once you have created a GIS exchange cluster in anticipation of updating a model, you may need to update the exchange cluster to use a new GIS database. Instead of using the GIS Gateway, you can use a tool in the DB Editor to preserve the active field mappings. By editing the updated GIS data path using this method, the GIS field mapping will not be reset, which is what happens when you select a new GIS data source inside an existing GIS exchange cluster.
In this example, the GIS exchange cluster has already been configured for new pipe creation. To update the GIS exchange cluster:
To verify the changes:
Note: In the GIS Exchange Cluster dialog, the GIS Data Source now displays the updated file path set in the DB Editor.
By updating the file path in the DB Editor, these field mappings from the PIPE_UPDATE cluster are preserved. If the GIS data source were updated directly within the Exchange Cluster dialog, all the field mappings would be cleared, and all the fields would need to be remapped.
