Subtitles of the Movie

Let's have a look now at saving our reports to external files outside of AutoCAD. Now, the first thing I'm going to do is I'm going to make sure that my current drawing, Saving Reports to Files, is part of my current project. So it's a right click, Add Active Drawing, Yes to that and it comes up as 05SavingReportstoFiles.dwg. So there's my current drawing there. Now, as before in all these other exercises, we're going to go to the Reports Icon in the Panel Panel on the Reports Tab on the Ribbon. Click on Reports. I'm going to stick with the Component Exception Report. I'm going to use Project as the exception there for the Panel and I'm going to switch on all of my conditions. Installation Codes, All, Location Codes, All. Formats, I'll go for the last table that I generated and I'll OK that. I then click on OK here. There's my five drawings in my project. I want to do all of them. So it drops them into the Drawings to Process Panel here. I OK that now. There's all the schematic components not on panel. I go to Display Report Formats. Now, I'm going to add all of the information here. Now before I do that, let me just do an Alt Tab. There's the current Excel Format 1 Spreadsheet that I've generated from this drawing so what I'm going to do here is I'm going to do a little bit of editing on the format. So let's go back to AutoCAD and I'm going to change the report format and I'm going to add a load more fields. Let's add that one, let's add that one. So they've been added so I'll OK that now. And what I'll do there, make sure the Time and Date is in there, Project Lines and Column Tables. So that's all been added and there's the HDL and the SH Numbers there. So that's all in place. Now, I want to save this to a file so what I'm going to do now is click on Save to File here and it gives me the option. I actually have five file types that I can save to: ASCII, Report Output; that's what's shown here. That's all this information here. I don't want that one. What I want is an Excel Spreadsheet and I also want to include the Project Line X Values. I can also consider an Access Database Format, which obviously would go into an Access Database, XML that you could put onto a web page or CSV, it' Common Delimited Format; again, something you could put into Excel. The XML format is useful if you're running an Intranet within your company. You could perhaps bring that up on an Intranet or an Extranet page for project collaboration, for example. I'm going to stick with my Excel Spreadsheet Format and OK it. It asks me where do I want to save that. So if I scroll down here, you'll see that I've got an ACAD E 2010 Folder. That is installed by default in your documents folder when you install AutoCAD Electrical. Underneath that you've got AutoCAD Electrical data and there's all my project folders there: Proj, Project. There's Schematic Reports and there's my Excel Spreadsheets there. Now what I'm going to do is I'm actually going to overwrite Excel Format 2 and Save and it says that already exists. Do you want to replace it? Yes, I do so I hit Yes there. I'm not going to run any scripts. I'm going to close the No Scripts there and then I'm going to close here. So that has now added that. So if I now go Alt and Tab here and go there and go Open, you'll see there's my Excel Format 2. If I open that one up, you can see look. There's my HDL SH and I'll I've got to do using Excel, just make these a little bit bigger, a bit smaller, just get them all to auto fit and you can see the information there. So you can see there that I've exported out as an Excel Spreadsheet. I could also export it to a database, a web page and so on. Let's pop back to AutoCAD Electrical and as you can see there, I don't have a report on my drawing but there's nothing to stop me now from hitting Report and I'll do the format there that I used previously and OK that. I'll OK it there, I'll do All and I'll OK that there. Display Report Formats, I want to put that on the drawing so I hit Put on Drawing, I OK that there and as you can see, it hasn't appeared because I've already exported it out but if I run that again and select Format and select that one there and OK it, will it put it on the drawing for me? Let's have a look and see. I'll do a Do All and OK that, Report Format there, I'll add that, that and that like I've done before and I'll put it on the drawing and I'll OK that. Nothing comes up again because you've already exported the file out to another location. So that's how you generated your reports and save your reports to separate external files, external to AutoCAD and AutoCAD Electrical.