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...
View 1 Replies
ADVERTISEMENT
Mar 5, 2013
update the title block attribute from the drawing register with capital letters and not lower case which has been entered into the drawing register.
That is everything that is updated from the drawing register is upper case when we want lower case.
View 7 Replies
View Related
Apr 19, 2012
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
The aterisks can not be added from the civil3d .
View 9 Replies
View Related
Jun 1, 2012
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?
Inventor 2011
View 1 Replies
View Related
Jan 16, 2012
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.
View 5 Replies
View Related
Dec 22, 2011
I am using Auto Cad LT 2012. How do I import an Excel spreadsheet into my drawing?
View 2 Replies
View Related
Apr 26, 2013
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!!!
View 4 Replies
View Related
Jun 7, 2012
I want to access the solid opened in AutoCAD from dwg file using C++ and Object ARX.
View 3 Replies
View Related
Dec 29, 2013
I am usint Elements 12 and trying to utilize double processing but can't get the both images to register in layers when I try to pin-register?
View 4 Replies
View Related
Jan 7, 2014
I am trying to link excel file to drawing file (idw), but couldn't succeed.
View 2 Replies
View Related
Aug 27, 2013
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.
View 3 Replies
View Related
Jun 27, 2012
How to create a excel file using ilogic?
View 6 Replies
View Related
Feb 9, 2012
I am looking to import an excel file to creat points within LT 2012. Can this be done?
View 4 Replies
View Related
Jun 7, 2012
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?
View 3 Replies
View Related
Feb 28, 2013
How do I copy a drawing from one dwg file into another without copying its layer properties along
View 5 Replies
View Related
Feb 4, 2010
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.
View 7 Replies
View Related
Jan 3, 2013
Is there a way to paste the results of a mass properties query to the drawing rather than to a file?
I have a complex shape that I am analyzing and would like the properties as part of the drawing for refence purposes.
View 6 Replies
View Related
Feb 24, 2012
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.
View 1 Replies
View Related
May 20, 2011
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.
View 4 Replies
View Related
May 22, 2013
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.
View 9 Replies
View Related
Jun 26, 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?
View 7 Replies
View Related
Feb 11, 2013
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.
View 1 Replies
View Related
Sep 24, 2013
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.
View 1 Replies
View Related
Aug 30, 2006
Is there a way to access AEC-data (connection properties etc) using the SDK?
View 1 Replies
View Related
May 29, 2013
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.
View 8 Replies
View Related
Apr 11, 2012
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)
View 9 Replies
View Related
Dec 27, 2011
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.
View 5 Replies
View Related
Oct 21, 2012
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?
View 5 Replies
View Related
Mar 7, 2013
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.
View 1 Replies
View Related
Dec 4, 2012
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.
[URL]
View 6 Replies
View Related
Sep 23, 2011
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.
View 4 Replies
View Related
