search

usap-dc-dev / usap-dc-website

repository for usap-dc website. Includes javascript client side app and python/flask server side.
2 stars 0 forks source link

update harvest_nsf_awards.py to use nsf award list from config file instead hard coded one #34

Closed fnitsche2001 closed 5 months ago

fnitsche2001 commented 11 months ago

the current script harvest_nsf_awards.py uses an award file from nsf that is hard coded in the script. It is easy enough to change the hard coded one, but if I change this in production it might cause some confusion in Git. It would be better practice to get the final name from somewhere else, e.g. it could be listed in the config file. Also, the current version uses a tab separated file. Switching this to csv might be easier since csv files could be exported more easily form the Excel files we get from NSF. (We have to see, if the new program officer is actually providing these files in the future and in which form)

fnitsche2001 commented 7 months ago

As of 2024 we are not getting the spreadsheet/tab-limited file from NSF anymore. We used the additional information from the NSF PO to determine the lead award for multiple awards. NSF has updated the workflow and collaborative awards have now consecutive award numbers and the lowest (first) number is the lead award. The script should be updated to reflect these changes.