[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