Versions Compared

Old Version 15

changes.mady.by.user Eric Hanson

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.

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

Package nameFile nameAssigned toUpdate frequency
 

 

Communication_Studies_A_SAGE_Full_Text_Collection.txt		  
 Criminology_A_SAGE_Full_Text_Collection.txt  
 Education_Full_A_SAGE_Text_Collection.txt  
 Health_Sciences_A_SAGE_Full_Text_Collection.txt  
 Management_and_Organization_Studies_A_SAGE_Full_Text_Collection.txt  
 Materials_Science_A_SAGE_Full_Text_Collection.txt  
 Political_Science_A_SAGE_Full_Text_Collection.txt  
 Psychology_A_SAGE_Full_Text_Collection.txt  
Sage: Cardiology and Cardiovascular Medicine Collection 2013SAGE_Cardiology_and_Cardiovascular_Medicine_Collection_2013.txtEric Hanson 
Sage: Cardiology and Cardiovascular Medicine Collection 2014
SAGE_Cardiology_and_Cardiovascular_Medicine_Collection_2014.txtEric Hanson 
 SAGE_Cardiology_and_Cardiovascular_Medicine_Collection_Backfile_2014.txtEric Hanson 
 SAGE_Clinical_Medicine_Package_2007.txt  
 SAGE_Clinical_Medicine_Package_2008.txt  
 SAGE_Clinical_Medicine_Package_2009.txt  
 SAGE_Clinical_Medicine_Package_2010.txt  
 SAGE_Clinical_Medicine_Package_2011.txt  
 SAGE_Clinical_Medicine_Package_2012.txt  
 SAGE_Clinical_Medicine_Package_2013.txt  
 SAGE_Clinical_Medicine_Package_2014.txt  
 SAGE_Collection_Plus_2014.txt  
 SAGE_Communication_and_Media_Studies_Collection_2013.txtEric Hanson 
Sage: Communication and Media Studies Collection 2014SAGE_Communication_and_Media_Studies_Collection_2014.txtEric Hanson 
 SAGE_Communication_and_Media_Studies_Collection_Backfile_2014.txtEric Hanson 
 SAGE_Criminology_Collection_2013.txtMatt Harrington 
Sage: Criminology Collection 2014SAGE_Criminology_Collection_2014.txtMatt Harrington 
 SAGE_Criminology_Collection_Backfile_2014.txtMatt Harrington 
 SAGE_Deep_Backfile_Clinical_Medicine_2012.txt  
 SAGE_Deep_Backfile_Clinical_Medicine_2013.txt  
 SAGE_Deep_Backfile_Clinical_Medicine_2014.txt  
 SAGE_Deep_Backfile_Health_Sciences_Package_2012.txt  
 SAGE_Deep_Backfile_Health_Sciences_Package_2013.txt  
 SAGE_Deep_Backfile_Health_Sciences_Package_2014.txt  
 SAGE_Deep_Backfile_HSS_2007.txt  
 SAGE_Deep_Backfile_HSS_2008.txt  
 SAGE_Deep_Backfile_HSS_2009.txt  
 SAGE_Deep_Backfile_HSS_2010.txt  
 SAGE_Deep_Backfile_HSS_2011.txt  
 SAGE_Deep_Backfile_HSS_2012.txt  
 SAGE_Deep_Backfile_HSS_2013.txt  
 SAGE_Deep_Backfile_HSS_2014.txt  
 SAGE_Deep_Backfile_Package_2007.txt  
 SAGE_Deep_Backfile_Package_2008.txt  
 SAGE_Deep_Backfile_Package_2009.txt  
 SAGE_Deep_Backfile_Package_2010.txt  
 SAGE_Deep_Backfile_Package_2011.txt  
 SAGE_Deep_Backfile_Package_2012.txt  
 SAGE_Deep_Backfile_Package_2013.txt  
 SAGE_Deep_Backfile_Package_2014.txt  
 SAGE_Deep_Backfile_STM_2007.txt  
 SAGE_Deep_Backfile_STM_2008.txt  
 SAGE_Deep_Backfile_STM_2009.txt  
 SAGE_Deep_Backfile_STM_2010.txt  
 SAGE_Deep_Backfile_STM_2011.txt  
 SAGE_Deep_Backfile_STM_2012.txt  
 SAGE_Deep_Backfile_STM_2013.txt  
 SAGE_Deep_Backfile_STM_2014.txt  
 SAGE_Deep_Backfile_Upgrade_Package_2008.txt  
 SAGE_Deep_Backfile_Upgrade_Package_2009.txt  
 SAGE_Deep_Backfile_Upgrade_Package_2010.txt  
 SAGE_Deep_Backfile_Upgrade_Package_2011.txt  
 SAGE_Deep_Backfile_Upgrade_Package_2012.txt  
 SAGE_Deep_Backfile_Upgrade_Package_2013.txt  
 SAGE_Deep_Backfile_Upgrade_Package_2014.txt  
 SAGE_Education_Collection_2013.txtMatt Harrington 
Sage: Education Collection 2014SAGE_Education_Collection_2014.txtMatt Harrington 
 SAGE_Education_Collection_Backfile_2014.txtMatt Harrington 
Sage: Health Practice and Services Collection 2014SAGE_Health_Practice_and_Services_Collection_2014.txtChristee Pascale 
 SAGE_Health_Practice_and_Services_Collection_Backfile_2014.txtChristee Pascale 
 SAGE_Health_Sciences_Package_2007.txt  
 SAGE_Health_Sciences_Package_2008.txt  
 SAGE_Health_Sciences_Package_2009.txt  
 SAGE_Health_Sciences_Package_2010.txt  
 SAGE_Health_Sciences_Package_2011.txt  
 SAGE_Health_Sciences_Package_2012.txt  
 SAGE_Health_Sciences_Package_2013.txt  
 SAGE_Health_Sciences_Package_2014.txt  
 SAGE_Health_Sciences_Package_without_RSM_2014.txt  
 SAGE_HR_Package_2014.txt  
 SAGE_HR_Package_Backfile_2014.txt  
 SAGE_HSS_Backfile_Upgrade_Package_2008.txt  
 SAGE_HSS_Backfile_Upgrade_Package_2009.txt  
 SAGE_HSS_Backfile_Upgrade_Package_2010.txt  
 SAGE_HSS_Backfile_Upgrade_Package_2011.txt  
 SAGE_HSS_Backfile_Upgrade_Package_2012.txt  
 SAGE_HSS_Backfile_Upgrade_Package_2013.txt  
 SAGE_HSS_Backfile_Upgrade_Package_2014.txt  
 SAGE_Humanities_and_Social_Science_Package_2007.txt  
 SAGE_Humanities_and_Social_Science_Package_2008.txt  
 SAGE_Humanities_and_Social_Science_Package_2009.txt  
 SAGE_Humanities_and_Social_Science_Package_2010.txt  
 SAGE_Humanities_and_Social_Science_Package_2011.txt  
 SAGE_Humanities_and_Social_Science_Package_2012.txt  
 SAGE_Humanities_and_Social_Science_Package_2013.txt  
 SAGE_Humanities_and_Social_Science_Package_2014.txt  
 SAGE_Management_and_Organization_Studies_Collection_2013.txtTessa Minchew 
Sage: Management and Organization Studies Collection 2014SAGE_Management_and_Organization_Studies_Collection_2014.txtTessa Minchew 
 SAGE_Management_and_Organization_Studies_Collection_Backfile_2014.txtTessa Minchew 
Sage: Materials Science and Engineering Collection 2014SAGE_Materials_Science_and_Engineering_Collection_without_I_Mech_E_2014.txtChristee Pascale 
Sage: Medico-Legal Collection 2014SAGE_Medico-Legal_Collection_2014.txtDavid Applegate 
 SAGE_Medico-Legal_Collection_Backfile_2014.txtDavid Applegate 
Sage: Mental Health Collection 2014SAGE_Mental_Health_Collection_2014.txtDavid Applegate 
 SAGE_Mental_Health_Collection_Backfile_2014.txtDavid Applegate 
 SAGE_Neurology_Collection_2014.txtMaria Collins 
 SAGE_Neurology_Collection_Backfile_2014.txtMaria Collins 
 SAGE_Nursing_and_Health_Sciences_Collection_Backfile_2014.txtYan Song 
 SAGE_Nursing_and_Public_Health_Collection_2013.txtYan Song 
Sage: Nursing and Public Health Collection 2014SAGE_Nursing_and_Public_Health_Collection_2014.txtYan Song 
 SAGE_Oncology_Collection_2013.txtYan Song 
Sage: Oncology Collection 2014SAGE_Oncology_Collection_2014.txtYan Song 
 SAGE_Oncology_Collection_Backfile_2014.txtYan Song 
 SAGE_Orthopaedics_and_Sports_Medicine_Collection_2013.txtKristen Wilson 
Sage: Orthopaedics and Sports Medicine Collection 2014SAGE_Orthopaedics_and_Sports_Medicine_Collection_2014.txtKristen Wilson 
 SAGE_Orthopaedics_and_Sports_Medicine_Collection_Backfile_2014.txtKristen Wilson 
 SAGE_Palliative_Medicine_and_Chronic_Care_Collection_2013.txt  
 SAGE_Palliative_Medicine_and_Chronic_Care_Collection_2014.txt  
 SAGE_Palliative_Medicine_and_Chronic_Care_Collection_Backfile_2014.txt  
 SAGE_Pediatrics_Collection_2013.txt  
 SAGE_Pediatrics_Collection_2014.txt  
 SAGE_Pediatrics_Collection_Backfile_2014.txt  
 SAGE_Pharmacology_and_Biomedical_Collection_2013.txt  
 SAGE_Pharmacology_and_Biomedical_Collection_2014.txt  
 SAGE_Pharmacology_and_Biomedical_Collection_Backfile_2014.txt  
 SAGE_Political_Science_Collection_Backfile_2014.txt  
 SAGE_Politics_and_International_Relations_Collection_2013.txt  
 SAGE_Politics_and_International_Relations_Collection_2014.txt  
 SAGE_Premier_2006.txtBen Heet 
 SAGE_Premier_2007.txtBen Heet 
 SAGE_Premier_2007_without_AERA_journals.txtBen Heet 
 SAGE_Premier_2008.txtBen Heet 
 SAGE_Premier_2008_Asia.txtBen Heet 
 SAGE_Premier_2009.txtBen Heet 
 SAGE_Premier_2010.txtBen Heet 
 SAGE_Premier_2011.txtBen Heet 
 SAGE_Premier_2012.txtBen Heet 
 SAGE_Premier_2013.txtBen Heet 
Sage: Premier 2014SAGE_Premier_2014.txtBen Heet 
 SAGE_Premier_2014_Gratis_Upgrade_Package.txt  
 SAGE_Psychology_Collection_2013.txt  
 SAGE_Psychology_Collection_2014.txt  
 SAGE_Psychology_Collection_Backfile_2014.txt  
 SAGE_RSM_Package_2014.txt  
 SAGE_RSM_Package_Backfile_2014.txt  
 SAGE_Shallow_Backfile_Package_2014.txt  
 SAGE_Shallow_Backfile_Package_DFG_2014.txt  
 SAGE_Shallow_Backfile_Package_with_RSM_2014.txt  
 SAGE_SJ_All_Titles.txt  
 SAGE_Sociology_Collection_2013.txt  
 SAGE_Sociology_Collection_2014.txt  
 SAGE_Sociology_Collection_Backfile_2014.txt  
 SAGE_STM_Backfile_Upgrade_Package_2008.txt  
 SAGE_STM_Backfile_Upgrade_Package_2009.txt  
 SAGE_STM_Backfile_Upgrade_Package_2010.txt  
 SAGE_STM_Backfile_Upgrade_Package_2011.txt  
 SAGE_STM_Backfile_Upgrade_Package_2012.txt  
 SAGE_STM_Backfile_Upgrade_Package_2013.txt  
 SAGE_STM_Backfile_Upgrade_Package_2014.txt  
 SAGE_STM_Package_2007.txt  
 SAGE_STM_Package_2008.txt  
 SAGE_STM_Package_2009.txt  
 SAGE_STM_Package_2010.txt  
 SAGE_STM_Package_2011.txt  
 SAGE_STM_Package_2012.txt  
 SAGE_STM_Package_2013.txt  
 SAGE_STM_Package_2014.txt  
 SAGE_Theology_Collection_2013.txt  
 SAGE_Theology_Collection_2014.txt  
 SAGE_Theology_Collection_Backfile_2014.txt  
 SAGE_Urban_Studies_and_Planning_Collection_2013.txt  
 SAGE_Urban_Studies_and_Planning_Collection_2014.txt  
 SAGE_Urban_Studies_and_Planning_Collection_Backfile_2014.txt  
 Sociology_A_SAGE_Full_Text_Collection.txt  
 Urban_Studies_A_SAGE_Full_Text_Collection.txt  
    

...

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