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.
Category: LibreOffice
Removing duplicates from a list using Libreoffice
In this example, I will condense a list of paired-down postcodes into a short list by removing all the duplicate entries.
copy-pasting data from website table to libreoffice, formatting it as a csv in geddit
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
Why Piwik is now Matomo: on Forking and Damaged Trademarks
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.
Removing some text items e.g. files with certain extension, from a list in Libreoffice using COUNTIF
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