[NoBrainer] Connecting Enterprise Architect Interfaces with PowerShell

Enterprise Architect ProvidedInterface

In one of our projects we needed to create a lot of components that expose interfaces. The steps to design this in EA are quite tedious: Link the Interface to the diagram of our component. Create a ProvidedInterface and attach it to the component Set the name of the ProvidedInterface to the name of the […]

Extracting RTF Documents from XMI Files with PowerShell

XMI Base64 Encoded ZIP

Enterprise Architect allows you to create custom document templates to be used in your reports. Internally EA uses the oldie-goldie RTF document format for these templates. When exporting these templates via Export Reference Data they are included as base64 encoded zipped RTF documents which in turn are again base64 encoded. For the untrained eye it […]

[NoBrainer] Automating Sparx Enterprise Architect with PowerShell

Enterprise Architect Class Diagram

It has been some time since I have last posted something on our blog, so I will start with something easy: today I made the switch from Sparx Enterprise Architect v13.5 to v14.0. And yes, it really paid off since I now can actually decipher all those small connector icons on my Surface Book 2 […]

[HOWTO] Send Mails and Create Calendar Entries with the Office365/Exchange 2016 REST API using PowerShell

After playing around with the Office 365/Exchange 2016 REST API I decided to summarize the knowledge and the experiences I gained in this blog post. The goal of the tryout session was to check out the Outlook endpoints for messages and calendars. To be more precise, I wanted to try out the following features. Reading […]

[HOWTO] Adjust Outlook Web App Session Timeout

Today my boss asked me to extend the session lifetime for Outlook Web App to have a lower login frequency. As described in the article Session timeouts for Office 365 the session timeout is set to 6 hours by default. To change the session timeout the following steps have to be executed. Connect to Exchange […]

[HOWTO] Access Azure File Share in PowerShell Script executed by a Scheduled Task

Last week I had to set up an Azure File Share for data transfer purposes. Clients will upload data to the Azure File Share and the data will then be moved from the share to a local drive by a PowerShell script. The PowerShell script gets invoked every 15 minutes by a Scheduled Task. The […]

[HOWTO] Access Microsoft Access Database with PowerShell

In one of our current projects we had to access a Microsoft Access Database (.mdb) with PowerShell. I first tried to access the .mdb using the Invoke-SqlCmd Cmdlet from our PowerShell module biz.dfch.PS.System.Data. Unfortunately connecting to the Access database with the Invoke-SqlCmd Cmdlet does not work as it uses SqlClient from the C#/.NET namespace System.Data […]

Get NetworkCredential from PSCredential splits Username into Username and Domain

During development of a PowerShell binary module I had to do deal with two different credential types (System.Management.Automation.PSCredential and System.Net.NetworkCredential) and came across a behaviour I wanted to write down. The PowerShell binary module I developed contains several Cmdlets. One of them defines a parameter of type System.Management.Automation.PSCredential. Inside the Cmdlet we need to have […]

[NoBrainer] Start-Sleep takes longer that it seems

While doing some tests with our new TraceListener and log server I did some tests where I wanted to find out how long the log server would take to start accepting messages. So I started to constantly send messages from the console: When I looked at the server logs I noticed that the arriving messages […]

How to Write a PowerShell Binary Module – revisited

Module Configuration Variable

Recently I started writing a PowerShell binary module in C# (mainly due to facilitate testing and move away from Pester limitations). In this post I will describe the format of our PowerShell module and the format of the respective Cmdlets, plus logging and testing integration. My first attempt was to create a module for Abiquo […]