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 want to create title blocks with text fields that are linked to an excel file for easy updating. I want to be able to open the excel file and change the sheet number, date, title, revisions etc. Any title block .dwg file and an excel file that are linked together?
View 1 Replies View RelatedHow do i create a spreadsheet for title blocks. i want to be able to fill in a spreadsheet and automatically fill in the title block....
View 1 Replies View Relatedway I can link my AutoCAD title block attributes to excel and make changes in either excel or AutoCAD and then be able to run an update? The attributes would be “REV” “DWG_NO” “TITLE” “LOCATION” “DRAWING_SIZE” and “FILE NAME”.
View 4 Replies View RelatedI've created a custom title block. I'd like to use VB to fill in this title block using info obtained from an Excel Spreadsheet; Company Name, Location, Drawing Title, etc.
View 5 Replies View RelatedI have 200 files listed in Excel. The file name in excel is an attribute being document number in title block.
How I can import this directly into eac .dwg file?
I have a title block inside my drawing and i want to link my title on the title of the file itself, so that if the title of the file was change, it will be change also inside the drawing.
View 4 Replies View RelatedIs it possible to create a block to insert on our title block that will populate itself with a list of drawings and names?
I know this is possible through the use of LISP and the Sheet Set Manager, but could this be done through a combination of attributes and fields (we want the same functionality in LT).
I'm having some difficulty in deciding how to go about creating a title block for my drawings. I have attempted to create the title block with Document fields from the drawing properties custom properties tab, and creating the same fields with information from the Sheet / Sheet Set fields. Both title blocks used attributes inside the block to house the fields, and both were .dwt files.
Is there a way to take the properties from the .dwt drawing into a newly created drawing, or is there a way to link custom sheet set properties with a newly created sheet set? The main goal is to not have the user manually input multiple custom fields either in the drawing properties or the sheet set manager of the new drawing.
i am trying to set up templates at a new job and i want to create templates with an xref for the title block so when we start a new drawing, we use the template, save to the project file and everything is there with our title block already xref'd. my problem is, the path on the xref'd title block stays the same and is still referencing the location of the file i used when creating the template. if possible, when i save the new drawing to the project foldeer i want the xref to also move to the project file and the path to the xref to change.
View 4 Replies View RelatedI have searched high and low and still could not find a tutorial to really explain how to create a drawing title with attributes (Detail Number, Sheet Number, Detail Title, Detail Scale). All I find are on creating dynamic block, which I could achieve, but I need one for a block that has (or will have) attributes.
I was able to find a tutorial on attributed door numbers, but it does not work for drawing titles that has attributes. GOAL: I would like to have all my seven drawing titles in one file and to be able to stretch the leg of any selected title to a desired length.
(again): how to create one title block that fits all paper sizes?
In the ArcGIS, the same layout can fit all paper sizes and there is no need to customize the layout for each paper size manually. For example, if the map is set up based on A4 paper size and then needed to be printed in A0 size, then all the lay out elements will be automatically proportionally changed to fit the new paper size.
I’m not sure if there is an equivalent features in the AutoCAD that handle this issue
I am setting the Custom Properties on a CAD File. The Properties may include "Drawing Number, DrawingName, ProjectName"...
Now using code I want to fetch values of these Properties and set into Layout Title Block.
I’m trying to save myself a bit of time and was wondering if it is possible to have part of the file location displayed in the title block?
The current title block we are using shows the full file location of the drawing but I was wondering if it is possible to show only part of this?
The reason I am asking is that when a project progresses to the next stage we have to go through each drawing and change the status to warrant, tender, construction etc. so I am looking for a way that this can be done automatically and I was thinking if only part of the file location could be used this process could be done by simply moving the drawings to the next folder? Our projects folders are split down in to subfolders for planning, warrant, tender etc. which corresponds with the status field on your layout. So instead of having to update this status manually every time the project progresses this would update to the folder that the drawings are in.
Example:
I:Projects## - Project TitleDrawingsConstructionGround Floor Plan.dwg
Am trying to get the "Construction" folder to display in the status field on the layout.
I want to use the File name property in my title block. But i don't want to see the .dwg extension.
Is it possible to not show the extension?
I am creating a title block in Revit Architecture 2012. I am trying to create new labels for my title block and cannot seem to get it to work. I created a shared parameter and added the parameters I wanted to add to my title block. I chose the "common" discipline and the type of parameter as "text". I added these parameters to the label parameters I wanted to insert into the title block. When I do so they show up in the edit family, but when I load them into my project they don't show up.
View 3 Replies View RelatedI am trying to create a single layout with title blockandviewport to save as a template for future. Right clicking on the layout tab does not produce the menu.
I create a new layout by selecting page set up manager in the file menu, create a new layout, but the tab does not show up at the bottom.
I am having trouble with my title block showing up in my plan view. It says it is loaded but it does not show up.
View 2 Replies View RelatedHow to create a 'No/Yes' or visibility parameter for a title block? I have my Architectural Seal as an image inserted into my title block family. I want to have that as a parameter for visibility so I can have it turned off until I am ready to print for final building department submission filing.
If possible, this would be a global adjustment so I would operate this parameter once and will affect all the sheets in the project instead of having two title block families and swapping those out at the time of filing.
I am attempting to attach a title block into a layout. This is my process:
1. Go to Building1 drawing, and go to layout. Without any viewports created, I attach a dwg file named titleblock1.
2. When I specifiy the location and scale, I cannot find the attached drawing.
why can't I attach files larger than 1.5 KB? I can't attach anything useful!
I've seen in previous thread's how to add a company logo to your title block/plot frame using a jpg file. Plus i've set the image parameters to 0 to remove the line around the image that appears. I've also set the transparency to "ON" - not sure if this is correct but did it anyway - i think.
My problem is that when I come to print it off - the logo appears with a slight background (very faint grey) when it should be just white. The logo is made up of black and red shapes with black text on a white background.
We are using a title block and it has an attribute field that links to the file name. Now one of our projects is adding the revision to the CAD file name, but it messes up our drawing sheets.
i.e. It was fine when the CAD file name was 111-A222-ZZ-X-123456.dwg and this would display the complete 111-A222-ZZ-X-123456 in the drawing title.
Now we need to do this, the CAD file name, 111-A222-ZZ-X-123456-001002-A1.dwg and we still need to just show 111-A222-ZZ-X-123456 in the title block, striping away the 001002-A1.
As I am creating drawings for parts/assemblies, I have to fill out the customers name and the job number which I currently do on every drawing I create by right clicking on the Drawing name in the tree, going to iProperties, and then filling out the fields I need.
I have to do this for every sheet. Sometimes over 100 sheets per job.
Is there a way, within the project file maybe, to have these fields be already filled in with the customers name and job number?
Every new project file I make is a new customer. So I'm wondering if there is someway to tweak the project file.
I have some code to replace the current title block with a title block from a template file. I just don't like how it adds a new title block definition named "copy of titleblock". I'd like to delete or replace the current title block definition so only the newly added one is listed.
Sub test() Dim odrawdoc As DrawingDocument Set odrawdoc = ThisApplication.ActiveDocument If (odrawdoc.DocumentType <> kDrawingDocumentObject) Then Exit Sub Dim oTemplate As DrawingDocument Dim oSourceTitleBlockDef As TitleBlockDefinition Dim oNewTitleBlockDef As TitleBlockDefinition Dim oSheet As Sheet Set oTemplate = ThisApplication.Documents.Open(ThisApplication.FileOptions.TemplatesPath & "template.idw", False) Set oSourceTitleBlockDef = oTemplate.ActiveSheet.TitleBlock.Definition Set oNewTitleBlockDef = oSourceTitleBlockDef.CopyTo(odrawdoc) ' Iterate through the sheets. For Each oSheet In odrawdoc.Sheets oSheet.Activate oSheet.TitleBlock.Delete Call oSheet.AddTitleBlock(oNewTitleBlockDef) Next oTemplate.CloseEnd Sub
I'm just being picky at this point, but I don't want a buildup of title block definitions. We reuse drawings all the time which is why a simple method of updating a title block would be nice. I can just imagine in some years time after a title block update or two there are 20 "copy of copy of copy of .................. titleblock" listed in a drawing file.
The title blocks that we use have prompted entries in them and I would like to find a way using iLogic to copy the entries from one title block to another within the same drawing; i.e.. if the user decides to change from an A2 to A1 drawing.
I already have an iLogic rule which allows the user to change the active border, title block and sheet size based on a form selection but would like it to capture the prompted entries already entered and re-use them after the change.
Showing the “file name” on the title block,
I’m not sure if there is workaround to show the file name only WITHOUT the path. This option is avaible in the AutoCAD. have a look on the attached screenshots
How to create a excel file using ilogic?
View 6 Replies View RelatedI am looking to import an excel file to creat points within LT 2012. Can this be done?
View 4 Replies View RelatedIs 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 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...
We have a title block and border which is used in MS. If this is referenced using AMTITLE then it acts as expected. We issue these to some external people to create our drawings but they have been using CTRL-C and V to place them in a new drawing. ACAD does now not see them as a Title block or border but as blocks. We have a process to bring DWG's into SAP and this will check for a title block and border.
The issue is we need to fix these drawings and currently this means removing the borders and title blocks and placing new ones then adding all the attributes again. Is there a way to convert the blocks back to how they should be?
AutoCADM 2011 SP2
XP 32-Bit SP3
