---------1---------2---------3---------4---------5---------6---------7---------8 Hints in creating the CSV file: (Printed with .5" margin for best result) ** This file address the newer version of the CCPE tools: MkCsvXls.xls (2000.7.31 or newer) MkCsvAcc.mdb (2000.7.31 or newer) 1. Using Microsoft Excel 1) Complete the Excel Template: MkCsvXls.xls 2) Make sure the 'All' worksheet is selected. 3) Do [File][Save] to save any changes. 4) Use [File][Save As] to bring up the save as dialog. 4) Set the [Save as type] to .csv 5) Type 'All' as the [File Name] 6) Click [OK]. 7) Click [OK] to save the data sheet. 8) When you try to close the program, Excel will ask if you want save the data. Answer NO. Since we already saved in step 3). ** Before sending the data to CCPE, please run the Csv file against the validation program. 2. Using Microsoft Access If your institution already has a facility database, you can use Microsoft Access to produce the CSV file. 1) Link the database tables into MkCsvAcc.mdb. 2) Create queries to populate the tempelate table: T_Site, T_Building, T_OrgnztnlUnt and T_Room. NOTE: 1. Remember to remove sample data in T_Site, T_Building ... etc. 2. Notice that SystmId, InstId ... are Text Data Type when populating T_Site, T_Building ... etc. 3) Start the form: CsvGnrtr. 4) Click button: 'Generate CSV Files' ** Before sending the data to CCPE, please run the Csv file against the validation program.