When you select 'Subscription export' from the 'Other' menu, QuickFill gives you the option of using the 'Standard filter' or the 'Qualification filter'. You use the 'Qualification filter' when you want to select subscribers based on their classification, request type, qualification date, or their responses to your qualification form. Because qualification data is specific to a publication, you can only select subscribers to one publication at a time using this filter.
You use the 'Standard filter' when you want to make selections that involve multiple publications (if you want, for example, to select customers that subscribe to publication A but not to publication B).
With the exception of the first tab, the tabs of the 'Qualification filter' are very similar to those for the 'Qualified circulation' report.
Subscription types
Use these check boxes to specify the type of subscriptions (single, two-party, and group) you want to include in your export file.
For two-party and group subscriptions output
Use these check boxes to specify whether you want to include bill-to records and/or ship-to records in your export file. Normally QuickFill includes bill-to records and ship-to records. However, since each ship-to record contains subscription and order data, you may want not want to include bill-tos in your export.
Format
Right click once and select the output format you wish to use. The following formats are available:
Comma-delimited
dBASE
You can use the comma-delimited files to export data for use with a word processor for mail-merge applications. (The first record in the file created contains names of the fields in each record.)
You can use the dBASE format to for use with programs such as Microsoft Excel, Access and FoxPro..
Click here for the subscription export file layout.
Include customer fields
Leave the check mark in this field if you would like the customer fields exported or remove the check mark (by clicking on this field) if you would like the customer fields to be excluded from the export.
Include audit fields
Leave the check mark in this field if you would like the audit fields exported or remove the check mark (by clicking on this field) if you would like the audit fields to be excluded from the export. This field appears on both the 'Standard filter' and 'Qualification filter'.
Publication
Enter the publication code of the publication whose subscribers are to be selected. You may select subscribers from only one publication. To select subscribers with subscriptions to more than one publication you must use the 'Standard filter'.
Output file name
Enter in this field the name of the disk file where you want to store your output. This file name is "fully qualified." That is, you can include a disk drive and directory designation as well as a file name. You can type in the filename and/or path and filename or click on "Browse" to locate the path and/or filename you would like to use.
Example: To store your output in MYFILE.TXT in the root directory of the F-drive, enter F:\MYFILE.TXT. (If you omit the drive and directory, the file goes in the mail-merge directory.)
Maximum number of subscriptions desired
The number you enter here is the maximum number of subscription records QuickFill will produce—no matter how large your file or which selections you make. Entering a number in this field lets you export an exact number of subscriptions. Leave this field blank, and QuickFill exports records for all of your subscriptions.
Do not use this field to select a portion of the subscriptions in your database right now and then to select the rest of them at a later date. You will not be able to do this because when you go back to select those other subscriptions there is no way to distinguish whether or not a subscription was selected the first time. Use the 'Random numbers' field when you want to select a portion of the subscriptions in your database.
Click here for more information about Filter screens and Options for running exports.