Case Study: Dynamically Update ‘My Published Medium Articles’ on a Content Management System

Pushing CSV content into a Content Management System

In the previous two case studies, I showed an automation script that extract articles titles from Medium (dynamic load page) and store them in a CSV file.

This article wraps up by creating a web page list all articles (drafts or published) by a Medium author.

Test Design

1. Login to Medium account, pass authentication manually
2. Go to a Drafts tab, and scroll down until the end is reached
3. Extract article title, last edited time and word count for each draft story
4. Process the data and save it to a CSV file
5. Repeat for ‘Published’ articles.
6. Read from CSV file, construct a HTML page with all article titles (with links), update a web page on a Content Management System.

A Content Management System is a web hosting platform that serves web page. In this exercise, I will use SiteWise CMS.

Steps

1. Preparation

Start a Chrome browser session from executing a test case in TestWise;
Log in (manually)
Enter TestWise Debugging mode
Keep scrolling down to show all stories
Extract data and save it to a CSV file