skills.rest
ha-giwan1203
ha-giwan1203COMMUNITY
Explore all skills by this author →
GitHub

mes-production-upload

Automates BI production data upload to MES via SaveExcelData.do API with validation and duplicate checks.

Updated Jul 23, 2025
Search Tags:#automation#production#api#etl#data-upload#mes#bi-excel
One-click install
npx skills add https://github.com/ha-giwan1203/GIWANOS_AgentOS --skill mes-production-upload
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: mes-production-upload
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/production-result-upload
Command: npx skills add https://github.com/ha-giwan1203/GIWANOS_AgentOS --skill mes-production-upload

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, requests, playwright.

What problem does it solve?

This Skill automates the end-to-end process of extracting BI production data and uploading it to MES via the SaveExcelData.do API, removing manual Excel-to-MES steps and reducing errors.

Core Features & Use Cases

  • Automated extraction from BI Excel files and direct POST to MES SaveExcelData.do.
  • End-to-end automation covering BI refresh, data validation, duplicate checks, and upload verification.
  • Use Case: daily MES production data upload for Daewon Tech lines, ensuring consistency between BI and MES.

Quick Start

Upload yesterday's BI production data to MES for Daewon Tech.

Frequently Asked Questions about mes-production-upload

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

FAQPage Schema
How do I automate MES production data uploads from BI Excel files?▼

MES production data uploads from BI Excel files are automated by extracting data and directly POSTing it to the MES SaveExcelData.do API, eliminating manual Excel-to-MES data entry steps and reducing errors.

How does the SaveExcelData.do API handle duplicate checks and data validation during an upload?▼

The SaveExcelData.do API upload process handles data validation and duplicate checks by verifying data consistency before the transfer and confirming the upload results directly within the automated MES workflow.

Can I use Playwright and openpyxl to extract and upload production data to MES?▼

Yes, you can use Playwright and openpyxl to extract BI production data and upload it to MES, as these dependencies support BI data extraction, browser automation, and direct API session management.

What is the best way to handle authentication when posting daily production data to MES?▼

The best way to handle authentication when posting daily production data to MES is through optional OAuth or session management, ensuring secure and robust direct API calls during the automated data transfer.

Why does my automated MES data upload fail when transferring daily production data across multiple lines?▼

Automated MES data uploads may fail due to data validation errors or duplicates across different lines, but the built-in robust error handling verifies results after the upload to identify and resolve transfer issues.

Related Skills

Explore More Data & Analytics Skills→
Science-DiscoveryScience-Discovery
71

Excel Analysis

Automate Excel data analysis and visualization with pandas, openpyxl, and matplotlib.

Official
Intermediate
ha-giwan1203ha-giwan1203

night-scan-compare

Compare MES night-shift scan results with BI production data via API.

Community
Advanced
TurnaboutHeroTurnaboutHero
12

playwright-master

Automate browser testing and web scraping with Playwright across Chromium, Firefox, and WebKit.

Community
Intermediate
ha-giwan1203ha-giwan1203

d0-production-plan

Automate ERP D0 production instruction uploads for SP3M3 and SD9A01 workflows.

Community
Advanced