AutoCAD Inventor :: Loading Thread Data Spreadsheet?
May 15, 2013I have problem with Hole and Thread load menu input Thread.
i see only Loading thread data spredsheet .Please wait
win xp x32
inventor 2013
I have problem with Hole and Thread load menu input Thread.
i see only Loading thread data spredsheet .Please wait
win xp x32
inventor 2013
Autodesk Inventor 2013.
Could not find file C:Program FilesAutodeskInventor 2013Design DataXLS13XLSen-USThread.xls containing thread data.
Is there a way that I can add helicoil tap info to the thread size spreadsheet so that I can use the data within the hole command and place helicoil-tapped holes into my models? I need some way to automatically flow the helicoil tap info into the drawing via a hole note.
View 8 Replies View Relatedi get an error message telling (invalid thread data table. Please check Thread.xls file.i tried to reinstall the windows and the autodesk inventor but the error keep appearing.
1.my os is windows xp sv2 32 bit
2. inventor version is 2011 32 bit i also had the same problem with 2010
3. i tried to reinstall without any antivirus on my pc but i still have the same problem
4. what's a UAC?
5. yes i've office 2007 installed & i had tried with office 2003 but also the same problem.
1 the first time i used, i made the bolted connection once, but at the second time i kept having this issue.
2 my last trial was installing a freh copy of the windows then install office and the inventor only but nothing changed
3 i tried to install the inventor on another pc but i also had the same issue
4 i searched the c drive for the file THREAD.xls, and i found three of it and i guess they are fine.
I already have a cut list template in Excel that calculates my stock material, volume, etc when I populate the appropriate fields. It is also connected to an access database that has various information that automatically generates the final price of my product based on various suppliers prices and data with whom I do business with and so on.
I would like to know if there was a way with iLogic to make Inventor populate specific cells with information found in the BOM such as: description; Qty and custom iProperties value like dimensions, etc?
The reason why I'm making a new topic out of this is that I have read previous post about the issue, but they were regarding "exporting the BOM to an excel". I, on the other hand, would like to populate an already existing spreadsheet with data from the BOM
After exploring the iLogic snippets, I've only found the "export" option. It referenced the API snippets, but with limited programming knowledge there is not much I can understand.
I recently installed Inventor Premium 2012 and I am not able to make a bolted connection or creat a tapped hole. I get this error message: Invalid thread data table. Please check Thread.xls file.".
View 4 Replies View RelatedI'd like to use an "NPT" Hole Dialog thread but it doesn't show up in the Thread type list.But it does show up in the Thread Dialog/Specifications Tab/ Thread type list so it's available.
I definitely have "NPT" in my Thread.xls & I have my Options/Files set to point to the correct Design Data folder.
Inventor Suite 2013 Ultimate
My colleague installed IV2013. He has excel 2010 installed in his PC also. However he cannot create thread hole (thread option is grey out).
View 4 Replies View RelatedI can drill a hole as needed, but can't thread a hole at all. Not with the Tapped Hole function when drilling the hole, or after drilling the hole then using the Thread Tool. Inventor will just not let me create threads this way outside of cutting a coil.
View 9 Replies View RelatedI am trying to add a thread class to the thread.xls. (that part is ok)
The thread is M26x2.0
I can't seem to find any information for me to simply plug in the values into the .xls, so I am thinking that I have to crunch some numbers. which is fine. I just want to make sure that this image below is the correct the reference for this task.
using the pitch, I should be able to calculate all my min and max values, but the xls has class column and a tap drill column, how would I determine these values??
Inventor Professional 2014-Update 2 - AutoCAD Electrical 2014
Win7-x64 | ASUS P8Z77-V | i7 3770 -3.4 GHz | 32GB RAM |
240GB SSD | nVidia GTX 670 4GB - 320.49
We are using SSM, and it is getting quite annoying right clicking each sheet to input the info for each sheet, as not each sheet has the same info. Is there not a way to import the data from a spreadsheet, so you can fill out all the data in a spreadsheet how you want it, then import it into the SSM?
View 2 Replies View RelatedI need to find a way to export my BOM data to an Excel spreadhseet. Some of my BOM's are in tables, most are not. I found a lisp routine that will export this data to a csv file, but it's clunky at best. I don't want to use the "ole" method, I don't feel like fighting that battle.
So outside of plotting to a "png", and pasting that into Excel, are there any other options that are feasible?
°°AutoCAD Rel 1 - 2014°°
I have a map in AutoCAD and I would like to fill certain sections of it. The colour that I require the fill to be changes according to varying data in an excel spreadsheet. Is there a way of linking the two?
View 2 Replies View RelatedI have a database with the polyline reference/handle (i.e. '13EE6A') and each polyline has a 'door number' associated with it.
I can easily create a query that produces a table of polyline ref and associated door number.
I need to somehow import that door number into the middle of each polyline on the drawing - i.e. if there is a polyline with that handle, put the associated door number in the middle of the polyline on a certain layer. I do NOT need an active link between the database and drawing - it's just to initially populate several thousand rooms numbers!
Problem:
How to read real number data from selected columns in an Excel spreadsheet into an illustrator javascript array variable, so that then I can use this information to construct an illustrator polygon.
Further information:
I am new to javascript (and not much of a programmer in the best case, but do have some basic knowledge using ancient languages like FORTRAN 88). I am sure I am just missing an important step here despite all morning browsing with Google for answers (something to do with variable definition I assume?). I have some survey data defining the outline of features in map view listed in a string of point (x,y) values in adjacent columns in excel (these x,y point values calculated from GPS data using a commercial program to converted 3D position to a 2D x,y by geoid projection, and then in excel to re-scale point locations to illustrator’s artboard). What I am trying to do is select columns of x,y value pairs in an excel spreadsheet, copy these values to the clipboard, and then develop an IA JavaScript to draw a polygon through the specified set of x,y points. It seems easy enough to script illustrator to draw the polygon once I get the values from the clipboard are in a javascript array (lots a good tips here [URL] ....), but pulling in the clipboard data seems to be beyond me. I have tried populating a defined array with various combinations of array declarations and app.paste(); or windows.clipboardData.getData('text/plain'); with no satisfaction. I then had the idea to try to pull in the clipboard to one long continuous string, place that in a text box (see see its structure), andthen read and split up the text in a loop to populate the JavaScript array…but that deposited a complex illustrator table object into my text box, and several attempts to force the clipboard to paste text did not work (again probably having problems understanding variable type declaration).
I would be happy to find any method of scripting the pull of the selected on an excel spreadsheet for use in an Illustrator script…so if I am making this all harder than it needs, be I would be grateful to know that also!
You can organize a multi-threaded work with data through Inventor API? For example, there is a assembly and I need the first part of assembling a list of items to consider in a data set, the second part of the list - in the second data set, the third - the third and so on up to N, where N - depends on how many threads can run in the system . Whether these flows are processed and to receive data in parallel? Or go to the consistent implementation of this algorithm will first be processed by the first part, and only after it will start the second ...?
Autodesk
I am having a terrible time getting the thread modeler to work correctly for an M16x 1.5 thread. I have tried multiple approaches to get the correct thread dimensions output.These are the steps I take:
1) Create hole (I've used both major and minor thread diameters,16mm and 14.376mm)
2) Apply Inventor threads (M16 x 1.5)
3) Select threads from tree using the Add-in thread modeler "Controller"
4) Analyze dimensions finding both cases yield the wrong dimensions.
This add-in would be very useful and a great time saver if it would work correctly.
How to add a Thread to both the Nut & Bolt....i always use the Thread Tool but i would like to also know how to add an actual thread.
View 2 Replies View RelatedI need to add thread to a hole but cannot do this under the edit command. How to do this ?
View 7 Replies View RelatedI need to make a thread of 8 D.P.I on a diameter of 104.8 mm.It's not a standard thread size.Where is the excel file with the ANSI threads?
View 9 Replies View RelatedI have recently installed Inventor 2013 Professional Ultimate and am having some issues. I can not seem to get the Thread function to work. When I go to apply a thread I get the follow error....
When I go to search the directory, I find that the Thread xls document is infact there, but it is not located where the program thinks it should be (XLS Folder --> en-US Folder)
I also made sure that the Design Data location was correct within the Application Options...
A reboot of the computer did not work.
The Edit via spreadsheet option does not work, it will not call up Excel, although it believes that it does. The computer is running Win7 Ultimate sp 1 64, Office Home and Business 2010 sp1 32, Inventor 2012 sp2. The software (windows, office) is up to date, I have done the registry edit that other sites have mentioned.
I will bring up an .ipt, right click on Table, click on Edit via spreadsheet. I will get a circle for a cursor for a moment as if it were processing, then nothing. I right click on it again, and just get the How To option, so it believes Excel is open when it is not.
I have just inherited a project where I have been asked to supply our purchaser with a list of non-stocked fixings.
OK so far, i hear you ponder, but the designer for reasons of speed (his words) didn't add the fixings to the assmbly!
Is there any way to list all tapped hole features to an excel spread sheet so that i could then just sort and count and then be able to hilite the specific parts in inventor to find the length?
The prospect of looking at each individual part for tapped holes fills me with dread (shudder).
HP z210 16Gb ATI FirePro5800
Autodesk Produst design Suite 2012
Trying to figure out the best method to insert an IDW into an Excel spreadsheet without sacrificing quality. I have tried several methods to go straight from Inventor(2012) to Excel(2010) using print PDF at press quality, export JPEG, and even the snipping tool as a last ditch effort all of which inevitably loose all line quality when inserted to Excel.
I have only had success bringing a PDF from Inventor into Adobe InDesign where I am able to mimic the design of my Excel spreadsheet and create an additional PDF to include with the Excel document. It seems like there would be an easier way for Inventor and Excel to work together without sacrificing quality or adding additional steps.
I am trying to export some data from my BOM. I require the part names, quantities and lengths. I have followed a previous topic in these discussions which is now closed. it seems simple to follow but requires me to click on the export BOM icon in the top left of the browser. In my instance this is greyed out. D
View 4 Replies View RelatedIn my project file, under design data folder options, I have it set to c:designsStandardsStyles. This is where I have my thread.xls located.
When I try to place a threaded feature, Inventor gives me a warning that it cant find the Thread.xls file.
It is looking for this file in c:DesignsStandardsStylesXLSen-USThread.xls. Where is it getting this path from?
We are using inventor 2012 at my school and have recently purchased a makerbot 3D printer abd having lots of fun. However i recently created a model that has an M40 Thread as part of the model. However when i try to 3D print it, it doesn't recognise the thread and it isn't printed. I see the thread on the ipt but once it is saved as an stl it seems to disappear.
View 6 Replies View RelatedHow to make the nut in this assembly turn with the thread, all I can figure out how to do is put it all the way in then turn it 360 degrees.
i5 3570k@4.4ghz gtx 670, 8gb ddr3 1600mhz
How to make thread in assembly?
View 9 Replies View RelatedI would like to use a multi-value custom iProperty 'item_finish' in the part or assembly model to drive an iLogic rule.
'item_finish' would be 1-24 from the list.
The part file would have an embedded spreadsheet with column A corresponding to the 'item_finish'.
The spreadsheet would have column B containg long text descriptions of the finish process.
The ilogic rule must take the 'item_finish' number, find the corresponding row and then return the B column cell text to a user parameter 'defined_finish'.
The 'defined_finish' parameter can be called in a sketched symbol to describe the finish.
It appears this is all possible, but I cannot find enough information describing the snipped code requiremnets to accomplish the goal.
Im struggeling with creating a code that opens a certain Excel spreadsheet and retrieves / inserts info.
the spreadsheet is a list containing part numbers for purchased components, therefore the list must be filled with information from iproperty. But it has to be where the next available number is. i had this working in iLogic, but have to move it to VBA for better use. the code that worked in iLogic is this one.:
[URL]
If possible it would be nice if the code at the same time retrieves the new partnumber and saves the active part as this part numeber...