# Set Parameter error "Parameter storage type is not a number"

**URL:** <https://forum.dynamobim.com/t/set-parameter-error-parameter-storage-type-is-not-a-number/17760>\
**Category:** Revit\
**Tags:** dynamo\
**Created:** [December 29, 2017, 6:56am UTC](https://forum.dynamobim.com/t/set-parameter-error-parameter-storage-type-is-not-a-number/17760 "2017-12-29T06:56:24Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![sps.25788](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sps.25788](https://forum.dynamobim.com/u/sps.25788)\
**Post date:** [December 29, 2017, 6:56am UTC](https://forum.dynamobim.com/t/set-parameter-error-parameter-storage-type-is-not-a-number/17760/1 "2017-12-29T06:56:24Z")

</div>

Hello,

I am new to the dynamo and this community too. I am working on write and read from excel to Pipe schedule.  
While writing excel it works fine but reading from same excel it shows error on “SetParameter” Node.

Also reading same problems like this on the community pages. But didn’t find any logic behind this error. For someone’s it works fine.

Please see below snaps

 ![Parameter's storage type not number](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/5/95478dcac2f008befb7a69661552b7b1ffff2778.JPG)

It just pipe schedule with mark, length and dia. List works fine till getitemIndex.

Please suggest better way

---

<div class="post-metadata">

**Author:** ![Robert2017](https://avatars.discourse-cdn.com/v4/letter/r/b2d939/32.png) [@Robert2017](https://forum.dynamobim.com/u/Robert2017)\
**Post date:** [December 29, 2017, 10:06am UTC](https://forum.dynamobim.com/t/set-parameter-error-parameter-storage-type-is-not-a-number/17760/2 "2017-12-29T10:06:29Z")

</div>

Length is read only parameter. Data type of Mark is string.

 ![Dynamo_1_1](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/3/639ea8c26c22c324436578a9e9185309348d1291.png)

---

<div class="post-metadata">

**Author:** ![sps.25788](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sps.25788](https://forum.dynamobim.com/u/sps.25788)\
**Post date:** [December 29, 2017, 10:38am UTC](https://forum.dynamobim.com/t/set-parameter-error-parameter-storage-type-is-not-a-number/17760/3 "2017-12-29T10:38:49Z")

</div>

Thanks Robert2017.

That means I cant change length parameter. Understood about the Mark.  
What about the Diameter?

I Was just trying to understand which parameter we can change by excel. How useful excel importing in revit.

---

<div class="post-metadata">

**Author:** ![Robert2017](https://avatars.discourse-cdn.com/v4/letter/r/b2d939/32.png) [@Robert2017](https://forum.dynamobim.com/u/Robert2017)\
**Post date:** [December 29, 2017, 10:47am UTC](https://forum.dynamobim.com/t/set-parameter-error-parameter-storage-type-is-not-a-number/17760/4 "2017-12-29T10:47:36Z")

</div>

You can change the length but only if you set new start or/and end points of pipes. You can control almost everything by excel but part of them is harder than other.

 ![Dynamo_1_2](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/c/0c22d6b3166be224d2b4ab74da4437f390955fd7.png)

---

<div class="post-metadata">

**Author:** ![sps.25788](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sps.25788](https://forum.dynamobim.com/u/sps.25788)\
**Post date:** [January 2, 2018, 8:31am UTC](https://forum.dynamobim.com/t/set-parameter-error-parameter-storage-type-is-not-a-number/17760/5 "2018-01-02T08:31:10Z")

</div>

Okay. Thanks Robert2017.

Stay tuned for upcoming queries 😀

---

<div class="post-metadata">

**Author:** ![sps.25788](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sps.25788](https://forum.dynamobim.com/u/sps.25788)\
**Post date:** [January 5, 2018, 4:40am UTC](https://forum.dynamobim.com/t/set-parameter-error-parameter-storage-type-is-not-a-number/17760/6 "2018-01-05T04:40:34Z")

</div>

Hi Robert,

see below snap, as per your suggestion I have made this script. After running the script my all marks turn in to 0 value, cause we added code block 0 to the set parameter value.  
I wanted to read this as mark I have added in revit file. I have added those as 1,2,3,4.

Please advise.

 ![Dynamo_Mark](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/3/d3ab02c3bca90aa71644c616636988eead9e922f.JPG)

---

<div class="post-metadata">

**Author:** ![Robert2017](https://avatars.discourse-cdn.com/v4/letter/r/b2d939/32.png) [@Robert2017](https://forum.dynamobim.com/u/Robert2017)\
**Post date:** [January 7, 2018, 1:05pm UTC](https://forum.dynamobim.com/t/set-parameter-error-parameter-storage-type-is-not-a-number/17760/7 "2018-01-07T13:05:10Z")

</div>

1. You have to sort list of element as you want.
2. Then generate number from 1 to n and change it to string.
3. Then set value to Mark parameter.  
 ![ForumDynamoBIM_20171229_0756_3](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/5/f/5f4b5e1682cc850a2e6edeabfae0c83bd467ff15.png)
