Steve Withington stevewithington

Powershell: Create/Add Windows System DSN via `.CSV` Import

You can create/add/update/get a Windows System DSN pretty easily with Powershell.

Example `dsn.csv` file

Database, SystemDSN, Server
AAA, AAA_DSN, SomeIP\User

Brew Bundle Brewfile Tips

Copyright & License

Unless otherwise noted (either in this file or in a file's copyright section) the contents of this gist are Copyright ©️2020 by Christopher Allen, and are shared under spdx:Creative Commons Attribution Share Alike 4.0 International (CC-BY-SA-4.) open-source license.

Sponsor

If you more tips and advice like these, you can become a monthly patron on my GitHub Sponsor Page for as little as $5 a month; and your contributions will be multipled, as GitHub is matching the first $5,000! This gist is all about Homebrew, so if you like it you can support it by donating to them or becoming one of their Github Sponsors.

Continent_Name	Continent_Code	Country_Name	Two_Letter_Country_Code	Three_Letter_Country_Code	Country_Number
Asia	AS	Afghanistan, Islamic Republic of	AF	AFG	4
Europe	EU	Albania, Republic of	AL	ALB	8
Antarctica	AN	Antarctica (the territory South of 60 deg S)	AQ	ATA	10
Africa	AF	Algeria, People's Democratic Republic of	DZ	DZA	12
Oceania	OC	American Samoa	AS	ASM	16
Europe	EU	Andorra, Principality of	AD	AND	20
Africa	AF	Angola, Republic of	AO	AGO	24
North America	NA	Antigua and Barbuda	AG	ATG	28
Europe	EU	Azerbaijan, Republic of	AZ	AZE	31

How to solve `dyld: Library not loaded: /usr/local/opt/icu4c/lib/libicui18n.60.dylib`

brew uninstall --ignore-dependencies node icu4c
brew install node

Super Simple CaaS Example

This is just an example to build upon and in no way represents best practice. You most like would use a web component framework like React.js or Vue.js with Mura.js rather than vanilla js.

For this to work:

You must be on Mura 7.1.137 or greater
set your site's contentRenderer.cfc's this.hashURLs=true;

	USE {YOUR-SAP-DBNAME-GOES-HERE};
	GO

	SELECT
	D3L.POSITION AS SOURCE_COLUMN_POSITION
	, D2L.TABNAME AS SOURCE_TABLE_NAME
	, D2T.DDTEXT AS SOURCE_TABLE_DESC
	, D3L.FIELDNAME AS SOURCE_COLUMN_NAME
	, D4T.DDTEXT AS SOURCE_COLUMN_DESC
	, D4T.REPTEXT AS SOURCE_COLUMN_HEADER

	import * as React from 'react'
	// routing, etc.

	import { Reset } from '~/ui/shared/Reset'

	export class App extends React.Component {
	public render() {
	return (
	<div>
	<title>Dashboard</title>

	<!---
	save this file somewhere under your theme (e.g, custom/tracking-form.cfm),
	then use [m]$.dspThemeInclude('custom/tracking-form.cfm')[/m] to display it
	--->
	<form id="trackingform" method="post">
	<div class="form-group">
	<label for="trackingnumber">Tracking Number</label>
	<input type="text" name="trackingnumber" class="form-control" placeholder="Enter tracking number ..." />
	</div>

	/*

	Mura forms are loaded asynchronously. So, if you wish to run some scripts, you need
	to use a special method to `reopen` the form, and add your scripts using

	`Mura.DisplayObject.Form.reopen({})`

	The most commonly needed examples are described below.

	*/