Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Data managerTBDJennifer Solomon
Data manager email jhsolomo@ncsu.edu
Provider contact 
Provider contact emailjnls.mkt@oxfordjournals.org
Provider contact phone 
Source typeweb site
Source locationhttp://www.oxfordjournals.org/help/techinfo/linking.htmlresource/homepage_urls.xls
Update frequencyUnknown
Update methodNew list posted
Change feedhttp://www.oxfordjournals.org/help/moved/
KBART compliant? N
Notes
  • OUP issues a single file for all collections. See the special instructions below for more details on how to process this file.
  • File includes coverage dates for HTML and PDF access. The PDF access always includes more coverage, so use this to determine access dates. The HTML coverage column can be deleted.
  • File includes Open Access information. Titles with a value of "Mixed" can be marked as HybridOA. Functionality for marking titles as PureOA is coming soon.

...

  1. Use the macro found here to split the volume, number, and date information into three separate columns.
  2. Process the other error an warning messages normally, except for the package name error.
  3. Apply the following procedure to the Oxford Journals Archive Collection and Oxford Journals Collection columns:
    1. Use Edit Column>Split into Several Columns feature to separate multiple collection names. The separator is a plus sign "+".
    2. Create a text facet for each column, including the new ones you've just created.
    3. Rename each cell to the appropriate package name using the faceted values.
  4. Rearrange your columns so that all of the columns you've created are next to each other and at the right-most end of the spreadsheet.
  5. Using the menu for any one of these columns, select Transpose>Transpose columns across rows.
  6. In the "From" column, select the first of your package name columns.
  7. In the "To" column, select the last of your package name columns.
  8. Choose the radio button for "One column" and enter "package.name" as the column name. Check the "Fill down" box.
  9. Click "Transpose"
  10. This will create a new row for each title each time it appears in a different packageUse the "Transpose" feature in OpenRefine to create a line on the spreadsheet for each package that a title appears in.