[Download-List] How To Retrieve The Record Number For A Multivalued Field
Glasser, David
glasserd at union.edu
Mon May 5 07:58:45 EDT 2014
Hi David,
I believe this is the entire release notes for 8.0:
Version 8.00
* Bug fix (CSV format with multiple MV.ORIENTATION VERTICAL fields
* Add support for invoking a "csv to xlsx" routine
The jump from 7.42 to to 8.0 seems to indicate a big release, but perhaps
not. Could you clarify if there were additional behind the scenes changes?
Thanks,
David
On Mon, May 5, 2014 at 7:47 AM, Rotman, David <rotmand at cedarville.edu>wrote:
> The alignment problem is a bug that was fixed in version 8.00 of DOWNLOAD.
>
> This paragraph seems to produce accurate output on our system:
> 001: PA
> 002: SELECT STUDENT.ACAD.CRED \
> 003: WITH STC.ACAD.LEVEL = 'UG' \
> 004: WITH EVAL "COUNT(STC.STATUS, at VM)" GT 1 \
> 005: SAMPLE 20
> 006: SELECT STUDENT.ACAD.CRED \
> 007: BY @ID BY.EXP STC.STATUS \
> 008: REQUIRE.SELECT
> 009: DOWNLOAD STUDENT.ACAD.CRED \
> 010: @ID \
> 011: BY.EXP STC.STATUS STC.STATUS \
> 012: MV.ORIENTATION VERTICAL \
> 013: STC.STATUS.DATE \
> 014: STC.STATUS.TIME \
> 015: STC.TERM
>
> Sample output:
> 889832,"N","06/28/04","11:31PM","2004FA"
> 889832,"N","06/21/04","04:02PM","2004FA"
> 889832,"X","07/13/04","01:46PM","2004FA"
> 889832,"X","06/24/04","08:12PM","2004FA"
> 889889,"N","06/28/04","06:56PM","2004FA"
> 889889,"N","06/21/04","04:03PM","2004FA"
> 889889,"X","06/23/04","02:06PM","2004FA"
> 1118597,"N","08/19/08","02:55PM","2008FA"
> 1118597,"N","06/23/08","01:52PM","2008FA"
> 1118597,"X","08/18/08","05:18PM","2008FA"
> 1118601,"N","08/19/08","08:53AM","2008FA"
> 1118601,"N","06/23/08","01:52PM","2008FA"
> 1118601,"X","07/01/08","09:32AM","2008FA"
>
>
>
>
>
> David Rotman, Ph.D.
> Associate Vice President for Technology
> Chief Information Officer
> Cedarville University
> 251 N. Main Street
> Cedarville, OH 45314
> rotmand at cedarville.edu
> voice 937-766-7905
> fax 937-766-8819
>
>
>
> On Sun, May 4, 2014 at 10:40 PM, Small, Eric <esmall at chapman.edu> wrote:
>
>> You probably need to write a unidata program not sure you can get what
>> you want using the,download,program.
>>
>> Eric Small
>> Technical Analyst
>> Information Systems and Technology
>> Chapman University
>> 714/744-7852
>> esmall at chapman.edu<mailto:esmall at chapman.edu>
>>
>> IS&T WILL NEVER ASK FOR YOUR PASSWORD - DO NOT SHARE YOUR PASSWORD WITH
>> OTHERS!
>> Sent from my iPad
>>
>> On Apr 28, 2014, at 12:53 PM, "Aaron Thomason" <
>> athomason at apps.zogotech.com<mailto:athomason at apps.zogotech.com>> wrote:
>>
>> How do I get all the values of STUDENT.ACAD.CRED, STC.STATUS,
>> STC.STATUS.DATE, and STC.STATUS.TIME in a format similar to:
>>
>> 4454891,X,12/15/08,05:36PM
>> ,N,11/19/08,07:54AM
>> ,N,01/01/09,09:26PM
>>
>> When I use MV.ORIENTATION VERTICAL, it does not group the output
>> correctly.
>>
>> Aaron Thomason
>> Systems Engineer
>> zogotech
>> Toll-free: 888.221.6372 x.809 | Dallas: 214.774.4780 x.809
>> Fax: 512-469-6306
>> Email: athomason at zogotech.com<mailto:athomason at zogotech.com> | Web:
>> zogotech.com<http://www.zogotech.com/>
>>
>> From: Small, Eric [mailto:esmall at chapman.edu]
>> Sent: Wednesday, April 23, 2014 11:02 AM
>> To: support at zogotech.com<mailto:support at zogotech.com>; Cedarville
>> DOWNLOAD Users
>> Cc: Aaron Thomason
>> Subject: RE: [Download-List] How To Retrieve The Record Number For A
>> Multivalued Field
>>
>> There is no internal value that can be accessed to get the position
>> within the multivalued field STC.STATUS.
>>
>> Also your BY.EXP and BY.EXP.DSND will not work either because it will
>> sort based on the STATUS VALUE in the field. See my example below.
>>
>> The dates and the why it was entered will be out of order. I suggest you
>> don’t explode on this field at all.
>>
>>
>> LIST STUDENT.ACAD.CRED BY.EXP.DSND STC.STATUS STC.STATUS
>> STC.STATUS.DATE STC.S
>> TATUS.TIME EVAL "DCOUNT(STC.STATUS, at VM)" COL.HDG 'POS' 08:57:24 Apr 23
>> 2014 1
>> STUDENT.ACAD.CRED Status......... Status Date Status Time POS............
>>
>> 4454891 X 12/15/08 05:36PM
>> 4454891 N 11/19/08 07:54AM
>> 4454891 N 01/01/09 09:26PM 3
>> 3 records listed
>>
>> Eric Small
>> Technical Analyst
>> Information Systems and Technology
>> Chapman University
>> 714/744-7852
>> esmall at chapman.edu<mailto:esmall at chapman.edu>
>>
>> IS&T WILL NEVER ASK FOR YOUR PASSWORD - DO NOT SHARE YOUR PASSWORD WITH
>> OTHERS!
>> "If a child cannot learn the way we teach him, we had better teach him
>> the way he learns."
>>
>>
>>
>>
>> From: download-list-bounces at cedarville.edu<mailto:
>> download-list-bounces at cedarville.edu> [mailto:
>> download-list-bounces at cedarville.edu] On Behalf Of Keith Wiggans
>> Sent: Wednesday, April 23, 2014 8:21 AM
>> To: download-list at cedarville.edu<mailto:download-list at cedarville.edu>
>> Cc: Aaron Thomason
>> Subject: [Download-List] How To Retrieve The Record Number For A
>> Multivalued Field
>>
>> We are using the query below to retrieve student registration records
>> expanded by status.
>>
>> SELECT STUDENT.ACAD.CRED WITH STC.ACAD.LEVEL = 'UG' REQUIRE.SELECT
>> DOWNLOAD STUDENT.ACAD.CRED \
>> @ID \
>> BY.EXP.DSND STC.STATUS STC.STATUS \
>> STC.STATUS.DATE \
>> STC.STATUS.TIME \
>> STC.TERM \
>>
>> Is there a way to extract the record number for the row, and the sequence
>> number for the status?
>> For example, Keith added, dropped and added a course. Is there a numeric
>> sequence that corresponds with each Add, Drop, Add entry, and how do we
>> access it?
>> Sincerely,
>>
>> Keith Wiggans Systems Engineer zogotech Toll-free: 888.221.6372 x 814 |
>> Austin: 214.774.4780 x 814 | Fax: 512-469-6306
>> Email: kwiggans at zogotech.com<mailto:kwiggans at zogotech.com> | Web:
>> zogotech.com<http://zogotech.com>
>>
>> _______________________________________________
>> download-list mailing list
>> download-list at cedarville.edu
>> http://mail.cedarville.edu/mailman/listinfo/download-list
>>
>
>
> _______________________________________________
> download-list mailing list
> download-list at cedarville.edu
> http://mail.cedarville.edu/mailman/listinfo/download-list
>
>
--
David Glasser
Enrollment Systems Analyst
Union College
807 Union Street
Schenectady, NY 12308
Phone: (518) 388-6561
Visit Union: www.union.edu
Twitter and Instagram: @unionadmissions
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20140505/90fa0233/attachment.html>
More information about the download-list
mailing list