|
Create a Spreadsheet File
from PX Data
Create a pointer file.
Example:
$sort crshist
Fields to Sort (15 Maximum)
Level 1...Field? .termcode
Level 2...Field? .courseid
Level 3...Field?
Sorting on 2 fields specified.
Select out special records <NO>? yes
Criterion A
Field? .termcode
Low ? 003s/only
Criterion B
Field? .termcode
Low ? 013s/only
Criterion C
Field?
Selection statement? a or b
Field extraction started 09:43 AM
Pointer file build started 09:43 AM
Pointers to 848 records constructed. 09:43 AM
Use DMS:EXCHANGE to create a csv (comma separated value) file.
$ run dms:exchange
EXCHANGE V6.7-01 - POISE Data Exchange File Builder 09:44 AM
Copyright (c) 1999, Campus America, Inc.Data File Name? crshist
READ or WRITE Exchange file? write comma
Output Exchange File Name? crshist.csv
Command 1? .enrolled
Command 2? .termcode
Command 3? .courseid
Command 4? .title
Command 5?
Proceed? yes
Use the FTP utility to move the file to the NT network.
Open spreadsheet program.
Place cursor on Select File, Open.
Find the file named crshist.csv in the ftp folder and doubleclick on it.
|