skills.rest
Briian3306
Briian3306COMMUNITY
Explore all skills by this author →
GitHub

verification-pasadas-files

Compares toll pasadas rows in Supabase against source CSV and Excel files for date mismatches.

Updated Jan 31, 2023
Search Tags:#supabase#excel#csv#postgres#data reconciliation#read-only audit#date verification
One-click install
npx skills add https://github.com/Briian3306/Transporte --skill verification-pasadas-files-briian3306
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: verification-pasadas-files
Source: https://github.com/Briian3306/Transporte/tree/main/ibarra-app/.agents/skills/verification-pasadas-files
Command: npx skills add https://github.com/Briian3306/Transporte --skill verification-pasadas-files-briian3306

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? After importing toll passage (pasadas) data from ConsumosResumen Excel or Telepase CSV files, dates and key fields can end up wrong in the database. This Skill provides a safe, read-only workflow to reconcile production pasadas rows against the original source files and report only real mismatches. ## Core Features & Use Cases - Read-only reconciliation: Compares fecha_hora and key fields (patente, pase, factura, estación, precio) between source files and the DESARROLLO Supabase project without any writes. - Timezone-safe comparison: Converts Excel serial dates and CSV strings to UTC wall-clock, avoiding the common false 3-hour offset caused by local-time parsing. - Threshold-based reporting: Reports only mismatches above a configurable time delta (default 4 minutes), filtering out sub-minute noise. - Use Case: After a wizard load of ConsumosResumen-202607-1.xlsx, verify that every row's fecha_hora in the pasadas table matches the Excel Fecha column, and get a table of only the rows that differ by more than 4 minutes. ## Quick Start Verify the pasadas loaded from the file ConsumosResumen-202607-1.xlsx against the DESARROLLO database and report any fecha_hora mismatches over 4 minutes.

Frequently Asked Questions about verification-pasadas-files

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

FAQPage Schema
How do I verify pasadas data against an Excel file in Supabase?▼

Filter pasadas rows by file_upload_name with a read-only SQL query joining patentes, pases, documentos, and estaciones, then compare each row's fecha_hora against the Excel Fecha column converted to UTC wall-clock. Report only differences above the 4-minute threshold.

How to convert Excel serial dates to UTC for database comparison?▼

Convert the Excel serial with Math.round((serial - 25569) * 86400 * 1000) and format using UTC getters, never browser-local methods. For text timestamps, force UTC by parsing with a Z suffix instead of letting the engine assume local time.

Why do all rows show a 3-hour difference when comparing dates?▼

This happens when Date.parse treats a timestamp string as local time (ART, UTC-3) instead of UTC. Always force UTC parsing, for example with Date.parse on a string ending in Z, so the comparison matches the UTC wall-clock stored in fecha_hora.

Can this verification workflow fix wrong fecha_hora values in production?▼

No, the workflow is strictly read-only and never runs UPDATE, DELETE, db push, or migration repairs. Fixing production fecha_hora values requires explicit write authorization and a separate change process.

Why does the UI show a different date than the database for pasadas?▼

The Angular date pipe shifts UTC timestamps to browser local time, displaying them 3 hours behind in ART. The UI must use formatUtcDateTime from peajes-fecha.util.ts to render fecha_hora as UTC wall-clock.

Related Skills

Explore More Software Engineering Skills→
Rafael-2109Rafael-2109

lendo-arquivos

Parse Excel and CSV files into structured JSON for agent analysis.

Community
Advanced
kurojskurojs
2

judgment-day

Run blind dual adversarial code reviews with re-judging until approval or escalation.

Community
Advanced
git-taogit-tao

timezone-safety

Enforce consistent UTC handling across code, databases, and APIs.

Community
Basic
JYeswakJYeswak

sheets-reconciliation

Compare a sheet range against its source of truth and report mismatches with cell-level citations.

Community
Intermediate