AutoCAD Inventor :: ILogic Excel Date - How To Format
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
ADVERTISEMENT
Jun 19, 2013
I've inserted <CREATION DATE> into the custom title blocks I normally use for drawings. It displays the date without preceding zeros (example: June 18, 2013 is displayed as "6/18/2013" instead of "06/18/2013"). How can I change this?
View 2 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 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
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
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
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
May 27, 2013
What im trying to do is take the i properties from an inventor .dwg, and place them into a specific excel spreadsheet. I've managed to get so far, by using code that Curtis posted, which does the opposite of what im looking to do.The code Curtis posted takes info from excel and fills in iprops.
I can fill in specific cells, for instance columns A, B & C on Row 1 and place that info into a specific spreadsheet. But my code falls down when i run the code on another .dwg, It obviously overwrites what was previously in those cells.... I am looking for the code that looks to see if those cells are in use, and if so, go to the next available cell down.
View 6 Replies
View Related
Mar 6, 2012
Ok what I'm tring to do is have a spreadsheet that has a list of prices in it that we could modify if needed for all these parts i'm making. Best way is to have the spreadsheet obviously external of the file.Though now I do not know how to do this in iLogic.And example of what I'm trying to do is, with 3 parameters.
A, B, and P
Value "A" and Value "B", these are just read items which when combined will give Value "P" to be imported into the Part file. So need A & B to be read and give the row number for P to be imported.
View 3 Replies
View Related
Nov 29, 2010
I have an embeded excel chart on my drawing called CLASS 125 Single Disc.xls. I want to switch this chart with another one known as CLASS 150 Single Disc.xls. How do I do this? I am using Autodesk Inventor 2011.
View 9 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
Oct 23, 2013
Is there any way using ilogic to find a value in an excel file and delete the column that value was found in?
View 1 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
Sep 20, 2013
For Creating my own templates i want to use iLogic and embedded Excel-Spreadsheets. The embedded Sheet has its own data, but i want to create a rule to refresh the data from an external Excelsheet.
For now i use the following rule:
For I = 65 To 90 '65=A 90=ZBuchstabe = Chr(I) GoExcel.CellValues("3rd Party:Embedding 1", "Platte", Buchstabe & "1", Buchstabe & "999") = GoExcel.CellValues("G:KonstruktionVorlagenMaterialgrunddaten.xlsx", "Platte", Buchstabe & "1", Buchstabe & "A999")Next I
it works well, but wont insert a new single-sheet or refresh formats, i have to add the same code for each sheet. And its REALLY slow.
Is there a possibility to refresh or replace the whole embedded file via a simple iLogic-rule?
View 1 Replies
View Related
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
Nov 20, 2012
I'm unable to open or otherwise query an Excel spreadsheet.
I get the following error message. see attached.
What steps must I take to open and query Excel spreadsheets?
I'm using Inventor 2013, Excel 2007 and Vista 64.
Inventor 2012
AutoCAD 2012
Product Design Suite Ultimate 2012, 2013 & 2014
View 1 Replies
View Related
Sep 21, 2011
I would like to set the custom property format for all user paramters from an iLogic code. This is what I've come up with. It runs, but it does not seem to alter the custom property format. What am I doing wrong here?
DimoPartDocAsPartDocument
oPartDoc=ThisApplication.ActiveDocument
DimoParameterAsParameter
ForEachoParameterInoPartDoc.ComponentDefinition.Parameters
oParameter.ExposedAsProperty=True
ShowUnitString=True
ShowLeadingZeros=True
ShowTrailingZeros=False
Precision=kTwoDecimalPlacesPrecision
NextoParameter
i7-2720QM Dell Precision M6600, Win 7 Pro 64-bit, 8GB RAM
Autodesk Product Design Suite Ultimate 2013
Autodesk Vault Professional 2013
View 9 Replies
View Related
Apr 30, 2013
I have some code (below) that will open my embedded excel spread sheet and it works great. Now I need the code to save and close the excel file after it’s been open.The embedded excel spreadsheet pushes some stuff the model and does a couple other thing. So all I really need is for the excel file to open, save, and close when the rule is run.Imports Inventor.
OLEDocumentTypeEnumExcelApp = CreateObject("Excel.Application")Dim ExcelFile As ReferencedOLEFileDescriptorExcelFile
=hisDoc.Document.ReferencedOLEFileDescriptors.Item(1)ExcelFile.Activate(kEditOpenOLEVerb, ExcelApp)
View 4 Replies
View Related
Jan 9, 2013
I have a MultiValue Parameter that I want to populate using a named range from an embedded excel spreadsheet. I would like an iLogic solution if possible because I need other people to be able to understand the code without too much difficulty.
One of the sample snippets given allows access but not if the excel file is embedded.
'GoExcel.NamedRangeValue("Part_Width")
The code below works but not when using a named range.
' Load bearing housing typesMultiValue.List("parameter1") = GoExcel.CellValues("A1","A20")
Is there something I'm missing? I was hoping to use something like below
' Populate MultiValue Parameter from excelMultiValue.List("parameter1") = GoExcel.CellValues("3rd Party:Embedding 4", "Sheet", "myNamedRange")
View 2 Replies
View Related
Aug 1, 2013
I am trying to have iLogic change the custom property format for my user parameters. I am able to work with linear measurements, but I would like to also work with angular measurements. I want my angular units to be "Degrees" the format to be "Deg-Min-Sec" and the precision to be DD MM.
Below is my code to change the units to deg, but I can't change the format or precision:
Dim oPartDoc As PartDocument
oPartDoc = ThisApplication.ActiveDocument
Dim oParameter As Parameter
Dim oFormat As CustomPropertyFormat
[Code]....
View 1 Replies
View Related
Nov 11, 2013
I'm trying to start Excel and show the results of some BOM items I have written to a file like item number, part number and description.The task is to find components in an assembly that have a part number longer then 39 characters, due to ERP limitations.
What I´m doing is cycling through all BOM (structured) items on first level and check if the part number is longer then 39 characters.
I write these item number, part number, description to an Excel file (temp.xlsx), so the user sees which Components he has to check for the Part Number (make it shorter). I figured it would be best to do that with an excel file, so the user can save the results to a new file or just check it.
Values will be erased from the temporary excel file afterwards.Here I can't figure out how to start the excel application and open the file in an actual application window if possible.
how to list the results with plain iLogic that would do it too or some other solution to list a snapshot from the BOM.I guess there is no way to add your custom BOMViews ?
View 6 Replies
View Related
Dec 6, 2012
I'm linking an excel file to an .ipt file with iLogic code determining if the Material type is a certian value it will find the correct material thickness. These file work great when working on them thru Vault but when I "Save As Template" and create this file where our other template files are located (not Vault) this fuction does not work. I have realized that I had to place the a copy of the excel file in the same file folder as the template ipt, but even this does not fix the issue.
I recieve this error:
Error in rule: Material, in document: Part6
'MWW Materials (Inventor).xlsx' could not be found. Check the spelling of the file name, and verify that the file location is correct.
If you are trying to open the file from your list of most recently used files, make sure that the file has not been renamed, moved, or deleted.
It seems completly countintutive that just saving the file as a template file would cause this not to work when all files that are required are located in the same file folder. Maybe I need a reference to the excel document within the iLogic code.
View 3 Replies
View Related
Oct 18, 2011
Inside VS 2010 the datetime components format the date string as "dd/MM/yyyy"
Inside autocad 2012 the date formatting is "dd/MM/yyyy"
but inside the .net appication that I am writing, the date.now returns "MM/dd/yyyy" and the compents also reformat to "MM/dd/yyyy" so I end up with lots of "invalid date string" errors
View 4 Replies
View Related
Mar 11, 2012
i am useing vb.net 2010
Dim AcadApp As Autodesk.AutoCAD.Interop.AcadApplication
Dim acaddoc As Autodesk.AutoCAD.Interop.AcadDocument
AcadApp = GetObject(, "Autocad.Application")
acaddoc = AcadApp.ActiveDocument
Dim DD As Double
DD = acaddoc.GetVariable("tdcreate")
how to convert DD value to date and time format
View 4 Replies
View Related
Dec 12, 2013
I've been sent an AGS 3.1 file which I'm trying to import to Civil 3D using the Geotechnical module, but keep running up against an error which suggests the date format in the AGS file is incorrect. From what I can see the format should be DD/MM/YYYY, and this is correct in the file, but Geotechnics still won't recognise it.
Is there a different date format I should be using, or is there a way to force the tool to recognise the format in the file?
View 7 Replies
View Related
