Label Split Table

Label split tables are used to define groups of issue labels that must be broken out and printed separately from the main body of issue labels. Click here for an overview of label split tables.

Defining label split tables

When you select 'Label splits' under 'Definitions' on the main menu, and then select 'Split Table', you'll see one of two screens. If you select 'Split Table' for the first time after installing QuickFill, you'll see a screen with a blank form for defining the label split table.

If you've already defined some label split tables, you'll see a list of them in the upper portion of the screen and "New," "Change," "Replicate," and "Delete" buttons running along the bottom.

If you haven't yet defined any label split tables, enter a description, fill in the blank form (as described below), and click on "OK" to save your changes.

You can define another label split table by clicking on "New," filling in the fields described below, and then clicking on "OK." If the label split table you want to define next is similar to one you've already defined, you can replicate the existing table by moving the cursor to it and clicking on "Replicate."

Five special buttons are available when filling in the rows of the issue label split table. The "Move Up" and "Move Down" buttons allow you to change the position of a row in the table by moving it up or down respectively. The "Insert Row" button inserts a blank row above the position of the cursor. The "Delete Row" button deletes the row that the cursor is on and moves the remaining rows up. The "Add Row" button adds a row to the end of the split table.

You link label split tables to a publication's definition. (Click here for details on the 'Label group split table' field. ) In most cases you will define a separate split table for each publication. Sometimes you may have similar issue label requirements for several publications, in which case you can link the same split table to each publication.

Description

Enter a brief description of your table—for example, "Label splits for weekly newsletters". This description will be displayed on the table selection list that appears on the publication definition issue labels tab when you right click and select "pick split table" in the 'Label split table' field.

Split rows

The split rows section displays the split codes that are being used in the table so far with the criteria for each row. (Note: you can have as many rows in a split table as you like.)

After you use the "F2" key or your mouse to select codes from a list, the field in the row you were editing is left in "non-edit" mode. Once you move to the next field, you will be switched back to the normal editing mode.

 

Each split row contains the following fields (use the scroll bars on the bottom of the screen to access fields beyond view):

Split Code

You can type the split code you want to use in this field or select it from a list of split codes you've already defined by left clicking on the arrow to the right of the field or pressing "F2." (Click here for information on label split codes.)

File

Enter a number (from 1 to 99) and QuickFill will place this group of labels into a separate file. To place several label groups into the same file use the same file number for each group. To place each group of labels into a separate file use a different file number for each group. If you do not enter a file number, QuickFill will place the labels in the main label file.

Svc Code

Enter a service code and QuickFill will place an issue label in this group if the current order was entered with that service code. To select from a list of service codes, left click on the arrow to the right of the field or press "F2." You may use wild cards in this field to select groups of service codes. (Click here for details on using wild cards.)

Sort

Enter "N" in this field if you do NOT want the labels in this group to be sorted by service code. If you want QuickFill to sort the issue labels (that are going to be split out) by service code, leave this field blank.

Normally QuickFill will sort your main label file by service code. If you want to suppress this sort, you should add a line to your split table that contains blanks in all of the fields except the 'Split code' field and this field. This line should be the last line in your split table. All of the labels that QuickFill did not split out for other reasons will match this last line and they will not be sorted by service code.

IssRem Low
IssRem High

Enter a range and QuickFill will place an issue label in this group if the number of issues remaining in the subscription (before serving the current issue) falls within that range. You can select grace issues by using a value of zero or less. Say that you allow two grace issues. To split off the labels for those two grace issues you would enter a range of 0 to -1.

Issues Served

Enter a value and QuickFill will place an issue label in this group if the number of issues served (prior to serving the current issue) from an order matches that value. Use this for splitting out the first issue of an order by entering a value of zero.

Term

Enter a value and QuickFill will place an issue label in this group if the current order has a term that matches that value. Use this for splitting out the issue labels of short-term trial subscribers.

Gift

Enter "Y" in this field and QuickFill will place an issue label in this group if the subscription is a gift subscription. Enter "N" in this field and QuickFill will place an issue label in this group if the subscription is not a gift subscription. Leave this field blank and QuickFill will place an issue label in this group regardless of whether the subscription is a gift subscription.

Comp

Enter "Y" in this field and QuickFill will place an issue label in this group if the subscription is a complimentary subscription. Enter "N" in this field and QuickFill will place an issue label in this group if the subscription is not a complimentary subscription. Leave this field blank and QuickFill will place an issue label in this group regardless of whether the subscription is a complimentary subscription.

Paid

Enter "F" this field and QuickFill will place an issue label in this group if the subscription is free. Enter "P" in this field and QuickFill will place an issue label in this group if the subscription is not free and has been paid. Enter "N" in this field and QuickFill will place an issue label in this group if the subscription is not free and has not been paid. Leave this field blank and QuickFill will place an issue label in this regardless of whether the subscription is free or paid.

Sub Type

Enter "S" in this field and QuickFill will place an issue label in this group if the subscription is a single subscription. Enter "2" in this field and QuickFill will place an issue label in this group if the subscription is a two-party subscription. Enter "G" in this field and QuickFill will place an issue label in this group if the subscription is a group subscription. Leave this field blank and QuickFill will place an issue label in this regardless of whether the subscription is a single, two-party, or group subscription.

New
Ren

Enter "N" in this field and QuickFill will place an issue label in this group if the active order in the subscription is a new order. Enter "R" in this field and QuickFill will place an issue label in this group if the active order in the subscription is a renewal order. Leave this field blank and QuickFill will place an issue label in this group regardless of whether the active order in the subscription is a new or renewal order.

Country Code

Enter a country code and QuickFill will place an issue label in this group if the country on the label matches the code you enter. To select from a list of shipping codes, left click on the arrow to the right of this field or press "F2.". (Enter "USA" if you would like to select labels for customers with addresses in the United States of America. Enter "CAN" if you would like to select labels for customers with Canadian addresses.)

Zip Low
Zip High

Enter a postal/zip code range and QuickFill will place an issue label in this group if the postal or zip code on the label falls within that range.

Tracking Code

Enter a tracking code and QuickFill will place an issue label in this group if the tracking code of the subscription matches the code you enter. To select from a list of tracking codes, left click on the arrow to the right of this field or press "F2." You may use wild cards in this field to select groups of tracking codes. (Click here for details on using wild cards.)

QuickFill can display up to 500 tracking codes when using the selection list for this field. If you have more than 500 tracking codes defined in your database, you should verify the tracking codes you want to use via the 'Tracking codes' definition screen so that you can enter them in the 'Tracking code' field on the 'Split tables' screen.

Order source

Enter an order source code and QuickFill will place an issue label in this group if the order source for the current order matches the code you enter.  This field only applies to current orders.  To select from a list of renewal effort codes, left click on the arrow to the right of this field or press "F2." (Please note that you should use the tracking code field to specify order sources for new orders.)

You may use wild cards in this field to select groups of renewal effort codes. (Click here for details on using wild cards.)

Billing Series

Enter a billing series code and QuickFill will place an issue label in this group if the billing series code of the order matches the code you enter. To select from a list of billing series codes, left click on the arrow to the right of this field or press "F2." You may use wild cards in this field to select groups of billing series codes. (Click here for details on using wild cards.)

Renewal Series

Enter a renewal series code and QuickFill will place an issue label in this group if the renewal series code of the order matches the code you enter. To select from a list of renewal series codes, left click on the arrow to the right of this field or press "F2." You may use wild cards in this field to select groups of renewal series codes. (Click here for details on using wild cards.)

Ship Class

Left click on the arrow to the right of this field or press "F2" to select a shipping class from a list of codes. QuickFill will place an issue label in this group if it is to be mailed using the chosen shipping class. If you place more than one shipping class in a single file, QuickFill will sort that file by shipping class.

Copies Low
Copies High

Enter a range and QuickFill will place an issue label in this group if the number of copies to be mailed falls within that range. QuickFill will sort the labels in the group by the number of copies to be mailed.

Selection flags

Use this column to select customers based on their selection flags. The selection flags are represented as a string of digits from 1 through 8 with an optional single character prefix. If there is no prefix, then the record will match if any of the specified selection flags are set. If there is a plus sign (+) prefix, then the record will match if all of the specified selection flags are set. If there is an equals sign (=) prefix, then the record will match if all of the specified selection flags are set and no others.

Examples:
135 matches if any of flags 1, 3 and 5 are set.
+135 matches if flags 1, 3 and 5 are all set.
=135 matches if flags 1, 3 and 5 are set and 2, 4, 6, 7 and 8 are not set.
= (with no digits) matches if no flags are set.

Random Low
Random High

Enter a range and QuickFill will place an issue label in this group if the customer's random number falls within that range.

Age Low (audit system field)
Age High (audit system field)

Enter a range of months, and QuickFill will place an issue label in this group if the age of the qualification data of the subscriber falls within that range. Use this to put requalification wrappers on the issues of subscribers prior to their first and second anniversary dates.

If you would like your label splits to include customers with a qualification date that is less than one month old (meaning the qualification date falls within the same month as the calendar date for the current issue), you should start your range with the number zero.

Sub Class (audit system field)

Left click on the arrow to the right of this field or press "F2" to select a subscription class from a list of classification codes. QuickFill will place an issue label in this group if the subscription class matches the specified code. Special codes with wildcards are available for selecting common groups of classifications such as 'P*' for "paid" or 'NQ*' for "nonqualified". You will find these special codes on the selection list for this field.

Request Type (audit system field)

Left click on the arrow to the right of this field or press "F2" to select a request type from a list of request type codes. QuickFill will place an issue label in this group if the request type matches the specified code. Special codes with wild cards are available for selecting common groups of request types such as 'PD*' for "Personal direct" or 'M*' for "membership." You will find these special codes on the selection list for this field.

 

You can also change the definition of a label split table by moving the cursor to it and double clicking on it, or clicking on "Change." You may change a label split table definition at any time prior to running the issue label update. In fact, if you have special editions whose composition changes from one issue to the next, you will need to change the label split table prior to serving each issue.

You can delete a label split table that is not being used by moving to it and clicking on "Delete."

Copying rows in a split table

You can cut or copy rows from a split table and then paste them into a different spot on the same table, to another table (in the same database or in a different database), or to another application. To select and cut or copy rows, left click in the column to the left of the split code for the first row you want to select, hold down the mouse button, drag the mouse to select additional rows, and then use the "cut" or "copy" command (you can either use the toolbar buttons or combination keys, CTRL-X and CTRL-C). The rows that were selected will be stored on your computer's clipboard in a tab-delimited format. You can then go to the split table or application to which you want to add the rows and use the "paste" command (again, you can either use the toolbar button or combination keys, CTRL-V). The rows will be inserted above the cursor so be sure to move the cursor to the desired spot before using the "paste" command.

 

See Also