# Family Types from Excel

**URL:** <https://forum.dynamobim.com/t/family-types-from-excel/11112>\
**Category:** Revit\
**Created:** [April 18, 2017, 4:08pm UTC](https://forum.dynamobim.com/t/family-types-from-excel/11112 "2017-04-18T16:08:32Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![StrangeQuark](https://avatars.discourse-cdn.com/v4/letter/s/8edcca/32.png) [@StrangeQuark](https://forum.dynamobim.com/u/StrangeQuark)\
**Post date:** [April 18, 2017, 4:08pm UTC](https://forum.dynamobim.com/t/family-types-from-excel/11112/1 "2017-04-18T16:08:32Z")

</div>

Hi,  
I’m trying to use Dynamo to push multiple types, generated from an excel file, into an existing family.

There used to be an “ElementType.Duplicate” which I think is the missing link (I believe it was from the Clockwork package?).

Getting the required types to populate as a list from Excel is straight forward enough but I’m struggling to duplicate the required family types.

Is this something which is achievable with Dynamo?

Many thanks.

---

<div class="post-metadata">

**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\
**Post date:** [April 18, 2017, 4:52pm UTC](https://forum.dynamobim.com/t/family-types-from-excel/11112/2 "2017-04-18T16:52:15Z")

</div>

Hi @StrangeQuark

> [@StrangeQuark](#):
>
> There used to be an “ElementType.Duplicate” which I think is the missing link (I believe it was from the Clockwork package?

Yes it is.

> [@StrangeQuark](#):
>
> Getting the required types to populate as a list from Excel is straight forward enough but I’m struggling to duplicate the required family types.

Could you please show us image of your graph where you got stuck?

---

<div class="post-metadata">

**Author:** ![StrangeQuark](https://avatars.discourse-cdn.com/v4/letter/s/8edcca/32.png) [@StrangeQuark](https://forum.dynamobim.com/u/StrangeQuark)\
**Post date:** [April 19, 2017, 8:43am UTC](https://forum.dynamobim.com/t/family-types-from-excel/11112/3 "2017-04-19T08:43:23Z")

</div>

Hi Kukul,  
Thank you for getting back to me.

This was based on a previously closed thread which used the “ElementType.Duplicate” node. The closest I can find is “ElementTypesMatchList” but this has different inputs. Perhaps I’m just missing the node from the package?

Please see attached screenshot of graph. I’ve selected the family from the drawing and created a list from an external Excel so just need to create duplicate family types and push the names in the list to the newly created families.

Reason this is needed is that we have a large number of family types which need to be managed from an excel/access file for ease of maintenance.

Many thanks,  
Chubby.

 ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/3/b32ed2c567915e6cc8d2f00702bd8ed5d082ac36.png)

---

<div class="post-metadata">

**Author:** ![Ahmad\_Saad](https://avatars.discourse-cdn.com/v4/letter/a/ac8455/32.png) [@Ahmad\_Saad](https://forum.dynamobim.com/u/Ahmad_Saad)\
**Post date:** [April 19, 2017, 9:08am UTC](https://forum.dynamobim.com/t/family-types-from-excel/11112/4 "2017-04-19T09:08:26Z")

</div>

Hi @StrangeQuark !  
It works fine with me, I think you are missing the node.

 ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/0/901466e6c824c5e0897aec5cc48f3a14f3f2bd04.PNG)

---

<div class="post-metadata">

**Author:** ![StrangeQuark](https://avatars.discourse-cdn.com/v4/letter/s/8edcca/32.png) [@StrangeQuark](https://forum.dynamobim.com/u/StrangeQuark)\
**Post date:** [April 19, 2017, 9:40am UTC](https://forum.dynamobim.com/t/family-types-from-excel/11112/5 "2017-04-19T09:40:16Z")

</div>

OK, thanks Ahmad, I’ll try re-installing the package. Just to confirm, is that node from the clockwork package?

All the best.

---

<div class="post-metadata">

**Author:** ![StrangeQuark](https://avatars.discourse-cdn.com/v4/letter/s/8edcca/32.png) [@StrangeQuark](https://forum.dynamobim.com/u/StrangeQuark)\
**Post date:** [April 20, 2017, 2:48pm UTC](https://forum.dynamobim.com/t/family-types-from-excel/11112/6 "2017-04-20T14:48:26Z")

</div>

OK, I was missing the node. All working now. Thanks.

I was doing well until…

…Trying to push the Excel generated type name into an instance parameter. Graph runs ok but returns “null” values when trying to set the parameter? Am I missing something obvious?

Thanks!

![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/8/3/83b3d047e5ceab1581d6e5a527140e0f50e4ff18.png)

---

<div class="post-metadata">

**Author:** ![StrangeQuark](https://avatars.discourse-cdn.com/v4/letter/s/8edcca/32.png) [@StrangeQuark](https://forum.dynamobim.com/u/StrangeQuark)\
**Post date:** [April 20, 2017, 3:56pm UTC](https://forum.dynamobim.com/t/family-types-from-excel/11112/7 "2017-04-20T15:56:26Z")

</div>

I should add this is an instance parameter in an annotation family I’m trying to set, not sure if it makes any difference but thought I’d add for completeness.
