Importing Data

You can import DNS, DHCP, and IPAM data from a JSON or CSV file. For more information on the types of objects supported, and the import/export process, see Importing and Exporting Data. See Supported Formats for the file format. For information on the mandatory and optional fields, see Import Parameters.

To view the imported objects, go to Administration -> Data Import/Export. The following information is shown:

• Filename: Name of the imported file
• Created by: User account importing the file.
• Start time: Start time of the import. 
• End time: End time of the import.
• Object Type: Number and type of objects in the imported data.
• Status: Status of the import process whether it is in progress, completed, or failed.
• Error: If the import operation failed, the error log is shown with the reason for the failure is updated in the document

You can do the following in this tab:

• Sort By: Click to sort by Created by, Description, Name, Start time or Status. 
• Click   to sort in ascending or descending order.
• Enter the keyword in the Search field to search for a particular entry. 
• Click  to filter by Name, Description, Created By, Start time or Status. 

Complete the following steps to import data:

1. Go to Admin -> Data Import/Export -> Data Import.
2. Click Import. 
3. Specify the following information in the General Info tab:
   • Name: Specify a name for the imported configuration. 
   • Description: Specify a description.
   • Tags: Click Add to associate keys with the view and specify the following details:
     
     • KEY: Enter a meaningful name for the key, such as a location or a department.  
     • VALUE: Enter a value for the key such as San Jose or Accounts. To remove a tag, select the respective checkbox and click Remove to delete the associated tag. For information about tags, see /wiki/spaces/ddiadminguidensdraft/pages/11014132.
4. Click Next.
5. Select the JSON or CSV file. Edit the file as per the instructions in Import Parameters before import. 

   • Click Select File. Browse to select the file and click OK. 

     Note

     Before importing the JSON file, you can add entries for all objects and services except on-prem hosts. You can also modify the values for Name, Description, and Tags for all objects. You cannot add or delete on-prem hosts, but you can modify the values for Name, Description, and Tags for on-prem hosts.

6. Choose the objects to be imported in the Verify objects tab. If you do not wish to import certain objects, clear the respective checkboxes. For example, you can choose the objects in the following categories:
   • IPAM/DHCP: Choose the IPAM/DHCP objects to be imported. 
   • DNS: Choose the DNS objects to be imported. 
   • ON-PREM HOSTS: Choose the on-prem hosts to be imported. 
7. Click Next. 
8. Choose the type of import. Choose one of the following options:
   • Add new records from the imported file
   • Add new records and update existing records
   • Add new records, update existing records and delete all records not in the imported file
   • Add new records and delete all records not in the imported file
   • Update existing records and delete all records not in the imorted file

   • Delete all records not in the imported file

     Warning

     Use the Delete all records not in the imported file option with caution. If you use this option, it could result in the deletion of a large number of objects from the Cloud Services Portal which would then have to be recovered from the /wiki/spaces/ddiadminguidensdraft/pages/11012252. 

   • Delete all records in the imported file

     Note

      You cannot add or delete on-prem hosts, but you can update the values for Name, Description, and Tags for on-prem hosts. Adding or deleting of  On-Prem Hostconfig object is not supported. 

9. Click Next. 
10. Specify the error handling. Choose one of the following options:
    • Skip failed records (continue import)
    • Stop import if any record fails
11. Click Next and verify the summary. 
12. Click Start Import.