|
<< Click to Display Table of Contents >> Import Circuit Data |
  
|
|
<< Click to Display Table of Contents >> Import Circuit Data |
|
Menu: Database > Circuits
Default command line shortcut: cmscg
Related Project Settings:
Circuit Status Items
Product Level: ENT
Click Tools > Import Circuits.
Command:
Open the Circuits Grid. Then click: File>Create Import Template.
Open the Circuits Grid. Then click: File>Import Circuits.
Limitations
Simplex, duplex or n-strand/core count can be imported. You are limited to 82 rows of circuit data. If you are importing more than 82 rows start another file.
The import template will only accommodate circuits with a maximum of 6 backbones/risers, or in other words a simplex/duplex/n-plex circuit with a maximum of 8 jumpers.
Prerequisites
You must have created backbone data in order to establish circuits.
Related Topics
You will need to have entered or imported backbone data in order to create circuits.
This is a multi-step process.
Create the import template:
Open the Circuits Grid. Then click: File>Create Import Template.
This will export the data from your project to the import template. This makes the use of drop downs with project-specific data possible. Without this you will likely get errors if you were to just type the data manually into the import template.
c:\users\public\documents\WireCAD\WireCAD9\Import Templates\SomeImportTemplateNameWithADateCode.xlsx
NOTE: Be sure to use the most current import template.
Open the import template in MSExcel and enter your data into the Circuit Import Template created in Step 1 above.
Be sure to fill in all fields.
NOTE: If you leave the Circuit Number field blank one will be assigned on import.
A circuit in its simplest form will consist of source and destination equipment with at least one backbone and two jumpers:
The following is a n-plex simple circuit:
This import would require 4 rows in the import template. One row for each horizontal strand/core.
When completing the import template you will need to type the source and destination equipment manufacturers/name and port info.
You will then need to select the first jumper action. The jumper will either jumper to the next backbone or to the final destination.
You will then select the first panel into which we will apply a jumper and the port we will use.
NOTE: The ports displayed in the drop downs are available ports. If you are trying to use a port that is not listed check to see why that port is not listed.
Port and System ID fields are strictly validated. You cannot enter field data in the generated template that is not allowed.
Once you have the first row of the circuit defined you will need to select the Final Action in Column BN. Your choices are:
•CKT CONTINUES ON NEXT LINE
•CKT COMPLETE. NEW CKT NEXT LINE
•CKT COMPLETE. END OF FILE
There can only be one and only one CKT COMPLETE. END OF FILE row in the template.
Once you have entered all of your data. Save the file and proceed to the next step.
Import your data using the Import Circuits tool.
The Import Circuits tool performs several data integrity checks before the data is actually imported:
•Is the import template the proper format.
•Is all of the necessary data in place.
Then the data is validated against existing data in a preflight check.
•Do the backbones exist.
•Are the ports already assigned to another circuit.
•Is the circuit number available.
