RevitCity.com Logo

Home  |  Forums  |  Downloads  |  Gallery  |  News & Articles  |  Resources  |  Jobs  |  FAQ  |  SearchSearch  |  Join  |  LoginLogin

Welcome !

255 Users Online (151 Members): Show Users Online - Most ever was 487 - Tue, Dec 3, 2013 at 3:44:27 PM

 

Forums

Forums >> Revit Systems >> Technical Support >> Revit MEP lookup tables / csv files

Search this ThreadSearch this Thread | Page 1 of 1 |

Sun, Sep 2, 2007 at 1:35:09 PM | Revit MEP lookup tables / csv files

#1

norby


active

Joined: Tue, Jun 12, 2007
4 Posts
5 Stars: 1 Votes


Hi there

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.

norby



Attached Files

This user is offline

 

Sun, Sep 2, 2007 at 5:27:00 PM | Revit MEP lookup tables / csv files

#2

norby


active

Joined: Tue, Jun 12, 2007
4 Posts
5 Stars: 1 Votes


Hi,

 I found where the problem was. Thanks to Martin Schmid and his paper "Creating Autodesk Revit Systems Content for Engineering Coordination".

My mistake was I thought that: "...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..."

 Actually this is THE SECOND COLUMN in the csv file...

Problem solved.

Regs.

N


This user is offline

 

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

New Help with Lookup Tables on MEP

Revit Systems >> Technical Support

Tue, Aug 24, 2010 at 6:51:45 PM

1

Difference Between CSV/TXT Lookup Tables and Family Types?

Community >> Newbies

Wed, Aug 3, 2011 at 11:02:56 PM

8

victaulic elbows

Revit Systems >> Technical Support

Fri, Mar 7, 2014 at 3:55:17 PM

1

PIPE SIZES TROUBLE in MEP 2012

Community >> The Studio

Fri, Sep 21, 2012 at 10:53:45 PM

1

Lookup tables - looking up numbers, getting Invalid Input

Revit Systems >> Technical Support

Tue, Oct 14, 2014 at 11:49:40 AM

4

Site Stats

Members:

556747

Objects:

15515

Forum Posts:

131680

Job Listings:

3

Home | Forums | Downloads | Gallery | News & Articles | Resources | Jobs | Search | Advertise | About RevitCity.com | Link To Us | Site Map | Member List | Firm List | Contact Us

Copyright 2003-2010 Pierced Media LC, a design company. All Rights Reserved.

Page generation time: 1.4914

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights