Jump to content

Search the Community

Showing results for tags 'database'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • CADTutor
    • News, Announcements & FAQ
    • Feedback
  • AutoCAD
    • AutoCAD Beginners' Area
    • AutoCAD 2D Drafting, Object Properties & Interface
    • AutoCAD Drawing Management & Output
    • AutoCAD 3D Modelling & Rendering
    • AutoCAD Vertical Products
    • AutoCAD LT
    • CAD Management
    • AutoCAD Bugs, Error Messages & Quirks
    • AutoCAD General
    • AutoCAD Blogs
  • AutoCAD Customization
    • The CUI, Hatches, Linetypes, Scripts & Macros
    • AutoLISP, Visual LISP & DCL
    • .NET, ObjectARX & VBA
    • Application Beta Testing
    • Application Archive
  • Other Autodesk Products
    • Autodesk 3ds Max
    • Autodesk Revit
    • Autodesk Inventor
    • Autodesk Software General
  • Other CAD Products
    • BricsCAD
    • SketchUp
    • Rhino
    • SolidWorks
    • MicroStation
    • Design Software
    • Catch All
  • Resources
    • Tutorials & Tips'n'Tricks
    • AutoCAD Museum
    • Blocks, Images, Models & Materials
    • Useful Links
  • Community
    • Introduce Yourself
    • Showcase
    • Work In Progress
    • Jobs & Training
    • Chat
    • Competitions

Categories

  • Programs and Scripts
  • 2D AutoCAD Blocks
  • 3D AutoCAD Blocks
  • Images
    • Backgrounds

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Found 11 results

  1. Swibbs

    Database Creation?

    I am trying to create a database that contains additional information about the components that I am going to use in a one-line diagram. If possible I would like to create some kind of prompt related to the component in use, which allows the user to input complete specifications for that component and compiles them into a data base of some kind. I have already created dynamic blocks for each component that I will be using and there is some basic information attached to each block that will show on my drawing, but I would like to be able to create an additional database linked to the components
  2. In Feb fixo helped me to write aSQLCon function. I used the function tooquery SQL databases. I have tried towrite one enabling me to query an access database in the same way. But I am at a total loss. (defun SQLControl ( query_statement / adocmd ADOConn adorst data field fields n sqlQuery tmp data1 data2) ;; Fixo ;; http://www.cadtutor.net/forum/showthread.php?84548-LISP-to-query-MS-SQL-Server-Database-return-results-as-list-of-strings (defun tostring (received / temp ) ; Function Syntax: (tostring received) ; received: Variable to be converted to a string (cond
  3. This is my first post. Although I feel like I may have posted on this forum before. I've definitely used the advice I've found here in the past. I have a question that CAD users who deal with vast quantities of drawings might have some answers to. I work for a company that has a database of scanned drawings some of which date back nearly 200 years. There are over 10,000, mostly in a .rlc file type. Since AutoCAD has been around there are also a few thousand .dwg files on our server. We used to search through the drawings using a program that someone here wrote. You'd type in a sear
  4. Hello Community After many hours looking for a solution to my 'problem' I have been forced to sign up to a website in which there are far more skilled people than I in their programming skills. My issue isn't new but I am unable to find a straightforward solution. It is this...I wish to update individual blocks with different attributes using their handles from an excel spreadsheet on loading any applicable drawing. As I have it I have Handle | Blockname | Attribute 1 | Attribute 2 | Attribute 3 | etc. I have found Lee Mac's Update Titleblock Attributes and (as I see it) this i
  5. I will try to explain this the best I can. I have several hundred miles of aerial and buried fiber. It is in AutoCAD map 3d 2012. I was given the task to create a database that links to the drawing and consists of information extracted from attributed blocks and cable information. The blocks are no problem. I am able to get all the info needed from ATTOUT, but getting the fiber info can be done manually. The cable in the landbase (.dwg) is represented by polylines and the access database links to the handle created by autocad. I can get all the handles and then manually type the pole to pole i
  6. I have an idea for scheduling our plant’s production but I don’t know if it is possible. I would like have your input. We use AutoCAD 2011 and AutoCAD LT 2011. We also use Office 2010. I have some experience with Visual Basic. Here is the problem: We use Excel to schedule production of items in our plant. There are several workstations that produce several items each day. Presently, this activity is organized in a spreadsheet. This spreadsheet is manually updated maybe 2-3 times a day to reflect many variables that affect production. The data for this spreadsheet origina
  7. Calen Anderson

    Excel Database and AutCAD

    Good day, This is my first post after hours of searching. I have bits and pieces related to my question, but nothing substantial. I have a database with ~350 computer's physical coordinates within the building (actually not yet, but a field to fill) and all related info for that computer. Is it possible to have an object for each computer, and have that object's coordinates within the drawing updated when the database is updated? Or anything that can help with IT's management of these assets? The long-term goal is to have the maintenace people to be able to see where an asset(computer) i
  8. Hello, We are having problems with FDO Oracle Provider. Map3D 2012 id not able to see changes made on Oracle table (via SQL Developer). For example, when we delete, update or add a column in table, MAP 3D throws an error like this (Note that SIFRA1 does not exist in this table): Also, tables that are deleted in oracle are still visible in fdo oracle provider. For Example: Table MBUS_RHI1 does not exist in our database but it is still listed How can we fix this? We tried updating MAP 3D to SP1 and SP2 but problem persists. Where does MAP 3D store information
  9. This may be a bit complex, so please bear with me. We are a water utility and have thousands of detail drawings of service taps and hydrant connections (maybe 11,000 total). These are in the old Microstation J format. Each drawing is divided into a top half and bottom half. The bottom half of the drawing is the actual drawing portion. The top half of the drawing is text that comes out of an Old Oracle database, into Microsoft Word 2000 through mail merge then is copied and pasted into the top portion of the card. Newer drawings done like this and opened in AutoCAD have the top portion
  10. I have read many posts about linking attributes with excel files but have yet been able to receive any help with what i'm trying to do, so any input would be greatly appreciated. I'm an engineer that works for a company that designs offshore drilling platforms. Currently i am generating panel termination sheets (image attached) and i have to generate one for every junction box but i have several to do (several 100). What i want to do is link my excel junction box schedule (image attached) and set up my attributes in such a way that i input the originating or terminating device and the rest of
  11. I have an Acad2011 drawing with objects linked to a MS Access 2010 BOM database table via dbconnect. I have created my links successfully. However, I occasionally need to break a single object's link to its corresponding record either due to an error or change. A database record may sometimes link to multiple objects. How do I break just the one link while leaving the other objects' links intact.
×
×
  • Create New...