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
84766members
354198posts

Hidden spaces from clipboard MS excel paste

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
236

Hidden spaces from clipboard MS excel paste

This question was originally posted on DCIM Support by Nigel Fanning on 2018-02-09


I recently had a query from our capacity management team who receive a datafeed from Struxureware (DCO).  They discovered 28 servers which were returning hostnames with question marks before or after the hostnames themselves.  These obviously would not tally with the known devices in the comparative databases.

For example:

HOSTNAME??  or ?HOSTNAME

Where "hostname" represents the name of a particular server.

From luck and some faint memory we remembered that this was a DCO issue a long time ago that recognised that hidden spaces or returns could be included when text fields are pasted into the properties boxes perhaps from excel cells.

This was resolved before (I presume by some added code on a minor update) but the issue appears to have reappeared after our 8.2.2 update.

The 28 servers have since had their "hidden" spaces or returns removed but if more come in the future they will export with the spaces.  Can this be resolved again?

(CID:128755034)

5 Replies 5
DCIM_Support
Picard
Picard
0 Likes
3
236

Re: Hidden spaces from clipboard MS excel paste

This answer was originally posted on DCIM Support by Jef Faridi on 2018-02-11


Hi Nigel,

I will contact you soon (by direct email), I might need some info, thanks.

Kind regards

(CID:128755300)

DCIM_Support
Picard
Picard
0 Likes
0
236

Re: Hidden spaces from clipboard MS excel paste

This comment was originally posted on DCIM Support by Jef Faridi on 2018-02-12


Hi Nigel (Nigel Fanning),

Many thanks for providing the additional info - I have now registered an enhancement case for you (& have sent you a confirmation as well), thanks.

Kind regards

(CID:128755719)

DCIM_Support
Picard
Picard
0 Likes
0
236

Re: Hidden spaces from clipboard MS excel paste

This comment was originally posted on DCIM Support by Nigel Fanning on 2018-02-12


Thanks Jef - I look forward to the cases progression.

(CID:128755731)

DCIM_Support
Picard
Picard
0 Likes
0
236

Re: Hidden spaces from clipboard MS excel paste

This comment was originally posted on DCIM Support by Jef Faridi on 2018-02-12


You are most welcome, Nigel

I will keep you posted,

Kind regards

(CID:128755757)

DCIM_Support
Picard
Picard
0 Likes
0
236

🔒 Closed

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