Regenerate Galley File (audit system only)

Each time the 'Issue labels' update is run for an audit issue, QuickFill creates a galley data file. This file is stored in the database directory. The galley data file should not be deleted; it is used by 'Publisher's Statement' report for the sections that provide breakdowns of the analyzed issue and by the 'Audit issue galley' report to produce a test selection for your auditor. In the event that the galley data file is lost or damaged, the 'Regenerate Galley File' option can be used to reconstruct it. However, any changes made to your database since the audit issue was run will be reflected in the reconstructed galley data file and it thus may not reflect a true picture of the qualification status of the subscribers at the time the issue was served. If possible, a better option than regenerating the galley file would be to back up your current database, then restore your database and galley data file back to a point before the galley data file was deleted or damaged.

When you click OK, QuickFill will create a galley data file in the database directory and will also produce a 'Create Audit Issue Galley File' report providing information about the reconstruction of the file. The galley data file's name is made up of the database name, publication code, and issue number. For example, if your audit issue for publication code WIDGET in the standard QuickFill database (that is the database files are named QFWDB*.QFDAT) was issue #144, the galley data file would be named QFWDB_WIDGET_0144.QFDAT.

Publication

Enter the publication for which you would like to re-create the galley data file. You may enter the publication code directly or right click once to select from a list of publications.

Issue

After a publication has been selected, this field will default to the number of the most recent audit issue. If you would like to create the galley data file for another audit issue, change this entry by either typing an issue number directly into the field or right clicking once to select from a list of defined issues.

Set the request type and order source from the requalification order provided the qualification date is on or before

Some publishers continue to enter requalification data after serving their analyzed issue. In order to be certain that this new data appears in the Publisher's Statement report it is necessary to regenerate the galley data file. Doing so will update the galley data file with the most recent qualification data, but the subscription classification, request type and order source codes will remain the same as they were when the issue was served. This check box specifies that the request type and order source codes should be obtained from the requalification order instead of the original order. When using this option you must also specify the date of the last day in your audit period. Request type codes from requalifications with qualification dates after that date will not be used to update the galley data file.

 

Click here for more information about Filter screens and Options for running reports.