search

sul-dlss / FOLIO-Project-Stanford

Task management for Stanford’s analysis of FOLIO.
2 stars 0 forks source link

Export Business items circ data from Symphony #656

Closed dlrueda closed 1 month ago

dlrueda commented 3 months ago

Our circ_stats table never had items with library=BUSINESS added to it. Do one dump from Symphony data of these items, provide to Irina so she can add to Tableau tables with this historical circ data.

dlrueda commented 3 months ago

columns catkey | callseq | itemseq | year_quarter | itemid | num_charges | num_inhouse | library | last_chrg_date | item_type | home_loc | curr_loc |

tsv format needed year_quarter can be either 202402 or 202303 if Irina prefers (that was the last year/quarter we dumped from Symphony right before migration to FOLIO). I asked her

dlrueda commented 3 months ago

Counts: sirsi@bodoni /s/SUL/Users/dlrueda>cat business-items.dat | wc -l 29358 sirsi@bodoni /s/SUL/Users/dlrueda> grep "|0|0|BUSINESS|0|" business-items.dat | wc -l 17826 sirsi@bodoni /s/SUL/Users/dlrueda> grep -v "|0|0|BUSINESS|0|" business-items.dat | wc -l 11532

not sure if we should bother with items that have never been charged or have an in-house use

dlrueda commented 3 months ago

Ended up only including items that had >0 charges or >0 in-house uses. Ignored last charge date column.

Supplied tsv file of data to "external data for metadb" folder https://drive.google.com/drive/u/0/folders/0AECU7QPdkC4sUk9PVA