Adding Institutions

DESC People DB add institutions: https://srs.slac.stanford.edu/GroupManager/exp/LSST-DESC/protected/administration/administration.jsp

Latex conversion via python

pip install pylatexenc

>>> from pylatexenc.latexencode import unicode_to_latex  
>>> print(unicode_to_latex('C.P. 37150, León'))


Latex Name and Street Address in latex format

Keeping Institution Names without accents since DB can't really handle it.

Looking up institution addresses using arxiv


Fixing null user_ids in PROFILE_UG table

UPDATE PROFILE_UG p SET USER_ID = (SELECT USERNAME from UM_MEMBER_USERNAME mem where mem.MEMIDNUM = p.MEMIDNUM) WHERE p.USER_ID is null AND p.EXPERIMENT='LSST-DESC';

after creating back up of PROFILE_UG table

Hoping to avoid this by making sure the Confluence user_id is set BEFORE the MC approves a new standard member



Confluence usernames are stored in UM_MEMBER_USERNAME



  • No labels