Page History

...

• This is running now fine. Or was there still something to be fixed with sort1 field and stat_cat?
  
  • Sort1 and Sort2 are free to be used as wished, at least MPKK uses them for some special needs.
  • Stat_cat goes to a column of its own. Checkbox in asiakasmääreet. It's a multiple value field, so it's in an additional table. pseudonymized_borrower_attributes
    
    • chat about this: https://kansalliskirjasto.slack.com/archives/CRAQWTEKD/p1640195825034200?thread_ts=1640171769.029700&cid=CRAQWTEKD
  • Clean-ups:
    • ticket:

      Jira
      server Kansalliskirjaston JIRA serverId f77f19b3-0866-3dd6-97a9-e424355d78c1 key KOHA-228

       
    • we need to clean up borrowernumbers from Sort1 field for some libraries (that happened to be filled Sort1 there since Voyager)
    • also, we need to clean up pseudonymized_transactions rows which contain insecure Sort1 which already went into pseudonymized_transactions table.
  • Useful info about differences across libraries with "STAT_CAT" settings: 
    • in details this text from that chat, STAT_CAT, what checkboxes are set for different libraries:
      
      • 3amk:
        • multiple values per patron (and data in DB for that!)
      • arcada:
        
        • searchable
      • arkisto:
        • searchable
      • diak:
        • searchable
        • multiple values per patron (and data in DB for that!)
      • fikka:
        • searchable
        • multiple values per patron (and data in DB for that!)
      • hamk:
        • searchable
      • hanken:
        • searchable
        • multiple values per patron (and data in DB for that!)
      • humak:
        • searchable
        • multiple values per patron (and data in DB for that!)
      • jyu:
        • searchable
        • multiple values per patron (and data in DB for that!)
      • mpkk:
        • no STAT_CAT field at all
      • stat:
        • searchable
        • multiple values per patron (NO multiple values in DB though)
      • varasto:
        • searchable
      • xamk:
        • searchable
      • centria:
        • searchable
      • tritonia:
        • searchable
        • mandatory
    • outstanding are:
      
      • MPKK: because nothing (no STAT_CAT at all),
      • Tritonia: STAT_CAT set as mandatory,
      • 3AMK: STAT_CAT set as "not searchable",
      • All others: some libraries have "multiple values" enabled, some don't.
    • 3AMK had cases where a customer has two stat_cats. Can Extra stat can be done deleted by changing Patron attribute types->STAT CAT->Mandatory: "Check to make this attribute mandatory when creating or editing a patron". Take it off for a while, clean patron information and put setting back.
      
      • Changing settings - may have affected Tuudo, but not sure. Anyway fixed by Tuudo people.
      • does this 3AMK-multiple stat_cats closed / not require Andrii/devs participation?

...