Great video! I have a question for you. Say I made the same excel document populated with your data for practicing and I also have these parameters in Inventor. I have built an illogic form linked to the parameters with multiple-values. How can I “limit” the schedule pipe column parameter based on the selecting the pipe size? Basically I’m trying to understand how to limit what the available options are based on what I chose from the pipe size, if that makes sense lol. Kind of like using filters in excel to only show data the meets certain criteria when filtering. Hard to explain but hopefully you can understand what I’m trying to achieve and understand how to code. You do a great job of explaining the “language” in your video and it’s been helpful learning more illogic programming.
Yes that's possible using Excel columns and multi value parameters. You'll have to have a rule that runs automatically and some logic that refreshes the values of that parameter depending on the user's selection of another parameter... if that makes sense haha
I am interested in using this method to create part numbers. Ideally I would like to find out if an entry exists with the matching parameters and then reuse that, or if an entry does not exist in the spreadsheet, create the next entry and populate it with all the relevant parameters. This way I could automatically detect existing components and reuse them if possible. Also if it makes a difference, there's about 10 different parameters I need to monitor for each part.
@@DesignAutomationSolutions @Automation With iLogic I look forward to it :) I'm just about getting knee deep into ilogic and I've started fully automating a lot of my designs. My thoughts are that I can create a dynamic block in autocad then use those blocks to produce a data extraction table for products. That table could be read by inventor and the drawings fully automated from that. That would let me focus on the big picture and design assemblies in bulk. Just out of curiosity, once a spreadsheet of parts/assemblies is created, would I then be able to create a script to run automatically cycle through each spreadsheet entry and then export a pack of drawings and dxfs of every instance? So far I have been able to fully automate the drawings, and then produce a dxf flat pattern and a pdf pack for each component. But I manually have to switch between instances and then rerun the export code which can be very tedious with hundreds of variants. If you could include this in your video I would officially be your biggest fan 🙂
@@Nickgowans Watch my video that i post today! It's only an example but it shows a project that I did for a company that extracts the data from AutoCAD dynamic blocks then runs ilogic rules to generate those assemblies. You should be able to run through each spread sheet and each cell value. Is the spreadsheet meant for sheet metal components only?
@@DesignAutomationSolutions I have explained my janky workflow on your other video. I think I'm taking a slightly unusual approach to things so it would be hard to explain but basically I do not actually export my model once it's configured, I don't replace any components, I simply change the components which exist and update lots and lots of parameters for every part and then update the part number to suit. But often I find that some assemblies use matching components and it makes no sense to use unique part numbers for them so I need to retrieve any matching values from Excel, . And because I haven't got a saved itp file of that component anywhere on my project (because there is only 1 itp covering all variants) Its as though I am saving my parts within my spreadsheet. That means if someone wants to see the model of a specific assembly type, I have to select if from a multivalue list which is populated using said spreadsheet, then run the rule to update the assembly.
@@Nickgowans Yeah it's definitely possible to store that information onto the excel file. The only issue that comes up with is having too many users making updates to that excel file. Could cause some corruption on the excel file. Ideally, it should be Read-Only for majority of the engineers who are not programming or maintaining the code. I am having a bit of trouble trying to visualize how the assembly and the iLogic operate
i am getting the error, Error in rule: excel, in document: JHB-3DT-Cprofiel-trogstel.iam GoExcel: Could not match the column title: "lengte". do you have any suggestions?
Double check the column title because it is case sensitive. Also, by default it looks at the first row of the excel sheet so make sure the title is there. Make sure you launch the excel sheet correctly as well
You did an excellent job giving brief explanations of what the code was doing.
thank you!
Great work. Just subscribed!! Looking forward to learning from you.
Thanks, you are doing great work. Keep going
Thank you Tamar!
Great video! I have a question for you. Say I made the same excel document populated with your data for practicing and I also have these parameters in Inventor. I have built an illogic form linked to the parameters with multiple-values. How can I “limit” the schedule pipe column parameter based on the selecting the pipe size? Basically I’m trying to understand how to limit what the available options are based on what I chose from the pipe size, if that makes sense lol. Kind of like using filters in excel to only show data the meets certain criteria when filtering. Hard to explain but hopefully you can understand what I’m trying to achieve and understand how to code. You do a great job of explaining the “language” in your video and it’s been helpful learning more illogic programming.
Yes that's possible using Excel columns and multi value parameters. You'll have to have a rule that runs automatically and some logic that refreshes the values of that parameter depending on the user's selection of another parameter... if that makes sense haha
Tried it and the returned value is not the same as the on the the specified column/row. And the returned value is different eacht time. Very strange
I am interested in using this method to create part numbers. Ideally I would like to find out if an entry exists with the matching parameters and then reuse that, or if an entry does not exist in the spreadsheet, create the next entry and populate it with all the relevant parameters. This way I could automatically detect existing components and reuse them if possible. Also if it makes a difference, there's about 10 different parameters I need to monitor for each part.
I’ll make an upcoming video for this!
@@DesignAutomationSolutions @Automation With iLogic I look forward to it :) I'm just about getting knee deep into ilogic and I've started fully automating a lot of my designs. My thoughts are that I can create a dynamic block in autocad then use those blocks to produce a data extraction table for products. That table could be read by inventor and the drawings fully automated from that. That would let me focus on the big picture and design assemblies in bulk.
Just out of curiosity, once a spreadsheet of parts/assemblies is created, would I then be able to create a script to run automatically cycle through each spreadsheet entry and then export a pack of drawings and dxfs of every instance? So far I have been able to fully automate the drawings, and then produce a dxf flat pattern and a pdf pack for each component. But I manually have to switch between instances and then rerun the export code which can be very tedious with hundreds of variants. If you could include this in your video I would officially be your biggest fan 🙂
@@Nickgowans Watch my video that i post today! It's only an example but it shows a project that I did for a company that extracts the data from AutoCAD dynamic blocks then runs ilogic rules to generate those assemblies.
You should be able to run through each spread sheet and each cell value. Is the spreadsheet meant for sheet metal components only?
@@DesignAutomationSolutions I have explained my janky workflow on your other video. I think I'm taking a slightly unusual approach to things so it would be hard to explain but basically I do not actually export my model once it's configured, I don't replace any components, I simply change the components which exist and update lots and lots of parameters for every part and then update the part number to suit. But often I find that some assemblies use matching components and it makes no sense to use unique part numbers for them so I need to retrieve any matching values from Excel, . And because I haven't got a saved itp file of that component anywhere on my project (because there is only 1 itp covering all variants) Its as though I am saving my parts within my spreadsheet. That means if someone wants to see the model of a specific assembly type, I have to select if from a multivalue list which is populated using said spreadsheet, then run the rule to update the assembly.
@@Nickgowans Yeah it's definitely possible to store that information onto the excel file. The only issue that comes up with is having too many users making updates to that excel file. Could cause some corruption on the excel file. Ideally, it should be Read-Only for majority of the engineers who are not programming or maintaining the code.
I am having a bit of trouble trying to visualize how the assembly and the iLogic operate
good morning. One question: is it possible to protect the code I wrote ? This also to don't permit accidental edit by the customer. Thanks
I have made a little more of same like you ....but it is showing me message- Could not match the column title: "Pipe size"
Plz help required.
i am getting the error, Error in rule: excel, in document: JHB-3DT-Cprofiel-trogstel.iam
GoExcel: Could not match the column title: "lengte". do you have any suggestions?
Check the name of the column on excel then check the name that is written on your iLogic rule
@@DesignAutomationSolutions i have checked it more than once, but it still doesnt work
@@markvanmaldegem5364 send me the code to my email felixcortes147@gmail
Where can i find the Excel file?
Hi,Iam getting an error,
GoExcel:Could not match the column title: "pipe size"
Name in excel and ilogic are same
How to correct it?
Double check the column title because it is case sensitive. Also, by default it looks at the first row of the excel sheet so make sure the title is there. Make sure you launch the excel sheet correctly as well
i got it ,thank you and vedios are very helpfull
@@krishna7203 glad you like them! Best wishes on your automation
Visit:
design-automation.teachable.com/