Advanced Scripting for Testers: Local Data, Spreadsheets, and Reporting

Course details

Your program might be passing all the tests, but what more can you glean from your results? Your test results can hold—and sometimes, even hide—valuable insights that you could be extracting and sharing with larger teams. In this course, instructor Dave Westerveld offers an overview of advanced scripting skills for testers, including local data processing, spreadsheets, and test reporting. Explore the essentials of processing local data generated from testing, working with the Google Charts and Sheets APIs, and creating and managing reports with HTML, PDFs, email, Slack, Excel, and Python. By the end of this course, you’ll be prepared to wield your new skills to find and distribute your testing results more effectively.

Concepts

0. Introduction

01 - Smarter testing through scripting
02 - What you should know

1. Working with Local Data

03 - Running command line programs
04 - Capturing stdout and stderr
05 - Running a program from Python
06 - Interacting with files
07 - Running a web server locally
08 - Parsing a log file
09 - Challenge - Find the error in the logs
10 - Solution - Find the error in the logs

2. Working with Spreadsheets

11 - Scripting Excel
12 - Reading data from Excel
13 - Writing data to Excel
14 - Challenge - Create a test report in Excel
15 - Solution - Create a test report in Excel
16 - Setting up a Google service account
17 - Interacting with Google Sheets
18 - Reading data from Google Sheets
19 - Writing data to Google Sheets
20 - Challenge - Consolidate multiple data sources
21 - Solution - Consolidate multiple data sources

3. Scripting Test Reports

22 - Using HTML templates
23 - Creating charts
24 - Challenge - Creating an HTML report
25 - Solution - Creating an HTML report
26 - Working with PDFs
27 - Challenge - Creating a PDF report
28 - Solution - Creating a PDF report

4. Sending Test Reports

29 - Sending emails
30 - Emailing a test report
31 - Integrating with Slack
32 - Posting a report to Slack
33 - Challenge - Build and send a report
34 - Solution - Build and send a report

Conclusion

35 - From course to action