mikesclassicads-dep’s gists

mikesclassicads-dep / ImportExcelFromFileToProdDB.ps1

Created September 7, 2020 02:14 — forked from mattcushing/ImportExcelFromFileToProdDB.ps1

Import Excel files to SQL Server

	# get each xls file and create xlsx file. 1st step in process is to download attachment from email to dir in $Path
	# script was designed to be generic enough to be used for multiple project emails
	# My final file has most of the below variables being populated from parameters passed to file
	# File I receive is in Excel 2 format, so I need to convert to XLSX. If this isn't an issue skip first Get-ChildItem section

	$Path = 'D:\MattDev\PowerShell\test'
	$TargetServer = 'SQLServerName'
	$StagingDb = 'StageDBName'
	$ProdDb = 'ProdDBName'
	$project = 'Project_A'

mikesclassicads-dep / quick-scan.sh

Created August 28, 2020 18:55 — forked from dinh/quick-scan.sh

Quick scan: a bash script to obtain a PNG 300ppi scan on your home folder.

	#!/bin/bash
	# Quick scan: a script to obtain a PNG 300ppi scan on your home folder.
	# Configure: change the device name (line 11) with your scanner ID running: scanimage -L
	# Dependencies: sane and libsane to scan (line 11) , imagemagick for cleaning (line 13), and notify-send for pretty D.E. notification (line 16).
	# License: CC-0; author <[email protected]>

	version=$(date +%Y-%m-%d_%Hh%M%S)

	touch /tmp/"$version"_scanner.tiff

mikesclassicads-dep / scanpix.sh

Created August 28, 2020 18:54 — forked from ki9us/scanpix.sh

Scans a photo, alerts the user when finished, and quits or scans another. Useful for bulk scanning photos while doing other computer work.

	#!/bin/bash

	####################################################\
	## ###
	## scanpix.sh ###
	## v 1.1.1 ###
	## Photo scanning script ###
	## ###
	## Scans a photo, alerts the user when ###
	## finished, and quits or scans another. ###