Thoughtful Solutions, Creatively Implemented and Communicated thoughtful-solutions

JSON to CSV

jq provides a tool for processeding JSON files, in a similar manner to sed

Proccessing JSON files to CSV

 jq '.daily.calls | input_filename + "," + @csv' *.json  \
    |  sed -e 's/^"\([a-z7]*\)\-\([0-9]*\).json/\"\2,\1/'  \
    | sed -e 's/\"//g' > test.csv

Azure Congnative Search

Azure Cognative Search is a search tool capable of ingesting and searching a number of data formats including Office and JSON documents.

The service is currently under development and marked as preview This means that the azure CLI does not provide all the tooling you might wish and you are required to post some configuration pieces using curl or similar.

Build Search Service

The free tier of service (SKU) is limited in the size of the documents it can handle.

Blob Triggered Functions

Create the Azure Resources

mti-example provides a function to load JSON files into a storage container satrigger000sc FaaS-on-Azure.md gives an example
mti-satrigger provides a function which is triggered every time the storage container is updated

  az account set --subscription "Free Trial"
  az storage account list -o table
  az group create --name satrigger000rg --location westeurope

Azure AD authentication in Azure Functions

Create a Resource Group

  az group create --name mtidns000rg --location "ukwest"

Create a DNS Zone

  az network dns zone create -g mtidns000rg --name mtifl.considrd.dev

At this point you'll have to go do your name service provider and repoint your NS records and SOA records to the name servers inside azure

FaaS-on-Azure

Setting up the Desktop Environment

On Windows

iwr -useb get.scoop.sh | iex

Then

Windows Desktop

ANSI/VT Console behaviour

Windows 10 and Windows 11 default console behaviour is to ignore ANSI/VT escape sequences

   Set-ItemProperty HKCU:\Console VirtualTerminalLevel -Type DWORD 1

Scoop.sh

Construct hugo

$ mkdir src
$ cd src
$ git clone https://github.com/gohugoio/hugo.git
$ go build --tags extended
$ cp ~/go/bin/hugo ~/.local/bin
$ hugo version
Hugo Static Site Generator v0.68.0-DEV/extended linux/amd64 BuildDate: unknown

GraphViz

Intro to graphviz

	# OS VMs
	It is often needed for the testing of ideas the ability to construct VMs on demand.
	[Boxcutter](https://github.com/boxcutter) provides such a service.

	## Using on Windows-10
	The key item to having boxcutter working on windows-10 is to have [Scoop.sh](https://scoop.sh] installed and to have GnuMake installed
	as well as the packer tools.

	## example buid
	'''