Import official_volunteering_url from "Official volunteering opportunities" on Counties

[alexmv]

County data aligns well between staging and Airtable, except the "Official volunteering opportunities" column, which is empty in VIAL. We should import that; we have the official_volunteering_url for it.

[alexmv]

I don't see a current import script for counties? I assume all of the metadata must have gotten in somehow, though.

[simonw]

Good catch. County imports are a little odd at the moment - it's an admin tool, available only to is_superuser accounts, at this address: https://vial-staging.calltheshots.us/admin/tools/

It's manual because you have to go and generate a limited-time-only GitHub JSON export URL and paste it in there.

If we're going to switch to editing counties in VIAL directly there's no need to automate this. If we're going to stick with Airtable for that we should set this up as an automated task.

[simonw]

Good news: it's in our County model already:

vial/vaccinate/core/models.py

Line 101 in 9cec7c8

official_volunteering_url = CharTextField(null=True, blank=True)

[simonw]

That fixed it. I've run in staging:

https://vial-staging.calltheshots.us/admin/core/county/1/change/

Will deploy to and run in production.