Excel family parameter values import to revit

Revit
,
1

Hi team,

I tried creating a ‘Dynamo script’ to import excel values of a family parameter values to Revit model.

But I have ended up in a warning (please find enclosed attachments).

Warning - “The parameter’s storage type is not a string”.

Actually, the script should read ‘Family parameter (FCT-1,2…)’ —> take ‘Height sch’ and ‘Radius sch’ values from excel and feed it to the Revit family parameters.

image
image1549×742 197 KB

Please correct where have done the mistake.

2

Hi,
Please make sure to check the data type of the family parameter. You are converting the value to a string, but the family parameter expects a different data type.

2 Likes
3

I believe the root problem lies with the collector as well.
This workflow requires you to consider the following;

  1. Collect from a Family Symbol or Instance
  2. Pair the ID together to isolate the family type or family
  3. Read the information across and embed the parameter values by parameter name.

To note that this will brute force the system and warnings will not prompt automatically if anything goes wrong.

Post script run, best to run a check through the model for these items.
I would ideally like to generate isolated affected elements by view for the check.

Hope that helps.

4

IF the parameter storageType is double or integer you have to feed it at number not a string

image
image1025×791 57.4 KB

5

Thanks resolved now…