AutoCAD Inventor :: Using Excel And ILogic To Control IParts
Jan 9, 2012
I am currently using iparts/assemblies to model a resistor bank. We have dozens of different configurations and currently each time we need a new one its is re modeled from scratch.
I have created an assembly with all my relevant parts and controlled it through parameters to auto update when key values are changed.
What I would ideally like to do is to either link my two iparts to the iassembly though the excel sheets they use. Currently I have to added each variation to the parts first and then added the parameters to the assembly.
Would it be possible to have a master sheet were all control values are inputted and then each excel sheet for the different parts are linked to this?
As the excel sheets are saved in the temp file and are deleted once you have finished editing I have found it hard to do this so far. Can I change where they are saved? I tried save copy as which created the file but inventor did not link to it.
If this is not possible can I utilize iLogic to input the key values and then write them to a new row in the table. I have created a rule already to limit the number of elements and also the length of the by's (the space between each supporting rod). I have included a zip file with all my parts in it.
View 1 Replies
ADVERTISEMENT
Apr 13, 2012
I am finding it difficult to find good through examples of how to use iLogic with iParts and iAssemblies. I have been through several of tutorials, but can't seem to find examples for what I need. Here is a link to a video to give you a bit of an idea of what I am trying to do. How/when and what snippets to use in order to get the iParts and iAssemblies to function properly.
See Video : [URL].....
First video went to long here is the rest.. [URL].......
One thing I think I mentioned in the last video, but not sure I explained it well, is that instead of having the main file name show up in the browser..the part name shows up. When I go to change parts using a form I created it keeps telling me it can't find the current part.
View 1 Replies
View Related
Nov 16, 2011
See attached.
I no longer have the option to edit iparts or iassemblies via speadsheet (excel). I'm using Excel 2007. (INV 2012 Sp1)
Is excel functionality part of an addin that I might have turned off accidentally?
I believe it was working in 2012 but haven't really noticed it not working till after Sp1 install till now..
Running 2014 Product Design Suite Ultimate
Windows 7 64 bit
90G OCZ SATA 3 SSD
Core I7 920 processor, ATI HD6970 graphics card, 12G Corsair RAM
View 5 Replies
View Related
Mar 21, 2012
I am venturing into a new area with my iLogic coding. Looking for some good examples or How-To of how to use iLogic with iParts and iAssemblies.
View 1 Replies
View Related
Jan 31, 2012
As my Inventor endeavors continue, I would like to take a template of a part I made and use Excel to change the parts dimensions. Essentially make it so if we need a 20 Tonne Lift Lug, I just punch in the necessary values in Excel and have the part update.
View 1 Replies
View Related
Sep 16, 2013
Is it possible to control (move) End of Part with iLogic? Let's say to move it before or after a certain feature.
View 1 Replies
View Related
Jul 26, 2013
I am using ilogic rules found in this forum to publish to pdf.
I would like to know if its possible to hide certain layers while publising to pdf.
So is it possible to do that with ilogic?
View 1 Replies
View Related
Nov 22, 2013
Working on a product configurator using iLogic and have a large amount of hardware that needs to be suppress or unsuppressed based on certain parameter choices. Instead of creating hundreds of lines of code suppressing and unsuppressing the hardware one by one, I was hoping to put hardware into folders based configurations. In my mind this would have allowed me to have one line that would suppress the folder as needed. Unfortunately I cannot figure how to suppress a folder in iLogic as I saw someone else mention I was hoping for a "Folder.IsActive" rule but have yet to find one.
Inventor 2013
View 6 Replies
View Related
Dec 7, 2011
I need to use/write a iLogic code. I have a assy, in this assy i have parameter Height and Width. And it´s no problem to controlls this two rules/value.
But I have a problem with the rule when my height will control the number of parts
If my height is 500-1000, one part.
If my height is 1000-1500, two parts.
If my height is 1500-2000, three parts.
Is it best to use suppress or use a pattern in this case?
View 1 Replies
View Related
May 28, 2013
Is it possible to use iLogic to insert a row into excel?
View 1 Replies
View Related
Sep 3, 2013
I am trying to use an iLogic Excel link to define the hub and bushing dimensions for a wing pulley part file. I get an error: GoExcel: Could not match the column title: "Size". I've attached the part file and Excel file. The iLogic rule in the part file is called Hub_Bushing.
View 9 Replies
View Related
Oct 31, 2011
I am creating a drawing controlled by ilogic. The assembly can vary in size considerably so I have set the IDW to change between sheet size A3 and A2 accordingly using ilogic. However, when the sheet size is changed, the parts list stays in a static position.
Currently, the parts list is situated in the top right corner up against the title block and the border. So when changing from Size A3 to Size A2, the parts list ends up in the middle of the page. Is there anyway i can control the position of the parts list so it changes with the sheet size change?
I know I could simply move the partslist to the bottom left corner, which is a work around. However, I'd like to be able to keep the drawings in line with the company standard.
View 1 Replies
View Related
Mar 21, 2013
I am trying to create a windows form within iLogic. Everything works except the lines defining the location on the controls. I keep getting the following error: 'New' cannot be used on an interface. The error refers to lines in the code that try to set the control location on the form. (i.e. "button1.Location = New Point(10,10)") Ihave pasted the code below and have it attached as well. I am in Inventor 2013.
AddReference ("C:WindowsMicrosoft.NETassemblyGAC_MSILSystem.Drawingv4.0_4.0.0.0__b03f5f7f11d50a3aSystem.Drawing.dll")Dim oOccurrence As ComponentOccurrenceTry oOccurrence = ThisDoc.Document.SelectSet.Item(1)Catch MessageBox.Show("Please select a component before running this rule.", "iLogic")
[Code] ........
View 1 Replies
View Related
Jan 9, 2014
I am trying to create a new sheet in an existing excel file and can not figure out how to do it.
I am trying to export parts lists from multiple drawings to an exisitng excel spreadsheet and I'd like have each on their own sheet. I can do everything but create a sheet. How to do this in iLogic?
Inventor Pro 2013 (PDS Ultimate)
Vault Pro 2013
Windows 7 64
Xeon 2.4 Ghz 12GB
View 2 Replies
View Related
Jan 7, 2013
I want iLogic to look up todays date in an excel file and then pull information from that row.
The problem I have is that it doesn't seem to like / or - so I am not sure how to format the date.
How would I format my date in Excel so that it matches the wway Inventor stores it in iproperties>Project>Creation Date?
Inventor 2013
DwgNum = iProperties.Value("Custom", "Dwg Number")Client = iProperties.Value("Project", "Vendor")Description = iProperties.Value("Project", "Description")DrawingType = iProperties.Value("Custom", "Drawing Type")author = iProperties.Value("Summary", "Author")Date2 = iProperties.Value("Project", "Creation Date")i =
[Code] .........
View 9 Replies
View Related
May 21, 2013
I want to export reference parameters to an excel table using i-Logic
I found the function GoExcel.CellValues("filename.xls", "Sheet1", "A2", "A10") = MultiValue.List("d0")
It looks like the syntax calls for the file location and name if the xls file is not open and if open is not supposed to be required.
I have entered it both ways and with and with out the target file open and with the function GoExcel.Open("pathFilename.xls","sheet1") and continue to get the error:
we couldn't find C:AbellAbell VaultWorkSpaceDEVELOPMENTAC100-0100MRLTEST Table.xls. Is it possible it was moved, renamed or deleted?
Also, I was expecting that to fill in the sheet cell's would be MultiValue.List("d0","d1","d2")
but the system give me an error that says
Error on Line 3 : Overload resolution failed because no accessible 'List' accepts this number of arguments.
See below
GoExcel.Open("C:AbellAbell VaultWorkSpaceDEVELOPMENTAC100-0100MRLTEST Table.xls", "AC-100-0101003-TEST")GoExcel.CellValues("C:AbellAbell VaultWorkSpaceDEVELOPMENTAC100-0100MRLTEST Table.xls", "AC-100-0101003-TEST", "A2", "A10") = MultiValue.List("d194_A")GoExcel.Save
View 8 Replies
View Related
Jan 28, 2013
I have made a configurator, that defines my part. Now i would like to add some intelligence for the Save process...
When i activate my rule it should.:
1. Go to a Excel spreadsheet and find next Empty cell in a specific collum
2. Place Title from inventor in that empty cell
3. Return the value from the cell next to this cell
3. Use this value as the new filename for my part.
Example: here i would like to get the parts tile put into B3 and A3 (103) returned to Inventor as filename to my part
--------------------
A B C
1 101 Title1
2 102 Title2
3 103
If possible, i would like to be able to adjust this alittle as i go forward in my work,
View 9 Replies
View Related
Dec 12, 2012
I have an ilogic rule to open an existing excel file template and export the inventor parameters into it. I am trying to find a way to then save the excel file as a different filename. This way the original template can stay unmodified. I have found the GoExcel.save command but is there some sort of GoExcel.saveas(filename, filepath) command?
View 2 Replies
View Related
Jun 27, 2011
I am trying to use an iLogic rule to populate iProperties (some generic, some custom) from a part number spreadsheet (containing columns such as PART NUMBER, DESCRIPTION, FINISH etc) and the rule keeps throwing up the following error 'Conversion from string "" to type 'Double' is not valid.'
Here’s part of the code (would be extended for the required custom iproperties but I’m assuming the same principle is ok)
StartRule:
'read excel file
GoExcel.Open("C:DESIGNDocumentsEXCEL FILESPART NUMBERS", "PARTS")
'index row 3 through 10000
For rowPN = 3 To 10000
'find first empty cell in PART NUMBER column (Column A)
If (GoExcel.CellValue("A" & rowPN) = "") Then
[code]...
Changing the format of the excel data (number or text) has no effect. Is manipulation of the format required so that Inventor can read text and numbers to iProperties in this way?
View 5 Replies
View Related
Jul 25, 2011
Is there a chance could shoe me how to use iLogic to create copy of part by first searching through an excel worksheet columns, if the name exist in excel worksheet then donot save else create a copy of the part or save as whatever name is defined in the iLogic code.
Core i7-2630K
12GB dual channel Corsair XMS3
Nvidia quadro 2000
128 vortex 2 SSD
WD 7200rpm Black
Asus P8P67 DELUXE
Product Design Suite 2012 Ultimate
View 2 Replies
View Related
Jun 27, 2012
How to create a excel file using ilogic?
View 6 Replies
View Related
Feb 24, 2011
is there any way using iLogic or other method to automatically control the size of the 'break' in a drawing view? I have built a model which uses iLogic to control virtually everything, however the large variations in the length of the product mean that there are some interesting results when it comes to the broken drawing views updating.
it would be nice to locate the break at the absolute center of the view and then size it as a percentage of the view size along one axis or perhaps according to some other length based rule.
Dell Precision M6400 - C2D 2.66 / 8gb / Quadro FX3700M / Win 7 Pro x64
View 9 Replies
View Related
Apr 30, 2012
i want to export my part list with ilogic in a excel template but dont want all the part list column and dont erase the column i skip in excel?
View 3 Replies
View Related
May 27, 2013
What im trying to do is take the i properties from an inventor .dwg, and place them into a specific excel spreadsheet. I've managed to get so far, by using code that Curtis posted, which does the opposite of what im looking to do.The code Curtis posted takes info from excel and fills in iprops.
I can fill in specific cells, for instance columns A, B & C on Row 1 and place that info into a specific spreadsheet. But my code falls down when i run the code on another .dwg, It obviously overwrites what was previously in those cells.... I am looking for the code that looks to see if those cells are in use, and if so, go to the next available cell down.
View 6 Replies
View Related
Mar 6, 2012
Ok what I'm tring to do is have a spreadsheet that has a list of prices in it that we could modify if needed for all these parts i'm making. Best way is to have the spreadsheet obviously external of the file.Though now I do not know how to do this in iLogic.And example of what I'm trying to do is, with 3 parameters.
A, B, and P
Value "A" and Value "B", these are just read items which when combined will give Value "P" to be imported into the Part file. So need A & B to be read and give the row number for P to be imported.
View 3 Replies
View Related
Nov 29, 2010
I have an embeded excel chart on my drawing called CLASS 125 Single Disc.xls. I want to switch this chart with another one known as CLASS 150 Single Disc.xls. How do I do this? I am using Autodesk Inventor 2011.
View 9 Replies
View Related
Mar 11, 2013
I tried Curtis Waguespack's iLogic: Export Parts List with Options, and it works great on Part Lists. I'd like to do the same thing on a custom table, but I don't know what needs to be changed.
View 3 Replies
View Related
Oct 23, 2013
Is there any way using ilogic to find a value in an excel file and delete the column that value was found in?
View 1 Replies
View Related
Dec 17, 2013
I want a ilogic rule syntax for following process:
I have one excel sheet it consists around 5 sheets for Plate, Flats, Rounds, etc. When i am run the rule then it will ask and do the following:
Ask the thickness value.It will search thickness value in “D:LINUS KOTTEstock numbers.xlsx” in sheet 1If thickness value found then fill the stock number in iproperty(project tab-stock number)
Here i am using different rules for plate, flat, round, etc.,
View 2 Replies
View Related
Sep 20, 2013
For Creating my own templates i want to use iLogic and embedded Excel-Spreadsheets. The embedded Sheet has its own data, but i want to create a rule to refresh the data from an external Excelsheet.
For now i use the following rule:
For I = 65 To 90 '65=A 90=ZBuchstabe = Chr(I) GoExcel.CellValues("3rd Party:Embedding 1", "Platte", Buchstabe & "1", Buchstabe & "999") = GoExcel.CellValues("G:KonstruktionVorlagenMaterialgrunddaten.xlsx", "Platte", Buchstabe & "1", Buchstabe & "A999")Next I
it works well, but wont insert a new single-sheet or refresh formats, i have to add the same code for each sheet. And its REALLY slow.
Is there a possibility to refresh or replace the whole embedded file via a simple iLogic-rule?
View 1 Replies
View Related
Aug 15, 2012
iLogic rule that will retrieve a part number(s) from an excel sheet. I work for a company that built vacuum trucks and I'm trying to make an . I am template where the user can select different lengths of shells to achieve the desire overall length. I have been able to achieve this using iLogic rules and forms and making the shell length parameter multi value.
But now I need to show predetermined SAP part numbers for the shells in BOM or part list. I all ready have an excel sheet with shell sizes with corresponding part numbers on file. I also thought about incorporating our custom CC parts/shells that already have the SAP part numbers set up as a custom iProperty but might be to complicated for a newbie iLogic user.
View 9 Replies
View Related
