AutoCAD Map 3D :: Convert DWG With Database Links?
Jun 8, 2012
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.
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?
I have 200,000 lines with some object data. LINKED to these lines is a database with some more information. Basically I want to export all of these lines to shape files, converting the information in the linked database to be the new object data. (This is for the client to view the lines on ArcGIS).
I have done this a few times in the past, but working with this volume of lines and data, Its taking an extremely long time.
My question is, could i use autolisp to quickly transfer the database data to object data before i export to shape files? or if there are any other options.
I'm reconstructing an old document originally developed with PageMaker. I've recreated a half dozen pages hopefully with more uniform techniques. The original line art for the pages was created in AutoCad and some were scans. To bring them into InDesign some of the art is now in psd format and some of the newer art is in Illustrator AI format.
I've noticed that the pages with photoshop art print pretty quickly (about 30 seconds). The ones with Illustrator art take much longer (about 1:30 seconds). They go through a flattening process.
I print these 50 page books on demand and that additional time would add about an hour.
I guess the question is whether this is normal and to be expected or not. If it is I'll likely turn everything into raster before going into InDesign. That, however, seems like quite a bit of extra work. Going from AutoCad to Illustrator (to add stroke) then to PhotoShop to change to raster and then into InDesign seems like a pretty convoluted work flow.
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.?
My company produces drawing sets that show the same information in multiple places. I.e. an attribute in drawing A is also shown in a different block in drawing B and a different block in drawing C and in a table. This creates problems in that as soon as one piece of information changes, you have to change it in 14 places... and it creates typos. A LOT of typos. So I'm trying to come up with a good solution as to how to link these pieces of information.
I know how to use data links in a table... but is there a way to link block attributes? Also, am I just barking up the wrong tree? Because in my head, you'd have to manually link all of these things for every new drawing, and they can be easily broken.
How to manipulate data links? I want excel tables to come over and use their native excel formatting. I have a heck of a time getting them to look right (text size, font, justification, cell size, etc) and then when I update the link after making changes to the XLS, they get all cattywompus again.
I've never been real strong on text management in CAD; I'm always scaling text and doing poor drafting things like that. So I looked into Tablestyles and things a bit and thought I had it, but not so much.
Is it possible to put links into AutoCAD drawings?
For instance could I set up an icon / text that if clicked on opens another drawing, pdf, word document, excel document or other.
example: if I have a note in the drawing saying "see drawing A123_456_789 for details of power cable" could I put a link next to it that took you straight to the drawing?
If it can be done is it possible to save the drawing in a format that somebody without AutoCAD could view drawing and use the links.
I'm developing a custom SA in C#. At some point, I need to get a shape area and a link length from other SA (created with subassembly composer). This SAC subassembly is created before my custom SA in the assembly.
In the DrawImplement function the corrsidorState list of links and shapes is empty...
I am working on Inventor 12, previously Inventor 10 and recently (approx 4 months ago while I was still on Inventor 10), all of a sudden, if I tried to open a drawing where components had been deleted for example, it would not try and resolve the links, just straight crash the program.
Windows 7 Professional 64-bit Nvidia Quadro 2000 8Gb RAM 2 x Quad Core Intel i7 2600 CPU @ 3.4GHz
is it possible to restore an associative link? I have a model that is being run by ilogic rules and everytime i run the model a invisible part in the assembly is still visible in de drawing. i can manually restore this by RM-->subassembly--> representation--> and then switch it to associative again, but i want it to just do it automatically.
ia also tried to do it with de following code but it doesn't seem to have effect.
''------------------------------------------------ThisApplication = InventorVb.ApplicationDim oDoc As Document = ThisDoc.DocumentDim oCompDef As Inventor.ComponentDefinition = oDoc.ComponentDefinitionDim oCompOcc As Inventor.ComponentOccurrenceFor Each oCompOcc in oCompDef.OccurrencesoCompOcc.SetDesignViewRepresentation("Default",True)NextRuleParametersOutput() ' use this before DocumentUpdateInventorVb.DocumentUpdate() ' Update now
it will run okay but the sub-assembly still doesn't switch to associative or it switches back after the update?
there must be a way to just simply put the associative link back on.
ps: in the .idw the associative link is enabled but the subassembly is missing his link to the main assembly.
why am i not allowed to have multiple direct links for a node (junction/outfall)? i have a situation where i want to add the flows to two junctions, one for each side of the property, then add the two junctions to an outfall (overall site). i do not want to model the pipes, just want to add hydro graphs.
my each junction has two direct links coming from two other upstream junctions, and then this junction flows out by a direct link to the overall site outfall (the set of junctions from the other site does the same). i cannot run the model because of the error:
ERROR 134 : Node TOTAL-EAST has more than one DIRECT outlet link or DESIGN pump. ERROR 134 : Node TOTAL-WEST has more than one DIRECT outlet link or DESIGN pump.
There are two polygon topologies in the dwg attached. The 'Parcels' topology is a source while the 'RoW' topology represents an overlay topology. Both are reported correct and complete, nevertheless an intersection overlay operation
does not show the expected result. Instead, a rather painful error message comes up: Can't create polygons.Some links could be lost. Frankly, I have never known any of the messages before...
Ironically, this sample is a part of a greater drawing and the rest of the topologies work just fine.
How does the datalinks handle the links to the excel spreadsheet. I am drawing parcels from legal descriptions and would like to link each parcel to a spreadsheet with all the parcels data via a ID number. Then be able to click on that parcel and see the owner (the link). But my question is: do I have to give each link a new name to correspond with the parcel in order to see each parcel ownership?
I'm the only one out of a bunch of guys using 2012. Others in my office are using either 2010 or 2009. They can set up Excel tables with links and have no troubles but, the minute I try to edit one the link gets broken. I also have an issue where if I highlight the border of the OLE, right click, and try to open the OLE... I get a small error box saying that the server application has failed.
I'm new to AutoCad 360 but I'm finding it impossible to find link to Xrefs on the 360 drive - I'm logged in and can see the files in Windows explorer but can't link them into the file... It means I have to work from different locations which is a nightmare for co-ordination.
On grade Inlet Inlet-01 does not have two outlet links. At least one stormwater sewer pipe and a bypass gutter link must be defined.How do I add another link?
I am running Inventor 2008 and have recently created a few models. All of the models I have created have been linked to external spreadsheets at the part and assembly levels. Everything for a complete model is in a single folder, the spreadsheet and all parts, assemblies and drawings. With my previous models I was taking the entire folder and copying it to new locations to make slightly different models. When I would do this all the links of the copied parts were pathing to the copied spreadsheet, not the original, which is what I want. With my most recent model the copied parts are still pathing to the original spreadsheet.
P.S.: I tried to get around this by doing a pack and go and ended up with the same issue.
How are people modeling curb inlet bypass flow? When I first got into using SSA, I looked on-line through some AU handouts and blogs etc. I learned to model on-grade inlets using direct bypass links. I would create one that linked upstream and downstream inlets. It appears that hydrodynamic routing is the preferred option for modeling pipe networks with storage nodes, and the direct links don't work due to error 134. It would seem that the logical fix for this is to model all gutter bypass as user defined open channel and create a channel section that matches the road and gutter section. Is that correct? Also, how does the software view a direct link versus open channel?
Using IV2012 SP1, I needed to generate a bracket that had has silkscreen graphics on it. So in the part file I started a sketch/insert image and using the decal command projected it onto the desired face. The image is a BMP file that is 5meg in size. It took me several attempt to get this right and all appears to be good. But upon completing this very simple part I noticed the file was 48meg! I went into “links” and I noticed that the BMP file was shown 7 times. The BMP file is showing “yes” under “resolved” for one instance and “no” for the other 6 instances. I can only “break link” one instance but can do nothing with the other. I’ve deleted the decal and stated over but it still shows up with the 7 instances.
I'm creating temp projects out the wazoo. There are so many unresolved projects that Inventor's window to "Click okay and stop searching for these projects window" is longer than my two widescreens can display stacked on top of each other in portrait view...
Is there any way to manually clear the projects list?
So I made a shop drawing of an assembly, which is very complex and took a great deal of time to complete. It has 3 sheets and a bunch of different views and information already on the drawing.
Now the thing is I took the assembly and made it an iassembly; but I did this in another file so I wouldnt screw up all the work I did before. Now I realize that I dont have the links to the shop drawing that I wish I did.
how to link the shop drawing to the new iassembly model?
How to avoid broken links to an Xref while migrating to a new server?
We will migrate our servers and have to move all Xrefs. The Xrefs are composed from files located on different harddrives. Let's say A: / B: / C:
When migrating to our new servers I suppose we are just fine when we name the new harddrives exactly the same as the current situation? Are there any other things we should take care of?
