Travis Wade

Just a collection of crap I like to keep.

Automatically move Google sheet row to another sheet based on data in column

2018-11-05 Travis
Today I was looking for a means to automatically move some data from one Google sheet to another sheet tab based on what I put in a specific column. Now, the example here is say that I have a Google form that dumps into a Google sheet. The answers fill data into columns A through F. I wanted to have column G where all I had to do was put a “yes” or “no” and that data would automatically move from that sheet to another. Continue reading

WordPress Setup Guide v1 (Vultr Ubuntu 14.04 VPS)

2018-09-23 Travis
Getting Passwords Ready https://xkpasswd.net/s/ Document different passwords for each: Root MySQL Root MySQL User Create Vultr Instance sudo passwd root cat >> /etc/hosts <<EOF <PUBLIC IP> site.com EOF Install Packages Add PHP7 PPA and get things up to date. apt-get install software-properties-common add-apt-repository -y ppa:ondrej/php apt-get update apt-get dist-upgrade -y apt-get install -y mariadb-server php7.0 php7.0-mysql apache2 libapache2-mod-php7.0 php7.0-xml php7.0-gd mysql_secure_installation No Yes Yes Yes Yes nano /etc/apache2/mods-enabled/dir. Continue reading

Disable DEP Windows Server 2016

2018-09-09 Travis
By default in Windows Server 2016, DEP (Data Execution Prevention) is enabled for security reasons. However, this can lead to issues with certain applications and or services. You can disable DEP, but leave PAE (Physical Address Extension) enabled. You can do so from either the GUI (Graphical User Interface) or from Powershell. From the GUI Right click on Start Menu > System. Open start, and type “System”. On the left, click Advanced system settings > Advanced tab > under the performance section, Settings… > Data Execution Prevention tab: Continue reading

Create a simple logoff batch file to keep on your desktop

2018-09-09 Travis

For the lazy Sysadmin… If clicking start, logoff is too much work and slowing you down, there’s an easier way!

Open notepad, place the following snippet in the text editor and click Save As. In the drop-down below the file name, select All File types and give your file a name (perhaps logoff?). Be sure to place the .bat extension at the end of the file name to save it as a batch file.

shutdown -l

Now every time you double click this file, you’ll log off of the computer.

Apply custom printer settings for all users in Windows 10

2018-09-08 Travis
Printers are the bain of every IT administrator’s existence. Every manufacturer is different, there are a million and a half methods for managing them, users install them in ways that not even you knew were possible, the list goes on. But let’s say that you have a computer that’s shared among many users throughout a shift across multiple shifts. That very computer has several different printers installed via various methods. Continue reading
Older posts