Subscribing is a smart move!
You can subscribe to this forum after you log in or create your free account.
Import Patch Panels back Connection to DCO
EcoStruxure IT forum
A support forum for Data Center Operation, Data Center Expert, and EcoStruxure IT product users to share knowledge on installation, configuration, and general product use.
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we?ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
This comment was originally posted on DCIM Support by Boris on 2018-06-21
Hello
I have found the following link
http://sxwhelpcenter.ecostruxureit.com/display/public/DCIMDEVELOPER/ETL+Integration+Examples
I copy the kjb and ktr files to /data/pentaho/import
In additionally I have prepared the connections.xls .According to etl.log the import is working without errors . I see data from connections.xls into tables of the staging DB . But into operation this connection not exist . I attach screenshot
| id | from_name | from_id | from_port_type | from_port_number | from_module_name | from_port_speed | from_patch_panel_rear | to_name | to_id | to_port_type | to_port_number | to_module_name | to_port_speed | to_patch_panel_rear |
| 1 | A | pp001 | FIBER_LC_REGULAR | 1 | A1 | 1Gbps | 0 | B | pp002 | FIBER_LC_REGULAR | 1 | A1 | 1Gbp | 0 |
| 2 | A | pp001 | FIBER_LC_REGULAR | 1 | B1 | 1Gbps | 1 | B | pp002 | FIBER_LC_REGULAR | 1 | B1 | 1Gbp | 1 |
PortConfiguration sheet
| name | id | port_type | start_port_number | port_count | module_name | port_speed |
| A | pp001 | FIBER_LC_REGULAR | 1 | 6 | A1 | 1Gbps |
| B | pp002 | FIBER_LC_REGULAR | 1 | 6 | A1 | 1Gbps |
| A | pp001 | FIBER_LC_REGULAR | 1 | 6 | B1 | 1Gbps |
| B | pp002 | FIBER_LC_REGULAR | 1 | 6 | B1 | 1Gbps
|
This answer was originally posted on DCIM Support by Ed Tarento on 2018-06-26
Hi Boris
I've successfully done this although I didnt use the supplied files. I wrote programs to populate the Import DB directly from CSV files provided by the customer. It did work at the v7 version i used a few years back.. no reason to think its broken in this version but its possible
This is just a guess but are you using an XLS or XLSX? I can see the example posted is called connections.xls
Have you created the External System in DCO referencing the Import DB?
Webmin should show this
not this
When you right click on the External System and select "Synchronize external data" in DCO under "Planning - Device Association" what do you see?
look in /opt/jboss-as/standalone/log/server.log
Cheers
Ed
This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.
Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.