Datasheet

ManualsBrandsCampbell ManualsHome building and DecorSM192

Manual

Annexes

Annex 3: Consecutive Steps in Processing Raw Data Files in Report.

Step

Action

Activate Report by clicking the Report tab on the PC208W toolbar.

Choose Open from the File menu to activate a pre-defined parameter file.

Navigate to the location on hard drive, which contains the parameter files. This is “C:\CAMPBELL\FILES\PARA-

METR” if the Recommended Directory Structure is used. Highlight the concerned parameter file and click OK.

Activate the Input File(s) sub-window and select the Input Data File. To this end click “Browse” in the Input Data

File box and navigate to the location on hard disk which contains the data files. Highlight the appropriate file

and click OK.

Switch to the Output File sub-window by clicking its tab at the top-mid of the current Split screen.

Select location for, and give a name to, the resulting Output file. To this end click “Browse” in the Output Data

box. Navigate to the desired folder on the hard drive and type in an output file name according to the convention

discussed in paragraph 5.3.2.2. Click OK.

Finalize the routine by selecting Go from the Run menu.

Annex 3:Consecutive Steps in Processing Raw Data Files in Report.

The above steps are discussed in detail in the paragraphs 5.3.2 of this manual.

Annex 4: Consecutive Steps in Final Processing of Report Output Files in MS Access

and Appending Fully Processed New Data Sets to NBD.

Step

D10

D11

D12

D13

D14

D15

D16

Action

Open the MS Access file “NBD_PreProcessing.mdb” in folder

C:\MyDbase\NBD NEW DATA\Kenya Preprocessing – for Kenya, or

C:\MyDbase\NBD NEW DATA\Rwanda Preprocessing – for Rwanda, or

C:\MyDbase\NBD NEW DATA\Uganda Preprocessing - for Uganda.

Highlight the appropriate auxiliary table and click “Open”. See Table 4 in paragraph 6.2 for an overview of the

auxiliary tables (Group 1).

Select all records by simultaneously keying CTRL and A, or clicking Select All Records in the Edit menu.

Delete all records by choosing Delete Records from the Edit menu, or by pressing the ‘Delete’ key.

Close auxiliary table.

In the database window, select Get External Data from the File menu. Choose the sub command Import.

In the subsequent window, navigate to the folder containing the Report output files and select the concerned

one. Use the appropriate Windows Explorer commands. If the recommended directory structure is used, these

files are stored in folder C:\CAMPBELL\FILES\OUTPUT. Make sure the ‘Files of type:’ box below-left is in “Text

Files”.

Click Import.

Select “Delimited” and click “Next”.

Select “comma” and click “Next”.

Check “In an Existing Table:” and navigate in the related list box to the appropriate auxiliary table. Click “Next”.

Click OK.

Finalize data processing and storage into the NBD by activating the appropriate pre-defined append query. See

Table 5 in paragraph 6.4 for the required combination of query, input and output file.

Click Yes.

New set of data have been stored/appended in the NBD; open the respective NBD table to check the final

results.

Annex 4: Consecutive Steps in Final Processing of Report Output Files in MS Access and Appending Fully Processed New

Data Sets to NBD.

The above steps are discussed in detail in the paragraphs 5.3.2 of this manual.