[Download-List] Inserting a Line Feed in Verticalorienttion Download File

[Kenneth B. Nies]

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/20120213/f42d6d78/attachment.html>