Families- Specific Type Loader by Excel ( Type Name)

Revit
, , ,
1

I am trying to load specific Types of different family and I have excel data from advance steel - I have managed to get clean up the excel data and achieve ( Type Names - example SHS40x40x5 etc) now I want to load my company standard specific FamilySymbols ( Types) based on data sorted from advance steel.

I was able to duplicate preloaded type ( as each families has one type preloaded in the model) and change it type names based on excel data but steel members has Structural Section Geometry parameters and values which is specific for each type.

When we load families in Revit by Load family while choosing .rfa file we get a pop up of Type Catalog which let us select specific type(s).

We we get this option via Dynamo or python.

I did see a method in Revit API which let us load a specific type in the document but i am not able to map through it excel data.

Any help and suggestions would be really appreciated @c.poupin @jacob.small @sovitek @christian.stan or anyone

public bool LoadFamilySymbol(
	string filename,
	string name
)
2

Hi,

The Revit API does not allow you to load a family using a Type Catalog (txt file); you must load the family (which includes all types) and then delete any types you don’t want.

What does your Excel file look like?

1 Like
3

Hi @c.poupin, thanks for your insight - excel workbook look alike attchated

image
image661×591 15.9 KB

But I got it cleaned up and able to achieve
I got list full of 762 types - but manage to get Unique types

image
image550×570 57.6 KB

4

Are SHS180x6.3, SHS40x5 and SHS140x10 file names or type names? How are your RFA files organised?