[Download-List] How To Retrieve The Record Number For A Multivalued Field
Rotman, David
rotmand at cedarville.edu
Mon May 12 10:18:27 EDT 2014
Fred--
Thanks for the note.
I don't have any experience with Perl on AIX, but I'm guessing the
libraries for the Excel creation would work fine.
If you decide to go ahead, I'd be interested in hearing from you regarding
how difficult the Perl installation/configuration is.
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 Mon, May 5, 2014 at 9:29 AM, Fred Finken
<Fred.Finken at mascocabinetry.com>wrote:
> Hi David,
>
>
>
> I’d like to add the XSLX capabilities to an AIX system. Do you know the
> considerations for getting this done? Should the Linux versions work or
> would you expect to use something else?
>
>
>
> Download is a great product that I’ve been using for years and I love the
> functionality.
>
>
>
> Thank you.
>
>
>
> *From:* download-list-bounces at cedarville.edu [mailto:
> download-list-bounces at cedarville.edu] *On Behalf Of *Rotman, David
> *Sent:* Monday, May 05, 2014 8:47 AM
> *To:* Cedarville DOWNLOAD Users
> *Subject:* Re: [Download-List] How To Retrieve The Record Number For A
> Multivalued Field
>
>
>
> The big change in version 8.00 was support for creating Excel (XLSX)
> files. This took only one line in the version summary, but did require
> substantial changes in the programming. Depending on local configuration
> settings, the Excel files are created by first generating a delimited file
> (CSV, tab, etc.) and then calling a routine at the operating-system level
> to convert the delimited file to XLSX.
>
>
>
>
>
>
> 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 Mon, May 5, 2014 at 7:58 AM, Glasser, David <glasserd at union.edu> wrote:
>
> 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
>
>
> _______________________________________________
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20140512/f5569692/attachment.html>
More information about the download-list
mailing list