AutoCAD Inventor :: Get Feature List As Spreadsheet?
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
ADVERTISEMENT
Dec 31, 2013
On several projects there are long lists of images linked in the Illustrator file. I need to find a way to export the names of these links to a spreadsheet for another department to reference. Is there a way to do this (in Illustrator Cs5 or CS6)?
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
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
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
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
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
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
View Related
May 11, 2007
Is there a way that I can add helicoil tap info to the thread size spreadsheet so that I can use the data within the hole command and place helicoil-tapped holes into my models? I need some way to automatically flow the helicoil tap info into the drawing via a hole note.
View 8 Replies
View Related
Jun 7, 2012
I have several drawings with tables on them with broken links to spreadsheets which have been deleted.I can't edit the tables.
Is there a way of reusing the information in the table to recreate the spreadsheets or new tables.
View 2 Replies
View Related
Jul 26, 2012
My "parameter names" and "value" columns fill in under the Inventor Parameter chart, but for some reason I can't get the comment section to fill in.
Inventor 2011
07 Excel
Inventor 2011
Intel Core 2 Duo 2.93GHz
8GB RAM
Windows 7 Pro
View 1 Replies
View Related
May 12, 2012
I created a spreadsheet of about 40 rows to be used to create different parts. I then created a part "we'll call it Board_A". I linked to the spreadsheet and used 3 of the fields for my dimensions. Lets say I named the length (which was the extrusion number) as "Len_1". I saved it and all is well!! I then created other parts and used the spreadsheet for the dims. I then went back and opened "Board_A" and saved a copy as "Board_B". I closed Board_A and opened Board_B. I then rt clicked on "Extrusion" so I could change the length from "Len_1" to "Len_1_A" which is another row (field) on that same spreadsheet which is still linked. When I tried I received a message that said I couldn't do that (I forgot the actual message!) I clicked the Parameter icon and the only fields showing on the popup spreadsheet box were the ones I had previously used for those parts that I made from scratch. I thought I figured this out once but if I did I forgot. I deleted the spreadsheet link and then re-added it but nothing I have tried has worked. Is there a way to get these fields to be usable with a Copy of an existing part or do I just have to start from scratch and make the similar part?
View 1 Replies
View Related
Dec 29, 2011
Recently upgraded to Windows 7 from XP and changed from a laptop to a desktop. With the laptop I used dual monitors; to date I haven't secured a second monitor from IT for true dual monitors.
Well I have some iParts that I've edited using excel and they have formulas that I can't edit using the standard iPart dialog, but when I click "Edit via Spreadsheet" the window opens off screen. The alt+Spacebar method doesn't work in Windows 7 and the Windows 7 method of shift+right-click isn't an option because Excel doesn't appear on the taskbar and selcting Inventor moves the Inventor window, not the instance of excel inside of inventor.
2013 Product Design Suite Ultimate
Windows 7 Sp1
Intel(R) Core (TM) i5-2400 @ 2.00GHz
6.00 GB of RAM
AMD Radeon HD 6570
View 3 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
Apr 18, 2013
I have made this rule, that should fill out a cell in a spreadsheet with a text from IProperties.. but it seem to work only the first time. 2nd time i run it, nothing happends... not even the msgbox at the end...?!
GoExcel.Open("I:TEGNINGSNUMRE SKEMAERStandard nummer udtagning-test.xlsx", "80000")'Get new partnumber from Excel'Find next empty row in Column BFor RowPN = 2 To 1000RowPN = RowPN + 1If GoExcel.CellValue("B" & RowPN) = 1 Then'Insert title from open DocumentGoExcel.CellValue("C" & RowPN) = iProperties.Value("Summary", "Title")End IfNextGoExcel.Save()
View 3 Replies
View Related
Aug 7, 2013
I have a problem with using the excel spreadsheet to hold my parameters and then making them auto update in the model.
I have the excel 2003 spreadsheet saved in the same folder in the projects directory as the model. When I create the spreadsheet and enter the parameters and values etc I save and close the file.
When I am in inventor 2013 64 bit with SP1 installed, I open the model and can link the spreadsheet to the model and the model reflects the values in the spreadsheet. I also click update on the parameters dialog box.
I then open the spreadsheet and make some changes to the values, save the file and even go to the extreme of closing the file. When I go back into Inventor it recognises there has been some changes in the underlying spreadsheet. The update button is active in the tool bar. However trying to update the models by what ever means does not update the model parameters to those in the spreadsheet. Even closing the model and reopening it does not make a difference.
The only way I can get this to work is disconnecting the file and then reconnecting the file through the links option in the parameters dialog box. Then the model reflects the correct values and updates the model accordingly.
My concern is there is quite a bit of stuff on the net about 2013 not working with 2014 inventor anyway.
View 3 Replies
View Related
Apr 9, 2012
I have a set of sheet metal parts modeled in inventor that are produced in a wide range of sizes and several different sheet metal types.
The dimensions (length, width, flange size, etc) are driven from a spreadsheet. I would like to be able to have the user update the K Factor from the same spreadsheet by selecting a sheet metal type.
The sheet metal type and K factor are not listed in the parameters list with the other model dimensional data, so I'm not sure how to proceed.
View 1 Replies
View Related
Sep 15, 2013
I cannot import my Outlook contact list to Photoshop when using the Share feature.
View 7 Replies
View Related
Jun 16, 2011
I have been working with some GIS data in the form of SHP files in autocad map 3D 2011. On one of my layers I have started getting "Feature was not saved in the target feature source" when I try to check in my data. In total there are 308 errors in the data table, all of which were features I deleted. They all have a featID of null and I cannot remove them from the data table. I need to fix these errors without going back and starting over.
View 4 Replies
View Related
Jul 24, 2012
I am running Autodesk Map3D 2012 and I need to label my feature points no matter if they overlap or not.The Map3D documention refers to a check box that will allow what I believe I need- but I cannot find the checkbox in the style editor. Here's a clip from the Autocad documentation:
To allow labels to obscure points on the selected layer..In the Display Manager , select the point layer. Click the Style button.In the Style Editor, click Allow Other Labels To Obscure Feature Symbols On This Layer.
View 1 Replies
View Related
Dec 27, 2013
I'm trying to use the cut across bend feature on a sheet metal part. However, when I check cut across bend, it grays out all of the other cutout options, and only has thickness as the only option. This is perplexing to me, because I can't think of too many times I'd need this option other than when there is more than one thickness of material I need to manipulate the profile onto.
I was to understand that this "cut across bend" is for use similar to the "normal cutout" command in solid edge? Keeps the cut perpendicular to the sheet face in a sheet metal part.
Cybertron PC
Intel Core i5-3470 CPU @ 3.20 GHz 3.60 GHz
16.0 GB RAM
Windows 7 Professional 64 Bit
3D Connexion Space Pilot
Inventor Professional 2014
Autocad Mechanical 2014
View 3 Replies
View Related
Nov 24, 2011
Can not find the table where you can input "suppress feature if this equals 0" and so...
View 1 Replies
View Related
Jun 11, 2013
I would like to both flip and mirror (or pattern) a feature onto the opposite side of a rectangular extrusion.
For example (assuming a rectangular solid extruded in the Z dimension), I have two counter bored holes on the top surface of the solid aligned with the X axis and I would like a copy of those holes on the bottom surface but aligned with the Y axis. If I pattern the holes rotating them 90 degrees and then attempt to mirror them, I can only select all four or the two originals. Is there any way to disassociate the rotated copies from the originals while still retaining control over their dimensions from a single sketch?
View 3 Replies
View Related
Oct 12, 2012
I am working on a sheet metal tee and i am having a problem with the Rip feature on this particular piece. I am not understanding why it will not rip all the way through this part.
Part was created with Inventor 2013
View 4 Replies
View Related
Oct 10, 2013
Creating feature edit dialogs? I currently have working program that creates a custom pocket/cavity but I'm having trouble with the User Interface and setting up a solid structure to handle events.My goal is to mimick how the "add hole" dialog works by having the following attributes:
- Ribbon button to bring up dialog
- Dimensions update when the dialog text boxes are updated
- Right click menu to edit existing features
- Existing dimensions and other properties are loaded when the dialog is used to edit existing features
So far, I have my classes structured this way:
AddinServer (handles loading and unloading the command) ->
CavityCommand (defines the buttons and containes event handlers) ->
CavityFeature (wraps up multiple identicle cavities into one client feature) ->
Cavity defitions (draws individual cavities using more specific classes)
View 1 Replies
View Related
