Inventor General Discussion

Inventor General Discussion

Reply
*Brentner, Jack
Message 1 of 4 (86 Views)

iPart - concatenate custom prop with custom parameter

86 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
*Dotson, Sean
Message 2 of 4 (86 Views)

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
>
>
>
*Brentner, Jack
Message 3 of 4 (86 Views)

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
> >
> >
> >
>
>
*Dotson, Sean
Message 4 of 4 (86 Views)

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
> > >
> > >
> > >
> >
> >
>
>
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.