<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v = "urn:schemas-microsoft-com:vml" xmlns:o = "urn:schemas-microsoft-com:office:office" xmlns:w = "urn:schemas-microsoft-com:office:word" xmlns:m = "http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7601.17622">
<STYLE><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></STYLE>
</HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 12pt Arial" lang=EN-US link=blue vLink=purple>
<DIV>I do not believe there is an automatic way to generate unique names.</DIV>
<DIV> </DIV>
<DIV>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:</DIV>
<DIV> EVAL "FIELD(U80.ADMT.EVENT.ADDR,@VM,1,1)" COL.HDG "addrline1" </DIV>
<DIV> EVAL "FIELD(U80.ADMT.EVENT.ADDR,@VM,2,1)" COL.HDG "addrline2" </DIV>
<DIV><BR>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.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>
<DIV><FONT face=Arial>Dave Rotman</FONT></DIV>
<DIV><FONT face=Arial>Associate Vice President for Technology<BR>Chief Information Officer</FONT></DIV>
<DIV><FONT face=Arial>Cedarville University<BR>251 N. Main Street<BR>Cedarville, OH 45314<BR>rotmand@cedarville.edu<BR>voice 937-766-7905<BR>fax 937-766-8819</FONT></DIV>
<DIV> </DIV></DIV>
<DIV><BR>>>> On 8/22/2011 at 5:15 PM, in message <4E52C705.EC5 : 110 : 40645>, "Glasser, David G." <glasserd@union.edu> wrote:<BR></DIV>
<TABLE style="MARGIN: 0px 0px 0px 15px; FONT-SIZE: 1em" border=0 bgColor=#f3f3f3>
<TBODY>
<TR>
<TD>
<DIV style="BORDER-LEFT: #050505 1px solid; PADDING-LEFT: 7px">
<DIV class=WordSection1>
<P class=MsoNormal>Hi All,<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>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.:<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><u80admteventaddr>Addr Line 1</u80admteventaddr><o:p></o:p></P>
<P class=MsoNormal><u80admteventaddr>Addr Line 2</u80admteventaddr><o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Is there any way to have these named differently? Full statement is below.<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Any help that you can provide would be much appreciated.<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Thanks,<o:p></o:p></P>
<P class=MsoNormal>David<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>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<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt">David Glasser</SPAN><SPAN style="FONT-SIZE: 12pt"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt">Enrollment Systems Analyst<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt">Office of Admissions and Financial Aid</SPAN><o:p></o:p></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt">Union College</SPAN><o:p></o:p></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt">Grant Hall</SPAN><o:p></o:p></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt">Schenectady, NY 12308</SPAN><o:p></o:p></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt">Phone: (518) 388-6561</SPAN><o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P></DIV></DIV></TD></TR></TBODY></TABLE></BODY></HTML>