[Download-List] Help with XML for MV association
Wendy Smoak
Wendy.Smoak at asu.edu
Fri Apr 8 16:45:19 EDT 2005
I'm having trouble getting DOWNLOAD to do what I want with a multivalued assocation. This is from the Benefactor PERSON file (with DSPLY):
44 NAME.HISTORY.LAST.NAME..........: |Donor|
<44,2,1>: |Smith|
45 NAME.HISTORY.FIRST.NAME.........: |Ima|
46 NAME.HISTORY.MIDDLE.NAME........: ||
This does what I want (but only includes the last name):
DOWNLOAD PERSON \
@ID \
NAME.HISTORY.LAST.NAME XML.GROUP.NAME 'historicalnames' \
DEFAULT NUM.VALUES ALL \
XML.ROOT.NAME '' \
XML.VERSION '' \
FORMAT XML
Gives:
<person>
<id>0252436</id>
<historicalnames>
<namehist>
<namehistorylastname>Donor</namehistorylastname>
</namehist>
<namehist>
<namehistorylastname>Smith</namehistorylastname>
</namehist>
</historicalnames>
</person>
But as soon as I add the first name, I "lose" the second set of associated values.
DOWNLOAD PERSON \
@ID \
NAME.HISTORY.LAST.NAME XML.GROUP.NAME 'historicalnames' \
NAME.HISTORY.FIRST.NAME XML.GROUP.NAME 'historicalnames' \
DEFAULT NUM.VALUES ALL \
XML.ROOT.NAME '' \
XML.VERSION '' \
FORMAT XML
Gives:
<person>
<id>0252436</id>
<historicalnames>
<namehist>
<namehistorylastname>Donor</namehistorylastname>
<namehistoryfirstname>Ima</namehistoryfirstname>
</namehist>
</historicalnames>
</person>
Which is missing the 'Smith' last name. There should be another <namehist> section. Technically, the data is missing a value mark in the first and middle name fields, but that's how Datatel does it. :(
:AE PERSON 0252436
Top of "0252436" in "PERSON", 150 lines, 662 characters.
*--: 44
044: DonorýSmith
045: Ima
046:
*--:
Is there some combination of keywords that will make DOWNLOAD produce this?
<person>
<id>0252436</id>
<historicalnames>
<namehist>
<namehistorylastname>Donor</namehistorylastname>
<namehistoryfirstname>Ima</namehistoryfirstname>
</namehist>
<namehist>
<namehistorylastname>Smith</namehistorylastname>
</namehist>
</historicalnames>
</person>
Thanks,
--
Wendy Smoak
Applications Systems Analyst, Sr.
Arizona State University, PA, IRM
More information about the download-list
mailing list