Versions Compared

Key

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

Provider profile

Data managerTBDVirginia Bacon
Data manager emailvirginia.bacon@duke.edu 
Provider contactPatrycja Wis
Provider contact emailpatrycja.wis@sagepub.co.uk
Provider contact phone 
Source typeFTP site
Source locationAddress:  ftp.sagepub.co.uk
Folder:  sage_erm_updates
username:  erm
password:  ChuY6p
Update frequency

Monthly

Update methodNew full title lists posted
Change feed 
KBART compliant?Y
NotesFor proprietary ID, use custom field "title.identifier.sage"

...

TransformationNotes
Rename KBART columns to GOKb columns

This code renames all columns in a KBART file to GOKb equivalents except

  • first_author - there is no current GOKb equivalent to this KBART field
  • title_id - this can contain a variety of information and so there is no direct mapping to a GOKb equivalent field.
    • publisher_name - this often contains organization names that GOKb would consider imprints.
Quick fix transformationQuick fix transformation for "lastedateissued" column
Sage Premier Validation Errors and FixesQuickly load this package using the Operation History or the individual errors
Sage Humanities and Social Sciences Validation Errors and Fixes 

Customized Columns

Column NameCustomized Column Name
title_idtitle.identifier.sage
publisher_namegokb.ti.imprint

...