[Download-List] Perplexing Issue

Fri May 4 11:36:21 EDT 2018

Thanks, David!
I’ll have to try this out.
Thank you,
Carol

From: download-list-bounces at cedarville.edu [mailto:download-list-bounces at cedarville.edu] On Behalf Of Rotman, David
Sent: Wednesday, May 02, 2018 6:19 PM
To: Cedarville DOWNLOAD Users <download-list at cedarville.edu>
Subject: Re: [Download-List] Perplexing Issue

I have heard about this kind of thing happening when i-descriptors make use of @1, @2, etc.  My suspicion (unproven) is that the variables (especially @RECORD and @ID) get modified somewhere deep in the Envision code that gets included in the subroutine.

The original virtual field looks like this:

DICT PERSON “PERSON.ACTV.CUI.RELTN.CUI”

   TRANS(“RELATIONSHIP”,PERSON.CUI.RELATIONSHIP.CUI,”RS.RELATION.TYPE,”X”);

   TRANS(“RELATIONSHIP”,PERSON.CUI.RELATIONSHIP.CUI,”RS.START.DATE”,”X”);

   TRANS(“RELATIONSHIP”,PERSON.CUI.RELATIONSHIP.CUI,”RS.END.DATE”,”X”);

   SUBR(“CC.X.S.ACTIVE.REL.TPES.CUI”, at 1, at 2, at 3);

   @4

Here is a workable suggestion (but hard to read in an actual dictionary entry):

DICT PERSON “PERSON.ACTV.CUI.RELTN.CUI”

   SUBR(“CC.X.S.ACTIVE.REL.TPES.CUI”,

   TRANS(“RELATIONSHIP”,PERSON.CUI.RELATIONSHIP.CUI,”RS.RELATION.TYPE,”X”),

   TRANS(“RELATIONSHIP”,PERSON.CUI.RELATIONSHIP.CUI,”RS.START.DATE”,”X”),

   TRANS(“RELATIONSHIP”,PERSON.CUI.RELATIONSHIP.CUI,”RS.END.DATE”,”X”))

Error checking and readability might be improved by creating 3 new dictionary
entries:

DICT PERSON “PAC.RELTN.TYPE”

   TRANS(“RELATIONSHIP”,PERSON.CUI.RELATIONSHIP.CUI,”RS.RELATION.TYPE,”X”)

DICT PERSON “PAC.RELTN.START.DATE”

   TRANS(“RELATIONSHIP”,PERSON.CUI.RELATIONSHIP.CUI,”RS.START.DATE”,”X”)

DICT PERSON “PAC.RELTN.END.DATE”

   TRANS(“RELATIONSHIP”,PERSON.CUI.RELATIONSHIP.CUI,”RS.END.DATE”,”X”)

DICT PERSON “PERSON.ACTV.CUI.RELTN.CUI”

   SUBR(“CC.X.S.ACTIVE.REL.TPES.CUI”,PAC.RELTN.TYPE,PAC.RELTN.START.DATE,PAC.RELTN.END.DATE)

Hope this helps...

David Rotman
15276 Nashua Circle
Westfield, IN 46074
rotmand at cedarville.edu<mailto:rotmand at cedarville.edu>
937-532-4739<tel:(937)%20532-4739>

On Fri, Apr 27, 2018 at 1:33 PM, Carol Van Weelden <VANWEELDENC at central.edu<mailto:VANWEELDENC at central.edu>> wrote:
Hi David,
Yes. Please see the attached file.
Sorry that took so long, but Colleague Studio is running very slowly for us today. (Argh!)
Thank you,
Carol

From: download-list-bounces at cedarville.edu<mailto:download-list-bounces at cedarville.edu> [mailto:download-list-bounces at cedarville.edu<mailto:download-list-bounces at cedarville.edu>] On Behalf Of Rotman, David
Sent: Friday, April 27, 2018 11:19 AM
To: Cedarville DOWNLOAD Users <download-list at cedarville.edu<mailto:download-list at cedarville.edu>>
Subject: Re: [Download-List] Perplexing Issue

Carol--

Would you be able to show us the definitions for the virtual fields and also the actual Download statement you are using?

Thanks.

David Rotman
15276 Nashua Circle
Westfield, IN 46074
rotmand at cedarville.edu<mailto:rotmand at cedarville.edu>
937-532-4739<tel:(937)%20532-4739>

On Fri, Apr 27, 2018 at 10:11 AM, Carol Van Weelden <VANWEELDENC at central.edu<mailto:VANWEELDENC at central.edu>> wrote:
We have 2 fields defined in our Colleague PERSON file that go through the Organization section of Relationships (PREL) and, after dividing them in Active and Inactive, list the Role(s) of those relationships, eg. MBR (for Member).  These lists are subsequently made into long strings where the entries are separated with semicolons. LISTing the data, the fields display correctly. However, using DOWNLOAD, the data from the inactive field appears to get pulled into the active field and the inactive field appears empty.  It doesn’t matter what order the fields appear in, in the DOWNLOAD command, they always behave the same way.

Any ideas  are greatly appreciated.

Thank you,

CAROL VAN WEELDEN
Senior Systems Analyst | Central College
812 University Street | Campus Box 5500 | Pella, Iowa 50219

vanweeldenc at central.edu<mailto:vanweeldenc at central.edu> | www.central.edu<http://www.central.edu/>
Office: 641.628.7619 | Fax: 641.628.5316
Twitter : @CentralCollege; @CentralDutch
Facebook: Central College; Central College Dutch

[cid:image001.png at 01D051D5.56661940]

_______________________________________________
download-list mailing list
download-list at cedarville.edu<mailto:download-list at cedarville.edu>
http://mail.cedarville.edu/mailman/listinfo/download-list

_______________________________________________
download-list mailing list
download-list at cedarville.edu<mailto:download-list at cedarville.edu>
http://mail.cedarville.edu/mailman/listinfo/download-list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20180504/4cfb35a5/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 5837 bytes
Desc: image001.png
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20180504/4cfb35a5/attachment.png>