Hi,
I've done this in the past but I can't remember how I did it. I'm sure there is a better way now. What we need is to be able to grab the title block information from our drawings and have that information listed in an Excel file or a Word document. I remember placing a .bat in the same folder as the drawings and then choosing the run macro button (or something like that) in one open file. This would create a list of all the drawings in that folder.In other words. My engineer wants a list of the names of the drawings in an excel file. (Not the file names. But the names of each drawing. As an example: 230/69KV Control RoomSwitchgearPSC Panel They are a combination of data fields and simple text. Drawings from last century and this century. Thanks for any and all suggestions.
Kelly Ogle said:I'm sure there is a better way now
Tell us the version of MicroStation that you're using, otherwise we don't know what to recommend.
Use key-in VERSION to see the version no. in the MicroStation Message Center, or Help→About MicroStation in the backstage.
VERSION
See this blog that shows you how to obtain MicroStation's version number.
Regards, Jon Summers LA Solutions
MicroStation CONNECT Edition - Version 10.16.02.34, Using RealDWG 2022 Thanks
Hi Kelly
It is certainly possible, I can modify my title block tags directly from Excel. With CONNECT being 64-bit, you would need to have the 64-bit version of Excel if you were to consider writing your own Macro. Alternatively, you can write and use a macro within MicroStation to export and import the tag values to an intermediate storage file e.g. CSV file but I chose not to take that approach as its an additional step and I dislike seeing MicroStation open and close each DGN file.
The other thing to keep in mind is how you would "know" what information to harvest. If it's all a text element on one specific level (not shared with anything else) that's pretty easy. If it's a combination of text and text nodes, that's something a little different. If the level has a bunch of other information on it, that's something else. Whatever you decide to do, you need to be able to visualize exactly how to locate the information.
Since you said "last century", I would assume that this isn't as neat as "all sheet models" or something as simple to run through as that, either.
MaryB
Power GeoPak 08.11.09.918Power InRoads 08.11.09.918OpenRoads Designer 2021 R2
Really, for harvesting title block data, you HAVE to use tags. Anything else and your in a world of pain; as you correctly question, how do you differentiate between annotation elements that are title block data, and others of the same type that are not?
Personally, I think the answer is: with great difficulty (it at all possible)