agents_yml_from_sheet

To get agent information from a Google Sheet, where it is easier to edit, and convert to yml.

During the metadata blitz, we crowd-sourced the organizations from which AEDG derives its data. To avoid changing formats or copy pasting all the fields, this script was written to transfer info from the Google Sheet we populated into the YAML file in the registry.

I expect to only use this script once, and to maintain the YAML file as the source of truth going forward ELD 4/22/2025

Functions

hack_fix(filename)	Fix yaml file so it can be read back in like a normal file.
main()	Grab the data and write it out with some contextual notes.

Module Contents

agents_yml_from_sheet.hack_fix(filename)

Fix yaml file so it can be read back in like a normal file. I do not understand why, but writing the YAML file is sticking in a “|” that causes it to be read in as a big long string, not a YAML file. So strip out that one line.

Parameters:

filename (pathlib.Path)

Return type:

None

agents_yml_from_sheet.main()

Grab the data and write it out with some contextual notes.

Return type:

None