Introduction

Manufacturer-specific Autoline modules typically access one or more data files. The generic file editor enables you to view and amend such files directly.

Note: You may find that you are unable to add, amend or delete a record.

What do you want to do?

• Load a file in the Edit File (...) form

• Omit fields (columns) from the grid

• Reduce the number of records (lines) in the grid

• Add a new record

• Amend an existing record

• Delete a record

• See help about the Edit File (...) form

Loading a File in the Edit File (...) Form

To load a file in the Edit File (...) form:

Note: This procedure assumes you have displayed a form with a Utilities option in its menu bar. Its sub-options load the files accessed by the manufacturer-specific module, denoted by [file] in these help pages.

Select Utilities > [file] from the menu bar.

The Edit File (...) form is displayed with the selected file's records listed in the grid.

Deleting a Record

Note: This procedure assumes you have loaded the required file in the Edit File (...) form.

To delete a record:

1. On the Edit File (...) form, do one of:

   • Right-click the grid line representing the record to delete and select Delete record from the context menu.

   • Select the grid line representing the record to delete and select Edit > Delete selected record from the menu bar.

   • Select the grid line representing the record to delete and click the Delete selected record toolbar button

   A Delete Record dialog box is displayed containing the message:

   Are you sure that you want to permanently delete this record?

2. Click Yes.

   The record is deleted from the file and the grid is redisplayed, the line for the deleted record being omitted.

Edit File (...) Form

This form is displayed when you select Utilities > [file] from the menu bar on a form in a manufacturer systems Autoline module. It enables you to edit a file accessed by that module.

Menu Bar and Toolbar

Menu bar	Toolbar	Action
File > Exit		Returns you to the form from which you invoked this editor
Edit > Add record		Creates a new blank record and enables you to enter its contents
Edit > View and edit selected record		Displays the record represented by the selected (highlighted) row in the grid and enables you to amend it
Edit > Delete selected record		Deletes the record represented by the selected (highlighted) row in the grid after prompting you to confirm the deletion
Tools > File Information		Enables you to view file information, extend, re-index, verify, and initialise the file
Tools > Change path > ...		Redisplays the grid with lines sorted according to predefined combinations of sort fields (indicated by Path 1 or Path 2, and so on, in the second panel of the status bar)
Tools > Set file direction to [backwards/forwards]		Redisplays the grid with lines in reversed sort order (using the selected key path)
Tools > Filters > Apply		Enables you to apply new filters to displayed records (grid lines) or edit existing filters
Tools > Filters > Reset		Clears all filters and hidden columns
Tools > Filters > Set start/finish points > Set		Enables you to select the first and/or last records to be listed in the records grid
Tools > Filters > Set start/finish points > Clear		Clears start and finish points, listing all records (the whole file) in the grid
Help > Help		Displays this help page in a web browser
Help > About		Displays version and copyright information

GRID:

The grid's top two rows are column headings containing field names of the file's records, in English and in code, respectively. Subsequent rows contain the file's records.

The left-most column, in grey, is the main sort field and any yellow columns are secondary sort fields.

The grid displays a maximum of 100 records at a time, more being displayed by row request when you reach the bottom. The fourth panel of the status bar states how much of the file is displayed.

Tip: Use the Tools > ... options on the menu bar to reorder, filter, and/or crop the list of displayed records.

Grid COLUMN HEADING Right-Click Context Menu:

Global edit: Enables you to update ALL records within the selected filter criteria with new data

Grid LINES Right-Click Context Menu:

Edit record: Enables you to view and amend the selected record

Delete record: Removes the selected record after prompting you for confirmation

STATUS BAR:

Panel 1: Status of the form, for example Ready

Panel 2: Indicates which of the predefined sort orders to which the grid conforms; Path 1 or Path 2, and so on, referring to the Tools > Change path > ... menu bar options (also selectable by clicking the Change the path of the file toolbar button ). It also indicates the sort direction by triple chevrons (>>> indicating forwards and <<< indicating backwards).

Panel 3: Indicates whether filter criteria are applied to the grid. One of:

• Filter: No: Filter criteria are not applied
• Filter: YES: Filter criteria are applied

Panel 4: States how much of the file is displayed as two pairs of two figures; absolute and percentage. The first pair is the number of records read so far as an absolute total and as a percentage of the file. The second set indicates the number actually displayed excluding any records omitted by filter criteria. If no filters have been set, both pairs should be the same.