[Download-List] How to do Report Headings that also include all theField Labels
Sally Crawford
scrawford at ocean.edu
Thu Nov 6 10:04:25 EST 2008
Hi,
I don't know what I would have done without the Cedarville download
program through the years. It is my mainstay.
This is my typical download with headings.
:AE VOC O06.STU.DATA.DWNLD
Top of "O06.STU.DATA.DWNLD" in "VOC", 37 lines, 1,359 characters.
*--: P
001: PA oitscraw 01/07/04
002: * <<mnemonic, if I put it into a user menu>>
003: * <<process id, if I put it into a user menu>>
004: * Current student data dwnld
005: * Last download 2008FAL 11/04/08
006: DISPLAY
007: *<<A,Enter REPORTING.TERM: >>
008: DISPLAY
009: DISPLAY
010: SELECT STUDENT.TERMS WITH STTR.TERM EQ '<<Enter REPORTING.TERM:
>>'
011: SELECT STUDENT.TERMS WITH STTR.CURRENT.STATUS EQ 'P''R''T''L'
012: SELECT STUDENT.TERMS WITH NO STTR.ACTIVE.PROGRAMS EQ 'NJVCC'
013: SELECT STUDENT.TERMS WITH NO O06.STTR.DECEASED.DATE
014: DOWNLOAD STUDENT.TERMS \
015: STTR.STUDENT COL.HDG "ID" \
016: LITERAL " " COL.HDG "*" \
017: STTR.SSN COL.HDG "SSN" \
018: STTR.STUDENT.SORT.FIRST.NAME COL.HDG "FIRST.NAME" \
019: STTR.STUDENT.SORT.MID.NAME COL.HDG "MI" \
020: STTR.STUDENT.SORT.LAST.NAME COL.HDG "LAST.NAME" \
021: STTR.CUR.RES.STATUS COL.HDG "RES.STAT" \
022: STTR.IMMIGRATION.STATUS COL.HDG "IMMIGRATION.STATUS" \
023: STTR.ALIEN.FLAG COL.HDG "ALIEN" \
024: STTR.GENDER COL.HDG "GEN" \
025: STTR.ETHNIC COL.HDG "ETH" \
026: STTR.AGE COL.HDG "AGE" \
027: STTR.BIRTH.DATE COL.HDG "DOB" \
028: O06.STTR.HS.GRAD.YEAR COL.HDG "HS.YR" \
029: STTR.ACTIVE.CRED COL.HDG "CRED" \
030: XSTTR.PROGRAMS NUM.VALUES 2 MV.ORIENTATION HORIZONTAL COL.HDG
"PROGRAM" \
031: O06.STTR.HOME.PHONE COL.HDG "HOME.PHONE" \
032: O06.STTR.BUS.PHONE COL.HDG "BUS.PHONE" \
033: O06.STTR.CELL.PHONE COL.HDG "CELL.PHONE" \
034: O06.STTR.INT.EMAIL COL.HDG "OCC.EMAIL" \
035: O06.STTR.INP.EMAIL COL.HDG "INP.EMAIL" \
036: HEADING FIELD.NAMES FORMAT QUOTE FILE SALLY.HOME STUDATA1
OVERWRITING NOPAG
E
037: END:
I prefer the use of "COL.HDG" rather than list it below the fields with
a 'LITERAL'. It's a cleaner way to add or delete fields and to determine
where they are in the lineup.
The error you're getting is telling you that you're telling the program
2x what to put in the heading and it doesn't like to be told twice!
Sally
PS. "SALLY.HOME" is allowing me to dump all of my stuff into my home
directory so it doesn't get lost in the minutia in the &HOLD& directory.
It's setup like this:
:AE VOC SALLY.HOME
Top of "SALLY.HOME" in "VOC", 3 lines, 38 characters.
*--: P
001: DIR
002: /home/oitscraw/_HOLD_
003: D_SAVEDLISTS
Bottom.
with a _HOLD_ file listed in my home directory.
==============================================================
Sally Crawford * Systems Analyst
Ocean County College * 1 College Drive, Toms River, NJ 08753-2239
Tel 732-255-0400 x2156 * Fax 732-255-0501
scrawford at ocean.edu * www.sungardhe.com * www.ocean.edu
CONFIDENTIALITY: This e-mail (including any attachments) may contain
confidential, proprietary and privileged information, and unauthorized
disclosure or use is prohibited. If you received this e-mail in error,
please notify the sender and delete this e-mail from your system
-----Original Message-----
From: download-list-bounces at cedarville.edu
[mailto:download-list-bounces at cedarville.edu] On Behalf Of Brian McGuire
Sent: Thursday, November 06, 2008 9:50 AM
To: Cedarville DOWNLOAD Users
Subject: [Download-List] How to do Report Headings that also include all
theField Labels
Hello,
I am trying to create a Report Heading for a comma separated file that
consists of:
GCU.DISBB2 as of 11/6/08
"Student","Last","First", (etc for all the Field Labels in the report)
Below is a snippet of the paragraph. I am using XLIST feeding into
Download. I get output that begins at the Field Labels and includes
data. I am NOT able to get the first 2 lines of the Report Heading that
I desire.
XLIST STUDENT.TERMS DL \
ID.SUP \
STTR.STUDENT \
LAST.NAME \
FIRST.NAME \
... other output fields (too many to type all the column headings
manually) \
HEADING LITERAL "GCU.DISBB2 as of 'D'" LINE 1 \
LITERAL "" LINE 2 \
FIELD.LABELS LINE 3 \
PROGRESS.INTERVAL 55000 \
FILE _HOLD_ GCU-DISBB2 OVERWRITING
When the paragraph runs, I see the following display, which indicates
that I will have a challenge in the output:
XLIST 1.8f (12/01/06) > DOWNLOAD version 7.13 Using input file
STUDENT.TERMS Output to file _HOLD_ GCU-DISBB2
10386 records processed.
Enter <New line> to continue...
LITERAL "" already has a LINE qualifier "LINE 2"
HEADING may be specified only once.
Here is a sample of the output showing Lines 1-2, notice that I am
missing the 2 top Report Heading lines:
"Student ID","Last Name","First Name","MIDINITIAL","DMI
ID","ACCEPTED","IEC-LFNAME","IECM-LFNAME","OEC-LFNAME","OECM-LFNAME","DI
SB-DATE1","ALL-COURSES"
"9999999","Billy","Bob","M","bbilly","Accepted","Myself, Me","Yourself,
You","AllUs, Us","ForgetIt, Now","1/5/09","EED-580A-OL102
EED-580B-OL202"
Do anyone know how to do this? Thank you.
Brian McGuire, Ph.D., MAS
Executive Director
______________________________
Office of Institutional Research & Student Systems
Toll Free: 800-800-9776 x7605
Direct: 602-639-6551
FAX: 877-218-6668
bmcguire at gcu.edu
More information about the download-list
mailing list