[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