Ilogic Multi value list from Excle

[Anonymous]

greetings all...

i would like to thank everyone who helps/post/comments in this group. it has help me with so much 🙂

but, i do have a question. i am trying to create a multi-value User Parameter that gets its values from an Excel file. but i think my workflow or something is going wrong (see attached images).

as you can see, i just started a blank assembly, created a text User Parameter, wrote the basic code to read my Excel file (you can see from the image that when I hover my mouse over the parameter name it lists the values that I want). but when I go to my Parameters dialog box, my drop down box is empty. what am i missing here? what is the correct workflow for setting this up correctly.

also, i am currently using INV2013

thanks

[Anonymous]

i really don't understand what i am doing wrong here. i keep starting fresh and recreating everything. i even started a new excel file and tried.

i have found and followed some examples.

is there some workflow that is different when the User Parameter is a Text field?

please help 😞

[Chirpyboy2060647]

Well I think the issue might be the Unit/Type is Text instead a unit of measurement. I just remade your code on a test project and mine works fine. But the Unit is Inches, not text.

[Anonymous]

thanks for replying 🙂

i know, i have tried that as well, and it works as Units. but i should be able to bring in Text values as well. i had found an example on GrabCAD that shows that Text in an Excel sheet can be used for a multi-value list as well. but i can't seem to duplicate that example. i'm not sure if it is the formatting in Excel or am i missing a step in Inventor.

here is a screen capture of the example that i have found and works

[Chirpyboy2060647]

Well its hard to see with this image. But couldnt you just click where it says Text in inventor and just change it to inches or whatever unit of measure you need? Or does it not let you change this?

[Anonymous]

sorry about the screen capture. it got scaled down when i added it

you can't change a user parameter type once it is created.

i just don't understand why i cannot bring a text list from Excel in Inventor thru iLogic. even tho the examples i found show that you can, and the training manual for iLogic i have says that you can. my workflow must be wrong somehow

thanks for replying

[Curtis_Waguespack]

Hi leonardbordian,

Here is a link to your original image:

/t5/image/serverpage/image-id/211408iF574F8976E3A8894/image-size/original?v=mpbl-1&px=-1

I keep meaning to work up an example for you on this, but haven't found the time, but the short answer is that I think you'll need to hand the Excel data to an ArrayList, and then set the parameter to use the arraylist.

Here's an example, although it is not the most straightforward one for what you're after (see Mike Deck's reply) :

http://forums.autodesk.com/t5/inventor-customization/multi-value-list-from-excel-sheet-names/m-p/287...

I hope this helps.
Best of luck to you in all of your Inventor pursuits,
Curtis
http://inventortrenches.blogspot.com

[Chirpyboy2060647]

Hmmm, yeah I didn't realize this before as I was just using numbers for my excel-params (also thank you for posting this cause this actually got me some kudos from my boss. We are going to be doing stock items soon and this helped me start creating a few drawings now to use to quickly get these stock items out to shop.) I think youre missing a step that's calling out what each Text Material is as a number.

So for Cast Bronze needs its own parameter that = a number or whatever, and then it can call that when you pull down under the Materials number. Ill add a picture that shows you what we use that still uses text as the value, but that the text parameter has an equation somewhere else. Probly easier once you see it.

Edit....Ok that was per the example image you showed. But I believe the same applies. Could you show the same image in a sense as for what your excel/ilogic shows?

[Anonymous]

i've been playing around some more with this. so i thought i would combine both Text and Number values in my Excel sheet. and it seems that Inventor doesn't recognize my Number values as Text, which is what i want for my application.

i'm fairly new at iLogic but i can work my way thru the code to get the results i want. once i get passed this one hurdle, i believe the rest of what i want will fall into place nicely

[Anonymous]

i'm very sure i don't know how to do this 😞

i keep trying with the help of this group, blog pages, etc...

but i cannot seem to get the results

i know now that i have to convert (somehow) my Number values (which are Size/Part Numbers) in Excel, to be Text values in Inventor so that i can create my Multi value list in iLogic.

i know that i can hard code my iLogic for the results i want, but i need to be able to get all my values from a multi-tab Excel file

any other suggestions, please?

thanks

[Chirpyboy2060647]

Well pretty much to get that you need to make a parameter for each Text value you have in excel and set its numerical value in that parameter. So if you have "Steel" as a text param option, then it needs its own separate param that says "Steel" is "X inches". So that when you Select "Steel" on your multivalue it can pull a numeric number.

Im hoping this is what youre looking to do with it. Unless you are just trying to call these out as parts for a Bill of Materials...Then what ive been saying has been wrong and I misunderstood Haha