Running the Bulk Insert utility
Follow these steps to run the Bulk Insert utility:
- Configure Venafi Trust Protection Platform (TPP) and create the template and data file as described in Configuring-the-Bulk-Insert-utility.
- Open a PowerShell window.
Run the following script in the command line, modifying the path to BulkInsert.exe according to its location in your environment:
& "C:\Program Files\Venafi\Utilities\ECVenafi SPExxxx\BulkInsert.exe" tppAPIHostName userName password templateFileName dataFileName
Variable
Description
tppAPIHostName
Name of the server hosting the TPP REST API
Use only the host name. Don't include https:// or /vedsdk.
userName
Name of the user with permissions to access the API integration
Enter the name of the user account that you created in the TPP configuration section of "Configuring the Bulk Insert utility."
password
Password for the user name
Enter the password for the user account that you created in the TPP configuration section of "Configuring the Bulk Insert utility."
templateFileName
Name of the JSON template file that you created in Configuring-the-Bulk-Insert-utility
dataFileName
Name of the CSV or TSV data file that you created in Configuring-the-Bulk-Insert-utility
When you run the utility, it performs the following actions:
- Loads the template and data files.
- Verifies that the macro tags and definitions are correct.
- Processes each line of the data file, and creates a certificate object and associated application object with the specified values.
- Prints the values of each macro tag and the status response from TPP for each object created to the terminal.
If any errors occur (for example, if an object already exists) the utility prints out the error and stops processing.
TPP automatically processes each pair of objects as they are created.