Import shapefiles from InfoAsset Planner into Info360 Asset

Export pipe and manhole shapefiles from InfoAsset Planner, and then import these shapefiles into an InfoAsset 360 project.


00:03

When migrating from InfoAsset Planner to Info360 Asset, there are a couple of ways to move your project data.

00:11

One of these options is to export shapefiles from InfoAsset Planner, and then import them into Info360 Asset.

00:19

InfoAsset Planner GIS data for sewer and water assets is available in the Info Asset Planner file geodatabase,

00:26

within the Sewer_Network or Water_Network feature layers.

00:30

You can see these networks in the Catalog view, under the project database.

00:36

Expand Sewer_Network to see the SS Gravity Main and SS Manhole layers.

00:41

These same layers can be found in the Table of Contents.

00:45

The easiest way to export the gravity main and manhole shapefiles is through the Table Of Contents.

00:51

Expand the Sewer_Network layer.

00:54

Right-click Gravity Main and select Data > Export Data.

01:01

In the Export Data dialog, click the folder icon to select a location, then add a name for your shapefile, such as "GravityMains".

01:10

Click Save, and then OK.

01:13

If you see a popup about adding the exported data to the map as a layer, click No.

01:20

Repeat these steps to export the manhole shapefile, naming the file "Manholes".

01:26

You are now ready to import these shapefiles into Info360 Asset.

01:31

To start the import process, with an Info360 Asset project open, click Data.

01:39

From the Assets tab, click New Import.

01:42

The first import will be the pipe shapefile.

01:45

Set the System Type to Sanitary Sewer, the Asset Type to Pipe, and the Data Source to Shapefile.

01:56

To import a shapefile, you need a single .zip file containing all the .shp, .shx, .dbf, and .prj files.

02:07

Click in the Drag and drop file here box to open your file browser.

02:11

Navigate to where you exported the shapefiles from InfoAsset Planner.

02:16

Select all of the GravityMains files, then right-click and select Send to > Compressed (zipped) folder.

02:24

Select the newly created .zip file, then click Open.

02:28

You can now map fields from your Source to the Target fields.

02:32

Note that fields with an asterisk are mandatory to map.

02:37

Click each of the following Target fields, use the Configure dialog drop-down to map it to the accompanying Source Field, then click OK.

02:46

In some cases, you also need to set a Source Unit:

02:50

Map assetId to FACILITYID

02:54

Map DsNodeId to TOMH

02:58

Map Length to PipeLength

03:01

Map usNodeId to FROMMH

03:05

Map material to MATERIAL

03:08

Map yearLaid to INSTALLDAT and set the Source Unit to date [YYMMDD]

03:15

Set other non-mandatory fields, as needed, such as installation date, pipe diameter, upstream invert, and pipe material.

03:25

Click Import.

03:27

Add a Configuration name, such as “pipesimport”, and then click OK.

03:33

After this import process is complete, repeat the same steps for manholes.

03:38

Click New Import, set the Asset Type to Manhole, and once again, set the Data Source to Shapefile.

03:48

Click the Drag and drop file here box, and in the file browser, create a .zip comprising all of the manhole shapefiles.

03:57

Select the .zip file, then click Open.

04:01

As with the pipes shapefile, there are certain fields to match for the manholes.

04:06

Map the following:

04:08

Map assetId to FACILITYID

04:12

Map yearLaid to INSTALLDAT and set the Source Unit to date [YYMMDD]

04:21

Map groundLevel to RIMELEV and set the Source Unit to foot

04:27

Map material to WALLMAT

04:30

Map owner to OWNEDBY

04:34

Map locationDetails to LOCDESC

04:39

Map systemType to WATERTYPE

04:43

After matching all fields, click Import.

04:47

Add a name, such as "manholesimport", then click OK.

04:52

Once the import is completed, since you have no more shapefiles to import, click I’m Done.

04:59

You can see your imported shapefiles in the Network map.

05:02

Open the Layers panel, then expand Sanitary Sewer to find your Manholes and Pipes.

05:09

Zoom in to the map to see the manholes and pipes more clearly.

Video transcript

00:03

When migrating from InfoAsset Planner to Info360 Asset, there are a couple of ways to move your project data.

00:11

One of these options is to export shapefiles from InfoAsset Planner, and then import them into Info360 Asset.

00:19

InfoAsset Planner GIS data for sewer and water assets is available in the Info Asset Planner file geodatabase,

00:26

within the Sewer_Network or Water_Network feature layers.

00:30

You can see these networks in the Catalog view, under the project database.

00:36

Expand Sewer_Network to see the SS Gravity Main and SS Manhole layers.

00:41

These same layers can be found in the Table of Contents.

00:45

The easiest way to export the gravity main and manhole shapefiles is through the Table Of Contents.

00:51

Expand the Sewer_Network layer.

00:54

Right-click Gravity Main and select Data > Export Data.

01:01

In the Export Data dialog, click the folder icon to select a location, then add a name for your shapefile, such as "GravityMains".

01:10

Click Save, and then OK.

01:13

If you see a popup about adding the exported data to the map as a layer, click No.

01:20

Repeat these steps to export the manhole shapefile, naming the file "Manholes".

01:26

You are now ready to import these shapefiles into Info360 Asset.

01:31

To start the import process, with an Info360 Asset project open, click Data.

01:39

From the Assets tab, click New Import.

01:42

The first import will be the pipe shapefile.

01:45

Set the System Type to Sanitary Sewer, the Asset Type to Pipe, and the Data Source to Shapefile.

01:56

To import a shapefile, you need a single .zip file containing all the .shp, .shx, .dbf, and .prj files.

02:07

Click in the Drag and drop file here box to open your file browser.

02:11

Navigate to where you exported the shapefiles from InfoAsset Planner.

02:16

Select all of the GravityMains files, then right-click and select Send to > Compressed (zipped) folder.

02:24

Select the newly created .zip file, then click Open.

02:28

You can now map fields from your Source to the Target fields.

02:32

Note that fields with an asterisk are mandatory to map.

02:37

Click each of the following Target fields, use the Configure dialog drop-down to map it to the accompanying Source Field, then click OK.

02:46

In some cases, you also need to set a Source Unit:

02:50

Map assetId to FACILITYID

02:54

Map DsNodeId to TOMH

02:58

Map Length to PipeLength

03:01

Map usNodeId to FROMMH

03:05

Map material to MATERIAL

03:08

Map yearLaid to INSTALLDAT and set the Source Unit to date [YYMMDD]

03:15

Set other non-mandatory fields, as needed, such as installation date, pipe diameter, upstream invert, and pipe material.

03:25

Click Import.

03:27

Add a Configuration name, such as “pipesimport”, and then click OK.

03:33

After this import process is complete, repeat the same steps for manholes.

03:38

Click New Import, set the Asset Type to Manhole, and once again, set the Data Source to Shapefile.

03:48

Click the Drag and drop file here box, and in the file browser, create a .zip comprising all of the manhole shapefiles.

03:57

Select the .zip file, then click Open.

04:01

As with the pipes shapefile, there are certain fields to match for the manholes.

04:06

Map the following:

04:08

Map assetId to FACILITYID

04:12

Map yearLaid to INSTALLDAT and set the Source Unit to date [YYMMDD]

04:21

Map groundLevel to RIMELEV and set the Source Unit to foot

04:27

Map material to WALLMAT

04:30

Map owner to OWNEDBY

04:34

Map locationDetails to LOCDESC

04:39

Map systemType to WATERTYPE

04:43

After matching all fields, click Import.

04:47

Add a name, such as "manholesimport", then click OK.

04:52

Once the import is completed, since you have no more shapefiles to import, click I’m Done.

04:59

You can see your imported shapefiles in the Network map.

05:02

Open the Layers panel, then expand Sanitary Sewer to find your Manholes and Pipes.

05:09

Zoom in to the map to see the manholes and pipes more clearly.

Was this information helpful?