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.
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 […]
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. […]
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 […]
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 […]
The other day I needed to remove double line breaks from a list to quickly put it in a spread sheet. Similarly, today I needed to change a list like: Heading Item; Item; Item; Into Heading Item Item Item In order to put it into a spreadsheet. Here is what I did: I pasted the […]
While copy-pasting an index from a website to a spreadsheet (google sheet) recently, I found several annoying points of formatting: Each item was an html link, which could not be easily removed in bulk The items were “double spaced” using two new lines after each item. I found the easiest way to remove this formatting […]
This is a up-to-date variation of some docs I found useful, the original was made by johnSUN. My problem Today I was researching for a possible change in the phpList UI: right now the behaviour of the menu item “Send a campaign” depends on if you have draft campaigns or not. If you have no […]
I had heard tell of dramatic/humiliating problems caused by erroneous email auto-complete before, but never been personally affected. I recently discovered that, while social embarrassments are… embarrassing, when you leave one employer and join a new one, the stakes are raised and the problems caused could easily have wider repercussions. I decided to sort out […]