Error 180161 when loading CAD File

[OlivierTravaglini]

Hello,

I'm trying to load CAD files into ArcGIS Indoors using the CONFIG_CAD_Indoors_Template.xlsx file delivered with ArcGIS Pro 3.1.2.

When I launch the Toolbox Import Floorplans To Indoors Geodatabase I get an error 180161 with the following message:

Import Floorplans To Indoors Geodatabase

=====================

Parameters

Target unit entities C:\Temp\ArcGIS_Indoors\ArcGIS_Indoors.gdb\Indoors\Units

Target detail entities C:\Temp\ArcGIS_IndoorsArcGIS_Indoors.gdb\Indoors\Details

Target level entities C:\Temp\ArcGIS_IndoorsArcGIS_Indoors.gdb\Indoors\Levels

Target building entities C:\Temp\ArcGIS_IndoorsArcGIS_Indoors.gdb\Indoors\Facilities

Input Excel Template File C:\Temp\ArcGIS_Indoors\test_config_indoors.xlsx

Unique ID Delimiter PERIOD

Sliver Threshold 2

Door Close Buffer 0

Surface measurement unit SQUARE_METERS

PLANAR measurement mode

Target section entities    

Target area entities    

Updated units C:\Temp\ArcGIS_Indoors\ArcGIS_Indoors.gdb\Indoors\Units

=====================

Messages

Start time: Thursday, August 3, 2023 12:09:08 PM

Retrieve floor plan mapping details from an input Excel file...

Retrieve building properties from an input Excel file...

Validate worksheet: Facility Properties...

Retrieve level properties from an Excel input file...

Validate worksheet: Level Properties...

Validate worksheet: Source Files...

ERROR 180161: The Level Properties worksheet cannot contain a SOURCE_PATH column.

Import floor plans into Indoors geodatabase script failed...

Failed to execute (ImportFloorplansToIndoorsGDB).

Failed on Thursday, August 3, 2023 12:09:24 (elapsed time: 16.36 seconds)

It seems that the Excel file is not configured correctly. Does anyone have a solution?

Thanks in advance.

[Jinho_Kang]

Error information;

180161: Level Properties sheet cannot have SOURCE_PATH column.—ArcGIS Pro | Documentation

I wonder if you're using an outdated Excel configuration sheet?

The attached Excel should work with Pro 3.1.2.

SOURCE_PATH is now under the 'Souce Files' tab.

[OlivierTravaglini]

Hi @Jinho_Kang Thank you for your answer, but I'm using the same Excel template as you have send.

[SFrank]

Hi @OlivierTravaglini, Can you verify that values in the following two fields match between sheets in the configuration file:

1. Source Files sheet's LEVEL_ID column
2. Level Properties sheet's LEVEL_ID column

Each LEVEL_ID field value in the Level Properties sheet should correspond to a matching LEVEL_ID field value in teh Source Files sheet. If the tool doesn't find at least one match it throws the error that you encountered.

[ParkerWelch]

For anyone here troubleshooting, this worked for me. I was copying and updating a previous CAD config file when importing to Indoors GDB and forgot to update my Id's in the Level Properties sheet. I was getting the same error message (180161)  but my config file did not have a SOURCE_PATH column in the Source Files sheet, so I figured the error message was incorrect.

I updated my Level Properties sheet to match the Source File sheet and everything worked as expected.

[OlivierTravaglini]

Hello Franck

Thank you for your reply, which enabled us to take things a step further.
Unfortunately we still have an error message.
I've put the Excel file, the logs and screenshots, and the two CAD files in the attached .zip file.
The CAD file doesn't contain any labels. Could this be the problem?
For your information, we're in Switzerland, the projection file is not WGS84 but CH1903+ LV95 and the CAD file only contains data for one floor (4th) of a building.

[SFrank · Accepted solution]

Hi @OlivierTravaglini, Thanks for attaching the sample data, very helpful! This looks like another small configuration issue. Looks like while you inlcuded A-DOOR in the OPENINGS column, you didn't include them in the DETAILS column. A couple notes--

• Since you aren't using the UNIT_LINES column and instead have closed polylines that represent your units, you can remove A-DOOR from the OPENINGS column.
• Add A-DOOR and any other features you'd like to bring in as polylines (eg, A-WALL, A-FURN, etc) to the DETAILS column.

Here's some additional information on the Excel spreadsheet and what each column should contain.

You may also be interested in knowing that we are currently developing a new tool to import CAD to the Indoors model that will remove the requirement for the Excel spreadsheet altogether.

[OlivierTravaglini]

Hi @SFrank Many thanks for your explanation. Everything works fine now. 

Best regards

Olivier