AutoCAD Map 3D :: External Database To SHP Files OD Table
Oct 25, 2011
I have shp files and an external database file and I wish to merge the data from the External database to the Shp files OD table.They both have a column with entries matching so I figured I could use a Join to complete this. This is where I have run into difficulties.
I tried to import the spreadsheet using FDO but there is no XYZ data its just pure data. I added dummy XYZ data and tried again but I am unable to insert the data. the checkbox is greyed out, I select the Identity property to match the main title and it does not work.
I tried adding a new data source but I am unable to perform a join with this. right way to import the data from the excel sheet and add / merge the data to the FDO table created by the shp file.
View 3 Replies
ADVERTISEMENT
May 10, 2012
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 Related
Jul 14, 2011
For some reason, I can't seem to find all the right steps in the right order to accomplish this. Maybe what I'm trying to do isn't possible.
Using either Map3D 2011 or Map3D 2007:
I have a database (SQL Server) and a drawing (.DWG) with object data fields. For simplicity, lets say the database field names match the object data field names. The key field in the object data is already filled in. I would like to link to the database so the rest of the object data fields are filled from the database. Is this possible? If so, how? The closest I have gotten so far is creating a link template and using mapod2ase, but that creates a separate set of Link Template fields instead of filling in the Object Data fields.
View 5 Replies
View Related
Nov 27, 2013
what other programme you can open survey databases in? Up until about Civil3D 2011 you could open them up in MS Access, but the type of database has been changed and I can't do that anymore.
The reason I want to do this is that opening the database in Civil3D does not expose all of the contents of the database eg. prism constants. I would like to see the entire contents of the database.
Civil3D 2014 - Windows7 64bit
View 6 Replies
View Related
Jun 11, 2012
I am using 2012 autoCad. I have created an external MS access database in 2010. I want to map some fields like Polyline areas to DB field. DBConnect wasn't that much usrful to me for external databse.(Or I might be missing something).
Is there anyway that I can map AutoCAD-2012 Polylines to External database field so that updating polyline auto updates the database??
View 2 Replies
View Related
Mar 2, 2013
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 :
View 3 Replies
View Related
Mar 24, 2011
I need to add table in acad as an external reference via ms excel.
View 2 Replies
View Related
May 30, 2012
Some view-port with excel table external reference does not appear when I print
View 1 Replies
View Related
Sep 26, 2013
I have started a new project and would like to use the database table from a previous project with this one. Basically what I want to do is create a new shape file using the a previous database table so I do not have to create a whole new data base.
View 1 Replies
View Related
May 31, 2011
I have just installed Map3d 2012 on a new windows 7 machine and connect to data using oracle! I have some .layer files that are stored on my server which worked perfectly in 2011! The problem I have now is when I use Load layer from the task pane I receive an message that reads..
Failed to open FDO connection
ORA-01005: Null password given: Logon denied
I can log in to my oracle database which gets rid of the error but no data is bought in! Also if I try to connect with query (polygon region on Map) from data connect (polygon region on Map) no data shown, just a red polygon where the data should appear!!
View 8 Replies
View Related
Apr 25, 2013
I have imported csv files into my database but after closing the database and reopening I cannot import any more files. I can only import the events that I already brought in into the current drawing. Is this a common issue? How do you fix this?
C3D2012 SP2
Win7
View 2 Replies
View Related
Aug 6, 2013
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.?
View 4 Replies
View Related
May 17, 2013
is it possible to show all files from a folder with external links in a listbox? Is it possible to check if the link is OK?
View 1 Replies
View Related
Dec 9, 2012
when trying to follow the "Getting Started: Animated Battle Scene" tutorial. I am at the "Adding Materials to Objects In the Scene" section of the tutorial where I am being instructed to add the textures onto the objects, however when I open up the Compact Material Editor, all of the samples (Battlefield, Cannon, Windmill, ect) are nothing but grey spheres.
I was able to locate the image files stored in my Documents/3ds_Max_Tutorials_scene_files folder, however when I close out of 3DS Max, reopen the program, and reopen the scene, I am presented with the "Missing External Files" message box. Where should I store the image files so that 3DS Max is able to locate the image files?
View 1 Replies
View Related
May 16, 2013
Is it possible through VB or VBA to delete links to external files?
View 3 Replies
View Related
Apr 2, 2013
Automator script to backup Smoke 2013 database and other vital files? If not, where could I find a list of those files?
View 5 Replies
View Related
Sep 13, 2012
Is it possible to loop through multiple files in a directory?
Like this: (setq file (open "..\TOPO QUADS\*.jgw" "r"))
Windows 7 x 64 Professional
Nvidia Quadro 4000
8 GB Ram
i5 2500 @ 3.30 GHz
Civil 3D 2012 SP 2
Civil 3D 2013 SP 1
View 9 Replies
View Related
Sep 3, 2011
Our general manager strongly worries about data security after reading this news. [URL] ..... How we can forbid staff from Saving files into external drives, Printing specific files, Printing screen? We are also in finance field and we are not going to pay for penalty charge due to data loss.
View 6 Replies
View Related
Nov 7, 2011
I HAVE PASTE EXCEL FILES ON MY DRAWINGS BY USING PASTE SPECIAL, AUTOCAD ENTITIES, AFTER THAT WHEN I SAVE MY FILES IT COMES LIKE THIS:
SAMPLE.dwg" has a command in progress.
Hit enter to cancel or [Retry]:
I ENTER IT EVEN RETRY IT BUT MY FILES STILL NOT SAVE.IS THERE'S A WAY TO SAVE MY FILES AFTER I PASTED EXCEL?
View 2 Replies
View Related
Jun 28, 2013
When I go to plot, my plot styles table only shows .stb files. I have a bunch of .ctb files that exist in the plot styles folder, and everything is pathed correctly but the .ctb files do not show up in autocad. How can I get these files to be available?
(They do show up in some drawings for some reason though, just not when I create a new drawing file.)
View 2 Replies
View Related
Oct 7, 2011
In some cases (especially with files imported from dxf format), the tables of print style are only with .stb extension but I need to use the Monochrome.ctb. How Can I load this table if it doesn't appear in the list?
View 1 Replies
View Related
Jul 17, 2013
If uninstalling and reinstalling will get the external files that I am missing now, will properly load on the reinstall. It seems that nearly every tutorial I have tried to do is missing critical external files. When I open the material editor, the compact one, the sample files are there, but they are all blank. That is there has been no material added to the sample. Is there a way I can import the missing external files without having to uninstall and reinstall?
View 5 Replies
View Related
Feb 3, 2014
I am using LR5.3 and can't manage to move files to my external HD. I did it already but for some reason it does not work anymore.
View 2 Replies
View Related
Jan 18, 2013
I have some data in the form of
point# | X | Y | Desc_1 | Desc_2 | Desc_3 |....... ect
I would like to make an excel table that i can create multiple points from and make that table dynamic, ie if i edit the table the points will change.I would be labeling the points according to the different desc_# in multiple drawings
Is there any way to do this? I have messed with creating a user defined property classification and creating a new point file format, but i want that point file I imported to be dynamic, and if I change values the values will change in all my drawings.
View 4 Replies
View Related
Oct 31, 2013
When I try to import files from external drive I get message " the disc to which you are importing to is low on space" but I am importing from a different disc and not importing to that disc. The message is a hang up and no matter if I import to my catalogue I still get the same message,
So how do I get rid of this hang up and import files again?
View 3 Replies
View Related
Aug 18, 2013
I decided to use my external drive and imported my pics to lightroom 4. I went through a few and flagged (rejected) several. When I tried to delete them, I get the prompt that asks if I want to remove from the library or permanently delete from disk. I choose the latter but then nothing happens.
View 3 Replies
View Related
Nov 1, 2013
I moved my images to an external drive through LR5.2. Everything is working great except there are 6 files (organized by date) that LR says already exist on the external drive. They are not on the external drive and I can't seem to get LR to move them. Everything is in date order, so it's easy to see thay they are not there. How to move these files? BTW this has happened with more than one batch move... now I have a few dates from each move that remain on my computer leaving holes in the file dates on the external drive.
View 1 Replies
View Related
Mar 8, 2012
I've searched here and found several people getting this failure and just want to add that I'm having the same problem. I have the latest everything, full stop ... I get the prompts and nothing happens in the end. The photo stays in the catalog. I have resorted to removing them from the catalogue, but they're staying on disk.
View 3 Replies
View Related
Mar 15, 2012
The angle or radius are outside the table boundaries. I have used bend tables before and have not run into this. See screenshot. What I don't understand is that in the error dialog box the Thickness is correct the Radii are correct and the Angle is correct except it is showing a -90 degrees. Is that the problem? The negetive? Why is it showing a negative number. I can't change the way the part is formed. The problem seems to be with the lower left hand curl. It does go ahead and flatten it, but I don't trust the results when I have the three errors.
View 1 Replies
View Related
Mar 14, 2013
In our company, we put Excel tables in our drawings. The reason we've chosen for Excel-tables is that we can adjust the layout of the table quite easily. These tables consist of grouped cells in a particular company-specific layout. We select the range of the desired cells, copy and paste them in our AutoCAD drawing. This drawing is sent to our customers. The disadvantage of this method is, that when our customers (who use CAD-software of other brands) open the dwg, they don't see the table, but some kind of picture of the table.
Is there a way to 'explode' the excel-table, but keep the specific layout of the table? For attributes in blocks there's the 'Explode Attributes'-command in the Express-tools, but is there something similar for Excel-tables?
Product Design Suite 2014
Inventor 2012 SP2, Vault 2014
HP Workstation Z220
Intel Xeon 3.4GHz
16GB RAM
Nvidia Quadro 4000
Windows 7 Professional (64bit)
View 2 Replies
View Related
Oct 20, 2012
I bought a highly recommended Western Digital My Book Essential external hard drive to backup image files, then discovered that the WD software doesn't support .dng files. Is there any way to get around the WD software and backup .dng files to the WD external drive? I'm using PS CS5.1, version 12.1 x32 on a PC with Windows XP professional.
View 3 Replies
View Related
