Jesus Franco tzkmx

https://claude.ai/public/artifacts/f6ac67c1-783e-48ab-9326-bae384b0ede8

Planner: Script de Prueba de Integración — Fórmulas Google Sheets (Escáner de Cajas)

Contexto del Proyecto

Propósito del sistema

Herramienta operativa para conteo físico de inventario. Un operador escanea cajas una por una. Cada escaneo introduce un identificador en la columna B de la hoja activa. Las fórmulas en esa misma hoja validan en tiempo real si la caja existe en el sistema ERP y si ya fue escaneada previamente.

Origen de datos

Analysis of Moodle Dashboard Embedding Capabilities

This document summarizes the investigation into embedding custom JavaScript applications within a Moodle dashboard, showing the initial analysis and the final conclusion based on live testing.

Initial Analysis (Based on HTTP Headers and HTML)

No Content-Security-Policy (CSP): The HTTP headers for the Moodle page were missing a Content-Security-Policy (CSP) header. A CSP header is the primary browser-level mechanism to control which external resources (like scripts) can be loaded. Its absence suggested that loading external scripts would be possible.
HTML Sanitization Appears Minimal: An initial test of adding a simple HTML block with <div> and <h3> tags was successful, indicating that Moodle's own sanitization was not overly aggressive.

GEMINI Best Practices for Project Interaction

This document outlines a set of best practices for AI models when interacting with user projects. Adhering to these guidelines is critical for ensuring safety, consistency, and a productive collaboration.

1. Core Principles

User is the Priority: The user's instructions and feedback are the most important source of truth. If there is any ambiguity, ask for clarification rather than making an assumption.
Safety First: Never perform destructive actions (e.g., deleting files, modifying critical infrastructure) without explicit confirmation from the user. Always explain the potential impact of such actions before proceeding.
Clarity is Key: If the user's intent is unclear, ask for clarification. It is better to ask a question than to proceed with a wrong assumption.

	[CmdletBinding()]
	param()

	#--------------------------------------------------------------------------------
	# UTILITY: ConvertTo-SpanishLongDate
	# PURPOSE: Finds all cells in all tables containing only a date in dd/MM/yyyy
	# format and converts it to a long Spanish date string.
	# - Years before 2000 use "de" (e.g., 12 DE FEBRERO de 1989).
	# - Years 2000 and after use "del" (e.g., 24 DE SEPTIEMBRE del 2025).
	#--------------------------------------------------------------------------------


	function Invoke-ArchivedHistory {
	[CmdletBinding()]
	param (
	[string]$Pattern,
	[string]$HistoryFilePath = "$env:USERPROFILE\Scripts\session_history.csv"
	)

	if (-not (Test-Path $HistoryFilePath)) {
	Write-Error "History file not found: $HistoryFilePath"

	description = "Limpiar texto de folio corrigiendo errores y formato, preservando íntegramente frases y formalidades sin resumir ni reinterpretar."

	prompt = """
	Recibirás un texto extraído mediante OCR que puede contener errores de reconocimiento.
	1. Corrige únicamente errores evidentes de ortografía y gramática, sin alterar el orden ni la literalidad de las frases.
	2. Elimina encabezados repetitivos, números de página y elementos ajenos al cuerpo del documento que no formen parte del acta o escritura.
	3. Unifica párrafos que pertenezcan a la misma idea, pero nunca fusiones, modifiques, resumas, sintetices ni reinterpretes ningún acuerdo, párrafo o frase.
	4. Considera como frases protegidas (whitelist) las siguientes, que deben conservarse tal cual y en su posición original, aunque tengan variaciones menores por errores de OCR:
	- “Previo el receso necesario…”, “Previo el receso de… minutos…”, “Se reanudó la sesión…”, “Se continuó con el siguiente punto del orden del día…”, “Acto conti

	Public Sub GenerarSoloConFormato()
	Call AutoCorrectListFormatted(True)
	End Sub

	Public Sub GenerarListaAutocorreccion()
	Call AutoCorrectListFormatted(False)
	End Sub

	Private Sub AutoCorrectListFormatted(Optional soloConFormato As Boolean = False)
	Dim a As AutoCorrectEntry

	The Artistic License 2.0
	Copyright (c) 2000-2006, The Perl Foundation.
	Everyone is permitted to copy and distribute verbatim copies of this license document, but changing it is not allowed.
	Preamble
	This license establishes the terms under which a given free software Package may be copied, modified, distributed, and/or redistributed. The intent is that the Copyright Holder maintains some artistic control over the development of that Package while still keeping the Package available as open source and free software.
	You are always permitted to make arrangements wholly outside of this license directly with the Copyright Holder of a given Package. If the terms of this license do not permit the full use that you propose to make of the Package, you should contact the Copyright Holder and seek a different licensing arrangement.
	Definitions
	"Copyright Holder" means the individual(s) or organization(s) named in the copyright notice for the entire Package.
	"Contributor" means any party that has contributed code or oth

	/* eslint-disable @typescript-eslint/no-non-null-assertion */
	function set(
	obj: Record<string, any>,
	path: string[] \| string,
	value: unknown,
	): void {
	if (typeof path === 'string') {
	path = path.split(/[\.\[\]]/).filter(Boolean);
	}

	FROM gguf

	PARAMETER model-file gemma-3b-it-Q4_K_M.gguf