Apteco PS Modules - PowerShell logging script Execute commands like Write-Log -message "Hello World" Write-Log -message "Hello World" -severity ([LogSeverity]::ERROR) "Hello World" | Write-Log The logfile getting written looks like 20210217134552 a6f3eda5-1b50-4841-861e-010174784e8c INFO Hello World 20210217134617 a6f3eda5-1b50-4841-... More info

Apteco PS Modules - Framework This module allows Apteco, partners and customers to develop their own integrations. This framework brings lots of useful features with it like - Logging + Send information to Orbit UI - Standardised settings management saved in json files - Update upward compatibility when there are new features and setting pos... More info

Apteco PS Modules - PowerShell functions extension This function helps to gather all parameters that a function/cmdlet has except the common parameters like -verbose etc. This can be used to extend existing functions/cmdlets with more scripting and possibly additional parameters. So in this example you see how it works ```PowerShell ... More info

Script to install dependencies from the PowerShell Gallery and NuGet. It is possible to install scripts, modules and packages. The packages can be installed from the PowerShell Gallery and packages from a NuGet repository. Packages can defined as a raw string array or as a pscustomobject with a specific version number. Please make sure to have the... More info

Apteco PS Modules - PowerShell security encryption module Execute commands like "Hello World" | Convert-PlaintextToSecure to get a string like 76492d1116743f0423413b16050a5345MgB8AEEAYQBmAEEAOABPAEEAYQBmAEYAKwBuAGQAegBxACsASQBRAGIAaQA0AEEAPQA9AHwANAAxAGEAYQBhADAAYwA3ADQAYwBiADkAYwAzADEAZgBkAGUAZQBkADQAOABhADIAMgA5AGUAMAAyADkANwBiADcAMQA... More info

Script to import dependencies from the PowerShell Gallery and NuGet. Please make sure to have the Modules WriteLog and PowerShellGet (>= 2.2.4) installed.

Apteco PS Modules - PowerShell unix timestamp conversion Converts a [DateTime] into a numeric unix timestamp as [UInt64] and vice versa. To get a unix timestamp from a [DateTime]::Now or (Get-Date) just do it like in these examples Get-Unixtime Get-Unixtime -InMilliseconds Get-Unixtime -InMilliseconds -Timestamp ( Get-Date ).AddDays(-2) ... More info

Apteco PS Modules - PowerShell merge Hashtable This module merges two hashtables into one. It is able to handle nested structures like hashtables, arrays and PSCustomObjects. Please see the examples below. Just use ```PowerShell $left = [hashtable]@{ "firstname" = "Florian" "lastname" = "Friedrichs" "address" = [hashtable]@... More info

Apteco PS Modules - PowerShell oAuth Support of oAuth v2 in PowerShell! This module allows the oAuth flow to create your first api token for Microsoft Dynamics, Salesforce, CleverReach and much more... We support redirect urls to local urls `http://localhost:54321` and app urls (handled via registry) `apttoken://localhost`. The local url is ins... More info

Apteco PS Modules - PowerShell file rows count Just use Measure-Rows -Path "C:\Temp\Example.csv" or "C:\Temp\Example.csv" | Measure-Rows -SkipFirstRow or Measure-Rows -Path "C:\Temp\Example.csv" -Encoding UTF8 or even "C:\Users\Florian\Downloads\adressen.csv", "C:\Users\Florian\Downloads\italian.csv" | Measure-Rows -SkipFirs... More info

Apteco PS Modules - PowerShell String Conversion Multiple functions to convert strings, e.g. to change the encoding or to hash a string - Replace-Tokens - Get-StringHash - Convert-StringEncoding - Get-RandomString Please have a look at the help of the functions for more information or the github repository

Apteco PS Modules - PowerShell merge PSCustomObject This module merges two PSCustomObjects into one. It is able to handle nested structures like hashtables, arrays and PSCustomObjects. Please see the examples below. Just use ```PowerShell $left = [PSCustomObject]@{ "firstname" = "Florian" "lastname" = "Friedrichs" "address"... More info

Apteco PS Modules - PowerShell Notify This module allows you to trigger messages via email, Telegram, Slack and Teams. You can use the channels separated from each other or combined as a group, when you want to inform via multiple different channels.

Apteco PS Modules - PowerShell WebRequest UTF8 Helpful function for APIs, that return UTF8 encoded content, but PowerShell does not recognize it as UTF8 encoded. So it reads the content and converts it straight into UTF8 via [Text.Encoding]::UTF8.GetString($response.RawContentStream.ToArray())

Apteco PS Modules - Wrapper for SimplySQL

This script is used to switch off or switch on some data sources in FastStats Designer to allow a build with only a few tables (like customer data) and then later do a bigger build with customer and transactional data. This example just changes the behaviour of the extract options and saves it in the same xml SyncExtractOptions -DesignFile "C:\Ap... More info

Apteco PS Modules - OpenStreetMaps Geocoding - Geocode your addresses through OpenStreetMaps - Much more to follow... Your help is appreciated. Just contact me.

Apteco PS Modules - PowerShell Credentials Test This module tests your credentials like # Interactive mode -> this one requests your user and password, uses the current user as default Test-Credential # Define User and password beforehand $c = Get-Credential Test-Credential -Credentials $c OR $c = Get-Credential Test-Credential -... More info