In this article
Bulk import Sites by importing a CSV file requires 2 steps.
- Prepare the file
- 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
- Select Policies
- Select a policy
- 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
- Select Policies > Block Pages
- Select a block page
- 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
- Select Deployments > Sites
- Select Import CSV button
- Choose the prepared file
- 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.
Comments
0 comments
Please sign in to leave a comment.