# Actualising .csv file in family wih dynamo or macro

**URL:** <https://forum.dynamobim.com/t/actualising-csv-file-in-family-wih-dynamo-or-macro/45006>\
**Category:** Revit\
**Tags:** revit, excel, csv\
**Created:** [January 2, 2020, 7:54am UTC](https://forum.dynamobim.com/t/actualising-csv-file-in-family-wih-dynamo-or-macro/45006 "2020-01-02T07:54:48Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Thomas\_LiB](https://avatars.discourse-cdn.com/v4/letter/t/50afbb/32.png) [@Thomas\_LiB](https://forum.dynamobim.com/u/Thomas_LiB)\
**Post date:** [January 2, 2020, 7:54am UTC](https://forum.dynamobim.com/t/actualising-csv-file-in-family-wih-dynamo-or-macro/45006/1 "2020-01-02T07:54:48Z")

</div>

Hi,  
Recently, i have created an excel file to create a data base of mullion profil dimension. This excel export csv file that i link manually in my family in revit.

I would like to know if there is a method to automatically actualize the link between my family and my csv file with a macro or a dynamo that i can simply launch.

I can analyze by myself witch family need to be actualized.

---

<div class="post-metadata">

**Author:** ![Thomas\_LiB](https://avatars.discourse-cdn.com/v4/letter/t/50afbb/32.png) [@Thomas\_LiB](https://forum.dynamobim.com/u/Thomas_LiB)\
**Post date:** [January 2, 2020, 2:18pm UTC](https://forum.dynamobim.com/t/actualising-csv-file-in-family-wih-dynamo-or-macro/45006/2 "2020-01-02T14:18:34Z")

</div>

I tried this but don’t actualize the file.

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

It just “import data” 🤷‍♂️

---

<div class="post-metadata">

**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\
**Post date:** [January 2, 2020, 2:20pm UTC](https://forum.dynamobim.com/t/actualising-csv-file-in-family-wih-dynamo-or-macro/45006/3 "2020-01-02T14:20:02Z")

</div>

> [@Thomas\_LiB](#):
>
> don’t actualize the file

What do you mean by this?

---

<div class="post-metadata">

**Author:** ![Thomas\_LiB](https://avatars.discourse-cdn.com/v4/letter/t/50afbb/32.png) [@Thomas\_LiB](https://forum.dynamobim.com/u/Thomas_LiB)\
**Post date:** [January 2, 2020, 2:35pm UTC](https://forum.dynamobim.com/t/actualising-csv-file-in-family-wih-dynamo-or-macro/45006/4 "2020-01-02T14:35:42Z")

</div>

For exemple, i delete a profil reference from the csv and my family parameter value doesn’t change.

As you can see, the parameter value “VALIDE” in red is “Profil existe” with the old CSV for the profile reference WIC10160

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/5/8/58912561e50d976fa8025564d947c0ac13ce82a7.png)

When i use the Dynamo node Data.ImportCSV the result is the same.

When i reload it manually there is a difference i want.  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/5/9/5900450ba93b6e80a58091e1ebcfa5bf8f572466.png)  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/3/03c0356a61a33df41125ad371e7bc08cde9a0eea.png)

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/e/1e6d6b6db3582a58adcf64d517ffed14416d2747.png)

I don’t know why dynamo don’t do it automatically.

---

<div class="post-metadata">

**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:** [January 2, 2020, 2:49pm UTC](https://forum.dynamobim.com/t/actualising-csv-file-in-family-wih-dynamo-or-macro/45006/5 "2020-01-02T14:49:14Z")

</div>

Once a lookup table is imported, the data is stored internally within the family. The only way to update the data in the family is to import a “new” table. I’m not aware of any custom nodes for this so you’ll probably need to write something yourself. [This](https://www.revitapidocs.com/2020/1aa769e8-d524-4ca7-6b76-9c09333a7405.htm) might be a good starting place.

---

<div class="post-metadata">

**Author:** ![Thomas\_LiB](https://avatars.discourse-cdn.com/v4/letter/t/50afbb/32.png) [@Thomas\_LiB](https://forum.dynamobim.com/u/Thomas_LiB)\
**Post date:** [January 2, 2020, 2:53pm UTC](https://forum.dynamobim.com/t/actualising-csv-file-in-family-wih-dynamo-or-macro/45006/6 "2020-01-02T14:53:27Z")

</div>

I’m dying inside 😅

I’m so disappointed there is not a simple node like “Data.RefreshCSV” 🙃

---

<div class="post-metadata">

**Author:** ![stillgotme](https://avatars.discourse-cdn.com/v4/letter/s/e480ec/32.png) [@stillgotme](https://forum.dynamobim.com/u/stillgotme)\
**Post date:** [January 3, 2020, 2:21am UTC](https://forum.dynamobim.com/t/actualising-csv-file-in-family-wih-dynamo-or-macro/45006/7 "2020-01-03T02:21:49Z")

</div>

if you are so disappointed, why not create it yourself? 🙂 And, your concept are totally off here. Import csv node is just purely parsing csv data into readable dynamo data that is to be used in the visual programming environment, nothing else more. If you want to find any OOTB nodes that will play with Revit, go search under the Revit category. If you are dealing with family, orchid package is your best bet. But with that being said, since it is simple node like you said, i believe you can do it in python script easily right

---

<div class="post-metadata">

**Author:** ![Thomas\_LiB](https://avatars.discourse-cdn.com/v4/letter/t/50afbb/32.png) [@Thomas\_LiB](https://forum.dynamobim.com/u/Thomas_LiB)\
**Post date:** [January 3, 2020, 10:34am UTC](https://forum.dynamobim.com/t/actualising-csv-file-in-family-wih-dynamo-or-macro/45006/8 "2020-01-03T10:34:32Z")

</div>

Actually in discussion with expert to find a solution, he send me a link to this post in dynamo forum.

[https://forum.dynamobim.com/t/batch-import-lookuptable-csv-files-to-families/22963/5](https://forum.dynamobim.com/t/batch-import-lookuptable-csv-files-to-families/22963/5)

As i see a solution of this post, with package we can write formula in parameter.  
So i think i can do this :

- Delete csv file from my family
- Load this csv as a new csv
- Write formula to my parameter to get my information from csv.

---

<div class="post-metadata">

**Author:** ![a.pie](https://avatars.discourse-cdn.com/v4/letter/a/50afbb/32.png) [@a.pie](https://forum.dynamobim.com/u/a.pie)\
**Post date:** [June 15, 2020, 10:34am UTC](https://forum.dynamobim.com/t/actualising-csv-file-in-family-wih-dynamo-or-macro/45006/9 "2020-06-15T10:34:40Z")

</div>

Hi,

I just ran into the same problem: I need to update/refresh LookUpTables

Did you manage to find a solution to your problem?

Thanks for your help!

---

<div class="post-metadata">

**Author:** ![Thomas\_LiB](https://avatars.discourse-cdn.com/v4/letter/t/50afbb/32.png) [@Thomas\_LiB](https://forum.dynamobim.com/u/Thomas_LiB)\
**Post date:** [October 7, 2020, 9:14am UTC](https://forum.dynamobim.com/t/actualising-csv-file-in-family-wih-dynamo-or-macro/45006/10 "2020-10-07T09:14:47Z")

</div>

Hi, today there is no real solution with Dynamo. I see something in C# but that all.
