[Download-List] Multi-Valued download challenge when importing into excel Version 14.0.6112.5000 MS Office Prof 2010

Mark Riddle mriddle at antioch.edu
Mon Apr 9 16:51:31 EDT 2012


Shoot: looked more closely, and it only grabs first values...


On 4/9/12 12:47 PM, "Brigette Miller" <bmiller at antioch.edu> wrote:

> I'm having a challenge when downloading information for a report and I was
> hoping someone could provide a solution.
> 
> The setup is:
> 
> 
> DOWNLOAD STUDENTS @ID A07.STU.FIRST.NAME <http://A07.STU.FIRST.NAME>
> STU.LAST.NAME <http://STU.LAST.NAME>  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
> 
> 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?
>         
>  370549 
>  
>  70BALACW 
>  
>  
>   
>  
>  
>  
>  70BALA 
>  
>  
>   
>  
>  
>  
>  70BAMGT 70-11 
>  
>   
>  
>  
>  
>  
>  DFLT 
>  
>   
>  
>  
>  
>  
>  70-10 9/18/2011 
>   
>  
>  
>  
>  
>  
>  7/5/2011 
>   
>  
>  
>  
>  
>  
>  9/17/2011 
>   
>  364538 
>  
>  70TLRE 
>  
>  
>   
>  
>  
>  
>  70TLECE 70-11 
>  
>   
>  
>  
>  
>  
>  70-10 1/2/2012 
>   
>  
>  
>  
>  
>  
>  9/18/2010 
>   
>  370086 
>  
>  70BAECE 
>  
>  
>   
>  
>  
>  
>  70BAECEHWL 
>  
>  
>   
>  
>  
>  
>  70BAHSA 70-10 
>  
>   
>  
>  
>  
>  
>  70-10 
>  
>   
>  
>  
>  
>  
>  70-10 9/17/2011 
>   
>  
>  
>  
>  
>  
>  9/17/2011 
>   
>  
>  
>  
>  
>  
>  1/3/2011 
>   
>  368422 
>  
>  70TLEDS 
>  
>  
>   
>  
>  
>  
>  70TLRE 
>  
>  
>   
>  
>  
>  
>  70ELSS 70-10 
>  
>   
>  
>  
>  
>  
>  70-10 
>  
>   
>  
>  
>  
>  
>  DFLT 4/2/2011 
>   
>  
>  
>  
>  
>  
>  9/18/2010 
>   
>  
>  
>  
>  
>  
>  7/1/2010 
>   
>  
>  
>  
>  
>  
>  
>  
>   
>  
>  
>  
>  
>  
>  
>  
>  
> 
> 
> 
> Brigette Miller
> Functional Analyst
> Antioch University
> 888 Dayton Street, Suite 102
> Yellow Springs, OH 45387
> (W) 937-769-1828
> (F) 937-769-1804
> 
> If you need assistance with a Datatel issue please submit a helpdesk ticket
> via email at https://helpdesk.antioch.edu/content/default.aspx 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.
> 
> 
> 
> _______________________________________________
> download-list mailing list
> download-list at cedarville.edu
> http://mail.cedarville.edu/mailman/listinfo/download-list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20120409/4a5e93c3/attachment.html>


More information about the download-list mailing list