Industrial Programming Case Study – Glasgow Watersports
Prior to Xyroh, Andy was the founder of dotUK (A software development firm based out of Yarm and Stockton on Tees here in the North East), again specialising as a developer in mobile apps, web applications and desktop software for a number of business clients – this is one of those portfolio case studies for an industrial programming project
Industrial Programming
Industrial Programming is a term reserved for the programming of industrial equipment, pumps, valves, etc to control and monitor any number of simplex or complex scenarios. In many small business scenarios the distinction is being blurred with the advent of ‘Internet of Things’ products such as Hue Lights, Ring doorbells, Tado home heating automation etc – the concept however is the same, you turn things on and off.
In this case we are using a combination of a web and mobile based dashboard to turn on and off the paddle sports course pumps as required, the dashboards being the visible, more traditional development side, but the industrial programming being what happens behind the scenes to interface with the pump infrastructure.
Project Summary
The Glasgow Watersports project is a multi phased industrial programming project that will ultimately empower the user to control and administer the canoe course pumps and lighting from mobile devices, and place site bookings over the web.
The core control system part of the project allows for programmatic control of the sites pump, lighting, and klaxon systems using the industry standard Modbus protocol. This is being offered in conjunction with Retroflo, a North East based Electrical Contractors and bringing on board their expertise in industrial process control.
The full flow of the development will commence with a web based booking system provided by dotUK, end user bookings are then pushed privately to the Glasgow Watersports site where the onsite infrastructure will allow users to access their booking and the control systems via any wifi enabled device.
Local users can then control the pump output (strength of water flow) on demand in accordance with the abilities and expectations of their group.
A full remit of expected industrial safety, and health and safety best practices are of course in place but this investment allows the end user, through dotUK’s software development expertise, to bring control and a more beneficial user experience to the end user.
IPL – Quote Management and CRM System Case Study
Prior to Xyroh, Andy was the founder of dotUK (A software development firm based out of Yarm and Stockton on Tees here in the North East), again specialising as a developer in mobile apps, web applications and desktop software for a number of business clients – this is one of those portfolio case studies
Summary
International Procurement, a Stockton on Tees (North East) based supplier of severe service isolation solutions, needed a means to better automate and streamline their already complex request, quote, supply and invoicing workflow,
Technical
Client International Procurement – Critical & Severe Service Isolation Solutions
Platforms Web, Web Services, Kashflow
Technologies PHP, CSS, JQuery, Javascript, MySQL, REST API, JSON, Kashflow, SOAP
Development Web Development, Web Services Integration, Kashflow Integration
Case Study
The IPL sales process workflow is complicated by the very precise specification and requirements attached to each and every order, often a customer enquiry for a product will be met with a variety of options from a supplier, may have to meet complex supply requirements (including lengthy import, export and trade embargos), and even build to order solutions.
With that in mind, dotUK built, upon their in-house web services framework, a cloud based software solution that runs in the web browser, and is accessible both internally, to allowed users on the road or in home working environments, and to mobile and smartphone devices over the web, bespoke to IPL’s requirements.
The summary workflow required was in essence;
• Record Enquiry
• Manage Supplier requests (with quote and attached document management) to fulfil the enquiry
• Freeform Quote Generation (Multiple Quotes and Variations)
• Quote to Order process
• Supplier Purchase Order generation to fulfil the client order
• Invoice generation, and customer management to the web based Kashflow accounts software
Where document generation was required we standardised on PDF as a consistent, non-editable output format, and the system automatically maintains copies of the last generated version (eg for quotes), and also maintains an archived history of prior versions. The system also allows for management of archived records, repeat ordering, and reporting on sales and overdue enquiries.
The Kashflow accounts software integration, also web based, through it’s own SOAP based API meant that simple requests such as pushing invoices into their accounts software moved from being a one line requirement, with traditionally a costly, time consuming and frustrating integration phase, became as simple as it should be. A custom written Kashflow module was written as an extension to our web services framework that integrated seamlessly, and allowed us to continue using the same methods for data exchange and document generation. Something that wouldn’t have been possible with traditional desktop based accountancy packages
Efiling – Web Based Company Formation Software
Prior to Xyroh, Andy was the founder of dotUK (A software development firm based out of Yarm and Stockton on Tees here in the North East), again specialising as a developer in mobile apps, web applications and desktop software for a number of business clients – this is one of those portfolio case studies
Summary
Efiling is an award winning online company formations software product that was originally developed by dotUK and had undertaken a number or significant revisions and expansions in the lifetime of the product
Technical
Client Efiling Ltd – Online Company Formations Software
Platforms Web, Web Services, Kashflow, XML Gateway
Technologies PHP, CSS, JQuery, Javascript, MySQL, REST API, JSON, Kashflow, SOAP, XML, Python
Development Web Development, Web Services Integration, Kashflow Integration, Companies House Integration
Case Study
The Efiling Web Based Companies House Software product was initially conceived with the core functional requirements of offering a web based medium through which instruction to the Companies House Gateway could be sent, on receipt of which the gateway would act upon those instructions. Examples of commands which could be instructed include;
- Formation of a UK Company (Eg Ltd, Plc etc)
- Add / Modify / Resign a Director
- Add / Modify / Resign a Company Secretary
- Articles of Association & Memorandum
- Change Registered Office
Version 1 of the software, developed exclusively by dotUK was utilising the Companies House Email Gateway, this protocol mean that instructions were issued by embedding commands in the email message subject and the payload (data fields, attachments etc) were embedded in properly formatted email message body. Responses from the Gateway were equally sent via email to a dedicated mailbox which was polled and monitored at the Efiling end.
Efiling is a multi tenanted system, which means the core platform is used by a near unlimited number of brand owners / companies withcompany formation needs. To function in this way data security and segregation is paramount as under no circumstances can data ‘leak’ between tenants on the system, and we built robust practices and data references into place to ensure this never happened. It also added significantly to the complexity of the system as we then had to manage website templates, company names, Companies House account details, email addresses and domains to manage, in essence near every variable in the system had to be configurable on a per tenant basis.
Billing for orders was another challenge to be managed, end user payments were taken by credit card on order, however brand owners were split between pre-pay (An account with a preloaded positive balance of funds) and credit accounts (Accounts with a preset maximum negative balance according to their credit limit), so we built a complex accounting structure that allowed for both charging models, and of course all associated reporting, statements, and invoicing required. Pricing levels (Both to Efiling, and charged by tenants to their clients) was also configurable and changeable on demand.
As the product matured additional features were added, which included expanding the standard statutory Companies House product offerings to allow tenants to offer bespoke, bundled packages, which included their own value add services (eg Company Secretarial, Mail Room services, offline products such as bound articles, hard copies of certificates etc). These were managed on a per tenant basis so significant upgrades to the tenant administration tools were made, and also to Efiling’s own system administration tools which sat above the tenants as an overview.
Soon Companies House began the process of decommissioning the email gateway service, which worked well, but was limited in terms of speed of service due to the delays faced in email delivery, and introduced a new XML based gateway. This gateway is in essence a secure web service that listens real time for commands sent direct over https (secure web traffic) and using documented (mostly!) XML documents as the payload. The benefits this service offered were that responses to instruction delivery were often available instantly, and it allowed us the option to ‘poll’ the gateway periodically for updates as opposed to wait for an email to arrive. It also increased reliability as we were communicating direct with the gateway as opposed to the round robin route email can on occasion take. dotUK were heavily involved in this transition, and the opportunity was taken to significantly improve other areas of the system such as document generation and storage.

Unfortunately it became apparent as the project progressed that some areas of the new gateway functionality were incomplete, undocumented, or not tested which meant we were frustrated in our ability to communicate progress to the client. However we took steps to optimise our time as efficiently as possible and made sure that we managed the project fully, this included taking responsibility for liaising with Companies House direct (who’s hands were tied by their own third party development team) and on occasion direct with the gateway developers themselves. Ultimately we were able to build and conclude testing of instructions in parallel with Companies House as we moved towards the deadline for switch off of the old email service. This was a regulatory deadline and was immovable.
Since then we have also been involved in other third party integrations, such as feeding bank account application into the Barclays Business accounts service (again an XML based gateway) and integration with the Kashflow web based accounts software using their SOAP based API. The advantages of using Kashflow were that it meant tenant accounting transactions were ultimately delivered direct into their accounts package, new customers automatically created, invoices and credits posted, thus automating tenant admin processes, actually reducing the amount of functionality required within the Efiling Back End, and actually adding significant value to the proposition.
For more information about Efiling, or to enquire about licensing their web based company formation software technologies please visit www.efiling.co.uk