Recipient list
To send letters using WorkZone Mass Dispatch, you must create a recipient list. Each contact in the list will receive the letter.
The recipient list is a Microsoft Excel workbook with a mandatory set of two sheets describing the recipients: a schema sheet and a data sheet.
- Contacts.Schema—required name of the schema sheet. This sheet contains system information on the aliases specified in the data sheet or taken from the WorkZone database. The A1 cell must refer to the name of the data sheet.
- Contacts—the data sheet that you can name as you like. In the example below, it is named Recipients. The information from this sheet populates the letter template after you start the mass dispatch.
If you want to save dispatched letters on individual cases per recipient, you can add another set of schema and data sheet to the Excel workbook:
- Files.Schema—required name of the schema sheet. This declares the relation of cases and recipients for the mass dispatch, and contains system information on the aliases specified in the data sheet or taken from the WorkZone database. The A1 cell must refer to the name of the data sheet.
- Cases—you can name the data sheet as you like. This sheet contains the cases on which the dispatched letters will be saved.
The recipient cases can either be existing cases that you specify in the recipient list or new cases that are created based on a case template and information that you specify in the Start mass dispatch dialog box. See Start a mass dispatch ( steps 10-11).
Contacts.Schema sheet
All strings on the Contacts.Schema tab are case-sensitive, except Type.
The A1 cell refers to the name of the Contacts sheet. WorkZone Mass Dispatch requires a fixed structure of the recipient list to be able to process it, so you must define fields in this sheet as described in the table below.
Field name | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Alias |
The field name used on the Contacts tab and in letter templates. |
||||||||||||||||
ServerPath |
The path to the field values in WorkZone Content Server. If this field is empty, the information will be pulled not from the WorkZone Content Server but from the Contacts sheet. Tip: You can use WorkZone QueryBuilder to view available fields and their paths.
|
||||||||||||||||
Type |
This field is not case-sensitive. Enter one of these types:
|
||||||||||||||||
Constraint |
Enter Required if the field values cannot be empty. Enter ServerKey in the field that will be used as key. |
Contacts sheet
This Contacts sheet contains the WorkZone contacts that will receive the letters using WorkZone Mass Dispatch and the information regarding these contacts. In this sheet, columns represent the fields that are defined on the Contacts.Schema sheet, and rows represent values.
Files.Schema sheet
The Files.Schema sheet is used to define the relation between cases and mass dispatch recipients.
The A1 cell refers to the name of the data sheet (in our example, Cases sheet). WorkZone Mass Dispatch requires a fixed structure of the fields to be able to process them, so you must define fields in this sheet as described in the table below.
Field name | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Alias |
The field name used on the Cases sheet. |
||||||||||||||||
ServerPath |
The path to the field values in WorkZone Content Server. Tip: You can use WorkZone QueryBuilder to view available fields and their paths.
|
||||||||||||||||
Type |
This field is not case-sensitive. Enter one of these types:
|
||||||||||||||||
Constraint |
Enter ServerKey in the field that will be used as a Contact key. Enter ForeignKey in the field that points out the existing cases. In the example above, the cases with the numbers filled in the CaseNo. field on the Cases sheet will be used to store the documents that are sent. Fields with no constraints are used to create the new cases. |
Cases sheet
The Cases sheet is a data sheet that contains the information that is required to find or create cases where the sent letters will be saved. The Cases sheet can only contain recipients that are also on the Contacts sheet.
In the Cases sheet, columns represent the fields that are defined on the File.Schema sheet, and rows represent values. The dispatched letters will be saved on the existing cases that are specified for the recipients. If a case number is not specified, a letter will be saved on a new case or on the dispatch case depending on the information that you specify in the Start mass dispatch dialog box. See Start a mass dispatch (step 10).
If a recipient is specified on the Contacts sheet but is not on the Cases sheet, a new case for such recipient will be created if the Create recipient cases check box is selected in the Start mass dispatch dialog box. See Start a mass dispatch (step 10).
Validation
To ensure a successful mass dispatch, the following requirements to the recipient list must be met:
- All fields are strictly aligned between the schema and data sheets. For example, all fields in the Contacts.Schema sheet must be present in the Contacts sheet, and all fields in Contacts sheet must be defined in the Contacts.Schema sheet.
- Alias and type must be filled in for each field.
- Each field has a unique alias and a unique server path.
- Server paths only contain letters, numbers, underscores, and slashes.
- Only one field is defined as ServerKey. Mind that the key values must be unique in WorkZone.
- If there is a defined ServerKey in the Cases data sheet, then it should correspond to the ServerKey in the Contacts data sheet.