[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