Error when using Import Floor Plans to Geodatabase

[steveflo]

Hello all,

We just got indoors and I was trying to use the tool Import Floor Plans to Geodatabase. I am using the Excel Template File that is provided and ESRI's webpage Configure CAD floor plan mappings and metadata. However, I get this error:

ERROR 180134: Invalid value: invalid literal for int() with base 10: 'B1' in worksheet: Level Properties

I followed the instructions, but not sure why I'm getting the error. My Level IDs look like this UC.BERK.MAIN.CAL.B1.

Any help to steer me in the right direction would be appreciated it. Thank you. 

[GauravJobanputra]

@steveflo can you please provide the link to the webpage where you downloaded the Excel spreadsheet from and also please let us know what version of ArcGIS Pro are you on.

[steveflo]

SFrank solution solved it.

I'm on ArcGIS Pro 3.0.3. 

[GauravJobanputra]

Very glad to know. Don't forget to leave her a Kudo! @SFrank is working on a tool which won't require filling out the sheet. Keep an eye on our announcements for the next release!

[SFrank · Accepted solution]

Hi @steveflo -- This error message looks like you may be populating an Integer field in the Level Properties sheet with a non-Integer value. Is it possible that you have populated the LEVEL_NUMBER column with the value "B1"? If that is the case, try changing the value to "1" and running the tool.

One tip for filling out that spreadsheet is that there are tooltips in the Excel spreadsheet that can be helpful, along with the Configure CAD floor plan mappings documentation.

[steveflo]

This worked for me. I completely misunderstood the error and thought they were referring to cell B1. I didn't see the tooltips before. Thank you!