Inventor IdeaStation
Share your ideas about how to improve Inventor with the Development Team.
11 Kudos
LT.Rusty

Text Parameters & iParts, Excel Spreadsheets

Status: New Idea
by *Expert Elite* on ‎12-07-2012 09:46 AM

I've got a ton of parts that I work with that are identical with the exception of color & markings, and I'd love to be able to make better use of iParts.  Colors are no problem, but the markings can be.  The way it works right now, I have to make individual extrusion or emboss features for each different marking, and then suppress / unsuppress in each factory member.  Wouldn't it be great to be able to just make one extrusion which calls the text to be extruded from a parameter, and then just vary the parameter in the factory members?

 

Also, why can't we bring text parameters in from Excel spreadsheets?  That particular restriction just doesn't seem to make sense.  If Inventor can figure out that "in" or "ul" or "lbforce" in the third column means something, then it doesn't seem like it'd be difficult to figure out what "text" in the third column would mean ...

Comments
by HericS on ‎03-15-2013 08:44 AM

Does somebody knows the answer to what LT. Rusty is asking on this post? I have a similar situation where I need to import a text rather than unit or unitless. I know we can do that directly within the inventor parameters but I need this to be controlled with my excel spreadsheet.

 

I would appreciate any help on this matter.

 

Thanks,

 

Eric

by LarrenSmoot on ‎08-13-2013 03:05 PM

I have a work around to get specific Text into the Inventor model using numeric data.  I have models driven by over 400 parameters from Excel.  Thye all start as numbers but can be translated back into text.  To make this work you must know and predefine the boundries of your text options. 

 

First you need to list and identify the text options you need and then identify them by number.

 

In Excel you can use something like a VLOOKUP or IF funtion to fill in the Parameter with a number.  The number is used to identify what text Inventor will select to put in it's place.

 

For instance, the Excel parameter will define the parameter.    

Example:

XL_Intake_Option = 3 in

 

 

Once you link the the Excel parameters to Inventor then Inventor will identy the parameter XL_Intake_Option with the number 3

 

 

Using iLogic you can write a simple rule that changes the number to text or in this case simply suppress or turn on certain parts or assemblies based on the option chosen in Excel. 

If XL_ENCLOSURE_INTAKE_OPTION = 1 Then

    'Inlet_style = "Louver_Intake"

    Component.IsActive("Wall_front") = False

    Component.IsActive("Wall_HF") = False

    Component.IsActive("Wall_HF2") = False

 

ElseIf XL_ENCLOSURE_INTAKE_OPTION = 2 Then

    'Inlet_style = "Hood_external"

    Component.IsActive("Wall_front") = False

    Component.IsActive("Wall_HF") = False

    Component.IsActive("Wall_HF2") = False

   

ElseIf XL_ENCLOSURE_INTAKE_OPTION = 3 Then

    'Inlet_style = "Hood_internal"

    Component.IsActive("Wall_front") = False

    Component.IsActive("Wall_HF") = True

    Component.IsActive("Wall_HF2") = True

 

ElseIf XL_ENCLOSURE_INTAKE_OPTION = 4 Then

    'Inlet_style = "Silencer_Intake"

    Component.IsActive("Wall_front") = True

    Component.IsActive("Wall_HF") = False

    Component.IsActive("Wall_HF2") = False

   

ElseIf XL_ENCLOSURE_INTAKE_OPTION = 5 Then

    'Inlet_style = "Sidewall_Louvers"

    Component.IsActive("Wall_front") = True

    Component.IsActive("Wall_HF") = False

    Component.IsActive("Wall_HF2") = False

   

ElseIf XL_ENCLOSURE_INTAKE_OPTION = 6 Then

    'Inlet_style = "Sidewall_Hood"

    Component.IsActive("Wall_front") = True

    Component.IsActive("Wall_HF") = False

    Component.IsActive("Wall_HF2") = False

   

ElseIf XL_ENCLOSURE_INTAKE_OPTION = 7 Then

    'Inlet_style = "Intake_Wall"

    Component.IsActive("Wall_front") = True

    Component.IsActive("Wall_HF") = False

    Component.IsActive("Wall_HF2") = False

 

ElseIf XL_ENCLOSURE_INTAKE_OPTION = 8 Then

    'Inlet_style = "SW_And_Intake_Louvers"

    Component.IsActive("Wall_front") = False

    Component.IsActive("Wall_HF") = False

    Component.IsActive("Wall_HF2") = False

 

End If

 

 

 

 

 

 

 

 

 

Submit Your Ideas

Share and shape product ideas.

New Idea
You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Inventor Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for Autodesk Inventor helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Inventor

Twitter

Facebook

Blogs

Pinterest

Youtube