Working with Templates

The export templates are used to both control what data is included in the export output as well as the format of that data.  Managing and running export templates is limited to users with the Administrator role.

Topics covered on this help page include:

• Adding a New Template

• • Summary Tab  (define template name, type, filename, email defaults and other summary information)

  • Record Types  (output file headers, trailers, group totals, detail lines explained)

  • Defining a Field  (define what to include and how to format each field)

  • Order Tab  (defines the order in which the selected database fields will be sorted)

• Exporting Templates

• Importing Templates

You may also be interested in:

• Export Expressions (expression syntax and examples)

• Excel Tips

Adding a New Template

From the template list, the user can click on the add icon () to create a new export template.  You must first supply the necessary information on the Summary tab (and click on Save), before moving on to specify the field layout.

Field Descriptions (click on a link below for additional information):

Template Record Types

Once you have populated the values on the Summary tab and hit save, you can then begin defining the fields (on the Fields tab) to include in the output file layout.  When creating a brand new template, you will first need to specify which record type you'd like to begin working with by selecting an appropriate Add control.

There are 5 different record types available, including:

• File Header- This is an optional record that appears only once at the top of a file. It can contain summed information, but any non-summed database fields used in it will be from the last database read. In the web browser, this record will appear at the end of the data with the text label "FILE HEADER:" (though it will be at the top of the emailed or saved file).

• Group Header -  This is an optional record that will repeat grouped by the fields it contains. In other words, when its data changes, it will be written and it will also write any detail records under it that are part of this group. It can contain summed information. It may be necessary to use hidden fields to force the correct grouping of a Group Header Record because you may not want to display all of the group by fields.

• Detail -  This is a required record that repeats as often as necessary to display it's information. It can contain summed information and can be part of a group record (Group Header or Group Trailer).

• Group Trailer

   - This is an optional record that will repeat grouped by the fields it contains. In other words, when its data changes, it will write any detail records that are part of this group and then be written out as a group footer. It can contain summed information. It may be necessary to use hidden fields to force the correct grouping of a Group Trailer Record because you may not want to display all of the group by fields.

• File Trailer - This is an optional record that appears only once at the bottom of a file. It can contain summed information, but any non-summed database fields used in it will be from the last database read. In the web browser, this record will appear at the end of the data with the text label "FILE TRAILER:".

On a new template, there are no fields specified and all 5 record type options are available.  As you add record types to your layout, the corresponding add option will no longer appear.  In most cases, you will probably begin with the Detail record type as it is required.  

Once you have included fields in your template, the Fields list tab will resemble the following.

Defining Template Fields

By using the Field List - Icon Controls, you can add, copy, delete, edit, and move fields.  When adding or editing a field, you will be presented with an entry screen that resembles the following:

Field Descriptions (click on a link below for additional information):

Order

This is the order in which the data will be sorted when retrieved for processing from the database. Because your output may have different requirements for sort order, you can specify the desired order by moving the fields up and down on the screen using the arrows.   You can move individual or groups of fields.

Only fields selected from the database are included in this list.

Do note that because you may further manipulate the output within the expression (ie substitute values using a SWITCH statement for example), this order may not reflect the final sort order of the resulting output file (as it only sorts the data when retrieved from the database).  When summing data, the sort order is critical as the summing will 'break' on changes to values within this sort order.

Exporting Templates

Once you have templates in your Unanet System, the export page allows you to export the templates either to a valid email address and/or you are given the option to save the templates to a local drive.  This can be useful if you want to share your templates with others, send them to Unanet Technical support for help in tweaking them, or to simply back them up.

The image below is an example of the Template Export page.  Note that you can choose any combination of templates to export by checking the desired checkbox.

The templates are stored in files having a .csv extension with the name of the file matching the template name itself.  The format of the file is suitable for use with the template import functionality described below.

Once you click on the export button, you are prompted with the options to save the files locally.  If you have selected more than one export template, you'll have the opportunity to download and save the files individually, or you can download and save a bulk file.  Note that both formats are compatible with the template import functionality described below.  The output screen with these options will resemble the following:

Importing Templates

The Unanet System comes with a number of built-in templates.  Custom made templates can be imported into Unanet by using the Template - Import functionality.  Browse for the file you want to import and hit the submit button and the template will be imported.   

The import screen will resemble the following:

Additional templates may be available for download from the Unanet web site (login to the Support area to see what's available).