Versions Compared

Old Version 147

changes.mady.by.user Former user

Saved on

compared with

New Version 148

changes.mady.by.user Former user

Saved on

Key

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

On this page:

...

TransformationNotes
Elsevier full conversion macro (GOKb Test)

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 test instance of GOKb.

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
921 Elsevier: ScienceDirect Cell Press Collection Cell Press Collection [ECCPC]DavidMonthly
932Elsevier: ScienceDirect Clinics Collection - BasicClinics Collection (ScienceDirect) - Basic [BCLIN]DavidMonthly
943Elsevier: ScienceDirect Clinics Collection - CompleteClinics Collection (ScienceDirect) - Complete [FCLIN]DavidMonthly
954Elsevier: ScienceDirect Clinics Collection - DeluxeClinics Collection (ScienceDirect) - Deluxe [DCLIN]DavidMonthly
965Elsevier: ScienceDirect Clinics Collection - PremiumClinics Collection (ScienceDirect) - Premium [PCLIN]DavidMonthly
976Elsevier: ScienceDirect Italian language EMC CollectionElsevier Italian language EMC Collection [ITEMC]Matt HarringtonMonthly
987Elsevier: ScienceDirect Masson French Language TitlesElsevier Masson French Language Titles [SCEMT]DavidMonthly
998Elsevier: ScienceDirect Subject Collection - Spanish Language EMC CollectionElsevier Spanish Language EMC Collection [SPEMC]TessaMonthly
1009Elsevier: ScienceDirect Subject Collection - Urban & Fischer Archive: BiochemistryElsevier Urban & Fischer Archive: Biochemistry [EUFABIOC]Tessa MinchewMonthly
10110Elsevier: ScienceDirect Subject Collection - Urban & Fischer Archive: Immunology & MicrobiologyElsevier Urban & Fischer Archive: Immunology & Microbiology [EUFAIM]TessaMonthly
10211Elsevier: ScienceDirect Subject Collection - Urban & Fischer Archive: MedicineElsevier Urban & Fischer Archive: Medicine [EUFAMED]TessaMonthly
10312Elsevier: ScienceDirect Freedom Collection JournalsFreedom Collection Journals [SCFCJ]Kristen WilsonMonthly
10413Elsevier: ScienceDirect Subject Collection - Large Multidisciplinary CollectionLarge Multidisciplinary Collection [ECLMC]TessaMonthly
10514Elsevier: ScienceDirect Subject Collection - Life Sciences JapanLife Sciences Japan [FCJLS]TessaMonthly
10615Elsevier: ScienceDirect Subject Collection - Medium Multidisciplinary CollectionMedium Multidisciplinary Collection [ECMMC]TessaMonthly
10716Elsevier: ScienceDirect Subject Collection - SciVerse Hightech EditionSciVerse Hightech Edition - Subject Collection [SVHTSC]TessaMonthly
10817Elsevier: ScienceDirect College Edition Journals Collection - Health and Life SciencesSD College Edition Journals Collection - Health and Life Sciences [SCHLS]DavidMonthly
10918Elsevier: ScienceDirect College Edition Journals Collection - Physical SciencesSD College Edition Journals Collection - Physical Sciences [SCPS]EricMonthly
11019Elsevier: ScienceDirect College Edition Journals Collection - Social and Behavioural SciencesSD College Edition Journals Collection - Social and Behavioural Sciences [SCSBS]MattMonthly
11120Elsevier: ScienceDirect Small Multidisciplinary CollectionSmall Multidisciplinary Collection [ECSMC]Eric HansonMonthly
11221Elsevier: ScienceDirect Subject Collection - Agricultural and Biological SciencesSubject Collection - Agricultural and Biological Sciences [SCABS]Xiaoyan SongMonthly
11322Elsevier: ScienceDirect Subject Collection - Biochemistry, Genetics and Molecular BiologySubject Collection - Biochemistry, Genetics and Molecular Biology [SCBGM]TessaMonthly
11423Elsevier: ScienceDirect Subject Collection - Business, Management and AccountingSubject Collection - Business, Management and Accounting [SCBMA]YanMonthly
11524Elsevier: ScienceDirect Subject Collection - Chemical EngineeringSubject Collection - Chemical Engineering [SCCEG]YanMonthly
11625Elsevier: ScienceDirect Subject Collection - ChemistrySubject Collection - Chemistry [SCCHE]YanMonthly
11726Elsevier: ScienceDirect Subject Collection - Computer ScienceSubject Collection - Computer Science [SCCSC]YanMonthly
11827Elsevier: ScienceDirect Subject Collection - Decision SciencesSubject Collection - Decision Sciences [SCDSC]YanMonthly
11928Elsevier: ScienceDirect Subject Collection - Earth and Planetary SciencesSubject Collection - Earth and Planetary Sciences [SCEPS]YanMonthly
12029Elsevier: ScienceDirect Subject Collection -Economics, Econometrics and FinanceSubject Collection - Economics, Econometrics and Finance [SCEEF]YanMonthly
12130Elsevier: ScienceDirect Subject Collection - EnergySubject Collection - Energy [SCEPW]YanMonthly
12231Elsevier: ScienceDirect Subject Collection - EngineeringSubject Collection - Engineering [SCETG]YanMonthly
12332Elsevier: ScienceDirect Subject Collection - Environmental ScienceSubject Collection - Environmental Science [SCESC]EricMonthly
12433Elsevier: ScienceDirect Subject Collection - Health SciencesSubject Collection - Health Sciences [SCMED]EricMonthly
12534Elsevier: ScienceDirect Subject Collection - Immunology and MicrobiologySubject Collection - Immunology and Microbiology [SCIMB]EricMonthly
12635Elsevier: ScienceDirect Subject Collection - Materials ScienceSubject Collection - Materials Science [SCMSC]EricMonthly
12736Elsevier: ScienceDirect Subject Collection - MathematicsSubject Collection - Mathematics [SCMAT]EricMonthly
12837Elsevier: ScienceDirect Subject Collection - Mathematics CoreSubject Collection - Mathematics Core [SCMATCORE]EricMonthly
12938Elsevier: ScienceDirect Subject Collection - Neuroscience Subject Collection - Neuroscience [SCNRS]EricMonthly
13039Elsevier: ScienceDirect Subject Collection - Nursing and Health ProfessionsSubject Collection - Nursing and Health Professions [SCNHP]EricMonthly
13140Elsevier: ScienceDirect Subject Collection - Pharmacology, Toxicology and PharmaceuticsSubject Collection - Pharmacology, Toxicology and Pharmaceutics [SCPTP]MattMonthly
13241Elsevier: ScienceDirect Subject Collection - Physics and AstronomySubject Collection - Physics and Astronomy [SCPAS]MattMonthly
13342Elsevier: ScienceDirect Subject Collection - PsychologySubject Collection - Psychology [SCPSY]MattMonthly
13443Elsevier: ScienceDirect Subject Collection - Social ScienceSubject Collection - Social Science [SCSSC]MattMonthly
13544Elsevier: ScienceDirect Subject Collection - Veterinary Science and Veterinary MedicineSubject Collection - Veterinary Science and Veterinary Medicine [SCVSM]MattMonthly
13645Elsevier: ScienceDirect United Nations package HINARI-AGORA-OARE (journals)
United Nations package HINARI-AGORA-OARE (journals)MattMonthly
13746Elsevier: ScienceDirect Complimentary free access journals
Complimentary free access journalsMattMonthly

...

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 Backflie Package - Clinical NeurologyBackfile Package - Clinical Neurology [YHC]LisaYearly
19Elsevier: ScienceDirect Backfile Package - Computer Science (Legacy)Backfile Package - Computer Science (Legacy) [YCS]LisaYearly
20Elsevier: ScienceDirect Backfile Package - Computer Science 1995-2004Backfile Package - Computer Science 1995-2004 [BFJCSC9504]LisaYearly
21Elsevier: ScienceDirect Backfile Package - Computer Science Including Supplement 1Backfile Package - Computer Science including Supplement 1 [YUR]LisaYearly
22Elsevier: ScienceDirect Backfile Package - Decision SciencesBackfile Package - Decision Sciences [YDT]LisaYearly
23Elsevier: ScienceDirect Backfile Package - Decision Sciences 1995-2004Backfile Package - Decision Sciences 1995-2004 [BFJDSC9504]LisaYearly
24Elsevier: ScienceDirect Backfile Package - Dentistry Oral Surgery and MedicineBackfile Package - Dentistry, Oral Surgery and Medicine [YHD]LizYearly
25Elsevier: ScienceDirect Backfile Package - Earth and Plenetary 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

...