Import InfoAsset Planner data into Info360 Asset through ArcGIS Online

Publish InfoAsset Planner data to ArcGIS Online, and then import the data into Info360 Asset.


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 use the publisher tool in InfoAsset Planner to export layers to ArcGIS Online,

00:18

and then import the layers into Info360 Asset.

00:22

To conduct this process, you need full access permissions in the Info360 Asset tenant

00:28

and an ArcGIS Online account.

00:31

With your InfoAsset Planner project opened in ArcMap, sign in to your ArcGIS Online account.

00:37

From the File menu, select ArcGIS Online.

00:42

In the popup, click Sign in, enter your login credentials, and then click Sign In again.

00:51

Close the ArcGIS Online popup.

00:54

From the InfoAsset Planner toolbar, click Publish InfoAsset Planner Data.

00:60

This tool shows all project data that can be published online as a hosted feature layer.

01:06

For this example, make sure that the Manhole and Gravity Main entries are selected.

01:12

In the AGOL Feature Service Name field, enter a name, such as “InfoAssetPlannertoInfo360Asset”,

01:19

and then click Publish Selected Data.

01:23

When you see the message that the publishing is finished, click OK.

01:27

Then, sign in to your ArcGIS Online account to verify.

01:32

From a browser window, navigate to arcgis.com and sign in with your credentials.

01:38

The resulting feature layer can be found under Content > My Content, as well as on the Gallery tab.

01:46

You can now import these layers into Info360 Asset.

01:50

Before importing, you must connect your Info360 Asset project with ArcGIS Online.

01:57

Click Admin.

01:60

Switch to the Integration tab, then click Create New Integration.

02:06

In the New Integration popup, set the Integration Type to ArcGIS Online, and then click Get Started.

02:14

Enter a name for the integration, and then click Authenticate.

02:20

Once again, enter your ArcGIS Online credentials and click Sign In.

02:27

Once authenticated, enable the integration, and then click Save.

02:33

You can now import your layers.

02:36

Click Data, and from the Assets tab, click New Import.

02:43

Set the System Type to Sanitary Sewer, the Asset Type to Pipe, and the Data Source to your named Integration.

02:53

Click Select Layer, and from the list, select your integration—in this example, InfoAssetPlannertoInfo360Asset is selected.

03:04

You can use the Search if you have a long list of layers.

03:08

Click Next.

03:10

From the Layers list, select Gravity_Mains, then click Select Layer.

03:19

Once imported, you can proceed to the mapping process from your Source to the Target fields.

03:24

Note that fields with an asterisk are mandatory to map.

03:29

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

03:38

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

03:42

Map assetId to FACILITYID

03:45

Map DsNodeId to TOMH

03:50

Map Length to PipeLength

03:53

Map usNodeId to FROMMH

03:58

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

04:05

Map width to DIAMETER and set the Source Unit to inch

04:11

Map usInvert to UPELEV and set the Source Unit to foot

04:16

Map material to MATERIAL

04:20

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

04:29

Once you have finished mapping, click Import.

04:33

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

04:41

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

04:47

From the Asset page, set the Asset Type to Manhole, and then click Select Layer.

04:53

Select the same integration, and then from the Layers list, select Manholes and click Select Layer.

05:02

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

05:07

For this example, map the following fields:

05:10

Map assetId to FACILITYID

05:14

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

05:22

Map groundLevel to RIMELEV and set the Source Unit to foot

05:27

Map material to WALLMAT

05:31

Map owner to OWNEDBY

05:35

Map locationDetails to LOCDESC

05:39

Map systemType to WATERTYPE

05:43

Click Import.

05:45

Add a Configuration name, such as “IAP Schema”, and then click OK to import the manholes from ArcGIS Online.

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 use the publisher tool in InfoAsset Planner to export layers to ArcGIS Online,

00:18

and then import the layers into Info360 Asset.

00:22

To conduct this process, you need full access permissions in the Info360 Asset tenant

00:28

and an ArcGIS Online account.

00:31

With your InfoAsset Planner project opened in ArcMap, sign in to your ArcGIS Online account.

00:37

From the File menu, select ArcGIS Online.

00:42

In the popup, click Sign in, enter your login credentials, and then click Sign In again.

00:51

Close the ArcGIS Online popup.

00:54

From the InfoAsset Planner toolbar, click Publish InfoAsset Planner Data.

00:60

This tool shows all project data that can be published online as a hosted feature layer.

01:06

For this example, make sure that the Manhole and Gravity Main entries are selected.

01:12

In the AGOL Feature Service Name field, enter a name, such as “InfoAssetPlannertoInfo360Asset”,

01:19

and then click Publish Selected Data.

01:23

When you see the message that the publishing is finished, click OK.

01:27

Then, sign in to your ArcGIS Online account to verify.

01:32

From a browser window, navigate to arcgis.com and sign in with your credentials.

01:38

The resulting feature layer can be found under Content > My Content, as well as on the Gallery tab.

01:46

You can now import these layers into Info360 Asset.

01:50

Before importing, you must connect your Info360 Asset project with ArcGIS Online.

01:57

Click Admin.

01:60

Switch to the Integration tab, then click Create New Integration.

02:06

In the New Integration popup, set the Integration Type to ArcGIS Online, and then click Get Started.

02:14

Enter a name for the integration, and then click Authenticate.

02:20

Once again, enter your ArcGIS Online credentials and click Sign In.

02:27

Once authenticated, enable the integration, and then click Save.

02:33

You can now import your layers.

02:36

Click Data, and from the Assets tab, click New Import.

02:43

Set the System Type to Sanitary Sewer, the Asset Type to Pipe, and the Data Source to your named Integration.

02:53

Click Select Layer, and from the list, select your integration—in this example, InfoAssetPlannertoInfo360Asset is selected.

03:04

You can use the Search if you have a long list of layers.

03:08

Click Next.

03:10

From the Layers list, select Gravity_Mains, then click Select Layer.

03:19

Once imported, you can proceed to the mapping process from your Source to the Target fields.

03:24

Note that fields with an asterisk are mandatory to map.

03:29

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

03:38

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

03:42

Map assetId to FACILITYID

03:45

Map DsNodeId to TOMH

03:50

Map Length to PipeLength

03:53

Map usNodeId to FROMMH

03:58

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

04:05

Map width to DIAMETER and set the Source Unit to inch

04:11

Map usInvert to UPELEV and set the Source Unit to foot

04:16

Map material to MATERIAL

04:20

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

04:29

Once you have finished mapping, click Import.

04:33

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

04:41

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

04:47

From the Asset page, set the Asset Type to Manhole, and then click Select Layer.

04:53

Select the same integration, and then from the Layers list, select Manholes and click Select Layer.

05:02

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

05:07

For this example, map the following fields:

05:10

Map assetId to FACILITYID

05:14

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

05:22

Map groundLevel to RIMELEV and set the Source Unit to foot

05:27

Map material to WALLMAT

05:31

Map owner to OWNEDBY

05:35

Map locationDetails to LOCDESC

05:39

Map systemType to WATERTYPE

05:43

Click Import.

05:45

Add a Configuration name, such as “IAP Schema”, and then click OK to import the manholes from ArcGIS Online.

Was this information helpful?