upload-r1
CommunityIngest R1 XLSX data into ReturnPro staging.
Authorclenisa
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Uploads R1 reverse-logistics XLSX files into ReturnPro's financial staging tables. The R1 export is parsed using WASM-based calamine (fast XLSX parser without ExcelJS overhead), rows are aggregated by master program, and results are upserted into stg_financials_raw for FP&A.
Core Features & Use Cases
- Ingest R1 XLSX files parsed with WASM/calamine; upsert aggregated results into stg_financials_raw keyed by month and master_program_id.
- Resolve program names to dim_master_program.id via fuzzy matching, and validate accounts using dim_account to ensure data integrity.
- Log ingestion activity and errors to observability dashboards for auditing and troubleshooting.
Quick Start
Provide the path to the R1 XLSX file and the target month to ingest data into ReturnPro staging.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: upload-r1 Download link: https://github.com/clenisa/optimal-cli/archive/main.zip#upload-r1 Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.