Monday, December 1, 2014
Click the read more link to see the entire list.
Thursday, March 27, 2014
Wednesday, March 26, 2014
It can be a real pain setting up reports because the reported fields and formatting resets to default with each new report. I have seen users save a report as a template, and then insert the sheet into the project, as a way of controlling the reports format. However the following can be saved as a .set file and referenced on future reports.
- The various include/exclude report options depending on report type
- Display and grouping options
- Predefined filters in the Location/Installation fields
- Special break and header information
- Predefine the output type
- What fields are displayed and their order
- The “Put on Drawing” options like column width, text color, layer to be used ,ect.
Like most other external files in AutoCAD Electrical, these are simply text files and as such could be edited using a simple text editor. However their format can be quite confusing. The Electrical dialogs for creating/editing these files is defiantly the way to go when creating or modifying saved report formats.
Saving Report Formats
- Start here. Choose the type of report and all options on the right update.
- Review and select any report options. This area is mostly include/exclude and grouping type options.
- This section allows filtering by Installation and Location codes.
- For more information on the power of these codes see this post. INST & LOC Codes Honor Wildcards When Searching
- Options for type of report export, what fields are reported and in what order. To give an idea what what options are hidden behind the four buttons I have included screen shots of each.
- Each report type can be broken into separate tables based on various fields such as location code, manufacture name, block filename, ect.
- This is where the options selected are finally saved into a settings file. Pressing Save Format File will prompt for a filename if not yet named. Open Format File will load all selected options after opening an existing .set file. And finally Save As Format File will prompt for a new name and not overwrite the loaded .set file. The loaded .set files name is displayed in the top right corner of the Report Format File Setup dialog.
When opening settings files, only .set files for the currently selected report type are displayed. However when saving, all .set files are displayed to keep from overwriting any other setting files.
.SET File Default Location
The default location for the settings (.set) files is buried in a hidden folder under each users name.
C:\Users\swile\AppData\Roaming\Autodesk\AutoCAD Electrical 2014\R19.1\enu\Support\User\…
However this location can changed in the wd.env file on line (*WD_SET_FILES,x:/some path/,folder for report ".set" files) Remove the asterisk (*) from the front of the line and then replace the path with your own shared network path.
Referencing the Saved Report Settings
Now that a .set file has been created lets use it. Both the Schematic and Panel Reports dialogs have a Format button that allows selection of any .set file for the currently selected report type. If you are not seeing the .set file desired, double check that the correct report type is selected.
These settings files are also used with the Automatic Report Selection tool. I’ll try to cover that in a future post.
Saturday, March 1, 2014
I took a week and a half off this month. My vacation goal was to build an office desk/work bench. I had this idea in my head but really nothing on paper. I started on the Inventor model on Saturday last week and today finished the desk. I had no idea this project would involve so many people and I’m deeply grateful to all that helped. Technically this desk is not 100% complete. I have a good bit of sanding and painting on the routered grooves left to do. However I was so excited by the final results I had to share them.
Before more pictures, I would like to give a huge thank you to my parents for helping transfer and the pieces from OH to SC and for all the help assembling once it was home. Also a huge huge shout out to Dean and Wayne at Wengerd Wood for all the routing and CNC programing time.
Three sheets of 3/4 inch cherry veneer MDF coming home from the finishers. We bought the wood from Kiem Lumber but I can’t remember the name of the finisher.
Monday, February 3, 2014
There are three types of reports in AutoCAD Electrical. Schematic, Panel, and the Drawing List report.
Schematic reports only pull values from schematic symbols on the drawings in the project. Panel reports only pull values from the panel footprints. However the Panel report has an option (Full) that will include all values from ALL components. The Drawing List report uses the data stored in the project descriptions and drawing properties. Of course a few other types could be added to the list if the audits and export options were included.
All of the reports allow project wide as well as active drawing wide reporting. Project wide isn't necessarily all drawings. A separate drawing selection dialog opens to allow selection of individual drawings as needed. Most of the reports also have an option for a manual selection (pick) of components to report on.
- Note: If “Active drawing” is not available it is more than likely because the drawing is not a part of the active project. Any Project report, in this case, will be from the active project and NOT the project the active drawing is from.
Filtering by Installation or Location Code can further limit the components being reported on. This filtering is far more powerful than single values. See the blog post about wild cards to see how to include/exclude multiple values.
INST & LOC Codes Honor Wildcards When Searching
All of the report types have a Format button. Pressing this button opens a new dialog that allows the user to select a report settings (.set) file. The .set files store formatting and selection options. These are created from the Report Format Setup command.
The Report Generator shows a preview of what records will be reported and what data about each record will be included. Here header information can be added, sorting and grouping can take place, and columns can be added or removed from the table. The User Post button allows scripts to run on the data. Typically there are one or two scripts already provided under User Post for the different types of reports.
Finally either Put on Drawing or Save to File is pressed. Put on Drawing brings up a table wizard that allows control of the report table formatting. Save to File gives the following file types as exports.
Updating Existing Reports
Currently reports are not updated automatically as changes are made to the schematic. Simply rerun the report and then choose Place on Drawing. If that report was already placed somewhere in the project, the Table Generation Setup will default to Update Existing. Simply press OK and any changes will update in the existing table.
When saving the report out to a file, saving a new report export can save over the old export. (Electrical will prompt stating a file will be overwrote) Just be aware of this because any changes made to the original export will be lost as the new file completely saves over it.
I have several unique report configuration requests that will follow this post.
Friday, January 10, 2014
I’m not sure if its me being an engineer, or me being a true nerd, but for some reason I’m fascinated by the stats that can be created from a webpage. Below are a few interesting things about this blog from last year. All statistics are shown for the year 2013 only.
Total blog (not page) visits: 8,309
Directly entered web address (not referred): 29.10%
From a search engine (Bing, Google, ect): 21.87%
Mobile and tablet traffic: 4.39%
Number of new posts: 37
My official (posted) goal was 24 posts for last year. My personal goal was 52. I’m not sure if 37 is a win or not.
Most active blog post: AutoCAD Electrical 2013 New Features! (2,210 Views)
Breaking The wd.env File Down Line By Line (908 Views)
Wire From/To Annotation On the Schematic (694 Views)
Creating a custom PLC style (620 Views)
Title Block Update - Previous / Next Sheet Numbers (604 Views)
Number of new people I have personally met because this blog: 2
I hope you enjoyed this useless information. I have a series of reporting posts in the works.
Saturday, January 4, 2014
In this post we will walk through the steps needed to create something more complex. I was thinking of a block for the Rockwell Turbo-Encabulator. However Jason Moore has been waiting patiently for a Rockwell Power Flex 40 AC Drive block for over three months now. Oh well, I wasn’t sure how I was going to draw the six hydrocoptic marzlevanes anyway.
So here is our starting AutoCAD geometry (on the left). Currently it is all simple geometry and text. No blocks or attributes. It has already been broken into two halves so lets start with the top half by taking it into the Symbol Builder.
Start the Symbol Builder command. Select the geometry from for the top of the drive. I choose the left quadrant of the “R” terminal as my insertion point. That should make it easier to place into exiting wires rather than using the upper most corner of the block as the insertion point.
STOP! If your confused by this point, you need to stop reading this post and go read this one first…. The Basics Of Creating A Block I do not plan to show the basics of each dialog again in this post. Instead I want to focus on little tips and tricks that can be applied here to help make the end users job easier.
Placing The Attributes
I plan to start at the top of this block and work down. First thing is to place the needed attributes. Below you can see TAG1 and the DESC attributes have already been placed. I went into the properties palette to modify the justification of the DESC attributes. To make the MODEL NUMBER text always display the catalog number, use the Convert Text option.
However after converting the text be sure to remove the default value (See image below). Anytime text is converted the original text becomes the attributes default value. Most of the time this needs to be modified or removed. In this case I’ll remove the entire value. Also the CAT attribute is invisible by default. In this case we want it to display. Using the Properties palette toggle Invisible to No.
Next we place the wire connections. From the image on the right, you can see I placed all of the terminals on the left and then, after switching direction, placed all of the right connections.
Since these terminals all seem to have standard letters/numbers, lets make the terminals take on those as defaults. Select each terminal’s attribute in the palette and then choose Convert Text, then select the proper terminals id. This copies the location and formatting of the original text. Pretty cool!
Dynamic Clean Up
That takes us down to the DIP switches. Since this symbol will be for multiple drives, lets make these switches actually functional using a Dynamic Flip function. More than likely you have closed the Block Authoring palette by now. It can be opened again from the Block Editor tab. For the switches the Flip parameter makes the most sense. If you are unfamiliar with Dynamic Blocks a Flip is a good place to start. Simply follow the prompts. In this case the Flip Parameter is setting the mirror line for the flip/mirror. Once the Parameter has been placed, I used the move command and moved it off to the side a bit. Just be sure to not move the the Parameter up or down because doing so would change the mirror line for the Flip Action.
After placing a Parameter, its time to place an Action. Switch to the Action tab on the Block Authoring palette and choose the Flip Action. Actions always start with selecting what Parameter the Action is to be associated with. So select the Flip Parameter and then select the geometry that is to flip. Then right click to continue. Done.
Dynamic additions to bocks are so easy and add so much functionality. Do the same to the switch on the other side. Anytime your working with Dynamic Blocks, its good to test the Parameters/Actions before before leaving the Block Editor environment. There is a handy tool on the Block Editor tab that does just that. Inside the test environment, select the block to display the dynamic handles. Note the Flip arrows. If you placed the Parameters and Actions properly the switches should change position by simply clicking the Flip arrows.
To leave the test environment press the Close Test Block Window button.
Exit the Block Editor environment using the Done button on the Symbol Builder tab. Since we chose Generic as the type at the start of this process, be sure to change the Symbol name drop down to Drives. That will update the block name to DR. Also modify the Unique identifier as well. Be sure to verify, and change if necessary, the icon and symbol save paths.
Then place the symbol and verify the attributes and wire connections work as expected. On the right is my test symbol. The catalog attribute is working as well as the wire connection points.
If all is well, add the symbol to the Icon Menu.
But that’s not all. That was only the top half. Lets start the process over for the bottom half of the drive symbol. The only difference between the two pieces of this block, is setting the bottom half as a child. How you do that is easy. Simply choose the Horizontal Child attribute template before entering the Block Editor environment.
Place the attributes, wire connections, and add some more flip actions to the bottom half of the drive and we’re done. I chose the same Unique identifier keeping the two block names the same except for the fourth character. Parents fourth digit are a 1 and children are 2’s.
Place and test the child block. Link it to its parent and the relationship should be established and the parent attribute values should carry across.
I have recorded the entire process I used making these blocks and it will eventually be posted to IMAGINiT’s YouTube channel. I’ll post a direct link here as well once its up.