...
Create a data file if you do not already have one, as described in Creating a Data File for Import.
Configure import options. For information, see Configuring Import Options.
When you submit multiple CSV imports, the appliance puts the import jobs in queue and executes them one at a time in the order they are submitted. When a job is being executed, it is in the Import in progress state. When a job is in queue for execution, it is in the Import pending state. You can import multiple CSV files at a time, but at any given time you can execute only one single task. Note that only one task at a time will be in the Import in progress state, while the others are in the Import pending state. You can view the status of each import job through CSV Job Manager. To access CSV Job Manager, from the Data Visualization tab, click CSV Job Manager from the Toolbar and select Jobs Manager, click CSV Import in the IPAM Task Pack.
You can do the following in CSV Import. See Configuring Import Options for details.
...
You can import multiple CSV files at a time, but at any given time you can execute only one single task. The import tasks are queued. Note that only one task at a time will be in the Import in progress state, while the others are in the Import pending state.
Do not use UTF-8 characters in the CSV file name.
When you perform a CSV import that includes objects that have scheduled changes or updates associated with them, the import fails.
When you stop an import, the appliance completes the import of the data row it is currently processing before it stops the import. You cannot resume the import from where it stopped.
You cannot roll back to previous data.
Only editable data can be imported.
When you promote a new Grid Master during an import, the import stops; and it does not restart on the new Grid Master. When a failover occurs during an import, the import stops on the old active node, and it does not restart on the new active node.
When a CSV import starts, the appliance validates the first 100,000 rows of data in the CSV file. If the file contains more than 100,000 rows of data, the appliance validates the rest of the data as the import progresses.
The appliance supports up to one million rows of data in each CSV import.
Use the delete function to delete import jobs that are uploaded. You can delete the content of a CSV file that you have imported to the database. Note that you cannot delete jobs that are already imported.
If you upload a file and preview the file using the Preview option, and later update the content of the same CSV file, and then try to view the edited file using the same Preview wizard, you may not be able to see the changes. Infoblox recommends that you start a fresh CSV import to upload the edited file and navigate to the Preview wizard to preview the file.
Configuring Import Options
You can import CSV files and perform various operations to update the data in the database. You can choose from several import options: add, override, merge, and custom. You can add new rows from the imported file to the database, overwrite existing rows in the database, append rows to the existing rows in the database, delete existing rows in the database, or replace the existing rows in the database. You can verify whether the data in the imported file is appropriate using the Test option before you import the file to the database. You can also view the results and progress details of the operation.
To import a CSV file, complete the following:
...
Add: Select this to add new rows from the imported CSV file to the database. NIOS updates the database with the new data that you have added to the imported CSV file and retains the rows that do not have any changes.
Override: Select this to overwrite the existing data in the database with the data from the uploaded file. You cannot add new rows or delete existing rows. If you want to overwrite values in the required fields, you must include the required fields and the corresponding _NEW_XXXX fields in the data file.
Merge: Select this to add values from the imported CSV file to the existing columns in the database that do not have any data. It does not overwrite the existing data, even if the data file contains new values for certain fields. If you want to overwrite values in the required fields, you must include the required fields and the corresponding _NEW_XXXX fields in the data file.
Delete: Select this to delete the rows in the imported CSV file from the database.
Custom: Select this to apply custom import actions for individual data rows in your CSV file. When preparing the CSV file for import with the Custom option, add an IMPORT-ACTION column to the file and specify a custom import action for each data row. Use the following abbreviations for import actions: 'I' (INSERT), 'M' (MERGE), 'O' (OVERRIDE), 'IM' (INSERT+MERGE), 'IO' (INSERT+OVERRIDE), 'D' (DELETE).
Note: The replace operation might affect system performance if you try to replace a zone with a lot of changes. Infoblox recommends that you perform the replace operation for large import files (more than 10,000 rows of changes) during non-peak hours. This operation ignores _new_XXX fields in the imported CSV files.
...
4. Click Next to import the CSV file.
Import Type: Displays the type of import option you have selected.
Select the CSV file that you want to import and click Choose.
On Error: Select one of the following to tell the appliance what to do when it encounters an error during an import:Stop import: Select this to stop the data import once it encounters an error in the uploaded file. Grid Manager displays the row number at which it stops the import when it encounters an error. NIOS saves the changes made to the CSV file before an error occurs. For example, if there are 100 rows of data and you select this option, and there is an error in row 90, the appliance displays 90 of 100 completed, 1 error.
Skip to the next row and continue: Select this to skip over errors and continue the data import. You can download an error report to identify the erroneous data. NIOS displays the total number of rows it has processed by skipping over. For example, if there are 100 rows of data and you select this option, the appliance displays 100 of 100 completed, 1 error.
5. Click Next to preview your CSV file. In the File Preview table, Grid Manager displays the header row, the first six rows, and up to 15 columns of the imported data. You cannot edit the data here. Field names with asterisks 
indicate required fields. Note that you must define these fields in the imported file. If any of the required fields are missing, the appliance generates an error during the import operation. You can do the following in this wizard:
Import type: The type of import option you have selected.
File name: The name of the CSV file you have selected.
Separator: Select a separator for your CSV file from the drop-down list. The default value is Comma.
On Error: The option you have selected.
6. Click Test to verify the content in your CSV file. Click Yes in the Test CSV Import for Replace Operation dialog box to verify the content or click No to cancel the operation. NIOS automatically analyzes the data in the imported file for any syntax errors or other violations. You can also view a detailed report of the file that you are importing. Note that you can run the test as a background task. This report also displays information about the number of deleted, updated and added files. It also displays error messages, if any. NIOS generates a results file listing the file name, action performed, date and time, result, and the number of failures at the end of the validation. You can view the results file only after the replace operation is complete.
...
8. You can view the progress and results of your import operation in the CSV Import Progress wizard. This wizard displays the following information:
Import type: The type of import option you have selected.
File name: The name of the CSV file you have selected.
Separator: The separator you have selected for your CSV file. The default value is Comma.
On Error: The option you have selected when the import operation encounters an error.
Current status: If an import is in progress, this field displays its current status. Otherwise, it displays the date and time of the last import.
Last action: Displays the last operation and the admin who initiated it.
Rows Completed: The number of rows of data the import has processed. Depending on the import options, Grid Manager displays either the row number at which it stops an import when it encounters an error or the total number of rows it has processed by skipping over the erroneous data. For example, if there are 100 rows of data and you select "On error: Stop importing," and there is an error in row 90, Grid Manager displays 90 of 100 here. If you select "On error: Skip to the next row and continue," Grid Manager displays 100 of 100 here and displays 1 in Rows with Errors.
Rows with Errors: The number of rows of data the import has detected errors. Click Download Errors to download the CSV file that contains the fields and the rows of erroneous data. You can use this report as a reference to update the data file before you import the file again.
To cancel the import operation, click Stop Import before the operation is complete. To close the wizard and execute the operation in the background, click Close & Run in Background. When the operation is complete, you can click Download errors to download and view the errors. The Download errors button is enabled only if the operation encounters errors. Click Save & Close to save the operation and close the wizard.
...
From the Data Visualization tab, click CSV Job Manager from the Toolbar.
In the CSV Job Manager wizard, select CSV Import and select the import job that you want to update, click the Action icon
and select Edit.
In Edit - CSV Import Job, select a type of import and perform the operations mentioned in Configuring Import Options.
Click Download to download the uploaded file, snapshot file, or the results file. For more information, see Configuring Import Options.
Click Save & Close to save the changes.
...
From the Data Visualization tab, click CSV Job Manager from the Toolbar.
In the CSV Job Manager wizard, select CSV Import and select the import job that you want to delete, click the Action icon
and select Delete or click the Delete pending job icon.
Click Yes to delete the uploaded job or No to cancel the operation in the Cancel Import Job wizard.
...
From the Data Visualization tab, click CSV Job Manager from the Toolbar.
In the CSV Job Manager wizard, do one of the following:
Select CSV Import and select the import job that you want to download, click the Action icon
and select Download.
In the CSV Job Manager wizard, select CSV Import and select the import job that you want to download, click the Action icon
and select Edit. Click the arrow beside the Download option and select one of the following:
Uploaded File: Select this to download the uploaded CSV import file.
Error File: Select this to download the error file. This option is enabled only if the import operation encountered an error.
...
From the Data Visualization tab, click CSV Job Manager from the Toolbar.
In the CSV Job Manager wizard, click CSV Export.
Select the export job that you want to update, click the Action icon
. Click Cancel to cancel the export job that is in progress. You can also click the Cancel job icon to delete the file. Click Download file to download the exported file.
Click the New CSV Export job icon to export a new job.
Click Close to exit.