Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
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
84295members
353438posts

Struxureware DCO integration to MS Excel

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.

DCIM_Support
Picard
Picard
0 Likes
5
207

Struxureware DCO integration to MS Excel

This question was originally posted on DCIM Support by Vineet K. Sarin on 2014-06-21


Integration of MS Excel with DCO is possible easily but what do we do when end clients have their own databases fields which we have to create as custom fields for Asset? Do we have any mechanism to add those Custom fields also to the DCO import template through Excel?

 

(CID:85885046)

5 Replies 5
DCIM_Support
Picard
Picard
0 Likes
2
207

Re: Struxureware DCO integration to MS Excel

This answer was originally posted on DCIM Support by Jonathan Gould on 2014-06-21


Vineet,

I believe you are referring to the Excel Import tool in Data Center Operations; if so then you can add any additional custom fields by inserting the column with the custom field desired name and appending the custom field name with 'CP' ('CP' stands for custom property).   There are examples of this in the template available from DCO and here is a screenshot of the section I am referring to in the template (highlighted in green):

In the sample above, the two custom property fields are IP and Owner.  Hope this helps

(CID:85885048)

DCIM_Support
Picard
Picard
0 Likes
0
207

Re: Struxureware DCO integration to MS Excel

This comment was originally posted on DCIM Support by Vineet K. Sarin on 2014-06-22


And is there a possibility of getting the CRAC units and various other infrastructure to exactly align themselves at 90 degree with ROOM walls rather than importing them onto Rows, similarly for Racks to orient themselves at specific angles?

(CID:85885059)

DCIM_Support
Picard
Picard
0 Likes
0
207

Re: Struxureware DCO integration to MS Excel

This comment was originally posted on DCIM Support by Brunner Ueli on 2015-01-13


From where do i know how the excelfile has to look like? Is there a specific form for that or is there somewhere a template?

(CID:93914544)

DCIM_Support
Picard
Picard
0 Likes
0
207

Re: Struxureware DCO integration to MS Excel

This answer was originally posted on DCIM Support by Jonathan Gould on 2014-06-26


Vineet, 
The only way to import to floor equipment to a specific space is to create a row, otherwise it imports the floor equipment generally into a room

 

(CID:85885193)

DCIM_Support
Picard
Picard
0 Likes
0
207

🔒 Closed

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.