Import custom tables

Locate and import custom tables originally created in InfoAsset Planner.


00:03

In Info360 Asset, you can import and work with custom tables originally created in InfoAsset Planner.

00:11

Open your InfoAsset Planner project in ArcMap.

00:15

You can view which background layers and external tables are being referenced in the Catalog pane.

00:21

Expand the InfoAsset Planner database.

00:25

In this example the model is called FinishedProjectDB.gdb.

00:30

Locate the IMIC_Likelihoods table, and then drag and drop it into the Table of Contents.

00:37

From the Table of Contents, right-click the table and select Open.

00:43

For this example, look at the LOF12 row.

00:46

The Description and Attribute fields for this Likelihood ID is Count of service requests.

00:53

Take note of the LayerName and LayerFullName to help you locate this custom table in Info360 Asset.

01:00

In this case, the file is a CSV, which is the format needed to import a custom table.

01:06

If the table is a different format, then it will need to be converted to CSV.

01:12

With this information, you are ready to import the custom table.

01:16

In Info360 Asset, click the Data icon, then switch to the Custom Tables tab.

01:24

Click New Import.

01:26

Add a Layer Name of "Count of service requests", set the System Type to Sanitary Sewer, and set the Related Asset Type to Pipe.

01:36

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

01:40

Navigate to the file location that you noted in the LayerFullName field, select the Data for Risk analysis.csv file, and then click Open.

01:50

Map the fields that you noted in the IMIC_Likelihoods table.

01:55

Start with the mandatory field, which is the asset ID that matches the asset ID in the GIS.

02:02

In this example, it is the PLR field.

02:05

In the Configure popup, set the Target Field to PLR, turn on Primary Key, and then click OK.

02:15

Once the mapping is complete, make sure that Import Configuration is set to New Configuration, and then click Import.

02:24

Add a Configuration name, such as "Count of Service Requests", then click OK to start the import.

02:32

After the import is complete, the Import Complete popup opens, and you can choose to start a New Import or click I'm Done.

02:41

The CSV table is now available on the Custom Tables tab.

Video transcript

00:03

In Info360 Asset, you can import and work with custom tables originally created in InfoAsset Planner.

00:11

Open your InfoAsset Planner project in ArcMap.

00:15

You can view which background layers and external tables are being referenced in the Catalog pane.

00:21

Expand the InfoAsset Planner database.

00:25

In this example the model is called FinishedProjectDB.gdb.

00:30

Locate the IMIC_Likelihoods table, and then drag and drop it into the Table of Contents.

00:37

From the Table of Contents, right-click the table and select Open.

00:43

For this example, look at the LOF12 row.

00:46

The Description and Attribute fields for this Likelihood ID is Count of service requests.

00:53

Take note of the LayerName and LayerFullName to help you locate this custom table in Info360 Asset.

01:00

In this case, the file is a CSV, which is the format needed to import a custom table.

01:06

If the table is a different format, then it will need to be converted to CSV.

01:12

With this information, you are ready to import the custom table.

01:16

In Info360 Asset, click the Data icon, then switch to the Custom Tables tab.

01:24

Click New Import.

01:26

Add a Layer Name of "Count of service requests", set the System Type to Sanitary Sewer, and set the Related Asset Type to Pipe.

01:36

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

01:40

Navigate to the file location that you noted in the LayerFullName field, select the Data for Risk analysis.csv file, and then click Open.

01:50

Map the fields that you noted in the IMIC_Likelihoods table.

01:55

Start with the mandatory field, which is the asset ID that matches the asset ID in the GIS.

02:02

In this example, it is the PLR field.

02:05

In the Configure popup, set the Target Field to PLR, turn on Primary Key, and then click OK.

02:15

Once the mapping is complete, make sure that Import Configuration is set to New Configuration, and then click Import.

02:24

Add a Configuration name, such as "Count of Service Requests", then click OK to start the import.

02:32

After the import is complete, the Import Complete popup opens, and you can choose to start a New Import or click I'm Done.

02:41

The CSV table is now available on the Custom Tables tab.

Was this information helpful?