I am trying to create a family with the use of a lookup tables and I have came across some “issues”.
1. Why Revit does not read the value form the csv file - the file was created from scratch - for the corresponding column, which was set in the lookup formula (family type editor)?
Below I put a description what I did as a simple exercise in order to understand how the system works:
I created a csv file:, OuterDia##length##millimeters, InnerDia##length##millimeters
15, 16, 14
20, 21, 19
25, 26, 24
32, 33, 30
and I saved this as Coupling.csv and my family file as Coupling.rft . In the family type editor I set parameters: RadiusA, RadiusB, DimA (all length type). My lookup formula for the parameter DimA is:
text_file_lookup("Coupling.csv", "OuterDia", RadiusB, RadiusA)
where as far as I understand the command reads:
text_file_lookup – name of the formula
"Coupling.csv" – name of the csv file (I could also put the name as a txt parameter and just place the name of that parameter in the formula)
"OuterDia" – name of the column header from where the corresponding value will be taken,
RadiusB – the name of the parameter which value will be put for the DimA in case if the RadiusA will not have the corresponding value in csv file (first column which describes the types)
RadiusA – the name of the parameter which value will be used in order to compare it with the value from the first column of the csv file (I called it input to the formula)
By studying the default lookup tables and default files, the way I understand how the software works is: If the value for RadiusA is 15, Revit looks in the csv file for the corresponding value from the first column and reads the value in the same row but from the column specified in the lookup formula, in my case OuterDia, and then puts this value back to the parameter RadiusA. It should be 16. When I tested some default lookup tables and default families I noticed this is the way how it works. Somehow this does not work in my case. E.g. If my value for RadiusA is 2 and for RadiusB is 5 then value of DimA will be what? Ready ? :-)) It depends what parameter goes after the header name in the look up formula. If it's RadiusA then will be 2, if RadiusB, then 5. But this is not how this works in "default" file which comes with Revit MEP.
Also what I found out if you modify the default lookup csv files in terms of adding new values (rows) the software does not read them. Also when I add a new column to the default csv file Revit does not read it neither.
I thought It could be the version of Revit MEP I have but not. I de-installed and installed a new Revit MEP which I downloaded from Autodesk website. It did not work neither.
I restart Revit every single time when I modyfied the csv file, I put the csv file in the specified folder, I checked the ini file where the path for lookup tables folder is.
Is there anything wrong with my understanding of how the lookup formula works? I am doing something wrong?
Please - Any help will be greatly appreciate.
Thanks for the reply in advance.