daily-routine

Automate ZDM daily checks and MES production uploads with Python.

Updated Jul 23, 2025
One-click install
npx skills add https://github.com/ha-giwan1203/GIWANOS_AgentOS --skill daily-routine-ha-giwan1203
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: daily-routine
Source: https://github.com/ha-giwan1203/GIWANOS_AgentOS/tree/main/90_%EA%B3%B5%ED%86%B5%EA%B8%B0%EC%A4%80/%EC%8A%A4%ED%82%AC/daily-routine
Command: npx skills add https://github.com/ha-giwan1203/GIWANOS_AgentOS --skill daily-routine-ha-giwan1203

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, requests.

What problem does it solve?

This integration solves the tedious manual work of performing daily ZDM inspections and uploading MES production data by combining them into one automated script, reducing missed entries and human errors.

Core Features & Use Cases

  • Automated ZDM daily inspection entry for SP3M3 (19 checks) and automatic correction for missing days, excluding Sundays.
  • MES production data upload and validation across target dates with retry logic and pre-upload BI data synchronization.
  • Use Case: A plant operator sets up a daily job to automatically verify ZDM records and push MES data, ensuring consistent daily metrics without manual intervention.

Quick Start

Run the daily-routine script to execute ZDM checks and MES uploads for the current business day.

Frequently Asked Questions about daily-routine

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate daily ZDM inspections and MES production data uploads?

To automate daily ZDM inspections and MES production uploads, the script combines both tasks into one scheduled job that performs morning checks and end-of-day pushes automatically. It handles 19 SP3M3 checks and coordinates ZDM API with MES HTTP services.

Do I need Python openpyxl and requests to run MES data upload automation?

Yes, you need Python with the openpyxl and requests libraries installed to run this MES data upload automation. These dependencies handle Excel file operations and coordinate HTTP interactions with ZDM and MES services.

Can I schedule automated ZDM daily checks to skip Sundays?

Yes, automated ZDM daily checks can be scheduled to skip Sundays. The script applies KST scheduling across weekdays and automatically corrects missing entries for skipped or missed days.

What is the best way to validate MES production data before uploading?

The best way to validate MES production data before uploading is using a script with built-in retry logic and pre-upload BI data synchronization. This verifies target dates and syncs data before the MES HTTP upload executes.

How does automated ZDM daily inspection handle missing days?

Automated ZDM daily inspection handles missing days by applying automatic correction logic. The scheduled task identifies gaps in SP3M3 records and backfills missing daily entries, excluding Sundays from the checks.