& Construction

Integrated BIM tools, including Revit, AutoCAD, and Civil 3D
& Manufacturing

Professional CAD/CAM tools built on Inventor and AutoCAD
Locate and import custom tables originally created in InfoAsset Planner.
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.
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.