Academic Transcript Template Production

This documentation relies upon the following knowledge;

Please familiarise yourself with the above documentation, prior to continuing.

A letter template

A transcript template is used by the Produce Transcript (Single) form ASSF5600 and the Produce Transcript (Multiple) process ASSJ06V0 to produce transcripts of students' academic record. Transcript templates are mapped to system letters in CORF2520. To produce a transcript, the template must be held in the directory specified in control.doc. The control.doc file must be held in the c:\tmp directory. If you have macros in your normal.dot template in Word, you must replace normal.dot with the standard template.

Control.doc
Control.doc is a Word file, containing a Word Basic macro that coordinates the merging of information from Callista into the appropriate template.

Control.doc must be in the c:\tmp directory of any client machine that produces system letters.

Creating a letter template

To create a transcript template the user is required to have Word 8.0 (Word 97) or above. Create a new Word document and save it into the directory specified in control.doc, using a name of your choosing. The template must be saved in the directory prior to creating a system letter in CORF2520. For best results design your template with Word's 'Show/Hide Paragraphs' set to 'Show'. The following examples of formatting letter parameters for transcript in the template are meant as a guide only. In the following examples, letter parameters have been created with the same name as the system letter parameter they have been mapped to. Institution specific data configurations may cause significant variations in the formatting of letter parameters in transcript templates.

1. Leave a little room for Word.
The Word merge functions available to Callista have a number of irritating features. These include;

 

2. Adding letter parameters.

 

REP_UNIT

TRN_SUA_PD TRN_SUA_CD TRN_SUA_TL TRN_ACH_CP TRN_SUA_UL TRN_SUA_MK TRN_SUA_GD

REP_UNIT


The output from this would be something like the following:

 
3. Formatting one or more letter parameters on the same line.

TRN_SUA_PD / TRN_SUA_CD

The letter parameters TRN_SUA_PD and TRN_SUA_CD have been bolded. If more than one letter parameter is on the one line, or text is on the same line, then formatting has to be applied across the whole line. The above would return the following;

2/MAA102

 

4. Formatting letter parameters within a cell.

Letter parameters within cells can be formatted independently of each other.

 Note:

If there is any chance that the parameter you have selected would return no data or text, then it is important that a return is placed at the end of the parameter. This will ensure that the Word merge function does not alter the settings of the table/cell.

 

5. Formatting a letter parameter which contains data separated by tabs.

A number of letter parameters return multiple data that have tab separations between the individual data items. The size of the standard data and the amount your institution uses of the available size, will determine how to format the data.

6. A letter parameter without formatting.

 

The above parameter has no formatting, in terms of tabs set for it. The standard tabs will be used for this data. If we look at the output from this, it would be something like the following:

 

 This data could benefit from alignment of the tabs. To aid this process, it is recommended that the appropriate data is copied into the template and the parameter and the data are formatted together. Once you have the required format, the data can be deleted, leaving the parameter with the appropriate format.

 

7. Miscellaneous advice.

 

Last Modified on 9 July 1999