Category: Free Software

copy-pasting data from website table to libreoffice, formatting it as a csv in geddit

gingerlingBuisness

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

Removing button names etc from a list of blogs/files/emails copied from a website (Gedit, Fedora)

gingerlingBuisness

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)

Quickly removing date/time stamps from a text file using find and replace (Gedit, Fedora)

gingerlingBuisness

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)

Removing some text items e.g. files with certain extension, from a list in Libreoffice using COUNTIF

gingerlingComputer skills

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

Removing double line breaks in a text editor on Linux (Fedora)

gingerlingComputer skills

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…Continue reading Removing double line breaks in a text editor on Linux (Fedora)

Allow your contributors to upload a profile picture to WordPress without using Gravatar

gingerlingCommunity Management

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

Help I forgot to make my user an administrator when installing fedora

gingerlingFedora

When installing fedora I almost always forget to tick the “make user an administrator” box. Then when I want to install some software or update later I get a rather morose ticking off from my terminal…  “Username is not in sudoers file. This incident will be reported”.  Just what every girl wants to hear… one…Continue reading Help I forgot to make my user an administrator when installing fedora