Menu
Runbook for template ingestion (DOCX/HTML), Excel header generation, and file linking in colegios.
Installer avec Codex ou Claude Copiez ce prompt, collez-le dans Codex, Claude ou un autre assistant, puis laissez-le vérifier la page du skill et l'installer pour vous.
Basé sur la classification professionnelle SOC
| name | colegios-templates-excel-pdf |
| description | Runbook for template ingestion (DOCX/HTML), Excel header generation, and file linking in colegios. |
Standardize DOCX/HTML template handling, Excel header generation from placeholders, and surfacing per-row file URLs.
word/document.xml.{{...}}).pandocservices/api:
playwright (Chromium)pandocxlsx (Excel generation)pandoc and Playwright Chromium:
npx playwright install --with-deps chromiumGET /v1/templates/:id/excel?organizationId=...&role=ADMIN
.xlsx with header row = placeholders.GET /v1/template-groups/:id/excel?organizationId=...&role=ADMINGET /v1/batches/:id/requests-detail
items[] with { index, row, request: { id, pdfUrl, docxUrl } }GET /v1/batch-groups/:id/requests-detail
items[] with { index, row, requests: [{ templateName, pdfUrl, docxUrl }] }pdfUrl / docxUrl are relative (/v1/files?...); UI must prefix with apiBase.Descargar Excel de carga button uses /excel endpoints (template or group).nombre -> no, apellido -> ap, cedula -> ce, email -> em, celular -> cel.requests-detail and displays per-row links; always prefix with apiBase./excel routes must be matched before list routes. (Use pathOnly === "/v1/templates" etc.)PATCH /v1/templates/:id with status=inactive for templates in use.Database evolution runbook for the colegios project. Use when changing Prisma models, adding fields, introducing new tables, or adjusting relationships to ensure additive migrations, data preservation, and a persistent change log from local development.
Runbook for Colegio MVP lessons learned. Use when setting up local Docker Compose, fixing Prisma/openssl in containers, generating migrations/seed data, or deploying on VPS/Coolify with Traefik labels and network configuration.
Envio de PDFs por registro del Excel hacia OmniSwitch/Firmalo con el flujo de 4 pasos (crear solicitud, cargar documento, registrar firmante, disparar envio). Usar cuando se necesite integrar el pipeline de firma en el proyecto colegios, especialmente al procesar lotes y generar un envio por cada request.
Runbook for multi-template groups (max 4) in colegios: DB models, API endpoints, UI flow, and batch processing.