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

[Kellie, Julie]

Check out the NUM.VALUES command; I think there's an " all values" argument. It helps, but MVs in download are just...kinda ugly.

Julie Kellie
MIS Programmer/Analyst
Metro Community College
Omaha NE 402-457-2219

From: download-list-bounces at cedarville.edu [mailto:download-list-bounces at cedarville.edu] On Behalf Of Mark Riddle
Sent: Monday, April 09, 2012 3:52 PM
To: Brigette Miller; Cedarville DOWNLOAD Users
Subject: Re: [Download-List] Multi-Valued download challenge when importing into excel Version 14.0.6112.5000 MS Office Prof 2010

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/afc7049e/attachment.html>