Skip to content

Instantly share code, notes, and snippets.

Avatar
Enjoying a fresh cup of tea...

Frank Corso fpcorso

Enjoying a fresh cup of tea...
View GitHub Profile
@fpcorso
fpcorso / helpscout-api-to-csv.py
Last active Feb 23, 2021
Download conversations from a Help Scout mailbox and save as CSV file
View helpscout-api-to-csv.py
"""
Download conversations from a Help Scout mailbox and save to CSV file.
Be sure to replace the App ID and Secret in the authorization call as well
as the Mailbox ID in the conversations API call.
Python: 3.9.0
"""
import csv
@fpcorso
fpcorso / domain-search.py
Last active Sep 14, 2020
Site Crawl - Domain Search
View domain-search.py
# Script: Site Crawl - Domain Search
# Author: Frank Corso
# Date Created: 09/14/2020
# Last Modified: 09/14/2020
# Python Version: 3.6.5
# Crawls a supplied url (hopefully your own) and searches for instances of links to a different supplied domain.
# i.e. Crawls site on https://example-one.com looking for any links to example-two.com.
# Avoid crawling for a link that is in your header or footer as this will capture all of those too.
# To run, use `python domain-search.py` and then supply the site to be crawled in `https://example-one.com` format.
@fpcorso
fpcorso / customer-license-calculations.py
Last active Sep 10, 2020
EDD Customer License Calculations
View customer-license-calculations.py
# Script: EDD Customer License Calculations
# Author: Frank Corso
# Date Created: 04/06/2020
# Last Modified: 07/21/2020
# Python Version: 3.6.5
# Takes exports of licenses from EDD and turns it into a CSV of customers with total number of licenses,
# total number of sites, active licenses, and total active sites. This is meant as a stepping stone for
# further analysis.
# To use, have CSVs of licenses for each download in EDD in a 'licenses' directory with each
@fpcorso
fpcorso / license-calculations.py
Last active Sep 10, 2020
EDD Per Download License Calculations
View license-calculations.py
# Script: EDD Per Download License Calculations
# Author: Frank Corso
# Date Created: 04/05/2020
# Last Modified: 07/16/2020
# Python Version: 3.6.5
# Takes exports of licenses from EDD and turns it into a CSV of totals and averages.
# To use, have CSVs of licenses for each download in EDD in a 'licenses' directory with each
# saved as edd-export-licenses-(download-slug).csv
# Put this script above that directory. In terminal, run python license_calculations.py
@fpcorso
fpcorso / plugin-reviews.py
Last active May 23, 2020
WordPress Plugin Reviews Scraper
View plugin-reviews.py
# Script: WordPress Plugin Reviews Scraper
# Author: Frank Corso
# Date Created: 08/16/2019
# Last Modified: 05/23/2020
# Python Version: 3.6.5
# There are waits built in to avoid putting strain on the wp.org servers.
# However, any amount of scraping adds to server load.
# So, please avoiding running this script on plugins with lots of reviews
# and try to only run this script once and not on any repeating schedule.
@fpcorso
fpcorso / Contract Killer 3.md
Created Jan 28, 2019 — forked from malarkey/Contract Killer 3.md
The latest version of my ‘killer contract’ for web designers and developers
View Contract Killer 3.md

Contract Killer

The popular open-source contract for web professionals by Stuff & Nonsense

  • Originally published: 23rd December 2008
  • Revised date: March 15th 2016
  • Original post

@fpcorso
fpcorso / wordcamp-sessions-xml-to-csv.py
Last active Jan 14, 2019
WordCamp Sessions XML to CSV
View wordcamp-sessions-xml-to-csv.py
# Converts an XML generated from exporting
# sessions on a WordCamp site to a CSV file
# Use CMD/Powershell/Terminal to enter:
# python wordcamp-sessions-xml-to-csv.py
import xml.etree.ElementTree as ET
import csv
# Get the filenames
file_name = input("What is the XML file to convert? ")