Physical infrastructure information can be imported via CSV import. The general requirements for the CSV file are listed below.
- The character ; (semicolon) is used as a separator.
- A heading is always expected in the first line. This row will not be considered during the import.
- The names of the columns are not relevant.
- Docusnap assigns the names of the entries to the dependent objects to import the CSV data. ID's cannot be used.
- If data records to be imported are not complete or cannot be assigned, they are imported in the Import dialog and can be manually adjusted there.
- If data records already exist, duplicates are created.
- The order of the columns must be observed. This is specified in the individual points.
Sites
Site name
- Site Type
- Parent Site (empty if at the top of the hierarchy)
![Docusnap-Physical-Infrastructure-Site-CSV](./images/docusnap-physical-infrastructure-site-csv.png)
![Docusnap-Physical-Infrastructure-Site-CSV-Import](./images/docusnap-physical-infrastructure-site-csv-import.png)
Site Elements
- Site Element Name
- Site
- Site Element Type
Racks
Rack Elements
- Rack Element Name
- Rack Name
- Rack Element Type
- Orientation (front or back) (front = 1 or True, back = 0 or False)
Cable Connections
To be able to import several ports per cable connection, one line must be used per plug. Thus two lines are required for the cabling of a network socket port with a patch panel port.
Based on the name of the connection, an assignment of start port and destination port is implemented. The number is required if a port has several connection options, e.g. TERA wiring.
Entries that could not be inserted correctly are marked with a red X and have to be adjusted manually. With click on the OK button all connections are inserted.
- Connection Name (related ports are specified by the connection name)
- Cable Type
- Cable Color (specified by RGB value 255-255-255) (If the field is blank, the default color of the cable is used)
- Element (element to be wired)
- Port (port to be wired)
- Front (Front or Back) (Front = 1 or True, Rear = 0 or False)
- Number (Relevant for cabling with multiple connections. Specifies the position of the connection at the plug. If the plug has only one port, a "1" is always entered)
- Destination (specify at which end of the wiring this port is) (Start = 0 and End = 1) Relevant if there are several plugs on one side of the connection, e.g. TERA cabling
![Docusnap-Physical-Infrastructure-Cable-CSV](./images/docusnap-physical-infrastructure-cable-csv.png)
![Docusnap-Physical-Infrastructure-Cable-Import](./images/docusnap-physical-infrastructure-cable-import.png)
Cable Connections Export
With the help of the Export Plugs function it is possible to export a finished CSV file with the cabling of the system. The Export function is available for all elements where connections can be documented.
![Docusnap-Physical-Infrastructure-Cable-Export](./images/docusnap-physical-infrastructure-cable-export.png)
The existing connections can be deleted during export. This way the connections can be edited in the exported CSV file and then imported again.
![Docusnap-Physical-Infrastructure-Cable-Export-Dialog](./images/docusnap-physical-infrastructure-cable-export-dialog.png)
![Docusnap-convention-Warning](./images/hmfile_hash_5b9c1c5d.png)
|
If the checkbox is activated, these connections are deleted from the database. If the CSV file is subsequently lost, the connections must be created again.
|
The exported CSV file can then be imported as usual using the Import Cable Connections button.