AutoCAD Inventor :: Get New Part Number From Excel With ILogic?
Jan 28, 2013
I have made a configurator, that defines my part. Now i would like to add some intelligence for the Save process...
When i activate my rule it should.:
1. Go to a Excel spreadsheet and find next Empty cell in a specific collum
2. Place Title from inventor in that empty cell
3. Return the value from the cell next to this cell
3. Use this value as the new filename for my part.
Example: here i would like to get the parts tile put into B3 and A3 (103) returned to Inventor as filename to my part
--------------------
A B C
1 101 Title1
2 102 Title2
3 103
If possible, i would like to be able to adjust this alittle as i go forward in my work,
View 9 Replies
ADVERTISEMENT
Aug 15, 2012
iLogic rule that will retrieve a part number(s) from an excel sheet. I work for a company that built vacuum trucks and I'm trying to make an . I am template where the user can select different lengths of shells to achieve the desire overall length. I have been able to achieve this using iLogic rules and forms and making the shell length parameter multi value.
But now I need to show predetermined SAP part numbers for the shells in BOM or part list. I all ready have an excel sheet with shell sizes with corresponding part numbers on file. I also thought about incorporating our custom CC parts/shells that already have the SAP part numbers set up as a custom iProperty but might be to complicated for a newbie iLogic user.
View 9 Replies
View Related
Dec 6, 2011
I would like to link a cell value in excel with the partnumber from a assembly in Inventor. How can I made this link?
View 1 Replies
View Related
Aug 22, 2012
I want a part number which is made with a parameter write to excel to the excel sheet to link to acad. I have the following code that runs smoothly and requires the excel sheet to save but get nothing written in the cell.
GoExcel.CellValues ("M: AutoCAD AutoCAD 2012 Inteco3D File Test ExportPartNumber.xlsx", "Sheet1", "A1", "A10") = MultiValue.List ("Part Number")
View 4 Replies
View Related
Sep 21, 2011
I would like to have the part number automatically be entered with ilogic.
Normally I know how to do this but this time I'm trying to have a couple constant letters with numbers to be filled in.
Example
MGR72
MGR is constant and the 72 will change with the width
What I thought would work but doesn't is
iProperties.Value('Project", "Part Number")="MGR" Width
View 2 Replies
View Related
Nov 15, 2011
I'd like to create a part number generator using iLogic. The rule would run as follows:
If the iProperty "Part Number" was not blank or the same as the file name (as Inventor default), then a question box would pop up asking if you would like to overwrite the part number. If one were to select yes, then the following would happen.
iLogic would open an xls that is on the network. The xls would have two columns. Column A would be the part number, B would be the filename associated with that part number.
Column A (the part number) is a sequential count in the form of 6 or seven digits. The format would be something like =TEXT(ROW(A1),"JFRC-000000")
Everytime the part number generator rule is triggered, it would create a new part number on the next blank row, copy this part number to the Part Number iProperty and assign the file in which the iLogic rule was executed to column B in the xls, save and close.
If, when the rule is triggered, the Part Number property is blank or the same as the file name, the user would not be asked if they would like to overwrite the part number. This rule would be triggered manually from a form.
View 2 Replies
View Related
Oct 31, 2013
I have a part number that i want to defined in custom properties.
Then would it be possible to call it out in Ilogic? that way in any drawing doesn't matter where the part number will always be the same for that part when i balloon and the same in the BOM.
View 4 Replies
View Related
Oct 28, 2013
I have two user parameters saved in a part template that are tied to the part volume and an overall estimated part weight. The user parameter Pc_Volume is the volume in cubic feet and calculated by pulling the part mass (in cubic inches) and converting to cubic feet via ilogic rule. This is then automatically run via event triggers before a file is saved and if the part geometry has changed to keep the volume up to date. These are exported because they get pulled into iproperties of our drawing files as well as used to create a parts lists showing the volumes and weights.
I have the property formats of the user parameters set to Number and to unitless and the unit display turned off so it does not show on the parts list, with a precision of 0.000 for Pc_Volume. The Pc_Weight is set the same way however with a precision rounded to the nearest whole number.
These are created this way so when we use the part file as the template when we select "Make Components" to separate our parts and tie them to an assembly all the files are then updated and the information saved for exporting.
The problem is, the Pc_Volume always comes in rounded to a whole number. The Pc_Weight Does as well, but that doesn't bother me since we want it to do that anyway. If I would go into the part file after it's created, double check the precision and then re-run the rule the volume will show up with the correct precision in the exported parameters. I don't want to have to open each partfile however to get this to update.
Attached are images of the parameters, ilogic rule, and exported results.
View 2 Replies
View Related
Oct 26, 2012
I had wanted to find a way to engrave/emboss the part number on a part model and have it be parametrically tied to the part number iProperty. Since it doesn't appear that I can create a text box and insert the iProperty directly, here's what I did to work around this. (I setup my part templates to have this out of the box....)
1. Within, the IPT file, add a user text parameter called "PartNo" and set its initial value to any text value.
2. Create your sketch for your text to be engraved. Insert the User parameter you just created.
3. Create the engraving/embossing for your text.
4. Create the following iLogic rule:
' Requires a User Text Parameter called "PartNo" prior to running' Set the appropriate event trigger to tasteIf Parameter("PartNo") <> iProperties.Value("Project", "Part Number") ThenParameter("PartNo") = iProperties.Value("Project", "Part Number")InventorVb.DocumentUpdate()End If
5. I set this rule to fire using the "iProperty Change" event trigger. So if the iProperty is set or changed, your text will update. Obviously, you can set this to run with whatever trigger you like.
Inventor 2014 64-bit SP1
Win 7 Pro 64-bit SP1
View 2 Replies
View Related
Feb 19, 2012
Is it possible, if you have a merged BOM.row to get the total quantity of each part?
inventor professional 2011 / 2012 / 2013
View 4 Replies
View Related
Dec 3, 2013
Why when I mirror a part in an assembly the mirrored part gets a new part number? I want to mirror only the position of the part which is always the same part. Is it possible to do that in Inventor?
View 7 Replies
View Related
Apr 1, 2013
I`m looking for the iLogic code that can change one parameter (user defined) for each (ipt) part in assembly (iam)
The one below doesn`t work.
Sub Main Dim oApp As Inventor.Application = ThisApplication Dim oAssy As Inventor.AssemblyDocument = oApp.ActiveDocument For Each oSubDoc as Inventor.Document In oAssy.AllReferencedDocuments On Error Resume Next Parameter(oSubDoc, "FH") = 15.26 Next End Sub
View 5 Replies
View Related
Feb 8, 2013
Is there a way to connect parameters from part1 to part 2 using iLogic, without using an assembly.
View 9 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
Nov 5, 2013
How do I need to write the code in Ilogic to find the sin of a number. It works fine in a parameter as sin (43) but does not give the same value in ilogic.
View 1 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
Jan 9, 2012
I am currently using iparts/assemblies to model a resistor bank. We have dozens of different configurations and currently each time we need a new one its is re modeled from scratch.
I have created an assembly with all my relevant parts and controlled it through parameters to auto update when key values are changed.
What I would ideally like to do is to either link my two iparts to the iassembly though the excel sheets they use. Currently I have to added each variation to the parts first and then added the parameters to the assembly.
Would it be possible to have a master sheet were all control values are inputted and then each excel sheet for the different parts are linked to this?
As the excel sheets are saved in the temp file and are deleted once you have finished editing I have found it hard to do this so far. Can I change where they are saved? I tried save copy as which created the file but inventor did not link to it.
If this is not possible can I utilize iLogic to input the key values and then write them to a new row in the table. I have created a rule already to limit the number of elements and also the length of the by's (the space between each supporting rod). I have included a zip file with all my parts in it.
View 1 Replies
View Related
May 21, 2013
I want to export reference parameters to an excel table using i-Logic
I found the function GoExcel.CellValues("filename.xls", "Sheet1", "A2", "A10") = MultiValue.List("d0")
It looks like the syntax calls for the file location and name if the xls file is not open and if open is not supposed to be required.
I have entered it both ways and with and with out the target file open and with the function GoExcel.Open("pathFilename.xls","sheet1") and continue to get the error:
we couldn't find C:AbellAbell VaultWorkSpaceDEVELOPMENTAC100-0100MRLTEST Table.xls. Is it possible it was moved, renamed or deleted?
Also, I was expecting that to fill in the sheet cell's would be MultiValue.List("d0","d1","d2")
but the system give me an error that says
Error on Line 3 : Overload resolution failed because no accessible 'List' accepts this number of arguments.
See below
GoExcel.Open("C:AbellAbell VaultWorkSpaceDEVELOPMENTAC100-0100MRLTEST Table.xls", "AC-100-0101003-TEST")GoExcel.CellValues("C:AbellAbell VaultWorkSpaceDEVELOPMENTAC100-0100MRLTEST Table.xls", "AC-100-0101003-TEST", "A2", "A10") = MultiValue.List("d194_A")GoExcel.Save
View 8 Replies
View Related
Dec 12, 2012
I have an ilogic rule to open an existing excel file template and export the inventor parameters into it. I am trying to find a way to then save the excel file as a different filename. This way the original template can stay unmodified. I have found the GoExcel.save command but is there some sort of GoExcel.saveas(filename, filepath) command?
View 2 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
Jul 25, 2011
Is there a chance could shoe me how to use iLogic to create copy of part by first searching through an excel worksheet columns, if the name exist in excel worksheet then donot save else create a copy of the part or save as whatever name is defined in the iLogic code.
Core i7-2630K
12GB dual channel Corsair XMS3
Nvidia quadro 2000
128 vortex 2 SSD
WD 7200rpm Black
Asus P8P67 DELUXE
Product Design Suite 2012 Ultimate
View 2 Replies
View Related
Jun 27, 2012
How to create a excel file using ilogic?
View 6 Replies
View Related
Jul 7, 2011
My question: We want to use iLogic to save a PDF-file of the DWG-drawing every time we hit "save". We now use the following iLogic
Spoiler (Highlight to read)oPath = ThisDoc.Path PN = iProperties.Value("Project", "Part Number")
PDFAddIn = ThisApplication.ApplicationAddIns.ItemById("{0AC6FD96-2F4D-42CE-8BE0-8AEA580399E4}")
oDocument = ThisApplication.ActiveDocument
oContext = ThisApplication.TransientObjects.CreateTranslationContext
[Code] .....
View 9 Replies
View Related
Oct 1, 2013
Im linking a prompted entry in a sketch symbol to a selection from the user in an array. The code works perfectly.
The array displays the number of sheets there are in the document, the user selects the correct one & the sheet number is displayed in the prompted entry. I need to add "SHT" before the number though in the code but I cant get it to work.
I dont want to add a text line into the symbol saying "sht"
Dim oApp As Application: oApp = ThisApplication
Dim oDoc As DrawingDocument: oDoc = oApp.ActiveDocument
Dim oSheet As Sheet: oSheet = oDoc.ActiveSheet
'This uses a sketch symbol with the name "'View On' View Label"
Dim oSymDef As SketchedSymbolDefinition: oSymDef = oDoc.SketchedSymbolDefinitions.Item("'View On' View Label")
'This is the selected view
Dim oView As DrawingView: oView = ThisApplication.CommandManager.Pick(SelectionFilterEnum.kDrawingViewFilter,"Select View To Place Symbol:")
'This takes the label items of the selected view
'And adds it To an array that will link To the prompted entry
Dim sPromptStrings(2) As String
sPromptStrings(0) = oView.Name
sPromptStrings(1) = oView.ScaleString
oDoc = ThisApplication.ActiveDocument
Dim sSheet As Sheet
'create sheet number list
Dim oSheetList As New ArrayList
i = 0
s = "-"
For Each sSheet In oDoc.Sheets
i = i +1
oSheetList.add(i)
Next
oSheetList.add(s)
'get user input
mySheet = (InputListBox("View taken form sheet number.", oSheetList, oSheetList(0), "Sheet Number Ref.", "Sheet Numbers"))
sPromptStrings(2) = mySheet
'This is the position for the sketched symbol under the selected view'
Dim oPosition As Point2d: oPosition = oView.Center
oPosition.y = oPosition.y - (oView.Height / 2 + 2.5)
'This inserts the sketched symbol and fills in the prompted entry.
Dim oSymbol As SketchedSymbol: oSymbol = oSheet.SketchedSymbols.Add(oSymDef, oPosition, , ,sPromptStrings)
View 2 Replies
View Related
Jun 27, 2012
I am making a iPart with iLogic. I need a function to convert letter to number or convert number to letter as we did in VB for Excel.
For example: Char(65)="A"; CODE("A")=65, and so on.
View 3 Replies
View Related
Dec 7, 2011
I need to use/write a iLogic code. I have a assy, in this assy i have parameter Height and Width. And it´s no problem to controlls this two rules/value.
But I have a problem with the rule when my height will control the number of parts
If my height is 500-1000, one part.
If my height is 1000-1500, two parts.
If my height is 1500-2000, three parts.
Is it best to use suppress or use a pattern in this case?
View 1 Replies
View Related
Jul 4, 2012
I want my browser name using iLogic particular change to the part number. I fill in my iproperties, the part number. Then the browser name has to take over the part number.
But i get an error.
doc = ThisDoc.Document
Dim oCC As ComponentOccurrence
For Each oCC In doc.ComponentDefinition.Occurrences
OccName = oCC.Name
oCC.Name = iProperties.Value("Project", "Part Number")
Next
View 4 Replies
View Related
Nov 29, 2012
I dont no in english if odd number is the right word but i want to make all my number to 1, 3, 5, 7, 9, etc,....
View 9 Replies
View Related
Apr 30, 2012
i want to export my part list with ilogic in a excel template but dont want all the part list column and dont erase the column i skip in excel?
View 3 Replies
View Related
