Versions Compared

Key

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

Provider profile

Data managerKristen WilsonVirginia Bacon
Data manager emailkristen_wilson@ncsuvirginia.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 feedTransfer-ins: http://www.uk.sagepub.com/librarians/newjournals.sp 
KBART compliant?Y
NotesFor proprietary ID, use custom field "title.identifier.sage"

Provider packages

...

Sage_Premier_2014.txt

(Investigate loading of previous years)

...

GOKb Test Web App

GOKb Live Web App

 

Macros

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 FixesQuickly load this package using the Operation History or the individual errors

Customized Columns

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