# Export family parameter properties to Excel **URL:** \ **Category:** Revit\ **Tags:** dynamo\ **Created:** [December 7, 2022, 11:25am UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849 "2022-12-07T11:25:37Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![ross](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/ross/32/151333_2.png) [@ross](https://forum.dynamobim.com/u/ross)\ **Post date:** [December 7, 2022, 11:25am UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849/1 "2022-12-07T11:25:37Z")
Hi, This is my first post to the forum so hello all. I’ve been reading posts for some time and have found them very helpful. There are some very talented people here! I’ve been looking at a graph to extract the properties from family parameters into an Excel file. I’ve used the nodes shown below ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/3/b30159e8e60b52e785f859a738df4e5bb28e1d3e.png) the FamilyDocument.Current & Family Document Parameters are from the Orchid package. The FamilyParameter.Properties is from the Clockwork package. Package versions are as shown below: ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/7/475b58c34fcf3057fd1ea1fbcc2d6f40766918ef.png) I’m running ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/f/7f279c061fa74f9f383777285f7f7f03e7883eeb.png) The Orchid nodes work fine at extracting the parameters but when the data is fed into the Clockwork node I get null values for all properties. I’ve connected the list via a Flatten and have tried all three types of lacing but still get nulls. I’ve also tried using the OOTB nodes to extract the parameters & taking 1 parameter from the list to connect to the Clockwork node. ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/9/b9983445f1ed9cf129d01b64ebb15595b1324ca1.png) Again this yields nulls when run. I’ve attached copies of the Dynamo file and Family Document. It would be great if anyone has a solution/workaround for the issue I’m having. [Extract Multiple Family Parameter Properties to Excel\_Forum.dyn](https://forum.dynamobim.com/uploads/short-url/mm55AbVpa6XyNoH5We5sViwnO0E.dyn) (46.9 KB) [WN-Frame Circular Arch-5x3-Assembly.rfa](https://forum.dynamobim.com/uploads/short-url/hGbT0meXfCiiPg1SRntVvb4hU7X.rfa) (1.3 MB) ---
**Author:** ![manhgt214](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/manhgt214/32/153251_2.png) [@manhgt214](https://forum.dynamobim.com/u/manhgt214)\ **Post date:** [December 7, 2022, 12:07pm UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849/2 "2022-12-07T12:07:05Z")
Hello! I think you try use DirootOne (Free) better Dynamo, It’s Amazing Plug-in ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/8/c821c8148e25ac4580c21b08e0f240e72b6c31fa.png) =\>Link below: [DiRootsOne - 8 productivity Revit Plugins by DiRoots](https://diroots.com/revit-plugins/dirootsone/) [DiRootsOne - 8 Productivity Tools | Revit | Autodesk App Store](https://apps.autodesk.com/RVT/en/Detail/Index?id=6035794126247149351&appLang=en&os=Win64) ---
**Author:** ![manhgt214](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/manhgt214/32/153251_2.png) [@manhgt214](https://forum.dynamobim.com/u/manhgt214)\ **Post date:** [December 7, 2022, 12:09pm UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849/3 "2022-12-07T12:09:10Z")
Your Family ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/1/418070698686b69876e860e49928ad3e3749cb82.png) ---
**Author:** ![Alban\_de\_Chasteigner](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/alban_de_chasteigner/32/39650_2.png) [@Alban\_de\_Chasteigner](https://forum.dynamobim.com/u/Alban_de_Chasteigner)\ **Post date:** [December 7, 2022, 12:35pm UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849/4 "2022-12-07T12:35:32Z")
Hi @ross, You could use the _FamilyParameter.Properties_ node in conjunction with the _FamilyDocument Parameters_ from the _Genius Loci_ package. ![familyparameters](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/c/1cc5bc218327182c5299bad18bdd4c8ae88e7d8f.png) ---
**Author:** ![ross](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/ross/32/151333_2.png) [@ross](https://forum.dynamobim.com/u/ross)\ **Post date:** [December 7, 2022, 2:23pm UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849/5 "2022-12-07T14:23:30Z")
Hi @Alban, Many thanks for your suggestion. I tried the GeniusLoci nodes and got the same result. All the nodes I’m trying work except the FamilyParameter.Properties node. I’ve also tried this in Revit 2021 and got the same result, nulls output from the #Clockwork node. I’ve tried installing the latest version of DynamoIronPython but this did not solve my issue either… Hi @manhgt214 thanks for the plugin link, I’ll give it a go if I cannot get the Clockwork node to work ---
**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\ **Post date:** [December 7, 2022, 2:31pm UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849/6 "2022-12-07T14:31:17Z")
Try pulling apart the Properties node to run it in your graph directly and see what fails there. EDIT: It looks like all the parameters are failing at `SpecTypeId` (line 35). That’s leftover from 2021 but has now been depricated. You can replace it with the updated method: ```auto utype.append(param.Definition.GetDataType()) ``` ---
**Author:** ![ross](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/ross/32/151333_2.png) [@ross](https://forum.dynamobim.com/u/ross)\ **Post date:** [December 7, 2022, 4:13pm UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849/7 "2022-12-07T16:13:46Z")
Hi @Nick_Boyts Many thanks for the suggestion. I pulled apart the custom node as suggested then changed line 35 to your suggestion then ran the graph again. I got a few errors on the custom node contents, the furthest upstream was on the first Python node: Node Name: Python Script Package: Core.Scripting Dynamo Version: 2.16.1.2727 Host: Dynamo Revit Messages: PythonEvaluator.Evaluate operation failed. Traceback (most recent call last): File “”, line 29, in AttributeError: ‘FamilyParameter’ object has no attribute ‘Definition’ State: Warning The line of code reads pname.append(param.Definition.Name) I only know the basic concepts of Python so have little idea of how to solve this, I tried deleting Definition in line 29, then got the same error on line 32. I’m guessing the Definition attribute needs to be replaced or removed but I’m not sure with what… ---
**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\ **Post date:** [December 7, 2022, 4:23pm UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849/8 "2022-12-07T16:23:54Z")
Try with the Genius Loci package again. It returns the correct object type. ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/1/01aa30380a7aa42cecd4382dd0bfda40c1e5ccaa.png) ---
**Author:** ![ross](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/ross/32/151333_2.png) [@ross](https://forum.dynamobim.com/u/ross)\ **Post date:** [December 8, 2022, 1:04pm UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849/9 "2022-12-08T13:04:09Z")
Hi @Nick_Boyts that worked perfectly, many thanks! ---
**Author:** ![kslifter](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kslifter/32/192657_2.png) [@kslifter](https://forum.dynamobim.com/u/kslifter)\ **Post date:** [May 4, 2023, 5:01pm UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849/10 "2023-05-04T17:01:51Z")
is this node still available? I’m trying to export the different types of a family and their parameters to excel so that I can more easily see the differences between them all. Thanks ---
**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\ **Post date:** [May 4, 2023, 5:18pm UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849/11 "2023-05-04T17:18:49Z")
Should be. Have you looked for it? ---
**Author:** ![kslifter](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kslifter/32/192657_2.png) [@kslifter](https://forum.dynamobim.com/u/kslifter)\ **Post date:** [May 4, 2023, 5:27pm UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849/13 "2023-05-04T17:27:59Z")
I looked again and found it. I was looking in the family section and didn’t see it and nothing was coming up when I used the search term ‘parameter’. I noticed the parameter section of the package and it’s in there. ---
**Author:** ![kslifter](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kslifter/32/192657_2.png) [@kslifter](https://forum.dynamobim.com/u/kslifter)\ **Post date:** [May 4, 2023, 5:52pm UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849/14 "2023-05-04T17:52:29Z")
Can you help me pinpoint what I’m missing? It’s not returning any info on the parameter selected. ![family paramters script_2023-05-04_12-52-07](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/3/63c2f82419ee317ed80b49f33dc9cbe16c5c72e3.png) ---
**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\ **Post date:** [May 4, 2023, 6:02pm UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849/15 "2023-05-04T18:02:24Z")
You’ll have to pull apart that node to see what issues it’s having. ---
**Author:** ![kslifter](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kslifter/32/192657_2.png) [@kslifter](https://forum.dynamobim.com/u/kslifter)\ **Post date:** [May 4, 2023, 6:09pm UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849/16 "2023-05-04T18:09:38Z")
It looks like It’s having an issue on line 35 with getting the "GetSpecTypeId’. Any suggestions on dealing with this? ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/2/920374c37fcb103b60e77b5f4e68b109d0db3c4a.jpeg) ---
**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\ **Post date:** [May 4, 2023, 6:14pm UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849/17 "2023-05-04T18:14:37Z")
It would be helpful if you included all the inputs you’re using. Otherwise we’re just guessing blindly. ---
**Author:** ![kslifter](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kslifter/32/192657_2.png) [@kslifter](https://forum.dynamobim.com/u/kslifter)\ **Post date:** [May 4, 2023, 6:26pm UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849/18 "2023-05-04T18:26:29Z")
I am selecting an element from Revit and isolating a parameter → `Autodesk.Revit.DB.FamilyParameter` ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/1/4107d7b5269dfb42efefa1396e9db68eb9edc3d6.jpeg) ---
**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\ **Post date:** [May 4, 2023, 6:37pm UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849/19 "2023-05-04T18:37:33Z")
And the Version is correct? What version of Revit are you in? I mentioned the issue with `GetSpecTypeId()` earlier in the thread. > [@Nick\_Boyts](#): > > It looks like all the parameters are failing at `SpecTypeId` (line 35). That’s leftover from 2021 but has now been depricated. You can replace it with the updated method: > > ```auto > utype.append(param.Definition.GetDataType()) > > ``` ---
**Author:** ![kslifter](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kslifter/32/192657_2.png) [@kslifter](https://forum.dynamobim.com/u/kslifter)\ **Post date:** [May 4, 2023, 6:57pm UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849/20 "2023-05-04T18:57:47Z")
Sorry for overlooking that. I read that, but then got lost in trying to figure out my stuff that I forgot about that. That solved the issue, thanks! It’s still not exporting the info that is typed in for that parameter? There is the type parameter and it’s showing it’s a double, but not what is entered. Should I use another node to get that info? Similar to using a get name node? ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/e/2e07d05d92263a5a49776109eb0822bf6376dd94.jpeg) ---
**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\ **Post date:** [May 4, 2023, 7:09pm UTC](https://forum.dynamobim.com/t/export-family-parameter-properties-to-excel/83849/21 "2023-05-04T19:09:27Z")
Correct. This is only giving the family parameter information. The value would be based on the type or instance.