Quantum VS Help: File Maintenance

Previous  Next  

Build Super Index Extract

The Build Super Index Extract process extracts appropriate words from your Product, Customer and Supplier records and makes them accessible in the Finder, enabling users to locate Product, Customer and Supplier records using the Finder's Advanced Search facility.

 

You will need to run the Build Super Index Extract process after setting up your Product, Customer and Supplier data in Quantum VS, to generate the words which describe your Products, Customers and Suppliers. Every time you add or amend a Product, Customer and Supplier you will need to run the Build Super Index Extract routine to ensure that the new or changed Product, Customer and Supplier can be located using the Finder.

 

To run the Build Super Index Extract process:

 

1.      Either:

 

The Processes record opens in a new tab, listing all Processes by Name and Category.

 

2.      Use your mouse or [Tab] key to select the Build Super Index Extract process:

 

FileM_ProcessSuperIndexExtract.gif

 

3.      Select process options in the available fields as required, using the following as a guide:

 

Note: You may use your [Tab] key to move from one field to the next.

Field

Definition

 

Index Type

Use the drop-down menu to select the Index Type for extraction:

 

  • Customer: to extract and build index from the Customer record

  • Product: to extract and build index from the Product record

  • Supplier: to extract and build index from the Supplier record

 

Save Template Only

 

The Word Extract phase of the process - see Word Extract below - pulls out all the appropriate words from every record on the chosen Customer / Product / Supplier file to build a vocabulary list for each file. Default templates which define the fields from which words will be extracted are defined/stored in the General tab of the Sales Ledger (for Customer records) and the Miscellaneous tab of the Price Book General record (for Product and Supplier records).

 

If you wish to save a new template, check the Save Template Only field and then specify which of the following fields will form the template used for word extraction:

 

  • Extract for Customer Record: Name; Address 1; Address 2; Address 3; Post Code 1; Post Code 2; Short Name; Telephone Number; Contact.

  • Extract for Product Record: Description 1; Description 2; Manufacturer's Reference; Alternative Word 1; Alternative Word 2; Alternative Word 3 (Note: Alternative Words 1 - 3 are held in the Super Index Alt Words fields of the Product record).

  • Extract for Supplier Record: Name; Address 1; Address 2; Address 3; Post Code 1; Short Name; Telephone Number.

 

Note: If no selection is made, the process will use the default settings in the General tab of the Sales Ledger (for Customer records) and the Miscellaneous tab of the Price Book General record (for Product and Supplier records).

Update Vocabulary

 

If this field is checked, the routine will update existing vocabulary data only. If unchecked, the routine will rebuild vocabulary data from scratch.

 

Word Extract

 

Checking the Word Extract field shows a list of further fields to the right. These correspond to the fields from the Customer / Product / Supplier records from which words will be extracted to form the Super Index. If you wish to override the default settings/template, check the following fields as appropriate so that they are extracted from to build the Super Index:

 

  • Extract for Customer Record: Name; Address 1; Address 2; Address 3; Post Code 1; Post Code 2; Short Name; Telephone Number; Contact.

  • Extract for Product Record: Description 1; Description 2; Manufacturer's Reference; Alternative Word 1; Alternative Word 2; Alternative Word 3  (Note: Alternative Words 1 - 3 are held in the Super Index Alt Words fields of the Product record).

  • Extract for Supplier Record: Name; Address 1; Address 2; Address 3; Post Code 1; Short Name; Telephone Number.

 

If you wish to extract from the pre-defined fields (i.e. the default settings/template as described above) then leave this field unchecked.

 

Cross Reference

 

Check this field if you wish to run the Cross Reference Phase of the routine. This reads the appropriate Customer/Product/Supplier vocabulary file and references each word against Customer, Product or Supplier records to build the Cross Reference file which drives Super Indexing.

 

 

4.      Click Start on the Toolbar - Sub Menu to begin running the process.

 

5.      When the process has finished running, a Status message will be shown. Click OK to close this message. You may now close the Processes tab if you wish.

When The Super Index Extract Has Been Run: Using Advanced Search

Once the Super Index Extract routine has been run, the extracted words are added to the Super Index, enabling the Advanced Search filter to be used to search for exact matching search terms when Products, Customers or Suppliers are active in the Finder. Therefore users may perform searches based on the words/fields extracted from Product, Customer and Supplier records.

 

Note: Advanced Search is available as a filter when Products, Customers or Suppliers are active in the Finder and 'Advanced' is selected on the Finder Toolbar. Advanced Search is on by default but may be switched on and off as required.

 

For example: With Customers active in the Finder and the Sequence menu set to Account Code, you enter the search string 'abs':

 

NEXT: Bulk Account Balances Update