[Download-List] hopefully easy question?

Linda Miller lcmiller at aurora.edu
Mon Oct 27 13:09:00 EDT 2008


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? 

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 chang e 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 
Information Technology 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/749e0bfc/attachment.html>


More information about the download-list mailing list