Community
Inventor Forum
Welcome to Autodesk’s Inventor Forums. Share your knowledge, ask questions, and explore popular Inventor topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

iPart - concatenate custom prop with custom parameter

3 REPLIES 3
Reply
Message 1 of 4
Anonymous
322 Views, 3 Replies

iPart - concatenate custom prop with custom parameter

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
3 REPLIES 3
Message 2 of 4
Anonymous
in reply to: Anonymous

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
>
>
>
Message 3 of 4
Anonymous
in reply to: Anonymous

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
> >
> >
> >
>
>
Message 4 of 4
Anonymous
in reply to: Anonymous

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
> > >
> > >
> > >
> >
> >
>
>

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report