Florian von Bracht gitfvb
👋
gitfvb
/ backup.ps1
Created
February 6, 2020 09:14
Daily backup and cleanup for folders in PowerShell
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ################################################ | |
| # | |
| # SETTINGS | |
| # | |
| ################################################ | |
| $foldersToBackup = @( | |
| "D:\Apteco\Publish\holidays\private" | |
| "D:\Apteco\Publish\holidays\public" |
gitfvb
/ aachen_postal_codes.txt
Last active
May 18, 2023 14:08
Overpass Turbo queries with http://overpass-turbo.eu/
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| area["name"="Aachen"][boundary=administrative]->.myarea; | |
| rel(area.myarea)["boundary"="postal_code"]; | |
| out geom; |
gitfvb
/ loop_inserts.sql
Last active
December 9, 2019 12:02
Outline to page through MSSQL inserts (especially helpful for big joins)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* Drop temporary table if exists */ | |
| DROP TABLE IF EXISTS #CommTestefd5adf666914ec88906066cdcf4de1f | |
| /* Create a temporary table */ | |
| CREATE TABLE #CommTestefd5adf666914ec88906066cdcf4de1f | |
| ( | |
| [Id] [int] NOT NULL, | |
| [Urn] [sql_variant] NULL, | |
| [StepId] [int] NULL, | |
| [StateId] [int] NULL, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <# | |
| based on this example from: https://jwt.io/ | |
| https://stackoverflow.com/questions/30246497/using-statement-for-base64urlencode | |
| https://medium.com/@nikitafed9292/net-base64-decoding-workaround-82b797162b6e | |
| https://blog.angular-university.io/angular-jwt/ | |
| https://gist.github.com/kucukkanat/1ef77db8120323db2b89087735ef8a5d | |
| #> | |
| ################################################ |
gitfvb
/ base64.ps1
Created
November 1, 2019 10:31
Base64 String converting in PowerShell because some frameworks trim the "=" at the end
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # source of functions: https://medium.com/@nikitafed9292/net-base64-decoding-workaround-82b797162b6e | |
| # Add missing "=" at the end | |
| Function Check-Base64 { | |
| param( | |
| [Parameter(Mandatory=$true)][String]$inputString | |
| ) | |
| $input |
gitfvb
/ read_wsdl.ps1
Last active
October 29, 2019 09:47
first try to read and parse SOAP wsdl in powershell
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $wsdlUrl = "https://soap.flexmail.eu/3.0.0/flexmail.wsdl" | |
| $wsdlContent = Invoke-RestMethod -Method Get -Uri $wsdlUrl -Verbose | |
| # metadata | |
| $targetNamespace = $wsdlContent.definitions.targetNamespace | |
| $bindingStyle = $wsdlContent.definitions.binding.binding.style | |
| # operations (different ways) | |
| $operations1 = $wsdlContent.definitions.binding.operation |
gitfvb
/ unix-timestamp.ps1
Created
October 21, 2019 13:47
PowerShell function to create a unixtimestamp (seconds or milliseconds since 1970)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Function Get-Unixtime { | |
| param( | |
| [Parameter(Mandatory=$false)][switch] $inMilliseconds = $false | |
| ) | |
| $multiplier = 1 | |
| if ( $inMilliseconds ) { | |
| $multiplier = 1000 |
gitfvb
/ 00__create_settings.ps1
Last active
October 18, 2019 20:24
encrypt and decrypt parts of xml via powershell
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ################################################ | |
| # | |
| # SCRIPT ROOT | |
| # | |
| ################################################ | |
| # Load scriptpath | |
| if ($MyInvocation.MyCommand.CommandType -eq "ExternalScript") { | |
| $scriptPath = Split-Path -Parent -Path $MyInvocation.MyCommand.Definition |
gitfvb
/ 00__create_settings.ps1
Last active
October 18, 2019 09:42
Check EpiServer output before uploading
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ################################################ | |
| # | |
| # SCRIPT ROOT | |
| # | |
| ################################################ | |
| # Load scriptpath | |
| if ($MyInvocation.MyCommand.CommandType -eq "ExternalScript") { | |
| $scriptPath = Split-Path -Parent -Path $MyInvocation.MyCommand.Definition |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ################################################ | |
| # | |
| # SCRIPT ROOT | |
| # | |
| ################################################ | |
| # Load scriptpath | |
| if ($MyInvocation.MyCommand.CommandType -eq "ExternalScript") { | |
| $scriptPath = Split-Path -Parent -Path $MyInvocation.MyCommand.Definition |