[Download-List] How To Retrieve The Record Number For A Multivalued Field
Fred Finken
Fred.Finken at mascocabinetry.com
Mon May 5 09:29:05 EDT 2014
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<mailto:rotmand at cedarville.edu>
voice 937-766-7905
fax 937-766-8819
[http://www.cedarville.edu/~/media/Images/Information-Technology/IT-logo-for-signature.jpg]
On Mon, May 5, 2014 at 7:58 AM, Glasser, David <glasserd at union.edu<mailto: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<mailto: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<mailto:rotmand at cedarville.edu>
voice 937-766-7905<tel:937-766-7905>
fax 937-766-8819<tel:937-766-8819>
[http://www.cedarville.edu/~/media/Images/Information-Technology/IT-logo-for-signature.jpg]
On Sun, May 4, 2014 at 10:40 PM, Small, Eric <esmall at chapman.edu<mailto: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<tel:714%2F744-7852>
esmall at chapman.edu<mailto:esmall at chapman.edu><mailto: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><mailto: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<tel:888.221.6372%20x.809> | Dallas: 214.774.4780 x.809<tel:214.774.4780%20x.809>
Fax: 512-469-6306<tel:512-469-6306>
Email: athomason at zogotech.com<mailto:athomason at zogotech.com><mailto:athomason at zogotech.com<mailto:athomason at zogotech.com>> | Web: zogotech.com<http://zogotech.com><http://www.zogotech.com/>
From: Small, Eric [mailto:esmall at chapman.edu<mailto:esmall at chapman.edu>]
Sent: Wednesday, April 23, 2014 11:02 AM
To: support at zogotech.com<mailto:support at zogotech.com><mailto: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<tel:714%2F744-7852>
esmall at chapman.edu<mailto:esmall at chapman.edu><mailto: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<mailto: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><mailto: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<tel:888.221.6372%20x%20814> | Austin: 214.774.4780 x 814<tel:214.774.4780%20x%20814> | Fax: 512-469-6306<tel:512-469-6306>
Email: kwiggans at zogotech.com<mailto:kwiggans at zogotech.com><mailto:kwiggans at zogotech.com<mailto:kwiggans at zogotech.com>> | Web: zogotech.com<http://zogotech.com><http://zogotech.com>
_______________________________________________
download-list mailing list
download-list at cedarville.edu<mailto:download-list at cedarville.edu>
http://mail.cedarville.edu/mailman/listinfo/download-list
_______________________________________________
download-list mailing list
download-list at cedarville.edu<mailto: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<tel:%28518%29%20388-6561>
Visit Union: www.union.edu<http://www.union.edu/>
Twitter and Instagram: @unionadmissions
_______________________________________________
download-list mailing list
download-list at cedarville.edu<mailto: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/2ff8710b/attachment.html>
More information about the download-list
mailing list