Inventory Import

Inventory-import plugin synchronizes objects from excel file with project data.

Current implementation supports import of Applications, Servers, and Connections.

Parameters

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:
  • Preview - output of the plugin will contain changes to be made to the data without any changes made
  • Import - data will be imported if it does not have any errors
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.

Import File Format

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

  • MMM d, yyyy
  • MMM d,yyyy h:mm a
  • MMM d,yyyy h:mm:ss
  • EEE MMM d, yyyy h:mm a
  • EEE MMM d h:mm:ss z yyyy

For details and examples see original documentation

Importing connections

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:

  • 'Connection Name' - unique name for the connection.
  • Driver - use driver name, e.g. 'SQL Server (jTDS)' for sql server
  • User - username for the connection, when empty integrated connection is used
  • Password - password for the connection, when empty integrated connection is used
  • 'Connection URL' - java connection url should be used here.
    For jTDS driver use jdbc:jtds:sqlserver://<server-name>:1433;domain=<domain-name>;useKerberos=true/false

Driver parameters are defined in the data/drivers.ini file.

Import File Samples