Team Roster Migration from Google Docs

[rachelwhaley]

Overview

Team rosters are currently maintained in Google Docs, and will soon be managed in VRMS via the Project Team Member collection in our database.

Action Items

• Bonnie to collect all roster columns into a single doc for analysis
• Rachel to check that all columns are represented in the User and Project Team Member schemas
• Need to decide what date to put as the "joined date" since none of the Google Doc records have that. @ExperimentsInHonesty can we pull a join date from when we added them to our Github maybe? Or should we just default it to whatever date we export from the Google Doc?
• Build a single master roster document for that purpose (we can add people to this roster document during any lag time in the cutover period, until we can add people directly in VRMS)
• Identify the "cut-over" period (when we'll export the Google Docs and upload them into our DB)
• Upload data to Project Team Member collection in MongoDB
• QA the data and make sure the queries bring expected results (e.g., query for all VRMS team members, etc.)

Resources/Instructions

• Research best way to combine sheets & export (one idea here)
• Research best way to go from spreadsheet to MongoDB (data formatted correctly, fields labeled clearly, etc.)

[rachelwhaley]

Created data mapping, several questions to resolve before migrating data.

[ExperimentsInHonesty]

@rachelwhaley

1. Progress - has speed up the process a bit
2. Blocks - having difficulty getting the google api for sheets working to combine the rosters, could use help
3. Availability - have time, just blocked
4. ETA - can do it manually within a day (45 min of processing time)

New member Nick is going to take a look.

[nickbeaird]

I think that I am starting to get a handle on what I am looking at here now. I see that @rachelwhaley created a document, which is great. I am not yet able to see it. I guess my first question would be will this data be used in Google Sheets continually, or is this a one time migration? Well regardless, feel free to ping me Rachel and I can take a look as well.

[ExperimentsInHonesty]

1. Progress: Script done, just finishing
2. Blockers: none
3. Availability: evenings only
4. ETA: Thursday

[rachelwhaley]

Progress: no update from last week. Will address this week.

[rachelwhaley]

1. Progress: completed python script that combines rosters from all Google docs into a single doc. Can post it to the repo if anyone else needs to use it.
   Blockers, availability, ETA: See Connect and populate Projects and Team Members #124

[jbubar]

This will be managed by P Depot in the future. I advise to close, but would like to have the rest of the team take a look first

[jbubar]

@JackHaeg will bring this up with bonnie if he gets the chance. otherwise we have other issues that are already tracking team roster features