You are here Newsletters Monthly Newsletter
Wednesday, August 04, 2021
Blog Entries
Jul 12

Written by: hl2admin
7/12/2012 12:51 PM  RssIcon

  Message From Management  
  Phew! We are finally there! It gives me great pleasure to announce the completion of Version 4.50 of HAIRLINKSQL. This is a MAJOR upgrade and has an update document that we encourage you to download as soon as possible. We have released an update notes document which we recommend you study before upgrading.

In This Issue
HairlinkSQL V4.5
Cloud Backups
Tip 1
Tip 2


Devendra Patel [BE(Elec), ME(E&E), MemIEEE, Mem NZSA]
CEO, Computer Fanatics Limited.

  HairlinkSQL Version 4.5  

The Update notes for HairlinkSQL version 4.50 are now available. This version has been in testing at a number of businesses and is packed full of new features and user requests. A further email will follow shortly advising users when they can upgrade. To ensure a smooth upgrade process ALL users should read the update notes first. New features include;

    Sort EOD Till Roll by Date/Time     Product Price Change Log    
        Send Single Bulk Mailer per Client     Statement Email    
        Consult Room Based Diary     Bonus Point Message on Bill    
        Microsoft Word Integration     Crystal Report Upgrade    
        Plus Much, Much, More            

For a full list of features with detailed descriptions and instructions please download the update notes from the HairlinkSQL website under the downloads menu or click on the link below.  


  CFL will provide the upgrade service free of charge to all users on a support plan during business hours by logging on to your server. After-hours upgrades are also available by special arrangement and incurred time is billed out at our standard hourly rate. It is important to note that upgrades can go through easily without any problems or they may take some time if problems arise. All after-hours time is billed as incurred and this must be accepted as the terms for any after-hours upgrade request.  

Back to Top

  Online Cloud Backups  

Many HairlinkSQL users are now utilising CFL's online cloud backup system to provide extra protection of their data.

Imagine a disaster similar to the Christchurch earthquake or the Queensland Floods. The data on the server would be lost but so would the "backup"given that it resides in the same geographical location. Backing up to the "cloud" means that the data is safe in another secure location. In our opinion, this should be, without a doubt, standard policy for any business today. 


 Advantages of Cloud Backup include:

  • Reliable backup and recovery with data off-site and off-city.
  • Fully automated offsite data protection in case of geographical disaster.
  • Secure. All data is encrypted at the source, in transit and in storage using 256-bit AES encryption.
  • Removes the costs, hassles and human error associated with tape, DVD or other forms of backups.

For more information click here or contact Goran on 
+64 9 489 2280 ext 3.


Back to Top


  Tips 'N' Tricks  
TIP #1: Sorting Invoices by Name

By default HairlinkSQL shows products on  invoices in the order they were entered and sent. However when receiving orders, the supplier may have re-ordered the products into alphabetical order which can make reconciling the order more time consuming than need be. HairlinkSQL allows you to re-order the products on an invoice to alphabetical to make checking an order easier.

  1. With the invoice open on screen, click the Key button on the right.
  2. Select 'Product +' to sort into alphabetical order or 'Product -' for reverse alphabetical.

Back to Top

TIP #2: Product Wildcard Search

HairlinkSQL provides an easy way of searching for products where you can only remember part of the name. This is useful for products that may have long complicated names like drugs for example.

The ‘Contains’ field will assist with these issues by providing a word within a word search on the Advanced Search Screen. For example, if ‘Contains’ is unchecked and you do a search for 'Premium', the system will find only products that start with 'Premium'. If ‘Contains’ is checked it would find other items where 'Premium' was inside the name like 'Supplier Premium Body Wash'.

  1. Click on the 'Product' button.
  2. Click 'F8: Advanced' if only the simple search is shown.
  3. Enter the part of the name you remember in the 'Name' field and tick the 'Contains' checkbox.
  4. Press 'F12: Search'.

This will bring up a list of all products that have the text you entered within their name.


Back to Top

  P2P Limited  

Would you like to send Monthly Newsletters like this one to your clients? Check out the P2P Limited website as well as this link to see how you can integrate HairlinkSQL with your website and send HTML emails like this one. The website can also let your clients log on to check reminders, account balances, bonus points, appointments and much more

Back to Top


P.O. Box 34589 Birkenhead, Auckland 0746, New Zealand
21 Barrys Point Road, Takapuna, Auckland 0622, New Zealand

Location: Blogs Parent Separator Blog
Search Blog
Recent Entires
Running HairlinkSQL on Windows 8
May Newsletter 2013
April Newsletter 2013
Importance of Backups
March Newsletter 2013
Advantages of Having Your Own Domain Name
February Newsletter 2012
December Newsletter 2012
November Newsletter 2012
October Newsletter 2012
Copyright 2016 by HL2 Privacy StatementTerms Of Use