<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7233.28">
<TITLE>RE: [Download-List] Double Quotes in LITERAL command</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Sorry all</FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">,</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">I guess that was a</FONT></SPAN><SPAN LANG="en-us"> <FONT SIZE=2 FACE="Courier New">dumb</FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New"> question for the start of the day</FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">. </FONT></SPAN><SPAN LANG="en-us"> <FONT SIZE=2 FACE="Courier New">I know about merge.list</FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">.</FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New"> I use it quite a bit in my current PA to</FONT></SPAN><SPAN LANG="en-us"> <FONT SIZE=2 FACE="Courier New">determine</FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New"> who as paid and not paid. Sad or funny take your pick</FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">…</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Thanks for the wakeup</FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New"> -Keith</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<BR>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">SAVE.LIST XM.PRO.KEEP</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">GET.LIST XM.PRO.KEEP TO 1</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">GET.LIST XM.RWB.PRO.KEEP.BAK TO 2</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Courier New">MERGE.LIST</FONT></B></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New"> 1 DIFF 2</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<BR>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">-----Original Message-----<BR>
From: download-list-bounces@cedarville.edu [<A HREF="mailto:download-list-bounces@cedarville.edu">mailto:download-list-bounces@cedarville.edu</A>] On Behalf Of Brich, Richard W.<BR>
Sent: Friday, March 10, 2006 8:23 AM<BR>
To: Cedarville DOWNLOAD Users<BR>
Subject: RE: [Download-List] Double Quotes in LITERAL command</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Logic to get records added since query was run</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">*NEW PROSPECTS SINCE PARA WAS LAST RUN</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">GET.LIST XM.PRO.KEEP</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">SAVE.LIST XM.PRO.KEEP.BAK</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">SELECT APPLICATIONS WITH APPL.START.TERM = <<ENTER START TERM(S)>>\</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New"> WITH NO APPL.CURRENT.STATUS EQ 'CAN' 'DEN' 'WDR'\</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New"> WITH XM.APPL.REAL.PERSON = 'Y' \</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New"> WITH APPL.ACAD.PROGRAM LIKE 'M...' \</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New"> WITH APPL.PROSPECT.STATUS NE 'NOI'</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">SAVE.LIST XM.PRO.KEEP</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">GET.LIST XM.PRO.KEEP TO 1</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">GET.LIST XM.RWB.PRO.KEEP.BAK TO 2</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">MERGE.LIST 1 DIFF 2 </FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">-----Original Message-----</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">From: download-list-bounces@cedarville.edu</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">[<A HREF="mailto:download-list-bounces@cedarville.edu">mailto:download-list-bounces@cedarville.edu</A>] On Behalf Of Keith Johnson</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Sent: Friday, March 10, 2006 8:51 AM</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">To: Cedarville DOWNLOAD Users</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Subject: RE: [Download-List] Double Quotes in LITERAL command</FONT></SPAN></P>
<BR>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">All,</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">I use download to extract data for CBORD too. However I have found it</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">lacking. It needs to be pre-processed to find who dropped out from the</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">day before. Has anyone written any code to track this yet in envision?</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Currently I extract the data import it to a minor access database and</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">compare who was in the list last run to this run mark the records</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">accordingly then extract the records that are new or dropped only for</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">CBORD. -KJ</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Or have I misses something here?</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">-Keith Johnson</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Lewis-Clark State College</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Lewiston, ID 83501</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">208 792 2510</FONT></SPAN></P>
<BR>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">-----Original Message-----</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">From: download-list-bounces@cedarville.edu</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">[<A HREF="mailto:download-list-bounces@cedarville.edu">mailto:download-list-bounces@cedarville.edu</A>] On Behalf Of Twitchell,</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Wayne</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Sent: Friday, March 10, 2006 5:33 AM</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">To: Cedarville DOWNLOAD Users</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Subject: RE: [Download-List] Double Quotes in LITERAL command</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">So how do you get it to output the fixed format and don't you have to</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">tell it number of records? (sorry to ask such obvious questions, I use</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">download but our program for cboard was written by another programmer</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">who does not use download and I am wanting to approach him with this...)</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Wayne Twitchell</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Applications Integrator/Developer</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Information Technology Services - Campus Information Systems Team</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Grinnell College 641-269-4348 twitchew@grinnell.edu</FONT></SPAN></P>
<BR>
<BR>
<BR>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">...[snip]...</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">_______________________________________________</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">download-list mailing list</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">download-list@cedarville.edu</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New"><A HREF="http://mail.cedarville.edu/mailman/listinfo/download-list">http://mail.cedarville.edu/mailman/listinfo/download-list</A></FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">_______________________________________________</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">download-list mailing list</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">download-list@cedarville.edu</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New"><A HREF="http://mail.cedarville.edu/mailman/listinfo/download-list">http://mail.cedarville.edu/mailman/listinfo/download-list</A></FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
</BODY>
</HTML>