Autodesk Fabrication: Best Practice #5

Don’t Store Estimating Tables in Your CADmep Drawing

If your company uses ESTmep, pay close attention. CADmep stores in the DWG files most of your database with the exception of content that’s not used and reports. What this also means is that by DEFAULT, CADmep stores your Estimating Tables in every Drawing file (DWG) you produce. Most companies using ESTmep use 1.0 Factors for SMACNA, MCAA or other trade labor so exposing that data isn’t as big of a risk…everybody knows what it is. However, if you have pricing multipliers for your vendors, negotiated prices (as opposed to List Pricing) in your tables or have your own custom labor factors and rates, anyone with access to CADmep and your drawing files can EASILY extract that information from your DWG files,

This is easily changed by toggling the “Do NOT Store Est Tables with DWG Database” setting in the Edit Configuration utility as shown on the following image.

,

Setting this toggles will prevent CADmep from caching a copy of the Price Tables, Install Tables and Fabrication Tables in your drawing file, These are a few other things to note…

  • While this settings prompts you for which configuration to load (if you have more than one), the setting is not configuration specific. Meaning, it is not stored in your Fabrication Database. The setting applies to ALL configurations so you can pick any one you like to make this change.
  • This change is software VERSION specific. For example, if you run 20017 and 2018 versions of CADmep, you need to make the change in both versions.
  • This issue is NOT present when using Revit with Fabrication Parts. Only CADmep has this issue,
  • Because this setting isn’t stored in the database, that means it’s computer specific. You need to change it on each computer running CADmep.
  • This setting is also USER specific (stored in your Windows profile) so even if you change if for one user, if a different user logs in on the same computer, you’ll need to make the change again.

Because this setting is user specific and computer specific…and because the default setting if you do nothing is the RISKY option, it’s easy for this setting to revert back to it’s original value and save the Estimating Tables to the drawing. For this reason, you many want to consider creating an AutoLISP routine that sets this setting every time you start AutoCAD. You could also have it run from a Batch File or VBScript in the Windows Startup folder each time you log onto Windows or even have your IT Department force the setting via Group Policy or other methods. For any of these solutions, it’s as simple as automating the setting in the following Registry Key.

Key: HKEY_CURRENT_USER\Software\Autodesk\Fabrication 2018\CADmep
Value: StoreEstDatabase
Type: REG_SZ
Data: FALSE

If you’re interested in a sample LSP, Batch File and/or VBScript to set this, drop me an Email at Dyoung@Mcwi.Com.

Autodesk Fabrication: Best Practice #4

Make sure ALL of your ITM content has a Database ID assigned to it.

A database ID is a unique identifier for content. There should be a single Database ID for any ITM that is NOT Product Listed. For Product Listed ITM’s, there should be Database ID for each entry in the product list.

For ITM’s that are not product listed (typically fabricated sheet metal fittings or other content where the ITM only represents one size, you can put the Database ID in the “Code” field of the ITM Properties as shown in the following image…

For ITM’s that are Product Listed, the Database ID should be in the ID column of the Product List. When you place an instance of a product listed ITM in your model, you select a size from the product list, When you select that size, the Database ID associated with that size it automatically entered into the Code field of the ITM Properties like shown earlier, The following image shows the Database ID column in a Product List…


Why Use A Database ID?

The Database ID is a useful component to managing an Autodesk Fabrication configuration. This Database ID can be referenced by other aspects of Autodesk Fabrication should you choose to use them. The Database ID is what can link your content to….

  • Price lists
  • Fabrication Labor
  • Installation Labor
  • Product Information (ProdInfo)

Even if you don’t use ESTmep for estimating  and don’t want to use the Price and/or Labor features of the database, Product Information is tied to the Database ID and is used to store additional meta data about your content like Manufacturer, Size, Description, etc. Even if you’re not using ProdInfo now, it’s still a good idea to use Database ID’s because adding them to the content is the most time consuming part. It’s easy to add them when building content, more cumbersome later after the fact. If all your content had Database ID’s assigned, it’s much easier to implement ProdInfo, Price and/or Labor later down the road.

The following Video shows how to access the Database ID of Product Listed and Non-Product Listed ITM’s. It also shows you 2 different sizes of a product listed ITM in a drawing and how Autodesk Fabrication automatically assigned the Database ID from the Product List for the corresponding size into the Code field of the ITM Properties.


Key Database ID Takeaways

Here’s a few pointers when working with Database ID’s:

  • Each Database ID should be unique and not assigned to other content or sizes.
  • Managing Database ID’s using a spreadsheet or other database makes managing them much easier.
  • Your database ID can be anything you want but should have some sort of naming standard associated with it.
  • Your Database ID Naming standard can be as simple as a prefix followed by incremental numbers to something complex with special codes and formatting to indicate other aspects of your content. (e.g. Valves, Pipe, Sheetmetal, etc)
  • You can use Autodesk or other Vendors ID’s if they already have them assigned and use your for anything you create or replace them all with your own company Database ID’s if you are particular about naming standards,
  • Don’t reuse ID’s if the content that once used them is now obsolete. Legacy/Archive drawings still reference these numbers. Simply flag them as being obsolete in the Spreadsheet you are managing them with.

Autodesk Fabrication: Best Practice #2

Don’t use BMP files for ITM Images

If you’ve been using an Autodesk Fabrication configuration for a long time, like back before Autodesk acquired MAP Software Ltd, you may have a lot of content that’s using Bitmap (*.BMP) files. These image files are used on a couple key locations….

1: Service Palettes….

2: Folders Dialog….

If you’re Fabrication configuration uses BMP files for images, you should consider converting them to PNG files. There’s a number of utilities that will do this in bulk for you if you have a lot. My favorite is using TechSmith’s SnagIt Editor but there are others.

Use Windows Explorer and browse to your content. You can use the search functionality in the upper right corner and search on *.BMP to see how many Bitmap images there are. Or you can browse folder by folder looking for them. Hint: Sorting by type can speed with this too.

Once you convert the BMP’s place the PNG files in the same folder using the same name as the BMP and then delete the BMP files. Doing this will reduce the size of the files which in turn speeds the display of your service palettes and folder’s list.

Applied Software acquires long standing CADmep reseller TSI

And then there was one….

TSI – From Startup to Market Domination to Decline

Long before Autodesk acquired UK based MAP Software LTD, their products were not well known in the US. Technical Sales International (TSI) was started by some folks with a long history at QuickPen. They left and went out on their own to become the US reseller of CADduct, CADmech, CAMduct and ESTmep. It was through their efforts that what we now know as the Autodesk Fabrication product line became a major force in the market place for MEP sub-contractors.

But with all things, times change. Autodesk acquired MAP Software in the end of 2011 and soon opened up the Autodesk sales channel. This eliminated TSI’s exclusive right to sell the software in the US and other territories and many customers moved their software subscriptions to other resellers who they likely already had an existing relationship with for many of their other Autodesk products. It was Autodesk’s fragmentation of a small niche market that started TSI’s decline.

Enter Applied Software

While other resellers could now sell Autodesk Fabrication, another well establish Texas based reseller DC CADD saw an opportunity. DC CADD quickly snapped up some of the top talent as TSI downsized. DC CADD made the investment in staff and marketing and position itself well. DC CADD later re-branded itself as Enceptia as they went from regional reseller to a national player. Ultimately, Enceptia’s owner was looking to retire and sold to Applied Software.

With the market fragmentation caused by Autodesk, TSI’s owners started focusing on their own product called SysQue which runs inside Revit. This focus and their SysQue product ultimately created a conflict of interest as they were taking a different direction than Autodesk for Revit Fabrication in the MEP trades. As SysQue started to gain traction TSI’s owner’s ultimately led them to split off SysQue as a separate company and sell their stake in TSI to one of the employees. This allowed them to focus exclusively on their product and not be distracted with the requirements Autodesk places on their resellers.

An Uphill Battle Lost

Ultimately, I suspect the marketing power of Applied Software, combined with the fragmented customer base was a tough battle for TSI. The MEP market is a pretty small community where everybody knows everybody and many of the familiar names nationally and globally recognized as “Experts”, were working for Applied Software or moved over to the SysQue company (who themselves were later acquired by Trimble).

Related Press Releases:

Autodesk Fabrication Resources

I’ve posted a number of Autodesk Fabrication resources for anyone using Autodesk Fabrication CADmep, EDTmep, CAMduct or Fabrication parts in Revit. You can find them using the Resources menu or by following the link here. You can also find this same information on the site XtraCAD.com. In the future, I’ll be compiling and posting additional resources that I’ve collected over the last several years in the course of administering Autodesk Fabrication databases for some large MEP firms.

Fabrication Resources…
  • History of Autodesk Fabrication build numbers for all the versions, service packs and product updates.
  • Pattern/CID Number history lists which Pattern Numbers (CID’s) are supported in which versions of the Fabrication products.
  • Revit Support history lists which Pattern Numbers (CID’s) are supported by which Revit versions.
  • CADmep command history lists which commands where added/removed from the different CADmep versions.
  • AutoLISP function history lists which versions of CADmep support which CADmep specific AutoLISP functions.
  • FabViewer command history lists the commands supported for the FabViewer in each version of Fabrication products.
  • Post Processor history lists which post processors are supported in each version and/or servicepack/update of the Fabrication Products
    • Decoiler/Coil Line Posts (DPL’s)
    • Plasma/Laser/Router/Waterjet Posts (VPL’s)