Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
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.
Send Invite Cancel
Link copied. Please paste this link to share this article on your social media post.
The Concept
The CSV to Properties Script automates object property management in EcoStruxure Building Operation using CSV files. It supports two modes: CSV to Properties updates object properties from a CSV, and Properties to CSV exports properties from Workstation Search paths to a CSV. Perfect for bulk updates or documentation.
Key Features
- CSV to Properties Mode:
- Sets properties and bindings from a CSV file.
- Optionally creates new objects if they don’t exist.
- Properties to CSV Mode:
- Exports object type, name, properties, and bindings to a CSV.
- Uses Workstation Search paths as input.
- Flexible Options:
- Supports semicolon (;) or comma (,) list separators of the CSV
- Option to run in Live or Database mode.
- Error Handling:
- Logs errors for invalid paths or files.
- Saves changes incrementally for stability.
How to Use
- Properties to CSV Mode:
- Use Workstation search to do the selection for what objects you want to get properties for:
Example : All object on the whole server with names ending with '_PB' - Copy the Search Result and paste this to the SEAL Script "Paste object paths from search" in the Create CSV file section. Select the Output file to create.
- Select Base Path and Run the script
- This will generate an csv with all properties for the referenced objects :
- Use Workstation search to do the selection for what objects you want to get properties for:
-
CSV to Properties to Mode:
- Use the CSV generated from above.
Adjust the values of the properties you do want to edit and remove properties you don't want to edit. - Select the CSV file
-
Select BasePath and Run the Script to set the defined properties on the referenced objects.
- Use the CSV generated from above.
Important ⚠️ Back up your system before modifying objects !
The Script is available from SEAL Script, Standard Scripts
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.