How do I get my Word template to print in Roof Wizard?

The software will use the default report templates created in the CAD software if no Word or Excel template exists.
​
​

This is necessary to ensure that existing operators can continue their use of the software without interruption because of a new reporting template options.
​

At any stage you may decide to use MS Word or MS Excel as your template editor and if the software finds a Word or Excel template, that template is used INSTEAD of the default CAD template.
​
Over time, we believe that the MS Word template will be the preferred option because of the greater flexibility of the design elements that it affords the user.
​

The important difference in the process is that you create a report template using Microsoft Word or Microsoft Excel that suits your needs.
You will save it as a Word template or Word document and use the default CAD template name and that will be used instead.
​

That is, QuotationDetails will be saved as QuotationDetails.DOT (Word template file) or QuotationDetails.DOC (Word document file), without spaces; QuotationLetter will be QuotationLetter.DOT etc.
​
If created in Excel they will be saved as QuotationDetails.XLT (Excel template file), or QuotationDetails.XLS (Excel spreadsheet file), These files will be saved in the …User folder for local use or the …Corporate folder for wider company use.
​
​

The exception to this is the output of supplier order forms - the CAD template is called OrderForm and is a subfigure in the RoofWiz.DAB file.
​
As such the software knows that it must process each supplier listed in the job material summary in turn, and in doing so generates a separate order form for each supplier.
​
So that the MS Word equivalent is handled the same way, the MS Word template MUST be called OrderFormTemplate.doc and reside in the ..\User folder.
​
​

NB - There is one exception to this rule – the MS Word template of the OrderForm must be called ‘OrderFormTemplate.doc’ instead of ‘OrderForm.doc’ for the automatic substitution to take place. The file name reference will still refer to ‘OrderForm’ as shown above.
​
​

The CAD template is called OrderForm and is a subfigure in the RoofWiz.DAB file. As such the software knows that it must process each supplier listed in the job material summary in turn, and in doing so generates a separate order form for each supplier.
​
So that the MS Word equivalent is handled the same way, the MS Word template MUST be called OrderFormTemplate.doc and reside in the ..\User folder.

Note: The file format must be Microsoft Office 1997 - 2003 compatible – that is, no XLTS or DOCX formats. This ensures backwards compatibility.

You can however create any other report template with any name so long as these names are listed in the text files called UserReportNames.csv and UserDrawingNames.csv as described later.

The process that the software uses with either AppliCad CAD templates or Word/Excel templates is the same – we use regular text and what we call Key Text Strings (KTS). The illustration below shows the different application of the two types of text – ‘Date’ is regular text; ‘###Date’ is a Key Text String.
​

​

You create your required template in MS Word using layout, graphics, text boxes and KeyTextStrings as required for the report you need.
​

The first thing you must do is decide what needs to be on your report. The starting point for that would be what you currently use to supply a proposal to your client. Look at the content and the layout. Consider what works now and what has been deficient in the past. Use this opportunity to revamp your proposals.
​
​

Now decide what is ‘regular text’ and type this onto your Microsoft Word/Excel document using the layout and composition functions of MS Word.
​

Next type in the Key Text String for the variable you need the software to insert when it creates the output report. There are 100’s of key text strings variables for you to use.
​

A complete list of all Key Text String options and their use is described in Section 6 of the Reference Guide installed with your software - C:AppliCadRoof WizardManual

Note that Word templates allows the use of Headers and Footers and multiple graphics files such as logo’s etc. The best layout will come after some experimentation, so try all the options that come to your mind.
It can be easily changed.
​
​

The same process with report templates is used to define the drawing templates for the various roof drawings that typically form part of the client’s proposal.
​
​

To get the roof plan (with or without dimensions) into the Word report, you must create a ‘text box’, a ‘shape’ or a ‘table’ in Word, and add the Key Text String for the required roof drawing, such as ###RoofDrawing into the shape, table or text box.
​
​

​

Important Note: As of the April 2017 Windows 10 product update, Microsoft disabled the ability to insert Encapsulated PostScript (EPS) graphics into Office documents in order to address a known vulnerability with Windows and make MS Office more secure.
​
It happens that the ###RoofDrawing uses an EPS file to get the roof plan from Roof Wizard to MS Word. Without that translator, the Roof Wizard crashes. We have a FAQ tip to re-instate the EPS translator here.
​

However, AppliCad recommends that you change your template(s) so that the EPS translator is no longer required. To do this remove ###RoofDrawing from all your templates and replace with ###RoofImage[n]. THIS IS THE BEST LONG TERM SOLUTION.
​
More details about how to take advantage of the ###RoofImage[n] are described in the next section.
​
Apart from over-coming the Windows/EPS issue, it provides a lot more flexibility to how you present your roof plan.
​

Note the use of the KTS - ###Scale.
​

Before the roof plan is inserted into the report, AppliCad creates a separate file of the roof drawing called RoofDrawing.eps (a postscript vector format print file) based on the current view of the 3D model, that is at the time you go to the Reporting > Supply and Install screen, and select [Print].
​
This is fundamentally different to the way the roof drawing is placed using the CAD report when it is generated from the CAD template.
​

Saving the Template for Re-Use
​
All the standard reports and drawings may be modified to suit the requirements of your business. This includes adding new reports using an existing template structure or to simply changing the name of a report or drawing as it appears in the list of operator options.
​
Once you have created your template, save it to the User folder (typically C:AppliCadRoof WizardUser) using a name that makes sense and is easy to find later. Now you must add it to you rlist of report options.
​
​

This is achieved by creating a translation or lookup file that defines the structure of the report/drawing and its name. There are two files – UserReportNames.csv and UserDrawingNames.csv. Being a CSV file format, they may be edited in Microsoft Excel or Notepad.
​
​

​

In the case of the Drawing Reports, the form of these is more strictly controlled and the output style is determined by the information that is automatically inserted on to the drawing report form by the software. For this reason, the drawing type must also be specified so that the required details for that drawing style are added.
​
​

​

Regular reports and drawing reports may be given any name that suits you, simply by editing the respective csv file. For example, a generic template called UserForm1 can be renamed in the table as Special Form 1 and that is the name that will appear in the list for selection for processing.
​

Renaming a standard form is simply a matter of changing the name in the UserReportName file.
​

In each situation the report or drawing template must exist either as a sub-figure in the database RoofWiz.dab (as shown in the example list above) or as a Word template or Excel document of the same name.
​
When the reporting process is run, the software looks for the Word DOC or DOT first (for example QuotationForm.doc) and if it finds a doc or template file, it runs it.
​
If no Word DOC or DOT file is found, then it looks for an Excel XLS or XLT (for example QuotationForm.xls) and finally it searches for the standard CAD form that is the sub-figure in Roofwiz.dab (for example QuotationForm).
​
​

NB - There is one exception to this rule – the MS Word template of the OrderForm must be called ‘OrderFormTemplate.doc’ instead of ‘OrderForm.doc’ for the automatic substitution to take place. The file name reference will still refer to ‘OrderForm’ as shown above.
​
​

The CAD template is called OrderForm and is a subfigure in the RoofWiz.DAB file. As such the software knows that it must process each supplier listed in the job material summary in turn, and in doing so generates a separate order form for each supplier.
​
So that the MS Word equivalent is handled the same way, the MS Word template MUST be called OrderFormTemplate.doc and reside in the ..\User folder.

TableFormats.csv
When you use a Word template with tables such as cutting lists or material lists, the format of the table should be set so that the appearance of the table and the layout of the table is controlled by the user. As highlighted below, you need to have the key text string for each table (1), the Word table appearance option (2) and the cell size for each column in the table (3).
​
​

​

How it All Works
A report template may be a Word DOC or a Word template; an Excel XLS or an Excel template.
​
If a Word/Excel document template exists in the user folder, say QuotationLetter.DOC designed by the operator to suit the needs of the business, the AppliCad software will use this template as the basis of the report instead of the default AppliCad CAD template.
​
​

When you select Print from the Supply Only dialog or Supply+Install dialog

The process pulls up the list of report options.
​
​

​
The list or reports available is on the left hand side of the box and to move the required reports to print, double click it or select it and then click the [>] arrow button.
​
​

​

Select [OK] and the process begins. Depending on the settings in the Preferences Microsoft Word will be displayed and show the form being completed and a print dialog may also displayed, providing the opportunity to select one of your network printers.
​
​