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

AutoCAD Inventor :: ILogic Code Part Iproperties To Custom Iproperties

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

AutoCAD Inventor :: How To Link IProperties To Excel

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

AutoCAD Inventor :: Populate IProperties From Excel Using ILogic

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

AutoCAD Inventor :: Import IProperties From Windows Browser Into Excel?

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

AutoCAD Inventor :: Import IProperties Value From External Excel File

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

AutoCAD Inventor :: ILogic Syntax For Searching In Excel And Update IProperties

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

AutoCAD Inventor :: Modifying Custom IProperties In C#

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

AutoCAD Inventor :: Change Order Of Custom IProperties?

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

AutoCAD Inventor :: Mass Custom IProperties Modification

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

AutoCAD Inventor :: Custom Iproperties Within Part File

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

AutoCAD Inventor :: Adding Custom Iproperties With ILogic?

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

AutoCAD Inventor :: Copy Custom Iproperties From One Part To The Other?

Mar 23, 2012

Copy custom iproperties from one part to the other - possible?

View 6 Replies View Related

AutoCAD Inventor :: Custom Drop Down Under Cost Center In IProperties

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

AutoCAD Inventor :: Custom Multi-Value Menu In Drawing IProperties?

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

AutoCAD Inventor :: Custom IProperties From Exported Parameters In Derived Blocks

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

AutoCAD Inventor :: IProperties And ILogic - Transfer Custom Title To Drawing

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

AutoCAD Inventor :: Exporting User Text Parameters To Custom IProperties

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

AutoCAD Inventor :: ILogic Changes Custom IProperties Type From Number To Text

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

AutoCAD Inventor :: Custom IProperties Not Updating In Drawing When Update Assembly Model?

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

AutoCAD Inventor :: ILogic To Create And Display / Insert Custom IProperties In Template

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

AutoCAD Inventor :: Importing Points From Excel

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

AutoCAD Inventor :: Importing Excel Table Entities

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

AutoCAD Inventor :: Importing Excel Points To 2013 Sketch

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

AutoCAD Inventor :: How To Create ILogic Rule To Create Custom IProperties

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

AutoCAD Inventor :: ILogic - Export Custom Table To Excel

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

AutoCad :: Importing Excel Table Into (OLE)?

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

AutoCad :: Importing Excel Data

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

AutoCAD Civil 3D :: Importing Layers From Excel

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

AutoCAD Inventor :: When Link Excel Document To Model All Parameters In Excel Gets Unit (mm)

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

AutoCAD Inventor :: Excel Installation Is Required / Failed To Launch Excel

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







Copyrights 2005-15 www.BigResource.com, All rights reserved