Importing DNS records - User Guide - BlueCat Horizon

BlueCat Horizon User Guide
ft:locale
en-US
Product name
BlueCat Horizon

Instead of manually creating DNS records one-by-one, you can import them into DDI orchestrator in bulk. It's possible to import records into multiple zones at the same time.

To import DNS records:

  1. On the DNS page, use the Action menu in the task bar to select Import DNS records.
    Note: If you only want to import records into one zone, Open that zone and then use the Action menu to select Import DNS records.
  2. In the dialog, copy and paste or drag and drop a file into the provided field. Files can be comma-, semicolon-, tab-, or pipe-separated files.
    Note: Only plaintext CSV/TSV/TXT files are accepted for file selection. Excel spreadsheets must be converted to one of these formats before importing.

    Refer to Formatting DNS data for import below for more information about formatting the DNS record data for import.


    The Import DNS records.
  3. Select Next.

After selecting Next, DDI orchestrator validates the data and highlights any errors before the changes are applied.

Formatting DNS data for import

The DNS data you are importing should be formatted as follows:

Header line
The first line of the data must be a header line that contains the names of the fields in the subsequent columns. Some fields refer to built-in system fields, while others match the custom properties defined for the object type.
Tip: Only include fields that need to be imported/updated, except for mandatory properties or those needed to identify the object for import.

Field names in the header line are not case-sensitive. For example, “title” corresponds to the custom property “Title”.

Built-in fields
Built-in system fields include the following:
  • action: Add, Modify, or Remove. The default is Add.
    Tip: You can also use the following aliases:

    • Insert/Create = Add

    • Update/Change = Modify

    • Delete/Del = Remove

  • name (required): The hostname of the record.
  • zone: The zone containing the record.
  • authority: For multi-primary, the zone’s authority.
  • view: For multi-primary, the view containing the zone.
  • forest: For multi-primary, the forest of the zone.
  • type (required): The record’s type, such as A, CNAME, MX, etc.
  • data (required): The record’s data (IP for A/AAAA, the target A/AAAA record for CNAME, etc.).
  • TTL: The record’s Time-to-Live value. The default is in seconds, but you can also use hours (1H), days (2D), weeks (3W), months (4M), or years (5Y).
  • comment: An optional save comment.
  • newdata: When modifying an existing record, this is the new data to replace the old value.

Use the following examples as references of how to format the DNS data for adding, editing, and deleting records.

Examples

Here are a few examples of how to import, edit, and delete DNS records through the bulk import function:

Add records

Import A record ‘viola’ to the zone ‘illyria.coast’:

name,type,data
viola.illyria.coast.,A,16.0.2.2

Import A record ‘viola’ to ‘illyria’ providing a view name:

name,type,data,view
viola.illyria.,A,16.0.2.2,first-folio

Import A record ‘viola’ to ‘illyria.palace’ to the authority of ‘orsino’:

name,type,data,authority
viola.illyria.palace.,A,16.0.2.2,orsino

Import A record ‘cesario’ to ‘olivia.palace’, when zone and authority are specified:

name,type,data,authority,zone
cesario.olivia.palace.,A,16.0.2.2,illyria,orsino.palace
Edit records

Edit IP address for the A record ‘viola’:

action,name,type,data,newdata
modify,viola.illyria.coast.,A,16.0.2.2,20.21.9.6

Edit IP address for the A record ‘viola’ but leave the TTL as it was:

action,name,type,data,newdata,ttl
modify,viola.illyria.coast.,A,16.0.2.2,20.21.9.6,

Edit IP address and TTL for the A record ‘viola’:

action,name,type,data,newdata,ttl
modify,viola.illyria.coast.,A,16.0.2.2,20.21.9.6,2H
Delete records

Delete A record ‘malvolio’:

action,name,type,data
remove,malvolio.olivia.palace.,A,16.0.2.2