[Download-List] How To Retrieve The Record Number For A Multivalued Field

Rotman, David rotmand at cedarville.edu
Mon May 5 07:47:31 EDT 2014


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


More information about the download-list mailing list