Bulk Import Sites

Article author
Chris Todd
  • Updated

Bulk import Sites by importing a CSV file requires 2 steps.

  1. Prepare the file
  2. Import the prepared file

Prepare the file

Create either a comma separated or a semi-colon separated file for import. Download a sample CSV file or create your own. The file should include the following values in each row.

Site Name (required) Site Address (recommended) Policy ID (required) Block Page ID (optional) External ID (optional) IP or Hostname (required)
  • Site Name (required). Name of your choice. Duplicates are accepted though they will each be their own site.
  • Site Address (recommended). An address or latitude and longitude, e.g. 38.889484,-77.035278 are accepted.
    Be sure to click the Latitude & Longitude button when viewing the address after import.
  • Policy ID (required). This is the id of the policy that will be applied to the Site.
    See below for instructions on locating a Policy ID.
  • Block Page ID (optional). This is the id of the block page that will be applied to the Site. If excluded, the default block page will be used.
    See below for instructions on locating a Block Page ID.
  • External ID (optional). The purpose of this identifier is to enable integrate with external services, such as Zapier.
  • IP Address or Hostname (required). Use comma separation when more than one value is provided.

CSV File Notes

  • Do not include column headers in the CSV file
  • Do not mix comma separated and semi-colon separated rows in the same file
  • CIDR range IPs are supported
  • 100 networks maximum per CSV file
  • Quotes are required for fields that contain commas (Address and IP Address / Hostname)
    • When exporting from a spreadsheet, the quotes should be added automatically
    • See below for examples

Find a Policy ID

  1. Select Policies
  2. Select a policy
  3. View the URL. The Policy ID for the policy is the number between "/filtering/" and "/edit"
    /organizations/987654/policies/filtering/123456/edit/name

Find a Block Page ID

  1. Select Policies > Block Pages
  2. Select a block page
  3. View the URL. The Block Page ID for the block page is the number between "/block-pages/" and "/edit/"
    /organizations/987654/policies/block-pages/12345/edit/details

CSV Examples

Comma separated with no Block Page defined

Import 1,"6650 Niagara Pkwy, Niagara Falls, Ontario, Canada",123456,,My External ID,191.172.100.0/30

Comma separated with no address, no external id, and multiple ip addresses

Import 2,,123456,12345,,"191.169.100.0/30,191.170.100.0/30,191.171.100.1"

Semi-colon separated with latitude and longitude (instead of an address) and no Block Page defined

Import 3;"38.889484,-77.035278";123456;;My External ID;191.168.100.0/30

Once the CSV file is ready, it's time to import the file.

Import the file

  1. Select Deployments > Sites
  2. Select Import CSV button
  3. Choose the prepared file
  4. Read the Bulk Operations in Progress dialog, and then select DISMISS

When completed, a green notification box will appear for a short time and the new sites will be added to the Deployment > Sites page.

ExamplesImported.png

 

Was this article helpful?

2 out of 2 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.