Tool Movement shortcut/bar code

Movement of tools from and back to the store can all be done from the Tool Movement Window W101, available from the waterfall menu: ToolMovement | Record option.  Movement can be recorded by selecting the destination and then the tool from the various drop down lists.  There is however a shortcut that will assist with capturing higher volumes of Tools.

This shortcut can be implemented by menually entering the item code in the “Encode” field, or scanning a bar code when the cursor is in the “Encode” field.  Each entry in the database has an unique code id.  You will for example see that staff has an id starting with 1/xxx and jobs 2/xxx etc.

To select a job enter the unique code in the encode field.  In this example our selected job has the code: 2/17793

Now this can be entered into the encode field followed by the tab key on W101 which will select the job and clear the encode field for the next entry.

In the same manner, one can proceed to enter all the other codes for tools and tool groups etc.  This method works exactly the same as manual selection, apart from the fact that selection is done from a code entered.

It is important to note the status messages on this screen as an incomplete instruction or incorrect instruction will be displayed on this status window.

Some of the standard reports incorporate the codes as well as barcodes in the report.

Bar Codes

Bar codes can be scanned from any inline bar code scanner.  These scanners are installed to simulate input from the keyboard. There are various standards in the scanner configuration.  Most scanners require a special character to indicate the start and end of the bar code. If you print your own bar codes, remember to include these in the code.  The ’*’ character is commonly used to indicate the start and end of the code.  If ou want to print your own codes, the example above would require the followinf characters to be printed: *2/17793*  It is also recommended to configure the bar code reader to add a tab character to each scan.  This ensures that users do not have to manually press the tab character once a code is scanned.  To print bar code, download a suitable font.  The one we use in the program reporting is: 3 of 9 Barcode.

Tool Manager - Printer selection

Users have the option to select a printer other than the default printer, where all reporting could be directed.  This could be changed away from the deafult printer on the report preview screen for any specific report.  If no default printer is selected for Toolmanager, all reports will be directed to the default printer of the specific station.

A default label printer can also be identified or selected in the program to anable the printing of labels.  Label report options will not be available if a label printer is not selected.  Label printers available for this option is limited to a specific label size and other labels might produce unexpected format problems.  Please contact Aviation Databases to confirm these requirements.

These selections are station specific for each user and can be accessed fom the waterfall menu option: System | Configuration and then the Station Tab.  From this window users can select the default printers for the specific station.

To verify the default printers as selected, this is easiest done from the Help About window.  Open this window from the waterfall menu and open the Station heading.  All selections related to the specific user station will be shown, including the default printers selected.

Installation to evaluate an application

Introduction

In order to assist users evaluating our applications, we now have a SQL server available on the internet.  Users can install the specific program on their local PC and connect to the demo SQL server to evaluate the program.  This process depends on the available band width (internet speed) and can sometimes be slow.  The evaluation program is fully functional and give users all the features on-line to test, print and evaluate.  This reduces the installation effort to a couple of very simple steps and users can be up and running quickly.

Please keep in mind that connection to your local SQL server will be much faster and handling large volumes of data can be done very efficiently once you move over from the internet based server to a SQL server on your own network.  Currently this demo feature is available for Tool manger and Status programs.  No registration is required and users can experiment with the test data as required.

Overview

To install and use an evaluation program, users must follow the following basic steps, which are explained in detail below.  Note that the steps are similar for all the evaluation programs.

1. Download the relevant installation program from our server.
   1. Demo server web site address click here.
2. Save the install program and Run when download is complete.
3. Run the newly installed program icon to run the program and connect to the Demo SQL server.
4. Download and update report templates.
5. Evaluate the program.

Download

To start the download, select this link or enter the full web address: http://vps3720.vmachine.co.uk in the address field of your Internet Browser.  Select from the download page the applicable program to download for evaluation.  When the download window is shown, it is recommended to Save the file and then Run the downloaded file once downloading is done.

Installation

Once installation starts, you will be prompted to answer various installation questions.  Select the default answers and ensure that you do not install as a server PC.

Configuration

After installation, a menu option will be available to run the program, but you will also be prompted to run the program from the installation dialog.   When the program is executed for the first time, users will have to define the origin of the SQL Server.  The connection window will open.  For evaluation of the program, users can connect to the Demo server.  Check the Demo SQL Server box.  The program will automatically check that the SQL server is available and that TCP Port 1433 is open for communication through your firewall.  If the Server is available, select the Open button.

The program will try to connect to the remote server and save the connection.  The ODBC connection will also be configured as this is required for reports that are generated by the program.  This should all be automatic, if you have internet connection.  Notice the messages that appear  on the program status bar. Give one command at a time as this method of remote connection can be slow at times.  (If this connections fails, it is most likely due to the firewall settings on your PC that prevent the program to connect to the internet server.  Please ask your IT support to open the firewall for the specific program and to check that TCP port 1433 is open for communication to the remote SQL server.)  Once connections are established select the Exit button. There is one remaining step required; to download the report templates.

Report Download

The report templates will be downloaded to the default directory from inside the program.  Under the configuration window, select the Station tab.  Notice the “Report update” button.  Select this button to start downloading the report.

Evaluation

You have now completed all the required steps to evaluate the program.  Note that you have some areas of the program that are restricted to Demo users, but you should be able to understand the functioning of the program as explained on the web links.  Please feel free to contact us for more information and visit or web link for more information of the programs:

• Tool Manager - Click Here
• Status Maintenance Scheduler – Click Here

Grant application user access

Users must have sufficient access rights or roles on the SQL server to connect to the database and access the database files and procedures as stored in the SQL server.  This is applicable to all programs using a SQL server for the data, like Toolman and Status.

Installing Status and Toolman applications for the first time on a server machine, will grant the SQL user sufficient access to the database.  It is however necessary to allow other users access to the database.  This can be done from inside the program from the SQL connect window.

There are two different possibilities here, users can log on with Windows Authentication, where the program will use the access asigned to the “BUILTIN\Users” or specific users where Windows Authentication is not used.

From the waterfall menu select the SQL Connect window, connect to the server and select Save on the catalog selection.  The Manage Access button should be available if you have sufficient access to grant access to others.

Select the “Manage Access” button.  The window that will open shows all you access rights and has two options to grant rights to other users.

 

Selecting the top “Grant” button, will allow all “BUILTIN\Users” access to the selected catalog or database.  This will therefore work in a domain or environment where users will connect through Windows Authentication.

Alternatively, it is possible to create users and assign the applicable rights to this new user to access the database.  Note that some SQL server requires a strong password, otherwise this step might fail.

Once access is granted to other users, there should be no problems for them to connect and use the applicable database from the program.

---

Users experienced in SQL can use the Management Studio application to set this access.  Assign the database owner role to users.

Installing Toolmanager software

Our toolmanager program is designed for the aviation industry to keep track of tools.  Tools can be issued to staff, jobs or sent for calibration.  Various reports assist users to keep track of tool movement.  For more information about the program, please link to our Toolmanager web site.

This article follows a step by step guide for fist time installations.  Please contact us from the link on the web site to arrange for the FTP details to download the evaluation program.   This installation assumes that users have a SQL server 2008 Express or better installed on the network.  The first installation must be done from the server machine to attach the database to the server.

Once the installation program (ToolSetup.exe) is downloaded, it is recommended that you copy this to a directory on the server machine where all users can access the exe for the first installation as well as for future upgrades.  This directory is remembered as a default location for future installations.

Run ToolSetup.exe

Select all options for a first installation, provided that you are on the SQL server machine where the empty table structure can be installed.

Note on the install summary the default paths where all the files will be installed.  The Toolman.exe will be installed in the default Program Files directory.  As this is a server machine, an empty database will be installed in the directory c:\ProgramData\Avdata\SQL  This is done to allow the program to attach this database to SQL.

Now run the program TM.exe

First time users will automatically be taken to the SQL connection window.  At this stage the SQL server must be running and you must have sufficient access to the server.  The preferred method to connect is by means of Windows authentication, but any SQL power user can be use to attach the database.

This window opens with the default values, but can be changed for each installation.  Select the “Open” button to test for a successful connection.  Once connected, the Catalog section will be available.  The “Create” button should be available if you have sufficient rightsa and if the installation section had the “Server” install option checked. Click on “Create” to attach the dabase as installed earlier.  A successful installtion should produce the screen below.  Note the important last line: “Database found in SQL server”.  If this is not shown, something went wrong and the database did could not be attached.

Now click “Save” in the Catalog section to store this information for future connections.  You will notice that the ODBC connection will automatically be created.  Make sure that the connection method, ie user and password or windows authentication is correct.  Select the “Test/Save” button. 

You can now exit from this window and the Toolmanager application should be configured for use on this machine.

 

---

On subsequent installations on pc’s linking to this server, follow the same steps, without selection of the server installation during installation.  Once you have connected to the SQL server, the “Create” button will not be available, but the drop down list will have the catalog adbTools which can be selected before the “Save” button is selected.