<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.hoenzb
{mso-style-name:hoenzb;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Hi David,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I’d like to add the XSLX capabilities to an AIX system. Do you know the considerations for getting this done? Should the Linux versions work or would you expect
to use something else?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Download is a great product that I’ve been using for years and I love the functionality.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Thank you.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> download-list-bounces@cedarville.edu [mailto:download-list-bounces@cedarville.edu]
<b>On Behalf Of </b>Rotman, David<br>
<b>Sent:</b> Monday, May 05, 2014 8:47 AM<br>
<b>To:</b> Cedarville DOWNLOAD Users<br>
<b>Subject:</b> Re: [Download-List] How To Retrieve The Record Number For A Multivalued Field<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">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.<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal">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<o:p></o:p></p>
<div>
<p class="MsoNormal"><img border="0" id="_x0000_i1025" src="http://www.cedarville.edu/~/media/Images/Information-Technology/IT-logo-for-signature.jpg"><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Mon, May 5, 2014 at 7:58 AM, Glasser, David <<a href="mailto:glasserd@union.edu" target="_blank">glasserd@union.edu</a>> wrote:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<p class="MsoNormal">Hi David,<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I believe this is the entire release notes for 8.0:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal">Version 8.00<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">* Bug fix (CSV format with multiple MV.ORIENTATION VERTICAL fields<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">* Add support for invoking a "csv to xlsx" routine<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">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?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">David<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Mon, May 5, 2014 at 7:47 AM, Rotman, David <<a href="mailto:rotmand@cedarville.edu" target="_blank">rotmand@cedarville.edu</a>> wrote:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<p class="MsoNormal">The alignment problem is a bug that was fixed in version 8.00 of DOWNLOAD.<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">This paragraph seems to produce accurate output on our system:<o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal">001: PA<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">002: SELECT STUDENT.ACAD.CRED \<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">003: WITH STC.ACAD.LEVEL = 'UG' \<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">004: WITH EVAL "COUNT(STC.STATUS,@VM)" GT 1 \<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">005: SAMPLE 20<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">006: SELECT STUDENT.ACAD.CRED \<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">007: BY @ID BY.EXP STC.STATUS \<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">008: REQUIRE.SELECT<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">009: DOWNLOAD STUDENT.ACAD.CRED \<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">010: @ID \<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">011: BY.EXP STC.STATUS STC.STATUS \<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">012: MV.ORIENTATION VERTICAL \<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">013: STC.STATUS.DATE \<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">014: STC.STATUS.TIME \<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">015: STC.TERM<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Sample output:<o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal">889832,"N","06/28/04","11:31PM","2004FA"<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">889832,"N","06/21/04","04:02PM","2004FA"<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">889832,"X","07/13/04","01:46PM","2004FA"<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">889832,"X","06/24/04","08:12PM","2004FA"<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">889889,"N","06/28/04","06:56PM","2004FA"<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">889889,"N","06/21/04","04:03PM","2004FA"<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">889889,"X","06/23/04","02:06PM","2004FA"<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">1118597,"N","08/19/08","02:55PM","2008FA"<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">1118597,"N","06/23/08","01:52PM","2008FA"<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">1118597,"X","08/18/08","05:18PM","2008FA"<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">1118601,"N","08/19/08","08:53AM","2008FA"<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">1118601,"N","06/23/08","01:52PM","2008FA"<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">1118601,"X","07/01/08","09:32AM","2008FA"<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal">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" target="_blank">937-766-7905</a><br>
fax <a href="tel:937-766-8819" target="_blank">937-766-8819</a><o:p></o:p></p>
<div>
<p class="MsoNormal"><img border="0" id="_x0000_i1026" src="http://www.cedarville.edu/~/media/Images/Information-Technology/IT-logo-for-signature.jpg"><o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Sun, May 4, 2014 at 10:40 PM, Small, Eric <<a href="mailto:esmall@chapman.edu" target="_blank">esmall@chapman.edu</a>> wrote:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<p class="MsoNormal">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" 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" target="_blank">888.221.6372 x.809</a> | Dallas:
<a href="tel:214.774.4780%20x.809" target="_blank">214.774.4780 x.809</a><br>
Fax: <a href="tel:512-469-6306" 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" 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" target="_blank">
888.221.6372 x 814</a> | Austin: <a href="tel:214.774.4780%20x%20814" target="_blank">
214.774.4780 x 814</a> | Fax: <a href="tel:512-469-6306" 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><o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><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><o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal"><span style="color:#888888"><br>
<br clear="all">
<span class="hoenzb"><o:p></o:p></span></span></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><span class="hoenzb"><span style="color:#888888">-- </span><o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:18.0pt;font-family:"Verdana","sans-serif";color:#660000">David Glasser</span><o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif";color:#660000">Enrollment Systems Analyst</span><span style="color:#500050"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif";color:#660000">Union College</span><span style="color:#500050"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif";color:#660000">807 Union Street</span><span style="color:#500050"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif";color:#660000">Schenectady, NY 12308</span><span style="color:#500050"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif";color:#660000">Phone: <a href="tel:%28518%29%20388-6561" target="_blank">(518) 388-6561</a></span><span style="font-family:"Verdana","sans-serif";color:#888888"><br>
</span><span style="font-family:"Verdana","sans-serif";color:#660000">Visit Union: </span><span style="font-family:"Verdana","sans-serif";color:#888888"><a href="http://www.union.edu/" target="_blank"><span style="color:#1155CC">www.union.edu</span></a></span><span style="color:#888888"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif";color:#660000">Twitter and Instagram: @unionadmissions </span><span style="color:#888888"><o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><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><o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</body>
</html>