listi.net

Check Routine

A check routine typically checks and waits for something to occur

Types

Check and wait for data arrival or task completion. Ex. Co-worker updates remedy CRQ

Check the data in Jira and extract info and report missing data

Check the status of something on a webpage

Ex. CheckDailyPostReview

This routine is looking for a file on SharePoint and opens it.

If the file isn't there it retries in 30 minutes

Or it can be to check data to look for errors

Get the data

Check it for some issues with the data

Report the data via an email

CheckForLabeled Epics

Assumptions

Pivot3 sheet contains the stories and Epics filtered on showing only the Epics

There release date corresponds to the date of the data

This is related to Jira, where each Epic needs a Label in a specific format to link it to a deployment event.

There is a sheet that my process generates called Pivot3 which is created by

Finding all Jira stories for the release date

Doing a Pivot Table to get the Epics for the stories.

CheckifNewDE

We need the date for the release as input which comes in from a Range [Main!the_release_dt]

Lessons/Knowledge needed

Rester for Jira retrieval

String processing (Instr, Mid, lStart, lEnd)

Error handling

Arrays

quoted string using """ three "

Flags

For loop

Array processing using LBound, Ubound and Split

formatting of dates using Format(vDate,"yyyy.mm.dd")

Steps

On this sheet we go to cell B4 which is where the headers are for the sheet because it's the output from a pivot table.

The data is assumed to be filtered with the blank values for the Epic to be hidden. So we process each filtered row until we reach the end of the data

We use a row variable i to go through each row.

The Epic is retrieved from the row in column 4 and is hardcoded
I'm not sure why but the field sometimes has "ul" which means there isn't an epic on the story so these records are skipped
A Rester Call is made to get the Jira data associated with the Epic
From the returned data which is in some sort of standard Python format with JSON format
I'm extracting data related to the assignee (whose working on the Jira) their email address. Need to handle case where the email is missing
I extract the "labels" field. Note there is a trick to get the " by using """ or 3 quotes
The labels can have multiple values so I need to load the data to an array and split it by "," comma
Calls a routine the checkForLabelsPart2

Check Jira Evidence

Goto a sheet (Upcoming 2) which has a list of Epics in column

Ask the user if it is okay to run for a date.

Step through the rows and build a list of epics separated by ","

CheckforProperReleaseKeyLink()

CheckforR2R
R2R = Ready to release.

Assumes I have a sheet General_report that has downloaded Jira data for a release

MissingAit

CheckTextForDups

CompareText

FindSheetDifferences