Inventory-import plugin synchronizes objects from excel file with project data.
Current implementation supports import of Applications, Servers, and Connections.
Parameter | Type | Required | Description |
---|---|---|---|
File to Import (Excel) | File | Yes | Data will be imported from this file. See format and sample below |
Object Type | List | Yes | Type of object to be imported. Possible values are Server, Application, and Connection. |
Inventory Object Filter | String | No | Filter for the objects in the repository in dbmaster search format. This parameter is useful when importing from more than one source or when some objects are manually entered and some come from external data. |
Data Source | String | No | When non-empty, custom field "Source" will be set to this value |
Action | List | Yes | Allows previewing changes to be made before importing objects. Possible values:
|
Field Mapping | Text | No | Specifies mapping between columns in the source file and inventory fields. Mappings should be defined one line in format <excel-column>=<custom-field>. A column will be ignored when custom-field is empty. If there is no mapping for a column, it will be imported under the same name. |
The plugin imports data from the first sheet of excel file, others are simply ignored. First row must have column names.
For date fields the plugin recognizes these formats
For details and examples see original documentation
Connections in DBMaster have three sets of attributes: standard fields, driver parameters, and custom properties. When importing connections, the plugin will try to recognize and map excel columns with connection attributes in the same order.
Standard connection fields are:
Driver parameters are defined in the data/drivers.ini file.