Assets / Assets / IT Asset Manager
Assets / Enterprise Assets / IT Asset Manager
Assets / Telecom Assets / Telecom Management
Migrating Archibus Client/Server Telecom Assets: Field Reference
The routine to migrate Archibus Windows Client/Server Telecom data for use in Web Central converts the following tables.
Note that the routine does not migrate all Client/Server fields; the fields that are not migrated are noted below. Web Central Telecom features do not require the fields that are not migrated.
See also:
- Migrating Telecom Data Developed in Client/Server to Web Central (Overview)
- Migrating Data
- Migrating Floor Plan Drawings
Network Devices (netdev) to Equipment (eq)
| Source Table and Field | Target Table and Field | Notes |
|---|---|---|
| netdev bl_id | eq bl_id | |
| netdev cross_connect_level | not migrated | |
| netdev description | eq description | |
| netdev detail_dwg | not migrated | |
| netdev dwgname | eq dwgname | XDATA is not adjusted |
| netdev ehandle | eq ehandle | |
| netdev fl_id | eq fl_id | |
| netdev hardware_address | eq hardware_address | |
| netdev is_multiplexing | eq is_multiplexing | |
| netdev net_address | eq net_address | |
| netdev net_address_ip | eq net_address_ip | |
| netdev net_card_type | eq net_card_type | |
| netdev net_id | eq net_id | |
| netdev net_sub_mask | eq net_sub_mask | |
| netdev netdev_id | eq eq_id | |
| netdev netdev_std | eq eq_std | |
| netdev netdev_type | not migrated | |
| netdev num_serial | eq num_serial | |
| netdev rack_id | eq rack_id | |
| netdev rm_id | eq rm_id | |
| netdev tc_level | eq tc_level |
Network Device Standards (netdevstd) to Equipment Standards (eqstd)
| Source Table and Field | Target Table and Field |
|---|---|
| netdevstd cost_purchase | eqstd price |
| netdevstd description | eqstd description |
| netdevstd image_file | eqstd image_file |
| netdevstd is_multiplexing | eqstd is_multiplexing |
| etdevstd netdev_std | eqstd eq_std |
| netdevstd netdev_type | eqstd category |
| netdevstd symbol | eqstd symbol |
| netdevstd tc_contained_tbls | eqstd tc_contained_tbls |
| netdevstd tc_level | eqstd tc_level |
| netdevstd tc_npositions | eqstd tc_npositions |
Network Device Ports (ndports) to Equipment Ports (eqports)
| Source Table and Field | Target Table and Field |
|---|---|
| ndport description | eqport description |
| ndport hardware_address | eqport hardware_address |
| ndport net_address | eqport net_address |
| ndport netdev_id | eqport eq_id |
| ndport port_id | eqport port_id |
| ndport port_std | eqport port_std |
| ndport segment | eqport segment |
| ndport tc_level | eqport tc_level |
| ndport tc_use_status | eqport tc_use_status |
Punch Blocks (pb) to Patch Panels (pn)
| Source Table and Field | TargetTable and Field | Notes |
|---|---|---|
| pb bl_id | pn bl_id | |
| pb cross_connect_level | pn cross_connect_level | |
| pb description | pn description | |
| pb detail_dwg | pn detail_dwg | XDATA is not adjusted |
| pb dwgname | pn dwgname | |
| pb ehandle | pn ehandle | |
| pb fl_id | pn fl_id | |
| pb mount_id | not migrated | |
| pb pb_id | pn pn_id | |
| pb pb_std | pn pn_std | |
| pb rack_id | pn rack_id | |
| pb rm_id | pn rm_id | |
| pb shelf_id | pn shelf_id | |
| pb tc_level | pn tc_level | |
| pb tc_service | pn tc_service |
Punch Block Standards (pbstd) to Patch Panel Standards (pnstd)
| Source Table and Field | Target Table and Field |
|---|---|
| pbstd description | pnstd description |
| pbstd doc_image | pnstd doc_image |
| pbstd image_file | pnstd image_file |
| pbstd pb_std | pnstd pn_std |
| pbstd symbol | pnstd symbol |
| pbstd tc_contained_tbls | pnstd tc_contained_tbls |
| pbstd tc_level | pnstd tc_level |
| pbstd tc_npositions | pnstd tc_npositions |
| pbstd vn_id | pnstd vn_id |
Punch Block Contained Positions to Patch Panel Ports
There is no source table for punch block contained positions. Rather each punch block has the number of connections specified in the Number of Contained Positions field (tc_npositions) in the Punch Block Standards (pbstd) table.
The Number of Contained Positions migrates to the corresponding field with the same name in the Panel Standards (pnstd) table.
Punch Block positions are specified in the Down Position and Up Position fields of the Connections table (afm_tccn). The migration process creates a single port in the Panel Ports table for each unique position entry in the Down Position and Up Position fields for each punch block.
For each Punch Block, the workflow rule runs the following SQL query statement to generate the corresponding ports for the Panel Ports table:
INSERT INTO pnport (pn_id,port_id) SELECT DISTINCT 'PB19H',position FROM
((SELECT DISTINCT downhill_position AS position FROM afm_tccn WHERE downhill_key='PB19H') UNION (SELECT DISTINCT uphill_position AS position FROM afm_tccn
WHERE uphill_key='PB19H')) AS pnport order by position
| Source Table and Field | Target Table and Field | Notes |
|---|---|---|
| pb_id pnport | pn_id | SQL statement to process all punch block connections and create patch panel ports |
|
afm_tccn downhill_position afm_tccn uphill_position |
pnport port_id |
Cards (card) to Equipment (eq)
| Source Table and Field | Target Table and Field | Notes |
|---|---|---|
| card card_id | eq eq_id | Cards use 16 characters |
| card card_std | eq eq_std | |
| card description | eq description | |
| card eq_id | not migrated | |
| card hardware_address | eq hardware_address | |
| card is_multiplexing | eq is_multiplexing | |
| card net_address | eq net_address | |
| card net_id | eq net_id | |
| card netdev_id | not migrated | |
| card slot_id | not migrated | |
| card tc_level | eq tc_level |
Card Standards (cardstd) to Equipment Standards (eqstd)
| Source Table and Field | Target Table and Field |
|---|---|
| cardstd card_std | eqstd eq_std |
| cardstd description | eqstd description |
| cardstd is_multiplexing | eqstd is_multiplexing |
| cardstd netdev_type | eqstd category |
| pbstd symbol | pnstd symbol |
| cardstd tc_contained_tbls | eqstd tc_contained_tbls |
| cardstd tc_level | peqstd tc_level |
| cardstd tc_npositions | eqstd tc_npositions |
Card Ports (cdport ) to Equipment Ports (eqport)
| Source Table and Field | Target Table and Field | Notes |
|---|---|---|
| cdport card_id | eqport eq_id | card_id is 16 characters |
| cdport description | eqport description | |
| cdport hardware_address | eeqport hardware_address | |
| cdport net_address | eqport net_address | |
| cdport port_id | eqport port_id | |
| cdport port_std | eqport port_std | |
| cdport tc_level | eqport tc_level | |
| cdport tc_use_status | eqport tc_use_status |
Connections Table (afm_tccn) to Key Element Uphill Keys (eq, eqport, pn, pnport, jk tables)
The migration from the Connections table (afm_tccn) uses a series of SQL statements to process the Connection records and fill in the corresponding uphill fields (To fields) in the Jacks, Equipment, Equipment Ports, and Panel Ports tables.
| Source Table and Field | Target Table | Target Field | Notes |
|---|---|---|---|
| afm_tccn auto_number | not migrated | ||
| afm_tccn ca_std | not migrated | ||
| afm_tccn comments | not migrated | ||
| afm_tccn uphill_key | not migrated | ||
| afm_tccn uphill_position | not migrated | ||
| afm_tccn uphill_position_end | not migrated | ||
| afm_tccn upnhill_table | not migrated | ||
| afm_tccn transfer_status | not migrated | ||
| afm_tccn downhill_key |
eq eqport jk tc_eqport_id pn pnport |
tc_eq_id tc_eqport_id tc_eqport_id tc_pn_id tcpnport_id |
|
| afm_tccn downhill_position | not migrated | ||
| afm_tccn downhill_position_end | not migrated | ||
| afm_tccn downhill_table | not migrated |