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?
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.
When I create a sketch block, there is a description area. After the block is saved, how can I see this information again? If I right click on the block in the browser, I cant find it anywhere.
View 1 Replies View RelatedI want to block the information of plotting in the editor see example (french version) :
***Zone effective du tracé: 290.70 de large par 400.97 de haut
Fenêtre de tracé 2.
The information is showing when i plot. How i can do that ?
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]........
deleted some xref by mistake.
is there a way to restore deleted xref or block from the database?
I get a block reference (has attribute) from other drawing as code follow:
Public Sub GetBlock_Info() Dim blockName As String = "test" Try Dim doc As Document = Application.DocumentManager.MdiActiveDocument Dim doclock As DocumentLock = doc.LockDocument() Dim ed As Editor = doc.Editor Dim ofd As New OpenFileDialog("Select Drawing", Nothing, "dwg; dwt", "ATS detai drawing", Autodesk.AutoCAD.Windows.OpenFileDialog.OpenFileDialogFlags.DoNotTransferRemoteFiles) Dim dr As
[code]..........
I am trying to add a table that I can edit like an attribute but have it in a block, Basically I am trying to put information for all the poles in an electrical panel, but im not using MV parts just a block is there anything that can be recommended in this instance.
Just another note I need to reference 72 poles and 5 colums for each of these.
I've argued this repeatedly with the powers that be at my small company and they're set on some old methods that I'm trying to figure out how to make happen.
We often have weldments where we do an assembled view on page 1 and balloon it and have a parts list. Pages 2-4 will be the details of the welded parts. On page 1, I bring in the "Title" and "Subject" fields from the assembly iProperties.
Here's the tricky part. On pages 2+, I don't want to bring in those two fields, I want to bring in something different. Is it possible to differentiate like that?
Second part of the question: is there a way to pull the balloon item number from page 1 into a field somewhere on following pages? For example: page 3 may show the details for "item 2". Can I bring the value of that balloon (item 2) into page 3 somehow?
I am not sure this is even possible, but could I use some sort of invisible block attribute data and everytime I insert it into a drawing (I use the same block multiple times within a drawing) it would autopopulate fields in a table. For example I have a smoke detector symbol I insert, I also have a specific address associated with every single detection symbol I insert into a drawing, would I be able to attach data such as what type of detector it may be and have the address and type automatically populate in a table everytime I insert my block into a drawing?
View 1 Replies View RelatedI am working with a set of dynamic blocks, each with a block table that provides a drop down for the user to alter attributes from. My goal is to be able to update the block table using VBA to push data from an excel file. I do have import/export code that will update block attributes, but I am not sure the functions that would access the table properties.
View 7 Replies View RelatedI was curious, when creating multi sheet drawings, how can I place different information in the title block on each drawing?
Example, 2 pages, Description on page 1 = PAGE 1 DESC, by default this same description will show up on all subsequent pages. How do I get page 2 description to be different?
Inventor 2014 PDS
I have 200 files listed in Excel. The file name in excel is an attribute being document number in title block.
How I can import this directly into eac .dwg file?
How do you make the information in your titleblock transfer to all pages?
I am sick of going on each page in paperspace and re-editing the same minor details.
This is the command line responce I get when i attempt to enter text. All teh numeric expressions of all my dimensions have been replaced with a backslash. Along with all text including infomation on the attributed title block.
I have exhausted my options for figuring it out, do I need to reload the program? is there a restore default option? ( I haven't found one yet) I am running 2011 LT
I have a block with:
tag1: XX
tag2: YYYYYY
tag3: ZZZZZZZZ
I have an external file check.txt with string:
XXYYYYYYZZZZZZZZ
I would like to create a lisp program that check the attributes of block using an external database, if tag1+tag2+tag3 = XXYYYYYYZZZZZZZZ ok end program, if not make a circle on block :
I am working on the AutoCAD customization and doing the same by VB.Net & C#.Net. But I just want to know the difference as mentioned below:
1. Insert Block In AutoCAD
Using VB.Net without using DataBase services..Only 1 statement is required to Insert the Block objAcadDocument.ModelSpace.InsertBlock(Required Arguments are here) Using C#.Net with DataBase services
There are many statments are there to insert only 1 block..Like Start Transaction, Lock the document, Get the Object Id Block etc...So my quetion is that when I have to use DataBase services and when not
what is the advantage of doing customization using DataBase services rather than go for wihout DataBase services.?
I am a AutoCad drafter for telecommunications and I have utility pole points (long/lats)
I can insert the poles via long/lat and all is great, my issue is I would like more information in those points.
For example, pole number, class, HOA, Make Ready. Currently I create a survey data store and import ASCII Points using PNE(comma delimited)
So with my Excel file (this is where I get my pole information from) I get a point/northing/easting to enter into the formatting section.
I would like to add more information to these individual points, like ploe number, class, HOA...
If I view the point table I see that there are a lot of other columns, can I use them or customize them? is there a quick tutorial on this issue?
Is it possible to take Current User Coordinate System of external Database object, like
Application.DocumentManager.MdiActiveDocument.Editor.CurrentUserCoordinateSystem?
I'm trying to add a database (excel ) as source for object in Map3D.
I start but when i select the excel file that i've created and stored in my pc map3d says that the cration of the data source doesn't work.
what is the best way of getting (modified) event triggered for some specific object?
i see a lot of examples doing: if database is modified, then trigger event, then iterate our list to if that object is in it.
is that the better that way, like to add handler to the specific object, and then when each of them is modified, then each of them call handler?
Any equivalent ObjectOverrule for the PnId Database?
If an entity is copied I dont want certain field values to be copied.I've tried an ObjectOverrule but I can't get the RowId at that point.
I also noticed that the field values are set as XData. I edited the XData in my ObjectOverrule but the values still gets copied.Is there a setting at project level to control which fields not to copy?
I am trying to convert several drawings that are linked to an SQL database to SQL spatial. The drawings are from a Autodesk map 2004 system. I have Map D 2013 64Bit installed on a laptop along with SQL server 2012 RC0 (Microsoft SQL Server Management Studio 11.0.1750.32 Microsoft Data Access Components (MDAC) 6.1.7601.17514 Microsoft MSXML 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 9.0.8112.16421 Microsoft .NET Framework 4.0.30319.269 Operating System 6.1.7601).
To keep my rouge laptop off the company network I exported our existing SQL data to a access database that I placed on the laptop and converted back to SQL and linked it to the 2004 drawings. That part worked fine. I would like to convert all of them to SQL spatial. I have converted a small drawing but it took a couple of hours. I am in the process of a larger drawing that has 60,000 entities and it has been working for 8 hours and only has 4550 of them completed. I am using the output to fdo connection.
As part of the automation requirements we are working on (through the .NET interface), we would like to find out whether a given drawing contains a sphere and if it does we would like to know its properties. We are doing something like this, to loop through the database and am able to get all Solid3d type of objects.
What I would like to know, if a given solid3d object is a sphere or otherwise. The code snippet is pasted here for reference:
bool bContainsSphere = false;
foreach (ObjectId Id in Ids)
{
DBObject oObject = ts.GetObject(Id, OpenMode.ForRead);
if (oObject.GetType().Name == "Solid3d")
[Code] ......
I have created a new database: Database newDb = new Database(true, true) Inserted a block into modelspace and now I want to zoom extent before saving.
Can this be done working on a new database in memory? all the examples I have seen on this board use Interop on a open document.
How can I link an external database(say access/oracle) to a drawing so that I m able to insert/update attribute directly from the autocad map drawing.
View 1 Replies View RelatedHow i can browse all objects into an autocad database?
View 5 Replies View RelatedI have a preview control on a window that I want to display temporary custom entities that the user can build before adding to the current working document. Is there a way to create a temporary document and database that I can show in my preview control? The Preview Control was created with the guidance of the BlockView.net sample.
What I mean by temporary, is a document / database that cannot be displayed or edited in the editor window.
I'm having a problem accessing data manager tables in the 2011 version. My C# .NET code worked fine with 2010. Here is a sample of the 2010 code that works, but returns zero length tables in 2011.
C#
ProjectPartCollection oPP = PlantApplication.CurrentProject.ProjectParts;
PlantProject oPProj = PlantApplication.CurrentProject;
Project oProj = oPP["PnId"];
try
{
//get ACAD data table
[code].......
The last two lines fail to object any meaningful data in 2011. In 2010, I would have all the table rows and could access tags and asset information.
what's the different between
Dim oDb As Database = HostApplicationServices.WorkingDatabase
and
Dim oDb As Database = Application.DocumentManager.MdiActiveDocument.Database
I have 1 drawing open, I have another drawings Database open . I have found the LinetypeTableRecord (in the Database) of the line type I want to copy to the open drawing.
How do I copy a LinetypeTableRecord from one drawing to another?