Import/Export Data

    Introduction

    The Easy-IP Import function lets you import legacy IP subnet / address data from Excel spreadsheets, plain text files, or other databases. You can import XML, XLS, CSV or plain TXT format.

    The intuitive Import Wizard walks you through the entire process in minutes, checking the import file for valid data and reporting any errors.


    To import a spreadsheet:

    1. Go to Tools > Import in the toolbar.
    2. Select Microsoft Excel spreadsheet option. (xls/xlsx format)
    3. Enter the name of the file you want to import.
    4. Click Next. To import a single worksheet, select a Worksheet from the dropdown list, or select Import All Worksheets to import all the spreadsheets in the file.
    5. Select the IP Address and Subnet Mask Columns. The column names must be unique.
    6. Click Next to continue. The Column/Field screen will be displayed.
    7. Click Add Pairing to match the column names in the spreadsheet to the field names in the database. You can click Auto Add to match source and destination fields with the same name.
    8. Click Next to continue. The Advanced Options screen will be displayed.
    9. Click Next again. The Data Preview screen will be displayed.
    10. Check your import data looks OK.
    11. Click Next to continue.The Import Destination screen will be displayed.
    12. Select the folder or Network where you want the data to be imported.
    13. Click Import. The Import Progress screen shows how many Subnets and IP Addresses will be imported.
    14. Click Finish to end and return to the main Client screen.
    15. Check the Subnets and IP Addresses have been imported successfully.

    Tip
    The import file must contain a valid IPv4 or IPv6 address and subnet mask, such as: 10.0.0.0/24 or 48db:6089:8000::/64.

    To import an XML file:

    1. Go to Tools > Import in the toolbar.
    2. Select Easy-IP XML File option. (XML format)
    3. Enter the name of the file you want to import.
    4. Follow steps 4 to 15, as above

    To import a CSV file:

    1. Go to Tools > Import in the toolbar.
    2. Select Comma Separated Text File option. (csv format)
    3. Enter the name of the file you want to import.
    4. Follow steps 4 to 15, as above.

    To import an Unformatted Text file:

    1. Go to Tools > Import in the toolbar.
    2. Select Unformatted Text File option. (txt format)
    3. Enter the name of the file you want to import.
    4. Follow steps 4 to 15, as above.

    You can import Unformatted Plain Text files, as long as they contain a valid IP address and a subnet mask.

    A sample router config file for import is shown below.

    Router#show ip route
    
    Gateway of last resort is not set
    
         172.16.0.0/16 is variably subnetted, 6 subnets, 2 masks
    C       172.16.1.0/24 is directly connected, GigabitEthernet0/0
    L       172.16.1.1/32 is directly connected, GigabitEthernet0/0
    C       172.16.4.0/24 is directly connected, Serial0/1/0
    L       172.16.4.1/32 is directly connected, Serial0/1/0
    C       172.16.5.0/24 is directly connected, Serial0/1/1
    L       172.16.5.1/32 is directly connected, Serial0/1/1
    

    Export Data

    Easy-IP exports the following industry-standard file formats for easy manipulation by other applications:

    • HTML, XML
    • PDF, Rich text Format (RTF)
    • XLS, CSV, Plain text (txt)

    You can export entire subnets or just selected fields to the above file formats.


    Export to a CSV file:

    1. Select a Group Folder or Subnet in the Subnet Browser.
    2. Go to Tools > Export in the toolbar.
    3. Select Comma Separated Text File option. (csv format)
    4. Enter the name of the file you want to export.

    Note
    Only the CSV, HTML or XML formats are available from the Tools > Export command, but you can export to PDF, XLS, RTF and other formats from the Reports screen.