<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=us-ascii"><meta name=Generator content="Microsoft Word 14 (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-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'>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.<br><br><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>