SA:CCP01 4:25:30 pm +-----------------------------------------------------------------+ ¦ C O R R E C T I O N and/or C O N V E R S I O N P R O G R A M ¦ +-----------------------------------------------------------------+ +------------------------------------------------------------------------------+ ¦ ¦ ¦ This program will correct and/or convert the Sr ACCOUNTANT database ¦ ¦ files to a NEW or the CORRECT format. The computer will ask you which ¦ ¦ drive the databases are on. You can convert all or specific files. ¦ ¦ ¦ ¦ This conversion is dated February, 1999 ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ +--------------------------------------+ ¦ ¦ ¦ MAKE BACKUPS OF THE DATA FILES FIRST ¦ ¦ ¦ +--------------------------------------+ ¦ +------------------------------------------------------------------------------+ ¦ (P)roceed without View, (V)iew Structure, (S)ize fields or (Q)uit ( ) ¦ +------------------------------------------------------------------------------+ |
SA:CCP02 4:39:30 pm +-----------------------------------------------------------------+ ¦ C O R R E C T I O N and/or C O N V E R S I O N P R O G R A M ¦ +-----------------------------------------------------------------+ +------------------------------------------------------------------------------+ ¦ ¦ ¦ : : ALL database files except Archived files ¦ ¦ ¦ ¦ : : Company profile file (PARM.dbf) [Feb/99] ¦ ¦ : : Master Account file (MSTR.DBF) [Apr/95] ¦ ¦ : : Names & Addresses file (NAMES.dbf) [Dec/95] ¦ ¦ : : TRANSACTIONS database files [Feb/99] ¦ ¦ : : BUDGET database files [Feb/99] ¦ ¦ : : STATEMENT database files [Feb/99] ¦ ¦ : : AUXILIARY database files [Feb/99] ¦ ¦ : : SOURCE Control and TAX Rate files [Feb/99] ¦ ¦ : : Outstanding Items and NOTES files [Feb/99] ¦ ¦ : : SYSTEM PARAMETER database files [Mar/99] ¦ ¦ ¦ ¦ : : Archived database files ¦ ¦ ¦ +------------------------------------------------------------------------------+ Mark the files that need to be changed since your last update by placing an 'x' opposite file Name and press 'PgDn' when finished |
Mark the files that need to be changed since your last update by placing an 'x' opposite file Name and press <PgDn> and <P> when you have finished your selection. To exit see below.
If you pressed <V>, a similar screen as shown below will appear:
Records Organize Fields Go To Exit 8:18:59 am +------------------------------------------------------------+ ¦FIELD_NAME¦FIELD_TYPE¦FIELD_LEN¦FIELD_DEC¦FIELD_IDX¦STANDARD¦ ¦----------+----------+---------+---------+---------+--------¦ ¦RDATE ¦C ¦ 10¦ 0¦N ¦ ¦If STANDARD = 'NO' ¦APNO ¦C ¦ 3¦ 0¦N ¦ ¦ ¦APSRC ¦C ¦ 2¦ 0¦N ¦ ¦This field is not ¦ARNO ¦C ¦ 3¦ 0¦N ¦ ¦part of the normal ¦ARSRC ¦C ¦ 2¦ 0¦N ¦ ¦system. It may be ¦INVNO ¦C ¦ 3¦ 0¦N ¦ ¦needed by your ¦INVSRC ¦C ¦ 2¦ 0¦N ¦ ¦custom software. ¦REA ¦C ¦ 3¦ 0¦N ¦ ¦ ¦REV ¦C ¦ 3¦ 0¦N ¦ ¦Use: ¦REVEND ¦C ¦ 3¦ 0¦N ¦ ¦ 'PgUp' & 'PgDn' ¦ANS ¦C ¦ 1¦ 0¦N ¦ ¦to view all fields ¦CPN ¦C ¦ 8¦ 0¦N ¦ ¦ ¦CPD ¦C ¦ 25¦ 0¦N ¦ ¦Press 'F10' to ¦PLT ¦C ¦ 3¦ 0¦N ¦ ¦activate Menu +------------------------------------------------------------+ +--------------------------------------------------------------+ ¦ You are about to correct the C:\TEST\SA\SAPARM database file ¦ +--------------------------------------------------------------+ Browse ¦C:\test\sa\TEMPSTRU ¦Rec 1/29 ¦File ¦ExclLock¦ Num Ins Press 'Ctrl'+'End' to accept this change or 'Esc' to Abort |
Read the Database definitions to see what each of the above files are used for.
The length of the Date field type (D) will show the field length of 8, leave this as is because the system stores the date fields in an universal date format. The system knows that when you enter or print the date that the year is a four digit field.
Press <Ctrl>+<End> to accept your changes or press <Esc> to Abort any changes.
The computer will the rebuild the database file(s) you have selected.
For example using the "SYSTEM PARAMETER database files"
as an example:
¦ : : Outstanding Items and NOTES files [Feb/99] ¦ ¦ :x: SYSTEM PARAMETER database files [Mar/99] ¦ ¦ ¦ ¦ : : Archived database files ¦ ¦ ¦ +------------------------------------------------------------------------------+ ¦ (P)roceed or (Q)uit to System ( ) ¦ +------------------------------------------------------------------------------+ |
This procedure will rebuild the following System Parameter files:
"SAPARM.dbf", SAGFR.dbf", "SAEXCH.dbf", "SAINDEX.dbf", "SAAUDIT.dbf", "SAHELP.dbf", "SAEHELP.dbf", "SAUHELP.dbf".
Read the Database definitions to see what each of the above files are used for.
The computer will return to the "SA:CCP02" screen.