I don't know why the subnet information is not imported in your IPAM.Having some workaround for this issue.
[IPAM_GroupAttrData] is the table where subnet custom fields has been stored in IPAM.
Create an csv with format of groupid , customfileds2
For getting groupid for particular subnet try to run the below query in sql management studio for each subnet
select GroupId from IPAM_Group where GroupType=8 and Address =<your subnet address>
Finally your csv must look like attached format(csvFormat.png). It should not have headers.To make it simple i have given two columns. That means having two custom fields in IPAM
Try to copy the csv file into c:\test.csv solarwinds database installed location then run the below query in sql management studio
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
--Check the content of the table.
Sample Data after import of CSV
Finally your subnet custom fields will be getting populated in IPAM
hi, thank you for your quick answer!!
we know solved it in that way that we deleted the subnets which where created from dhcp, then imported the xls-list and then afterwards added the discovered dhcp scopes to the imported subnets..
so we didn't have to try out the sql-solution. I still don't know why it's possible to add dhcp-data to existing subnets from excel but not the other way around (adding excel data to existing subnets from dhcp)