Visualize then Realize (TM)
14 06, 2021

T-SQL Bulk editing XML field

2021-06-14T07:48:50+02:00Giugno 14th, 2021|Programming|

TSQL Bulk editing XML field XML fields in MS SQL Server are powerful yet cumbersome; the script below, albeit its limitations, manages effortless insertions, updates and deletions of a simple one level deep XML fragment. Let's see how it works: the function receives two XML fragments, the first [...]

20 01, 2020

Fill DOCX with XML data using Powershell

2020-02-20T04:38:04+01:00Gennaio 20th, 2020|Programming|

Fill DOCX with XML data using Powershell Given a Microsoft DOCX document ("template") sprinkled with @@<tag> constructs, and, XML data that includes elements <tag>, the script below makes a copy of template and replaces, preserving style, the @@<tag> occurances with the XML element contents. The XML data may be [...]

28 02, 2019

RS485 Modbus RTU relay board with PowerShell

2019-03-13T17:06:27+01:00Febbraio 28th, 2019|Programming|

RS485 Modbus RTU relay board with PowerShell Serial comunication with a 4 Channel RS485 Modbus RTU relay board via a universal USB - RS485 dongle using PowerShell. Relevant links: https://unserver.xyz/modbus-guide/ https://www.tanzolab.it/R41A08 https://github.com/Erriez/R421A08-rs485-8ch-relay-board Write-Host "Available ports:" ([System.IO.Ports.SerialPort]::getportnames()); $COM = "COM4"; $SLAVE_ID = 0x03; # Append 2 byte MODBUS-16 CRC [...]

28 11, 2006

Tecniche di programmazione e il mondo Travian

2018-12-11T06:28:57+01:00Novembre 28th, 2006|Programming|

Tecniche di programmazione e il mondo Travian Inizio 2006 ho scoperto uno dei tanti MMOG (Massive Multiplayer Online Game) in rete, www.travian.it; un gioco di strategia dove: “…combatterai con migliaia di altri utenti. Tutti avranno un unico e solo obiettivo, sviluppare il loro piccolo villaggio e portarlo alla massima [...]

Torna in cima