Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Notifications
Login / Register
Community
Community
Notifications
close
  • Forums
  • Knowledge Center
  • Events & Webinars
  • Ideas
  • Blogs
Help
Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Login / Register
Sustainability
Sustainability

Join our "Ask Me About" community webinar on May 20th at 9 AM CET and 5 PM CET to explore cybersecurity and monitoring for Data Center and edge IT. Learn about market trends, cutting-edge technologies, and best practices from industry experts.
Register and secure your Critical IT infrastructure

CSV to Prop script. Edit multiple objects and properties using Excel.

EcoStruxure SEAL Forum

This forum is for engineers working EcoStruxure Building Operation, wanting to leverage the SEAL application to improve the efficiency in the engineering process.

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Home
  • Schneider Electric Community
  • EcoStruxure Building
  • EcoStruxure SEAL Forum
  • CSV to Prop script. Edit multiple objects and properties using Excel.
Options
  • Subscribe to RSS Feed
  • Mark Topic as New
  • Mark Topic as Read
  • Float this Topic for Current User
  • Bookmark
  • Subscribe
  • Mute
  • Printer Friendly Page
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send Invite Cancel
Invitation Sent
Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Send New Invite Close
Top Experts
User Count
StefanLundin
Lt. Commander StefanLundin Lt. Commander
23
Benji
Administrator Benji Administrator
9
MortenEnger
Lieutenant JG MortenEnger Lieutenant JG
3
APA
Lieutenant JG APA Lieutenant JG
3
View All
Related Products
product field
Schneider Electric
EcoStruxure SEAL

Invite a Colleague

Found this content useful? Share it with a Colleague!

Invite a Colleague Invite
Solved Go to Solution
Back to EcoStruxure SEAL Forum
Solved
APA
Lieutenant JG APA Lieutenant JG
Lieutenant JG

Posted: ‎2024-12-11 12:17 AM . Last Modified: ‎2024-12-19 12:13 AM

7 Likes
6
730
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2024-12-11 12:17 AM . Last Modified: ‎2024-12-19 12:13 AM

CSV to Prop script. Edit multiple objects and properties using Excel.

Hey all,

 

APA_1-1733903778229.png

 

 

With the attached script you can set object properties using a CSV file.

 CSV File needs to be CSV UTF-8 where ";" is used as a separator and "," as a decimal separator

APA_0-1733903528869.png

 

 

 

You can create a template file with in run mode Prop to CSV mode.

APA_2-1733903954064.png

And specify the objects you want to configure copying them from workstation search Window to the parameter. And specify the output file. Then you can edit the file in excel or text editor.

APA_3-1733903965862.png

APA_4-1733904269817.png

 

Example file looks like this:

APA_5-1733904397074.png

 

And edited file could look like this:

APA_6-1733904430551.png

If you want to make bindings use {bind} tag in the front of the value.

 

So it functions similarly to Workstations import from XLSX functionality, but the objects can be in different locations.

 

Examples this script can do, where there is not a straight way to do in Workstation:

  • Set colors or line presentation of Log series in Trend Charts
  • Set BACnet alarm properties (delay and limits - these are not exposed to normal search)

 

Attachments
GENERAL - CSV to Prop-2.2.6.zip
Labels
  • Labels:
  • Finnish
  • Script
  • Shared Scripts
  • Tags:
  • english
Reply

Link copied. Please paste this link to share this article on your social media post.

  • All forum topics
  • Previous Topic
  • Next Topic

Accepted Solutions
APA
Lieutenant JG APA Lieutenant JG
Lieutenant JG

Posted: ‎2024-12-15 11:30 PM

In response to Siva.A
0 Likes
3
612
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2024-12-15 11:30 PM

TGML Component properties are visible trough SDK. Only when they are set to public exposes they can be seen as properties of the TGML. To get the component properties that are not public exposes, someone would need to make a script to analyze the TGML:s structure directly.

 

Short answer. It is possible. But someone needs to develop such a script for that purpose.

See Answer In Context

Reply

Link copied. Please paste this link to share this article on your social media post.

Replies 6
JohnnyCarlsen
Lieutenant JG JohnnyCarlsen Lieutenant JG
Lieutenant JG

Posted: ‎2024-12-11 04:23 AM

1 Like
0
692
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2024-12-11 04:23 AM

Powerfull tool, I have been using at lot 💪

Reply

Link copied. Please paste this link to share this article on your social media post.

Siva.A
Ensign Siva.A Ensign
Ensign

Posted: ‎2024-12-12 07:20 AM

0 Likes
4
662
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2024-12-12 07:20 AM

is there any way to extract the graphics used components properties in csv format??

 

Reply

Link copied. Please paste this link to share this article on your social media post.

APA
Lieutenant JG APA Lieutenant JG
Lieutenant JG

Posted: ‎2024-12-15 11:30 PM

In response to Siva.A
0 Likes
3
613
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2024-12-15 11:30 PM

TGML Component properties are visible trough SDK. Only when they are set to public exposes they can be seen as properties of the TGML. To get the component properties that are not public exposes, someone would need to make a script to analyze the TGML:s structure directly.

 

Short answer. It is possible. But someone needs to develop such a script for that purpose.

Reply

Link copied. Please paste this link to share this article on your social media post.

Siva.A
Ensign Siva.A Ensign
Ensign

Posted: ‎2024-12-16 01:46 AM

In response to APA
0 Likes
2
602
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2024-12-16 01:46 AM

Thanks for your valuable answer. Is there any plan to develop such a code??. We are doing many custom graphics in our team and we are struggling to validate the graphics. if we get that scripts it will help us to compare the software & graphics and find out the issues..

Reply

Link copied. Please paste this link to share this article on your social media post.

StefanLundin
Lt. Commander StefanLundin Lt. Commander
Lt. Commander

Posted: ‎2024-12-18 11:38 PM

In response to Siva.A
1 Like
0
561
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2024-12-18 11:38 PM

Hi Siva,

 

I'm happy to see you recognize the value of what Seal Script can accomplish. I'm now writing as part of the developing team for the Seal Script engine itself, even though your previous conversation has been with individually very competent people who are not part of our team but have excellent knowledge of creating Seal scripts and are doing so for their businesses.

 

As for our developing team, we do not typically develop specific scripts. We as a team mainly focus on developing the Script engine itself to ensure it has the features needed for script development, even though we do create more common scripts occasionally. Community members, in general terms, tend to develop scripts that benefit their own organization's tasks.

 

You can certainly use the community to ask if anyone has plans to develop a script that you could benefit from or if someone with the necessary skills could create a specific script for you. However, realistically, waiting for someone to have spare time to develop a specific script might take a while.

 

The best way to get a script that benefits your organization is to ensure that someone in your team learns to code Seal scripts. The knowledge required to gain this competence includes learning to code in JavaScript and understanding how Ebo objects are built up. The community will be a great resource and conversation partner when you encounter challenges.

 

With this, I want everyone, not just you, to consider developing such competence within their business. I'm sure it would pay back quickly.

 

Best of luck with your projects

Reply

Link copied. Please paste this link to share this article on your social media post.

APA
Lieutenant JG APA Lieutenant JG
Lieutenant JG

Posted: ‎2024-12-19 12:20 AM

In response to Siva.A
0 Likes
0
556
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2024-12-19 12:20 AM

No sorry. I don't have plans to develop this kind of script.

Reply

Link copied. Please paste this link to share this article on your social media post.

Preview Exit Preview

never-displayed

You must be signed in to add attachments

never-displayed

 
To The Top!

Forums

  • APC UPS Data Center Backup Solutions
  • EcoStruxure IT
  • EcoStruxure Geo SCADA Expert
  • Metering & Power Quality
  • Schneider Electric Wiser

Knowledge Center

Events & webinars

Ideas

Blogs

Get Started

  • Ask the Community
  • Community Guidelines
  • Community User Guide
  • How-To & Best Practice
  • Experts Leaderboard
  • Contact Support
Brand-Logo
Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Forum-Icon

Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.

Register today for FREE

Register Now

Already have an account? Login

Terms & Conditions Privacy Notice Change your Cookie Settings © 2025 Schneider Electric

This is a heading

With achievable small steps, users progress and continually feel satisfaction in task accomplishment.

Usetiful Onboarding Checklist remembers the progress of every user, allowing them to take bite-sized journeys and continue where they left.

of