Autodesk Classification Manager – updating uniclass 2015

Evening

You may not be aware but if you are using the Autodesk Classification Manager this contains out of date uniclass tables from 2016 which were updated in April 2017.

Updating these tables can be time consuming but not impossible, the following describes the process I went through to update for uniclass 2015 & 1.4 (legacy).

  1. Download the latest uniclass 2015 tables En, Pr, SL & Ss which you can get here – https://toolkit.thenbs.com/articles/classification/#classificationtables
  2. Locate the Classification Manager Database UK.xlsx file which is located normally C:\Program Files (x86)\Autodesk\Classification Manager\2017
  3. Before we start to copy over the new data make a duplicate of all the tabs and rename them En OLD etc so we keep of the original tables for reference as we need some info from them for the new tables.
  4. Copy in the new new table data by opening them up (downloaded from point 1) then select all the data (1 column at a time ie Code to Number & Title to Description), then copy then paste in to the xlsx file in point 2.
  5. Once all the new data are copied over the xlsx file in point 2 we can now start to work out the code level and map over the revit categories from the original tabs which you renamed in point 3.
  6. In the Level column in order to quickly work out the various levels with the new additions you can use the following formula =SUMPRODUCT(LEN(A102)-LEN(SUBSTITUTE(A102,”_”,””)))+1 this counts the number of underscore and added one to work out the level position the code relates to which is import when viewing the codes in the classification manager.
  7. Next we need to do a look up of revit categories between the new/old tables which can simply be done using =LOOKUP(A103,’Pr OLD’!A:A,’Pr OLD’!D:D) where A103 is you look up value on your new tab which is then compared with Pr OLD’!A:A (Pr OLD is the old renamed tab, A:A is the column reference) and if it finds this then it will returns the value from Pr OLD’!D:D so a really quick way to avoid having to look through 0000’s of lines.
  8. Once you have done this for each of the tables you will be able to delete the Pr OLD tabs (note: as you did lookup’s for the revit categories you will need to select all this data and do a copy then paste values so everything is replaced with actual values rather than formulas which wont work when you delete the Pr OLD etc tabs)
  9. Once everything is done your classification manager will now be updated – if you want you could also use the Classification Manager Database Custom.xlsx file to add uniclass 1.4 (legacy) which you can download from http://www.cpic.org.uk/uniclass1/

Hopefully you have followed the above but if you are still struggling please get in touch as I’d be happy to provide further details and any appointment for ifc, uniclass or COBie training comes with these tables.

G