Search 85,904 posts and 653 resources contributed by 43,522 members or post a topic.

Already Joined? Sign in
IPAM Import

Page 1 of 1 (7 items) | RSS

rated by 0 users
Not Answered This post has 0 verified answers | 6 Replies | 4 Followers | 408 Views


52 Posts
Points 182
SolarWinds Certified Professional
mattjenkins posted on Mon, Jun 29 2009 10:10 AM
rated by 0 users

Hi all,

Im due to install IPAM with a Solarwinds partner (it was free so why not) in the next couple of weeks but wondered if anyone could provide an import 'template' so i can do pre-install work... I read the admin guide and it specifys the fields but no indication of file format etc...

Hope someone could post one.

Cheers
Matt

Matt Jenkins

--------------------------------------------------------------------------
Orion v9.5.1 SLX
NTA v3.6 NLX
IPAM v1.6 IPX
MS SQL2005 SP2

  • | Post Points: 3

All Replies


1,000 Posts
Points 5,477
SolarWinds Certified Professional
Yann replied on Mon, Jun 29 2009 10:30 AM
rated by 0 users

Hi,

mattjenkins:
I read the admin guide and it specifys the fields but no indication of file format etc...


CSV, TXT and XLS formats are supported file type for the import.

 

HTH,

Yann

  • | Post Points: 3

52 Posts
Points 182
SolarWinds Certified Professional
mattjenkins replied on Mon, Jun 29 2009 10:37 AM
rated by 0 users

Thanks. Does the file have to reference all the fields? and do they need to be in a specific order?

Cheers
Matt

Matt Jenkins

--------------------------------------------------------------------------
Orion v9.5.1 SLX
NTA v3.6 NLX
IPAM v1.6 IPX
MS SQL2005 SP2

  • | Post Points: 3

2,318 Posts
Points 7,773
Moderator
SolarWinds Employee
Mark Wiggans replied on Mon, Jun 29 2009 10:56 AM
rated by 0 users

If you are importing from an Excel file, the first worksheet will be used. You can then select which columns to ignore.

Mark Wiggans Information Development-

  • | Post Points: 1

2,318 Posts
Points 7,773
Moderator
SolarWinds Employee

12 Posts
Points 34
Horch replied on Sat, Aug 8 2009 4:31 AM
rated by 0 users

Thanks Mark.

Is there an example somewhere of an "ideal" excel spreadsheet format/layout to use?  If I could see what SW/IPAM is "looking" for, I could then adjust, remake or customize our current spreadsheet(s) and tabs to prepare them for import.  This would be huge for me.  TIA, -H

  • | Post Points: 3

2,318 Posts
Points 7,773
Moderator
SolarWinds Employee
Mark Wiggans replied on Mon, Aug 10 2009 11:24 AM
rated by 0 users

There are three required fields: 1) IP Address, 2) Status, 3) Type.
 
IP Address
 
Values: IPv4 Addresses
 
Status
 
Values: "Reserved", "Available", "Used" "Transient".
 
Note: When status is available, no other values (other than IP Address & Type) will allowed to be set.
 
Type
 
Values: "Static", "Static - User Managed", "Dynamic"
 
Note: If we are adding values for IPs that IPAM cannot communicate with, set the Type to "Static - User Managed". The scanner will not update this row, only users / import.

Mark Wiggans Information Development-

  • | Post Points: 1
Page 1 of 1 (7 items) | RSS

© 2003 - 2010 SolarWinds, Inc. All Rights Reserved.

Who is SolarWinds?

SolarWinds is rewriting the rules for how companies manage their networks. Guided by a global community of network engineers, SolarWinds develops simple and powerful network management software and network monitoring software for networks of all sizes. SolarWinds also offers a network certification program to become a SolarWinds Certified Professional (SCP).

What is thwack?

thwack, SolarWinds online community site, was designed by network engineers, for network engineers. thwack is a vibrant, growing community of more than 30,000 IT pros who share a passion for technology.

Explore Resources, Answers, Templates, and Advice

Download Free Networking Tools

Learn More About SolarWinds Products