Hiding dot-folders on Windows

Such a good tip, that I better save it right here for future use. To hide all the Linux-like dot folders (folders with names starting with a period, or full stop), open Command Prompt and run:

ATTRIB +H /s /d C:\.*

This will fix all the current folders, but any new ones generated later will not be hidden. You'll have to re-run this script (maybe automated as a Windows Scheduled Task?).

Python's Sendmail fails due to access permissions

A script that ran happily for about a year suddenly stopped working last week. From the stack trace, it was apparent that the script was stumbling on Python's smtplib>sendmail command. Here's the error:

OSError: [WinError 10013] An attempt was made to access a socket in a way forbidden by its access permissions

The offending code:

A simple Bitcoin price tracker with Python

This script tracks of Bitcoin's current USD price and displays it along with the price's "trend" since the script started running. The main part of the idea was borrowed heavily from this Stack Exchange article. It takes advantage of the coindesk API for getting current price information.

Sure, it's not a fancy line graph, but it's got ASCII-art up/down arrows!

Here's an example screenshot:

Collecting new document files for easy attachment in email

I find that I frequently (many times daily) have to send files as email attachments. Depending on the task, the files can be located in a half-dozen or so places on the Windows file system. I found myself browsing (from Outlook's "Attach File" function) to my Documents, Downloads, Desktop, or one of several network drives for the file I just saved there a few seconds ago.

Change pip package dependency lists and install from local source with Python 3.6

When installing a Python 3 package with Pip, if the package to be installed calls for a dependency that is outdated or otherwise not available, you can get a local copy of the module, change its dependency lists, then install it from the local source.

This will likely be no big deal for the Python wizards out there, but it was a pretty nice victory for me, so I thought I'd better share in case someone else has the same trouble.

I was attempting to install the lastpass-python module:

Tags

Properly configuring and using Drupal's views_data_export module

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".

CSVKit

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.