# Wonder how can I change the offset value of imported column **URL:** \ **Category:** Revit\ **Tags:** dynamo\ **Created:** [September 3, 2019, 4:42am UTC](https://forum.dynamobim.com/t/wonder-how-can-i-change-the-offset-value-of-imported-column/40206 "2019-09-03T04:42:00Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![1109842070](https://avatars.discourse-cdn.com/v4/letter/1/ee59a6/32.png) [@1109842070](https://forum.dynamobim.com/u/1109842070)\ **Post date:** [September 3, 2019, 4:42am UTC](https://forum.dynamobim.com/t/wonder-how-can-i-change-the-offset-value-of-imported-column/40206/1 "2019-09-03T04:42:01Z")
Hi, after I imported my family column which has been set in Dynamo, the offset value cannot be changed, due to fixed location of Z value. Even though I changed the Z value in Dynamo to 10000, the result remains the same. The only one way to solve this issue is to change the original family type in Revit. The second question is when I have two types of column, such as 800 diameter and 1000 diameter column, I wonder how can I link this family type from excel to dynamo so that I can import all types of column to Revit at once? ![d358f14f833288ce41053986db23311](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/2/4264af1b66e2a74a30020af238ecacc02c3fd27a.png) ---
**Author:** ![jshial](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jshial/32/91559_2.png) [@jshial](https://forum.dynamobim.com/u/jshial)\ **Post date:** [September 3, 2019, 8:43am UTC](https://forum.dynamobim.com/t/wonder-how-can-i-change-the-offset-value-of-imported-column/40206/2 "2019-09-03T08:43:26Z")
You probably need to upload your family here. ---
**Author:** ![Nissal](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nissal/32/67016_2.png) [@Nissal](https://forum.dynamobim.com/u/Nissal)\ **Post date:** [September 3, 2019, 9:15am UTC](https://forum.dynamobim.com/t/wonder-how-can-i-change-the-offset-value-of-imported-column/40206/3 "2019-09-03T09:15:03Z")
@1109842070 to your first problem, columns you made has a fixed top and bottom level when it gets created. Z value to 10000 wont work. Now you can change Z value Try this: ![column%20edit](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/1/7105911a2374ec7817074b63e25dd0558b6bbaf1.png) ---
**Author:** ![Nissal](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nissal/32/67016_2.png) [@Nissal](https://forum.dynamobim.com/u/Nissal)\ **Post date:** [September 3, 2019, 9:17am UTC](https://forum.dynamobim.com/t/wonder-how-can-i-change-the-offset-value-of-imported-column/40206/4 "2019-09-03T09:17:38Z")
for second question, use IF node, and give a test to your list of diameter. i.e. 800 == true and others false. (1000 dia will be false) ---
**Author:** ![wr.marshall](https://avatars.discourse-cdn.com/v4/letter/w/91b2a8/32.png) [@wr.marshall](https://forum.dynamobim.com/u/wr.marshall)\ **Post date:** [September 11, 2024, 10:41am UTC](https://forum.dynamobim.com/t/wonder-how-can-i-change-the-offset-value-of-imported-column/40206/5 "2024-09-11T10:41:29Z")
Hi Nissal Used your script and tweaked it to my own requirements. Gave you Credit as you will see. Bare in mind attached script is a work in progress. I will eventually when I figure it out replace the sliders for “Top Offset” & “Base Offset” with the intersection levels of the toposolid/s which I mention in this post: [Align Top Bottom Column with Toposolid - Revit - Dynamo (dynamobim.com)](https://forum.dynamobim.com/t/align-top-bottom-column-with-toposolid/104161) The issue I am having though is that it seems to be **duplicating the Columns** already in the model and then assigning the predetermined offsets to the duplicates. The Duplicates are also blank for the Custom parameters of Easting and Northing. Please advise if satisfactory solution as to why it duplicates and how to avoid. Seeking a solution whereby: [1] It does not place **duplicate columns** , and instead adjusts the existing columns or [2] if it must place the **duplicate columns** that it deletes the origionals, and fills in the Easting and Northing Coordinates [Topo Solid Sample Project.rvt](https://forum.dynamobim.com/uploads/short-url/AkJ15kuCJE0EWcxhA8c0WO1jqH0.rvt) (2.6 MB) [Column - Coordinate & Level.dyn](https://forum.dynamobim.com/uploads/short-url/bNV5zGktDErjvgec9M5cAHcu8Ae.dyn) (49.1 KB)