<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 12pt; color: #000000'>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? <br>----- Original Message -----<br>From: "Keith M Johnson" <KMJohnson@collegeofidaho.edu><br>To: download-list@cedarville.edu<br>Sent: Monday, October 27, 2008 11:47:41 AM GMT -06:00 US/Canada Central<br>Subject: [Download-List] hopefully easy question?<br><br>
<title>hopefully easy question?</title>
<!-- Converted from text/rtf format -->
<p dir="ltr"><span lang="en-us"><font face="Calibri">Hi</font></span><span lang="en-us"> <font face="Calibri">All</font></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">I am back on the list at a new</font></span><span lang="en-us"> <font face="Calibri">school</font></span><span lang="en-us"><font face="Calibri">…</font></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">I have a PA</font></span><span lang="en-us"> <font face="Calibri">report</font></span><span lang="en-us"> <font face="Calibri">using a tested</font></span><span lang="en-us"><font face="Calibri">*</font></span><span lang="en-us"><font face="Calibri"> and working DOWNLOAD (version 6.X)</font></span><span lang="en-us"> <font face="Calibri">I</font></span><span lang="en-us"><font face="Calibri"> think. </font></span><span lang="en-us"> </span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">*see the working PA at the bottom of this email.</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">Anyway</font></span><span lang="en-us"> <font face="Calibri">I</font></span><span lang="en-us"><font face="Calibri"> would like to chang</font></span><span lang="en-us"><font face="Calibri">e</font></span><span lang="en-us"><font face="Calibri"> the way this PA works for a new report and just</font></span><span lang="en-us"> <font face="Calibri">explode all data</font></span><span lang="en-us"> <font face="Calibri">values</font></span><span lang="en-us"><font face="Calibri"> like student names etc. I have tried adding BY.EXP from the original line 23 below. </font></span><span lang="en-us"> <font face="Calibri">First can</font></span><span lang="en-us"> <font face="Calibri">something</font></span><span lang="en-us"><font face="Calibri"> like</font></span><span lang="en-us"> <font face="Calibri">this work</font></span><span lang="en-us"><font face="Calibri"> using the secondary files and if so can someone help me with the</font></span><span lang="en-us"> <font face="Calibri">syntax</font></span><span lang="en-us"><font face="Calibri">? If</font></span><span lang="en-us"> <font face="Calibri">I</font></span><span lang="en-us"><font face="Calibri"> need to upgrade to</font></span><span lang="en-us"> <font face="Calibri">get this to work this information is also is helpful</font></span><span lang="en-us"><font face="Calibri">…</font></span><span lang="en-us"><font face="Calibri"> TIA</font></span><span lang="en-us"> </span></p>
<p dir="ltr"><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">023: * PERS->PERSON.LFM FMT '25L' \</font></span><span lang="en-us"><font face="Calibri"> *** old original line</font></span><span lang="en-us"><font face="Calibri">…</font></span><span lang="en-us"><font face="Calibri">, and the variations</font></span><span lang="en-us"> <font face="Calibri">I</font></span><span lang="en-us"><font face="Calibri"> have tried.</font></span><span lang="en-us"> <font face="Calibri">…</font></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">024: PERS-></font></span><span lang="en-us"><font color="#ff0000" face="Calibri">BY.EXP</font></span><span lang="en-us"><font face="Calibri"> PERSON.LFM PERSON.LFM FMT '25L' \</font></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">024: PERS->PERSON.LFM FMT '25L'</font></span><span lang="en-us"><font face="Calibri"></font></span><span lang="en-us"> <font color="#ff0000" face="Calibri">BY.EXP</font></span><span lang="en-us"><font face="Calibri"> PERSON.LFM</font></span><span lang="en-us"><font face="Calibri"></font></span><span lang="en-us"> <font face="Calibri">\</font></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">024: PERS->PERSON.LFM</font></span><span lang="en-us"> <font color="#ff0000" face="Calibri">BY.EXP</font></span><span lang="en-us"><font face="Calibri"></font></span><span lang="en-us"> <font face="Calibri">PERSON.LFM</font></span><span lang="en-us"><font face="Calibri"></font></span><span lang="en-us"> <font face="Calibri">FMT '25L'</font></span><span lang="en-us"><font face="Calibri"></font></span><span lang="en-us"> <font face="Calibri">\</font></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">024: PERS->PERSON.LFM</font></span><span lang="en-us"> <font color="#ff0000" face="Calibri">BY.EXP</font></span><span lang="en-us"><font face="Calibri"></font></span><span lang="en-us"> <font face="Calibri">FMT</font></span><span lang="en-us"> <font face="Calibri">'25L'</font></span><span lang="en-us"><font face="Calibri"></font></span><span lang="en-us"> <font face="Calibri">\</font></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">A</font></span><span lang="en-us"> <font face="Calibri">ERROR:</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">1 record processed.</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">"PERSON.LFM" not found.</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">"" not found.</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">[</font></span><span lang="en-us"><font face="Calibri">…</font></span><span lang="en-us"><font face="Calibri">]</font></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">Enter <New line> to continue...</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">OWNLOAD Error Listing Page 1</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri"> 10:23:40 10-27-08</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">Invalid syntax "BY.EXP PERSON.LFM": should be "BY.EXP multi-valuedField"</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">FMT must follow a field name to be downloaded</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">:</font></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">### Each variation</font></span><span lang="en-us"> <font face="Calibri">I</font></span><span lang="en-us"><font face="Calibri"> have tried</font></span><span lang="en-us"> <font face="Calibri">failed</font></span><span lang="en-us"> <font face="Calibri">with</font></span><span lang="en-us"> <font face="Calibri">various</font></span><span lang="en-us"><font face="Calibri"> errors</font></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri"># working PA</font></span><span lang="en-us"><font face="Calibri">…</font></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">PA</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">CLEARPROMPTS</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">CLR</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">DISPLAY</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">DISPLAY</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">DISPLAY</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">DISPLAY Advisor Midterm Grade Download</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">DISPLAY</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">DISPLAY</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">SELECT STUDENT.TERMS WITH STTR.TERM EQ \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">'<<Enter Grading Term (Ex. 03/FA): >>' \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">AND STTR.STUDENT.LOAD NE '' \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">AND STTR.STUDENT.LOAD NE 'X'</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">SELECT STUDENT.TERMS BY.EXP XSTTR.ADVISOR.NAMES.LFM \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">BY XSTTR.SORT.NAME \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">SELECT.ONLY</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">DOWNLOAD STUDENT.TERMS \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">SECONDARY.FILE PERSON KEY STTR.STUDENT ALIAS PERS \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">SECONDARY.FILE PERSON KEY STTR.ADVISORS ALIAS PERA \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">SECONDARY.FILE STUDENT.COURSE.SEC KEY STTR.SCHEDULE.COURSE.SEC ALIAS SCS \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">SECONDARY.FILE STUDENTS KEY STTR.STUDENT ALIAS STU \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">STTR.TERM FMT '6L' \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">PERS->PERSON.LFM FMT '25L' \</font></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">STU->STU.START.TERM \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">NUM.VALUES ALL MV.ORIENTATION VERTICAL \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">STU->STU.CLASS \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">NUM.VALUES ALL MV.ORIENTATION VERTICAL \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">STU->STU.ACTIVE.MAJORS \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">NUM.VALUES ALL MV.ORIENTATION VERTICAL \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">SCS->SEC.NAME FMT '14L' \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">NUM.VALUES ALL MV.ORIENTATION VERTICAL \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">SCS->STC.TITLE \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">NUM.VALUES ALL MV.ORIENTATION VERTICAL \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">SCS->STC.CRED FMT '5R' \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">NUM.VALUES ALL MV.ORIENTATION VERTICAL \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">SCS->XSCS.MID.TERM.GRADE1 FMT '2L' \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">NUM.VALUES ALL MV.ORIENTATION VERTICAL \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">PERA->PERSON.LFM \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">NUM.VALUES ALL MV.ORIENTATION VERTICAL \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">XSTTR.CURRENT.DATE \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">HEADING \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">LITERAL 'Term' \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">LITERAL 'Student' \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">LITERAL 'Matric' \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">LITERAL 'Class' \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">LITERAL 'Majors' \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">LITERAL 'Section' \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">LITERAL 'Title' \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">LITERAL 'Credits' \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">LITERAL 'Mid Trm' \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">LITERAL 'Advisors' \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">LITERAL 'Run Date' \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">FORMAT TAB \</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Calibri">FILE _HOLD_ XAMG_MIDTERM_GRADES.txt OVERWRITING</font></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"><b><i></i></b></span><span lang="en-us"><b><i></i></b></span><b><i><span lang="en-us"></span></i></b><b><i><span lang="en-us"><font color="#000000" size="4" face="Lucida Calligraphy">Keith Johnson </font><font color="#000000" size="4" face="Lucida Calligraphy"></font></span></i></b><span lang="en-us"></span><span lang="en-us"></span><span lang="en-us"></span><span lang="en-us"> <font color="#0000ff" size="2" face="Comic Sans MS">(208) 459-5209 (direct)<br>
The College of Idaho (208) 459-5543 Fax<br>
2112 Cleveland Blvd, Caldwell ID. 83605 </font></span><span lang="en-us"> </span><a href="about:blank" target="_blank"><span lang="en-us"></span><span lang="en-us"><u></u></span><u><span lang="en-us"></span></u><u><span lang="en-us"><font color="#800080" size="2" face="Comic Sans MS">www.collegeofidaho.edu</font></span></u><span lang="en-us"></span></a><span lang="en-us"></span><span lang="en-us"></span><span lang="en-us"><br>
</span><span lang="en-us"></span><span lang="en-us"></span><span lang="en-us"></span><span lang="en-us"><font color="#0000ff" size="2" face="Comic Sans MS">Information Technology </font></span><span lang="en-us"> </span><a href="mailto:kmjohnson@collegeofidaho.edu" target="_blank"><span lang="en-us"></span><span lang="en-us"><u></u></span><u><span lang="en-us"></span></u><u><span lang="en-us"><font color="#0000ff" size="2" face="Comic Sans MS">kmjohnson@collegeofidaho.edu</font></span></u><span lang="en-us"></span></a><span lang="en-us"></span><span lang="en-us"></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"></span></p>
<br>_______________________________________________
download-list mailing list
download-list@cedarville.edu
http://mail.cedarville.edu/mailman/listinfo/download-list
</div></body></html>