Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add existing groups mapping to COLD #56

Open
tmorrell opened this issue Jan 21, 2025 · 2 comments
Open

Add existing groups mapping to COLD #56

tmorrell opened this issue Jan 21, 2025 · 2 comments
Assignees
Milestone

Comments

@tmorrell
Copy link
Member

tmorrell commented Jan 21, 2025

Take data from Kathy's spreadsheet https://docs.google.com/spreadsheets/d/1RoCDCMY0nPhPLemaR_tWF0bnlKpPjmNs/edit?usp=sharing&ouid=113414142686600778780&rtpof=true&sd=true as well as data from https://github.com/caltechlibrary/irdm_harvester/blob/main/group_tagging.csv and add to the new COLD groups field

@rsdoiel
Copy link
Member

rsdoiel commented Mar 4, 2025

NOTE TO SELF: I need to have the regular division/people/group report update only the group name(s) and clgid(s) list. Other information is useful for human evaluation but should not be taken as authoritative.

@rsdoiel
Copy link
Member

rsdoiel commented Mar 4, 2025

The SQL to update each record should use json_patch() to update the src JSON column for _key.

@rsdoiel rsdoiel added the enhancement New feature or request label Mar 4, 2025
@rsdoiel rsdoiel added this to the 0.1.0 milestone Mar 4, 2025
@rsdoiel rsdoiel removed the enhancement New feature or request label Mar 4, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants