The agony of renumbering an entire set of MicroStation sheet files
Do you like doing the same thing, over and over, for hours on end?
Clearwater, Florida, USA — How do you handle the sheet numbers and sheet counts in title blocks after inserting a new sheet into a set? Do you edit the affected values in every title block in every sheet manually? While plodding through a set of design files, one at a time, typing little numbers into title blocks, did you ever think to yourself, “Is this what I went to school for?”
Okay, so someone comes along and says you gotta add an additional sheet file into a set of 237 nearly completed project design files. Now your numbering system is all screwed up. Somebody’s got to fix it. In less time than it takes for you to figure out who you hate the most, you could handle the whole thing and get that long-overdue respect you deserve. (Now this may not be your exact scenario, but think with me here. Have you or someone ever had to make some change to lots of title blocks?) The following takes about five minutes:
- After inserting that new sheet file into your set of design files (making 238 files now, in our example here), open MicroStation and start Axiom’s Title Block Administrator. Title Block Administrator is the batch processing half of the two tools, including Title Block Client, known together as Title Block Manager.
- With Title Block Administrator loaded, press the <Select> button next to the “Design Files:” field in the main Title Block Administrator dialog box. This will load the “Choose Files to Process” dialog box that allows you to select the sheet files for processing. Choose all the sheet files in your set.
- Now set “Action:” to “Update database from selected design files.”
- Click <Start>. This will create a spreadsheet (database) containing all the title block values in each sheet file in your set, including values from the new sheet you added to the set. In this example, let’s say the sheet you’re adding is sheet number 2.
Technical Note: If your title blocks use tags, they’re automatically supported by Title Block Administrator. If your title blocks use regular text or text in cells, you need to run Title Block Administrator’s “Upgrade existing text to TBMgr text” from the “Action” menu before creating this spreadsheet. That will add the self-awareness to your title block text elements that Title Block Administrator needs to perform its time-saving miracles.
- Click on the <Edit Database> button on the Title Block Administrator main dialog box. This will open the database created in step 4 above in Excel.
- Increment the values in the “Sheet” and “Total” columns of the spreadsheet to accommodate the renumbering. Specifically, add a sheet number for the new sheet, change existing sheet numbers to accommodate the newly inserted sheet and change the total sheet count in the “Total” column to “238”. By the way, while you are in Excel, you can change any title block field value you want. So if you need to make any other changes while you are in there, feel free. And keep in mind that you can make changes to any of the title blocks represented in the database — you are not limited to editing one title block at a time.
- When done making your changes in Excel, close the spreadsheet.
- Back in Title Block Administrator, set “Action:” to “Update selected files from database.”
- Click <Start>.
- Check your Facebook wall, get some coffee, brag to your peers about how you are saving them loads of time even as you are sipping your morning cup of Joe and by the time you get back to your desk, the job will likely be fully complete. Heck, depending on how many design files you have, it may be complete before you stand up.
Which scenario sounds better, the one that takes you four hours or the one that takes about five minutes?