Versions Compared

Old Version 159

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Jennifer Solomon

Saved on

Key

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

On this page:

Table of Contents

...

TransformationNotes
Elsevier full conversion macro (GOKb Live)

This macro makes Elsevier KBART files ready for ingest into GOKb, with the exception of the the "package.name" look-up, which must be selected by the uploader. If this macro is run, the three

macros below should not be necessary. This version is for the live instance of GOKb.

Elsevier - Rename KBART columns to GOKb columnsThis macro is specific to Elsevier packages due to the ISSN and E-ISSN columns being switched.
Collapse duplicate titles into single rows

Before applying this macro, confirm:

  • All DateFirsPackageIssue fields are populated
  • Any rows that contain a VolumeLastPackageIssue and/or a NumberLastPackageIssue also contain a DateLastPackageIssue
  • You have renamed the "title_id" column "title.identifier.elsevier"
Quick fix transformation Quick fix transformation for "lastedateissued" column

Customized Columns

Column NameCustomized Column Name
title_idtitle.identifier.elsevier
notesgokb.tipp.ElsevierNotes
publisher_namegokb.ti.imprint
precedingpublicationIDgokb.ti.ElsevierPrecedingPublicationID
titlechangehistroygokb.ti.TitleHistoryNoteCopy and paste this macro into the "Apply" field.

 

...

No.Package nameFileAssigned toUpdate frequency
1Elsevier: ScienceDirect Backfile Package - Agricultural And Biological Sciences LegacyBackfile Package - Agricultural and Biological Sciences (Legacy) [YAB]LisaYearly
2Elsevier: ScienceDirect Backfile Package - Agricultural and Biological Sciences 1995-2004Backfile Package - Agricultural and Biological Sciences 1995-2004 [BFJABS9504]LisaYearly
3Elsevier: ScienceDirect Backfile Package - Agricultural and Biological Sciences including Supplement 1Backfile Package - Agricultural and Biological Sciences including Supplement 1 [YUF]LisaYearly
4Elsevier: ScienceDirect Backfile Package - All of Back Files EBSBackfile Package - All of Back Files EBS [ALLOFBCKF]JenniferYearly
5Elsevier: ScienceDirect Backfile Package - Allergology Rheumatology And ImmunologyBackfile Package - Allergology, Rheumatology and Immunology [YHI]JenniferYearly
6Elsevier: ScienceDirect Backfile Package - Anesthesiology Pain Medicine Emergency Medicine Critical Care And Intensive MedicineBackfile Package - Anesthesiology, Pain Medicine, Emergency Medicine, Critical Care and Intensive Medicine [YHA]JenniferYearly
7Elsevier: ScienceDirect Backfile Package - Biochemistry Genetics And Molecular Biology LegacyBackfile Package - Biochemistry, Genetics and Molecular Biology (Legacy) [YBG]LizYearly
8
Elsevier: ScienceDirect Backfile Package - Biochemistry Genetics And Molecular Biology 1995-2004		Backfile Package - Biochemistry, Genetics and Molecular Biology 1995-2004 [BFJBGM9504]LizYearly
9Elsevier: ScienceDirect Backfile Package - Biochemistry Genetics And Molecular Biology Including Supplement 1Backfile Package - Biochemistry, Genetics and Molecular Biology including Supplement 1 [YUL]LizYearly
10Elsevier: ScienceDirect Backfile Package - Business Management And Accounting LegacyBackfile Package - Business, Management and Accounting (Legacy) [YBT]LizYearly
11Elsevier: ScienceDirect Backfile Package - Business Management And Accounting 1995-2004Backfile Package - Business, Management and Accounting 1995-2004 [BFJBMA9504]LizYearly
12Elsevier: ScienceDirect Backfile Package - Business Management And Accounting Including Supplement 1Backfile Package - Business, Management and Accounting including Supplement 1 [YUB]LizYearly
13Elsevier: ScienceDirect Backfile Package - Cell PressBackfile Package - Cell Press [YCP]LizYearly
14Elsevier: ScienceDirect Backfile Package - Chemical Engineering LegacyBackfile Package - Chemical Engineering (Legacy) [YCC]LizYearly
15Elsevier: ScienceDirect Backfile Package - Chemical Engineering 1995-2004Backfile Package - Chemical Engineering 1995-2004 [BFJCEG9504]LizYearly
16Elsevier: ScienceDirect Backfile Package - Chemical Engineering Including Supplement 1Backfile Package - Chemical Engineering including Supplement 1 [YUC]LizYearly
17Elsevier: ScienceDirect Backfile Package - Chemistry 1995-2004Backfile Package - Chemistry 1995-2004 [BFJCHE9504]LizYearly
18Elsevier: ScienceDirect Backfile Package - Clinical NeurologyBackfile Package - Clinical Neurology [YHC]LizYearly
19Elsevier: ScienceDirect Backfile Package - Computer Science (Legacy)Backfile Package - Computer Science (Legacy) [YCS]LizYearly
20Elsevier: ScienceDirect Backfile Package - Computer Science 1995-2004Backfile Package - Computer Science 1995-2004 [BFJCSC9504]LizYearly
21Elsevier: ScienceDirect Backfile Package - Computer Science Including Supplement 1Backfile Package - Computer Science including Supplement 1 [YUR]LizYearly
22Elsevier: ScienceDirect Backfile Package - Decision SciencesBackfile Package - Decision Sciences [YDT]LizYearly
23Elsevier: ScienceDirect Backfile Package - Decision Sciences 1995-2004Backfile Package - Decision Sciences 1995-2004 [BFJDSC9504]LizYearly
24Elsevier: ScienceDirect Backfile Package - Dentistry Oral Surgery and MedicineBackfile Package - Dentistry, Oral Surgery and Medicine [YHD]LizYearly
25Elsevier: ScienceDirect Backfile Package - Earth and Planetary Sciences (Legacy)Backfile Package - Earth and Planetary Sciences (Legacy) [YEP]LizYearly
26Elsevier: ScienceDirect Backfile Package - Earth and Planetary Sciences 1995-2004Backfile Package - Earth and Planetary Sciences 1995-2004 [BFJEPS9504]LizYearly
27Elsevier: ScienceDirect Backfile Package - Earth and Planetary Sciences including Supplement 1Backfile Package - Earth and Planetary Sciences including Supplement 1 [YUE]LizYearly
28Elsevier: ScienceDirect Backfile Package - Economics, Econometrics and Finance (Legacy)Backfile Package - Economics, Econometrics and Finance (Legacy) [YET]LizYearly
29Elsevier: ScienceDirect Backfile Package - Economics, Econometrics and Finance 1995-2004Backfile Package - Economics, Econometrics and Finance 1995-2004 [BFJEEF9504]LizYearly
30Elsevier: ScienceDirect Backfile Package - Economics, Econometrics and Finance including Supplement 1Backfile Package - Economics, Econometrics and Finance including Supplement 1 [YUT]LizYearly
31Elsevier: ScienceDirect Backfile Package - Energy 1995-2004Backfile Package - Energy 1995-2004 [BFJEPW9504]LizYearly
32Elsevier: ScienceDirect Backfile Package - Energy and PowerBackfile Package - Energy and Power [YER]LizYearly
33Elsevier: ScienceDirect Backfile Package - Engineering 1995-2004Backfile Package - Engineering 1995-2004 [BFJETG9504]LizYearly
34Elsevier: ScienceDirect Backfile Package - Engineering and TechnologyBackfile Package - Engineering and Technology [YEN]LizYearly
35Elsevier: ScienceDirect Backfile Package - Environmental Science (Legacy)Backfile Package - Environmental Science (Legacy) [YES]LizYearly
36Elsevier: ScienceDirect Backfile Package - Environmental Science 1995-2004Backfile Package - Environmental Science 1995-2004 [BFJESC9504]LizYearly
37Elsevier: ScienceDirect Backfile Package - Environmental Science including Supplement 1 (2006)Backfile Package - Environmental Science including Supplement 1 (2006) [YUV]LizYearly
38Elsevier: ScienceDirect Backfile Package - FEBS LettersBackfile Package - FEBS Letters [YFL]LizYearly
39Elsevier: ScienceDirect Backfile Package - Forensic Medicine, Pathology and Medical TechnologyBackfile Package - Forensic Medicine, Pathology and Medical Technology [YHF]LizYearly
40Elsevier: ScienceDirect Backfile Package - Gastroenterology, Endocrinology, Diabetes and MetabolismBackfile Package - Gastroenterology, Endocrinology, Diabetes and Metabolism [YHG]LizYearly
41Elsevier: ScienceDirect Backfile Package - General MedicineBackfile Package - General Medicine [YHM]LizYearly
42Elsevier: ScienceDirect Backfile Package - Hematology, Cardiology and Cardiovascular MedicineBackfile Package - Hematology, Cardiology and Cardiovascular Medicine [YHH]LizYearly
43Elsevier: ScienceDirect Backfile Package - High energy/Nuclear Physics and Astronomy (Legacy)Backfile Package - High Energy/Nuclear Physics and Astronomy (Legacy) [YPB]LizYearly
44Elsevier: ScienceDirect Backfile Package - High energy/Nuclear Physics and Astronomy including Supplement 1Backfile Package - High Energy/Nuclear Physics and Astronomy including Supplement 1 [YUH]LizYearly
45Elsevier: ScienceDirect Backfile Package - Immunology and Microbiology (Legacy)Backfile Package - Immunology and Microbiology (Legacy) [YIM]LizYearly
46Elsevier: ScienceDirect Backfile Package - Immunology and Microbiology 1995-2004Backfile Package - Immunology and Microbiology 1995-2004 [BFJIMB9504]LizYearly
47Elsevier: ScienceDirect Backfile Package - Immunology and Microbiology including Supplement 1 (2006)Backfile Package - Immunology and Microbiology including Supplement 1 (2006) [YUU]MarianneYearly
48Elsevier: ScienceDirect Backfile Package - Inorganic Chemistry (Legacy)Backfile Package - Inorganic Chemistry (Legacy) [YCI]MarianneYearly
49Elsevier: ScienceDirect Backfile Package - Inorganic Chemistry including Supplement 1Backfile Package - Inorganic Chemistry including Supplement 1 [YUI]MarianneYearly
50Elsevier: ScienceDirect Backfile Package - Materials ScienceBackfile Package - Materials Science [YMS]MarianneYearly
51Elsevier: ScienceDirect Backfile Package - Materials Science 1995-2004Backfile Package - Materials Science 1995-2004 [BFJMSC9504]MarianneYearly
52Elsevier: ScienceDirect Backfile Package - Mathematics (Legacy)Backfile Package - Mathematics (Legacy) [YMT]MarianneYearly
53Elsevier: ScienceDirect Backfile Package - Mathematics 1995-2004Backfile Package - Mathematics 1995-2004 [BFJMAT9504]MarianneYearly
54Elsevier: ScienceDirect Backfile Package - Mathematics including Supplement 1Backfile Package - Mathematics including Supplement 1 [YUM]MarianneYearly
55Elsevier: ScienceDirect Backfile Package - Medicine and Dentistry (Legacy)Backfile Package - Medicine and Dentistry (Legacy) [YME]MarianneYearly
56Elsevier: ScienceDirect Backfile Package - Medicine and Dentistry 1995-2004Backfile Package - Medicine and Dentistry 1995-2004 [BFJMED9504]MarianneYearly
57Elsevier: ScienceDirect Backfile Package - Medicine and Dentistry including Supplement 1 (2006)Backfile Package - Medicine and Dentistry including Supplement 1 (2006) [YMU]MarianneYearly
58Elsevier: ScienceDirect Backfile Package - Medicine and Dentistry including Supplements 1 and 2Backfile Package - Medicine and Dentistry including Supplements 1 and 2 [YKM]MarianneYearly
59Elsevier: ScienceDirect Backfile Package - Neuroscience (Legacy)Backfile Package - Neuroscience (Legacy) [YNT]MarianneYearly
60Elsevier: ScienceDirect Backfile Package - NeuroscienceBackfile Package - Neuroscience 1995-2004 [BFJNRS9504]MarianneYearly
61Elsevier: ScienceDirect Backfile Package - Neuroscience including Supplement 1Backfile Package - Neuroscience including Supplement 1 [YUN]MarianneYearly
62Elsevier: ScienceDirect Backfile Package - Nursing and Health ProfessionsBackfile Package - Nursing and Health Professions [YMN]MarianneYearly
63Elsevier: ScienceDirect Backfile Package - Nursing and Health Professions 1995-2004Backfile Package - Nursing and Health Professions 1995-2004 [BFJNHP9504]MarianneYearly
64Elsevier: ScienceDirect Backfile Package - Obstetrics, Gynecology and Women's HealthBackfile Package - Obstetrics, Gynecology and Women's Health [YHO]MarianneYearly
65Elsevier: ScienceDirect Backfile Package - OncologyBackfile Package - Oncology [YHN]MarianneYearly
66Elsevier: ScienceDirect Backfile Package - Organic Chemistry (Legacy)Backfile Package - Organic Chemistry (Legacy) [YCO]MarianneYearly
67Elsevier: ScienceDirect Backfile Package - Organic Chemistry including Supplement 1Backfile Package - Organic Chemistry including Supplement 1 [YUO]MarianneYearly
68Elsevier: ScienceDirect Backfile Package - Orthopedics, Sports Medicine and RehabilitationBackfile Package - Orthopedics, Sports Medicine and Rehabilitation [YHB]MarianneYearly
69Elsevier: ScienceDirect Backfile Package - Perinatology, Pediatrics and Child HealthBackfile Package - Perinatology, Pediatrics and Child Health [YHP]MarianneYearly
70Elsevier: ScienceDirect Backfile Package - Pharmacology, Toxicology and Pharmaceutics (Legacy)Backfile Package - Pharmacology, Toxicology and Pharmaceutics (Legacy) [YPH]MarianneYearly
71Elsevier: ScienceDirect Backfile Package - Pharmacology, Toxicology and Pharmaceutics 1995-2004Backfile Package - Pharmacology, Toxicology and Pharmaceutics 1995-2004 [BFJPTP9504]MarianneYearly
72Elsevier: ScienceDirect Backfile Package - Pharmacology, Toxicology and Pharmaceutics including Supplement 1Backfile Package - Pharmacology, Toxicology and Pharmaceutics including Supplement 1 [YUZ]MarianneYearly
73Elsevier: ScienceDirect Backfile Package - Physical and Analytical Chemistry (Legacy)Backfile Package - Physical and Analytical Chemistry (Legacy) [YCA]MarianneYearly
74Elsevier: ScienceDirect Backfile Package - Physical and Analytical Chemistry including Supplement 1Backfile Package - Physical and Analytical Chemistry including Supplement 1 [YUA]MarianneYearly
75Elsevier: ScienceDirect Backfile Package - Physics And Astronomy 1995-2004Backfile Package - Physics and Astronomy 1995-2004 [BFJPAS9504]MarianneYearly
76Elsevier: ScienceDirect Backfile Package - Physics General (Legacy)Backfile Package - Physics General (Legacy) [YPA]MarianneYearly
77Elsevier: ScienceDirect Backfile Package - Physics General Including Supplement 1Backfile Package - Physics General including Supplement 1 [YUG]MarianneYearly
78Elsevier: ScienceDirect Backfile Package - Psychiatry and Mental HealthBackfile Package - Psychiatry and Mental Health [YHS]MarianneYearly
79Elsevier: ScienceDirect Backfile Package - Psychology (Legacy)Backfile Package - Psychology (Legacy) [YPT]MarianneYearly
80Elsevier: ScienceDirect Backfile Package - Psychology 1995-2004Backfile Package - Psychology 1995-2004 [BFJPSY9504]MarianneYearly
81Elsevier: ScienceDirect Backfile Package - Psychology including Supplement 1Backfile Package - Psychology including Supplement 1 [YUP]MarianneYearly
82Elsevier: ScienceDirect Backfile Package - Public Health and Health PolicyBackfile Package - Public Health and Health Policy [YHU]MarianneYearly
83Elsevier: ScienceDirect Backfile Package - Radiology And ImagingBackfile Package - Radiology and Imaging [YHR]MarianneYearly
84Elsevier: ScienceDirect Backfile Package - Respiratory, Pulmonary and Infectious DiseasesBackfile Package - Respiratory, Pulmonary and Infectious Diseases [YHJ]MarianneYearly
85Elsevier: ScienceDirect Backfile Package - Social Science (Legacy)Backfile Package - Social Science (Legacy) [YST]MarianneYearly
86Elsevier: ScienceDirect Backfile Package - Social Science including Supplement 1Backfile Package - Social Science including Supplement 1 [YUS]MarianneYearly
87Elsevier: ScienceDirect Backfile Package - Social Sciences 1995-2004Backfile Package - Social Sciences 1995-2004 [BFJSSC9504]MarianneYearly
88Elsevier: ScienceDirect Backfile Package - SurgeryBackfile Package - Surgery [YHY]MarianneYearly
89Elsevier: ScienceDirect Backfile Package - The LancetBackfile Package - The Lancet [YTL]MarianneYearly
90Elsevier: ScienceDirect Backfile Package - Veterinary Science and Veterinary MedicineBackfile Package - Veterinary Science and Veterinary Medicine [YMV]MarianneYearly
91Elsevier: ScienceDirect Backfile Package - Veterinary Science and Veterinary Medicine 1995-2004Backfile Package - Veterinary Science and Veterinary Medicine 1995-2004 [BFJVSM9504]MarianneYearly

Non-Assigned Packages

...