<div dir="ltr">Hi David,<div><br></div><div>I believe this is the entire release notes for 8.0:</div><div><br></div><div><div>Version 8.00</div><div>* Bug fix (CSV format with multiple MV.ORIENTATION VERTICAL fields</div><div>
* Add support for invoking a "csv to xlsx" routine</div></div><div><br></div><div>The jump from 7.42 to to 8.0 seems to indicate a big release, but perhaps not. Could you clarify if there were additional behind the scenes changes?<br>
</div><div><br></div><div>Thanks,</div><div><br></div><div>David</div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, May 5, 2014 at 7:47 AM, Rotman, David <span dir="ltr"><<a href="mailto:rotmand@cedarville.edu" target="_blank">rotmand@cedarville.edu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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 <a href="tel:937-766-7905" value="+19377667905" target="_blank">937-766-7905</a><br>fax <a href="tel:937-766-8819" value="+19377668819" target="_blank">937-766-8819</a><div>
<img src="http://www.cedarville.edu/~/media/Images/Information-Technology/IT-logo-for-signature.jpg"><br>
</div></div><div><div class="h5">
<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" target="_blank">714/744-7852</a><br>
<a href="mailto:esmall@chapman.edu" target="_blank">esmall@chapman.edu</a><mailto:<a href="mailto:esmall@chapman.edu" target="_blank">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" target="_blank">athomason@apps.zogotech.com</a><mailto:<a href="mailto:athomason@apps.zogotech.com" target="_blank">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: <a href="tel:888.221.6372%20x.809" value="+18882216372" target="_blank">888.221.6372 x.809</a> | Dallas: <a href="tel:214.774.4780%20x.809" value="+12147744780" target="_blank">214.774.4780 x.809</a><br>
Fax: <a href="tel:512-469-6306" value="+15124696306" target="_blank">512-469-6306</a><br>
Email: <a href="mailto:athomason@zogotech.com" target="_blank">athomason@zogotech.com</a><mailto:<a href="mailto:athomason@zogotech.com" target="_blank">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" target="_blank">esmall@chapman.edu</a>]<br>
Sent: Wednesday, April 23, 2014 11:02 AM<br>
To: <a href="mailto:support@zogotech.com" target="_blank">support@zogotech.com</a><mailto:<a href="mailto:support@zogotech.com" target="_blank">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>
<a href="tel:714%2F744-7852" value="+17147447852" target="_blank">714/744-7852</a><br>
<a href="mailto:esmall@chapman.edu" target="_blank">esmall@chapman.edu</a><mailto:<a href="mailto:esmall@chapman.edu" target="_blank">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" target="_blank">download-list-bounces@cedarville.edu</a><mailto:<a href="mailto:download-list-bounces@cedarville.edu" target="_blank">download-list-bounces@cedarville.edu</a>> [mailto:<a href="mailto:download-list-bounces@cedarville.edu" target="_blank">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" target="_blank">download-list@cedarville.edu</a><mailto:<a href="mailto:download-list@cedarville.edu" target="_blank">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" target="_blank">888.221.6372 x 814</a> | Austin: <a href="tel:214.774.4780%20x%20814" value="+12147744780" target="_blank">214.774.4780 x 814</a> | Fax: <a href="tel:512-469-6306" value="+15124696306" target="_blank">512-469-6306</a><br>
Email: <a href="mailto:kwiggans@zogotech.com" target="_blank">kwiggans@zogotech.com</a><mailto:<a href="mailto:kwiggans@zogotech.com" target="_blank">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" target="_blank">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></div></div>
<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>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><span style="font-size:large;color:rgb(102,0,0);font-family:verdana,sans-serif">David Glasser</span><br><div><div style="color:rgb(80,0,80)">
<div><div><div><span style="font-family:verdana,sans-serif"><span style="color:rgb(102,0,0)">Enrollment Systems Analyst<br></span></span></div><span style="font-family:verdana,sans-serif"><span style="color:rgb(102,0,0)">Union College<br>
</span></span></div><span style="font-family:verdana,sans-serif"><span style="color:rgb(102,0,0)">807 Union Street<br></span></span></div><span style="font-family:verdana,sans-serif"><span style="color:rgb(102,0,0)">Schenectady, NY 12308<br>
</span></span></div><span style="font-family:verdana,sans-serif"><span style="color:rgb(102,0,0)">Phon</span><font color="#660000">e: (518) 388-6561</font><br><font color="#660000">Visit Union: </font><a href="http://www.union.edu/" style="color:rgb(17,85,204)" target="_blank">www.union.edu</a><br>
</span></div><span style="color:rgb(80,0,80);font-family:verdana,sans-serif"><span style="color:rgb(102,0,0)">Twitter and Instagram: @unionadmissions </span></span><br></div>
</div>