[Download-List] hopefully easy question?

[Johnson, Keith M]

Hmm…

Well in one location it says that but I also read:

 

“If you want the single-valued fields to repeat on each output record, you can use

an exploded select list:

SELECT STUDENTS SAMPLE 2 BY NAME BY.EXP REG.TERMS”  -Page 64 of the 7.3* DONWLOAD.pdf manual.  

I am not yet on that* version but am just checking to see if it works on 6.01

 

 

Keith Johnson

Information Technology

 

(Supporting Datatel’s; Colleague R18, Benefactor 5.1, and Web Advisor 3.X.  Also supporting; Informer v3.2.3 build 32406, UNIDATA 7.1X, and HP 11)

 

#5209 (direct)

#5543 Fax

 

From: download-list-bounces at cedarville.edu [mailto:download-list-bounces at cedarville.edu] On Behalf Of Linda Miller
Sent: Monday, October 27, 2008 11:09 AM
To: Cedarville DOWNLOAD Users
Subject: Re: [Download-List] hopefully easy question?

 

The BY.EXP has to be a multi-valued field.  PERSON.LFM name is single valued.  I'd say you need to explode the key that you are using to get over to the PERSON file, but STTR.STUDENT is not multi-valued either.  Is youR new query going against a file that has MV student ids?  
----- Original Message -----
From: "Keith M Johnson" <KMJohnson at collegeofidaho.edu>
To: download-list at cedarville.edu
Sent: Monday, October 27, 2008 11:47:41 AM GMT -06:00 US/Canada Central
Subject: [Download-List] hopefully easy question?




Hi All

I am back on the list at a new school…

I have a PA report using a tested* and working DOWNLOAD (version 6.X) I think.  

*see the working PA at the bottom of this email.

Anyway I would like to change the way this PA works for a new report and just explode all data values like student names etc.  I have tried adding BY.EXP from the original line 23 below.  First can something like this work using the secondary files and if so can someone help me with the syntax?  If I need to upgrade to get this to work this information is also is helpful…  TIA 

023: *  PERS->PERSON.LFM FMT '25L' \    *** old original line…, and the variations I have tried. …

024:   PERS->BY.EXP PERSON.LFM PERSON.LFM FMT '25L' \

024:   PERS->PERSON.LFM FMT '25L' BY.EXP PERSON.LFM \

024:   PERS->PERSON.LFM BY.EXP PERSON.LFM FMT '25L' \

024:   PERS->PERSON.LFM BY.EXP FMT '25L' \

A ERROR:

1 record processed.

"PERSON.LFM" not found.

"" not found.

[…]

Enter <New line> to continue...

OWNLOAD Error Listing                                                Page     1

                                                               10:23:40 10-27-08

Invalid syntax "BY.EXP PERSON.LFM": should be "BY.EXP multi-valuedField"

FMT must follow a field name to be downloaded

:

### Each variation I have tried failed with various errors

# working PA…

PA

CLEARPROMPTS

CLR

DISPLAY

DISPLAY

DISPLAY

DISPLAY Advisor Midterm Grade Download

DISPLAY

DISPLAY

SELECT STUDENT.TERMS WITH STTR.TERM EQ \

'<<Enter Grading Term (Ex. 03/FA): >>' \

AND STTR.STUDENT.LOAD NE '' \

AND STTR.STUDENT.LOAD NE 'X'

SELECT STUDENT.TERMS BY.EXP XSTTR.ADVISOR.NAMES.LFM \

BY XSTTR.SORT.NAME \

SELECT.ONLY

DOWNLOAD STUDENT.TERMS \

SECONDARY.FILE PERSON KEY STTR.STUDENT ALIAS PERS \

SECONDARY.FILE PERSON KEY STTR.ADVISORS ALIAS PERA \

SECONDARY.FILE STUDENT.COURSE.SEC KEY STTR.SCHEDULE.COURSE.SEC ALIAS SCS \

SECONDARY.FILE STUDENTS KEY STTR.STUDENT ALIAS STU \

STTR.TERM FMT '6L' \

PERS->PERSON.LFM FMT '25L' \

STU->STU.START.TERM \

NUM.VALUES ALL MV.ORIENTATION VERTICAL \

STU->STU.CLASS \

NUM.VALUES ALL MV.ORIENTATION VERTICAL \

STU->STU.ACTIVE.MAJORS \

NUM.VALUES ALL MV.ORIENTATION VERTICAL \

SCS->SEC.NAME FMT '14L' \

NUM.VALUES ALL MV.ORIENTATION VERTICAL \

SCS->STC.TITLE \

NUM.VALUES ALL MV.ORIENTATION VERTICAL \

SCS->STC.CRED FMT '5R' \

NUM.VALUES ALL MV.ORIENTATION VERTICAL \

SCS->XSCS.MID.TERM.GRADE1 FMT '2L' \

NUM.VALUES ALL MV.ORIENTATION VERTICAL \

PERA->PERSON.LFM \

NUM.VALUES ALL MV.ORIENTATION VERTICAL \

XSTTR.CURRENT.DATE \

HEADING \

LITERAL 'Term' \

LITERAL 'Student' \

LITERAL 'Matric' \

LITERAL 'Class' \

LITERAL 'Majors' \

LITERAL 'Section' \

LITERAL 'Title' \

LITERAL 'Credits' \

LITERAL 'Mid Trm' \

LITERAL 'Advisors' \

LITERAL 'Run Date' \

FORMAT TAB \

FILE _HOLD_ XAMG_MIDTERM_GRADES.txt OVERWRITING

Keith Johnson                    (208) 459-5209 (direct)
The College of Idaho                                        (208) 459-5543 Fax
2112 Cleveland Blvd, Caldwell ID. 83605            www.collegeofidaho.edu <about:blank> 
Information Technology                                    kmjohnson at collegeofidaho.edu <mailto:kmjohnson at collegeofidaho.edu> 


_______________________________________________ download-list mailing list download-list at cedarville.edu http://mail.cedarville.edu/mailman/listinfo/download-list 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20081027/94415ea7/attachment.html>