Welcome to CASK Inventory Database a responsive web application designed to assist distilleries in managing their inventory of maturing whisky casks. A few terms straight from the go. Responsive means that it will adapt to the size of the screen. This allows better use of the same application whether you access it on a mobile… Continue reading 0000 Introduction
0005 Initial Configuration Setup
System administrators should be aware that prior to wider distribution to your distillery colleagues it is recommended that you read and populate all of the lookup tables with values appropriate to your distillery additionally on an ongoing basis as number of casks under management increases it is likely that you will, after an initial period… Continue reading 0005 Initial Configuration Setup
0006 Relational Database some background
It is useful when viewing many applications to be aware of the structure of the data that the screens draw from. Your data is stored in SQL Server which is referred to as a relational database – this is a generic name given to a group of database programs that store information in indexed tables… Continue reading 0006 Relational Database some background
0007 Bulk Import of Data
Depending on your role type users may be able to bulk import data into the database. This powerful feature will assist you in getting up and running with information into the primary tables quickly. Firstly talk this over with your system administrator and if in agreement he will assist you in importing information into the… Continue reading 0007 Bulk Import of Data
0010 Getting Started – login
CASK Inventory Database – to get started navigate to the url you should have been given and enter the username and password you have been given. Please note that if you tick the remember me option on this screen your browser should remember your username and password when you next navigate to the site. If… Continue reading 0010 Getting Started – login
0011 Frequent User Tip – Chrome or Edge users
Users of Chrome or Microsoft Edge can alter the size of text by using the three dots in the top right of the browser window. In Chrome these are vertical in Edge these are horizontal clicking on them will reveal a zoom option. Clicking on negative will reduce the size of text clicking on positive… Continue reading 0011 Frequent User Tip – Chrome or Edge users
0012 Frequent User Tip – Chrome set up a web page to run in an application window
For Chrome users Google has created a special browser short cut that removes the url and tabbing associated with a normally accessed browser window. This gives several usability improvements when used with CASK inventory database. It is a feature of chrome and can be used with any given url. In order to benefit from it… Continue reading 0012 Frequent User Tip – Chrome set up a web page to run in an application window
0020 Opening Screen and Introduction to roles
CASK Inventory Database allows administrators to allocate users to roles with different access rights. The roles setup in the database at present are Read Only – users can see all screens but export of information is not enabled Read Only with export – users can see all screens and are allowed to export information to… Continue reading 0020 Opening Screen and Introduction to roles
0030 Look up fields
A look up is one of the names given to a field that has a restricted selection. Restricted selection allows users to increase the speed of input and allow more consistency over values entered on mobile devices and it allows improved validation of values being entered or edited into fields on all devices. The CASK… Continue reading 0030 Look up fields
0040 CASK Inventory Database – Getting started with the customer relations management (CRM) aspects
For distilleries that sell casks to private individuals it is important to match up individual contact details with individual casks and allow notes to be held against those casks. The CASK Inventory Database has tables that will allow you to store individuals details and organisation details and link these to casks in a many to… Continue reading 0040 CASK Inventory Database – Getting started with the customer relations management (CRM) aspects