Skip to content

Vendor Stats Aug Sep

Aug 2021 Checklist

  • Download csv from Ken's spreadsheets
  • Copy to stats site and normalize names 8 vendors, 13 files in, 17 files out
    • britannica.sh Britannica 1 in 2 out
    • films_on_demand.sh Films on Demand 2 in 3 out
    • ebsco.sh EBSCO 4 in 4 out (_temp _data_new_format)
    • gale.sh Gale 1 in 1 out
    • mango.sh Mango 1 in 1 out
    • proquest.sh Proquest 2 in 3 out
    • ebookcentral.sh eBook Central 1 in 1 out
    • learning_express.sh Learning Express 1 in 2 out
  • Recheck Combine Months (sessions data)
  • Recheck/Update Snapshots
    • /galileo/stats/scripts/snap_data -m=yyyymm -v update|mailx -s "snap_data yyyymm" baxter.brad@uga.edu
    • /galileo/stats/scripts/snap_inst -m=yyyymm -v update|mailx -s "snap_inst yyyymm" baxter.brad@uga.edu
    • /galileo/stats/scripts/snap_dbs -m=yyyymm -v update|mailx -s "snap_dbs yyyymm" baxter.brad@uga.edu
    • /galileo/stats/scripts/snap_batch_load -dates=yyyymm -email=baxter.brad@uga.edu

Sep 2021 Checklist

  • Download csv from Ken's spreadsheets
  • Copy to stats site and normalize names 8 vendors, 13 files in, 17 files out
    • britannica.sh Britannica 1 in 2 out
    • films_on_demand.sh Films on Demand 2 in 3 out
    • ebsco.sh EBSCO 4 in 4 out (_temp _data_new_format)
    • gale.sh Gale 1 in 1 out
    • mango.sh Mango 1 in 1 out
    • proquest.sh Proquest 2 in 3 out
    • ebookcentral.sh eBook Central 1 in 1 out
    • learning_express.sh Learning Express 1 in 2 out
  • Recheck Combine Months (sessions data)
  • Recheck/Update Snapshots
    • /galileo/stats/scripts/snap_data -m=yyyymm -v update|mailx -s "snap_data yyyymm" baxter.brad@uga.edu
    • /galileo/stats/scripts/snap_inst -m=yyyymm -v update|mailx -s "snap_inst yyyymm" baxter.brad@uga.edu
    • /galileo/stats/scripts/snap_dbs -m=yyyymm -v update|mailx -s "snap_dbs yyyymm" baxter.brad@uga.edu
    • /galileo/stats/scripts/snap_batch_load -dates=yyyymm -email=baxter.brad@uga.edu

Issue

Ken Henslee:

Hi @baxter.brad, vendor data for Aug and Sept is ready to be loaded. I've included two files here for institutions that need to be added. For Ebook Central, I created a completely new file that you can use to replace what you are using currently. They keep making changes to our institution names and it was easier just to create a new file. For Britannica, EBSCO and ProQuest, the institutions are listed in the attached text file. Thanks! https://drive.google.com/drive/folders/1DDepZa3SToFsvLF7WQGNa39ZGmw7eOVE

  • 202110_Add_Inst.txt
Britannica
psfs = Fulton Science Academy
psfu = Furtah Preparatory School
psgc = Georgia Christian School
pswf = Whitefield Academy
psao = Academe of the Oaks  
psat = Atlanta Girls' School  
pset = Eaton Academy  
psff = FULLINGTON ACADEMY  
psla = Lakeview Academy  
psly = Lyndon Academy  
pssv = St. Vincent's Academy  
pstr = Stratford Academy  


EBSCO
psfs = FULTON SCIENCE ACADEMY PRIVATE SCHOOL, ns012089
psfu = FURTAH PREPARATORY SCHOOL, ns237820
psgc = GEORGIA CHRISTIAN SCHOOL, s8830322
pswf = WHITEFIELD ACADEMY, ns159499
tcsg = TCSG ECAMPUS (GALILEO), ns327679
psff = FULLINGTON ACADEMY, s6318004
pshs = HOLY SPIRIT PREPARATORY SCHOOL, ns015679
psla = LAKEVIEW ACADEMY, s8830296
psly = LYNDON ACADEMY, ns309757


ProQuest
psfs = Account 209043 - Fulton Science Academy Tier (1)
psfu = Account 160062 - Furtah Preparatory School Tier (1)
psgc = Account 209046 - Georgia Christian School Tier (1)
pswf = Account 137385 - Whitefield Academy-GA Tier (1)
tcsg = Account 209494 - TCSG eCampus Tier (1)
  • 202110_EBC_Add_inst.csv
Edited by Brad Baxter