[Download-List] Multivalue Fields and XML

[David L. Rotman]

I do not believe there is an automatic way to generate unique names.
 
I would recommend creating virtual fields U80.ADMT.EVENT.ADDR.1 and
U80.ADMT.EVENT.ADDR.2 that pull off the first- and second-values
repsectively.  Alternatively, you could use EVAL expressions:
   EVAL "FIELD(U80.ADMT.EVENT.ADDR, at VM,1,1)" COL.HDG "addrline1" 
   EVAL "FIELD(U80.ADMT.EVENT.ADDR, at VM,2,1)" COL.HDG "addrline2" 

The EVAL option works best if you are using Download version 7.40 that
allows compiling of EVAL expressions.  EVAL will work with earlier
versions, but runs much slower.
 
 
 
Dave Rotman
Associate Vice President for Technology
Chief Information Officer
Cedarville University
251 N. Main Street
Cedarville, OH 45314
rotmand at cedarville.edu
voice 937-766-7905
fax 937-766-8819
 

>>> On 8/22/2011 at 5:15 PM, in message <4E52C705.EC5 : 110 : 40645>,
"Glasser, David G." <glasserd at union.edu> wrote:


Hi All,
 
I’m currently using DOWNLOAD to dump data to an XML file. One of my
fields is multi-valued and I’m using NUM.VALUES ALL to retrieve all the
values. However, this results in two XML fields being of the same name,
i.e.:
 
<u80admteventaddr>Addr Line 1</u80admteventaddr>
<u80admteventaddr>Addr Line 2</u80admteventaddr>
 
Is there any way to have these named differently? Full statement is
below.
 
Any help that you can provide would be much appreciated.
 
Thanks,
David
 
DOWNLOAD U80.ADM.TRAVEL @ID U80.ADMT.EVENT.TYPE U80.ADMT.START.DATES
NUM.VALUES ALL U80.ADMT.START.DATE1 CONV "M" U80.ADMT.START.TIMES 
NUM.VALUES ALL U80.ADMT.END.DATES NUM.VALUES ALL U80.ADMT.END.TIMES
NUM.VALUES ALL U80.ADMT.START.TIME1 CONV "M" U80.ADMT.EVENT.FULL.NAME
U80.ADMT.EVENT.ADDR NUM.VALUES ALL U80.ADMT.EVENT.CITY
U80.ADMT.EVENT.STATE U80.ADMT.EVENT.ZIP U80.ADMT.INST1 U80.ADMT.INST2
U80.ADMT.INST3 U80.ADMT.INST1.CITY U80.ADMT.INST1.STATE U80.ADMT.STAFF1
U80.ADMT.STAFF1.EMAIL FORMAT XML FILE _HOLD_\GLASSERD ADMTRAVEL.XML
NO.PAGE NO.PRINT.ERRORS OVERWRITING
 
David Glasser
Enrollment Systems Analyst
Office of Admissions and Financial Aid
Union College
Grant Hall
Schenectady, NY 12308
Phone: (518) 388-6561
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20110823/407c7372/attachment.html>