Import model Excel template
Learn about the fields and structure of the Excel template used to define network element models and their hierarchical relationships for bulk import.
Import model excel template overview
The import model template is a structured Excel file used to define network element models and their hierarchical relationships for bulk import into the application. Each row represents one record that is imported into the target system, and each column maps to a field in the target table.
You do not need a separate row for the model relationship. The model and its relationship to the parent component can be defined in a single row. If the model already exists in the system, the record is skipped. If it does not exist, the model is created along with the model relationship.
Model class determines the type of model being represented — Network Equipment Model, Network Holder Model, Network Card Model, or Network Interface Model. Model category must be a valid value from the model category table and determines which tables are used for inserting records and which tables are considered during equipment instantiation. The Excel template is created based on the Import model template table [sn_ni_adv_import_model_template]. An admin can customize the template and update it as required. To download the template with sample data, select Create Excel template on the Import model request form. Only Sheet 1 is considered during import. All other sheets are ignored.
| Field | Description |
|---|---|
| Entity ID | Unique identifier for each row in the template. The ID must be unique across all rows. The ID acts as a key within the spreadsheet to establish parent-child relationships using the Parent entity ID and Root entity ID fields. The ID is not mapped to any target table field.The referenced Entity ID must already exist in the Entity ID column before it can be used as a parent or root reference. |
| Model class | The type of network element the row represents. Accepted values are:- Network equipment model - Network holder model - Network card model - Facility model - Network interface model |
| Manufacturer | Name of the manufacturer or vendor of the network element. |
| Model number | Model number of the manufacturer for the component. |
| Relationship type | Relationship between the component relates and its parent. Accepted values are:- Equipment to Slot - Equipment to Network Interface - Slot to Card - Card to Slot - Card to Network Interface - Physical Connection to Logical Connection - Logical Connection to Logical Connection - Physical Connection to Network Interface - Logical Connection to Network Interface - Rack/Cabinet to Rack/Cabinet Slot - Rack/Cabinet Slot to Equipment - Rack/Cabinet Slot to Shelf - Interface to Interface - Logical Connection to Channel - Cable to Strand - Cable to Physical Connection - Multi Chassis to Equipment - Multi Chassis to Rack |
| Parent entity ID | Entity ID of the parent component. The referenced ID must already exist in the Entity ID column. This ID establishes the hierarchical position of this component within the model structure. |
| Root entity ID | Entity ID of the root component in the hierarchy. The referenced ID must already exist in the Entity ID column. |
| Count | Number of child elements of this type associated with the parent component. |
| Sequence | Order in which child elements are listed under the parent component. |
| Model category | Category of the model. The category must be a valid value from the model category table. The value determines which tables are used for inserting records and which tables are considered during equipment instantiation. |
| Owner | Owner of the model record. |
| Height \(U\) | Height of the component in rack units. This height applies to rack-mounted equipment and equipment holders. |
| CLEI code | Common Language Equipment Identifier assigned by the manufacturer to the component. |
| Slots occupied | Number of slots the component occupies in its parent holder. |
| Interface start number | Starting number used when auto-naming network interfaces associated with this component. This number links the model to a corresponding catalog item in the application. |
| Orientation | Mounting orientation of the component. The allowed values are:- Vertical - Horizontal" |
| Port bandwidth | Bandwidth capacity of a network interface port. |
| Slot naming pattern | Pattern that controls how the application automatically generates names for child slot elements associated with this component. |
| Interface naming pattern | Pattern that controls how the application automatically generates names for child interface elements associated with this component. |
| Weight | Physical weight of the component. |
| Weight unit | Unit of measurement for the Weight field, such as kg or lb. |
| Rated power | Power consumption rating of the component. |
| Power unit | Unit of measurement for the Rated power field, such as W or kW. |
| Max weight capacity | Maximum weight that the component can support. This applies to racks, cabinets, and equipment holders. Allowed values are:- 2 Post - 4 Post |
| Max weight capacity unit | Unit of measurement for the Max weight capacity field. |
| Post type | Post type of the rack or cabinet holder. |
| RU naming pattern | Naming pattern that controls how the application automatically generates names for rack unit positions within the component. |
Parent Topic:Telecommunications Network Inventory reference
Related topics