-
Re: Importing IPs from ToolSet's IP Address Management
mark wiggans Apr 29, 2009 3:16 PM (in response to sean.boston)Yes, this is possible.
The steps can be found here.
http://www.solarwinds.com/NetPerfMon/SolarWinds/OrionIPAMAGImportingIPAddressesSettings.htm
-
Re: Importing IPs from ToolSet's IP Address Management
sean.boston Apr 30, 2009 8:07 AM (in response to mark wiggans)Hello Mark;
These instructions are only for importing from a Excel xls or csv file. That would mean exporting each of the IP addresses ranges. Isn't there a way to import the whole ipdb file into IPAM?
-
-
Re: Importing IPs from ToolSet's IP Address Management
tonyled Apr 30, 2009 8:20 AM (in response to sean.boston)i too found no way to do this and have been entering all of mine manually
-
Re: Importing IPs from ToolSet's IP Address Management
bshoppApr 30, 2009 8:53 AM (in response to tonyled)
There is a command line utility you can run to import subnets and IP's from Toolset, let me get the directions for you and re-post
-
Re: Importing IPs from ToolSet's IP Address Management
bshoppApr 30, 2009 8:57 AM (in response to tonyled)
1 of 1 people found this helpfulHere you go
The parameter after STOP and START need to be enclosed within double quotes (and not the ones Word replaces on you with).
1. Locate the Toolset IP Address Manager database on your Toolset server.
Note: The Toolset IP Address Manager database has an .ipdb extension.
2. Copy the Toolset IP Address Manager database to an appropriate location on your Orion server.
3. Open the Command Prompt on your Orion server.
Note:Typically, the command prompt may be opened by clicking Start > All Programs > Accessories > Command Prompt.
4. Enter CD <volume>:\Program Files\SolarWinds\Orion\IPAM.
5. Enter NET STOP "SolarWinds IPAM Information Service"
6. Enter SolarWinds.IPAM.Init.exe -import <Full path to your Toolset IP Address Manager database>.
7. Enter NET START "SolarWinds IPAM Information Service"
-
Re: Importing IPs from ToolSet's IP Address Management
rgward Apr 30, 2009 6:30 PM (in response to bshopp)We have already populated IPAM with all our supernets and some subnets. If we import our Toolset IPDB will IPAM insert each subnet under the corresponding supernet? What happens if IPAM encounters a duplicate subnet on import?
-
Re: Importing IPs from ToolSet's IP Address Management
Peter.Cooper Apr 30, 2009 7:45 PM (in response to rgward)rgward,
That's an excellent point you bring up. I'm glad you asked.
The import tool was meant to help initialize the install. It will seek out an existing subnet of the same address space and overwrite its contents. I wouldn't recommend you run it since all your subnets have been added... leading to a potential reversion of changes.
New subnets are added under "IP Networks"... the top level group.
-
Re: Importing IPs from ToolSet's IP Address Management
rgward Apr 30, 2009 8:18 PM (in response to Peter.Cooper)Thanks Peter for your quick reply! Okay, this will work for us, I think. We're not doing any polling of subnet address spaces yet. So, with the Toolset subnets imported at the top level, we should be able to drag and drop them into the proper supernet.
-
Re: Importing IPs from ToolSet's IP Address Management
BakerD May 1, 2009 9:39 AM (in response to rgward)I am not sure if this step was suppose to be verbatim but didn't work for me:
5. Enter NET STOP SolarWinds IPAM Information Service.
I used: net stop swipaminformationservice
After figuring that out, the import failed for me so I will be contacting support on it.
-
Re: Importing IPs from ToolSet's IP Address Management
bshoppMay 1, 2009 9:53 AM (in response to BakerD)
Can you post the error you are getting?
-
Re: Importing IPs from ToolSet's IP Address Management
BakerD May 1, 2009 10:10 AM (in response to bshopp)
Can you post the error you are getting?
Sure, it was:
Unhandled Exception: System.OverflowException: Failed to convert parameter value from a UInt64 to a Int64. ---> System.OverflowException: Value was either too large or too small for an Int64.
I just got off the phone with tech support and they had a hotfix for it and the import worked great afterwards.
-
Re: Importing IPs from ToolSet's IP Address Management
sean.boston May 1, 2009 11:38 AM (in response to BakerD)Here is the error I'm getting.....
Can someone post the hotfix?
E:\Orion\IPAM>solarwinds.ipam.init.exe -import DiaglabsIPMan.ipdb
Unhandled Exception: System.OverflowException: Failed to convert parameter value
from a UInt64 to a Int64. ---> System.OverflowException: Value was either too l
arge or too small for an Int64.
at System.Convert.ToInt64(UInt64 value)
at System.UInt64.System.IConvertible.ToInt64(IFormatProvider provider)
at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvid
er provider)
at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType dest
inationType)
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType dest
inationType)
at System.Data.SqlClient.SqlParameter.GetCoercedValue()
at System.Data.SqlClient.SqlParameter.Validate(Int32 index, Boolean isCommand
Proc)
at System.Data.SqlClient.SqlCommand.BuildParamList(TdsParser parser, SqlParam
eterCollection parameters)
at System.Data.SqlClient.SqlCommand.BuildExecuteSql(CommandBehavior behavior,
String commandText, SqlParameterCollection parameters, _SqlRPC& rpc)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBe
havior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehav
ior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult
result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehav
ior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, S
tring method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at SolarWinds.IPAM.Storage.DAL.IPNodeDAL._ListOfNonExistentIpOrdinal(Int32 su
bnetId, String rangestring)
at SolarWinds.IPAM.Storage.DAL.IPNodeDAL.EnsureOrdinals(Int32 subnetId, Strin
g rangestring)
at SolarWinds.IPAM.Import.ImportHelper.FinalizeSubnetImport(SubnetInfo parent
)
at SolarWinds.IPAM.Import.ImportHelper.ImportToolsetSubnetsDatabase(String fi
lepath, ImportMode mode, List`1 results)
at IPAM.Init.Program.Import()
at IPAM.Init.Program.Main(String[] args)
E:\Orion\IPAM>-
Re: Importing IPs from ToolSet's IP Address Management
BakerD May 1, 2009 1:35 PM (in response to sean.boston)
Here is the error I'm getting.....
Can someone post the hotfix?
I was provided a secure authenticated link via email, so I think it would be best to contact support for the hotfix. Also they can verify if it is right for your setup. If they wanted it public, they would have provided it or maybe they will after further testing.
-
Re: Importing IPs from ToolSet's IP Address Management
Peter.Cooper May 7, 2009 9:54 AM (in response to BakerD)Just closing the loop on this issue.
We did investigate and constructed a private update for this issue. If your import throws an exception (fails with a verbose error), please contact our technical support for assistance. Thanks!-
Re: Importing IPs from ToolSet's IP Address Management
Peter.Cooper Dec 14, 2009 4:20 PM (in response to Peter.Cooper)This is just a reminder that, thanks to the community, IPAM v1.5 included a fix based on what we found investigating this thread. The "private update" I mentioned above is integrated into IPAM v1.5.
If you do experience a similar issue, I still ask you to contact our technical support and open a case.
-
-
-
-
-
-
-
-
Re: Importing IPs from ToolSet's IP Address Management
michael248363 Dec 15, 2009 11:50 AM (in response to Peter.Cooper)Is there a way to also import the description of the subnet? I'm going from a spreadsheet and importing that into the toolset database file using Access and then importing that into IPAM. Can I modify the Toolset .ipdb file in Access and add a column or have it in my original spreadsheet that will allow this information to be added as well? I've tried adding a column named Description with the information, but that didn't import the information. Is there a different name that column should be called?
Thanks,
Michael D. Jones
JetBlue Airways
-
Re: Importing IPs from ToolSet's IP Address Management
bshoppDec 15, 2009 5:08 PM (in response to michael248363)
Michael, just so you don't think we are ignoring you We are looking into this, I don't believe there is an easy way to do this today, but double checking.
-
Re: Importing IPs from ToolSet's IP Address Management
michael248363 Dec 16, 2009 11:50 PM (in response to bshopp)Thanks Brandon.
I've got my subnets imported now, so my follow-up question is:
Is there a way, preferably and easy one, to import just the subnet descriptions without overwriting the existing subnet information. I'm especially interested in not pulling all of the subnets out of the containers/folders that I spent 18 hours moving them into. . .one subnet at a time.
-
-
-
-
-
-