Warning: This is Part 2 of a 4 part series on merging Autodesk Fabrication Databases. Autodesk Fabrication software is extremely powerful and flexible but that also makes it very fragile. Use the below guidance with caution. I highly recommend backing up your configuration before attempting anything I’ve recommended. It never hurts to have a firm grasp of how Autodesk Fabrication functions from an administrative perspective. Consider yourself warned!
Method 2: ITM’s as Proxy
Another method of transferring data from one database to another is by using ITM’s. Simpy take an existing ITM or make a new one and set some of it’s properties to those you want to transfer. After you’ve completed this, copy the ITM to your desired database.
In your desired database, right-click on the newly copied ITM from the Folders view and select Edit or Properties as shown below.
Once the Edit Item or Item Properties dialogs are displayed, you can simply close them. The only purpose in calling them up was to force Fabrication to read all of their settings which in turn causes them to be created as Proxy entries in your database if they don’t already exist.
Once the database entries are in your new database, you’ll want to navigate to those database entries and make the proxy items permanent as shown below.
Pros: > Every property an ITM uses is supported. > Dependent database entries supported (e.g. Fixings on a Support) Cons: > Can bring in more properties than you want which need to be cleaned. > Time consuming for large property sets as multiple ITM’s required. > Proxy items must be manually made permanent afterward
Warning: This is Part 1 of a 4 part series on merging Autodesk Fabrication Databases. Autodesk Fabrication software is extremely powerful and flexible but that also makes it very fragile. Use the below guidance with caution. I highly recommend backing up your configuration before attempting anything I’ve recommended. It never hurts to have a firm grasp of how Autodesk Fabrication functions from an administrative perspective. Consider yourself warned!
You shouldn’t find yourself merging parts of different Fabrication databases very often. If you do, you may want to revisit your database management workflow and practices.
However there are a number of legitimate reasons you may do it. Most common is the database you’re using now isn’t the one you used a few years ago because you started over. It’s common for a Fabrication database to be a mess. They’re hard to learn and understand and while you learn, you do a little damage unknowingly. Maybe it’s turnover of the staff managing your configuration. Each new person will say they know how to manage Fabrication and what you’re doing is wrong. So they fix it. In the end, you end up with a mix of database management “Styles”.
And last but not least, it’s because trades men and women manage your data. Don’t get me wrong. Your trade staff are hands down the most qualified to manage an Autodesk Fabrication configuration. This is why the task gets assigned to them. But ultimately, what do companies “want” them to do? Detailing and modeling….run piping, plumbing, sheet metal, electrical, etc. Management more often than not pushes them to get back to modeling because management really doesn’t understand the importance of a good database. This leads to shortcuts and mismanagement through no fault of those doing the work. They’re doing the best they can given the constraints their under.
Whatever the reason, if you need to merge parts of different Fabrication Database configurations together, I’ll explain four different methods in the coming posts.
Method 1: Importing / Exporting Database Items
Export/Import Database is the most commonly used method. It’s also the most widely know. In 2014 and earlier versions, many of these were separate commands for each part of the database. In the 2015 version, they were wrapped up in a single command. This process allows you to export and import the following items…
Ancillaries (except Kits)
To initiate the Export process, type DBEXPORT at the command line in CADmep. In CAMduct or ESTmep, select File -> Export -> Database Export from the menu as shown below…
Once you start the command the Database Export dialog is displayed. You can switch tabs and select various database entries to export.
Once you’ve selected the items you wish to export, click OK and save the export file.
This *.IOX file contains everything you selected for export. You can then use this file to import those settings into another database configuration. The process for importing is very similar. Type DBIMPORT at the command line in CADmep or pick File -> Import -> Database Import in ESTmep or CAMduct from the menu shown below…
Upon initiating the command, you’re prompted to select an *.IOX file for import. Select the file you wish to import and click OK.
After selecting the file, you are presented with a dialog just like the Export dialog. In this one, you can navigate the various tabs and select what you would like to import.
There is no good way to see what’s available for import without checking all of the tabs. Only items included for export will be displayed. You can pick and choose to import some or all of the items that were in the export file.
If an item you are importing already exists, you can choose to Skip, Duplicate or Overwrite the item. A word of caution, if your configuration has not been managed well, be very careful selecting the Apply to All button. There are times when the items Fabrication thinks are duplicate are indeed different items. This can be due to database corruption or misaligned indexes or any number of other reasons. If you’re concerned, select Apply for each item one at a time to verify the duplicates aren’t unexpected.
Pros: > Easy to use > Most common items supported > Dependent items (e.g. Ancillaries attached to a Support) are included even though they are not displayed. Cons: > Not all database areas supported (e.g. Materials, Ancillary Kits, Notches, etc.)
If you’re a full time professional software developer, this is likely old news. For the rest of those who fall into the “Self-taught”, “Part Time” or “Recreational” category it may surprise you that Microsoft has a magazine dedicated to software development.
MSDN (Microsoft Developer Network) has put out the MSDN Magazine for almost 2 decades. You can access old issues here…
Did you know Autodesk makes extensive use of several open source technologies in their products? If you’re curious, they maintain a list as well as the distributions. Click Here if you want to check it out.
It’s no secret that Autodesk regularly changes their pricing structure. Here are some upcoming changes you should be aware of….
NEW “Multi-User” Subscriptions for “Collections” will increase an estimated 33% on February 7, 2020.
NEW “Multi-User” Subscriptions for “Single Products” will increase an estimated 14% on February 7, 2020.
It’s my understanding that existing multi-user licenses that are renewed are not subject to the price increase.
Reading between the lines, it appears Autodesk is slowly trying to eliminate network licenses. Obviously, they would rather sell you two licenses as opposed to have you share onE between two users.
Based on over a hundred hours of license usage research in my last two employers in the MEP Engineering and Construction space, here’s the breakdown I’ve seen…
2 to 3 Engineers can share a single license (this is what Autodesk wants to reign in)
1 to 1 User to License ratio for trade detailers
1/3 of company users fall into the very low usage…”once or twice a month” or “once a week for a half hour” category (if you have enough network license capacity)
What Autodesk fails to realize (or ignores) is that there are a couple reasons network licenses are important even if you can’t share a license. Those are the last two of the above bullet points.
1) Very Low Usage
Users who “Would” use products but don’t “Need” then get access. This can lead to future sales if usage increases. It can also help promote product knowledge to a larger audience.
2) Licensing Usage Analytics
If you’re trying to migrate users from AutoCAD to Revit, or implement other product roll outs, analytics are important to gauge adoption. It also helps you plan for the future.
Yes, Autodesk has some analytics but they’re completely inadequate for anything truly meaningful. In fact, they’re often misleading which lends itself to over licensing…which they like. For a better reporting tool, check out JTB Flex Report.
A Word About Perpetual Maintenance Subscriptions
There’s still some folks hanging on to their old perpetual maintenance licenses. Let me tell you here and now that’s a waste of time and money. On August 31, 2019, Autodesk ended support for 2010 and older versions. There’s no guarantee your old products will activate into the future.
As a lot of customers are finding this year, 3 years in to subscriptions, it’s cheaper to convert to subscription than maintain a perpetual seat. Perpetual seats are anticipated to increase another 20%. Additionally, if you convert to subscription now, it’s still cheaper than a new subscription. Autodesk has announced that Perpetuals converted to Subscription will not have any more than a 5% increase every OTHER year through 2028. This means you’re converted seat will be cheaper than a new subscription for a long time.
Yet another reason is that Autodesk controls licensing. It’s 100% in their control. Let’s take Navis Manage as an example. You could keep hanging on to it but all they have to do is say it’s no longer a valid product…it’s ends of life. And your only option is to buy a full new subscription of this new “Navis Quantum” product (I just made that up….just like they can) that replaces it.
The last reason to switch to subscription now, it’s your last chance. I’m hearing that in May 2020, you’ll no longer be able to convert your perpetual license to subscription. This means they can jack up the perpetual maintenance as high as they want and if you don’t like it, you’re left dropping it and buying a full subscription seat. If you’v been around long enough, you know they’ll run a promotion here and there offering a discount to convert to the few remaining holdouts. But the promotional discounts typically only applies to the first year…every other year you’re paying the full subscription costs.
If you’re still on maintenance, consider switching before May. For more information on Maintenance to Subscription, check out this Autodesk FAQ.
PS: Autodesk’s Fiscal Year End is January 31. Now’s the perfect time to make the changes to your licensing. I always structure mine to renew in January for that reason.
I have updated the Autodesk Fabrication COD Scripting resources. Resources have also been reorganized. Everything is still there but you may have to navigate to it differently.
Most of the updates are additions to the COD Scripting reference. They now include all the information that was in my Advanced Scripting sessions at MEP Force and Autodesk University.
A complete list of all COD Scripting resources can be found here. The COD Language reference is a complete list of all properties, functions, operators, keywords, and anything else scripting that I’m aware of. Everything I know about COD Scripting both documented and undocumented is located here. If you notice properties or functions in COD scripts of yours or from others that is not listed here, please let me know. I’d love to add anything new you find.
In a recent LinkedIn post, the topic of Tolerance Stacking was brought up. I’m not a machine designer, but I’ve spent a lot of my past life in Manufacturing. In that world, the term was used frequently. If the term was used in Construction, it certainly wasn’t when I was listening.
Tolerance Stacking can be described (in my mind) as the accumulation of allowable tolerances to a point where the design is no longer suitable for it’s intended purpose. Errors resulting from Tolerance Stacking are caused by a few things…
Lack of tolerance awareness
Poor annotation and documentation of tolerances
Both of the above
Tolerance Stacking Explained
The best way to understand Tolerance Stacking is from a few examples. In our first example, we see a part 10 Units long with 9 holes, equally spaced 1 Unit apart. Take note of the RED dimension on the right.
You may have seen parts dimensioned like this. Looks pretty normal. Now lets consider this same part and assume the dimensions have a tolerance of +/- 0.0625 (1/16 Inch). Now lets also assume that all the dimensions are in the negative -0.0625. The following graphic illustrates this condition. Again, notice the RED dimension on the right.
Is the overall length really have enough tolerance to compensate for the accumulation of those tolerances?
Now lets look at the same part, same tolerances but annotated/documented differently. It’s not as “pretty” and takes up a lot more real estate on your drawing.
But lets look at that same -0.0625 extreme case tolerance in this scenario. Once again, keep an eye on that RED dimension to the right.
This latest example solves the Tolerance Stacking issue by clearly outlining where the tolerances are allowed. In fact, in construction, we’re already doing this. We just don’t call it Tolerance Stacking.
In construction, one of the ways we eliminate Tolerance Stacking is by dimensioning to gridlines and columns. Dimensions in relation to known fixed points minimized Tolerance Stacking.
Are you old enough to remember when rafters were layed out by hand on the job site and cut individually? You would cut one and use it as a template and use that to mark the others. You never installed the template and used the next cut as your template for another. This minimized Tolerance Stacking as well.
Geometric Dimensioning and Tolerancing – GDT
What’s less familiar, is another concept used heavily in automotive and other precision manufacturing. It’s called Geometric Dimensioning & Tolerancing or “GDT” for short.
Traditional linear tolerances have flaws. GDT on the other hand more accurately describes “features” and allowable deviation from the desired location using a more complex form of graphics and symbols.
Once again, the best way to explain this is with some illustrations. The following example shows a square part with a hole in the middle. Pay close attention to the RED dimensions.
In this example, you see when the hole is moved to the maximum tolerance in both directions, it’s actually further away from it’s desired position than 0.0625.
This is where GDT comes in. In this last example, GDT is used to “Describe” the allowable deviation from it’s ideal position.
There’s actually an ASME Standard for GDT (Y14.5.2) and a full explination of GDT is not only beyond the scope of this blog but my knowledge, There’s a lot of courses out there specifically for this but a good “101” description can be found here.
Given trends in Prefab, Modularization, and Construction becoming more like Manufacturing….Makes you wonder….should there be a “GDT” style of documentation for construction?
If you’re attempted to download any of my COD Script libraries over the last couple weeks, you may have found the links were bad.
This should now be corrected. The issue was caused when the site was moved to a new hosting provider. Their newer WordPress setup used a different character set than was originally used when the site was originally setup.
Let me know if you notice any issues. There are still a few character anomalies in other pages and tables that will be fixed as I have time.
Autodesk has released update 2020.1 for Autodesk Fabrication products CADmep, CAMduct and ESTmep. You can see the small token list of fixes here.
Really not much in the way of fixing the many legacy, multi-release defects that have been piling up. Still no word on the update to plug the security hole in Revit where you’re COST/LABOR data can be mined by others.
One thing to note about this release, it’s not an “Update” that patches your existing system. The Update requires a full install. That means that 2020 versions of CADmep, ESTmep, CAMduct as well as Tracker, CAMduct Components and Remote Entry need to be removed first.
I would NOT recommend installing the update from the Autodesk Desktop App. I’ve tested on multiple systems both personal and corporate and it gets hung indefinitely on the uninstall of the 2020 versions.
If you do want to install the update, I highly recommend uninstalling yourself before adding the 2020.1 versions. Even manual uninstalls of 2020 have been hit or miss. If they hang, they’re usually already uninstalled and using Task Manager to cancel the running MSIEXEC tasks is enough to finish the uninstalls. Best of luck!