SHIFT-WIKI - Sjoerd Hooft's InFormation Technology
This WIKI is my personal documentation blog. Please enjoy it and feel free to reach out through blue sky if you have a question, remark, improvement or observation. See below for the latest additions, or use the search or tags to browse for content.
How To use a Public MS Team
Summary: How to setup and configure a public Microsoft Teams team
Date: Around 2019
Refactor: 22 March 2025: Checked links and formatting.
Recently I wanted to create a Release Calendar team. End users had to be able to subscribe to the release calendar team themselves, I needed a way to send all subscribers an email and interested subscribers should be able to receive all Release Calendar events in their calendar as well. Read below on how this works in Microsoft Teams.
Proxy Pac
Summary: A basic proxy pac script to manage your internal network for outgoing and intranet network traffic.
Date: Around 2014
Refactor: 22 March 2025: Checked links and formatting.
If you've created a proxy server you can create an automatic proxy script so your users don't have to turn off the proxy for internal addresses and it's easier to make changes.
PowerShell: Convert Excel File to CSV with Special Delimiter
Summary: Or actually, save an excel file as CSV and then recreate it with a specific delimiter
Date: Around 2013
Refactor: 22 March 2025: Checked links and formatting.
cd "D:\filedir\" $Excel = New-Object -ComObject Excel.Application $Excel.visible = $false $Excel.DisplayAlerts = $False $file = "D:\filedir\excelfile.xlsx" $csv = "D:\filedir\excelfile.csv" $csvfinal = "D:\filedir\excelfilefinal.csv" $workfile = $Excel.Workbooks.open($file) $Sheet = $workfile.Worksheets.Item(1) $Sheet.Activate() $Sheet.SaveAs($csv,[Microsoft.Office.Interop.Excel.XlFileFormat]::xlCSVWindows) $workfile.Close() sleep 5 $Excel.Quit() [System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel) Import-Csv $csv | Export-Csv $csvfinal -Delimiter ";" -NoTypeInformation