annaddicks / toastmasteragenda Goto Github PK

Sheets.go is now fetching an old spreadsheet. Update the spreadsheet on this line

service.FetchSpreadsheet("1_P9K2asfsITSGEAh7PrPLxncSemNnjXHg3_O3q7OW0k/")

to reference the new one located here:
https://docs.google.com/spreadsheets/d/1CBlORqCzL6YvyAUZTk8jezvhyuDzjjumghwGKk5VIK8/edit?usp=sharing. Use 1CBlORqCzL6YvyAUZTk8jezvhyuDzjjumghwGKk5VIK8

This issue has been created for a participant the "Commit To Open Source Today!" talk at We Rise Women in Tech Conference.

I need the documentation added to README.md something along the lines of:

• To change google docs sheets make sure your sheet is publicly readable with a link.
• Copy the highlighted spreadsheet identifier found on the shareable link: https://docs.google.com/spreadsheets/d/1_P9K2asfsITSGEAh7PrPLxncSemNnjXHg3_O3q7OW0k/edit?usp=sharing and add it to file Sheets.go. For my Google Spreadsheet it is 1_P9K2asfsITSGEAh7PrPLxncSemNnjXHg3_O3q7OW0k.

README.md needs to add a new header section on how to build this project. Under how to build, it needs go version 1.7.4 or higher. It also needs to demonstrate client_secret.json. Repeat what Iwark says in https://github.com/Iwark/spreadsheet/tree/v2#preparation in our docs.

A JokeMaster has been added to the Agenda. This means the Readme.md needs to be updated. Under form layout two things need to change:

1. Add a new row for Joke Master right after Toastmaster of the day (row # 3).
2. Add 1 to each row after this new row. Example: General Evaluator is now row # 4

I need the following documentation added to README.md:

• Add the format expected from the the way the google document is laid out. The document can be found here: https://docs.google.com/spreadsheets/d/1_P9K2asfsITSGEAh7PrPLxncSemNnjXHg3_O3q7OW0k/edit?usp=sharing

For example, line one is the date, line two is the Toastmaster of the Day, etc. If you can, copy and paste the way the cells look.

This issue has been created for a participant the "Commit To Open Source Today!" talk at We Rise Women in Tech Conference.

The Google Spreadsheet was changed to remove the whitespace rows. The README.md file needs to be updated to reflect this change. Rows 8, 17, 19, 21 need to be removed and the row numbers updated.

• Change code to pass date in as a parameter
• Add test to make sure the passed in object is correctly converted into the date string.

Main.go will also need to be updated to call the method with a parameter.