The Integrated System
The .dbf database files from both the above systems were merged, and data cleaning was performed on this single composite file. Note that the actual filename from which each record originally came is stored in the database (known as CATDATA.dbf); this will enable cross reference back to that original Enable database file or Symphony spreadsheet file if necessary.
For Dar es Salaam, all the records with origin as 'MARKER' were deleted from the system, because they were bogus records and not raw data.
For the following databases, the price values had to be multiplied by a factor of 10, since it was very apparent that a mistake had been made. This may be due to a lack of field capacity in the Enable computer system in Moshi, or it may be due to some operator mistake. Since this problem was discovered while back in Dar, it was not possible to check at the time with Mr Swai for his comments; that should be done at some time.
93/10 93/10 (3)
Numbers in brackets are for cases where not all records appear to be faulty - only the quantity indicated.
For the record, the databases affected are (in sequence as above) : ARUJAN.dbf, ARUMAR.DBF, ARUDEC.DBF, ARUAUG.DBF, AROCT93.DBF, ARDEC93.DBF, ARJAN94.DBF, ARJUN94.DBF, ARJUL94.DBF, ARAUG94.DBF, WWOCT93.DBF, MSDEC93.DBF, MSJAN94.DBF, WWJUN94.DBF, WWJUL94.DBF and WWAUG94.DBF.