The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,860 other subscribers

Archive for the ‘XML’ Category

dutch-sepa-iso20022/camt.053.001.02.xsd at master · jasperkrijgsman/dutch-sepa-iso20022

Posted by jpluimers on 2026/03/12

Just in case I ever need to work with the CAMT.053 XML format for bank statements: [Wayback/Archive] dutch-sepa-iso20022/camt.053.001.02.xsd at master · jasperkrijgsman/dutch-sepa-iso20022

It is part of the repository [Wayback/Archive] jasperkrijgsman/dutch-sepa-iso20022: SEPA PAIN.001.001.003.

Via (which has more links to how various banks interpret these rules: yes, as usual they have different interpretations of standards) [Wayback/Archive] “urn:iso:std:iso:20022:tech:xsd:camt.053.001.02” – Google Search

Related:

–jeroen

Posted in Banking, Development, LifeHacker, Power User, Software Development, XML, XML/XSD, XSD | Leave a Comment »

msxml – Error when loading valid Windows-1252 document “System error: -2146697210” – Stack Overflow

Posted by jpluimers on 2026/02/04

Yes, I know that Windows XP SP3 and Windows 7 SP1 have been end-of-life for a long time, but in the wild they are still being used so here is for posterity:

[Wayback/Archive] msxml – Error when loading valid Windows-1252 document “System error: -2146697210” – Stack Overflow (thanks [Wayback/Archive] Rob Kennedy for the comment):

Read the rest of this entry »

Posted in .NET, Delphi, Development, History, Power User, Software Development, Windows, Windows 7, Windows Development, Windows XP, XML, XML/XSD | Leave a Comment »

A Friendly Introduction to SVG • Josh W. Comeau

Posted by jpluimers on 2026/01/07

SVG can be beautifully crafted XML representing vector graphics with full support for CSS while also supporting raster graphics. [Wayback/Archive] A Friendly Introduction to SVG • Josh W. Comeau explains how you can do that.

Note that in practice most tools generate horrible SVG and CSS.

Via [Wayback/Archive] I finally get how SVGs work – YouTube

--jeroen


[Wayback/Archive] I finally get how SVGs work – YouTube

Posted in Development, Software Development, SVG, Web Development, XML, XML/XSD | Leave a Comment »

Windows event log querying from the command line: wevtutil (with XPath query parameters and XML output)

Posted by jpluimers on 2025/04/23

A while ago, I needed to investigate reboot events on some Windows 10 systems. I wanted to use the console instead of the eventvwr GUI Event Viewer.

There is a tool for that called wevtutil which – like eventvwr – uses XPath query parameters and produces XML output.

Postprocessing XML can be a thing, but since .NET has great XML support, you can use PowerShell for that (which for me often is way easier than going the XSLT route, for instance because Windows lacks built-in console XSLT tooling).

Based on the help and the below links, my query command then on these machines turned out to be this: Read the rest of this entry »

Posted in Batch-Files, CommandLine, Development, PowerShell, PowerShell, Scripting, Software Development, XML, XML/XSD, XPath, XSLT | Leave a Comment »

Enabling XML Auto Commenting C# in Visual Studio Code is in an odd setting (via Stack Overflow)

Posted by jpluimers on 2025/03/18

In Visual Studio Code I already had [Wayback/Archive] C# – Visual Studio Marketplace: C# for Visual Studio Code (powered by OmniSharp) installed in (through code --install-extension ms-dotnettools.csharp), and wanted automatic XML documentation comments generation just like Visual Studio does:

[Wayback/Archive] XML documentation comments – document APIs using /// comments | Microsoft Learn

Read the rest of this entry »

Posted in .NET, C#, Development, Hardware, Java, Java Platform, Keyboards and Keyboard Shortcuts, KVM keyboard/video/mouse, Power User, Software Development, XML, XML/XSD | Tagged: , , , , , | Leave a Comment »

Updated monthly after the 8th day of the month – Welcome to the BAG: The Dutch Building and Addresses database – Bert Hubert’s writings

Posted by jpluimers on 2025/01/17

[Wayback/Archive] Welcome to the BAG: The Dutch Building and Addresses database – Bert Hubert’s writings

Bert made a test page for it too: [Wayback/Archive] berthub.eu/pcode/2513AA/14 (postal code for “Binnenhof”)

And a repository: [Wayback/Archive] GitHub – berthubert/bagconv: Convert Dutch building/dwelling administration into a simpler format

The BAG (Basisregistratie Adressen en Gebouwen) information, which is maintained by the Dutch Kadaster (Cadastre), allows bug reporting, which is processed remarkably quickly: [Wayback/Archive] Postcode + huisnummer niet uniek in Emmen? – Datasets / BAG – Geoforum

Via: [Wayback/Archive] bert hubert 🇺🇦🇪🇺: “I’ve updated my conversion of the official Dutch address, postcode, building database (BAG) with the July 2024 release. Description in English, API, code, CSV files can be found on …” – Fosstodon

--jeroen

Posted in C++, Database Development, Development, Software Development, SQLite, XML, XML/XSD | Leave a Comment »

How to extract playlists (list of file locations) from iTunes using python – Stack Overflow

Posted by jpluimers on 2024/12/18

While migrating from iTunes on one machine to Apple Music on another one, I needed to migrate part of the (disorganised) playlists.

I knew there was a binary ~/Music/iTunes/iTunes Library.itl file, but that is encoded or encrypted, making it hard to parse.

Luckily there is also ~/Music/iTunes/iTunes Music Library.xml which I found via the links below.

Read the rest of this entry »

Posted in Apple, Development, iTunes, Mac OS X / OS X / MacOS, Power User, Python, Scripting, Software Development, XML, XML/XSD | Leave a Comment »

HTML / XML / RSS link checker – Visual Studio Marketplace

Posted by jpluimers on 2022/10/04

On my list of Visual Studio Code extensions to try (after I change the shortcuts, as direct Alt shortcuts are not a good idea, luckily those are configurable)

[Wayback/Archive.is] HTML / XML / RSS link checker – Visual Studio Marketplace (partly paraphrased):

VSCode extension that checks for broken links in an HTML, XML, RSS, PHP, or Markdown file.

Checks currently open file:

  • for broken links in anchor-href, link-href, img-src, and script-src tags in currently-open HTML or PHP file
  • both clearnet and onion (Tor) links
  • for badly-formatted mailto links, and duplicate local anchors (anchor-name, anchor-id)
  • for working HTTPS equivalents of HTTP links

Optionally checks for invalid characters and common mistakes (missing tag content, empty attribute value, more).

Also checks for errors in a small subset of semantic HTML tags (in HTML and PHP files): checks that each page has header, main, footer; checks that each heading is inside a section, article, or aside; checks that each section/article/aside has exactly one heading in it; checks that heading values are nested properly.

To see/change settings for this extension, open Settings (Ctrl+,) / Extensions / “HTML / XML / RSS link checker”.

To change the key-combinations for this extension, open File / Preferences / Keyboard Shortcuts and search for Alt+H or Alt+T or Alt+M or Alt+L.

–jeroen

Posted in .NET, Development, HTML, Lightweight markup language, MarkDown, Power User, RSS, Software Development, vscode Visual Studio Code, Web Development, XML, XML/XSD | Leave a Comment »

.NET: XML escaping a string

Posted by jpluimers on 2022/02/15

[Wayback] WILT: XML encode a string in .net « Benoit MARTIN’s Weblog:

Always wondered why I couldn’t find a method that would XML encode a string, effectively escaping the 5 illegal characters for XML. There is such a method but its location in the API is not intuitive at all. It’s in the System.Security namespace: [Wayback] SecurityElement.Escape(String) Method (System.Security) | Microsoft Docs

public static string? Escape (string? str);

Its usage is:

   tagText = System.Security.SecurityElement.Escape(tagText);

This will escape the 5 characters <, >, &, " and '

–jeroen

Posted in .NET, Development, Encoding, Software Development, XML, XML escapes, XML/XSD | Leave a Comment »

Getting the path of an XML node in your code editor

Posted by jpluimers on 2021/05/27

A few links for my link archive, as I often edit XML files (usually with different extensions than .xml, because historic choices that software development vendors make, which makes it way harder to tell editors “yes, this too is XML).

–jeroen

Read the rest of this entry »

Posted in .NET, Development, Notepad++, Power User, Software Development, Text Editors, Visual Studio and tools, vscode Visual Studio Code, XML, XML/XSD | Leave a Comment »