[Download-List] Inserting a Line Feed in Verticalorienttion Download File
Kenneth B. Nies
kbnies at bhcc.mass.edu
Tue Feb 14 09:14:58 EST 2012
Thanks Scott,
I tried LITERAL ‘’ and that worked.
From: download-list-bounces at cedarville.edu [mailto:download-list-bounces at cedarville.edu] On Behalf Of Scott Howder
Sent: Tuesday, February 14, 2012 8:33 AM
To: Cedarville DOWNLOAD Users
Subject: Re: [Download-List] Inserting a Line Feed in Verticalorienttion Download File
Replace the last EVAL statement with the following and give it a try:
EVAL "@VM"
Scott Howder
Assistant CIO
Cedarville University
howders at cedarville.edu
937-766-7905
>>> On 2/13/2012 at 3:48 PM, in message <C736BBB49328304D88164FE17E45A2CE0450EB1E at mercury.bhcc.dom>, "Kenneth B. Nies" <kbnies at bhcc.mass.edu> wrote:
Thanks Katie, but that puts a line feed after every line (field) not just after every record.
From: download-list-bounces at cedarville.edu [mailto:download-list-bounces at cedarville.edu] On Behalf Of Katie Morgan
Sent: Monday, February 13, 2012 3:46 PM
To: Cedarville DOWNLOAD Users
Subject: Re: [Download-List] Inserting a Line Feed in Verticalorienttion Download File
Instead of doing an EVAL for that, have you tried using EOR.CHAR ^10 ?
Katie
Katie Morgan
Datatel Programmer/Analyst
Linfield College
900 SE Baker St
McMinnville OR 97128
503.883.2714
kmorgan at linfield.edu <mailto:kmorgan at linfield.edu>
From: download-list-bounces at cedarville.edu [mailto:download-list-bounces at cedarville.edu] On Behalf Of Kenneth B. Nies
Sent: Monday, February 13, 2012 11:54 AM
To: download-list at cedarville.edu
Subject: [Download-List] Inserting a Line Feed in Vertical orienttion Download File
Good afternoon,
This is my first post.
Below is some Code from a Datatel (Unix based) Paragraph which is calling the Download functionality:
GET.LIST BHCC50079.CHEL.SP.STU
DOWNLOAD STUDENTS LITERAL '0013' \
LITERAL '1-' \
LITERAL '2-' \
LITERAL '3254' \
LITERAL '4bhc' \
LITERAL '5' \
LITERAL '6' \
EVAL "'705-31-':(<<Enter Desired Academic Year (FORMAT 2009):>> - 1999)" \
EVAL "'8':STU.ACTIVE.PROGRAMS" \
EVAL "'n':STU.LAST.20:', ':STU.FIRST.20" \
EVAL "'a':X.B88.PREFERRED:'$':X.STU.PREF.CSZ" \
EVAL "'rCHESP':(<<Enter Desired Academic Year (FORMAT 2009):>> - 1999)" \
EVAL "'t':X.STU.PHONE.10" \
EVAL "'u':@ID" \
EVAL "^10"
QUOTE.CHAR "" \
RECORD.ORIENTATION VERTICAL \
FILE _HOLD_ BHCC50079_LIBRARY.DAT OVERWRITING
This format is required by a Library System we have on campus to allow students to borrow books from other libraries and read periodicals subscribed to by other libraries across our state.
The basic purpose of this file is to update the expiration date of the Student’s library usage.
The Last EVAL statement places a line feed between each record of fields vertically displayed.
We were having problems when we ran this script against approximately 12,000 records in that it would output a couple of hundred records with no problem, but then all field rows with an EVAL: statement were left blank.
An email to David Rotman concerning this issue resulted in a suggestion to Place a COMPILE.EVAL statement set to true on our Unix Server, which we did, but did not fix the problem. David also suggested removing the last EVAL: statement and replacing it with a LITERAL.
This, however creates a field row with the text “^10” rather than a line feed.
I have tried “LITERAL ‘^10’” resulting in the text “^10” rather than a line feed.
and “LITERAL ^10” resulting in an error message in Datatel stating it cannot recognize “^10”.
It would appear that Removing this last EVAL: statement will allow all the records to be populated correctly, but without the line feed.
Any ideas would be welcomed. Been on this for 2 weeks.
Thanks
Kenneth B. Nies, B.S.C.E., M. Arch.
Systems Analyst
Bunker Hill Community College
250 New Rutherford Avenue
Charlestown, MA 02129-2925
617-228-2353
kbnies at bhcc.mass.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20120214/59cf5fa0/attachment.html>
More information about the download-list
mailing list