In a Drupal view, I have a button in place that allows the user to export the current view to an Excel (XLS) download (utilizing views_data_export module functionality). That download is expected to be around 3,500 rows, with 39 columns. I just noticed that trying to hit that button for the download results in (almost exactly 30 seconds later) an error I hadn't seen before: "Server Hangup".

I recently had to upgrade a Windows IIS Server running PHP 5.5 to PHP 7.1.1. I ran across this excellent blog post which got me 99% of the way through the process.

Some things I had to do additionally/differently:

I've found this tool to be very powerful and helpful...and I almost couldn't find it again after recently upgrading to a new computer. To prevent future heartburn, I'll document it here.

From the csvkit web site:

csvkit is a suite of command-line tools for converting to and working with CSV, the king of tabular file formats.

This post outlines a method I came up with to use a single AutoHotKey script to auto-load any number of scripts in a sub-folder. It also allows every script to have its own autoexec section, and to hook into a timer for event-type functionality.

AutoHotKey scripts that are 'persistent' need to be loaded into memory by Windows just one time. If you have several of them to load, you can get them all individually, but you end up with a system tray full of little green 'H' icons.

AutoHotKey is a powerful Windows automation tool, capable of doing pretty much anything you could do yourself on your PC. I have a number of scripts I run regularly (or always have running) to speed up my work and/or make it more accurate and efficient.

One of my favorite scripts responds to the key combination of Ctrl-Alt-0 (that's a zero). When I press that combo, a couple things happen:

1) First, the script checks to see if the machine is connected to WiFi, and if so, grabs the name of the WiFi's SSID.

I haven't found a way to make my email 'groups' from Outlook available on a mobile device (Android phone). I've tried several email clients, but none of them brings in the groups I use frequently in Outlook.

Recently, I came up with a workaround, using Outlook rules. Essentially, I can set up a rule with the following criteria:

• Sent from my account

• Sent to my account

  I almost never send mail to myself, so this works. If you routinely cc: yourself, you may need to be careful here.