<div id="google_translate_element"></div> <script type="text/javascript"> function googleTranslateElementInit() { new google.translate.TranslateElement({pageLanguage: 'en'}, 'google_translate_element'); } </script> <script type="text/javascript" src="//translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script> |
The IPPlan Importer is a command-line tool to import IPs from an IPPlan database into ProVision. This tool can be used via two approaches: generating .csv files via the tool only, then using the ProVision IP Import UI to import the csv files (Connector), or as a full command-line import solution, bypassing the ProVision UI entirely (Importer).
Options:
1) Generate .csv files to use with the IP Import - Upload/Import from CSV tool through the ProVision UI.
2) Import IPs directly into ProVision without accessing the UI.
You will need:
Accessing the Tool and Showing Help Instructions:
The tool is located in tools/ipplan_import.php. A help document is provided listing example commands and detailed situation-specific options.
To execute it, you must preface it with "php" program. From from your instance's root folder, the command would be:
"php tools/ipplan_import.php --help"
If you are in the tools folder, the command would be:
"php ipplan_import.php --help"
This will bring up the help / instruction document. It is also provided below.
|
This method creates .csv files that you can use with the IP Import - Upload/Import from CSV tool through the ProVision UI.
Note that you must import ipplan_aggregates first. into IP Import - Upload/Import from CSV to create the aggregates ipplan_hosts.csv will use. Then, import ipplan_hosts.csv as described in IP Import - Upload/Import from CSV. |
This method has the tool process the import task. Using this case, you must set the RIR in the command line for all of the IP's.
"php ipplan_import.php ../ipplanv6.sql --rir=1918"
(where '../ipplanv6.sql' is the path to your SQL file)
This will load your IPPlan database file into your mysql server and then import the hosts into ProVision. They will each be given the RIR you specified, as well as this text in the Notes field: 'IPPlan import'
The import may need to run for a number of minutes, depending on the size of your data. For reference, an import of 2100 hosts inside of 150 aggregates took approximately 10 minutes to complete during our testing.
Additional run options for various combination of conditions are detailed below. The command is the text within the quotes only.
You can load the SQL file, but NOT run an import, with the --only-sql option (feel free to include --no-overwrite option as well in case you don't want to overwrite a prior loaded SQL file):
"ipplan_import.php ../ipplanv6.sql --only-sql"
"ipplan_import.php ../ipplanv6.sql --only-sql --no-overwrite"
If you have already loaded the sql file previously, you can generate CSV files without having to load the SQL file:
"ipplan_import.php --only-import --csv"
If you want to just generate CSV files without re-loading the database file, you can as well:
"ipplan_import.php ../ipplanv6.sql --no-overwrite --csv"
You can also generate csv files with the rir option:
"ipplan_import.php ../ipplanv6.sql --no-overwrite --csv --rir=1918"
If you have already loaded your IPPlan database with the tool before, you can do --only-import:
"php ipplan_import.php --rir=1918 --only-import"
If you are not sure whether you have already loaded your IPPlan database with the tool before, you can specify --no-overwrite to NOT load the sql file if it was loaded already, or do load if it wasn't:
"ipplan_import.php ../ipplanv6.sql --rir=1918 --no-overwrite"