• Quickly convert a Xero batch payment CSV to a format that works on Metro Bank

    Ah Xero. Every day you disappoint. Not quite enough for me to find a replacement for your poor accounting software (I figure they all have issues but at least I have work arounds for most of your flaws) but one day, I will put enough effort into moving.

    Today though, I’m going to share a fix for Xero’s bulk/batch payment file export being in the wrong format.

    Where we start

    If you have a number of people/suppliers to pay you can create a ‘batch’ payment.

    Details here: https://central.xero.com/s/article/Pay-multiple-bills-UK

    This generates a file of payment instructions you can upload to your bank. However the payment file is in the wrong format.

    The help page says the format is correct for Santander but it is not.

    I filed a bug report a long time ago and go the now typical Xero response to a bug: ‘Please suggest fixing this as a new product idea’.

    I maintain that as a piece of software it would be easy for Xero to solve this if they cared. Fixing those files was as simple as adding the total and number of lines to the bottom of the text file and I’ve been doing that by hand. It was just about fast enough to not automate a fix.

    However, we’re now moving to Metro Bank and Xero won’t output the correct file format. The fix includes splitting the sort code and account number into two fields rather than the 1 field Xero exports which is not something that would be quick to do by hand, as well as putting them in a different order.

    I did ask Xero about fixing the CSV export and their answer is their software can’t format CSVs (🤦‍♂️but they do it for Santander and HSBC, albeit badly) and that I need to reformat their output to make it useful.

    The solution (that’s free and you can use too)

    I wrote a web page that takes the Xero CSV file and reformats it into the banks requirements.

    It does this using instructions in Javascript which your browser understands natively. That means it does NOT need to send your file to my server to process and return All the code runs on your own computer.

    You can find the page at https://sroot.eu/xero-csv-converter/ and although you can convert your CSV there you’ll read in the notes that I suggest you save the page to your computer, check the code, and use it from there to know that no one (including me) has tampered with your payment file.


  • Clothing for your first marathon

    I’ve been training for my first marathon and vlogging my progress on YouTube and Instagram. Early on I was told to start running in my marathon kit as soon as possible. I’m sharing below what I chose, why, and how much it cost. Perhaps it will help other new marathon runners choose.

    I do not promise these are the best choices, or that these are right for you!

    Links are to the manufacturers websites but you’ll likely find plenty of other retails of their products

    There’s a video version of this here [note to self, add it when published :-)]

    The BLUF (Bottom Line, Up Front)

    All of my marathon equipment has cost a total of £589.

    That includes several items I have multiples of so that I can avoid washing them every day. So much for running being a cheap activity.

    Trainers – Brooks Ghost 16

      £135 from my local running shop.

      I went there for an hour and tried on 5 different pairs. Strangely I didn’t settle on the most expensive. I had decided that even £200 would be worth it if it makes my first run more comfortable so didn’t ask the price until I’d chosen my favourite.

      Socks – Balega Blister Resist

      £16/pair, £64 for the 4 pairs that I bought.

      Before I lost my mind and decided to run a marathon I’d been running 5Km 2 or 3 times a week. Buying trail running trainers when I happened to be passing the running shop meant I didn’t have decent socks so I bought a new pair there, and their recommendation was Balega. That pair has been fine so I decided to buy a few more specifically for the marathon. I’ve no idea if they actually resist blisters or it’s good marketing. I did get a few small and minor blisters the first few weeks of having the trainers but none since. For context that’s probably 300km of training runs so I’m guessing they work for me.

      Shorts – Montane Men’s Jetstream 5″ Trail running short tights

      £44 each, £132 for 3 pairs.

      I love these shorts! I started running in tights over winter and realised I much prefer the figure hugging fabric. Not because I have an amazing figure (watch the videos, you’ll see what I mean), I find the tights more comfortable to run in. Also, if you watch my vlog “Run 36, number 2” you’ll discover a bonus feature they don’t advertise…

      Decathlon breathable Kiprun Run 500 dry+

      £11 each, £33 for 3 t-shirts.

      Despite throwing money at other clothing, I found these cheap T-Shirts from Decathlon that do just what I need. My wife doesn’t like the print pattern but I think they were end of line on offer.

      Hydration Vest – Montane Gecko VP 5L+

      £100 including 2 x soft water flasks

      Technically, I bought this twice. I misread the web site for sizing and ordered large which would be right for some of their other things, but the hydration vest sizes at the bottom I needed medium. Too large, and they bounce as you’ll notice in my early videos. I’m only counting the cost once for this. Also they RRP seems to be around £120 but there are always discounts and offers on Montane so £100 is the realistic price. The alternatives I considered were also around £100 from Salomon (I tried one in the running shop but I can’t remember it’s name, I was going to get that one until I saw the £100 price from Montane and decided to save myself a trip into the city).

      FRACTEL L-TANGLE Legionnaire cap

      £45

      I spent ages researching caps. I wanted one with cloth to cover my neck as there’s a good chance my marathon will be on a sunny day. It’s proved useful on my training runs too. Picking a cap was hard because I wanted to put my Run Rootie logo on it with iron on vinyl. The one I chose had a fabric patch that I unpicked to give me the space for my logo. It’s very lightweight and wicks away sweat ever so quickly. It’s always wet from sweat when I return from a run.

      Shokz OpenMove Blue refurbished

      £80

      Technically I had these before I signed up for the marathon. One of my suppliers reps is a keen marathon runner and recommend bone conduction headphones when I first started running. I went cheap by ordering the refurbished pair when my originals died and I couldn’t wait for the warranty replacements (I sold those when they arrived). In hindsight I should have got the version with USB-C charging rather than magnetic connecting cable. It’s a minor annoyance to remember to take that cable with me when travelling.

      The bottom line

      £589

      All of the equipment I’ve chosen to run my first marathon has cost me £589 which to me is a sensible investment in my comfort on my marathon challenge.


    1. Marathon training, turning planned run times into distances

      I’m training to run a marathon (Run Rootie!) and basing my training plan on the Chris Evans book “119 days to go”. That training plan is based around time you spend running rather than distance to run each time.

      I like the approach but it’s made it really hard for me to plan my running routes. Now I know that I’m running around 7 minutes per km I wanted to convert every run duration into distance and add it to my calendar.

      To do that, I made a spreadsheet with a few formulas, then exported a CSV file in a format calendars like, import it into my google calendar, and quicker than Steve can run a marathon I now have every training run suggested time and distance in my calendar

      If you’re doing the same thing, here’s my spreadsheet you can download an change to suit your own marathon date. It’s a ODS file (which is Open Document Spreadsheet format) that will open in Excel and many other spreadsheet applications.


    Search this site


    Free apps

    • birthday.sroot.eu – Your birthday or other celebration date based on [years on other planets] / [how many seconds/days] / [how far you’ve travelled around the sun]
    • stampulator.sroot.eu – Calculates the combination and how many 1st, 2nd, large 1st and large 2nd class Royal Mail stamps you need on large envelopes and packets

    Recent posts


    Archives


    Categories