[Download-List] hopefully easy question?

[Johnson, Keith M]

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
<blocked::blocked::http://www.collegeofidaho.edu/> 
Information Technology
kmjohnson at collegeofidaho.edu


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