Skip to main content

OAPEN Update

1. Overview and Context

This procedure updates the PROJECT_MUSE2OAPEN2 table in the SQL Database.

2. Triggers

The execution of this procedure is usually triggered by

3. Steps to Be Performed

3.1 Download

Somewhere halfway each month, MuseOAPEN-Dashboard generatesprovides thea usage datadownload for theall previous month. They can be downloadedcountries in theCSV backend.format.

    Click "Reports an Statistics – Usage Statistics" in the top menu. Click "Run Statistics," then "Data Export." Enter the pertinent year, month, select "country" "institution," and "CSV," then click "Submit."

    3.2 Clean

    Project

    MUSEWhen deliversimporting CSVswitch files,off butspace/semicolon theyas don'tdelimiter containDelete proper date column. Also, commas inside editorall columns createfrom errorsH inup displayingto present month Delete the CSV.Funders
      Open in LibreOffice (make sure to set encoding to UTF-8)
      column Append 1Reformat column G to the left, add date in YYYY-MM-01 format
      Delete column P "punctum books" Delete table header Check all rows have proper column count (because of comma issue)

      3.3 Upload

      • Upload into phpMyAdmin table "PROJECT_MUSE2"OAPEN2"

      4. Additional Information

      5. Document Control

      Document ID PRO-037038
      Document Owner Vincent
      Version 1.0
      Last Date of Change March 26, 2026
      Next Review Due Date
      Version & Change Tracking
      Back to top