Skip to main content

The Virtual Bean Counter

Prior to the trip to buy groceries each week, the tedious chore of wandering round the house checking how much of all the consumables that a household requires is actually present must be completed. Everywhere there is a stash; upstairs, downstairs, all the cupboards, the fridge, the freezer, etc., etc. I could try to do it from memory, but who has the available headspace to remember how many tins of beans you have at any particular moment and, even if you do try to use this method, how many extra tins of corned beef or jars of mustard is it reasonable to have to buy just to save yourself from the weekly traipse around the house doing a stock-check?

What I need is a Bean Counter.

I want to be able to scan in the barcode on a tin of beans when I buy it and when I use it scan it out again and have the stock level reflect that fact. Then, on shopping day, I can just look at the stock levels from my desk. Or even better it could just tell me when I need to buy more beans again.

Of course this is a really basic function for most businesses and there are whole suites of software for stock management, but this is a household not Amazon. Fortunately a nice person called Bernd Bestel has already solved this problem and the solutions' name is Grocy.

It is supposedly a whole ERP (Enterprise Resource Planning) system designed for the household. It sits on a central server (ie computer) and you or your SO can use a phone as a barcode scanner to interface with that server. Perfect. I don't need the whole ERP shebang, but if it can solve the bean problem then I am willing to give it a try.

Let's set it up.

The first task is to set up the main software on a server that, ideally, should be on all the time, or at least all the times that you want to be using or buying things. I could do this on my main PC but I don't necessarily trust Windows to be able to properly uninstall the package if I decide it isn't going to do what I want. However, if I do decide that it is the right solution, I would prefer to run it on a lower power consumption device as it is going to be on all the time, for example a Small Form Factor device like a Raspberry Pi. In addition, I have also been looking at home automation and wondering whether it is worth getting involved and this too would require an always-on device.

Happily, Grocy has already been integrated into Home Assistant (the leading open source platform for home automation). So I could kill two birds with one stone (a horrible metaphor, btw) and I do have a Raspberry Pi somewhere. But as to where exactly I don't know and really can't be bothered to go a-hunting for it. The answer, then, is to virtualise a Raspberry Pi and install the system on that while I determine whether it is a keeper or not.

Virtualise? I'll leave Copilot to explain that;

Virtualization in computing refers to the process of creating a simulated, or virtual, computing environment rather than a physical one. Virtualization uses software to create an abstraction layer over physical computer hardware. This layer allows for the division of a single computer’s components (such as processors, memory, and storage) into multiple virtual machines. Each virtual machine runs its own operating system and behaves like an independent computer, even though it shares the underlying hardware.

In short I can create one computer inside my desktop PC - like blowing a bubble inside a bigger bubble - then set up Home Assistant and Grocy and if I don't like it I can just trash the whole system rather than trying to uninstall a chunk of programs and any alterations they have made to my PC. Simples!

OK, but how? VirtualBox (VB) from Oracle is my preferred software - other virtualisation software or hypervisors are available, but A) I haven't used them before and B) they are normally more complex than VB, not that VB is exactly user friendly.

Setting up VB is not too taxing though, just download the right one for Windows 11, currently v7.1.4, and install it. To test it out I decided to set up a Linux system, Ubuntu 22.04 LTS, obtained from here. As why not have access to Linux on my desktop?

Unfortunately it was not to be that simple as VirtualBox started with error messages as soon as I tried to get Ubuntu running.

VERR_SVM_DISABLED error message from VirtualBox

Let's debug.

Labels:

Comments

Post a Comment

Popular posts from this blog

Grocy and its Home Assistant Add-on

The next layer of the Virtual Bean Counter software stack is the meat in the sandwich, Grocy (see Grocy system install ). As with the Home Assistant (HA) Operating System that was reviewed previously the aim of this article is to consider the support and backup options for the Grocy system as installed onto our HA virtual machine . But first a little history. Whither Grocy ? It sprang from the desire of a software developer, Bernd Bestel , to progress beyond using Excel (as we know a great spreadsheet and data analysis tool but with a limited UI) to something more fully featured by exploiting his experience with commercial inventory management. The first version of Grocy was released in 2017 and after seven years is now on its fourth full point release . However, unlike HA, it is essentially a one-man band with a single developer responsible for pretty much the entirety of the content all without stable funding (currently). That said the package is quite mature and " does wha...
Post a Comment
Read more

Further adventures in household paper products

As the toilet rolls are up and running I couldn't resist adding the rest of the loft stocks into the mix. The next two items are kitchen roll and facial tissues . Following the same process described for toilet rolls; kitchen roll comes in a multipack, but this time a case has four packs of three rolls and we already have the storage location, shop and quantity units set up. Again, I think we'll have to set up a generic item (Parent product) as well as a specific one for the Kirkland brand rolls (Child product). So I gave it a name, Kitchen roll and a description; default storage location and shop, Loft / Costco ; a min stock amount, 3 rolls ; all the quantity units are Roll . Job done. Now for the specific product, as previously, pulling images and descriptions off the Costco website, setting up case and pack barcodes and quantity conversions between them, buying in Cases and using in Packs . But hang on, do we really want to track in packs of three? We only need a sin...
Post a Comment
Read more

How to Delete a Government Gateway ID

As described earlier , here are the instructions from HMRC on how to delete a Government Gateway ID (GG ID), should you choose to do so. 1. Login to your account with the GG ID you wish to delete. You'll need your GG user ID and password. This will also require access to your second factor authorisation device. 2. Once logged on, select the ‘ Manage account ’ option at the top of your homepage. 3. On the next page choose the ‘ View or change your business tax account details ’ link under the ‘ Account details ’ heading. 4. On the following page select the ‘ Manage your Government Gateway details ’ link at the right-hand side of the page. 5. On the page after, choose the ‘ Your Government Gateway profile ’ option under the ' Your profile and settings ' heading at the right of the page. 6. Finally, on the next page choose the ‘ Delete my Government Gateway user ID ’ option at the bottom of the page. 7. Confirm that you want to delete your user ID ...
Post a Comment
Read more