Use this export to produce files with complete data for the subscriptions in your database including order dates, statuses, payments, and so forth. This is useful if you wish to perform some type of analysis on the data that is not provided by one of the standard QuickFill reports. You might also use it if you have sold a publication to another publisher and want to send them the subscriber file.
The filter for 'Subscription Export' looks almost the same as the one for 'Customer Export', but it actually differs in a subtle way. The customer export screen is intended to select customers that subscribe to one of your publications or that are members of one of your promotional lists—it does not provide any information about the subscriptions held by those customers. The subscription export is intended to select subscriptions, although it can include the customer address as part of the subscription data.
Say that Mr. Smith subscribes to publications PUB1 and PUB2. If you run the customer export and ask for subscribers to publications for PUB1 or PUB2 you will get only one copy of Mr. Smith's address. However, if you run the subscription export and ask for subscriptions to PUB1 or PUB2, you will get two records for Mr. Smith—one for each publication.
The filter for the subscription export has several tabs. The tabs, except for the first, are the similar to those for the 'Promotional labels' 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 produce files for use with programs such as Microsoft Excel, Access or FoxPro.
Click here for the subscription export file layout.
Include customer fields
Check this box if you would like the customer fields exported.
Include extra account fields for import
Check this box if you would like to include the PASSID, WRITEOFFn and PRORATEn fields in the export file. These fields are useful when the file will be imported into another QuickFill database, but are generally not useful elsewhere.
Include audit fields
Check this box if you would like to include the audit related fields in the export file. Note that even if you do not check this box the CONTROLn, REQTYPEn and SUBCLASSn fields will still be present.
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.