Skip to main content
OCLC Support

Harvest Setup

  1. Last updated
  2. Save as PDF
Use the Harvest Setup settings to configure vendors in order to harvest usage data for your e-resources based on vendor in WorldShare License Manager.

Harvest set up

Supported COUNTER report types for Recurring and One-Time harvests include: 

  • COUNTER 3: JR1, JR1a, JR2, DB1, DB3
  • COUNTER 4: JR1, JR1 GOA, JR1a, JR2, JR3, JR3mobile, JR4, JR5, DB1, DB2, PR1, BR1, BR2, BR3, BR4, BR5, CR1, CR2, CR3, MR1, MR2, TR1, TR1mobile, TR2, TR3, TR3mobile
  • COUNTER 5: PR, PR_P1, IR_M1, IR Master, IR_A1, TR, TR_J1, TR_J2, TR_J3, TR_J4, TR_B1, TR_B2, TR_B3, DR, DR_D1, DR_D2

Recurring Harvest

Once a harvest is scheduled for a configured vendor, it can be accessed through the Harvest History screen. For details, see Use the Harvest History.

To schedule a recurring harvest:

  1. On the left navigation, click Usage Data.
  2. Click Harvest Setup.
  3. On the Harvest Setup screen, click the Recurring Harvest tab.
  4. From the Vendor Name list, select a vendor.
  5. The schedule and version available for the vendor are displayed.
  6. Select one or more Report Types to be harvested.
  7. Enter the Start Date of the harvest.  The system harvests the data from the date you enter until it reaches the most recent month.  From that point the system harvests based on the vendor's monthly schedule.  You can type in the date or click the calendar icon to select the date.
    • The default Start Date and End Date are set to the previous month 
  8. Select the Status:
    1. Active: On (harvests occur according to the vendor's monthly schedule).
    2. Inactive: Off (no harvesting occurs).
  9. Click Save.

One-time Harvest

Use this tab to harvest COUNTER files that have been downloaded manually from a vendor's website or transfer reports from configured vendors.  

To schedule a one-time harvest: 

  1. On the left navigation, click Usage Data.
  2. Click Harvest Setup.
  3. On the Harvest Setup screen, click the One-time Harvest tab.
  4. From the Report Source list, select a Source. Follow the instructions below based on your selection.
Manual - Transfer report file from my computer
  1. Select the vendor that published the COUNTER report you are uploading from the Vendor Name  list. This list scans the actively held collections in your knowledge base holdings and presents vendors in your collection.
  2. Select the Counter type from the drop-down.
  3. Select the Format of your file. 
    1. XML: available for all COUNTER 4 reports.
    2. Comma-delimited (CSV)
    3. Tab-delimited (TSV)
    4. EXCEL (XLS and XLSX)
  4. To upload a file, select Choose File.  Locate the file on your computer and click Open. 
  5. Click Validate.
  6. The version and report type of the file you uploaded is displayed.
  7. Enter the date range of the report into the Start Date and End Date fields, respectively.  You can type in the dates or click the calendar icons to select the date.
  8. Click Save.
SUSHI - Transfer report file from configured vendor
  1. From the Vendor Name list, select a vendor.
  2. The licensee, format, and version of the report are displayed.
  3. Select one or more Report Types to be harvested.
  4. In the Start Date field, enter the start date of the report.  You can type in the date or click the calendar icon to select the date.
  5. In the End Date field, enter the end date of the report.  You can type in the date or click the calendar icon to select the date.

     Note: The default Start Date and End Date are set to the previous month 

  6. Click Save.

Format CSV and TSV file imports

License Manager requires COUNTER-compliant formatting for COUNTER 4 and COUNTER 5 file uploads.  CSV or TSV uploads are supported for the following list of journal, collection, and book reports:

  • Journal Reports: JR1, JR1 GOA, JR1a, JR2, JR3, JR3mobile, JR4, JR5, TR_J1 (Excluding OA_Gold), TR_J2, TR_J3, and TR_J4
  • Collection Reports: DB1, DB2, and PR1
  • Book Reports: BR1, BR2, BR3, BR4, BR5, and TR_B1 (Excluding OA_Gold), TR_B2, and TR_B3
  • Multimedia Reports: MR1 and MR2 
  • Title Reports:  TR, TR1, TR1mobile, TR2, TR3, and TR3mobile
  • Platform Reports: PR_P1
  • Item Reports: IR, IR_M1, and IR_A1

Use the below information to correctly format your report before uploading or to correct a previously uploaded report that returned errors.  

Metric type requirements

Most COUNTER reports include multiple metric types in addition to a summarized period value for each month (i.e. "Reporting Period HTML" in the JR1 report).  Because monthly breakdowns only include the "Reporting Period Total" metric type values, other metric types will be discarded for spreadsheet reports containing multiple months.  If individual metric types are important to import into License Manager, this can be accomplished by downloading individual monthly reports from your publishing vendor.

lman_individual_monthly reports.png

Report-specific requirements:
  • JR5: Number of successful full-text article requests by year of publication.
    • Because this report does not detail the data results by month of access, License Manager requires "Period covered by Report" values to be no greater than one month for JR5 reports.  This allows License Manager to combine and summarize monthly reports across different time periods.
    • In the image below, cell A5 can be no greater than one month:

      lman_J5_example.png

  • TR1: Number of successful requests for journal full-text articles and book sections by month and title.
    • Because this report includes a date header that differs from all other reports, License Manager has elected to require date headers in the same format as other reports (aside from the JR5).
    • It may be required that you reformat your date headers from (as an example) "Total MMM-YY" to the standardized "MMM-YYYY".  In other words, "Jan-2011" instead of "Total Jan-11".