AutoCAD Inventor :: ILogic Error Cannot Find Excel File After Saving File As Template
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
ADVERTISEMENT
Jun 27, 2012
How to create a excel file using ilogic?
View 6 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
Jun 6, 2013
I am trying to create an iLogic (or VB) rule to update an active drawing title blocks from our Template File.I don't want to use any of the external software (Transfer Wizard etc), we just need a simple rule that will update the title blocks when we need to.
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
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
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
Nov 5, 2013
I'm trying to use iLogic Design Copy to copy an assembly and all its associated parts to another directory. The assembly contains content center parts. Inventor warns me that the destination file of one of the CC parts (and 18 others) will be overwritten. When I go ahead and copy anyway, the copying process stops at that specific CC part. The Design Copy Progress dialog box states there is an error copying that CC part. When I close the Design Copy Progress dialog box, Inventor crashes.
The error copying the CC part: I'm allowed to use content center parts in iLogic Design Copied stuff, right? I searched some related topics and I'm under the impression that Inventor keeps the CC parts in its own directory and shouldn't be trying to overwrite them.
View 3 Replies
View Related
Aug 4, 2005
i have deleted the excel file from the ipt file but when i open the part file it is still looking for the excel file. i am using inv 10 sp1 and excel 2000
View 7 Replies
View Related
May 1, 2013
The goal of this project is to take a base part file, save new copies as needed, then modify the copies. They're rings for storage tanks that share the same tank diameter but differ in height and thickness. I have a SaveAsCopy rule in my template ring part that I run externally from my main assembly after passing down the new file names to the part rule. Since I'm testing a lot, I'm always deleting the parts from the assembly, then clearing out the new copies from my folder and running the rule again. Eventually after 1-5 times inventor starts giving me an error.
The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG))
The More Info Tab:
System.ArgumentException: The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG)) at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData) at Inventor.Document.SaveAs(String FileName, Boolean SaveCopyAs) at LmiRuleScript.Main() at Autodesk.iLogic.Exec.AppDomExec.ExecRuleInAssembly(Assembly assem) at iLogic.RuleEvalContainer.ExecRuleEval(String execRule)
The two other posts on here that deal with that error say it involves enumerating an array that is being changed and looking for an entry that is gone. I have a feeling it has to do with a left over variable (but this is all in iLogic rules so they get cleared at the end of the rule?), temporary files or remnant file references. It works again if I close the assembly and open it back up. Inventor 2013 SP 1.1
View 9 Replies
View Related
Nov 9, 2011
I'm trying to update a part with different colors for various features. My color styles are not available in this file. I can export them from another file, then use the import function to bring it over, but there has to be a way to force this file to find the entire "default" color file.
View 6 Replies
View Related
Oct 9, 2012
I am starting a football pool and I can't find a PSD template. where I can find one?
View 4 Replies
View Related
Jul 18, 2013
When I try to save a drawing, the box to choose the location, how I want to save doesn't show.
View 3 Replies
View Related
Jul 6, 2012
I have a drawing which has hundreds of levels on and i'm trying to establish what the MEAN level is and the AVERAGE level. I thought the best way might be to extract the text to excel and perform it there but at the moment the only way i can do it is to copy and paste the text and its taking me forever. Is there a way to either a) extract text to excel or b) calculate a MEAN value based on texted selected?
View 2 Replies
View Related
May 11, 2012
I am trying to make parts in part builder but when I try saving I get the error message "error saving XML file". I tried changing the setting on the files for saving but that doesn't seem to work.
View 5 Replies
View Related
Jun 13, 2013
I have a brand new workstation and only on certain files it will say FATAL ERROR: Cannot write to undo file (probably disk full) when ever I save. I have tried cleaning out the TEMP file, turning off the Undo function, auditing the file and its xrefs, and recovering the file. It was a file that was on the server, but I have pulled it to my local machine and I have also increased the amount of virtural memory avaiable.
View 3 Replies
View Related
Dec 30, 2013
I'm trying to do a save as of a previously created and validated part. When I create a new chapter and try to save the part in the new chapter, I get an error message saying "ERROR SAVING COLE FILE". What is a COLE file and why am I getting this error? Could there be a problem because the original part was created in 2013, and now I'm working in 2014?
We recently changed the location of our CAD Standards (such as Pipe Network Catalog). Can I simply copy the Pipe Network Catalog and paste it to the new location and have everything work the same or do I have to do something special?
View 2 Replies
View Related
Aug 28, 2011
I included a VB code in our drawing template, but then I get the "Warning: You have a non-empty VBA project.." message. If I copy the code into iLogic, I just get an error message. Why it runs fine as a separate macro, but doesn´t work in Inventor, or how I can include the code into the template? URL....
View 2 Replies
View Related
Aug 8, 2013
I am having problems with my drawing template, I can make changes no problem, but when I use the template to start a new idw file the changes are not in place.
For example; view preferences, I want to work in third angle, I have this selected on the template but each time I start a new idw I have to change it from 1st angle.
e.g. 2; sheet size, I changed it from text to a drawing property, but it doesn't change when I edit the sheet size.
View 7 Replies
View Related
Dec 30, 2013
I made some changes to our normal template file for inventor and saved it to my hard drive in the public folder. When i open through windows explorer its fine and everything is correct. When i open a new idw and select this file through inventor it comes in with some of the tables having different size text and none of my leaders coming in.
View 7 Replies
View Related
Nov 6, 2012
I have been trying to export a 2013 Inventor idw file as a 2010 AutoCAD dwg file.
I use to be able to do this without any issues however I am getting the following error message which prevents me from exporting the file.
"Could not open the DWG template file. Please check the path and try again."
I am using 2013 Inventor Pro.
This export feature use to work fine when I used 2012 Inventor Pro. however when i try to do the same from 2012 I get the same error message.
I have checked the default templates file path in the Aplications Option menu and I have tried to set a default in the AutoCAD template file option under the export destination setting under the save Copy As function.
View 2 Replies
View Related
Jan 24, 2012
I link an excel spreadsheet of text into my .idw files and I constantly have this issue where the text is crowded (see attached). I've tried changing the font, etc. but nothing seems to work. Every once in a while if I move the linked sheet within the .idw it corrects itself.
I'm using Inventor 2012.
Inventor 2013
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
View 1 Replies
View Related
Jul 4, 2012
I have used the command "insert object" to embed an excel sheet. I can see in the modelbar the new stage called "3rd Party", expanded I also see "Embedding 1". If I use edit I can see my excel sheet. So far good.
My next task is to create a Rule to recall cells in the sheet. I use the command CellValue (embedded) to pick my cell value. My problem is that then I close my rule-editor I got the error:
Error in rule: Rule0, in document: Box test.ipt
GoExcel: 3rd Party worksheet not found: "3rd Party:Embedding 1", Sheet: "Sheet1"
It seems like I´m not able to recall my cellvalues.Whats the difference between embedding a excelsheet as above or use the add link command i Parameters window?
View 4 Replies
View Related
Nov 14, 2012
When inserting object - xls file, i found trouble, max. number of column i see in dwg file is 22.
Creating table using table - general require long time for set up every column (different with)
View 1 Replies
View Related
Apr 4, 2012
How to set civil 3d 2012 to automatically load your templete file at start-up instead of a misc. drawing file with no styles or anything.
View 2 Replies
View Related
Jul 15, 2012
How can you use a template file from your personal files to use it in an already existing .dwg file.
I knwo how to do it if I start the drawing from scratch and I select that template, but I want to put this existing drawing into my personal template file from my documents.
View 2 Replies
View Related
Dec 4, 2012
I am trying to export each sheet in an Excel file to an separateTXT files.
I currently have code to read each cell in a sheet, but unfortunately some of the Excel sheets have in excess of 5000 cells and it is taking too long to read. So I am switching to another method.
The program will check dates of TXT files and XLS file to make sure TXT files are current (if not, open and recreate TXT files).Then read the TXT files (much faster).
Where I am getting stuck is 2 places -
Get the names of each sheet in the excel file (not always a known name)
Save each sheet as separate TXT file.
Here is condensed code so far without error checking, etc -
(defun E2TXT (FileName /)
(if (and (setq XLfile (findfile FileName)) (vl-file-systime XLfile) (setq XLapp (vlax-get-or-create-object "Excel.Application")))
(progn
[Code]....
View 4 Replies
View Related
Jun 27, 2013
When I try to do a make components I get this error "Could not open default template file." All the Standard.xxx files are the designated folder and named appropriately. Plus I just used this command earlier today. I did do a "rebuild all" but I'm not 100% sure the problem came directly after that.
FDS Ultimate 2013
View 4 Replies
View Related
Sep 9, 2013
I recently update the template for my drawing files, change the title block, revision, note....and I can't find a clean way to import this template to the existing files. I tried the Drawing resource transfer wizard tool, but it doesn't seem to be doing anything that I want.
View 1 Replies
View Related
Apr 14, 2012
I have an idw file that has absolutely nothing in it.
The file size if 17.5Mb.
May need to add it to an ftp site if someone has available.
View 5 Replies
View Related
Sep 29, 2012
With Photoshop CS6 Extended when i go to save image as jpeg it shows as file name.iff, if save as png it shows file name.pxe and save file as pdf it shows file name.pcx. All formats seem to show another format.I have done all the updates. On a mac as well.
View 3 Replies
View Related
