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
Category: Nerdy-Gudry
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
Change a list with colons to list with new lines in linux (fedora)
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…Continue reading Change a list with colons to list with new lines in linux (fedora)
Allow your contributors to upload a profile picture to WordPress without using Gravatar
There are lots of benefits to contributors uploading a profile picture (also known as an Avatar) to your WordPress site: it makes it clearer who is writing each blog, it helps the writer feel part of your site, it makes your site more personable and friendly which helps your readers to engage more. WordPress, by…Continue reading Allow your contributors to upload a profile picture to WordPress without using Gravatar
Android share suggesting inappropriate contacts
This issue appears to be closed/resolved on the android bug tracker but may still exist on your phone if you have not updated or if no update is available. The Android share menu has been a great feature for me, for example, when I am viewing a cute pick of my cat, I can click…Continue reading Android share suggesting inappropriate contacts
How to open gparted in fedora 25 (wayland): Gtk-WARNING **: cannot open display: :0
Today’s task list involved installing Fedora 25 (yay!) on my new computer and reformatting some hard drives to use as backup disks. The install was fine however I couldn’t seem to get gparted started (poet / know it). Gparted is the tool I find most useful for dealing with hard drives, partitions etc, but apparently…Continue reading How to open gparted in fedora 25 (wayland): Gtk-WARNING **: cannot open display: :0
How to randomly select data from a column in libreoffice
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…Continue reading How to randomly select data from a column in libreoffice
A discussion of website models for Open Source projects with OpenSAAS element
This blog contains a discussion of website models for Open Source projects with Software as a Service (SAAS) element, and uses four real projects as examples.
Protect yourself from Thunderbird email auto-complete when you start a new job
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…Continue reading Protect yourself from Thunderbird email auto-complete when you start a new job
Image and Attribution Identification Game using Blockhash and Elog.io
I heard Jonas Öberg speak about blockhash and elog.io (since mothballed) at Fosdem2015. The general purpose of these tools is to allow users to make attribution of CC licensed images easy. First they identify CC licensed images when they are used on-line, the tools then match the image with a record in a central database…Continue reading Image and Attribution Identification Game using Blockhash and Elog.io