AutoCAD Inventor :: Linked Spreadsheet And ILogic Workflow With Assemblies
Jun 19, 2013
My question is regarding the proper workflow within Inventor. We are currently using 2013 Pro.
I am trying to develop an Assembly that will take linked excel values and have the assembly repond to the user's input. This spreadsheet is to be general in form and is to be re-used for different projects. Right now, the excel values are linked to a master assembly file. This master file has a few iLogic rules to handle the user's input and to pass particular parameter values to the iAssemblies (read sub-assemblies). The iAssemblies are not that complex, but they are taking parameter values from the master, and using iLogic within the isub-assembly to choose the iAssembly member based on the parameter value.
Problem one:
There seems to be a problem with changing the iAssembly member. I have stabilized the iAssembly within the master Assembly. The isub-assembly does not update unless I open the isub-assembly file. In both the isub-assembly and the master assembly, I update at the end of each rule, and I trigger the rules after any parameter change.
The questions are:
Since there are 123 members (so far) in each of the 2 iAssemblies within the Master Assembly, do I really have to test the parameter 123 times to assign a particular iAssembly member? Or is there a more concise way to do this?
We are not using Vault yet, but with described workflow, will we have problems when we do migrate to a vault environment?
View 4 Replies
ADVERTISEMENT
Oct 14, 2011
where to find a tutorial that explains the usage of Design Assistant? Particularly the practice of renaming assemblies and linked parts?
View 4 Replies
View Related
Oct 1, 2012
I made a simple rule that triggers before save to ask user to make a selection, which then updates an iProperty.I created A multi value fxParameter and used the InputListbox function.
Ultimately I want to know the best way ok making this rule available to all parts, old and new.I am thinking, it will be easy enough to update my templates and embed this code into the part, as well as content center files by updating each file / template .
But for existing parts, is there a way to add these rules without the user having to do much steps.because there is an fxParameter I am thinking the user will have to know how add this to their part.I can change it to just an input box where they can type in the correct value, if that would be easier.
View 6 Replies
View Related
Feb 1, 2011
I would like to use a multi-value custom iProperty 'item_finish' in the part or assembly model to drive an iLogic rule.
'item_finish' would be 1-24 from the list.
The part file would have an embedded spreadsheet with column A corresponding to the 'item_finish'.
The spreadsheet would have column B containg long text descriptions of the finish process.
The ilogic rule must take the 'item_finish' number, find the corresponding row and then return the B column cell text to a user parameter 'defined_finish'.
The 'defined_finish' parameter can be called in a sketched symbol to describe the finish.
It appears this is all possible, but I cannot find enough information describing the snipped code requiremnets to accomplish the goal.
View 6 Replies
View Related
Nov 12, 2012
I have several parts which I wish to modify, but, those modifications are only being done to get some prototypes made. I do not want the changed (non-approved part) to be used in current issue drawings, assemblies etc. until I have proven the modifications and am happy with them.
I can do this by doing a save as on the part and could just replace the previous design, but then I lose the history of changes/revisions shown in Vault which is critical to me and part of using vault in the first place.
View 3 Replies
View Related
Dec 6, 2010
I already have a cut list template in Excel that calculates my stock material, volume, etc when I populate the appropriate fields. It is also connected to an access database that has various information that automatically generates the final price of my product based on various suppliers prices and data with whom I do business with and so on.
I would like to know if there was a way with iLogic to make Inventor populate specific cells with information found in the BOM such as: description; Qty and custom iProperties value like dimensions, etc?
The reason why I'm making a new topic out of this is that I have read previous post about the issue, but they were regarding "exporting the BOM to an excel". I, on the other hand, would like to populate an already existing spreadsheet with data from the BOM
After exploring the iLogic snippets, I've only found the "export" option. It referenced the API snippets, but with limited programming knowledge there is not much I can understand.
View 3 Replies
View Related
Oct 7, 2011
I am working on an iLogic assembly configurator that manipulates several skeletal parts, and suppresses both standard and skeletal parts depending on the configuration.
I've been using the Component.IsActive function to suppress all omitted parts, which has prompted me to create a custom Level of Detail. This hasn't caused me much grief until I had completed ~10months of work when it was time for me to make my final assembly drawing and a parts list.I am now running into several deal-breaking issues:
1) Suppressed parts insist on appearing on the Parts List.
2) Saving the assembly drawing reverts my assembly model to the "Master" LOD, which I never, ever, ever want to see again so long as I live.
Is there another workflow or technique that I should be using to turn off unwanted components in an assembly? I understand that LOD's are really intended to manage system resources, but Inventor users seem to be left with no other option to display a skeletal assembly in a certain configuration. What is the point of the Component.IsActive function if it doesn't update your assembly (at least so far as the Parts List is concerned)?
If I am left to deal with the nightmare that is the Inventor LOD, is there any way to set up the Parts List to reference the custom LOD?
Drawing View reps don't seem to be an option, as it looks like there is no way to automatically update the same custom view after the configuration has been made. The iAssembly Include/Exclude feature would handle part inclusion and BOM behavior nicely, but it won't fit into the rest of my iLogic and file management program.
View 9 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
Apr 30, 2013
I have some code (below) that will open my embedded excel spread sheet and it works great. Now I need the code to save and close the excel file after it’s been open.The embedded excel spreadsheet pushes some stuff the model and does a couple other thing. So all I really need is for the excel file to open, save, and close when the rule is run.Imports Inventor.
OLEDocumentTypeEnumExcelApp = CreateObject("Excel.Application")Dim ExcelFile As ReferencedOLEFileDescriptorExcelFile
=hisDoc.Document.ReferencedOLEFileDescriptors.Item(1)ExcelFile.Activate(kEditOpenOLEVerb, ExcelApp)
View 4 Replies
View Related
Oct 25, 2012
I got here on in my templates, two types of weight - net and gross. I've changed the main property MASS of each PART to be the GROSS weight, so when i have one assembly i always get the total gross weight.
And when i wanna get the NET, I open the BOM, show the proper column with this net weight and then export do XLS to sum all of then..
Now the doubt is, to get the things easier, is there a way to put some code in the assemblies, that could sum all the properties "X" from each part and sub assemblie to get the total net weight ?
View 1 Replies
View Related
Jan 11, 2012
i placed an ilogic component (wich i use as a template to later change dimentions) into an assembly file after changing dimentions i placed the same "template" ilogic component into the assembly but when i want to change something on the second component it also changes the first one and that only happens with only one feature of the component the other features work fine.
View 2 Replies
View Related
Jul 24, 2012
Got a new computer, put AutoCAD LT 2010 on the machine, justlike the rest of the office, but also installed excel 2010, when the rest ofthe office has 2007. when insertinglinked spreadsheets from the new computer, and we update the links on our oldcomputers, Acad fatal errors out. Thisis because of the difference in the excel versions correct?
View 1 Replies
View Related
Nov 14, 2011
Is it possible to replace sub assemblies using ilogic - I can only see a link to replace parts?
View 1 Replies
View Related
Jun 21, 2012
I'm new in use of iLogic and tried to use it by myself (and internet). But I have some difficulties.
Here is the open point, I wold like to create an assemblies with different length (and also some different part inside).
So I made some iLogic rules to make a configuration of my .iam with length selection.
I made rules to show or hide parts with is linked to the proper length.
I made rules to switch from a positional representation to another one and do the same for level of details representation and for view representation.
All is good in my .iam.
My problem is comming now. When I would like to put my .iam in a .idw in several views (corresponding to different length), my views are the all the same. I can't see one length per view even if I select the proper representation, the proper position and the proper level of detail.
At the end, all this work is to have all views length to be able to make in one drawing all length block in autocad.
View 3 Replies
View Related
Jul 17, 2013
iLogic code question concerning how Place iLogic Component and retain the ability to push parameters from the subassemblies to the parts after being renamed.
I have ASSEMBLY.iam containing:
SUBASSEMBLY-01:1.iam
SUBASSEMBLY-02:1.iam
and sometimes SUBASSEMBLY-02:2.iam
each SUBASSEMBLY.iam contains PART1.ipt and PART2.ipt which have variable LENGTH and WIDTH. LENGTH and WIDTH are entered manually at the SUBASSEMBLY.iam and are infinitely variable.
To transfer the parameters I'm using iLogic code in the SUBASSEMBLY:
Parameter("PART1.ipt", "LENGTH")=LENGTHParameter("PART1.ipt", "WIDTH")=WIDTHParameter("PART2.ipt", "LENGTH")=LENGTHParameter("PART2.ipt", "WIDTH")=WIDTH
Issue 1: When I place the SUBASSEMBLY as an iLogic Component, the parts are renamed to PART1-01.ipt which renders my Parameter transfer useless. What am I missing on writing this code so it can find the new part name?
Issue 2: I like the automatic renaming that happens with Place iLogic Component. Is there a better way to handle this automatically through Place Component -> Save & Replace?
Inventor 2013
View 1 Replies
View Related
May 28, 2013
I'm new in iLogic. I started making an assembly where it has a form where I put the dimension and iLogic controls the subparts including a frame generated profiles (in this case, iassembly don't work with FG).<br><br>The problem is: In the Larger assembly, I also put an iLogic and a form where I want this sub assemblies (this is the assembly mentioned above) to be driven by the parameters I will input on this large assembly. I don't know how to handle this but what I want is to:<br><br>1. I need that when I place this sub assembly there will be a form that will popup during the placement like when I put a bolt on content center.<br>2. Save as a new number and when the set of parameters exist on the previous large assembly it will notify that the sub assembly exist.<br><br>is this possible?
View 2 Replies
View Related
Jan 9, 2013
I'm running Invenor 2013 and I'm trying to figure out a way to rename my components from an iLogic assembly when placed in a new assembly.
Right now when I start a new assembly, then place an iLogic component it names everything "Part-01," Part1-01" and so on for all of the variable components.
What I'd like to do is write a rule that when placing my iLogic component it will name it based on the filename of the new assembly that I've created. "Part-New Assmebly," "Part1-New Assembly" and so on.
View 7 Replies
View Related
Oct 3, 2011
I am working in an Inventor Assembly .iam, I have about 250 fasteners (screws) that are constrained to a flat washer and lock washer. I would like to put them in as a single unit (sub assembly if you will) and then promote or explode them in the top level so that my bom has 250 screws, 250 washers, and 250 lock washers all at the same level, not associated to one another except thru the constraints that were entered in the original assembly. I have tried Promote but that doesn't work because it removes the washers from the original file and I end up with only 1 instance of the assembly. Am I approaching this incorrectly? Is there a better way? I run across this scenario with different components quite often.
View 2 Replies
View Related
Mar 8, 2012
If you have created a sub assembly and inserted it into an upper level assemby, is there a way to bust up the sub assembly at that level?
The issue arising is the individual components need to be called out on the upper level, but in the drawing are all showing up as the same balloon.
View 4 Replies
View Related
Jul 12, 2012
i have a valve vault assembly that i am creating that has two headers running through a large cylinder vault. how i get a total BOM if i were to create the header assembly file separate from the the total vault assembly file. is there a way to explode the header assembly bom when i do the drawing.
View 1 Replies
View Related
Aug 16, 2012
The Edit via spreadsheet option does not work, it will not call up Excel, although it believes that it does. The computer is running Win7 Ultimate sp 1 64, Office Home and Business 2010 sp1 32, Inventor 2012 sp2. The software (windows, office) is up to date, I have done the registry edit that other sites have mentioned.
I will bring up an .ipt, right click on Table, click on Edit via spreadsheet. I will get a circle for a cursor for a moment as if it were processing, then nothing. I right click on it again, and just get the How To option, so it believes Excel is open when it is not.
View 9 Replies
View Related
Aug 9, 2012
I have just inherited a project where I have been asked to supply our purchaser with a list of non-stocked fixings.
OK so far, i hear you ponder, but the designer for reasons of speed (his words) didn't add the fixings to the assmbly!
Is there any way to list all tapped hole features to an excel spread sheet so that i could then just sort and count and then be able to hilite the specific parts in inventor to find the length?
The prospect of looking at each individual part for tapped holes fills me with dread (shudder).
HP z210 16Gb ATI FirePro5800
Autodesk Produst design Suite 2012
View 4 Replies
View Related
Feb 15, 2012
Trying to figure out the best method to insert an IDW into an Excel spreadsheet without sacrificing quality. I have tried several methods to go straight from Inventor(2012) to Excel(2010) using print PDF at press quality, export JPEG, and even the snipping tool as a last ditch effort all of which inevitably loose all line quality when inserted to Excel.
I have only had success bringing a PDF from Inventor into Adobe InDesign where I am able to mimic the design of my Excel spreadsheet and create an additional PDF to include with the Excel document. It seems like there would be an easier way for Inventor and Excel to work together without sacrificing quality or adding additional steps.
View 1 Replies
View Related
Nov 21, 2012
I am trying to export some data from my BOM. I require the part names, quantities and lengths. I have followed a previous topic in these discussions which is now closed. it seems simple to follow but requires me to click on the export BOM icon in the top left of the browser. In my instance this is greyed out. D
View 4 Replies
View Related
Sep 8, 2011
Recently the company bought a single license of Inventor to test out and see if it meets our company goals and is efficient to use for what we do. I've been working with the frame generator, which is fairly easy to use and make the initial assembly, but I am having trouble and breaking out individual sections to detail.
I am stuck with using LOD for this platform, provide a general workflow procedure of the best way of creating assemblies and subassemblies.
What I am currently using Inventor is to build a condenser platform. Generally we like to weld as much of it in the shop before it goes to the field for final assembly. The platform consists of beam supports, grating, stairs, and handrail. In this case we would generally take sections of the handrail and weld in the shop, we would also have the stairs with the handrail welded on it as well. I would like to refrain from converting this to weldment.
I have tried promoting and demoting but this loses constraints and references. Also I cannot create a single skeleton of the whole frame at one time because a lot of the frame members depend on the other members structural sizes (flange width, height, etc.).
I've read of people creating multiple subassemblies and grounding them, but I would like to think that their has to be away that I could just build off of the base skeleton and not have to cycle through different assemblies.
View 9 Replies
View Related
Apr 17, 2013
Im struggeling with creating a code that opens a certain Excel spreadsheet and retrieves / inserts info.
the spreadsheet is a list containing part numbers for purchased components, therefore the list must be filled with information from iproperty. But it has to be where the next available number is. i had this working in iLogic, but have to move it to VBA for better use. the code that worked in iLogic is this one.:
[URL]
If possible it would be nice if the code at the same time retrieves the new partnumber and saves the active part as this part numeber...
View 4 Replies
View Related
Nov 15, 2012
I am working on a gearbox design that requires multiple iterations on the shaft dimensins and other parts, so linking the dimiensinos to a spreadsheet would make this easier. However, I'm using the design accelerator for the shaft and other components and I cannot find any information on how to connect the dimensions I enter in that design accelerator to a speadsheet.
I know how to link to a spreadsheet for a regular component, but haven't used that much.
View 3 Replies
View Related
Sep 13, 2013
Is there a way of inserting points from an excel spreadsheet that come into the part file already fixed, instead of manually selecting the points and selecting the fix constraint?
View 2 Replies
View Related
Jul 19, 2012
I try to edit the table of an iPart via a spreadsheet (EXCEL 2010) and it does not launch EXCEL. I saw other posts with changing the registery and I am not too confident on what to remove or even how to do it.
View 6 Replies
View Related
May 15, 2013
I have problem with Hole and Thread load menu input Thread.
i see only Loading thread data spredsheet .Please wait
win xp x32
inventor 2013
View 1 Replies
View Related
Jul 26, 2012
I can't understand why it takes so mant mouse clicks to correct/delete mate errors:
1) Select the Red Cross
2) Select the offending mate
3) Select Next
4) Select Next
5) Edit/Delete mate
6) Finish
7) Accept any other errors
8) Repeat above.
Is there a more simplified way of edditing/deleting mate errors?
Autodesk Inventor 2013-64Bit Edition
Intel Xeon W3520 @ 2.67GHz
Win 7 Pro
6.7 System Rating
NVIDIA Quadro FX 1800
View 1 Replies
View Related
