Home
Startup
Jobs
System
Calculate
Preferences
Security
Data Menu
Profile
Support info
Data Files
Tutorials

Visit our blog for more on-line help and support

blogger-simple-white
Data Files

Reindexing

Scheduled reindexing

A system of remote Re-Indexing of the data base has been developed as a method of keeping the file index's in good order.  File indexing errors typically occur as a result of power outages, power fluctuations and indiscriminate turning off of PC's.

To activate the remote reindex system, choose a PC which remains on or is left in 'Sleep' or 'Hibernate' mode at night.

  1. Edit the PC's registry 'HKEY_CURRENT_USER\Software\Avdata\AMS32'.
    Check that the key  'Sys_IdxName' is set to the PC user name (same as AMS user).  Set the key 'Sys_IdxHour'  'Decimal' is set to the desired hour (24 hour system)
  2. Set up the Windows 'Scheduled Tasks' to begin 'C:\AMS32.exe' at the set time.  Set task scheduler to 'Wake PC' to perform task if the PC is set to  'Sleep' or  'Hibernate' mode at night
  3. At the specified time the PC will 'Wake', AMS32 will open, run reindex and close.  A report of the activity can be found in 'C:\AMO\Voerror.log'
  4. For users of Multi Directory AMS32 set a PC up as described in 1 - 3 above.  Select an alternate data directory for the evening and the alternate directory will be re-indexed

Multiple data directories

A system of Multiple Databases has been developed to accommodate the administration of two or more inventories by the 'AMS32' program. This is to facilitate consignment stock, remote inventories or year end mirrors of the data. The main data base is called the 'Master Database'. With the purchase of the 'Multiple Database' module the user will be supplied with a program update. Select 'Data Directory' and the 'Data Directory Selection' box W925 will be shown. Single clicking with a mouse on the description will display the data path to that directory. Double clicking on a description will select that data. The program may then be used with the data bases selected. To return to the master data base merely go through the data base selection again. If the program is closed while a secondary database is selected that data base remains active. When the program is next started a warning will be given that a data base other than the 'Master' is selected. No warning is given when opening the program with the 'Master' data base selected. Security need not be reset as the security and user files are linked to the file in the main data directory.

To move parts from one database to another, the parts must be issued to a job. Create an 'Aircraft' to designate the 'Supplier' database. Create a new job and link it to the customer 'Aircraft'. Use the 'Description' to identify the parts transfer (ie Order number or Reason). Click the box marked 'Consignment' on the top right of the 'Job' window(W101). This will switch off the following buttons; Close Job, Adjust Selling, Build Logbook, Log Book Date and Extra Costs. In their place new buttons are shown. These are 'Consignment Parameters' and 'Export'. The job is now setup to be used to export parts from the current database to another. Issue parts in the normal way to the job. When the issue is complete, add freight costs and any mark-up desired to the 'Job' (W101) window. The Freight cost will be divided between all parts and added to each item as a percentage of the parts cost. ONCE THE JOB IS CLOSED IT IS IMPOSSIBLE TO REOPEN IT AS THERE IS NO WAY OF CHECKING IF THE PARTS HAVE BEEN CAPTURED IN THE OTHER DATABASE !!!

Click the 'Export' button to close the job and export the data. Parts will be calculated and the job closed. Please note that the selling price of consignment parts is not recalculated with the default parts markup at this time. Run 'Calculate in the 'Housekeeping - System - Calculate. Data is then written to the consignment file. The parts are now considered to be 'In Transit', waiting for an electronic delivery note to be generated. Create an electronic delivery note for the parts by going to Transactions - Parts - Consignment. Click 'Export' in the 'View Parts' - 'Unprocessed' section. Select all parts (or individual part) to be delivered. Click 'Export'. This will create a dbf file in the drive specified in the Preferences window (usually 'C:\amo\export').

These export files are numbered by date and time. (Ie 199909051422.dbf was created on 05/09/199 at 14:22). Copy the new file to a stiffy and include with the parts delivery, or e-mail the file to the recipient. The parts are now removed from the program files with full trace as to where they went. To import the data into the required database, simply insert the stiffy in the drive specified in the Preferences Window import directory section. This may also be a hard drive directory for e-mail or network files

Select Transactions - Parts - Consignment. Make sure that the 'Import' box is ticked and press 'Load File'. Highlight the file to import and it will display the parts contained in the file. Press 'Select All' and then 'Import'. This will complete the import of parts into the 'Inventory' file. The origin of a part batch can be ascertained by checking the 'GRV' box in that particular parts batch. The GRV number applied relates to the job number of the issuing database. If a part is received for the first time in the database, an entry will be generated in the parts file, with similar descriptions to the originators part name and description. A bin number for new parts will have to entered. Note that the cost price of these parts will be the original cost price plus consignment mark-up. Freight will also be added to the new cost price to determine the new landed cost.

Create a Multi data directory

This can be created on any PC running AMS with a level 5 security. The mapping of network drives must always be to the same letter as the AMO data, ie: 'Q:\'. Multidata will not work if all PC's do not have the data drive mapped to the same letter (ie 'Q:\'). Ensure that the network drive is always available. Load the 'AMS32' Data files into this new directory. This may be done from the 'AMS32' distribution CD-ROM or the latest 'Data' update.. Locate the 'Data' sub- directory on the CD-ROM and select 'Setup'. This will begin the unpack and setup of a new database. At the prompt select the new data base path and press 'Continue' Select 'Housekeeping - Preferences' and press the 'Muti Data' button. Add the new data directory together with a description. Ensure that the directory path ends with a '\' This file, AMODir.DBF, may only exist in the Master directory. It will now be noticed that in the 'Job' window (W101) a new selection 'Consignment' is shown.   The program is now set up to function as a Multi Data program, that will allow users to switch between various databases. This is a good method to keep track of month or year end status. Simply copy the AMS directory at month end to a new data directory and add this to multidata for easy reference to stock levels, WIP etc at a point in time.

Visit our blog for more on-line help and support

blogger-simple-white

AvdataLogoSAviation Databases develops and supports this application and other dedicated solutions for the aviation industry.

[Home] [Startup] [Jobs] [System] [Tutorials]