Results 1 to 10 of 10

Thread: Manufacturer Part Numbers?

  1. #1
    Junior Member
    Join Date
    March 5, 2015
    Posts
    5
    Current Local Time
    09:45 AM

    Not allowed! Not allowed!

    Manufacturer Part Numbers?

    Hi. I'm trying to create manufacturer specific pipe fitting libraries. Is it possible to add manufacturer part numbers to individual sizes of components? E.G. I have made an elbow family using lookup tables, but I can't see how I can add the unique part numbers to each individual size of elbow. Any ideas?

  2. #2
    Forum Addict josephpeel's Avatar
    Join Date
    May 3, 2012
    Posts
    1,402
    Current Local Time
    10:45 AM

    Not allowed! Not allowed!
    2 options.

    1. Put the part numbers in the lookup table, in the correct row with the diameters. Then in the family make an instance parameter for part number (Shared parameter if you want to tag/schedule it) and then use; =size_lookup(Lookup Table Name, "Column with part number", Size, Value if not found) in the formula to get the part number. (Or something like that, check the exact syntax).

    2. Use an If formula; =If(Size > X, "Part Number X", If(Size > Z, "Part Number Z", If(...... and so on. (Write it in notepad with tabs and line breaks, they disappear when you paste to revit).
    Last edited by josephpeel; March 6th, 2015 at 01:03 PM.

  3. #3
    Forum Addict tzframpton's Avatar
    Join Date
    January 17, 2011
    Location
    Dallas, TX
    Posts
    2,062
    Current Local Time
    03:45 AM

    Not allowed! Not allowed!
    Quote Originally Posted by josephpeel View Post
    (Write it in notepad with tabs and line breaks, they disappear when you paste to revit).
    Reeeeeally? Tip of the century right here!! I wanna try this in Notepad++....

  4. #4
    Forum Addict josephpeel's Avatar
    Join Date
    May 3, 2012
    Posts
    1,402
    Current Local Time
    10:45 AM

    Not allowed! Not allowed!
    ((It beats trying to write 20 if statements inside each other in a tiny text bo)...unexpected end of statement

  5. #5
    Junior Member
    Join Date
    March 5, 2015
    Posts
    5
    Current Local Time
    09:45 AM

    Not allowed! Not allowed!
    Thanks Joseph, much appreciated.

    Killian

  6. #6
    Junior Member
    Join Date
    March 5, 2015
    Posts
    5
    Current Local Time
    09:45 AM

    Not allowed! Not allowed!
    Hi, I'm finally getting around to looking at this again. I got it to work if the manufacturer part number is numberical only, using a number type shared parameter using the following formula =size_lookup(Lookup Table Name, "Part_Code", 0, Nominal Diameter / 1).
    If the Part number has any letters in it, it won't work with that formula, so I tried creating a text type shared parameter, but then I can't get the formula to work, it just says "Invalid Input". Any ideas please? Thanks

  7. #7
    Junior Member
    Join Date
    August 7, 2015
    Location
    USA
    Posts
    11
    Current Local Time
    01:45 AM

    Not allowed! Not allowed!
    Quote Originally Posted by Kilian View Post
    =size_lookup(Lookup Table Name, "Part_Code", 0, Nominal Diameter / 1).
    If the Part number has any letters in it, it won't work with that formula, so I tried creating a text type shared parameter, but then I can't get the formula to work, it just says "Invalid Input".
    Did you ever get it to work?

    this was my solution; I created a Text instance parameter with the following formula

    if(and(D1 = 1/2", D2 = 1/2", Angle = 90░), "9801-005", if(and(D1 = 3/4", D2 = 3/4", Angle = 90░), "9801-007",if(and(XX = size, XX2 = size, XX? = size/angle), "Partnumber","0")))

    anything you want to be "Text" actually has to be surrounded by Quotes, even your "false" statement has to be surrounded by Quotes. replace my Variables with yours and continue added the sizes. i set up a template at the end. XX? may not be needed depended on your constraints, everything in red can be deleted if not needed. don't forget to add a parenthesis at the end for every additional if(and( Statment

  8. #8
    Junior Member
    Join Date
    March 5, 2015
    Posts
    5
    Current Local Time
    09:45 AM

    Not allowed! Not allowed!
    Hi, yes I got it to work using the formula like you suggested. It would be great if we could add a text column for part numbers into the lookup table instead of typing all the part numbers into a formula - but hey it works so thats good. I have added two shared parameters to my parts, one is the Manufacturer Part Number (using the formula & shared text parameter), the other is our company order code (using the lookup table and a Shared number parameter). I just have one question, how do I stop it adding the decimal place and all the zero's?
    Thanks for the help guys.

    Click image for larger version. 

Name:	Revit.PNG 
Views:	11 
Size:	64.9 KB 
ID:	23184

  9. #9
    Member evan.dodds's Avatar
    Join Date
    December 29, 2014
    Location
    Calgary, Canada
    Posts
    219
    Current Local Time
    02:45 AM

    Not allowed! Not allowed!
    In your project schedules you can change your unit formatting. So I would un-check "use default settings" and change my number units to fixed. This allows you to change your rounding to however many decimal places you want.
    Click image for larger version. 

Name:	Unit formatting.PNG 
Views:	7 
Size:	23.2 KB 
ID:	23191

  10. #10
    Junior Member
    Join Date
    March 5, 2015
    Posts
    5
    Current Local Time
    09:45 AM

    Not allowed! Not allowed!
    Thanks Evan

Similar Threads

  1. Any exemplary manufacturer-produced lighting families?
    By hywd6545 in forum Architecture - Family Creation
    Replies: 3
    Last Post: February 26th, 2014, 05:17 PM
  2. Manufacturer Content
    By Cyus in forum Architecture and General Revit Questions
    Replies: 3
    Last Post: October 4th, 2013, 02:03 PM
  3. Manufacturer Rage
    By thewrz in forum MEP - Family Creation
    Replies: 4
    Last Post: February 3rd, 2012, 04:10 AM
  4. Manufacturer Lights, IES Files, Problem
    By rpmarchitecture in forum Rendering and Gallery
    Replies: 43
    Last Post: December 31st, 2011, 11:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •