[Download-List] DOWNLOAD using VF via script results in error

[Jacob Geluk]

Try shaking down your friendly local programmer to write a function that
wraps SWAP.

 

Then you can forget the line by line "if-thens" (they make my eyes go
blurry :-)).

 

If your programmer wraps SWAP with S.SWAP you should be able to: 

 

TRANS ("MAJORS", MAJ.DESC," MAJORS.DESC");

SUBR ("S.SWAP", "Do Not Use","", at 1);

SUBR ("S.SWAP", "Non-Degree Program","", at 2);

SUBR("S.STRIP.NULLS", at 3)

 

Cheers,

 

 

 

Jacob Geluk, Senior Administrative Systems Analyst

Simmons College 300 The Fenway

Boston MA 02114

(617) 521-2198

 

-----Original Message-----
From: download-list-admin at cedarville.edu
[mailto:download-list-admin at cedarville.edu] On Behalf Of Cindy Goede
Sent: Thursday, April 08, 2004 11:33 AM
To: download-list at cedarville.edu
Subject: [Download-List] DOWNLOAD using VF via script results in error

 

I have a paragraph that uses the virtual field below to DOWNLOAD a XML
file.  It works fine when I run it from the colon prompt.  When the
paragraph is run from a script it doesn't work.

virtual field----------------------------------------------
SUBR("S.L53.REMOVE.DUPS",X.LUTHER.MAJORS.ALL);
TRANS("MAJORS",FIELD(@1, at VM,1,1),"MAJORS.DESC","X");
TRANS("MAJORS",FIELD(@1, at VM,2,1),"MAJORS.DESC","X");
TRANS("MAJORS",FIELD(@1, at VM,3,1),"MAJORS.DESC","X");
TRANS("MAJORS",FIELD(@1, at VM,4,1),"MAJORS.DESC","X");
TRANS("MAJORS",FIELD(@1, at VM,5,1),"MAJORS.DESC","X");
TRANS("MAJORS",FIELD(@1, at VM,6,1),"MAJORS.DESC","X");
IF @2 NE 'Do Not Use' AND @2 NE 'Non-Degree Program' THEN @2 ELSE '';
IF @3 NE 'Do Not Use' AND @3 NE 'Non-Degree Program' THEN @3 ELSE '';
IF @4 NE 'Do Not Use' AND @4 NE 'Non-Degree Program' THEN @4 ELSE '';
IF @5 NE 'Do Not Use' AND @5 NE 'Non-Degree Program' THEN @5 ELSE '';
IF @6 NE 'Do Not Use' AND @6 NE 'Non-Degree Program' THEN @6 ELSE '';
IF @7 NE 'Do Not Use' AND @7 NE 'Non-Degree Program' THEN @7 ELSE '';
SUBR("S.STRIP.NULLS", at 8:@VM:@9:@VM:@10:@VM:@11:@VM:@12:@VM:@13)
---------------------------------------------------------

# ./usr/udms/scripts/ldapalumextract
/datatel/live/benlive
UniData Release 6.0  Build: (4161)
(c) Copyright IBM Corporation 2002.
All rights reserved.
Current UniData home is /usr/ud51/.
Current working directory is /datatel/live/benlive.
:L53.LIS.LDAP.ALUM 
This paragraph creates a file of Alumni to be updated in LDAP
980 records retrieved to list 0.
DOWNLOAD version 6.02
Using input file PERSON
Output to file _HOLD_ LdapAlum.xml
In /usr/local/DOWNLOAD.SOURCE/_DOWNLOAD.LOAD at line 119 Virtual
Attribute Error
: In /usr/local/DOWNLOAD.SOURCE/_DOWNLOAD.LOAD at line 119 Virtual field
too big.
1 record processed.
:#
---------------------------------------------------------
Any idea what the problem might be?



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20040430/7a3b031d/attachment.html>