14. Importing data

Data can be imported by the admin user via TAB delimited text files or from output generated in XML format by NMAP.

14.1. TAB delimited data

Network definitions or individual ip records can be imported in TAB delimited format.

The order of columns for network definitions or subnet descriptions are (three columns required): The first column contains the IP base address, the second the description and the third the mask either in dotted decimal format or in bit format.

The order of columns for importing IP records should be (six columns required): The first column contains the IP address, the second the user, the third the location, the fourth the description, the fifth the hostname and the sixth the telephone number.

If you have more than six columns, the remaining columns will be entered into the user defined fields specified in the template. The order will be the order the fields are defined in the XML template file.


See the templates section for details on how the templates work.

14.2. Importing using NMAP

A typical application for this would be to obtain data for networks that there are no records for. NMAP would be used to obtain the host info of all the addresses that are active on the network. Once this is done, the data can be read into IPplan. The NMAP parameters required by IPplan to generate a valid import file are:

 -sP -oX output.xml

To speed up the process, you can add -n to not resolve host names. The import process also understands the -O operating system detection parameter. To use -O, you will need to drop the -sP parameter. Using -O increases scanning time significantly.

As of version 3.93 of nmap, the -sP option also returns the MAC address which will be recorded in the MAC address field of the subnet IP record. MAC addresses only appear if the scan was done using root user - thus the MAC address will not appear if nmap was executed through php and the webserver. You can set the S bit on the nmap binary, but this is not advised due to security concerns.