I can't get you. You are worrying about subnet description then download the "Download an example spreadsheet with Subnets" from Import spread sheet link.
Fill appropriate subnet information and there is a field called "Descroption" fill that with your information.
After importing process the subnets will be filled with description.
Let me know If i am completely dealing about different information.
I'm having the same issue. I'm unable to import updates to existing subnets. Based on what I see, you can't use the sample spreadsheet, fill in the appropriate information, and then import. The response is always that the import overlaps with an existing subnet. "Overlapping with subnet: x.x.x.x"
To be clear, i'm not trying to update IP information within a subnet. I'm trying to update the description of each subnet that already exists.
Same issue here. I want to update subnet Description via an import.
I'm using Add Subnets & IP Addresses> Import subnets & IP addresses from a spreadsheet
Then I select This File Includes: Groups/Supernets/Subnets
I've tried importing with the following fields in a spreadsheet:
IP Address, Subnet Display Name, Subnet Address, Type, Description
The Wizard then has Subnet Column Mapping page with sections for Required Group information and Optional fields.
Required is only Type (i.e. Group, Supernet, Subnet, IPV6) - I choose Type, and my sheet has a column called Type, with the word Subnet.
I then pick the following Optional fields/Columns and pair them with the columns in the Import file:
Optional Column Import Column
Address: Subnet Address
Display Name (i.e. 3rd floor): Subnet Display Name
Group Description: Description
All other fields are set to Do Not Import.
The wizard ran without error, but no change is visible in Manage Subnets & IP Addresses.
I looked at the IPAM_GROUP table with Database Manager, and made a map of apparent similarities with the Manage Subnets & IP Addresses column headings based on the original subnet.
IPAM_GROUP field Manage Subnets & IP Addresses heading
AddressMask Mask (i.e. 255.255.255.0)
FriendlyName Display Name (i.e. 3rd floor)
Comments Group Description
ScanInterval Scan Interval
NodeExpungeInterval Node Expunge Interval
DisableAutoScanning Disable Auto Scanning (i.e. Yes or No)
DisableNeighborScanning Disable Neighbor Scanning (i.e. Yes or No)
NeighborScanAddress Neighbor Scan Address
NeighborScanInterval Neighbor Scan Interval
TransientPeriod Transient Period
RetainUserData Retain User Data (i.e. Yes or No)
no equivalent Address/CIDR (i.e. 10.10.1.0/24)
I found that the wizard simply appended the import to the end of the table, though it did match the parent group properly. It also set the proper Type value (8).
Oddly, it calculated the Address/CIDR and put that in the FriendlyName field of the table !?!
It put the Group Description/Description from the import into the Comments field, and threw away the Display Name/Subnet Display Name field from the import !?!
I exported the table to a CSV from Database Manager to determine all this.
I still have some reverse-engineering to do to map the Optional Column names to the IPAM_Group fields in order to find what field maps to Friendly Name.
Running into the same issue, any resolution?
We've tried the import and export options for IPAM and found it lacking and it didn't work for us. In our instance we needed to build the hierarchy and populate everything manually and have over 700k ip's. This took many hours and many days and lots of caffeine. I myself have an opened feature request to hopefully get them to enhance so we can have better import export for ipam. For us, when we did manage to import anything it would just dump it in a folder instead of building everything out.
We had to fill in subnets, supernets, description, etc. It was highly frustrating but manually we got it done.
Not sure this will help any. But wanted to share since it's relevant to the post.