FocusOnCRM

FocusOnCRM has been developed on demand as per the request of a UK Packaging Merchant.

This application allows the user to manage products (and manage the documents that are associated with the products,)  automatically email documents attached to quotations, process sales orders, purchase orders, manage stocks, manage machinery service agreements and generate service bookings and reminders by email.  Theres much more to the capabilities of this software but as it is bespoke, it operates just as the client wants it to.  Deployed over the web, this windows desktop application links to an SQL Server Express database and on shutdown automatically backs-up the data itself to a networked device.  The system has been written to operate in a multi user environment and the default user (Manager) can see the activity of the sales force and monitor their activity.

Image of FocusOnCRM interface

Mobile Phone Image Archiver

I found the need to archive the pictures on my 2gb memory card in my Blackberry Storm.  My family photos are stored on Home Network/NAS and the directory structure is, folders named with the date that the pictures were taken.

The image archiver was written to automatically archive blackberry images within date folders, taking away the painstaking task of manually moving the images and creating folders for the relevant date.  To download a copy click here, any questions or problems contact me and I will do my best to resolve the issues in a future release.  The application is deployed via ClickOnce (This means that the program automatically checks for updates when it opens and you are always kept up to date with any changes or improvements made.)

Update 09-02-2012:
An update has been made to the app to allow folder creation using the image file creation date.
The app can now be used to archive images from any phone!

Hope you like this handy little tool! :D

File System Created

The file system created

BellaPhotoViewer.exe

I have thousands of family photos which I have archived onto a USB stick, I save them into folders ‘by date taken.’  My daughter Bella aged 4 wants to constantly look at the pictures of when she was newly born but when I go to help her and browse the pictures to look back at those memories, I hadn’t realised how much of a nuisance it was to go in and out of all the folders to view the pictures!  I decided to write BellaPhotoViewer which took about 2 hours in total to code.

The BellaPhotoViewer reads the USB stick and finds all the pictures on it, sorts them by filename then puts the names into a list.  The slideshow function allows you to view the files at various intervals and then when your done, it remembers where you were up to for when you next open it or if theres a favourite picture you would always want to start from, you can set that as an option.

I installed it to my daughters profile on our family PC and now I can let her do it herself.  She opens the application (at her favourite photo) and then lets the program do the rest for her!  I dont need to worry about the risk of her deleting pictures either.  Available as a free download, runs on Windows PC.

BMS Scan Management

Recently a local office installed a new heavy duty free standing copier, multi function machine.  This machine allowed the office to scan documents to a network shared drive but without the copier software which came with a wopping price tag, it proved difficult to easily find documents by their index once they had been scanned.  I offered to write a program which allowed the users to re-index the documents and give them a name which could easily be found at a later date.

Each time a user scans a batch of documents to the network drive, the application reads the files, lists the documents and on selecting the list member, gives a preview of the document.  The user can then input a new name and click a button to update the file.  To retrieve the file, the user inputs a value (such as order number or delivery note number) then a list is populated with the relevant files that match the search string.  Original files are kept and indexed to be extra precautious!

New document

Sage Account Statement Tool

I was recently asked if it was possible to fully automate the sending of a customer statement or late payment letter from Sage to 400 individual customer accounts without any need to print and manually fax.  My client had experienced problems with configuring the computer to automatically email but still couldnt automatically fax any documents.  I wrote the SageStatementTool which looks up live data, builds statements then exports/prints them for mailing, automatically faxing or emailing as PDF.  The unattended process took 5 minutes to complete whereas previously it had taken hours.  The next step was to run various late payment letters in varying forms to customers who had not payed their account or only part payed.  Since using the tool, payments have been coming in more frequently than before and customers receive the statements in a form that suits them.

Sage Statement Tool

Factory Management System

BMS have provided a range of applications for a local manufacturer ranging from small contributions calculators and data analysis tools to a modulised ‘Factory Management System’ (FMS)

The project started using Vb6 back in 1998 and progressed further via migration to VS2005 then VS2010.  The current build is a modulised management system formed from several classes structured around Customer, Supplier, Quotations & Sales Order Processing, Purchase Ordering, Invoicing, Printing, Fax & Email management.  It is a multi-user, networked, MDI (Multiple Document Interface) program which can be accessed over VPN.  It streamlines data flow and minimises user input and data replication. On creation of a quote, with the click of one button the order is created, again on the click of a button the purchase order is created.

The manufacturer supply polythene packaging products to merchants throughout the UK.  Their products are complex and each can have its own recipe and formulation.  With introducing FMS, formerly known as ‘Quotes’ the office processes have been reduced considerably allowing more time to focus on the more critical business processes.