# Rename Piping System with Excel

**URL:** <https://forum.dynamobim.com/t/rename-piping-system-with-excel/82273>\
**Category:** Revit\
**Tags:** dynamo\
**Created:** [October 20, 2022, 6:18am UTC](https://forum.dynamobim.com/t/rename-piping-system-with-excel/82273 "2022-10-20T06:18:04Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![sb1102222](https://avatars.discourse-cdn.com/v4/letter/s/ccd318/32.png) [@sb1102222](https://forum.dynamobim.com/u/sb1102222)\
**Post date:** [October 20, 2022, 6:18am UTC](https://forum.dynamobim.com/t/rename-piping-system-with-excel/82273/1 "2022-10-20T06:18:04Z")

</div>

I am going to rename my piping system type name by Excel. My step show as below:

1. Export piping system data to Excel (Finish)
2. Fill the New name for piping system by Excel(Finish)
3. Import Excel by dynamo (In progress)  
3.1. Import Excel(Finish)  
3.2. Get necessary Data(Finish)  
3.3. Match Data by ElementID(In trouble)  
3.4. Set new name by Excel(Stuck by step 3.3)

I search posts about “get element by ID” or “import Excel” , still can’t fix the problem.

 ![Export](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/0/c088ed7e0803c25ca4e63f7c8c60ea6fb2165542.jpeg)  
 ![Excel image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/0/b023bb42383e11dafff3e236c96b7e25de5938ab.jpeg)  
[Import Excel List .dyn](https://forum.dynamobim.com/uploads/short-url/jXevb6ofsFePIuA7QRyvLMHgVyJ.dyn) (24.5 KB)

---

<div class="post-metadata">

**Author:** ![sb1102222](https://avatars.discourse-cdn.com/v4/letter/s/ccd318/32.png) [@sb1102222](https://forum.dynamobim.com/u/sb1102222)\
**Post date:** [October 20, 2022, 6:55am UTC](https://forum.dynamobim.com/t/rename-piping-system-with-excel/82273/2 "2022-10-20T06:55:20Z")

</div>

I tried a method by GavinCrump, but it seems not work.  
[https://www.youtube.com/watch?v=pFT5vejNzqU](https://www.youtube.com/watch?v=pFT5vejNzqU)  
Is it because of “Piping System” is System Families not Loadable Families?

 ![Retrieve Element ID](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/3/a/3a89ea7d60097566973c2da3f811c3cbe493f0f1.jpeg)

---

<div class="post-metadata">

**Author:** ![Garbage\_Collector](https://avatars.discourse-cdn.com/v4/letter/g/da6949/32.png) [@Garbage\_Collector](https://forum.dynamobim.com/u/Garbage_Collector)\
**Post date:** [October 20, 2022, 7:31am UTC](https://forum.dynamobim.com/t/rename-piping-system-with-excel/82273/3 "2022-10-20T07:31:01Z")

</div>

It looks like you’re not passing strings into the ‘string to number’ node.  
What is the error that node puts out?

---

<div class="post-metadata">

**Author:** ![sb1102222](https://avatars.discourse-cdn.com/v4/letter/s/ccd318/32.png) [@sb1102222](https://forum.dynamobim.com/u/sb1102222)\
**Post date:** [October 20, 2022, 7:38am UTC](https://forum.dynamobim.com/t/rename-piping-system-with-excel/82273/4 "2022-10-20T07:38:05Z")

</div>

![Screenshot 2022-10-20 153601](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/5/0/5050294aab8a23fdd5b89f54bf3ba3398402a679.jpeg)  
After I remove the node,the result is incorrect:  
 ![2](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/a/bad38d2e35392cda79b32b13c228c70077145e47.jpeg)

---

<div class="post-metadata">

**Author:** ![Garbage\_Collector](https://avatars.discourse-cdn.com/v4/letter/g/da6949/32.png) [@Garbage\_Collector](https://forum.dynamobim.com/u/Garbage_Collector)\
**Post date:** [October 20, 2022, 7:53am UTC](https://forum.dynamobim.com/t/rename-piping-system-with-excel/82273/5 "2022-10-20T07:53:03Z")

</div>

Are you sure those numbers are in the original list?

---

<div class="post-metadata">

**Author:** ![sovitek](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/sovitek/32/116237_2.png) [@sovitek](https://forum.dynamobim.com/u/sovitek)\
**Post date:** [October 20, 2022, 7:59am UTC](https://forum.dynamobim.com/t/rename-piping-system-with-excel/82273/6 "2022-10-20T07:59:57Z")

</div>

Hello @sb1102222 have you tried roundnumber or ceiling so you are sure both elementid is interger

 ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/9/f9746a1fdb8233261e3f662398ab7391bc167ef1.png)

---

<div class="post-metadata">

**Author:** ![sb1102222](https://avatars.discourse-cdn.com/v4/letter/s/ccd318/32.png) [@sb1102222](https://forum.dynamobim.com/u/sb1102222)\
**Post date:** [October 20, 2022, 8:18am UTC](https://forum.dynamobim.com/t/rename-piping-system-with-excel/82273/7 "2022-10-20T08:18:36Z")

</div>

![3](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/9/f9ee2ad6727da74b006d45cbfd568d1f88eb1d0b.jpeg)  
I should change to Element Types rather than Categories,but the result is incorrect too

---

<div class="post-metadata">

**Author:** ![Garbage\_Collector](https://avatars.discourse-cdn.com/v4/letter/g/da6949/32.png) [@Garbage\_Collector](https://forum.dynamobim.com/u/Garbage_Collector)\
**Post date:** [October 20, 2022, 8:39am UTC](https://forum.dynamobim.com/t/rename-piping-system-with-excel/82273/8 "2022-10-20T08:39:14Z")

</div>

could you add two ‘object types’ nodes as @sovitek suggested?  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/8/0/80e36333008d03f7a329ec7e28938859335a4516.png)

So we can see what object types you’re feeding in both inputs of the index of node

---

<div class="post-metadata">

**Author:** ![sb1102222](https://avatars.discourse-cdn.com/v4/letter/s/ccd318/32.png) [@sb1102222](https://forum.dynamobim.com/u/sb1102222)\
**Post date:** [October 21, 2022, 1:49am UTC](https://forum.dynamobim.com/t/rename-piping-system-with-excel/82273/9 "2022-10-21T01:49:18Z")

</div>

Thank you so much, I don’t know this node can change Double to Num.It is helpful.  
However, I am facing a problem here. The “Type Name” Parameter is read-only, I can’t write it.

 ![4](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/3/737c3f712ced2798157c0e7d081d7d7d5e2eecd8.jpeg)

---

<div class="post-metadata">

**Author:** ![sb1102222](https://avatars.discourse-cdn.com/v4/letter/s/ccd318/32.png) [@sb1102222](https://forum.dynamobim.com/u/sb1102222)\
**Post date:** [October 21, 2022, 1:49am UTC](https://forum.dynamobim.com/t/rename-piping-system-with-excel/82273/10 "2022-10-21T01:49:53Z")

</div>

You are right, the problem is object type!

---

<div class="post-metadata">

**Author:** ![sovitek](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/sovitek/32/116237_2.png) [@sovitek](https://forum.dynamobim.com/u/sovitek)\
**Post date:** [October 21, 2022, 6:19am UTC](https://forum.dynamobim.com/t/rename-piping-system-with-excel/82273/11 "2022-10-21T06:19:31Z")

</div>

Hello if you want to rename your pipesystem type name something should work…

 ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/0/00f64df89221e373326a7741cbec77fa16e47eec.png)

---

<div class="post-metadata">

**Author:** ![sb1102222](https://avatars.discourse-cdn.com/v4/letter/s/ccd318/32.png) [@sb1102222](https://forum.dynamobim.com/u/sb1102222)\
**Post date:** [October 21, 2022, 6:58am UTC](https://forum.dynamobim.com/t/rename-piping-system-with-excel/82273/12 "2022-10-21T06:58:22Z")

</div>

Solved! Thank you!

---

<div class="post-metadata">

**Author:** ![sb1102222](https://avatars.discourse-cdn.com/v4/letter/s/ccd318/32.png) [@sb1102222](https://forum.dynamobim.com/u/sb1102222)\
**Post date:** [October 25, 2022, 5:43am UTC](https://forum.dynamobim.com/t/rename-piping-system-with-excel/82273/13 "2022-10-25T05:43:44Z")

</div>

I have a new problem about this topic. Now,I am using this script to rename Annotation Symbols Family Name, but what I change is Type Name.  
I tried SetparameterbyName,it is not work.  
Do you have any advices to solve it?

 ![1](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/5/f5f495fc76fad2c413cee8149962ab3eb4b1fb61.jpeg)
