SPEEDATA

OPERATING INSTRUCTIONS


Menus | Functions of keys | Keyboard styles | Creating formats | Multiformat files | Starting SPEEDATA | Verification | Advanced features



SPEEDATA Features

SPEEDATA is meant for batch / large volume Data Entry work.
SPECIFICATIONS

AUTODUPLICATE - For dates , city names etc. ..
MANUAL DUPLICATE - To duplicate fields , even partial fields from previous records. Using the right arrow key.
MEMORY KEYS - Store & recall repeating items. Using F2 - F12 keys.
AUTOINCREMENT - For vouchers , bank numbers etc.
KEYBOARD OPTIONS : Keyboard can be changed to suit DE operators from UPTRON , HCL or a PC background. Using Ctrl-H , Ctrl-U.
PREVIOUS Record displayed .
MULTI FORMAT with CIRCLE & CHAIN options .
MAX FORMATS = 9 per file.
Operators with a PC or off line machine experience can very easily use the software. Formats are defined in the same way as in standard off-line data entry machines using dashes '-'.
E.g. A--------N---------Y---------S----------E
A field here is represented by "A--------" a letter followed by minus signs. The number of minus signs are one less than the length of the field. And the "A" represents the type of field. In this case an alpha field. The "N" represents a numeric field...
One record consists of a single line as viewed in a Text Editor ( EDIT.COM in WIN9x/WIN2000/WINME).Here the data entry record is shown in a line in the same way as it is stored on disc. Access, and others store records in the same way but the data entry screen can have many variations.

Load FILE.FMT into an ASCII editor like EDIT which is standard with all versions of WINDOWS to view it.

FILE.FMT also contains instructions regarding how to create formats.

(FILE.FMT contains all the formats of the files you create - the
word 'format' is the same as 'structure' in XBase terminology i.e.
the type of field and length of field or item )

Queries even for unregistered software will be replied at
e-mail : anilbhx@yahoo.co.in also full support by e-mail or chat.

THE COMPUTER CENTRE , 62/A The MALL , PO BOX 65,
Meerut Cantt. UP , INDIA 250 001 . Tel :91-121-642115.



MENUS

The MAIN MENU has the following options :


1.Enter 2.Verify 3. Format 4. Inspect 5. Config 6.Exit 7.Cut

ENTER
To begin entering data to a new or existing file .

VERIFY
To begin verifying data in an existing file.

FORMAT
To enter the format and field names. FORMATS & HEADING lines are maintained in a single file called "FILE.FMT" .The operator is transferred to DOS. 1 SPF is used to create/ edit or delete formats in FILE.FMT. A text editor can also be used here. ( page 10 ).

INSPECT
View a record of sessions, operator name etc.

CONFIG
To change the drive on which data and associated files are
written .

EXIT
The main exit .

CUT
To remove the last character of every record .This character is
added to store the format no.

The SECOND MENU - accessible ONLY through ENTER or VERIFY options . Comes up by pressing the ESC key .

The options provided :

1.View 2. Update 3. Delete 4. Insert 5. Continue 6. Exit 7.Rectify

VIEW : Enter the starting record number and press <ENTER>. Records are displayed from the given number. If only <ENTER> is pressed then next 8 records are displayed.

UPDATE : After viewing , a record number can be given for correction or all records can be re-entered from a certain number.

SEARCH : If the first character entered is a '*' followed immediately by a search string and column no. then records containing the string will be displayed for updating.

E.g. : *V23456,15
will search for V23456 from column 15.

INSERT
Records are inserted before a record . i.e If a record has to be inserted before record number 957, then type 957 .

DELETE
One record or a range of records can be deleted.

CONTINUE
To continue after Viewing etc.

EXIT
To go to main menu.

RECTIFY
To make corrections to AUTOINCREMENT AUTODUPLICATE fields.


FUNCTIONS OF KEYS



The ALT KEY in conjunction with the top row numeric keys will select formats when multiformat data entry.

CAPSLOCK should be on.

SHIFT KEYS function as usual during alpha fields. Use the left shift key to enter alpha during numeric fields, and numeric during alpha fields.

ERROR RELEASE When an error occurs the keyboard locks up . <Enter> will release the keyboard .


SKIPPING DURING ANY FIELD Pressing ';' in the middle of any field will cause jumping to the beginning of the next field. During entry 0's are filled, to the end of the field if numeric , and spaces if alpha. During verification fields are checked for 0's or blanks.

BACKSPACE KEY Used to delete characters .

FIELD CORRECT DURING VERIFICATION The Backspace key functions as the field correct key during verification .

MANUAL DUPLICATION
7 KEY (top row) Is used to duplicate characters from the previous record during entry. During verification a comparison is made with the corresponding contents of the previous record .

RIGHT-ADJUST KEY [';'] Must be pressed in every right adjust field. The key "0" functions as decimal during right adjust field .

AUTODUPLICATE SWITCH [Ctrl-D] This toggles the AUTODUPLICATE FUNCTION ON and OFF. Many duplication options are available . '7' Key -(Full field). RIGHT ARROW - will duplicate 1 (ONE) character. END - will duplicate up to next space or field.

ESCAPE KEY During entry or verification ,calls a SUBMENU with the choices VIEW, INSERT, DELETE, UPDATE ,EXIT , RECTIFY.


RECORD DISPLAY ['\'] Pressing this will display the record during verification. Maybe used when data is known to be reliable.

RECORD ADVANCE [ ']' ] Skips the rest of the record.

TAB Key [Field advance/ Field back] Functions as field advance and field back during correction. SHIFT-TAB or HOME for field back.

SAVING FILE TO CURRENT RECORD [ Alt - S ] will save file to current record.

CORRECTING A PREVIOUS RECORD Press UP ARROW key to reach the required record. Correct the record and press the DOWN ARROW or ESC key to continue .

ALPHANUMERIC KEYS - Alpha as well as Numeric: these keys are the following when in alpha mode: "9" , "U" , "I" , "O" , "J" , "K" , "L" , "M" , "," ,".". The key "0" functions as decimal during right adjust field . When a numeric field is present then pressing any of the following keys results in the changes shown below:

"9" -> "0"
"U" -> "1"
"I" -> "2"
"O" -> "3"
"J" -> "4"
"K" -> "5"
"L" -> "6"
"M" -> "7"
"," -> "8"
"." -> "9"

Exceptions in the numeric field : Characters allowed are '.' , '-' and '$' .
KEYBOARD STYLES(UPTRON/HCL/PC)



The modes are shown by small indicators at left of the screen.
NORMAL MODE : This is the same as UPTRON OR IBM 3270 configuration . Duplicate key is '7'. skip is ';'. Keys are changed as noted above. This mode is toggled by Ctrl-U.

PC MODE : In this case the keys are not reconfigured in the main keyboard. This is put ON by putting OFF NORMAL MODE - by pressing Ctrl-U. Numeric data entry is done with the numeric keypad .The grey '/' key is for duplicate and grey'-' for skip.
HCL MODE : Toggled with Ctrl-H. The numeric keypad is reversed . i.e. '*' is '0' and '3' is '9'. Duplicate and skip are as in PC MODE.


For numeric fields in UPTRON mode.


  ÉÍÍÍËÍÍÍËÍÍÍËÍÍÍËÍÍÍËÍÍÍËÍÍÍËÍÍÍËÍÍÍËÍÍÍËÍÍÍËÍÍÍËÍÍÍËÍÍÍ»
  ºESCº ! º @ º # º $ º % º ^ º & º * º ( º ) º _ º + ºBckº
  º   º 1 º 2 º 3 º 4 º 5 º 6 º 7 º 8 º 9 º 0 º - º Í ºspcº
  ÈÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊËÍÍÍÍ»

    ºtabº Q º W º E º R º T º Y º U º I º O º P º { º } º  º E  º
    º   º   º   º   º   º   º   º   º   º   º   º [ º ] º  º n  º
    ÈÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍ»º t  º
      ºCtrº A º S º D º F º G º H º J º K º L º : º " º ~ ºº e  º
      º   º   º   º   º   º   º   º   º   º   º ; º ' º ` ºº r  º
ÉÍÍÍÍÍÎÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍÍÍÎÊÍÍÍͼ
ºShiftº º   º Z º X º C º V º B º N º M º < º > º ? ºShiftº
º     º º \ º   º   º   º   º   º   º   º , º . º / º     º
ÈÍÍÍÍÍÊÍÊÍÍÍÊÍÍÍÊÍÍÍÊÍÍÍÊÍÍÍÊÍÍÍÊÍÍÍÊÍÍÍÊÍÍÍÊÍÍÍÊÍÍÍÊÍÍÍÍͼ
Changes
to this
  ÉÍÍÍËÍÍÍËÍÍÍËÍÍÍËÍÍÍËÍÍÍËÍÍÍËÍÍÍËÍÍÍËÍÍÍËÍÍÍËÍÍÍËÍÍÍËÍÍÍ»
  ºESCº ! º @ º # º $ º % º ^ ºDupº°*°º°0°º . º _ º   ºBckº
  º   º 1 º 2 º 3 º 4 º 5 º 6 º°7°º°8°º°9°º 0 º Í º Í ºspcº
  ÈÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊËÍÍÍÍ»

    ºFldº Q º W º E º R º T º Y º°1°º°2°º°3°º P º   ºRecº  ºE   º
    ºAdvº   º   º   º   º   º   º°U°º°I°º°O°º   º   ºAdvº  ºn   º
    ÈÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍ ºt   º
      ºCtrº A º S º D º F º G º H º°4°º°5°º°6°º : º " º ~ ººe   º
      º   º   º   º   º   º   º   º°J°º°K°º°L°ºskpº ' º ` ººr   º ÉÍÍÍÍÍÎÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍËÍÊÍÍÍÎÊÍÍÍͼ
ºShiftº º   º Z º X º C º V º B º N º°7°º°8°º°9°º ? ºShiftº
º     º º \ º   º   º   º   º   º   º°M°º°,°º°.°º / º     º
ÈÍÍÍÍÍÊÍÊÍÍÍÊÍÍÍÊÍÍÍÊÍÍÍÊÍÍÍÊÍÍÍÊÍÍÍÊÍÍÍÊÍÍÍÊÍÍÍÊÍÍÍÊÍÍÍÍͼ
ÉÍÍÍÍÍ» ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» ÉÍÍÍÍ»
º Alt º º S P A C E B A R                                º ºCapsº
ÈÍÍÍÍͼ ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ ÈÍÍÍͼ

FORMATS IN FILE.FMT

This file can be created by using EDIT in DOS . Or any other TEXT editor . A separate program ( not included in the shareware version ) can be used to create formats as in DBASE , FOXPRO etc.
AN EXAMPLE
Suppose a given record has the following fields:

S.NO FIELD NUMBER OF TYPE OF FORMAT

NAME         CHARACTERS        FIELD         CHAR
1. Date              6                 NUMERIC DUPLICATE  D
2. Voucher No.       6                 AUTO INCREMENT     Y
3. Item description 20                 ALPHA              A
4. Account Code      4                 NUMERIC            N
5. Dept. Code        4                 ALPHA DUPLICATE    L
6. Amount            8                 NUMERIC            N
7. FILLER           16                 SKIP               S
8. Part no.          8                 RIGHT ADJUST       R
ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ
                    54


LIST OF FORMAT CHARACTERS (field types)

A - ALPHANUMERIC field .
F - Verify Bypass ALPHA .
L - ALPHA AUTO-DUPLICATE field when the AUTODUP switch is ON (
by pressing Ctrl- D).
M - ALPHA for NAMES. Does not accept Numeric.
N - NUMERIC field.
B - BLANK FILL NUMERIC. Allows Alpha also.
T - Verify bypass NUMERIC.
Q - For 2 equal fields . BEEP on mismatch.
D - NUMERIC AUTO-DUPLICATE field .
R - RIGHT ADJUST (NUMERIC)(Left Zeros)
J - RIGHT ADJUST (ALPHA)
Y - AUTO INCREMENT field .
X - BATCH TOTAL field
S - A field which will be skipped during DATA ENTRY, and one which will not be verified during verification. During verification the contents of field will be displayed.
V - Check digit generate W - Check digit Validate.

Others: "-" { MINUS sign } and DECIMAL POINT ".".Their use will be clear from an example.

Using the description of format characters given .
The FORMAT LINE for such a record will be :
This is created by SPF and can be created with any Editor.
D-----Y-----A-------------------N---L---N----.--S---------------R----E

The number of dashes is 1 less than the length of the field. A
FILLER field , blank field or skip field is useful in multi format equal record length files .This is shown by the field beginning with "S".

Format Characters must be CAPITALS .

HEADING LINE: The total characters should not exceed the format line length. Take care to align the first characters of headings with the letters 'A' , 'B' ,'Y' etc. This is not be done automatically.
A sample Heading Line : Note the beginning of the field is in CAPS.

D-----I-----A---------------N---L---N----.--S-----------R-----E
Date..Vchno.Item.DescriptionAcd.Dcd.Amount..Blank.......Rt.adj

The Format line must end with a CAPITAL "E" .

Up to 9 pairs of formats and headings can be specified, for multiformat files .

ENTRY OF THE FORMAT AND HEADING LINES

To enter formats 1 SPF is provided . This uses the same method as FOXBASE and dBase to create the format lines . All help is provided in the program. Once the field list, type and size is available formats can be prepared.

When using a text editor :
Enter the name of the format . If there is only a single pair of format and heading lines nothing else needs to be entered on line but if there are more pairs , say 3 , then 3 is entered as follows

MASTER for single format.
MASTER/3. for 3 formats.
If these format lines are to be chained then enter
MASTER/3/CHAIN.
So for a file with a single format & heading pair the first line

will only contain the word MASTER . Comments can be added if started with a '*' in the 1st column.
1st line
1:*MASTER
Then ,enter the above format line,
2nd line
2:*D-----Y-----A-------------------N---L---N---.--S---------- -----R-------E

PRESS <ENTER> and enter the heading line, it can be all blanks also.
3:*
3rd line
3:*DATE..VCHNO.ITEM.DESCRIPTION....ACD.DCD.AMOUNT.. BLANK........... PRESS <ENTER>

More formats can be entered as long as the same order is followed. And as long as the actual number are mentioned after the format name after typing a / .
E.g. as above MASTER/3 .
IMPORTANT: The order of entry must be. Format Name and PARAMETERS.
Then FIRST the FORMAT LINE and then the HEADING LINE.
Press Enter to leave line blank. Only after the FORMAT FILE is created can actual data entry
begin.

Some Format examples :

a) Single format
PAYROLL
A---------------N------------E
Name............Salary.......
b) Multi - format
PAYROLL/3
A---------------N------------E
Name............Salary.......
N-------A---------N----------E
Pfno....Desc......Ledger.....
A-----------------N----------E
Deduction.........Amount......

MULTIFORMAT FILES

As noted earlier formats can be entered using either an Editor or the utility SPF1 on the disk . SPF is most convenient to use for beginners but lacks the flexibility of using an Editor. Formats created with SPF in FILE.FMT can be edited with an editor.

MULTIFORMAT
Operation of CIRCLE or CHAIN or MB words in the 1st line of the format. The first line of a format has the following structure.

NAME OF FORMAT/No. of formats/CIRCLE or CHAIN or MB.

For Example:
If
Format Name : PAYROLL
No. Of Formats : 3
Then the 1st line will be

PAYROLL/3 <-- digits allowed here 1-9 only. No space.

Formats will not change AUTOMATICALLY. To change press the ALT key with a top row numeric keys. (E.g. ALT - 2 etc. ).

If the formats are required to be presented in the sequence 1 then 2 and then 3 and again 1, automatically the line will be:

PAYROLL/3/CIRCLE

If it is required that format 1 be presented 1st then format 2, and STAY on Format 3 the line will be:

PAYROLL/3/CHAIN

The option /MB will duplicate from Format #3 (for example) only to format #3 instead of from previous record, as in the default case.

SUMMARY

1.All formats are contained in a single file called FILE.FMT.
2.There are a minimum of 3 lines for any format. The 1st line contains :

NAME of Format[/No. of formats/[CHAIN|CIRCLE|MB]
^ ^
1 Digit only |
NO SPACES ONE of these words
3. The 2nd line Contains the actual format.
4. The 3rd line contains a heading line which can be left blank.
5. If there are 3 formats in a MULTIFORMAT job then the total no. of lines will be 7 . 1 Identifier line and 3 pairs of format and heading lines. ( 2 x 3 + 1 ).

STARTING SPEEDATA

Instructions and 2 are in the README file.

Type
C\SP> SP To start the program.

The data drive ,password ,operator ,format name and data file name are required. Just press <ENTER> in response . If it is a new file, record numbering will begin from 1 .If not then from the record following the last . There will be no change in keyboard for alpha fields. For numeric fields the following keys will change as shown . 9 to 0,U to 1,I to 2,O to 3,J to 4,K to 5 L to 6, M to 7, "," to 8,"." to 9 as already noted. To type numerics in alpha fields ,use the numeric keypad or press the LEFT SHIFT key.

The '7' key is used for DUPLICATING. AUTO DUPLICATE is toggled by CTRL-D. ESCAPE key transfers control to the second menu explained above .It is used to EXIT from menus. With the existing Formats in FILE.FMT press enter for all input and keep the RIGHT ARROW Key pressed. To see the operation.

VERIFICATION

The data to be verified is re-entered or keyed in, as if it was being entered during data-entry. The difference is that the data is not recorded on disk but each character is checked with the existing record . If corrections are to be made then the record written to disk . For a mismatch then there is a beep and an error is flashed. If the character in the record is wrong then it can be corrected by pressing the correct key . The keyboard is released by pressing the <ENTER> key .

The verification process is reliable and faster than visual checking . Data after verification is found to have fewer errors than visual checking.

Reading files from a COBOL or BASIC Program

We show a DATA DIVISION entry in COBOL and a corresponding FIELD STATEMENT in BASIC for the record defined on page 8.

COBOL
01 VOUCHER-RECORD.
05 DATEX PICTURE X(6).
05 VOUCHER-NO PICTURE X(6).
05 ITEM-DESC PICTURE X(20).
05 ACNT-CODE PICTURE X(4).
05 DEPT-CODE PICTURE X(4).
05 AMOUNT PICTURE X(8).
05 FILLER PICTURE X(17).
[One extra for the mark]
An equivalent FIELD STATEMENT in BASIC
is :
MICROSOFT BASIC

FIELD #1,6 AS DATE$,6 AS VCH$,20 AS ITEM$,4 AS ACN$,4 AS DEP$,8 AS AMT$,19
AS FILLER$
^ 3 bytes extra for the
mark + CR/LF

END OF RECORD CHARACTERS: There are THREE bytes at the end of each record which need to be taken care of in programming . Each record contains a CR/LF code at the end plus a byte before the CR/LF bytes for format information.

MISCELLANEOUS

  1. The "X" field is used where page totals are given in documents. Pressing Ctrl-T will reset the total counter to 0.
  2. RECTIFY : In the EDIT MENU a new Option has been added to correct AUTO INCREMENT and AUTO DUPLICATE fields. Explanations are on screen.
  3. A "Q" field for share application entry has been added . This can contain application numbers which are entered twice , if the 2nd field does not match the 1st , a beep is sounded and the keyboard is locked .
  4. Alt-Q will toggle a short tick at the beginning of each field . This minimises the need to look at the screen.

ADVANCED FEATURES


MACRO KEYS ( F2 - F12)
Up to 78 characters can be stored in a Macro key. The storing to a Particular key F2 to F12 is done by pressing ALT - = , then press the key or keys to which the characters will be stored. The characters will be stored from the beginning of the field to present position. Pressing the key again will recall the stored data. You just have to remember which key stores what , presently there is no way to view the contents. Or you could press the key in an empty field to see the contents.

FOR EXAMPLE:

Assume the contents of a field are - "THE STATE BANK OF INDIA _ " and the cursor is at the end then all characters from the beginning of the field will be stored upto the cursor into one of the Macro Keys F2 to F12 . ( Whichever is pressed ).

Modifying ONE FORMAT character : When new jobs are undertaken the format is required to be changed frequently . To aid this a feature is provided so that a single character in the format line can be changed . This is a powerful feature and should be used sparingly. If desired an Alpha field can be changed to Numeric and Vice Versa . To activate this feature Press Alt-F1.
This change is NOT permanent and does not change FILE.FMT.



Queries even for unregistered software will be replied at , even free support is available.

e-mail: anilbhx@yahoo.co.in
THE COMPUTER CENTRE , 62/A The MALL , PO BOX 65,
Meerut Cantt. UP , INDIA 250 001 . Tel :91-121-642115.


The latest version is always available at .
http://surf.to/SPEEDATA/
https://www.angelfire.com/sd/SPEEDATA/
https://members.tripod.com/anilbh/
Can't remember the URL's ? Why bother.? Search Google for 'SPEEDATA' . Another site is included but that is for a speech recognition data entry system.