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

Brigette Miller bmiller at antioch.edu
Mon Apr 9 15:47:57 EDT 2012


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 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20120409/7774e4fa/attachment.html>


More information about the download-list mailing list