<div dir="ltr">The alignment problem is a bug that was fixed in version 8.00 of DOWNLOAD.<div><br></div><div>This paragraph seems to produce accurate output on our system:</div><div><div>001: PA</div><div>002: SELECT STUDENT.ACAD.CRED \</div>
<div>003: WITH STC.ACAD.LEVEL = 'UG' \</div><div>004: WITH EVAL "COUNT(STC.STATUS,@VM)" GT 1 \</div><div>005: SAMPLE 20</div><div>006: SELECT STUDENT.ACAD.CRED \</div><div>007: BY @ID BY.EXP STC.STATUS \</div>
<div>008: REQUIRE.SELECT</div><div>009: DOWNLOAD STUDENT.ACAD.CRED \</div><div>010: @ID \</div><div>011: BY.EXP STC.STATUS STC.STATUS \</div><div>012: MV.ORIENTATION VERTICAL \</div><div>013: STC.STATUS.DATE \</div>
<div>014: STC.STATUS.TIME \</div><div>015: STC.TERM</div></div><div><br></div><div>Sample output:</div><div><div>889832,"N","06/28/04","11:31PM","2004FA"</div><div>889832,"N","06/21/04","04:02PM","2004FA"</div>
<div>889832,"X","07/13/04","01:46PM","2004FA"</div><div>889832,"X","06/24/04","08:12PM","2004FA"</div><div>889889,"N","06/28/04","06:56PM","2004FA"</div>
<div>889889,"N","06/21/04","04:03PM","2004FA"</div><div>889889,"X","06/23/04","02:06PM","2004FA"</div><div>1118597,"N","08/19/08","02:55PM","2008FA"</div>
<div>1118597,"N","06/23/08","01:52PM","2008FA"</div><div>1118597,"X","08/18/08","05:18PM","2008FA"</div><div>1118601,"N","08/19/08","08:53AM","2008FA"</div>
<div>1118601,"N","06/23/08","01:52PM","2008FA"</div><div>1118601,"X","07/01/08","09:32AM","2008FA"</div></div><div><br></div><div><br></div>
<div>
<br></div><div><br></div></div><div class="gmail_extra"><br clear="all"><div>David Rotman, Ph.D.<br>Associate Vice President for Technology<br>Chief Information Officer<br>Cedarville University<br>251 N. Main Street<br>Cedarville, OH 45314<br>
<a href="mailto:rotmand@cedarville.edu" target="_blank">rotmand@cedarville.edu</a><br>voice 937-766-7905<br>fax 937-766-8819<div><img src="http://www.cedarville.edu/~/media/Images/Information-Technology/IT-logo-for-signature.jpg"><br>
</div></div>
<br><br><div class="gmail_quote">On Sun, May 4, 2014 at 10:40 PM, Small, Eric <span dir="ltr"><<a href="mailto:esmall@chapman.edu" target="_blank">esmall@chapman.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
You probably need to write a unidata program not sure you can get what you want using the,download,program.<br>
<br>
Eric Small<br>
Technical Analyst<br>
Information Systems and Technology<br>
Chapman University<br>
<a href="tel:714%2F744-7852" value="+17147447852">714/744-7852</a><br>
<a href="mailto:esmall@chapman.edu">esmall@chapman.edu</a><mailto:<a href="mailto:esmall@chapman.edu">esmall@chapman.edu</a>><br>
<br>
IS&T WILL NEVER ASK FOR YOUR PASSWORD - DO NOT SHARE YOUR PASSWORD WITH OTHERS!<br>
Sent from my iPad<br>
<br>
On Apr 28, 2014, at 12:53 PM, "Aaron Thomason" <<a href="mailto:athomason@apps.zogotech.com">athomason@apps.zogotech.com</a><mailto:<a href="mailto:athomason@apps.zogotech.com">athomason@apps.zogotech.com</a>>> wrote:<br>
<br>
How do I get all the values of STUDENT.ACAD.CRED, STC.STATUS, STC.STATUS.DATE, and STC.STATUS.TIME in a format similar to:<br>
<br>
4454891,X,12/15/08,05:36PM<br>
,N,11/19/08,07:54AM<br>
,N,01/01/09,09:26PM<br>
<br>
When I use MV.ORIENTATION VERTICAL, it does not group the output correctly.<br>
<br>
Aaron Thomason<br>
Systems Engineer<br>
zogotech<br>
Toll-free: 888.221.6372 x.809 | Dallas: 214.774.4780 x.809<br>
Fax: 512-469-6306<br>
Email: <a href="mailto:athomason@zogotech.com">athomason@zogotech.com</a><mailto:<a href="mailto:athomason@zogotech.com">athomason@zogotech.com</a>> | Web: <a href="http://zogotech.com" target="_blank">zogotech.com</a><<a href="http://www.zogotech.com/" target="_blank">http://www.zogotech.com/</a>><br>
<br>
From: Small, Eric [mailto:<a href="mailto:esmall@chapman.edu">esmall@chapman.edu</a>]<br>
Sent: Wednesday, April 23, 2014 11:02 AM<br>
To: <a href="mailto:support@zogotech.com">support@zogotech.com</a><mailto:<a href="mailto:support@zogotech.com">support@zogotech.com</a>>; Cedarville DOWNLOAD Users<br>
Cc: Aaron Thomason<br>
Subject: RE: [Download-List] How To Retrieve The Record Number For A Multivalued Field<br>
<br>
There is no internal value that can be accessed to get the position within the multivalued field STC.STATUS.<br>
<br>
Also your BY.EXP and BY.EXP.DSND will not work either because it will sort based on the STATUS VALUE in the field. See my example below.<br>
<br>
The dates and the why it was entered will be out of order. I suggest you don’t explode on this field at all.<br>
<br>
<br>
LIST STUDENT.ACAD.CRED BY.EXP.DSND STC.STATUS STC.STATUS STC.STATUS.DATE STC.S<br>
TATUS.TIME EVAL "DCOUNT(STC.STATUS,@VM)" COL.HDG 'POS' 08:57:24 Apr 23 2014 1<br>
STUDENT.ACAD.CRED Status......... Status Date Status Time POS............<br>
<br>
4454891 X 12/15/08 05:36PM<br>
4454891 N 11/19/08 07:54AM<br>
4454891 N 01/01/09 09:26PM 3<br>
3 records listed<br>
<br>
Eric Small<br>
Technical Analyst<br>
Information Systems and Technology<br>
Chapman University<br>
714/744-7852<br>
<a href="mailto:esmall@chapman.edu">esmall@chapman.edu</a><mailto:<a href="mailto:esmall@chapman.edu">esmall@chapman.edu</a>><br>
<br>
IS&T WILL NEVER ASK FOR YOUR PASSWORD - DO NOT SHARE YOUR PASSWORD WITH OTHERS!<br>
"If a child cannot learn the way we teach him, we had better teach him the way he learns."<br>
<br>
<br>
<br>
<br>
From: <a href="mailto:download-list-bounces@cedarville.edu">download-list-bounces@cedarville.edu</a><mailto:<a href="mailto:download-list-bounces@cedarville.edu">download-list-bounces@cedarville.edu</a>> [mailto:<a href="mailto:download-list-bounces@cedarville.edu">download-list-bounces@cedarville.edu</a>] On Behalf Of Keith Wiggans<br>
Sent: Wednesday, April 23, 2014 8:21 AM<br>
To: <a href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</a><mailto:<a href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</a>><br>
Cc: Aaron Thomason<br>
Subject: [Download-List] How To Retrieve The Record Number For A Multivalued Field<br>
<br>
We are using the query below to retrieve student registration records expanded by status.<br>
<br>
SELECT STUDENT.ACAD.CRED WITH STC.ACAD.LEVEL = 'UG' REQUIRE.SELECT<br>
DOWNLOAD STUDENT.ACAD.CRED \<br>
@ID \<br>
BY.EXP.DSND STC.STATUS STC.STATUS \<br>
STC.STATUS.DATE \<br>
STC.STATUS.TIME \<br>
STC.TERM \<br>
<br>
Is there a way to extract the record number for the row, and the sequence number for the status?<br>
For example, Keith added, dropped and added a course. Is there a numeric sequence that corresponds with each Add, Drop, Add entry, and how do we access it?<br>
Sincerely,<br>
<br>
Keith Wiggans Systems Engineer zogotech Toll-free: <a href="tel:888.221.6372%20x%20814" value="+18882216372">888.221.6372 x 814</a> | Austin: <a href="tel:214.774.4780%20x%20814" value="+12147744780">214.774.4780 x 814</a> | Fax: <a href="tel:512-469-6306" value="+15124696306">512-469-6306</a><br>
Email: <a href="mailto:kwiggans@zogotech.com">kwiggans@zogotech.com</a><mailto:<a href="mailto:kwiggans@zogotech.com">kwiggans@zogotech.com</a>> | Web: <a href="http://zogotech.com" target="_blank">zogotech.com</a><<a href="http://zogotech.com" target="_blank">http://zogotech.com</a>><br>
<br>
_______________________________________________<br>
download-list mailing list<br>
<a href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</a><br>
<a href="http://mail.cedarville.edu/mailman/listinfo/download-list" target="_blank">http://mail.cedarville.edu/mailman/listinfo/download-list</a><br>
</blockquote></div><br></div>