Hello, I need to prepare electrical wiring diagram for which I have required terminal details (Cable tag, terminal number etc.) in MS Excel format. Is it possible to populate data in MS Excel into MicrostationV8i.
Post your query to OpenUtilities Substation | Promis.e Forum
Ok Will do the same.
Without Promis.e, in the past one could use scripts to read the CSV data and populate into TAGS, or even at a most basic level, just using Text replace tool.
Consider how often this will be needed, and whether development of such a tool would be justified using VB. It could be a far cheaper proposition, especially if the nature of the task is repetitive, or there is a lot of data. I had a VB script produce 750 wiring diagrams from 10 template DRGs in 20 minutes, with immediate updating from a new CSV export. Unfortunately, this was paid for by a client, so unavailable to public, but any developer could build a system in 20-40 hours with a good algorithm and prep.
If you wish to have this capability to be more flexible, then definitely Promis.e like products are the go.
Greg Smith
Microstation 10.17.01.058
Opinions expressed are my own and not necessarily those of my employer
Thanks @Gregory Smith