Author Archives: saasmd

About saasmd

I am an experienced software-as-a-service entrepreneur, based in London, UK. I love building interesting software businesses. My current venture is StorIQ, a platform to help bricks-and-mortar retailers manage their operations more effectively. This blog is a space to share low-level techie stuff that I think other people will find useful.

Changing the email send address in Office 365 without moving your domain

An update to the very good post by Peter Meinl at https://petermeinl.wordpress.com/2011/07/04/changing-the-email-send-address-in-office-365-without-moving-your-domain/#comment-1989 (read that first) (this is really so I don’t forget what I’ve done..) A few updates for anyone doing this in 2017… I downloaded tools to `Connect to Office … Continue reading

Posted in Uncategorized | Leave a comment

Excel function to count the number of matching words in two cells (‘fuzzy matching’)

I had a requirement to do a ‘fuzzy match’ of two columns of data, based on the number of matching words in each. Add the following code to your Visual Basic module, and then in your Excel spreadsheet, do something … Continue reading

Posted in Uncategorized | Leave a comment

Installing Windows 10 over Linux (Ubuntu)

I have an Intel NUC that I’d installed Ubuntu on, and now I have decided to install Windows 10 over the top of it so the kids can use it. I have just spent a merry two hours trying to … Continue reading

Posted in Uncategorized | Leave a comment

Updating Rails / MySQL database datetime fields

We have a demo site that we show to prospective clients, and we reset it occasionally using a ‘seed database’ that we have created to give realistic reporting data. The problem is that the timestamps on the seed database get … Continue reading

Posted in Uncategorized | Leave a comment

Some tips on getting Windows 10 to run VirtualBox with Ubuntu 14.04 for Rails

Here are some commands I found useful setting up my virtual machine ready for Ruby on Rails – as usual, exercise your own caution! Host system Windows 10 VirtualBox 4.3.30 Virtual Machine Ubuntu 14.04 Set up a new unix user … Continue reading

Posted in Techy Stuff | Leave a comment

Owncloud upgrade when data directory is not in standard htdocs folder

When I installed owncloud on our Debian Jessie server I didn’t like the way the data directory was under the htdocs path, so I did a custom install and created an owncloud-specific apache config file (owncloud.conf) in the apache sites-available directory … Continue reading

Posted in Techy Stuff | Tagged , , , | Leave a comment

Xero bank reconciliation with GoCardless

If you’re using automatic repeating invoice generation with Xero, and a monthly direct debit plan with GoCardless, there’s a ‘problem’ in that the value credited to your bank account by GoCardless already has their transaction fee deducted – so Xero won’t spot … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment