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
Notes 

Provider Packages

Package nameFile nameAssigned toUpdate frequency
Sage: All titlesSage_SJ_All_Titles.txtKristen Wilson 
Sage: Premier

Sage_Premier_2014.txt

(Investigate loading of previous years)

Ben Heet 
Sage: Deep BackfileSage_Deep_Backfile_Package_2014.txt  
Sage: iMechE Proceedings Archiveno file available  
Sage: Cardiology & Cardiovascular Medicine CollectionSAGE_Cardiology_and_Cardiovascular_Medicine_Collection_2014.txtEric Hanson 
Sage: Communication and Media Studies CollectionSAGE_Communication_and_Media_Studies_Collection_2014.txtTessa Minchew 
Sage: Criminology CollectionSAGE_Criminology_Collection_2014.txtMatt Harrington 
Sage: Education CollectionSAGE_Education_Collection_2014.txtDavid Applegate 
Sage: Engineering and Materials Science CollectionSAGE_Materials_Science_and_Engineering_Collecti…without_I_Mech_E_2014.txtChristee PascaleFor proprietary ID, use custom field "title.identifier.sage"

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