Versions Compared

Old Version 4

changes.mady.by.user Kristen Wilson

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Full text of error

DateLastPackageIssue Import does not specify an DateLastPackageIssue column

Description

The publication date of the last/latest issue for a journal publication within the package. If all of DateLastPackageIssue, VolumeLastPackageIssue and NumberLastPackageIssue are blank, it is assumed that the package includes ‘up to the current issue. This column is not required, but it is highly desirable that it be added if the information is available.

Solutions

Use the KBART macro

  • Note that this macro will only work if you are beginning with a KBART formatted file.  It will also rename the other KBART standard columns.
  • Open the Rename KBART columns to GOKb columns macro.
  • Copy the code found on the page beginning with the first open bracket and ending with the last close bracket.
  • In OpenRefine, switch to the Undo/Redo tab.
  • Click "Apply" and copy the code from the wiki page into the text box.
  • Click "Perform operations."
    • Change back to the Errors tab and verify that this error has disappeared.

     Note: Many files contain this information, but it may be named something like "date_last_issue_online" or "ft_end_date". Look for columns with dates or years.

    Solutions

    Rename a column with a macro

    1.  Right-click any cell and select Apply Macro

    2. Search for the name of the package and/or provider to locate the correct macro, or search for the KBART (generic) macro.

    3. Click Ok to run the macro

    Rename a column manually

    1. Open the quick resolution menu by clicking on the wrench icon in the upper right corner of the warning message, and selecting "Quick Resolution."
    2. Choose "Rename a column."
    3. A dropdown menu will appear listing all of the columns already in your project.
    4. Choose the one that contains coverage start dates and click "rename."
    5. The warning message should disappear.

    Create a new column

    1. Open the quick resolution menu by clicking on the wrench icon in the upper right corner of the warning message, and selecting "Quick Resolution."
    2. Choose "Append a blank column."
    3. An empty column with the correct name will be appended at the right-most place in your project.
    4. You will need to manually type in dates for each title.