Create .csv or .tsv files for importing elements

You can create .csv (comma-separated value) files or .tsv (tab-separated value) files for importing elements.

In a .csv file, commas separate all values. In a .tsv file, a tab character separates all values.

For more details about the product and how to configure features, click Help or press F1.

Steps

  1. Create a new .csv or .tsv file. (For example, you can use a spreadsheet application.)
  2. In the first row of the file, specify the header as follows:
    • .csv files — Enter ip,name,comment.
    • .tsv files — Enter ip<tab>name<tab>comment.
    For example:
    • .csv:
      • 10.10.10.10,host-10.10.10.10,Host abc
      • 10.20.30.10/24,net-10.20.30.40,Net xyz
    • .tsv:
      • 10.10.10.10<tab>host-10.10.10.10<tab>Host abc
      • 10.20.30.10/24<tab>net-10.20.30.40<tab>Net xyz
    Note: Only the IP address is mandatory in the header row. All data entered in the file must follow the format of the header row.
  3. Enter the IP address of the element and optionally a name and a comment on the row below the header. Use the same format as in the header.
    Note: Only the IP address is mandatory. If you have other parameters in the header row, enter a separator (a comma or tab) even if you do not enter a name or comment in the row.

    Example: If the header row is ip,name,comment and you want to omit the name and the comment in the .csv file, enter 10.1.1.1,,.

    Example: If the header row is ip<tab>name<tab>comment and you want to omit the name and the comment in the .tsv file, enter 10.1.1.1<tab><tab>.

    If you omit the name, the SMC automatically generates a name for the element based on its IP address. The SMC detects the element type based on the syntax of the IP address as follows:
    • 10.10.10.10 — Specifies a Host element.
    • 10.10.10.0/24 — Specifies a Network element.
    • 10.10.10.10–20.20.20.20 — Specifies an Address Range element.
  4. (Optional) For each element, add another row to the file.
  5. Save the file.