AutoCAD Inventor :: Importing Custom Iproperties From Excel
Sep 5, 2012
I'm importing custom iproperties from an excel document into inventor using the code I've written below. I've figured out how to bring up a dialog box to select the excel file I need, but I'm completely stumped when it comes to selecting the sheet within the file. As it is now, I'm specifying the sheet in the code itself (Str. C). My goal is after selecting the excel file from the dialog box, have ilogic list all the sheets within the excel file, then be able to select which sheet I need using a radio box, list box or some sort of prompted entry.
I was looking for some iLogic Code for Inventor 2013 that would cycle through all the parts in an assembly grabbing the quantity of each part and setting it equal to the custom property "Qty" of each part.
Having a little trouble creating the for each loop and setting reference to each part without referencing each part by specific name.
Is there a way to link any inventor file iproperties to a excel spreadsheet - so that the excel spreadsheet updates parametrically with any inventor iproperty changes.
I know that inventor parameters can be linked to excel, but what about i properties?
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?
I'm looking for a way to export all iproperties, (from a selection or a directory), from windows browser, and CSV import into excel.
What I'm looking to do is, be able to select hundreds of files from the windows browser, either select the directory, (and it's sub-directories), or a selection of files, and extract their iproperties, and place the contents into excel similar to exporting contacts from outlook and importing them into excel.
i have made a iLogic Module who, whit an external rules, import the iProperties value from an external exel file.The exel file is connected from SQL with the our managerial software.This in the external rule:
It's work fine but i have same question. There is some string to refresh an iLogic Module? When i push the ruel button the rule add the custom value in iProperties, but there are disabled, i have close the module an reopen it for correct display the value of the iProperties.
this module work with single parts. Can I do an rule who do the same thing of my string but in one assembly, do this for every parts of assembly automaticly??
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.,
I am using some code from the June 2010 "Mod the machine" posted by Brian Erkins.I keep getting an error in C# (express 2010), Please see attached screen dump.
I don't see any obvious difference in my code when compared to Brian's (in fact at one point I copied and pasted his code and still had the same error). Here is the
Is there any easy way of adding custom Iprops to previously created parts and assemblies? A macro or something that could set up additional lines without having to go in and type them out all the time?
I'm using 2011 and I would like to add a drop down menu under the cost center box so I pick from a list of processes we use for purchasing. Is it possible to add a drop down list there?
I have two part files: Part A and Part B. Part A contains a sketch block, Block A, which will be used as a basis for Part B.
I derive Part B from Part A using a "Derived Part" to bring in only the sketch block (Block A) from Part A. When I do this, Inventor sets every dimension in Block A to "Export" and creates a custom iProperty for it. Then the Custom iProperties list in both Part B and Part A is cluttered with every dimension from Block A.
Is there any way to prevent it from creating all of these custom iProperties?
I have a form that is loading automatically in my part model. where i write the part number, description, project and custom titles.
my questions are:
1 - when i write the part number i would like then when i click apply it opens the save box with the same part number. 2 - it's possible to check-in the file during the saving and keeping the file checkout? 3 - i would like that some of the properties would be transfer to the drawing, like the description and the project (this two are from the part properties. 4 - transfer also for the drawing the custom titles to the custom i properties of the drawing as pre fill in.
I am trying to export a user parameter that is a text string to a custom I property. I am able to export other parameters to custom properties that are numarical values. I export check box is missing on the text user parameter.
I am using ilogic in Inventor 2011 to update my iproperties when I save a .dwg file. I am having problems with some custom iProperties I have created that are of the type 'number' and are initially set to 0 (zero). After the iLogic rule has run and the user has entered a numeric value the type of the custom iproperty has changed to 'text'.
The ilogic code I am using is:
If iProperties.Value("Custom", "Nominal ID") = 0 Then iProperties.Value("Custom", "Nominal ID") = InputBox("Enter The Nominal ID (Enter 0 if no value is available)", "Nominal ID", 0) Custom_iProp_Nom_ID = iProperties.Value("Custom", "Nominal ID") End If
I am using Vault 2011 and would like to map this property to a numeric property so I can perform <= and >= searches.
I'm using Inventor 2011 and when I go to change parameters using iLogic in an assembly model, (sometimes it is a component suppression, other times it is an iPart component change) it won't update the associated drawing file. I need to go into the BOM on the drawing and renumber the balloons, or change something else in order for the custom iProperties to update in the drawing template. If I just change the iPart component, then the BOM doesn't need to update making the renumbering of balloons redundant.
I'm using iLogic to update all of the iProperties and component references, then reattach balloons. What I would like to do is automatically update the custom iProperties drawing template fields, and renumber the drawing BOM.
Any way to use iLogic to create custom iProperties from the cells in an Excel spreadsheet (both text and numbers) for a .dwg template. The only thing even close has been a user who already knew how to do it and was having a different problem. I am using Inventor 2012 and Excel 2003 and have very little experience with VB. I currently have a family of assemblies, consisting of two parts linked to an Excel spreadsheet to control the various parameters for each variation of the assembly.
I need creating an iLogic rule that will:
Go to a specific tab (I have four different tabs/worksheets) in an Excel spreadsheet.
Make a specfic row of that worksheet the current row based on the part number used to generate the models of the assembly shown in a .dwg.
Use the contents of a cell in that row (text or numeric or a combination of both) to generate a custom iProperty for the .dwg template.
Use the custom iProperties to fill in the title block of the template.
I have created a Excel spreadsheet to impoort into my Inventor model, but one of the valves that I have created need to be a unitless/type. How do I set up a Excel cell to acheive this
I want to import my excel table to autocad. but when i try to do this, the table is not correctly import. im using paste special command and past to link. if i paste my file excel, image and other formats, i can not plot my draw. i attach my excel file.
note: i found a software that name is autotable. but its 150$. we dont want to buy an other software.
When I use the import excel points function in the 2D sketch menu of Inventor 2013, nothing happens when I open the excel file. No points are drawn in the sketch... I don't even get an error message... I have tried the same thing on another computer with the exact same spreadsheet and it works 100%.
I'm running Inventor 2013 service pack 2 on a Lenovo Y570 with an Nvidia GeForce GT555M GFX card
I'm trying to figure out how to create an iLogic rule that would create a Custom iProperties and put in what version of Inventor the file was last updated with.
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.
I'm trying to import an excel table into autocad. I can copy paste using ole and that works fine. It prints well, but when I print it as a PDF the file is not legible.
I am having a problem with my table that I insert from excel into ACAD 2010. The Data in excel is on automatic color and arial text, once imported into ACAD as ACAD entities the data in my table does not want to change to being bylayer as the cell type is set to but instead stays on white. The only way I can change the color is by entering the cell and changing it manually to bylayer.
Recently I have been trying to build table driven products and ipart tables, but when I copy a member to create a new part number, upon exiting the iassembly author I get the following message "excel installation is required for this operation. failed to launch excel". I have a fully functional version of 2010 Excel installed which has been used so it should be recognized in the windows registry. I am running Windows 8 and Autodesk Inventor 2014.