Cannot load integers from lookup table into revit family

[Anonymous]

Hi,

This issue is causing me a lot of headaches, especially because I've never had this problem in the past. For some obscure reason I'm unable to import integers from my .csv file into revit family, even though the colom head is designated correctly as noh##other##. I keep on getting the "inconsistent units" error message, even though for the life of me I cannot locate this so-called inconsistency.

I'm asking any and all experienced eyes to help me troubleshoot this. It might be something very obvious, or something deeply technical. I've attached the error screenshot, family and .csv file for reference

Would deeply appreciate any assistance on this matter!

[barthbradley]

Can't open the attached CSV file. 

[barthbradley · Accepted solution]

@Anonymous: I opened your RVT and checked out your Lookup Table. The Lookup Value  units (first named column in your table) is ##Length## and the "noh" column is ##other#. These are the two columns Revit is comparing. It can't compare different units.  Why not just change "noh" to ##Length##,  and make your NO HOLES family parameter of the Type Length. Then create another parameter of the Type Integer with the formula =(NO HOLES*1mm) ? 

[Alfredo_Medina]

@Anonymous

Lookup tables are intended to store sizes (length). For other purposes such as yes/no parameters, or text values, use a type catalog.

[Anonymous]

Hi Bradly,

Thanks a lot, Clever workaround. I have been able to look integer values up from lookup tables with lengths as references before though, Why is it not working anymore? I can load you a family that does work, but it was created in Revit 2017, was there a change perhaps with the new version?

Appreciate the help regardless

[Wernerlang]

@Alfredo_Medina  if you would like to use "int" in forumals your type catalogue won't work!

[Alfredo_Medina]

---

@Wernerlang wrote:

@Alfredo_Medina  if you would like to use "int" in formulas your type catalog won't work!

---

Excuse me? What are you referring to? 

[daniel.taylorC2FLJ]

Thank you Alfredo, this just really helped!

[Moustafa_El-Dakhakhny]

This is a smart and creative way to solve it. It worked. Thank you!