translation-base-seed-sync

Synchronizes WinForms translation keys into a base JSON seed and SQL script block.

Updated Aug 24, 2026
One-click install
npx skills add https://github.com/aggutierrez98/TP-TD --skill translation-base-seed-sync-aggutierrez98
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: translation-base-seed-sync
Source: https://github.com/aggutierrez98/TP-TD/tree/main/.agents/skills/translation-base-seed-sync
Command: npx skills add https://github.com/aggutierrez98/TP-TD --skill translation-base-seed-sync-aggutierrez98

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve? Keeping UI translation keys, the base language JSON seed, and the database seed script in sync is error-prone manual work. This Skill scans WinForms UI, BLL, and SERVICIOS code for translatable keys and regenerates the seed artifacts automatically. ## Core Features & Use Cases - Automatic Key Discovery: Scans Form*.cs files, Designer files, and BLL/SERVICIOS code for Form, Dialog, and Error translation keys, including Tag assignments and ObtenerTexto calls. - Seed JSON Regeneration: Updates translation-seeds/base.es.json as the single source of truth, preserving existing translations and inserting placeholders for new keys. - SQL Block Generation: Rewrites the auto-generated block in script_bd.sql so the database seed loads translations from the JSON file via OPENROWSET instead of hardcoded values. - Use Case: After adding a new button with a Form... Tag to a WinForms screen, run the sync script, fill in the new placeholder values in base.es.json, and compile the solution. ## Quick Start Ask the assistant to run the translation base seed sync script and review any new placeholder keys added to base.es.json.

Frequently Asked Questions about translation-base-seed-sync

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

FAQPage Schema
How do I sync WinForms translation keys with a SQL database seed?▼

Run the sync-i18n-base-seed.ps1 PowerShell script from the repository root. It scans UI, BLL, and SERVICIOS code for Form, Dialog, and Error keys, updates translation-seeds/base.es.json, and regenerates the auto-generated block in script_bd.sql.

How to add new translation keys to a WinForms application?▼

Add the key in your UI or service code using a Form..., Dialog..., or Error... prefix, then run the sync script. New keys appear in base.es.json with the key itself as a placeholder value, which you then replace with the real Spanish text.

Can I edit the auto-generated block in script_bd.sql manually?▼

No, the block between the BEGIN and END AUTO-GENERATED I18N BASE SEED markers must not be edited by hand. All changes flow from base.es.json through the sync script, which is the only supported way to regenerate that block.

Why does running script_bd.sql with sqlcmd ODBC 15.x fail silently?▼

sqlcmd ODBC 15.x stops processing silently with exit code 0 when it reaches the !! line, leaving the database without translations. Run the script from SSMS 19/22 in SQLCMD Mode or via setup-database.ps1, which strips the !! line from a temporary copy.

What is the source of truth for base language translations?▼

The file translation-seeds/base.es.json is the single source of truth for the base Spanish language. The SQL script only references it via OPENROWSET, and all key types including Dialog, Error, Warning, Confirm, Success, and Grid keys belong in that JSON file.