[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