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
ADVERTISEMENT
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
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
Sep 6, 2013
I used to have an A1 printed sheet of all of the ilogic commands, functions, syntax or whatever you call them. It was all nicely grouped and colour coded etc
Unfortunately I have since moved jobs and lost this and neither me or google can find this again, any copy or link? it may have been a pdf or excel format.
View 3 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
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
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
Nov 11, 2013
I would like to copy and paste all iproperties from one part to another, without retyping it all.
What i was thinking about is:
1. Exporting all iproperties to .txt
2. Run a import .txt rule to iproperties.
Is it possible? If so, How could i accomplish a task such as this?
Privacy warning: Since I live in a country that has traded liberty for the illusion of security, all of your posts to me are being monitored and saved by the United States Government.
View 1 Replies
View Related
Oct 18, 2013
I am sure this is extremely simple to do but I am missing something. I am wanting to set the Description of a part in the Iproperties using values from the parameters. For instance, if the part has a length value of 10 and a width value of 5 I want the Description to say: 10 x 5 Floor Sheet
I cannot figure out how to extract the parameter values and place them into the iproperties. Here is what I have tried: iProperties.Value("Project", "Description")=" =<Length> x <Width> Floor Sheet"... This gives me the following result in my description: x Floor Sheet
View 4 Replies
View Related
Jun 1, 2011
I wish to set the properties of an assembly using i Logic. I have the values of the properties in a part that is in the assembly. I wish to pass those values from the part to the assemblies i properties. I tried using the following code, but it gives an error saying it can not find the document "MyAssy.iam"
iProperties.Value("MyAssy.iam", ThisDoc.Path, "Part Number")=AssyNo
I'm not even sure that this is the way to do, but it's the only way I could think of to try.
View 9 Replies
View Related
Apr 2, 2013
I want to use i Logic to retreave or push the i Property of "Project" from my skeleton file to the rest of the parts and assemblies in the project.
View 9 Replies
View Related
Jan 30, 2012
My goal is to use basic ilogic to fill in some of the standard iproperty fields from parameters.I have so far managed to populate the description iproperty with one value from the parameters using this ilogic code;
iProperties.Value("Project","Description") = length
where length is a user parameter.Want I would like to do is build on this to include more parameters such as material thickness, width and depth etc so the resulting iproperty description field would read something like
1.2mm SS 50x100 @3000
How do I go about writing the ilogic string to include multiple values and end up filling in the one description field?
View 9 Replies
View Related
Jan 28, 2013
I would like to be able to add iproperty values to a derived part from the assembly..!
Breaking it down..:
When i run the rule, it creates a derived part from the Assembly i have open.
The iproperties from the assembly should be copied to the new Derived Part. or just set direclty from the rule, doesn't matter...
View 9 Replies
View Related
Aug 3, 2011
I'm trying to build a simple ilogic form to fill out iproperty infomation for parts we generate. Our company only uses a few of fields that are available. The problem is that the Physical tab is not available in the form editor. I would like to add this field to my form to be able to select the material for the part. The style/standard editor in our part template file holds all materials we use. Summary, Project, Status, and Custom are all available, why isn't Physical?
View 9 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
Apr 18, 2013
how could I synchronize my drawing with the referenced part?
I have a "User Defined Propertie" called "RBMATNO" in the part and in the drawing.
View 3 Replies
View Related
Sep 19, 2012
I'm working on a main assembly. I want to edit the i properties of components within a sub-assembly, this is fine for "RING:1"
iProperties.Value("RING:1","Project", "Description")="A79-H020B001"
but I get an error message when i try to edit the iproperties of a patterned component within the sub-assembly.
View 3 Replies
View Related
Jul 1, 2011
I like to keep the properties of my drawing the same as those of my model. Currently I must remember to hit the "updat copied properties" button in the drawing to discard any old drawing properties and replace them with the properties from the model.
Is there any way to automate this task (perhaps on saving the drawing?) I presume an iLogic rule could be created in the drawing template, just not sure how to go about it.
View 7 Replies
View Related
Sep 6, 2013
I would like to make a form that updates / creates custom properties for ALL parts in an assembly so that i dint have to go through them one by one.
Is there any sample code anywhere or a good code resource?
View 1 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
Jun 7, 2012
I'm trying to put a little iLogic rule in my drawing template which triggers as soon as the drawing is opened. The rule asks the user whether the component he's making a drawing of needs to be painted or not. If it gets painted, the paint area (one side only or both sides) needs to be calculated. The result of this is then referenced by a text note in the title block.
I can do the radio boxes with the questions, as well as their If loops, but only when I'm in the model. Due to our, admittedly inefficient workflow, we never have time to specify "minor details" like paint area or spec during modelling, only when we get to drawing level. I'd like to put the iLogic rule inside the drawing template. I'm having trouble referencing the iProperties of the model from within the drawing's iLogic interface.
What I have so far is this rule, which I can run inside the model:
'set dummy variable equal to total areatotal_area = iProperties.Area'start radio box with questionsText1 = InputRadioBox("Will this component be painted?", "Yes", "No", Text1, Title := iProperties.Value("Project", "Description"))If Text1 = True ThenText2 = InputRadioBox("How many sides will be painted?", "Both sides", "One side only", Text2, Title := iProperties.Value("Project", "Description"))If Text2 = True TheniProperties.Value("Custom", "Paint Area") = total_areaElseIf Text2 = False TheniProperties.Value("Custom", "Paint Area") = total_area/2End IfElseIf Text1 = False TheniProperties.Value("Custom", "Paint Area") = 0End If
adding a line or two so that I can run the same rule, but from the drawing.
View 9 Replies
View Related
Jul 11, 2013
I'm trying to do this with iLogic, and i'm not getting anywhere. What I need, is to be able get to the iProperties of an associated model that is referenced into a drawing file. I want to make it easier to update the iProperties from the drawing file, without having to open the model file.
Factory Design Suite Ultimate 2012
AutoCAD 2012 | Inventor Professional 2012 | Vault Professional 2012
View 2 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
Nov 25, 2009
During some discussion with other uses of Inventor I was ask if I knew about a problem relating to Changing a member size in Frame Generator and the iProperties maintain the old members properties.
The basic problem is as follows:-You start with a simple frame, create all of the members save and then added to a drawing. The members frame come from the content centre which have been copied into a Custom Library to enable addition parameters to be added along with addition iproperties being automated such as DESCRIPTION.
Once the frame and associated members have been created and then save, if a user wants to change the size of the member inventor has to create a new part file and then inserts into the frame generator frame. However, I have found that if you review the iProperties of the new file the DESCRIPTION is the same as the one that was replace, however it was strange to see that the STOCKNUMBER and PART NUMBER was updated correctly. It seems to be only a problem with the DESCRIPTION property.
View 9 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
May 28, 2013
Is it possible to use iLogic to insert a row into excel?
View 1 Replies
View Related
Sep 3, 2013
I am trying to use an iLogic Excel link to define the hub and bushing dimensions for a wing pulley part file. I get an error: GoExcel: Could not match the column title: "Size". I've attached the part file and Excel file. The iLogic rule in the part file is called Hub_Bushing.
View 9 Replies
View Related
Jan 9, 2014
I am trying to create a new sheet in an existing excel file and can not figure out how to do it.
I am trying to export parts lists from multiple drawings to an exisitng excel spreadsheet and I'd like have each on their own sheet. I can do everything but create a sheet. How to do this in iLogic?
Inventor Pro 2013 (PDS Ultimate)
Vault Pro 2013
Windows 7 64
Xeon 2.4 Ghz 12GB
View 2 Replies
View Related
Jan 7, 2013
I want iLogic to look up todays date in an excel file and then pull information from that row.
The problem I have is that it doesn't seem to like / or - so I am not sure how to format the date.
How would I format my date in Excel so that it matches the wway Inventor stores it in iproperties>Project>Creation Date?
Inventor 2013
DwgNum = iProperties.Value("Custom", "Dwg Number")Client = iProperties.Value("Project", "Vendor")Description = iProperties.Value("Project", "Description")DrawingType = iProperties.Value("Custom", "Drawing Type")author = iProperties.Value("Summary", "Author")Date2 = iProperties.Value("Project", "Creation Date")i =
[Code] .........
View 9 Replies
View Related
