Littlefield simulation tools

Scrape, save, load, and report data from Littlefield factory simulation, using Google Cloud Functions, Scheduler, and BigQuery.

Options:

Load data to an existing BigQuery table

Automatically post snapshot reports and useful charts to Discord

Examples:

Daily Report:

Demand Chart:

Utilization Chart:

Standings Chart:

Requirements:

• Existing Google Cloud Project
• Existing Google BigQuery dataset
• Existing Discord Webhook(s)

To Run:

Part 1: Set Up Clound Function

Step 1: Create a Google Cloud Function (1st gen) with an HTTP trigger, with the following runtime environment variables:

• GROUP_ID: Group/team name
• GROUP_PW: Group/team password
• CLASS_URL: Littlefield login page url
• GCP_PROJECT_ID: Google Cloud Project ID
• BIGQUERY_DATASET_NAME: Google BigQuery Dataset name
• DISCORD_REPORT_WEBHOOK: Discord webhook url for quick report
• DISCORD_EXCEL_WEBHOOK: Discord webhook url for updated excel files
• DISCORD_DEMAND_UTIL_WEBHOOK: Discord webhook url for demand and utilization charts
• DISCORD_STANDINGS_WEBHOOK: Discord webhook url for standings chart

Step 2: Set runtime to Python 3.11+ and entry point to main

Step 3: Copy main.py and requirements.txt to function code

Step 4: Deploy the function

Step 5: Copy Trigger URL for use with Google Cloud Scheduler

Part 2: Set Up Cloud Scheduler

Step 1: Create a Google Cloud Scheduler job

Step 2: Set desired job run frequency using a cron expression

Step 3: Set the Target type to HTTP and copy the Trigger URL as the execution URL

Step 4: Copy the following into the body ('avg' = desired period count for discord report moving averages)

{
  "bigquery_factory": true,
  "bigquery_standings": true,
  "bigquery_settings": true,
  "discord_report": true,
  "discord_demand_chart": true,
  "discord_util_chart": true,
  "discord_standings_chart": true,
  "discord_excel": true,
  "avg": 5
}

Step 5: Adjust the parameters based on desired usage

Step 6: Create the job

Success!

...hopefully. Please let me know if you have any issues.