Draw Forecast Export

This option exports a draw forecast file to be used by an external forecasting application. The export is for a specified time period and uses file mapping (“DrwForecastExprt” usage). The export file includes single copy draw, returns, and draw adjustments for a selected product and date range. Past and future draw dates can be included in the file.

Note: This option exports only single copy draw. Home delivery draw is not included. Also, only replacement draw is exported. This export does not create additions and subtractions.

To export a draw forecast:

  1. Select Draw Forecast from the Utilities | Export menu to display the Draw Forecast Export window.

  2. Click Add and complete the following fields.

    Field
    Type
    What to enter

    PRODUCT

    setup

    Specify the publication whose draw, returns and draw adjustments should be exported.

    START DATE END DATE

    date

    Enter the date range for which to export the information.

    ROUTE TYPE

    setup

    Select the type of route to include in the export: home delivery, single copy, or both.

    DRAW TYPE

    predefined

    Select Advance, Pending, or Actual draw.

    PROJECT ACTUAL DRAW WHEN NO DRAW FOUND

    yes/no

    When no pending or advance draw exists for a given weekday, actual draw can be used instead. For example, if you are running advance draw for a week, but advance draw exists for only one day, select this checkbox if the remaining days should be populated with actual draw.

    EXPORT DAYS WITH NO DRAW

    yes/no

    When this checkbox is selected, data will be exported for all days selected, in order to keep the format of the export file consistent each time it is run. If this option is not selected, only days with draw will be exported, and it will be possible for the number of days to vary among exported records.

    EXPORT CHANGED DRAW ONLY

    yes/no

    When this checkbox is selected, only those days of the week with draw that differs from the previous week will be exported. For example, if Wednesday’s draw is the same as it was last week, it will not be exported. If this option is not selected, all draw will be exported.

    DRAW OPTION

    predefined

    This field is available only when Export Changed Draw Only (above) is selected. Indicate whether All Dates In Range or Changed Dates Only should be exported. For example, if the export is run for one week, and only one day’s draw differs from the previous week, you have the option to export only that date or all dates in the entered date range.

    EXPORT BY DRAW CLASS?

    yes/no

    Indicate whether draw, returns, and draw adjustments should be sorted by draw class in the export file.

    EXPORT BY DELIVERY SCHEDULE ID?

    yes/no

    Indicate whether draw, returns, and draw adjustments should be sorted by Subscriber’s delivery schedule in the export file.

    FILE FORMAT

    setup

    Select a file format to use (set up using File Map).

    FILE NAME

    open (20)

    Enter the name of the file to be exported.

    FILE OPTION

    predefined

    Select append to add new figures to an existing file or replace to replace an existing file.

    TRUCK SEQUENCE

    setup

    If the selected file map (File Format field) contains the truck ID element, specify the truck sequence ID to use in this export.

  3. Click OK and then Continue to run the export. The file will be exported to the default exchange directory. A processing report will list the number of records exported and any errors that occurred during the process.

Last updated