18 Replies Latest reply on Dec 16, 2009 11:50 PM by michael248363

Importing IPs from ToolSet's IP Address Management

sean.boston Apr 29, 2009 3:03 PM

Hello Thwack;

Has anyone been successful in importing IP addresses from Toolset's IP address Management app into IPAM?

Regards

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
Like (0)

Actions
- 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?
  
  Like (0)
  
  Actions
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
Like (0)

Actions
- Re: Importing IPs from ToolSet's IP Address Management
  
  bshopp Apr 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
  
  Like (0)
  
  Actions
- Re: Importing IPs from ToolSet's IP Address Management
  
  bshopp Apr 30, 2009 8:57 AM (in response to tonyled)
  
  Here 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"
  1 of 1 people found this helpful
  
  Like (0)
  
  Actions
  - 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?
    
    Like (0)
    
    Actions
    - 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.
      
      Like (0)
      
      Actions
      - 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.
        
        Like (0)
        
        Actions
        
        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.
        
        Like (0)
        
        Actions
        
        Re: Importing IPs from ToolSet's IP Address Management
        
        bshopp May 1, 2009 9:53 AM (in response to BakerD)
        
        Can you post the error you are getting?
        
        Like (0)
        
        Actions
        
        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.
        
        Like (0)
        
        Actions
        
        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>
        
        Like (0)
        
        Actions
        
        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.
        
        Like (0)
        
        Actions
        
        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!
        
        Like (0)
        
        Actions
        
        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.
        
        Like (0)
        
        Actions
      - 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
        
        Like (0)
        
        Actions
        
        Re: Importing IPs from ToolSet's IP Address Management
        
        bshopp Dec 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.
        
        Like (0)
        
        Actions
        
        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.
        
        Like (0)
        
        Actions

Go to original post