[Download-List] Double Quotes in LITERAL command

Brich, Richard W. Richard.Brich at sdsmt.edu
Fri Mar 10 11:39:03 EST 2006


Trust no one... - the system rule here "anything with KEEP in the name
are
never to be removed" - but I keep a backup on my local drive...

-----Original Message-----
From: download-list-bounces at cedarville.edu
[mailto:download-list-bounces at cedarville.edu] On Behalf Of Keith Johnson
Sent: Friday, March 10, 2006 9:31 AM
To: Cedarville DOWNLOAD Users
Subject: RE: [Download-List] Double Quotes in LITERAL command


PS
The downside if you clear your savelists by accident you are back to
square one.  And my need for envision is alive again.

-----Original Message-----
From: download-list-bounces at cedarville.edu
[mailto:download-list-bounces at cedarville.edu] On Behalf Of Brich,
Richard W.
Sent: Friday, March 10, 2006 8:23 AM
To: Cedarville DOWNLOAD Users
Subject: RE: [Download-List] Double Quotes in LITERAL command

Logic to get records added since query was run

*NEW PROSPECTS SINCE PARA WAS LAST RUN

GET.LIST XM.PRO.KEEP

SAVE.LIST XM.PRO.KEEP.BAK

SELECT APPLICATIONS WITH APPL.START.TERM = <<ENTER START TERM(S)>>\

 WITH NO APPL.CURRENT.STATUS EQ 'CAN' 'DEN' 'WDR'\

 WITH XM.APPL.REAL.PERSON = 'Y' \

 WITH APPL.ACAD.PROGRAM LIKE 'M...' \

 WITH APPL.PROSPECT.STATUS NE 'NOI'

SAVE.LIST XM.PRO.KEEP

GET.LIST XM.PRO.KEEP TO 1

GET.LIST XM.RWB.PRO.KEEP.BAK TO 2

MERGE.LIST 1 DIFF 2 

-----Original Message-----
From: download-list-bounces at cedarville.edu
[mailto:download-list-bounces at cedarville.edu] On Behalf Of Keith Johnson
Sent: Friday, March 10, 2006 8:51 AM
To: Cedarville DOWNLOAD Users
Subject: RE: [Download-List] Double Quotes in LITERAL command


All,
I use download to extract data for CBORD too.  However I have found it
lacking.  It needs to be pre-processed to find who dropped out from the
day before.  Has anyone written any code to track this yet in envision?
Currently I extract the data import it to a minor access database and
compare who was in the list last run to this run mark the records
accordingly then extract the records that are new or dropped only for
CBORD. -KJ

Or have I misses something here?

-Keith Johnson
Lewis-Clark State College
Lewiston, ID 83501
208 792 2510


-----Original Message-----
From: download-list-bounces at cedarville.edu
[mailto:download-list-bounces at cedarville.edu] On Behalf Of Twitchell,
Wayne
Sent: Friday, March 10, 2006 5:33 AM
To: Cedarville DOWNLOAD Users
Subject: RE: [Download-List] Double Quotes in LITERAL command

So how do you get it to output the fixed format and don't you have to
tell it number of records? (sorry to ask such obvious questions, I use
download but our program for cboard was written by another programmer
who does not use download and I am wanting to approach him with this...)

Wayne Twitchell
Applications Integrator/Developer
Information Technology Services - Campus Information Systems Team
Grinnell College 641-269-4348 twitchew at grinnell.edu




...[snip]...

_______________________________________________
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

_______________________________________________
download-list mailing list
download-list at cedarville.edu
http://mail.cedarville.edu/mailman/listinfo/download-list




More information about the download-list mailing list