<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:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 12 (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]-->
<title>Re: [Download-List] Multi-Valued download challenge when importing into excel Version 14.0.6112.5000 MS Office Prof 2010</title>
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 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.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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">Anyone know the best way to upgrade the TD Client seamlessly?<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>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;color:#582A7E">Mylite D. Hart | Sr. Systems Analyst | Information Services, University Systems Division | Rush University Medical Center |
</span><span style="font-size:9.0pt;color:#002060"><a href="mailto:Mylite_Hart@rush.edu"><span style="color:#002060">Mylite_Hart@rush.edu</span></a></span><span style="font-size:9.0pt;color:#582A7E"> | (312)942-0127 |<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><i><span style="font-size:9.0pt;color:#ABABFF">"A great man is always willing to be little." ~Ralph Waldo Emerson~</span></i></b><b><i><span style="font-size:9.0pt;color:#ABABFF"><o:p></o:p></span></i></b></p>
<p class="MsoNormal"><b><i><span style="font-size:5.0pt;color:#ABABFF"><o:p> </o:p></span></i></b></p>
<p class="MsoNormal"><b><i><span style="font-size:9.0pt;color:#ABABFF">"When you set things in motion--something will happen" ~Aleen Bayard~<o:p></o:p></span></i></b></p>
<p class="MsoNormal"><b><i><span style="font-size:5.0pt;color:#ABABFF"><o:p> </o:p></span></i></b></p>
<p class="MsoNormal"><b><i><span style="font-size:9.0pt;color:#ABABFF">"Be a first rate version of yourself, not a second rate version of someone else" ~Judy Garland~<o:p></o:p></span></i></b></p>
<p class="MsoNormal"><b><i><span style="font-size:5.0pt;color:#ABABFF"><o:p> </o:p></span></i></b></p>
<p class="MsoNormal"><b><i><span style="font-size:9.0pt;color:#ABABFF">"Limits, like fear, are often just an illusion ." ~Michael Jordan (2009: Hall of Fame Induction Speech)~<o:p></o:p></span></i></b></p>
<p class="MsoNormal"><b><i><span style="font-size:5.0pt;color:#ABABFF"><o:p> </o:p></span></i></b></p>
<p class="MsoNormal"><b><i><span style="font-size:10.0pt;color:#ABABFF"> <o:p></o:p></span></i></b></p>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> download-list-bounces@cedarville.edu [mailto:download-list-bounces@cedarville.edu]
<b>On Behalf Of </b>Kellie, Julie<br>
<b>Sent:</b> Monday, April 09, 2012 4:02 PM<br>
<b>To:</b> Cedarville DOWNLOAD Users; Brigette Miller<br>
<b>Subject:</b> Re: [Download-List] Multi-Valued download challenge when importing into excel Version 14.0.6112.5000 MS Office Prof 2010<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Check out the NUM.VALUES command; I think there’s an “ all values” argument. It helps, but MVs in download are just…kinda ugly.<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">Julie Kellie<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">MIS Programmer/Analyst<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Metro Community College<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Omaha NE 402-457-2219<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>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> download-list-bounces@cedarville.edu [mailto:download-list-bounces@cedarville.edu]
<b>On Behalf Of </b>Mark Riddle<br>
<b>Sent:</b> Monday, April 09, 2012 3:52 PM<br>
<b>To:</b> Brigette Miller; Cedarville DOWNLOAD Users<br>
<b>Subject:</b> Re: [Download-List] Multi-Valued download challenge when importing into excel Version 14.0.6112.5000 MS Office Prof 2010<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Shoot: looked more closely, and it only grabs first values...
<br>
<br>
<br>
On 4/9/12 12:47 PM, "Brigette Miller" <<a href="bmiller@antioch.edu">bmiller@antioch.edu</a>> wrote:</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">I'm having a challenge when downloading information for a report and I was hoping someone could provide a solution.<br>
<br>
The setup is:<br>
<br>
<br>
DOWNLOAD STUDENTS @ID A07.STU.FIRST.NAME <<a href="http://A07.STU.FIRST.NAME">http://A07.STU.FIRST.NAME</a>> STU.LAST.NAME <<a href="http://STU.LAST.NAME">http://STU.LAST.NAME</a>> STU.ACAD.PROGRAMS NUM.VALUES ALL MV.ORIENTATION VERTICAL STU.CATALOGS NUM.VALUES
ALL MV.ORIENTATION VERTICAL A07.STU.STPR.START.DATE NUM.VALUES ALL MV.ORIENTATION VERTICAL FORMAT COMMA FILE _HOLD_ 70.TESTING OVERWRITING<br>
<br>
When I try to import the information into an excel spreadsheet the information formats as example below in different cells instead of aligning properly into the columns. the three fields are not associated. Is there any suggestions in getting to format the
three pieces of information correctly? Or at least can someone share with me as to why this would occur?<br>
<br>
370549 <br>
<br>
70BALACW <br>
<br>
<br>
<br>
<br>
<br>
<br>
70BALA <br>
<br>
<br>
<br>
<br>
<br>
<br>
70BAMGT 70-11 <br>
<br>
<br>
<br>
<br>
<br>
<br>
DFLT <br>
<br>
<br>
<br>
<br>
<br>
<br>
70-10 9/18/2011 <br>
<br>
<br>
<br>
<br>
<br>
<br>
7/5/2011 <br>
<br>
<br>
<br>
<br>
<br>
<br>
9/17/2011 <br>
<br>
364538 <br>
<br>
70TLRE <br>
<br>
<br>
<br>
<br>
<br>
<br>
70TLECE 70-11 <br>
<br>
<br>
<br>
<br>
<br>
<br>
70-10 1/2/2012 <br>
<br>
<br>
<br>
<br>
<br>
<br>
9/18/2010 <br>
<br>
370086 <br>
<br>
70BAECE <br>
<br>
<br>
<br>
<br>
<br>
<br>
70BAECEHWL <br>
<br>
<br>
<br>
<br>
<br>
<br>
70BAHSA 70-10 <br>
<br>
<br>
<br>
<br>
<br>
<br>
70-10 <br>
<br>
<br>
<br>
<br>
<br>
<br>
70-10 9/17/2011 <br>
<br>
<br>
<br>
<br>
<br>
<br>
9/17/2011 <br>
<br>
<br>
<br>
<br>
<br>
<br>
1/3/2011 <br>
<br>
368422 <br>
<br>
70TLEDS <br>
<br>
<br>
<br>
<br>
<br>
<br>
70TLRE <br>
<br>
<br>
<br>
<br>
<br>
<br>
70ELSS 70-10 <br>
<br>
<br>
<br>
<br>
<br>
<br>
70-10 <br>
<br>
<br>
<br>
<br>
<br>
<br>
DFLT 4/2/2011 <br>
<br>
<br>
<br>
<br>
<br>
<br>
9/18/2010 <br>
<br>
<br>
<br>
<br>
<br>
<br>
7/1/2010 <br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
Brigette Miller<br>
Functional Analyst<br>
Antioch University<br>
888 Dayton Street, Suite 102<br>
Yellow Springs, OH 45387<br>
(W) 937-769-1828<br>
(F) 937-769-1804<br>
<br>
If you need assistance with a Datatel issue please submit a helpdesk ticket via email at
<a href="https://helpdesk.antioch.edu/content/default.aspx">https://helpdesk.antioch.edu/content/default.aspx</a> or contact the helpdesk directly 1-866-662-0056 with detailed information in regard to your needs/challenges. They will submit a ticket and a Datatel
support person will contact you for assistance.<o:p></o:p></span></p>
<div class="MsoNormal" align="center" style="text-align:center"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">
<hr size="3" width="95%" align="center">
</span></div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Consolas">_______________________________________________<br>
download-list mailing list<br>
<a href="download-list@cedarville.edu">download-list@cedarville.edu</a><br>
<a href="http://mail.cedarville.edu/mailman/listinfo/download-list">http://mail.cedarville.edu/mailman/listinfo/download-list</a></span><o:p></o:p></p>
</div>
</body>
</html>