Mautic, Open Source marketing software, can be used to send targeted emails about events to people on your mailing list who live within a radius of that event. The best thing about this process is the lists will always be up to date when you need them: next time an event is in the same area you have a list ready and waiting. Here’s how it’s done.
In this example, I will condense a list of paired-down postcodes into a short list by removing all the duplicate entries.
Hi all, just a quick dip into website analytics today! Over the years I have learned that watching your analytics like they are drying paint after you make big changes to the site is a great way to…. find errors and be disappointed! (Not kidding unfortunatly) After most major website revamps I have been involved…Continue reading Troubleshooting changes in Analytics: Bounce rate down: Page views up caused by second Matomo / Google tracking code
In May the EU General Data Protection Regulation (GDPR) comes into force (and no, brexit won’t get us out of it – still no benefit to brexit. Sorry.) In my view this is shaping up be a complicated piece of law for small businesses to follow, both intellectually and technically. Worryingly, I’ve not heard much…Continue reading GDPR: you are allowed to maintain a blacklist, suppression list or stoplist. You are also allowed to freak out and panic.
Yet another task getting data out of a fairly nasty/incoherent web-based table and moving it into LibreOffice for sorting/project planning. Presumably this is all “easier” with scripting but I don’t have the time/patience/inclination to learn, so here is my hacky method! It worked for 95% of my data, so I had 5 of 100 lines…Continue reading copy-pasting data from website table to libreoffice, formatting it as a csv in geddit
Piwik is the Free and Open Source Analytics project, like Google Analytics but a whole lot less creepy. On 9th January 2018 Piwik was renamed Matomo: I did a little digging and can shed some light on why this change has happened and how it highlights a wider issue for Open Source projects in world of Branding and brand loyalty.
Often if I have copied a list of blogs, files or emails from an app or website, where there is no export function, button names such as “Edit” and “Delete” will copy over. Often in a small list of items there will be several repeated junk phrases for each item of text I actually need.…Continue reading Removing button names etc from a list of blogs/files/emails copied from a website (Gedit, Fedora)
I have been writing a lot recently about little obstacles I have come across while helping the Church of England move content from their old sites to their new ones. Making a list of all the content to be moved is often the first job, but many of the older/proprietary platforms don’t have the ability…Continue reading Quickly removing date/time stamps from a text file using find and replace (Gedit, Fedora)
This is particularly useful when working with lists copied and pasted from withing software (like WordPress or Drupal). Perhaps you are making a list of blogs you have written or you want to check the order of a menu: often when you copy this data you get spare bits of html such as button names…Continue reading Removing every other line, or every nth line, from a list using LibreOffice Calc
I am currently doing some work for the Church of England, moving and improving the repository of liturgy to their new website. There are a lot of files involved so using shortcuts for sorting out data and lists is vital. Removing unneeded items from a list Today I was working with an export of a…Continue reading Removing some text items e.g. files with certain extension, from a list in Libreoffice using COUNTIF