<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7653.38">
<TITLE>hopefully easy question?</TITLE>
</HEAD>
<BODY>
<!-- 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="blocked::blocked::http://www.collegeofidaho.edu/"><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"><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>
</BODY>
</HTML>