• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Autodesk Inventor

    Reply
    *Brentner, Jack

    iPart - concatenate custom prop with custom parameter

    67 Views, 3 Replies
    11-25-2002 06:13 AM
    I'm making a drill bushing ipart with the ID as a customer parameter that
    the user enters (since a myriad of ID's can be called for). Then I have a
    custom property, STOCK, in the parent that I'm trying to populate by the
    formula:

    =CONCATENATE("SF-",A2,"x",B2,"x",C2)

    Where:
    A2 = the ID, a custom parameter [value initially 0.25]
    B2 = the OD, key number 1 [value initially 0.5]
    C2 = the LENGTH, key number 2 [value initially 1]

    In the spreadsheet, the STOCK column initially computes to: SF-0.25x0.5x1

    Then when I go to use this custom iPart and define the ID to .138, the STOCK
    property still reads SF-0.25x0.5x1 (not SF-0.138x0.5x1 as expected). Any
    tips to get this to work like it "should"? I've posted the ipart in CF for
    review.

    And another thing. How come Autodesk don't figure you'd want Inventor to
    suggest a filename instead of dumb Part1, etc. so this concatenate can be
    the default filename?

    Thanks Many,
    Jack
    Please use plain text.
    *Dotson, Sean

    Re: iPart - concatenate custom prop with custom parameter

    11-25-2002 09:56 AM in reply to: *Brentner, Jack
    Not off the top of my head as the concatenate function is getting the info
    from the default values in the Excel sheet. The custom ID is getting passed
    directly to the model and not thru the Excel sheet. AFAIK there is not a
    way to do this. Let me give it some thought however.

    Sean Dotson
    http://www.sdotson.com
    ...sleep is for the weak...

    "Jack Brentner" wrote in message
    news:CDCAE5F52AEB217E9AAC407ABB14B358@in.WebX.maYIadrTaRb...
    > I'm making a drill bushing ipart with the ID as a customer parameter that
    > the user enters (since a myriad of ID's can be called for). Then I have a
    > custom property, STOCK, in the parent that I'm trying to populate by the
    > formula:
    >
    > =CONCATENATE("SF-",A2,"x",B2,"x",C2)
    >
    > Where:
    > A2 = the ID, a custom parameter [value initially 0.25]
    > B2 = the OD, key number 1 [value initially 0.5]
    > C2 = the LENGTH, key number 2 [value initially 1]
    >
    > In the spreadsheet, the STOCK column initially computes to: SF-0.25x0.5x1
    >
    > Then when I go to use this custom iPart and define the ID to .138, the
    STOCK
    > property still reads SF-0.25x0.5x1 (not SF-0.138x0.5x1 as expected). Any
    > tips to get this to work like it "should"? I've posted the ipart in CF for
    > review.
    >
    > And another thing. How come Autodesk don't figure you'd want Inventor to
    > suggest a filename instead of dumb Part1, etc. so this concatenate can be
    > the default filename?
    >
    > Thanks Many,
    > Jack
    >
    >
    >
    Please use plain text.
    *Brentner, Jack

    Re:

    11-25-2002 10:29 PM in reply to: *Brentner, Jack
    Thanks Sean,

    Thanksgiving weekend is coming up. Maybe it's time to dig into the Inventer
    VBA API next. There seems to me that this variable property and file naming
    is among a few simple things that a self-respecting programmer at Autodesk
    could have done to flesh out iParts. The other one that would have been a
    real benefit would have been custom parameter acceptable ranges PER line
    item entry. Afterall, you can't make a 3/4 OD drill bushing with a 1 inch
    bore, nor can you make a 1/2 OD drill bushing that has a 0.144 bore any
    longer than 1-3/4, but a 5/16 bore can be up to 2-1/8 long. I suspect there
    are many interdimensional relationships of this nature that iParts cannot
    address. But then you get into chicken and egg issues. So maybe not so easy.

    Many Thanks,
    Jack

    "Sean Dotson" wrote in message
    news:AAFC0BC3277BEA84377F55215D0B5E63@in.WebX.maYIadrTaRb...
    > Not off the top of my head as the concatenate function is getting the info
    > from the default values in the Excel sheet. The custom ID is getting
    passed
    > directly to the model and not thru the Excel sheet. AFAIK there is not a
    > way to do this. Let me give it some thought however.
    >
    > Sean Dotson
    > http://www.sdotson.com
    > ...sleep is for the weak...
    >
    > "Jack Brentner" wrote in message
    > news:CDCAE5F52AEB217E9AAC407ABB14B358@in.WebX.maYIadrTaRb...
    > > I'm making a drill bushing ipart with the ID as a customer parameter
    that
    > > the user enters (since a myriad of ID's can be called for). Then I have
    a
    > > custom property, STOCK, in the parent that I'm trying to populate by the
    > > formula:
    > >
    > > =CONCATENATE("SF-",A2,"x",B2,"x",C2)
    > >
    > > Where:
    > > A2 = the ID, a custom parameter [value initially 0.25]
    > > B2 = the OD, key number 1 [value initially 0.5]
    > > C2 = the LENGTH, key number 2 [value initially 1]
    > >
    > > In the spreadsheet, the STOCK column initially computes to:
    SF-0.25x0.5x1
    > >
    > > Then when I go to use this custom iPart and define the ID to .138, the
    > STOCK
    > > property still reads SF-0.25x0.5x1 (not SF-0.138x0.5x1 as expected). Any
    > > tips to get this to work like it "should"? I've posted the ipart in CF
    for
    > > review.
    > >
    > > And another thing. How come Autodesk don't figure you'd want Inventor to
    > > suggest a filename instead of dumb Part1, etc. so this concatenate can
    be
    > > the default filename?
    > >
    > > Thanks Many,
    > > Jack
    > >
    > >
    > >
    >
    >
    Please use plain text.
    *Dotson, Sean

    Re:

    11-25-2002 11:01 PM in reply to: *Brentner, Jack
    I agree Jack. I would like to see at the very least the functionality to
    "suggest" a filename for custom iparts.

    --
    Sean Dotson, PE
    http://www.sdotson.com
    ...sleep is for the weak..
    -----------------------------------------
    "Jack Brentner" wrote in message
    news:28CEDF37306766C46840853714523B45@in.WebX.maYIadrTaRb...
    > Thanks Sean,
    >
    > Thanksgiving weekend is coming up. Maybe it's time to dig into the
    Inventer
    > VBA API next. There seems to me that this variable property and file
    naming
    > is among a few simple things that a self-respecting programmer at Autodesk
    > could have done to flesh out iParts. The other one that would have been a
    > real benefit would have been custom parameter acceptable ranges PER line
    > item entry. Afterall, you can't make a 3/4 OD drill bushing with a 1 inch
    > bore, nor can you make a 1/2 OD drill bushing that has a 0.144 bore any
    > longer than 1-3/4, but a 5/16 bore can be up to 2-1/8 long. I suspect
    there
    > are many interdimensional relationships of this nature that iParts cannot
    > address. But then you get into chicken and egg issues. So maybe not so
    easy.
    >
    > Many Thanks,
    > Jack
    >
    > "Sean Dotson" wrote in message
    > news:AAFC0BC3277BEA84377F55215D0B5E63@in.WebX.maYIadrTaRb...
    > > Not off the top of my head as the concatenate function is getting the
    info
    > > from the default values in the Excel sheet. The custom ID is getting
    > passed
    > > directly to the model and not thru the Excel sheet. AFAIK there is not
    a
    > > way to do this. Let me give it some thought however.
    > >
    > > Sean Dotson
    > > http://www.sdotson.com
    > > ...sleep is for the weak...
    > >
    > > "Jack Brentner" wrote in message
    > > news:CDCAE5F52AEB217E9AAC407ABB14B358@in.WebX.maYIadrTaRb...
    > > > I'm making a drill bushing ipart with the ID as a customer parameter
    > that
    > > > the user enters (since a myriad of ID's can be called for). Then I
    have
    > a
    > > > custom property, STOCK, in the parent that I'm trying to populate by
    the
    > > > formula:
    > > >
    > > > =CONCATENATE("SF-",A2,"x",B2,"x",C2)
    > > >
    > > > Where:
    > > > A2 = the ID, a custom parameter [value initially 0.25]
    > > > B2 = the OD, key number 1 [value initially 0.5]
    > > > C2 = the LENGTH, key number 2 [value initially 1]
    > > >
    > > > In the spreadsheet, the STOCK column initially computes to:
    > SF-0.25x0.5x1
    > > >
    > > > Then when I go to use this custom iPart and define the ID to .138, the
    > > STOCK
    > > > property still reads SF-0.25x0.5x1 (not SF-0.138x0.5x1 as expected).
    Any
    > > > tips to get this to work like it "should"? I've posted the ipart in CF
    > for
    > > > review.
    > > >
    > > > And another thing. How come Autodesk don't figure you'd want Inventor
    to
    > > > suggest a filename instead of dumb Part1, etc. so this concatenate can
    > be
    > > > the default filename?
    > > >
    > > > Thanks Many,
    > > > Jack
    > > >
    > > >
    > > >
    > >
    > >
    >
    >
    Please use plain text.