AutoCAD Inventor :: Read / Retrieve Information From MS Access Database Using ILogic
Nov 9, 2012
I am currently trying to retrieve data from a MS Access Database, we currently have iProperties with number values in them. An outside programmer created a code which takes these values and exports them to an MS Access Database, where they are then translated to mean something.
Instead of exporting those numbers, I want to use them to find what they ACTUALLY mean within the database and bring that information back into iLogic. (ie. 123456 actually means "1/4 Flat Bar Steel")
In short, I wish to access the MS Access database through iLogic in order to read information from it.
I have searched for the better part of 3 hours but have not found a good answer or example code of this situation. I am not that experienced in programming, but have worked with the API before for developing Automated Drawings and have an understanding how to navigate through. If there were to be some example code, I can begin to understand the process quite well through this method as well by seeing how to go about coding this.
View 2 Replies
ADVERTISEMENT
Aug 2, 2010
I have a program that populates an access database with part parameters. Each Inventor part can look up its own parameter values from the database when supplied with a single parameter, the ID number of the database record. The ID number is derived from a blank part that the program also updates. So in a nut shell, the program populates the blank part's parameters with all database ID numbers that would make up entire assembly. Those parameter values are derived to all the parts in an assembly. This is by far the fastest most efficient way I've found to rapidly generate an entire assembly. In a matter of seconds I can have a new 1000+ part assembly.
The rumor that Inventor will eventually sever ties with VBA has put this whole process in jeopardy. So I have been looking into using iLogic to perform the same task of looking up the data from Access. I know that iLogic has Excel functions built into it, but because the original program is Access based (changes this is not an option) any way to use iLogic to retrieve data from Access.
View 4 Replies
View Related
Jul 11, 2012
This is my problem, each material in my cie. have a number code
EX.R069ARS407WLD35460
IT'S POSSIBLE TO LINK MY MATERIALS TO A XML, SQL OR ACCESS DATABASE???
View 1 Replies
View Related
Jun 10, 2013
Some months ago I created an iLogic code that creates all my notes that I use in my drawings, linked to a form. A good tool the made my work a little easy. Now I wanna make an update on it.
In my code I create a sketchedSymbol and then some textBoxes with my notes, but before that I erase all the Symbols in all sheets and then the main Symbol itself. Then I create again the symbol and textBox in a specific point of my Sheet. So, everytime that I need to update my Notes, it goes to that point of the sheet, it's not a problem, but it's annoying have to move them always to the correct place. And i can't use a specific final point for the notes because it may change according to the drawing.
So, my idea is:
If the Symbol is already created, how can I get its position ?
I create the points with TransientGemometry and then CreatePoint2D, but I dont know how to retrieve these points, even if that is possible.
The code I use is that below (I just erase the notes because it was too big, this is just the main code creating the stuffs).
' Set a reference to the drawing document. ' This assumes a drawing document is active. Dim oDrawDoc As DrawingDocument oDrawDoc = ThisApplication.ActiveDocument'Update the document oDrawDoc.Update'apaga o symbol existente em cada sheet Dim oSheets
[Code]....
View 7 Replies
View Related
Oct 8, 2012
I want to retrieve dimensions in a drawing with ilogic. I found some code but how to translate it into a ilogic code.
I always use assembly models in these drawing and all the parameters have unique names. So in my drawing i want to retrieve some specific dimensions in a view.
View 9 Replies
View Related
Jun 23, 2012
- when modelling a part file in Inventor, only the dimensions we set (dimensions we give a name and a value), are listed in the parameters table. This way, its possible to export the information listed in that table.
- the information listed in the parameters table is based on sketches and features dimensions, as obvious.
So , my question is: is it possible to access the information (dimension values) contained in a feature (or a sketch) without setting a specific name or value to it?
For example, in the attached pictures, if a rectangular form is drawn and the dimensions are sett, these will be listed in the parameters table (see attached "pic1" and "pic1 - params").
But, in the other hand, if the same rectangular form is drawn, but this time without setting any dimension, the parameters table will be empty, obviously (see attached "pic2").
After this, i can surely presume that Inventor saves or keeps this information somehow, somewhere, without having to set dimensions or values.
So, my question is: is it possible to access sketches and/or features information without setting this values?
View 6 Replies
View Related
Oct 22, 2013
I want to present additional information on my drawings, whether in notes or some other form depending on whether it is a part or assembly drawing. The information I want to get access to is included in the material library and comes from the material Physical tab > Information section > Source, Subclass, Type, & Name.
Is the material library information accessible this way?
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
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
Oct 30, 2012
is possible to retrieve the information of the reference in the iam file without open the file in session ? Opening with notepad the iam file, at the end of file, the references is contains in the planar text.
Is possible to retrieve documentation for this request ?
View 1 Replies
View Related
Sep 17, 2012
I want to use Ilogic to construct a code part name.
My question is perform a code of about 12 characters. For example the parameter "Lenght" is 600mm but in the expressione result It must be "000000000600" (a string of 12 characters)
View 3 Replies
View Related
Mar 30, 2012
Is there a way to retrieve the fileversion in the Database.BeginSave event when the user has choosen like version 2004 in the default SAVEAS command?
I only found the OriginalFileVersion and LastSaveAsVersion property, however I have to add something in the database for version 2004 before it is saved. Or is there another approach?
View 2 Replies
View Related
Jun 27, 2011
I want to create an application that intensively uses dynamic blocks, cross checking any new or changed block entity with existing ones.
It needs to be almost instantaneous but the only way I know will be impractical.
Looping through the property collection of each block reference, searching for each parameter then checking for a match.
Is there some sort of database functionality I can use to quickly compare block information?
View 1 Replies
View Related
Nov 19, 2012
I'm now having an issue accessing the features in an assembly, the error message is attached and the following is the relative code.
The error line is between the 2 Test Messages:
'Create a Component Definition relative to the Part Document
Dim oFeature As Features
Dim oAssembly As AssemblyDocument
oAssembly = oCompOcc.Definition.Document
MsgBox("Test 1")
'Cycle through all features in the Part
For Each oFeature In oAssembly.ComponentDefinition.Features
MsgBox("Test 2")
View 3 Replies
View Related
Oct 13, 2011
I am trying to use the iProperties.Value("part1", "Summary", "iProperty") function to get the filename or complete filepath of a component within a subassembly. I know that these iProperties exist because I can insert them onto a drawing, and I see them in the general tab of the iProperty window.
However, when I try something like:
filename = iProperties.Value("part1", "General", "Filename")
I get an error message indicating that the General tab can't be found. How might I go about getting this filename iProperty, or is there an easier way?
View 4 Replies
View Related
Feb 10, 2012
I am new to iLogic and trying to access the "Application Options" under the "Tools" tab. I am trying to grab some information from a couple of fields but it seems that I don't have the right coding or Snippets that indicate how I would do so.
View 3 Replies
View Related
Nov 1, 2012
I've created a main assembly containing several ipart components. With the following rule I can read the model parameters, but not the user parameters of the iparts:
A = Parameter("Part1:1", "d0")
If I create a component, insert it in the main assembly and make it an ipart afterwards, the user parameters can be read out with ilogic. But if I insert the same ipart again, the user parameters can not be read out anymore. Model parameters are no problem.
View 1 Replies
View Related
Sep 27, 2012
how to access the drawing sheet revisions using Ilogic.My company is wanting to start making the default initial rev on a drawing a "-" and inventor does not like to keep this when brought in as a template.
So like normal I am trying to trick it into having the dash until a rev is actually added.
View 1 Replies
View Related
Jul 15, 2013
How to access the color for a particular hatch within a drawing using iLogic.
I would like to color the hatching for parts based on paramaters besides material.
ie.
Purchased parts = Green Hatch
Refrence = Grey Hatch
I would hope one could loop through the views looking for hatches, and once found, check the part they are associated with, then based on an "if then, change the hatch color and move on to the next pattern.
View 4 Replies
View Related
Jan 9, 2013
Any way to modify a user form parameter's read only status using a rule?
I have a parameter that I want people to be able to edit when another parameter is set to true and to be locked if it's set to false. The only thing that comes to mind is have a rule that will just switch the value back automatically if the user changes it but it would be good if i could control the read only status.
View 3 Replies
View Related
Aug 23, 2011
I would like to be able to use iLogic to get the value of the Comment field of a model's parameters. I have some text there that I would like to display in a sketched symbol. The attached image illustrates what I am seeking.
View 2 Replies
View Related
Jul 15, 2013
How do I get at the hatch objects within a drawing using iLogic?
I would like to be able to customize hatch color based on various part properties.
ie:
Purchased part = Green Hatch
Refrence = Light Grey
and much more
This would be possible if I can get to the hatch object and determin what part it is associated with.
I only see iLogic code that allows you to change visibility of all hatching, and set general hatch angle.
Since I can select a hatch in the drawing and change its color, I assume there is an un-published API object that relates to hatches
View 3 Replies
View Related
Jun 14, 2013
I am creating one custom plug - in for my project. and for this i want to create one dictionary.In this dictionary i want to store my object and one custom property related to this selected object( exp path item, raster item. etc).
i want to know after closing AI CS6 how can i access the same value what i stored in dictionary.actually i want to create one property for the selected item and want to save and retrieve back. this property.
View 9 Replies
View Related
Sep 29, 2011
I'm experimenting with treadsafe progressbar, that would allow me to stop the process.
but for some reason, on this line
Dim _db As Database = AcApp.DocumentManager.MdiActiveDocument.Database
AutoCAD crashes with fatal error This runs on the new thread, so i suppose it has something to do with it, but i have no clue, why this should be a problem.
View 6 Replies
View Related
Feb 5, 2012
I'm using Windows 7 (64 bit) and I have to connect a file (.mdb) created with Microsoft Access 2007 to my Autocad Map 3D 2011 draw. I uninstalled Office, installed the AccessDatabaseEngine_x64.exe and re-installed Office. Then I followed step by step the process shown in the video here with ODBC but it doesn't worked for me. It says "test connection succeeded" but when I attach the database, it comes up with a red "X" symbol next to it.
View 2 Replies
View Related
May 20, 2011
I've found a number of articles outlining the process of extracting data from AutoCAD to an Excel file, but I'm wondering if it's possible to do the reverse. For my work I have a number of databased already established in Excel and am able to create information tables rather quickly that access these databases. Currently, after creating a table in Excel I then copy, paste, scale to the right size in AutoCAD.
There's gotta be a way to create a table in AutoCAD that simply accesses this information in Excel and just updates automatically. I produce a number of CAD drawings off of a template daily so this process has become quite the bottleneck.
View 4 Replies
View Related
Oct 1, 2013
My company has an access database that has all of our service data on it. I am currently considering rebuilding the database because it is a database with one table and a million fields. I want to split the database up into separate tables with relationships. All of these tables would be linked based on the same key field Service_ID.
Now here is the hard part. The data would be in a one to many relationship with one record for service info and multiple records per service for pipe info. The data is currently linked to objects in AutoCAD Map 3d 2014 based on the Service_ID key field and a "service" link template.
If i rebuild this database, am I going to lose all of my links? or will i retain the links? Also, is there a way to automatically generate links based on the service_ID field? For instance there are 3 records of pipe information for 1 service. Previously all of these records would be in the same table, but now the tables are split. Since they have the same Service_ID as the Service information, will the links show up?
View 9 Replies
View Related
Nov 23, 2012
I inserted a block from a dwg drawing with the following method:
public static ObjectId InsertBlock(string fileName, Point3d insPoint) { var acadDoc = Application.DocumentManager.MdiActiveDocument; var blockId = default(ObjectId); using (var acadLockDoc = acadDoc.LockDocument()) { var dbTemp = new Database(false, true); dbTemp.ReadDwgFile(fileName, FileShare.Read, false, ""); var blockName = Path.GetFileNameWithoutExtension(fileName);
[code]........
View 3 Replies
View Related
Feb 17, 2012
Here is the Scenario, Win 7, 64 bit, Office 2010, and yes I have installed 64 bit drivers, with Map 2012.
I have an Access Database with Water and Sewer information. I connect thru FDO and every thing is great. I make a change or add something to the Access Data Base and I don't see the change until I disconnect and then re-connect? I was under the assumption that this was a live connection? Is there a way to refresh the connection without having to dis-connect and then re connect?
View 1 Replies
View Related
Aug 22, 2013
Recently our company upgraded to office 365 with Microsoft Access 2013. I cannot seem to connect to this new format using the task manager. We used to use quite an old version, 2003 I think with no worries.
Am I doing something wrong or have the developers missed something quite fundamental to Map 3d?
View 4 Replies
View Related
Dec 6, 2011
I have just purchased PaintShopPro X4 Ultimate on disk and have repeatedly a version of an installation error:
Error 1901.Error attempting to read from the source installation database: C:windowsinstaller1021ae5.msi
I've done an install of the download version and then uninstalled and repeated the disk installation: this gave the same error except a different *.msi file.This is a Windows 7 home professional X64 system and I tried it on both my own logon (nominally an 'administrator') and on the 'super administrator' mode with the same problem.
View 2 Replies
View Related
