Archive for the ‘Articles’ Category

CadExplorer, Offering Search and Replace Across Multiple MicroStation and AutoCAD Files, Now Supports ProjectWise

Wednesday, 5 January 2011

Search, Replace, Filter, Group and More — Even with Files in ProjectWise

Clearwater, Florida, USA — Axiom, one of the world’s most experienced developers of time-saving CAD software products, announces the release of CadExplorer version 4.1. Previously released for MicroStation and AutoCAD, CadExplorer now supports ProjectWise, Bentley’s project management system. The new version of CadExplorer can now look into ProjectWise, allowing users to find virtually any DGN or DWG file objects (including text, cell or block names, circles, lines, shapes and many others) across multiple files based on a wide range of search criteria, including text strings, cell or block names, level or layer names, color, weight, style and many more. It can also make batch modifications of both DGN elements or DWG objects.

Finding what you need quickly is a snap using CadExplorer’s intuitive, easy-to-use interface. CadExplorer easily finds, filters and groups data from all your DGN and DWG files. With the latest release, CadExplorer now supports ProjectWise.

Per Axiom, CadExplorer’s addition of ProjectWise support has been a much sought-after feature requested by customers. For over a year, users (even non-CAD users) have been using CadExplorer to ignore the boundaries between both MicroStation and AutoCAD files and interactively find, display, analyze, explore, report on, investigate and edit MicroStation and AutoCAD file data in ways never before possible. In addition, Axiom reports that CadExplorer’s interface provides an easier way to find, select, preview and modify text across multiple MicroStation or AutoCAD files than by any other method. With CadExplorer, users can modify found text elements’ text strings in any imaginable way — even using wildcard and regular expression substitution — and can preview proposed text changes before committing them to all their selected MicroStation or AutoCAD files, even when these files are stored in ProjectWise.

“There is no other product out there that lets someone so easily peer into hundreds or thousands of MicroStation and AutoCAD files at a time and rapidly find the elements and objects that they need to locate”, said Axiom’s Vice President of Technology, Oscar Albornoz.

Axiom reports that in addition to the newly added ProjectWise support, CadExplorer is stuffed with tools and features that go beyond anything that can be done with MicroStation or AutoCAD alone. CadExplorer shows users virtually all the data contained in one, ten, hundreds or even thousands of design files in an easy-to-use and intuitive grid. Need to see all the cells or blocks that are being used in any project on the network and get a count of each one? A few mouse-clicks is all it takes. What are the chances of catching an odd-ball mistake before submitting the project to a client, like a misspelled level or layer name or some text that happens to be on the wrong level or layer? Spotting errors like misspellings or a cell or block that was only used once (a shoe-in for a CAD-standards violation) becomes much easier, faster and, per Mr. Albornoz, is “even kind of fun” when using CadExplorer.

How to Contact Axiom
For more information on CadExplorer or to see a free, online demonstration, call Axiom at 727-442-7774 extension 1638 or e-mail 1638@AxiomInt.com or visit Axiom on the Web at www.AxiomInt.com to find out more about the main features of CadExplorer as they relate to AutoCAD.

Why CAD training doesn't work

Wednesday, 5 August 2009

How to make CAD training actually useful for you personally

By Mike Arroyo
Clearwater, Florida, USA — Has anyone noticed that most technical training is still delivered the way it was in the 1980s?

Axiom’s instructor-led training includes customized training materials that incorporate customer drawings and procedures. This customized training, offered at generic training costs, helps customers save time and increase production.

Just like they did over 25 years ago, companies send designers to an off-site facility to receive generic training manuals, with less-than-impactful exercises, for a four-day marathon where success is proclaimed if all the commands and pages are covered during the scheduled time — regardless of the amount of knowledge actually retained. The main problem is that generic training doesn’t target the real issues that only customer-specific training can address. This is why Axiom, the largest provider of browser-based training for Bentley software, is changing the way instructor-led training is performed.

Shawn Butler of Paulus, Sokolowski and Sartor experienced the Axiom difference, stating this about the on-site training experience: “The training went great. Your team was excellent; your team’s ability to mobilize quickly was fantastic and the instructors’ ability to be flexible was superb. I truly have to say that Axiom’s response time, ability to understand my needs, ask the right questions and provide on-the-spot analysis is impressive. I can say that it was the quality and immediate response that confirmed to me that Axiom was the company to team up with. The time on the phone with your office and your team set the atmosphere for the success of this engagement.”

Steps to success
First, we interview the customer to discover what is needed and wanted. Questions such as “How much CAD experience do the students have?”, “What CAD skills could best impact the company’s speed of production?” and others help uncover unique issues and specific objectives that the company wants to solve with training.

Second, we customize the training syllabus to best fit the needs of the customer to ensure that time training users is the most productive possible. Adjusting the topics covered ensures that any specific issues and objectives are targeted and that the most needed CAD skills are gained during the training.

Third, we insert company drawings, workflow and customization into the training. Employees are exposed to their company CAD standards, such as naming conventions and annotation styles, as well as custom scripts and menus during the training sessions. Unlike generic training, students learn how CAD is done at their company.

Finally, we deliver customized training materials. The manuals are organized based on the revised syllabus and incorporate customer drawings and procedures. Additionally, ample design files and step-by-step labs are delivered.

Axiom, always looking for ways to help our customers save time and increase production, delivers this customized training solution at generic training prices. Take the time and contact one of our MicroStation Consultants and see how we can help.

Microsoft Office Importer adds ProjectWise support.

Friday, 15 May 2009

By Eiren Smith
What do MicroStation users do if they want to easily import large spreadsheets and word processing data into their design files with perfect formatting? What if they want to maintain a link to the original spreadsheet so that if something changes in the spreadsheet, the design file can be easily — interactively or automatically — updated? What if they use ProjectWise?

Microsoft Office Importer — which now talks to ProjectWise — lets you import word processing and spreadsheet data into your design files with formatting you control.

I’m a little tight on space this month so I’ll keep it brief. I want to tell you about Microsoft Office Importer’s brand-new and most excellent support for Bentley ProjectWise.

You all know what Microsoft Office Importer is, right? It’s Axiom’s super-popular tool for bringing data from Excel spreadsheets and Word documents into MicroStation with perfect formatting with a link to the source spreadsheet or document. Users open the spreadsheet or document, copy what they want to the clipboard, then jump over to MicroStation and paste that data, using the “Paste Clipboard Contents” button on Microsoft Office Importer’s toolbar. In addition to bringing the data in with perfect formatting, it provides tons of options so you can have things formatted exactly the way you want. Microsoft Office Importer also provides a link from that design file back to the spreadsheet or document so that pasted data in the design file can be easily (interactively or automatically) updated anytime in the future if the source spreadsheet or document file changes.

Enter ProjectWise
Microsoft Office Importer has long made all the above extremely easy to do, but (until now) wasn’t able to communicate with ProjectWise. So when Microsoft Office Importer would go to see if the spreadsheet or document had changed, that spreadsheet or document had to be in the exact same location it was when it was originally pasted into that design file. This meant two things:

  • The user had to check that spreadsheet or document out of ProjectWise before Microsoft Office Importer could check to see if the design file needed to be updated from that spreadsheet or document; and
  • The user had to check the spreadsheet or document out to exactly the same folder as it was checked out to the first time it was pasted into that design file, as that’s where Microsoft Office Importer was going to look for it at update time.

All this was because Microsoft Office Importer simply didn’t talk to ProjectWise. I’m happy to report that that’s now totally handled. Now, when Microsoft Office Importer needs to see if the design file needs to be updated, Microsoft Office Importer can talk to ProjectWise and check out any needed files automatically. This means that Microsoft Office Importer updates of spreadsheet and document data in design files are now totally workable for ProjectWise users.

As I mentioned above, I’m tight on space this month. Check back in the future for a detailed description of how this all works. But don’t let that keep you from trying out the new version of Microsoft Office Importer with ProjectWise support for yourself. It’s so easy to use, you really don’t need to know anything that non-ProjectWise Microsoft Office Importer users don’t know. Take it for a spin!

Save time and prevent a CAD standards nightmare.

Friday, 15 May 2009

Part two in a series of articles on the mysteries of global origin

By Rick Dewitt

Have you ever started a project and noticed that one or more reference files didn’t seem to line up in your master files the way you expected or that the geometry you expected to be a particular size was too big or too small? In a previous issue of MicroStation Today, I wrote the first segment of an in-depth discussion on the frequently misunderstood subject of “global origins”. [Editor's note: See MicroStation Today Volume 16, Issue 3. The article can be found here] Not understanding global origin and a closely related topic, “working resolution”, can lead to a host of questions such as:

Not knowing how global origin affects your design files could result in time-consuming and costly mistakes — the kind that keep you up at night.

  • What exactly is the global origin?
  • What happens if you change it?
  • How do you change it?
  • How does it affect reference files?
  • How is working resolution related?
  • Does Axiom have any products that can help fix global origin and working resolution problems?

In this article, I will continue that discussion so you have an even better grasp of the subject, how it can impact your projects and what you can do if you discover the global origin is wrong in some or all your project design files.
If you ever had a time when one or more reference files didn’t line up in your master files the way you expected after attachment or the geometry appeared way too big or way too small, then you had mismatched global origin settings, working unit settings, working resolution settings or some combination of all three.

The global origin is a setting made relative to the MicroStation design plane (for 2D) or cube (for 3D) which defines where the x=0, y=0 and z=0 coordinate point is located. The global origin point, when you ask MicroStation, is defined (set) as a certain number of master units (like feet or meters) from a predefined fixed point on the design plane (or cube) along each axis. The “predefined fixed point” is set by Bentley (more on this below).
“Master units”, as you probably know, define what we will call the real world distance measurement in a design file.

For civil engineering projects, this is usually feet or meters. If you are designing circuit boards however, you would probably prefer inches or millimeters as a master unit.

“Working resolution” defines how many units of resolution are going to be used to make up a specific unit of measure like a foot or a meter. For example, if you set the units of resolution to 1,000 units per foot in a design file, then a line that is one foot long will take up ten times more design plane than a one-foot line in a design file whose units of resolution are set to 100 units per foot. So, if you attach a reference file that uses 1,000 units of resolution per foot to a master file that uses 100 units of resolution per foot, at a scale of 1.0, then a one-foot line in the reference file will look like a ten-foot line in the master file.

Because the global origin is expressed as a value in master units like feet or meters, the same point on the design plane can have a very different value when the master units of two files are different or the working resolution is different for the same distance of measure.

Combining V7 and V8 files can create unexpected problems.
In MicroStation V8, the predefined fixed point used to help locate the global origin was changed from where this point was in V7. Specifically, the predefined fixed point was moved from the lower, left-hand corner (for 2D designs) to the exact center of the design plane. What’s more, the design plane is significantly larger (about 2 million times larger) in V8 than it was in V7. For 3D designs, the predefined fixed point was moved from the lower, bottom-left corner (where it was in V7) to the precise middle of the design cube (in V8). This change has created some confusions and problems — particularly when combining MicroStation V7 design files with MicroStation V8 design files in the same project.

One example of such problems occurs with “coincident” reference file attachments. When you make a coincident reference file attachment, MicroStation orients the two design files so the design planes match up exactly. It’s important to know that the thing MicroStation matches up is the design planes, not the global origins. In projects where all the design files (including all the reference files) use the same global origin and the same working resolution, then obviously all the global origins and geometry will happen to line up as well. Unfortunately, this is not the case if the global origin or working resolution settings of a master file are different from those of an attached reference file. In this case, the geometry in the reference files will not line up as expected due to global origin differences or the size of the elements will be wrong due to differences in working resolution.

When the global origins are different between master and reference files, a coincident attachment will offset geometry just like the global origins are offset above.

For instance, let’s say that you have a hybrid project that includes V7 design files, V8 design files and maybe even AutoCAD files. If each type (V7 or V8) of MicroStation file uses a different global origin setting and the working resolution settings are different, you are going to notice reference file geometry not having the expected orientation to the master file’s coordinate system. Also, the size of the geometry from the reference file will appear wrong.

Similar to the above, if the V7 or AutoCAD files are being translated into V8 format or vice-versa, you can easily run into the same problems if the translators are not set up to handle these factors properly. Understanding global origin and working resolution and how to fix them is crucial when you are responsible for creating projects that must comply to CAD standards or if you have to define the CAD standards others must follow.

Avoiding a time-consuming nightmare
Let’s say you translate a group of files from AutoCAD to MicroStation V8 without ensuring that the translated files come into MicroStation with the required working units (such as feet or meters), resolution settings and global origin settings. Guess what? You are playing Russian roulette with your company’s potential profit on that project. It’s true you might get lucky using the default translation settings or you might have a client who isn’t picky about settings as long as the sheets plot correctly. But if you aren’t lucky and the project has to be fixed to comply with a different resolution standard and a different global origin value, you will have a time-consuming nightmare on your hands. Why? Because changing the resolution changes the “real-world” size and location of every element already in the design file and changing the global origin changes the coordinate location of every element. To get things right after designing the project, you will have to re-scale and move everything. Re-scaling and moving elements obviously affects where reference file elements are going to display in master files. If reference file attachments are clipped, the elements in the reference files, after being rescaled and moved, will almost certainly disappear outside the clipping boundary, making it necessary to fix that as well. I could go on but I’m sure you get the point.

Some solutions may not meet your CAD standards.
In MicroStation V8, Bentley added a new attachment method called “Coincident World” to help make this all a little easier for users to deal with. “Coincident World” matches the attachment’s global origin to the master file’s global origin. This is really useful when files from multiple projects — that may have different global origin settings — are used together. Using this attachment method along with the “True Scale” option (which automatically scales the attachment to compensate for differences in working units or resolution) can make combining files from different projects very simple in V8 — provided you don’t have CAD standards that forbid having different global origin settings or different working resolution settings. Unfortunately for many, a number of CAD standards still require the use of very specific global origin and working resolution settings. When those settings aren’t followed, the time-consuming nightmare mentioned above comes into play.

Because of these problems, Axiom added additional features to Global File Changer that help isolate design files with non-standard settings and provide a way to easily update those design file settings to match the standard. Global File Changer and other tools from the MicroStation Productivity Toolkit provide effective solutions that can drastically reduce the time required to fix project design files, including those created using non-standard working resolution or global origins settings.

Product Review: Nigel Davies puts Global Workspace Manager through its paces.

Friday, 3 April 2009

There has been an item on the MicroStation Wish List since its inception over three years ago. [Editor's note: The MicroStation Wish List was developed in 2005 by EatYourCAD in conjunction with the worldwide Bentley Community and was announced at BE 2005.] The item, which is currently in the top three, is for MicroStation to have an “External configuration interface” (an interface that would allow you to edit MicroStation configuration variables without having to open MicroStation).

Nigel Davies, Director of Evolve Consultancy, has 20 years of extensive experience within the AEC industry.

There is a need when implementing any corporate application to ensure it is correct on all workstations. With a highly configurable product such as MicroStation, it’s even more important to ensure it remains correct on all workstations. Using MicroStation itself to check each workstation would be a long, slow slog. This is probably the main reason that an “External configuration interface” has enjoyed a top position on the MicroStation Wish List. So, we were very interested to hear from our friends over at Axiom that they had a new product, “Global Workspace Manager“, to fulfil some of those needs.

What does it do?
The features list for Global Workspace Manager (OK, I’m going to just refer to it as GWM for the rest of this review) is fairly comprehensive. I can’t sum it up any better. GWM is designed to:

  • View and modify configurations on any workstation.
  • Copy project configuration files and all project resources to another server or workstation on the network.
  • Produce an inventory of workstations that includes location, users, projects and which versions of MicroStation are installed.
  • Compare working configurations against a non-working configuration.
  • Isolate configuration levels and view changes made at that level.
  • Track a variable to see how it was changed at each configuration level.
  • View the final value of any or all variables.
  • Group, sort and filter the grid to produce valuable documentation.
  • Use categories to view specific user-defined groups of variables. [Editor's note: the "Category" tab shows variables categorized similar to MicroStation's Workspace | Configuration "Category" list. It can be customized to show user-specific "groups" or categories of variables.]
  • View variables in a tree similar to MicroStation’s configuration dialog box.
  • View a description of each MicroStation variable.
  • Build complex configuration definitions using the expression builder.
  • Easily create filters to display variables that “begin with”, “end with”, “contains”, “does not contain”, “is equal to” or “is not equal to” a user-defined string.

Yes, that’s quite a lot of features. But is it any good? Not one to turn down the chance to roll my sleeves up and dive into a few configurations, I set about giving it a thorough going-over.

First of all, why would you need it?
It used to be that it was pretty simple to deploy MicroStation on any workstation. All you needed was an edited “mslocal.cfg” to point to the central configuration files and you were fine. [Editor's note: The "mslocal.cfg" file is the first configuration file that MicroStation opens when started. Key variables in this file direct MicroStation to find files in a specific "central" location (path). Collectively, these files are sometimes referred to as "central configuration files".] While that’s still true for desktop PCs that don’t move around, in this age of a less-localized workforce, more people using laptops and the added complication of managing additional offices, it’s common to need at least some of your server configuration files on each workstation. That’s where GWM steps in. With the installation of a small utility (the client) on each computer, configurations are uploaded to GWM every time MicroStation is started. GWM lets you review those configuration files, make edits and ship them back out again. It’s less vital to install GWM on those PCs that are never detached from your server workspace, but then you can never be too careful if ol’ George likes to mess around with his workspace settings. Another useful application of GWM is to check and maintain workspaces on multiple servers or in multiple offices.

How does it work?
When you install GWM, you are prompted to set up a central database location where all your various workstations (that will have the client utility installed) will write their configuration files. GWM then provides you with a “.bat” file to install the client utility on your workstations. When MicroStation is started on a workstation that is running the client utility, the utility copies the configuration data to the central location that was previously set up. GWM reads this data and displays it in various, customizable formats.

Global Workspace Manager can keep track of MicroStation workspaces and present information about them in an easy-to-read, spreadsheet-like table.

(Note: It is well worth checking out the PDF guides installed with the product. GWM installs a demo database for you to play with and gives some valuable quick-start advice.)

GWM has four tabs at the bottom of the screen, which allow you to view the information, review the configuration process and edit variables.

“Workspaces” is the “home page” that shows one line for each workspace at your site (or in your corporation).

“Variables” is where you can check the values of variables from one or several workstations.

“File order” displays the order in which MicroStation processed the various configuration files — a heck of a lot easier than scrolling through an msdebug.txt file! [Editor's note: "msdebug.txt" is a file that MicroStation creates when run in debug mode. The file contains a whole lot of information about an installation of MicroStation. It lists all of the configuration files that run and shows what MicroStation variables are set in each configuration file. It also displays the configuration files and variables in the order that they are loaded. This data allows a very advanced MicroStation expert to determine exactly what happens when MicroStation loads, what settings are set within MicroStation, how they got to be set that way and much more.]

“Category” presents the variables in a tree view, grouped similarly to MicroStation’s Workspace Editor. Unlike the Workspace Editor, this is fully customizable through a “DebugCategory.txt” text file, which allows you to create your own categories and move variables around to suit your needs.

Dealing with multiple workstations reporting multiple workspace components can get very confusing. That’s where Axiom’s GWM excels. Each page in GWM is easily organized into more manageable groupings, by simply dragging a column heading to the top of the screen. For example, you can group by “Location” and then check which office has which workspace and when it was last updated without having to log in to remote servers or machines. Fantastic!

Global Workspace Manager allows you to group by any column such as the “Project” column. Grouping by “Project” lets you easily see, among other things, when a user last worked on a particular project.

I also gave it a more realistic test. I had a problem workstation where the user was continually complaining that his seedfiles were the wrong ones. Identifying his machine was simple. Next, all I had to do was find the report using the correct project configuration file, highlight it and switch to the “Variables” tab. From there I could group by Variable name and then by File to see each time that the variable MS_SEEDFILES was being set. Sure enough, the project configuration file was wrong.

Even with one just one workstation, finding a configuration variable can be difficult. In MicroStation you have no option but to scan through the “All Alphabetical” list in the Workspace Configuration dialog box if you can’t find it where you think it should be located. For example, did you know that you won’t find MS_RFDIR (the variable that sets the search path for reference files) under the References category? GWM has a search capability for just this purpose. Simply press <Ctrl+F> to find all the variables that contain a particular string.

You can filter any of the columns to show only the item you select, making your views easier to understand. Should you need to, you’ve even got an option to hide all the intermediate values of configuration variables and see only the final value.

Not only was I able to identify the error in the project configuration file, GWM also allowed me to open the project configuration file with a right-click and fix it right then and there. As soon as I saved the project configuration file, GWM asked me if I wanted to save it back to the original workstation. No, I wanted to update the server workspace. That wasn’t a problem either as all I had to do was browse to the correct place. Incidentally, if you make a change that needs to be rolled out to multiple machines, GWM can handle that as well.

Global Workspace Manager allows you to filter data to show a specific variable such as “MS_CELL” and then see each intermediate value as it is defined at each configuration level.

At any point, you can export the data from any GWM grid view to Excel to keep records of your system at key dates. You can refer back to these records if you need to check how things were set up previously. For upgrading or, in my case, maintaining records of any changes made to our clients’ configurations, it’s starting to look invaluable.

The only disappointment for me is that you can’t really say it has an “external configuration interface”. However, when you consider its comprehensive configuration builder and its intuitive and uncomplicated interface, to say it “just allows you to view and edit configuration files” is belittling its usefulness. And hey, it’s only the first release. As the product picks up customers, it’s certainly going to improve. Axiom is always open to development suggestions.

I’d originally thought it was more valuable to the larger organization, but I’ve changed my mind. We’re not large and it could prove very helpful to us. In fact, if you have a need to manage configuration files on servers or workstations, if you’ve got any laptops in the office with MicroStation installed, if making sure your standards are correct in all locations is important, then Axiom’s Global Workspace Manager is something you should seriously consider.

Now, where’s the AutoCAD version?

Evolve Consultancy
For more information about services provided by Evolve Consultancy, contact Nigel at Nigel@Evolve-Consultancy.com.

Want more tricks under your belt? Call now!
To schedule a free, online demonstration or for more information on LearningBay’s e-learning courses, contact an Axiom MicroStation Consultant today! Call 727-442-7774 extension 1448.

Google and MicroStation have baby!

Saturday, 7 March 2009

An Axiom exclusive

Clearwater, Florida, USA — If Google and MicroStation had a baby, what would be the capabilities of their offspring?

The baby could pre-fetch commonly needed information about MicroStation designs and store the data efficiently in a database, ready to provide you with instant answers at any time.

You could ask the baby just about any question about your MicroStation designs and he (or she) could provide an answer instantly.

If you needed to know the status of project reference file attachments or cell usage, the baby could tell you instantly — the baby wouldn’t need to scan hundreds of multi-megabyte design files from top to bottom — the baby would already know the answer!

The baby’s answers would be neatly presented in spreadsheet-like format, and the baby would gladly customize the content for you — sorting, filtering or grouping data any way you can imagine. Of course, the baby would remember your personal preferences and reuse them when he responds to your requests in the future.

Your IT personnel would appreciate the baby just as much as your CAD personnel. The baby could work with your IT department’s existing databases as readily as the baby integrated with MicroStation in your CAD department. In fact, the baby, being so cute and talented, just might unite your IT and CAD departments for the first time!

What if this unbelievably talented baby actually existed?

It does!

The secret Google-MicroStation baby was born in 2008!
This amazing baby is actually the brain-child of Axiom’s founder, David Greenbaum. Axiom announces the release of CadExplorer — the first in a series of releases using a new technology that combines powerful database search engine techniques with CAD.

MicroStation users no longer need to wait minutes or hours for their project files to be scanned for simple (or complex) reports. Just click a button and the report appears instantly (the data was pre-collected earlier and stored efficiently in a database).

The baby’s super powers are unbelievable to mere mortals.
CadExplorer’s unprecedented capabilities almost defy description. Simple statements about the capabilities might sound unbelievable, but are nevertheless true.

With CadExplorer you can:

  • Easily browse any or all project folders, project files, models, levels and elements. You can sort, filter and group this information in any way that you can imagine.
  • Instantly find text, cells and tags in any model, file or project.
  • Identify duplicate files or models anywhere in your enterprise.
  • Instantly discover details about any reference file attachment, in any file or model, in any project. For example, you can get information such as each attachment’s filename, full path, logical name, description and attachment type (vector or raster).
  • Instantly collect information about the usage of cells in any design or anywhere project-wide. For example, you can obtain each cell’s name, cell type (regular or shared), cell description and the unique element ID of each cell instance.
  • Instantly identify odd-ball deviations from project standards in one or many project files.
  • Synergize with your IT personnel in unprecedented ways. IT personnel can generate reports about your CAD projects using the common database structured query language (SQL), Crystal Reports and other tools they are already experts in.

Call now!
To schedule a free, online demonstration or for more information on CadExplorer, contact an Axiom MicroStation Consultant today! Call 727-442-7774 extension 1373 or e-mail 1373@AxiomInt.com.

Making your MicroStation life easier

Saturday, 7 March 2009

Part three of a continuing series of articles on how to customize workspaces to increase productivity

Clearwater, Florida, USA —This is the third in a series of articles on workspaces and what they can do to solve many of your headaches. A workspace is a MicroStation environment or configuration. Customizing your workspace on a per-project basis goes a long way in helping users comply with standards and increase production speed. It also helps reduce potential errors caused by using incorrect resources (such as fonts, text styles, line styles, macros, seed files and dimension styles) and saves on mouse clicks. While we recommend that you read the previous articles, I’ll provide a lot of information in this article that you will be able to use whether you’ve read the previous articles or not. However, if you find yourself getting stuck or having some difficulty understanding something in this article, I recommend that you read the first two parts of this series, as those articles contain definitions for many of the terms used in this article. [Editor's note: See Part 1, "MicroStations little known secret saves massive amounts of time and money" and Part 2, "Optimizing MicroStation workspaces for faster production" for previous articles on workspaces. You can also find all articles on workspaces by clicking here.]

You can reduce potential errors caused by using the wrong resources such as fonts, line styles and seed files by correctly configuring workspace variables.

Making projects easier
Anyone working on more than one project will benefit from optimizing workspaces (and that’s an understatement). If there’s more than one person working on the same project, the benefits will be compounded. Improved productivity and quality are two benefits of a well-designed workspace. Getting you home on time is another.

When you use the MicroStation Manager dialog box to open a design file, how your design environment looks and behaves is determined by hundreds of settings inside MicroStation. A major portion of these settings are determined by something called “configuration variables”. Just like the name sounds, these are variables (things you can give different values to in order to cause different things to happen) that configure (set up) MicroStation for you. These configuration variables control many things. For example, they can control what resources can be made available for you as you design. By “resources” we mean things such as font libraries, text styles, line styles, macros, cell libraries, seed files and dimension styles, to name a few. [Editor's note: It's actually amazing just how much easier life can be if you know how to get MicroStation to do a lot of the work for you. That's what this article is all about.]

Configuration variables reside in configuration files. When MicroStation starts up, it processes configuration files in a hierarchy referred to as “configuration levels”. These levels are processed in a predefined sequence starting with the system level, then going to the application level, the site level, the user level and the project level. One type of configuration file is the “project configuration file”. The project configuration file is the last of the configuration files to be processed and includes configuration variables that are used to load the right resources for the specific project. Unfortunately, many users never take advantage of the power of the project configuration file. Setting each project’s standards once in a project configuration file and using that file over and over saves hours (possibly hundreds or even thousands of hours) in making corrections to design files (due to some wrong resources being used) and in browsing around the network searching for project resources.

Setting up a standard folder structure for all projects helps users know where to find the resources they need and helps prevent CAD anarchy.

Before I go into how to set some of the variables in your project configuration files, I want to mention something on a related topic. One of the main problems that I’ve encountered when working with a project’s design files is that companies don’t always use the same folder structure for each of their projects. This leads to inconsistent locations for project resources which results in users having difficulty finding the needed resources. Also employees that are trained on one project will then have difficulty locating resources when working on another project due to inconsistent folder structure. This is easily handled by simply deciding on a folder structure that all projects will have. Some projects will have a few unique features, but that just keeps life interesting. When you develop a standard folder structure, be sure to keep all project data together.

I remember restoring a 12-year-old project from tape. We had all the design files, but no pen tables, cell libraries, color tables or fonts. They all had to be recreated or gathered up from other sources. Now I keep all project resources together with the project deliverables. You can use sub-folders to help keep things organized. That way, when you archive a project, you know that you won’t have to waste time recreating or searching for project resources some time in the future.

Also, users depend on the standards folder having the correct resources. If unauthorized changes get made to these files, users will have a tendency to make unauthorized copies to ensure that they have the “right” files. The best way to set this up is to keep your company CAD standards in their own separate folder and make the files “read-only” to everyone that has no reason to modify them (which will be mostly everyone except the CAD manager). This prevents CAD anarchy (not a pretty sight).

Configuring project variables
As mentioned above, the project configuration file contains configuration variables that are used to load the right resources for the specific project. Before we start changing the project configuration file, you first need to know a bit about how configuration variables are set up in a configuration file. MicroStation uses these configuration variables to determine information such as where your project resources are located. For example, if the font you need to use for a particular project is stored on a network drive, you will want MicroStation to know the name of that network drive, so it can make that font resource available.

In order to change your project configuration variables, you first need a project configuration file. As a starting point, you can use a file called “untitled.pcf” which gets delivered with MicroStation. By default, this file is stored in the WorkspaceProjects folder. Although you can use this project file as is, many companies develop their own project template or adopt one from one of their larger clients.

Each configuration variable in your project configuration file is listed on a single line. The most common way to configure a variable is to use the following syntax:

<VARIABLENAME> <operator> <new_value> # comment

The first three parts are required and the last, “# comment”, is optional. The first part is a variable name such as “MS_DEF”. [Editor's note: The value set for the variable MS_DEF tells MicroStation the location of the folder to open for design files (it sets the default folder that will be the first one that comes up when the user clicks on File|Open)]. Variable names can only contain alphanumeric characters (A-Z, 0-9) and must be at least two characters long. Although variable names are not case-sensitive, uppercase letters are used by convention. As a note, nearly all variable names used by MicroStation begin with “MS_” or “_USTN_”.

The next part is called an “operator”. An operator is a symbol that represents some function. In most cases, you will be doing one of four things:

  1. Assigning a value to a variable using the equal sign (“=”).
  2. For example, let’s say that you wanted to use the file “2dEnglishGeneral.dgn” as the default seed file. The variable name that MicroStation uses for this is “MS_DESIGNSEED”. To assign the file “2dEnglishGeneral.dgn” to this variable, you would use the “=” symbol as below:

    MS_DESIGNSEED = 2dEnglishGeneral.dgn

    I’ll go over more examples later in this article.

  3. Adding a folder or file to the end of a variable definition that defines a path that’s already in the variable (called appending) using the “>” symbol.
  4. For example, let’s say that the configuration variable “MS_CELL” was previously defined as “F:CellMyCells”. However, for the purposes of this project, you also want to have the cell libraries stored in “G:MyCells” available. Although you want the cell libraries stored in “G:MyCells” to be available, the cell libraries stored in “F:CellMyCells” should be searched first. In this case, you don’t want to assign the value “G:MyCells” to the variable “MS_CELL” but instead you simply want to add the value “G:MyCells” to the end of the available paths for MicroStation to search when searching for cell libraries. To do this, you would use the “>” symbol. For example, assuming that “MS_CELL” was previously assigned the value “F:CellMyCells”, then you would append to this by using the following:

    MS_CELL > G:/MyCells/

    Note that file path names should be entered using a slash mark (“/”). Windows converts all forward slashes (/) in values assigned to variables to backslashes (). Also, all folder definitions should end with a trailing forward slash.

    The new definition for “MS_CELL” is now “F:CellMyCells; G:MyCells”. You’ll notice that there are now two paths separated by a semicolon. When you append or prepend a path to an existing variable, MicroStation automatically separates the paths using a semicolon.

    This means that MicroStation will first look for cell libraries in the “F:CellMyCells” folder and then look in “G:MyCells”.

  5. Adding a folder or file to the beginning of a variable definition that defines a path that’s already in the variable (called prepending) using the “<” symbol.
  6. Sometimes, you want to do the opposite and place a file path at the beginning of the list. To do this, you use the “<”symbol. For this example, let’s say that the configuration variable “MS_CELL” was previously defined as “F:CellMyCells”. However, you want “G:MyCells” to be searched first. To do this, you would use the “<” symbol. For example, assuming that “MS_CELL” was previously assigned the value “F:CellMyCells”, then you would add to this by using the following:

    MS_CELL < G:/MyCells/

    The new definition for MS_CELL is now:
    “G:MyCells; F:CellMyCells”. This means that MicroStation will first look in the “G:MyCells” folder and then look in “F:CellMyCells” when searching for cell libraries.

    As a note, if you append or prepend a value to a variable and that variable has not previously been defined, then the variable is now defined as that value. In other words, MicroStation treats the “<” or “>” symbol as an “=” symbol if the variable has not been previously assigned a value. As an example, if the variable MS_CELL had not been previously defined and you used the following in a configuration file:

    MS_CELL < G:/MyCells/

    The new definition for MS_CELL would be “G:MyCells”.

  7. Assigning value to a variable (where that variable doesn’t yet have a definition), using the “:” symbol.
  8. The “:” symbol works just like the “=” symbol except that it will only assign the variable a value if that variable has not yet been defined (in other words, if that variable currently has no value). This is useful when you want to ensure that a variable has a value but you do not want to overwrite an existing value for that variable in cases where a value has been assigned for that variable on a previous level.

    For instance, let’s say that you want variable “MS_DESIGNSEED” to be assigned the value “2dEnglishGeneral.dgn” but only if the variable “MS_DESIGNSEED” has not been previously defined. To do this, you would use the “:” symbol as follows:

    MS_DESIGNSEED : 2dEnglishGeneral.dgn

    As long as the variable “MS_DESIGNSEED” had not been previously defined, then “MS_DESIGNSEED” would now be defined as “2dEnglishGeneral.dgn”. If this variable had been previously defined, then the statement above would simply be ignored (the previous definition would not be changed).

    After the operator, the last required item is the value being assigned or added to the variable. Here’s an example showing how to assign the value “C:” to the variable “LOCAL_DRIVE”:

    LOCAL_DRIVE = C:

    The last item, which is optional, is a comment. Comments are preceded by a “#” symbol. It is good to comment all changes for those who look at the configuration file in the future, even if it is you. MicroStation will ignore anything after a “#” symbol in a configuration line. For example, MicroStation will ignore the string “Local drive for non-networked resources” in the line below:

    LOCAL_DRIVE = C: #Local drive for non-networked resources

Getting the most out of variables
Now that you understand how to put together the configuration variable, let’s look at how to efficiently set up some variables by first defining one variable and then using that variable to define another variable. This is useful when assigning a variable like a network drive that may change over time. For instance, let’s say that the network drive that you are using is “O:”. You could simply use “O:” as part of the path for all of your different resources on that network drive. However, if the network drive changes for any reason, you would have to go back through all of your configuration files and change any configuration variables to the new network drive. There’s a better way to do this using “variable references”. What this means is that the value stored in one variable can be used when defining another variable. To do this, first set the “NET_DRIVE” to “O:” (as an example). In subsequent configuration variables, rather than using “O:” as part of the value for a configuration variable, I would simply refer to the variable “NET_DRIVE”. This way, if the network drive ever changes to a different drive, I simply change the “NET_DRIVE” variable in one location and my other configuration variables (that reference the “NET_DRIVE” variable) are automatically assigned the correct information. The above gives us the general rule that you shouldn’t explicitly assign folder paths to a configuration variable unless it’s the first time you’re assigning that path. After that, you should simply refer to the variable that was first assigned the value. Let’s see how this would be done.

Below are the four variable definitions that I use in my site configuration file. Note that these are variable names that I have created. All other variables that I define use variable references to either these variables or to default variables (variables that get defined automatically when MicroStation is installed). The four variable definitions that I use in my site configuration files are as follows:

NET_DRIVE = O: #Drive location for ­network workspaces and projects
LOCAL_DRIVE = C: #Local drive for non-networked resources
PROJECT_DIR = /Projects/ #folder used for project configuration files
WORKSPACE_DIR = /CADStandards/ #folder used for specific CAD standards resources

When MicroStation starts it will assign variables as follows:

_USTN_PROJECTSROOT=$(NET_DRIVE) ­$(PROJECT_DIR) #Location of project files on network
_USTN_WORKSPACEROOT = $(NET_DRIVE) $(WORKSPACE_DIR) #Location of workspace files on network

An obvious question would be “What the heck does ‘$(NET_DRIVE)’ mean?” “$(NET_DRIVE)” means to use the value of the variable “NET_DRIVE”. This is called “variable referencing” which means that a variable is defined by using the value of another variable. The most common way to use variable referencing is by putting parentheses around the variable name precede it by a “$”. For example:

_USTN_PROJECTSROOT = $(NET_DRIVE)$(PROJECT_DIR) #Location of project files on net

If “NET_DRIVE” was “O:” and “PROJECT_DIR” was set to “/Projects/”, then “_USTN_PROJECTSROOT” would now be set to “O:/Projects/”. If I ever need to change that to a different drive, I simply change the “NET_DRIVE” variable (in the site configuration file) and my user and project configuration variables are automatically assigned the correct information. Remember to use forward slashes (/) inside the value for the variable. When MicroStation processes this, forward slashes (/) will be converted to backslashes () automatically.

The “_USTN_PROJECTROOT” and the “_USTN_WORKSPACEROOT” variables are the variables designed to define the root project and workspace folders respectively. By setting the variables as above, if someone decides to upgrade the server or tells me that I need to move files from one drive to another, I only have to change the drive letter and folder names in one place. Since my user and project configuration files use a variable name (that was defined at the site level), I don’t have to make any further changes. As long as I’m connected to the network, I always have the most up-to-date company and project resources.

Creating paths
Earlier, I said that you can prepend (using the “<” sign) or append (using the “>”) information. Prepending and appending is different than assigning (using the “=”) a value to a variable. When you assign a value to a variable, that variable is now equal to that value. When you prepend or append information to a variable, you’re adding to the existing value of the variable rather than overwriting an existing value.
For instance, system and site level settings are set to cover standards that should be used when a client has not specified a project standard to use. However, if there are client-specified standards such as your cell libraries that need to be used, then I want to have MicroStation search for that information first, before looking at the settings on the system or site levels. If I were to simply assign a value (such as “O:/Projects/I-75/Cell/”) to the variable “MS_CELL” at the project level, then that would be the only folder path defined for that variable. This may be okay if this held all of the cell libraries that I could possibly want. But what if I also want to have other libraries available as well such as my cell libraries that are defined at the site level but wanted to have MicroStation search my project level folder first? To do this, I can prepend an additional folder to the value stored in the variable “MS_CELL”. By prepending or putting your project folder in front of the MicroStation default folders (which are usually set by MicroStation when it was first loaded or by a CAD manager), your project cell libraries will be searched first by MicroStation. This improves the productivity of your users by reducing the number of mouse-clicks to locate your project cells.

Let me show you how this all fits together. First, we’ll look at some variables that were defined at the system and user levels and then we’ll prepend a cell folder at the project level using these variables. (Note: We will not be modifying a value that was set at the user level with a value set at the project level. You cannot do that. Instead, we will reference the value of a variable that is set at the user level to define a variable at the project level.)
For this example, let’s assume that the two following variable assignments are made at the system level:

_USTN_PROJECT: $(_USTN_PROJECTSROOT)
_USTN_PROJECTDATA: $(_USTN_PROJECT) $(_USTN_PROJECTNAME)/

Additionally, we’ll assume that the following variable was set at the user level:

_USTN_PROJECTNAME = I-75

After processing, “_USTN_PROJECTDATA” is now defined as:

“O:projectsI-75″

Now, at the project level, we can define where the project cell libraries will be found:

MS_CELL < $(_USTN_PROJECTDATA)cell/

Assuming that the value for “MS_CELL” was set at both the system and site level (which it typically is) the value for “MS_CELL” now includes “O:/Projects/I-75/Cell/” as part of it’s definition. So typically, the full definition for this variable (including the prepend you just made) would be:
O:/Projects/I-75/Cell/;C:/Program Files/Bentley/Workspace/Projects/System/cell;C:/Program Files/Bentley/Workspace/Projects/Standards/cell/
A semi-colon is used to separate the folders in which MicroStation will search for files. If the variable MS_CELL had not been previously assigned, then the full definition for this variable (after the prepend you just made) would simply be:

O:/Projects/I-75/Cell/

With Global Workspace Manager, the CAD manager can monitor and control workstations anywhere in the world without leaving his desk.

By the way, Global Workspace Manager is a great way to monitor and maintain a few or a few thousand workspaces and see what variables have been set at which levels and change them — easily — as needed.

Tips & Tricks — Import Microsoft Office text into MicroStation without messing up the text height.

Saturday, 7 March 2009

By Rick Sewell
Do your Excel spreadsheets ever import into MicroStation with the right text height? The answer from many MicroStation users across the country is a resounding “No!” Thus, these MicroStation users are forced to either manually type their text using MicroStation’s “Place Text” tool with the correct text height or paste the text using one of MicroStation’s “Paste Special” options (which does not even paste your text correctly formatted unless you paste it as a raster image which can never be edited) and then scale it using MicroStation’s “Scale” tool. This process could take hours or even days depending on the amount of text that needs to be added to a design file.

Integrating Microsoft Office Importer into your workflow allows you to solve the problem of incorrect text height by allowing you to set the correct text height in the Microsoft Office Importer Settings dialog box. Once that’s done, you can import spreadsheet and word processing data into MicroStation with perfect formatting.

MicroStation users frequently need to have text at an exact height when placed into a MicroStation design file. That’s one reason why thousands of MicroStation users have adopted Microsoft Office Importer as their tool of choice for importing Excel spreadsheets and Word documents into MicroStation. Microsoft Office Importer allows you to set, among other things, the height of the text to be placed when you import spreadsheet and word processing data into MicroStation with perfect formatting.

How does it work?
Microsoft Office Importer looks at the point size of the font of the text in the source file (an Excel spreadsheet, for example) and assigns a user-defined number of MicroStation master units to each point. Larger or smaller text is then scaled based on the same ratio of number of master units per point of font size. For example, if you set Microsoft Office Importer so that each point of text size is equal to 0.5 master units, your ten-point text from a spreadsheet would be imported into MicroStation as five master units tall. If you were importing 20-point text, it would come into MicroStation as double that or ten master units tall.

Figure 1: With Microsoft Office Importer, when you import text from your spreadsheet, you can set it up so it will come in at the exact height you want, every time!

How to set text height and width
In order for your text to look right, you have to address its width too. It’s easy to set this in Microsoft Office Importer. Just follow the steps below. For this example, let’s say that you wanted text to come in at a height of 0.5 master units and you wanted the text width to be 80% of the height. [Note: By default, Microsoft Office Importer sets the width of text to be 80% of the height. This is a fairly common ratio in the world of font-sizing. However you can change that ratio to whatever you like (see below).] The height that you specify will be the height that the tallest letter (text character) will be when placed in the design file. Usually this height is the same as the height of a capitalized letter.

Figure 2: If Microsoft Office Importer’s toolbar is not open, select “Axiom | Microsoft Office Importer | Load Microsoft Office Importer for V8″ (or “V7″ if you are using V7).

  1. Push Microsoft Office Importer’s <Settings> button on Microsoft Office Importer’s toolbar. The <Settings> button is the one on the far right.
  2. Then choose the “Size” tab.
  3. Figure 3: On the “Size” tab of the Microsoft Office Importer Settings dialog box, you can select the exact height-to-width ratio that you want text to be when you place it into your design file.

  4. If the height-to-width ratio is unlocked, click on the <lock> icon to lock the height-to-width ratio. Notice that, by default, it is set to a height of “1.0″ and a width of “0.8″ (as shown in Figure 4). By locking it at this ratio, any number you type in for height will cause the width value to change so that it’s 80% of the height. [By the way, if you ever want a different height-width ratio, just unlock it, change the values in the height and width fields to whatever you want, then re-lock.]
  5. Figure 4: If the height-to-width–ratio lock icon is in the unlocked position (as depicted above), then click on it to lock it if you want to maintain the same height-to-width ratio of the height and width shown in the dialog box.

  6. Next, type “0.5″ in the “Height” field. Because the height-to-width ratio was locked at a height of “1.0″ and a width of “0.8″, the width will automatically change to “0.4″ (80% of the new height) as soon as you press on the <Update> button.
  7. Figure 5: Once you have clicked on the <Update> button, any new Microsoft Office Importer pastes will have the height-to-width ratio you specified.

  8. Press the <Update> button for the changes to become active.
  9. These settings will affect any new Microsoft Office Importer pastes in future sessions of MicroStation as long as you save the settings with “File | Save Settings” from the Microsoft Office Importer Settings dialog box.
  10. Press the <OK> button on the dialog box.

That’s it! You have just set your text height and width to exactly what you want. Now do all your text imports with Microsoft Office Importer and all your text will have perfect formatting.

Fix dead design files fast!

Saturday, 7 February 2009

New release now works with V8i

Clearwater, Florida, USA — When design file corruption slows your project down — or worse, brings it to a halt — you don’t have time to mess around. You need the file salvaged now! You need help. FileFixer for V8 gives you that help fast. The latest version from Axiom handles MicroStation V8i files too.

FileFixer continues the tradition of repairing corruption by adding support for design files created by the latest MicroStation version, V8i.

Have you ever had a design file that wouldn’t open? Have you ever been frustrated with MicroStation elements or models that behaved oddly? Have you ever had problems with plotting? For over 20 years, FileFixer has been the tool of choice for CAD managers and CAD users alike to fix these issues. FileFixer gives you the exact technical data you need to understand what’s wrong with your MicroStation V8, XM and V8i files and to fix them fast!

When you run FileFixer, it generates a hyperlinked report. Clicking on a link in the report takes you to the exact user’s guide paragraph you need, speeding your full understanding of the problem, so you can fix your design file that much faster. Here’s how it works: Say you’ve got a project deadline on your hands and a dead design file that FileFixer is reporting as having error “619″. [Editor's note: FileFixer for V8 reports error 619 for elements which have one or more coordinates dangerously close to or outside the design plane or cube.] You probably don’t have a lot of time to study up on the different forms of file corruption, because your boss wants the project done now! The great thing is there’s no research required! Just click on one of the report’s hyperlinked error numbers and a detailed explanation of that error is displayed on your screen. These report hyperlinks provide the shortcut that power users have come to depend on. Of course, if you’re really in a hurry or you don’t need to understand the problem — you just want it fixed — you can still ignore the report entirely and just let FileFixer work its magic automatically. The choice is yours.

In addition to the hyperlinks in the reports, specific help like this is also available for all FileFixer’s settings dialog boxes such as General Settings, Search Settings, Repair Settings and so on.

Using its default settings, FileFixer can detect and repair the vast majority of design file corruption automatically. But let’s face it, design file corruption is infinitely diverse. Any bit, containing “0″ or “1″, out of the millions of bits in a large design file, can potentially contain the wrong value and corrupt the file. To handle this broad range of potential corruption, MicroStation users may need to use FileFixer’s non-default search or repair settings to fully salvage a file. Each of FileFixer’s search and repair settings are thoroughly described in its user’s guide, including advice for when each setting should be used. But what’s the fastest way to find the exact search or repair setting needed to bring a corrupted file back to life?

Each FileFixer settings dialog box includes a help button that immediately displays the relevant section of the FileFixer user’s guide. Instant access to the precise help you need!

With FileFixer, you will never be more than a mouse click away from the exact help you need in order to understand why a design file is misbehaving and what to do about it.

When solving design file problems caused by corruption, FileFixer context-sensitive help is always just a click away.

Smart CAD managers know FileFixer is not just for emergencies. That’s because you can also use FileFixer for preventative maintenance. By simply scheduling regular searches for problems in all of a project’s design files, FileFixer can detect and handle damaged files before they impact projects.

Entirely new forms of file corruption have been discovered in V8 files submitted to Axiom by MicroStation users. FileFixer is the only application that can open and salvage the most severely corrupted design files. There is no other solution.

Easily modify all your MicroStation tags with just a few mouse-clicks.

Saturday, 7 February 2009

By Rick Sewell
It seemed a typical day as I manned Axiom’s Technical Support phone lines. Calls were coming in with the usual questions. Yes, Global File Changer will replace cells in all of your files in one shot. Yes, FileFixer will repair your file. Then I received a call from a fellow with a question that was quite out of the ordinary.

Changing tags in hundreds or thousands of design files can be done quickly and easily if you have the right tool.

He was looking for something that would allow him to extract tag values from his design files to an external database and also allow him to manage the tag values from there. He needed to do this not on just a single project either but “thousands of DGN files,” he said. “A real, hairy-monster of a job.”

My first thought was that we could likely custom program something to do the job. I didn’t know of any Axiom tools out of the box that would do it. Needing more information in order to give the problem a proper assessment, I had the customer send me some sample files to analyze.

As I opened each sample DGN file, I noticed that all the files were nearly identical. Each file contained a series of cells with five tags associated with each cell. They looked like a bunch of baby title blocks. Title blocks? That’s it! Title Block Manager has the ability to extract tags directly from MicroStation and copy them into Microsoft Excel! [Editor's note: "Tags" are database-like elements that may be attached to graphical elements in design files in order to provide more information about the graphical element (or elements) tagged. Tags can be displayed graphically.]

Just as the name indicates, Title Block Manager was designed to handle title blocks. The initial Title Block Manager release didn’t handle tags. However, it was later discovered that a number of customers used tags in their standard title blocks. To accommodate those users, we enhanced Title Block Manager to extract selected tag values (instead of extracting only regular Title Block Manager text elements from title blocks). This is when the universe opened up.

The new tag handling feature in Title Block Manager isn’t limited to just handling tags in title blocks. It allows you to extract tag values from any tag set in any set of design files! It’s like we have another application entirely living inside of Title Block Manager. We should call it “Tag Manager”. [Editor's note: A "tag set" is a set of associated tags. Each and every tag is part of a tag set.]

Check it out. Figure 1 shows some tag values within a DGN file. In this file, the tag values represent unit numbers in an apartment building.

Figure 1. In this sample design file, the number on each apartment door is a value of a tag. With the right tool, you can extract all your tag values from all your DGN files and have them automatically entered into a Microsoft Excel spreadsheet. Once there, you can quickly modify as many tag values as you like and put them back into your design file.

This design file contains six occurrences of a tag set (the same tag set is attached to each apartment door). This particular tag set contains three tags. One of these tag names is “Unit Number”. Each tag in a tag set can be given a different value. In this case, the tag values of each of the six “Unit Number” tags are “101″, “102″ “103″, “201″, “202″ and “203″.

Title Block Manager will take each of these values and place them elegantly into a spreadsheet (or a database) by creating a row in the database for each occurrence of each tag set that was placed in the DGN file. Figure 2 shows the actual tag data extracted from the sample design file. Each row in Figure 2 is a record of an instance of a tag set attached to an element. Column B, with the header “TBlockID”, contains the name of the tag set (in this simple example, we are using only one tag set, named “Apartment”). The next column shows the element ID number of the element that was tagged. The heading of each of the next three columns (in Figure 2) contains the name of each tag in the tag set. Notice that the tag set “Apartment” contains three tag names — “Unit Number”, “Size” and “Resident”. Each tag name becomes a column heading in the Excel spreadsheet. Within each field under each tag name, you see the value of that tag for the given element. For example, for element number 461 (the lower left apartment door), the tag value for tag name “Unit Number” is “101″. For that same element, the tag value for tag name “Size” is “2-Bedroom”, and so on.

Figure 2. Title Block Manager automatically, elegantly places all of the essential tag data into an Excel spreadsheet.

You can process all your design files and have a complete library of all the tags used in your files. Being able to do that is pretty impressive. But that’s just the half of it. You can also modify your tag values in the spreadsheet and write the modifications back to your design files!

In Figure 3, I’ve changed all the tag values listed in the spreadsheet under the “Unit Number” column heading from “101″, “102″, “103″, “201″, “202″ and “203″ to “1A”, “1B”, “1C”, “2A”, “2B” and “2C, respectively.

Figure 3. Title Block Manager lets you quickly change tag values in Excel and then easily write them back to your design files (compare the above to the values for “Unit Number” in Figure 2)

With nothing more than a few mouse-clicks, Title Block Manager will write the newly changed values back to the design file. Here is the result (Figure 4):

Figure 4. Tag values are updated in all your design files in about one second per design file modified.

Remember, you can process all your design files here. So go get your tag-laden design files and start having some fun with them.