AutoCad :: DWG File Properties To Excel Or Access To Create Drawing List / Register
Jun 3, 2011
I am looking for a way to use the .dwg file properties of a drawing to generate an updateable drawing list/register. One that will update automatically as the file properties are updated. I have already created a title block that uses text fields to display custom properties of the file on my title block, such as the job no., drawing no. etc.
I have searched the web for answers, came across this site, joined and searched through it... There are a number of threads that 'sorta' deal with my needs but alway tend to digress more towards the "poster's" needs and away from mine. I noticed that they all talk about Lisp Routines and I have no knowledge of using them. Is that the only way to go or can I use another route? Another one was the Sheet Set Manager but I don't think that this is exactly what I am looking for...
Is there a faster way to create figure prefix i.e form excel spreadsheet or access.
I have one tip also. When you modify the figure database "C:ProgramDataAutodeskC3D 2013enuSurvey" by using notepad and you add "*" after each figure it will connect during linework codes that much the prefix code and will exclude the integer, EPN1 and EPN2 will be treated as EPN
Is it possible to change a Parts Only parts list on a drawing into a Structured parts list? When a new parts list is created and you select the view it automatically chooses parts and greys out, preventing you from actually changing it manually. Is it possible to get around this without having to start a new drawing?
I have X5 and would like to know if there is anyway I can insert an excel name list into a coreldraw file. The file is a layout of badges with a name on 1 line of text, I want to change each line by inserting or dropping the name in with the name list I have in excel. Then there's no worries with spelling corrections on my part.
I would like an VB application that from within autocad can open an excel file,from there select 2 columns containing x,y co-ordinates. Which when selected will draw a polyline in the acad drawing.
I usually do this the long way, but it seems I'm doing it more and more so would like to have it fairly automated.New to VBA and stuck at even opening the excel file....nevermind the actual selecting columns and drawing of the polyline!!!
Q) A user will enter information for a new drawing into the Excel file, this will generate an autocad drawing (title block and attribute information) and fill in the title block based on the information in excel file.
OR
Q) a user will create a new autocad drawing from the new templates and fill in the title block. This information will automatically fill in the Excel file.
I have Custom Properties on Drawing File. Naturally it is non-editable. But from AutoCAD When I write Command "DWGPROPS" it can be edited. I does not want it to be edited at any time.
Is it Possible to lock it using Coding? Or CAN we disable the Command "DWGPROPS" of AUTOCAD into AutoCAD?
Is there a good reference that deals with command line formats in scripts?
I'm trying to create a script from an Excel file with a sequence of line commands. However, it seems I have to add a blank line in between each one to end the input. Is there something I can add at the end to avoid having to insert blank lines?
Also have the same problem with the -layer set command.
I have to list all object data on some 4000 drawings. The drawings have been created in an unkown version of autocad and are electrical in nature. It would be great if a LISP file could be created to extract all of this too individual Excel or text files.
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.
the properties palette started only showing the current properites for the drawing and not the properties of the entity selected. what causes this i am using autocad civil 3d 2013.
I have an excel file with thousands of rows, each with a column for the x-coordinate, the y-coordiante, the height, and width of a rectangle. I need a script that will ask me to select the excel file, read the excel file, and create rectangles from each of the thousands of rows. I'm working in a windows environment and have Illustrator CS4. Any scripts out there that might give me a start?
I am converting 1100 files from RAW to JPEG in ACR and after about every 10 or 15 images I randomly get the script alert 'I am unable to create a file in this folder. Please check your access rights to this location'
Under the properties on that folder 'full permission' is checked for everything. All of the images that have been processed are saved into that folder as well.
Is there a way to access AEC object (AEC_WALL etc.) properties from RealDWG? I am able to get the class name AecDbWall. And even the extents of the entity.There are some Aec*.dll files in the RealDWG folder but I am not sure what to use to get the properties of Wall,window.I'm using visual C++. I have installed the object enablers of Architecture Structure Drawing, MEP, and also of Civil.
I have AutoCAD 2013 and often "paste special" excel files that automatically update when the excel file changes.The problem I'm running into is I work with a person who has uses an older version of CAD 2004, so I always save to the older format for him.
When I etransmit, I be sure to add the excel file, but when he opens the dwg, only the outline of the excel appears in his dwg, no content.
I have a script that makes PDF-file with suffix revision. Now I want to expand this script so it even makes a STEP-file of the 3d-file connected to the drawing. This would make all manufacture files in one button. That should be nice..
How will i manage with this since the active document is the drawing not the part. (see code below)
Set oDoc = ThisApplication.ActiveDocument Call oDoc.SaveAs("C:UsersGoranWeDesktop est estfile.stp", True)
I'm fairly new to Map 3D and I'm trying to attach either an Excel or Access file as a data source. I started out with a simple test case and created both Excel and Access files following the steps outlined in the first reply in post:
[URL].......
When I get to the drag & drop step to attach the data I get the following error messages:
Invalid Wordspace file format: My DocumentsTEST.xlsx Invalid Wordspace file format: My DocumentsTEST.accdb
Not to be deterred, I saved the source files back to earlier xls and mdb file versions and was successful at attaching the data in both cases, but Map reported that there were no tables when I tried to define a link template.
1. How do you register file associations? In previous versions you could go into the File Menu and select which files you wanted Elements to open. I don't see that present in Elements 11.
2. After I crop a photo and save it the photo looks a little blurred and ragged on the edges, but it looks sharp in Windows Photo Viewer. How do you make it look sharp in the work area in Elements?
Recently I upgraded to 2013 and I been having some issues with my survey DB, first of all I created a base data shortcuts project template folder with all my folders and a default Survey DB.
once I create my project, and import points to the default DB, I have no access to the Figure Properties. Is this feature, that worked in 11 & 12 now broken in 13? I have gone into the setting and copied a new files to the folder several times, to no avail, and there are no other versions of C3D on this machine.
So now that I have my points in the drawing, I go to translate them to my survey, generally I will utilize line in the drawing between field data, and platted data to translate and rotate to the platted lot or lots and the work from there on any calcs or changes. However, when my OSNAP toolbar is docked and locked and I go to select a point line the midpoint, I have no access to the OSNAPS. This also, worked in 11 & 12, but seems broken in 13.
I work for a company that makes sheet metal cabinets. Each cabinet we construct has 17 parts that all different different blank sizes and notching. I have a template for each part right now that I have to shrink or stretch to the appropriate size every time we get a custom size order.
What I've created so far is an excel spreadsheet that determines the sizes of all the parts based on the overall height width and depth of the custom cabinet that was ordered. Any way to define a parts properties with a dynamic block and get the width depth or height imported in from the excel spreadsheet to automatically adjust the size.
We are trying to switch to a new parts list format, and the goal is to have all of our parts list imported from excel spreadsheets. The problem we are having is that we cannot import from excel and maintain the format from excel. The problem seems to be with merged cells. I have tried it both by: 1) Annotate > General > Table and 2) Manage > Insert > Insert Object with no success. I have a non-ideal work-around for this by inserting the "QTY PER ASSY" separately as a sketch symbol.
Attached is a sample of what we would like our parts list to look like. The red rectangle outline is what would be imported from excel.
