...
Prior to importing your data, there is a key step of Data Normalization to ensure that information is accurate. If you need assistance with parsing your data prior to importing, 6connect can help with our Data Analyst service. Email us at support@6connect.com for more information.
You can also use off the shelf tools like Microsoft Excel, MySQL, or Google Refine if you intend to take on the task of data cleanup in house.
Common normalization steps required for ProVision imports include:
- Remove any empty rows in the data range
- Remove any empty columns in the data range
- Remove stray data from inside and outside the data range, such as:
- notes, comments, and placeholder text as field values, when not set as their own data column
- nested secondary information located in additional rows under a primary record
- Ensure proper data formatting
- Check for data formatting errors - a common issue is leading zeros being dropped from a ZIP field when a file is opened. Re-specify format as needed.
- Ensure each field has consistent formatting for values
Ensure unique values for primary identifiers, such as Resource Name and ID Fields
Note title Data Encoding Format To ensure correct importing of any special characters, make sure to use UTF-8 encoding for your CSV file!
Step 2: Prep your Data
You can download data import templates from the Dashboard Tab or Data Import Tab. We recommend that you open the CSV import templates and get familiar with the data fields that you can import into the platform.
- For Company information you can import relevant data including mailing/billing address information as well as ARIN specific SWIP fields, and specific DNS servers.
- For Contact information you can import contact records assigned to a given Company. We support typical fields for this data including Name, multiple email fields, phone numbers as well as Timezone and Role (Roles can be customized from the IPAM Admin Tab).
- For IPv4 IP Block information you can import the following fields:
| Expand |
|---|
 |
| Info | ||
|---|---|---|
| ||
When importing the field "Allow Subassignments" - the parameters accepted are "TRUE", "1", "Y", "yes" |
...
Get to the Data Import Tab from the Admin button to import your data. For larger data import runs, feel free to contact 6connect at any time for assistance at support@6connect.com.
Data Import Overview: Which Import Tool Should I Use?
...
This tool supports the following fields:
| Expand |
|---|
For Resource Import from .csv, the following fields are REQUIRED:
All other fields are optional. |
Resource Import Tool: The Resource Import tool is designed for importing .csv files for any Resource type (company, physical devices, contacts, customers, etc), and allows for customized headers through integrating ProVision's Section fields. It also allows for data editing within the tool. Use the Resource Import Tool if you have resource data that does not fit under the Simple Upload / Import from CSV field options, and can equate that data to an existing or newly created Section.
...
Import BGP Sessions: This section imports peering sessions from a selected exchange and router. Routers must be created prior to using this importer. See Adding Peering Routers and Importing Sessions for additional information.
...
Upload / Import from CSV: Use this tool if you have a .csv file of IP block information, such as CIDR, Mask, ASN, RIR, etc.
This tool supports the following fields:
| Expand |
|---|
For IP Import from .csv, the following fields are REQUIRED:
All other fields are optional. |
Import from RIR: This tool automatically lookups your ARIN or RIPE information based on the IP address you are connected to. Once it identifies the blocks assigned to your company, you can import both 1918 aggregates as well as public IP space from ARIN and RIPE. See Import Aggregate Blocks for more detail on this tool.
...
DNSMadeEasy Zone Import: Imports DNS zones using a DNSMadeEasy API Key and API Secret. It is advised to create a DNS Group prior to the import with default parameters and NS records to be inherited by the imported records.
IPPlan Zone Import: Imports DNS zones using IPPlan MySQL database options. It is advised to create a DNS Group prior to the import with default parameters and NS records to be inherited by the imported records.
Additional Information
For more details, see:
...