Versions Compared

Old Version 157

changes.mady.by.user Former user

Saved on

compared with

New Version 158

changes.mady.by.user Eric Hanson (Unlicensed)

Saved on

Key

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

On this page:

...

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

...

No.Package nameFileAssigned toUpdate frequency
1 Elsevier: ScienceDirect Cell Press Collection Cell Press Collection [ECCPC]DavidMonthly
2Elsevier: ScienceDirect Clinics Collection - BasicClinics Collection (ScienceDirect) - Basic [BCLIN]DavidMonthly
3Elsevier: ScienceDirect Clinics Collection - CompleteClinics Collection (ScienceDirect) - Complete [FCLIN]DavidMonthly
4Elsevier: ScienceDirect Clinics Collection - DeluxeClinics Collection (ScienceDirect) - Deluxe [DCLIN]LisaMonthly
5Elsevier: ScienceDirect Clinics Collection - PremiumClinics Collection (ScienceDirect) - Premium [PCLIN]LisaMonthly
6Elsevier: ScienceDirect Italian language EMC CollectionElsevier Italian language EMC Collection [ITEMC]Matt HarringtonMonthly
7Elsevier: ScienceDirect Masson French Language TitlesElsevier Masson French Language Titles [SCEMT]LisaMonthly
8Elsevier: ScienceDirect Subject Collection - Spanish Language EMC CollectionElsevier Spanish Language EMC Collection [SPEMC]MarianneMonthly
9Elsevier: ScienceDirect Subject Collection - Urban & Fischer Archive: BiochemistryElsevier Urban & Fischer Archive: Biochemistry [EUFABIOC]Tessa MinchewMonthly
10Elsevier: ScienceDirect Subject Collection - Urban & Fischer Archive: Immunology & MicrobiologyElsevier Urban & Fischer Archive: Immunology & Microbiology [EUFAIM]TessaMonthly
11Elsevier: ScienceDirect Subject Collection - Urban & Fischer Archive: MedicineElsevier Urban & Fischer Archive: Medicine [EUFAMED]TessaMonthly
12Elsevier: ScienceDirect Freedom Collection JournalsFreedom Collection Journals [SCFCJ]Kristen WilsonMonthly
13Elsevier: ScienceDirect Subject Collection - Large Multidisciplinary CollectionLarge Multidisciplinary Collection [ECLMC]MarianneMonthly
14Elsevier: ScienceDirect Subject Collection - Life Sciences JapanLife Sciences Japan [FCJLS]MarianneMonthly
15Elsevier: ScienceDirect Subject Collection - Medium Multidisciplinary CollectionMedium Multidisciplinary Collection [ECMMC]MarianneMonthly
16Elsevier: ScienceDirect Subject Collection - SciVerse Hightech EditionSciVerse Hightech Edition - Subject Collection [SVHTSC]MarianneMonthly
17Elsevier: ScienceDirect College Edition Journals Collection - Health and Life SciencesSD College Edition Journals Collection - Health and Life Sciences [SCHLS]DavidMonthly
18Elsevier: ScienceDirect College Edition Journals Collection - Physical SciencesSD College Edition Journals Collection - Physical Sciences [SCPS]EricMonthly
19Elsevier: ScienceDirect College Edition Journals Collection - Social and Behavioural SciencesSD College Edition Journals Collection - Social and Behavioural Sciences [SCSBS]MattMonthly
20Elsevier: ScienceDirect Subject Collection - Small Multidisciplinary CollectionSmall Multidisciplinary Collection [ECSMC]Eric HansonMonthly
21Elsevier: ScienceDirect Subject Collection - Agricultural and Biological SciencesSubject Collection - Agricultural and Biological Sciences [SCABS]Xiaoyan SongMonthly
22Elsevier: ScienceDirect Subject Collection - Biochemistry, Genetics and Molecular BiologySubject Collection - Biochemistry, Genetics and Molecular Biology [SCBGM]TessaMonthly
23Elsevier: ScienceDirect Subject Collection - Business, Management and AccountingSubject Collection - Business, Management and Accounting [SCBMA]YanMonthly
24Elsevier: ScienceDirect Subject Collection - Chemical EngineeringSubject Collection - Chemical Engineering [SCCEG]YanMonthly
25Elsevier: ScienceDirect Subject Collection - ChemistrySubject Collection - Chemistry [SCCHE]YanMonthly
26Elsevier: ScienceDirect Subject Collection - Computer ScienceSubject Collection - Computer Science [SCCSC]YanMonthly
27Elsevier: ScienceDirect Subject Collection - Decision SciencesSubject Collection - Decision Sciences [SCDSC]MarianneMonthly
28Elsevier: ScienceDirect Subject Collection - Earth and Planetary SciencesSubject Collection - Earth and Planetary Sciences [SCEPS]MarianneMonthly
29Elsevier: ScienceDirect Subject Collection -Economics, Econometrics and FinanceSubject Collection - Economics, Econometrics and Finance [SCEEF]LizMonthly
30Elsevier: ScienceDirect Subject Collection - EnergySubject Collection - Energy [SCEPW]LizMonthly
31Elsevier: ScienceDirect Subject Collection - EngineeringSubject Collection - Engineering [SCETG]LizMonthly
32Elsevier: ScienceDirect Subject Collection - Environmental ScienceSubject Collection - Environmental Science [SCESC]EricMonthly
33Elsevier: ScienceDirect Subject Collection - Health SciencesSubject Collection - Health Sciences [SCMED]EricMonthly
34Elsevier: ScienceDirect Subject Collection - Immunology and MicrobiologySubject Collection - Immunology and Microbiology [SCIMB]MarianneMonthly
35Elsevier: ScienceDirect Subject Collection - Materials ScienceSubject Collection - Materials Science [SCMSC]LisaMonthly
36Elsevier: ScienceDirect Subject Collection - MathematicsSubject Collection - Mathematics [SCMAT]LisaMonthly
37Elsevier: ScienceDirect Subject Collection - Mathematics CoreSubject Collection - Mathematics Core [SCMATCORE]LisaMonthly
38Elsevier: ScienceDirect Subject Collection - Neuroscience Subject Collection - Neuroscience [SCNRS]LisaMonthly
39Elsevier: ScienceDirect Subject Collection - Nursing and Health ProfessionsSubject Collection - Nursing and Health Professions [SCNHP]LisaMonthly
40Elsevier: ScienceDirect Subject Collection - Pharmacology, Toxicology and PharmaceuticsSubject Collection - Pharmacology, Toxicology and Pharmaceutics [SCPTP]MattMonthly
41Elsevier: ScienceDirect Subject Collection - Physics and AstronomySubject Collection - Physics and Astronomy [SCPAS]MattMonthly
42Elsevier: ScienceDirect Subject Collection - PsychologySubject Collection - Psychology [SCPSY]LizMonthly
43Elsevier: ScienceDirect Subject Collection - Social ScienceSubject Collection - Social Science [SCSSC]LizMonthly
44Elsevier: ScienceDirect Subject Collection - Veterinary Science and Veterinary MedicineSubject Collection - Veterinary Science and Veterinary Medicine [SCVSM]LizMonthly
45Elsevier: ScienceDirect United Nations package HINARI-AGORA-OARE (journals)
United Nations package HINARI-AGORA-OARE (journals)LizMonthly
46Elsevier: ScienceDirect Complimentary free access journals
Complimentary free access journalsLizMonthly

...

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]LisaYearly
5Elsevier: ScienceDirect Backfile Package - Allergology Rheumatology And ImmunologyBackfile Package - Allergology, Rheumatology and Immunology [YHI]LisaYearly
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]LisaYearly
7Elsevier: ScienceDirect Backfile Package - Biochemistry Genetics And Molecular Biology LegacyBackfile Package - Biochemistry, Genetics and Molecular Biology (Legacy) [YBG]LisaYearly
8
Elsevier: ScienceDirect Backfile Package - Biochemistry Genetics And Molecular Biology 1995-2004		Backfile Package - Biochemistry, Genetics and Molecular Biology 1995-2004 [BFJBGM9504]LisaYearly
9Elsevier: ScienceDirect Backfile Package - Biochemistry Genetics And Molecular Biology Including Supplement 1Backfile Package - Biochemistry, Genetics and Molecular Biology including Supplement 1 [YUL]LisaYearly
10Elsevier: ScienceDirect Backfile Package - Business Management And Accounting LegacyBackfile Package - Business, Management and Accounting (Legacy) [YBT]LisaYearly
11Elsevier: ScienceDirect Backfile Package - Business Management And Accounting 1995-2004Backfile Package - Business, Management and Accounting 1995-2004 [BFJBMA9504]LisaYearly
12Elsevier: ScienceDirect Backfile Package - Business Management And Accounting Including Supplement 1Backfile Package - Business, Management and Accounting including Supplement 1 [YUB]LisaYearly
13Elsevier: ScienceDirect Backfile Package - Cell PressBackfile Package - Cell Press [YCP]LisaYearly
14Elsevier: ScienceDirect Backfile Package - Chemical Engineering LegacyBackfile Package - Chemical Engineering (Legacy) [YCC]LisaYearly
15Elsevier: ScienceDirect Backfile Package - Chemical Engineering 1995-2004Backfile Package - Chemical Engineering 1995-2004 [BFJCEG9504]LisaYearly
16Elsevier: ScienceDirect Backfile Package - Chemical Engineering Including Supplement 1Backfile Package - Chemical Engineering including Supplement 1 [YUC]LisaYearly
17Elsevier: ScienceDirect Backfile Package - Chemistry 1995-2004Backfile Package - Chemistry 1995-2004 [BFJCHE9504]LisaYearly
18Elsevier: ScienceDirect Backfile Package - Clinical NeurologyBackfile Package - Clinical Neurology [YHC]SharonYearly
19Elsevier: ScienceDirect Backfile Package - Computer Science (Legacy)Backfile Package - Computer Science (Legacy) [YCS]SharonYearly
20Elsevier: ScienceDirect Backfile Package - Computer Science 1995-2004Backfile Package - Computer Science 1995-2004 [BFJCSC9504]SharonYearly
21Elsevier: ScienceDirect Backfile Package - Computer Science Including Supplement 1Backfile Package - Computer Science including Supplement 1 [YUR]SharonYearly
22Elsevier: ScienceDirect Backfile Package - Decision SciencesBackfile Package - Decision Sciences [YDT]SharonYearly
23Elsevier: ScienceDirect Backfile Package - Decision Sciences 1995-2004Backfile Package - Decision Sciences 1995-2004 [BFJDSC9504]SharonYearly
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]SharonYearly
71Elsevier: ScienceDirect Backfile Package - Pharmacology, Toxicology and Pharmaceutics 1995-2004Backfile Package - Pharmacology, Toxicology and Pharmaceutics 1995-2004 [BFJPTP9504]SharonYearly
72Elsevier: ScienceDirect Backfile Package - Pharmacology, Toxicology and Pharmaceutics including Supplement 1Backfile Package - Pharmacology, Toxicology and Pharmaceutics including Supplement 1 [YUZ]SharonYearly
73Elsevier: ScienceDirect Backfile Package - Physical and Analytical Chemistry (Legacy)Backfile Package - Physical and Analytical Chemistry (Legacy) [YCA]SharonYearly
74Elsevier: ScienceDirect Backfile Package - Physical and Analytical Chemistry including Supplement 1Backfile Package - Physical and Analytical Chemistry including Supplement 1 [YUA]SharonYearly
75Elsevier: ScienceDirect Backfile Package - Physics And Astronomy 1995-2004Backfile Package - Physics and Astronomy 1995-2004 [BFJPAS9504]SharonYearly
76Elsevier: ScienceDirect Backfile Package - Physics General (Legacy)Backfile Package - Physics General (Legacy) [YPA]SharonYearly
77Elsevier: ScienceDirect Backfile Package - Physics General Including Supplement 1Backfile Package - Physics General including Supplement 1 [YUG]SharonYearly
78Elsevier: ScienceDirect Backfile Package - Psychiatry and Mental HealthBackfile Package - Psychiatry and Mental Health [YHS]SharonYearly
79Elsevier: ScienceDirect Backfile Package - Psychology (Legacy)Backfile Package - Psychology (Legacy) [YPT]SharonYearly
80Elsevier: ScienceDirect Backfile Package - Psychology 1995-2004Backfile Package - Psychology 1995-2004 [BFJPSY9504]SharonYearly
81Elsevier: ScienceDirect Backfile Package - Psychology including Supplement 1Backfile Package - Psychology including Supplement 1 [YUP]SharonYearly
82Elsevier: ScienceDirect Backfile Package - Public Health and Health PolicyBackfile Package - Public Health and Health Policy [YHU]SharonYearly
83Elsevier: ScienceDirect Backfile Package - Radiology And ImagingBackfile Package - Radiology and Imaging [YHR]SharonYearly
84Elsevier: ScienceDirect Backfile Package - Respiratory, Pulmonary and Infectious DiseasesBackfile Package - Respiratory, Pulmonary and Infectious Diseases [YHJ]SharonYearly
85Elsevier: ScienceDirect Backfile Package - Social Science (Legacy)Backfile Package - Social Science (Legacy) [YST]SharonYearly
86Elsevier: ScienceDirect Backfile Package - Social Science including Supplement 1Backfile Package - Social Science including Supplement 1 [YUS]SharonYearly
87Elsevier: ScienceDirect Backfile Package - Social Sciences 1995-2004Backfile Package - Social Sciences 1995-2004 [BFJSSC9504]SharonYearly
88Elsevier: ScienceDirect Backfile Package - SurgeryBackfile Package - Surgery [YHY]SharonYearly
89Elsevier: ScienceDirect Backfile Package - The LancetBackfile Package - The Lancet [YTL]SharonYearly
90Elsevier: ScienceDirect Backfile Package - Veterinary Science and Veterinary MedicineBackfile Package - Veterinary Science and Veterinary Medicine [YMV]SharonYearly
91Elsevier: ScienceDirect Backfile Package - Veterinary Science and Veterinary Medicine 1995-2004Backfile Package - Veterinary Science and Veterinary Medicine 1995-2004 [BFJVSM9504]SharonYearly

Non-Assigned Packages

...