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.
DimfdAsOpenFileDialog=NewOpenFileDialog()
DimstrFileNameAsStringfd.Title="Open File Dialog"fd.InitialDirectory="C:"
fd.Filter="All files (*.*)|*.*|All files (*.*)|*.*"
fd.FilterIndex=2
fd.RestoreDirectory=True
[code]....
View 2 Replies
ADVERTISEMENT
Sep 19, 2013
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.
View 6 Replies
View Related
Oct 28, 2010
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?
View 8 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
Feb 11, 2013
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.
View 1 Replies
View Related
Dec 14, 2011
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:
i = GoExcel.FindRow("Z:DISEGNI_INVENTORDescrizioni.xls", "Descrizioni", "Cod.Art.", "=", iProperties.Value ("Project", "Part Number"))iProperties.Value ("Project", "Description") = GoExcel.CurrentRowValue("Descr. Articolo Princ.")'iProperties.Value("Project", "Project")
[Code] .....
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??
View 7 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
Aug 11, 2012
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
private void button1_Click(object sender, EventArgs e)
{
Inventor.Application invApp = null;
invApp = (Inventor.Application)System.Runtime.InteropServices.Marshal.GetActiveObject("Inventor.Application");
Inventor.Document doc = invApp.ActiveDocument;
Inventor.PropertySet customPropSet;
customPropSet = doc.PropertySets["Inventor User Defined Properties"];
View 1 Replies
View Related
Apr 9, 2012
how to change the order of custom iProperties. I would like to group like iProperties together to make editing a bit easier.
Windows 7 Pro, SP1
Inventor 2012 SP1
Due to the nature of our business, I am not permitted to attach any files showing models or .idw environments of any actual work-related components.
View 3 Replies
View Related
May 18, 2012
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?
View 5 Replies
View Related
Sep 18, 2012
we have a part file that has 2 custom iproperties in it.
Length and Width.
If I delete these properties its fine and the properties are removed.
However if I then save the file, the properties become available again.
View 3 Replies
View Related
Nov 2, 2010
Is it possible to automatically add custom iproperties using iLogic?
I have a rule thats adds text to a propery, but when I run the rule in an old partfile i get the error:
"Can't find a property named DrawingNo"
Is there something like:
"Create iProperties.Value("Custom", "DrawingNo")"?
View 3 Replies
View Related
Mar 23, 2012
Copy custom iproperties from one part to the other - possible?
View 6 Replies
View Related
Dec 9, 2011
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?
View 1 Replies
View Related
Jul 10, 2012
how to make a multi-value drop down menu in drawing iProperties?
I want to make a list with aluminum extrusion sizes where I can pick it's name from a list of names. Similar to the custom iProperties "Design State".
View 5 Replies
View Related
Oct 23, 2013
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?
Inventor 2013
View 2 Replies
View Related
Oct 26, 2012
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.
View 1 Replies
View Related
Nov 21, 2012
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.
Is there a way to acomplish this with I-logic?
View 5 Replies
View Related
Nov 2, 2011
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.
View 2 Replies
View Related
Nov 19, 2012
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.
View 2 Replies
View Related
Aug 25, 2012
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.
View 4 Replies
View Related
Dec 18, 2013
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
View 1 Replies
View Related
Feb 20, 2012
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.
View 1 Replies
View Related
Jun 25, 2013
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
View 2 Replies
View Related
Sep 30, 2013
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.
View 8 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
Jul 31, 2007
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.
View 4 Replies
View Related
Apr 6, 2010
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.
View 9 Replies
View Related
Jan 24, 2013
I 'm looking for a method to import the layers that I have exported from Civil 3D 2013 and have edited in Excel.
View 2 Replies
View Related
Oct 30, 2008
When I link in an excel document to my model all parameters in that excel gets the unit (mm).
How can I change this? For instance I want some of the parameters to be an angle.
View 8 Replies
View Related
Sep 4, 2013
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.
View 6 Replies
View Related