<div dir="ltr">The big change in version 8.00 was support for creating Excel (XLSX) files. This took only one line in the version summary, but did require substantial changes in the programming. Depending on local configuration settings, the Excel files are created by first generating a delimited file (CSV, tab, etc.) and then calling a routine at the operating-system level to convert the delimited file to XLSX.<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 Mon, May 5, 2014 at 7:58 AM, Glasser, David <span dir="ltr"><<a href="mailto:glasserd@union.edu" target="_blank">glasserd@union.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">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>
<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" 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>
<br></blockquote></div><span class="HOEnZb"><font color="#888888"><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: <a href="tel:%28518%29%20388-6561" value="+15183886561" target="_blank">(518) 388-6561</a></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>
</font></span></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></div>