CoolFace
Apppublic

MohammadAli-production/solvei8-sewing-wip-rpa

sourceHugging Facemitupdated 6mo agoView on Hugging Face
0likes
App README

Solvei8 RPA v26 — Daily Sewing WIP + Finishing Final QC QC Report Automation

Automated RPA tool for downloading and processing two reports from Solvei8 Analytics in a single job run:

  1. 1.Daily Sewing WIP Report
  2. 2.Daily Finishing Final QC QC Report

✅ What's New in v26 (vs v25)

FixDetails
New Report AddedDownloads "Daily Finishing Final QC QC Report" raw Excel file in same job run
Dual Select AllClicks BOTH "Select All" buttons (Shifts + Lines) in the Finishing QC modal
Date-first SelectionSelects date first, then Select All — same proven order as WIP report
Raw File SavedFinishingQC_DATE_TS_RAW_ORIGINAL.xlsx added to output file list
5 Output Files4 WIP files + 1 Finishing QC raw file per run
Everything v25 UnchangedAll WIP report logic, session handling, paths identical to v25

✅ What Was in v25 (still applies)

FixDetails
No Persistence RequiredRemoved all Chrome profile / persistent storage usage
Fresh Session Every RunChrome starts clean — no profile lock, no second-run timeout
Per-run Download DirEach run gets its own /tmp/solvei8/downloads/<timestamp>/ — no file collision
/tmp pathsAll working dirs use /tmp/solvei8/ — always writable, no mount needed

Features

  • —✅ Downloads Daily Sewing WIP Report (same as v25 — unchanged)
  • —✅ Downloads Daily Finishing Final QC QC Report (NEW in v26)
  • —✅ Fresh login every run — no stale session errors
  • —✅ Department filter auto-clear — handles filtered report page
  • —✅ Date-first selection — correct modal interaction order for both reports
  • —✅ WIP Summary Excel — two columns: Line (1–28 + Pilot Line 01) and WIP quantity
  • —✅ Live streaming log
  • —✅ Custom date picker
  • —✅ No persistent storage needed — works on free HF tier

Setup

1. Create the Space

2. Upload Files

Upload all 4 files: Dockerfile, app.py, requirements.txt, README.md

3. Set Secrets

Secret nameValue
SOLVEI8_USERNAMEYour Solvei8 username
SOLVEI8_PASSWORDYour Solvei8 password
GEMINI_API_KEYYour Gemini API key (optional)

4. ⚠️ Do NOT Enable Persistent Storage

Output Files Per Run (5 total)

FileDescription
SewingWIP_Summary_DATE_TS.xlsxWIP Main output — Line + WIP two-column summary
SewingWIP_DATE_TS_RAW_ORIGINAL.xlsxWIP raw downloaded file from Solvei8
SewingWIP_DATE_TS.xlsxSession log + raw data combined
SewingWIP_DATE_TS.csvCSV export of WIP raw data
FinishingQC_DATE_TS_RAW_ORIGINAL.xlsxNEW — Finishing Final QC QC raw file

How the Finishing QC Download Works (v26)

After completing the WIP Report download, the RPA:

  1. 1.Navigates back to the reports page
  2. 2.Searches for "Daily Finishing Final QC QC Report" (multi-layer TreeWalker/JS/XPath)
  3. 3.Opens the report modal
  4. 4.Selects the target date
  5. 5.Clicks BOTH "Select All" buttons (Shifts + Lines)
  6. 6.Clicks "Download EXCEL"
  7. 7.Saves raw file as FinishingQC_DATE_TS_RAW_ORIGINAL.xlsx

Version History

VersionFix
v26Dual report mode. Added Finishing Final QC QC Report download. Dual Select All. All v25 logic unchanged.
v25No persistence mode. Chrome profile removed. /tmp paths. Per-run download dir.
v24DLDIR cleared. cleardepartment_filter rewritten.
v23Date selected BEFORE Select All. Angular disabled=false fix.
v22WIP Summary two-column format.

Troubleshooting

Login fails: Check SOLVEI8_USERNAME and SOLVEI8_PASSWORD secrets.

Download timeout: Site may be slow — tool waits 120s per file. Try again.

Finishing QC not found: Report name must be exactly "Daily Finishing Final QC QC Report" on the reports page.

Only WIP downloaded: Check log for FQC- prefixed step entries to diagnose the Finishing QC failure.