Label Splitter

Use the Label Splitter to change the format of any label files (issue labels, one-shot labels, promotional labels, group subscription labels, subscription agency labels and renewal labels).

To use the Label Splitter, select 'Print' from either the 'File' or the 'Reports' menu, go to the 'Labels' tab of the 'Print Saved Reports' screen, select a label file, and click on the "Label Groups" button located to the right of the label file listing. Once QuickFill displays the label groups within the file,  choose the format to be used for each label group in the 'Output Type' column. If you want to create separate files for some label groups, enter a file number (from 1 to 99) in the 'Group' column. When you are done, click on "OK" to run the label splitter.

If you requested label files, the newly split label files will appear on the Labels tab of the 'Print Saved Reports' screen with file names similar to "Issue labels—Group 1". If you requested dBase or CSV files, the files will appear on the Mail Merge tab.  If you requested 'dBase', 'dBase Audit', 'CSV' or 'CSV Audit' the files created by the Label Splitter will have file names of the form Lnnnnnnn.DBF or Lnnnnnn.CSV, where nnnnnnn is a number.  If you requested 'dBase SN', 'dBase SN Audit', 'CSV SN' or 'CSV SN Audit' the files created by the Label Splitter will have file names of the form Snnnnnnn.DBF or Snnnnnn.CSV, where nnnnnnn is a number.

Note: The 'SN' file formats

The 'SN' file formats (both dBase and CSV) contain three additional fields, TIMESTAMP, MAILERID and SERIALNUM.  These formats were added to the Label Splitter to make it easier for you to comply with USPS rule changes that where originally scheduled to go into affect Januray 26, 2014. If your Mailer ID is nine digits long, QuickFill will generate six digit serial numbers.  If your Mailer ID is six digits long QuickFill will generate nine digit serial numbers.  These two items (mailer id and serial number) should be used when generating an Intelligent Mail Barcode.  

When producing new files in one of the "SN" formats the Label Splitter will scan the "mail merge" folder and examine the existing "SN" output files.  In this way we determine what serial number to use next for each mailer ID.  The TIMESTAMP field is also used for this purpose.   

When you process ACS records (address change service) using the ACS Importer it will also scan the "mail merge" folder to find the most recent record (in an "SN" file) with the mailer id and serial number that is in the ACS record.  This allows the ACS Importer to "look up" the customer and order numbers in the "SN" files.

It is important that you do not delete or move the "SN" files from the mail merge folder too quickly. We suggest that you leave them for 6 months. If the files are not available, the Label Splitter will not properly assign the next serial number and the ACS Import will not be able to cross reference the serial numbers to find the records in QuickFill to process.

The SN file formats are only available via the Label Splitter.  The presort label files created automatically by the issue label update do not contain the three new fields.  

You do not have to use the same format for all of the label groups within a label file. For example, if you print all air mail labels in-house on pressure sensitive labels and send the rest of your labels to a mailing house, you would select 'Labels' for label groups with a ship class of "A" and one or more of the other file formats  for the rest of your label groups.

Output Type

Use this field to specify the type of file you would like QuickFill to create for a specific label group.

For systems without the audit feature the choices are 'Labels', 'dBase', 'dBase SN', 'CSV' or 'CSV SN'. dBase files, also known as DBF files, are files that are readily accepted by Microsoft Excel and by most database and postal presort software. CSV files, also known as comma delimited text files are also readable by Microsoft Excel, but sometimes result in unintended data changes. For example Microsoft Excel will drop any leading zeroes in the zip code field. It may also misinterpret the expiration dates, depending on the format you chose for the issue dates. dBase files are not subject to data changes such as these.

In systems with the audit feature, there are additional formats named 'dBase Audit',  'dBase SN Audit', 'CSV' and 'CSV SN audit'.

You should choose 'Labels' for the groups for which you want standard labels, printed directly from within QuickFill. You should choose 'dBase', 'dBase SN', 'CSV' or 'CSV SN' for the groups where you want files that you can transmit to your mail shop or can feed into postal presort packages. You should choose the 'Audit'  version of the appropriate dBase or CSV file if you need qualification data fields in the output file.

Click here for details on the label  file formats.

QuickFill suggests some choices for you for each of the groups based on the number of labels in the group. For issue and renewal label groups of less than 250 labels it assumes that you probably want printed labels since there is no cost benefit in performing a postal presort on small groups. For groups of 250 or more and for label types other than issue or renewal labels QuickFill assumes that you want dBase files. You can change the format of any group by clicking on the arrow buttons in the 'Output type' column.

Use the "Change All" button on the bottom left side of the label splitter screen to change the 'Output Type' for all of the label groups that are displayed. Each time you click the button, all of the label groups will be changed to the next available output format.

Mailer ID

Use the "Mailer ID" field on the bottom left side of the label splitter screen to supply the Mailer ID that will be used for any "SN" output files (dBase or CSV) that you have requested. The value used will be included in the Label Splitter Report.  The Mailer ID value displayed will default as follows:

Group

Use this field to control the number of output files created for your labels. This field defaults to "1" for all label groups meaning that only one output file will be created. If you would like to create separate files for each label group, change the numbers in the 'Group' column (you may use the numbers 1 to 99). If you have multiple label groups that you would like to put in the same file, simply use the same number for each of those groups.

Zone

Check this field for each label group for which you would like the 'Label splitter' report to include a periodical class zone, and county and intra-SCF reports. The label splitter produces the periodical class zone and county and intra-SCF reports based on the periodical class zone table and county and SCF table linked to a publication's definition. (Click here for more information.)

Pub

The publication code associated with the label group. This field is only displayed when analyzing issue labels, renewal labels, and promotional labels.

Bill/Renewal format

This field indicates whether or not bills and/or renewals were produced for a label group. It is only displayed when processing issue labels. The 'Bill/Ren Format' field may contain the following:

 

Bill/Renewal Format

Description

B-STD

(Standard bills were produced for this group.)

R-STD

(Standard renewals were produced for this group.)

B-MMERG1

(Mail-merge bills were produced for this group.)

R-MMERG1

(Mail-merge renewals were produced for this group.)

B-MMERG2

(Mail-merge bills were produced for this group.)

R-MMERG2

(Mail-merge renewals were produced for this group.)

B-MMERG3

(Mail-merge bills were produced for this group.)

R-MMERG3

(Mail-merge renewals were produced for this group.)

B-MMERG4

(Mail-merge bills were produced for this group.)

R-MMERG4

(Mail-merge renewals were produced for this group.)

R-LABEL

(Renewal labels were produced for this group.)

If no bills or renewals were produced for your issue label groups, this field will be blank.

Form

The 'Form' field contains the Form ID (from the billing or renewal package) for the corresponding bills or renewals. This field is only displayed when analyzing issue labels and renewal labels. If the 'Bill/Renewal Format' field (when analyzing issue labels) is blank, the 'Form' field will also be blank.

Package

The 'Package' field contains the Package code (from the billing or renewal package) for the corresponding bills or renewals. This field is only displayed when analyzing issue labels and renewal labels. If the 'Bill/Renewal Format' field (when analyzing issue labels) is blank, the 'Package' field will also be blank.

Issue

The issue number to be served to the label group. This field is only displayed when analyzing issue labels.

Premium

The premium code if the label group has premiums to be served with the issue. This field is only displayed when analyzing issue labels.

Split

The split code associated with the label group. This field is only displayed when analyzing issue labels.

Svc

The service code associated with the label group. This field is only displayed when analyzing issue labels.

Ship

The shipping code associated with the label group. This field is only displayed when analyzing issue labels.

Copies

The number of copies associated with the label group. This field is only displayed when analyzing issue labels.

Labels

The number of labels in the label group.

Label Splitter Report

Whenever the label splitter is run, QuickFill produces a 'Label splitter' report. This report contains the information from the label splitter screen (output type, publication, bill/renewal format, etc.) as well as the filename (including path information) for each file created. If your publication definition is linked to a periodical class zone table and a county and SCF table, and the 'Zone' fields were checked, the report will also include periodical class and county and intra-SCF reports. The 'Label splitter' report may be viewed and/or printed from the 'Reports' tab of the 'Print Saved Reports' screen.

 

See Also