[Download-List] attribute to group name in xml file

[Spitzner, Eric]

Kevin,

FWIW, I had the same problem. And I have now decided the nature of the
problem is the difference in structure of the NCAA data and that of
Colleague. There is no repeating entity "year" in the Colleague scheme
which might contain, e.g., termCode or sport. Therefore, I'm now
developing a batch procedure and report program to produce the required
CAi xml file.

HTH
Eric Spitzner, CDP (eric.spitzner at quinnipiac.edu)
Senior Programmer/Analyst
Quinnipiac University; Hamden, Connecticut
Sun V440; Solaris 2.9; UniData 6.0.9
Colleague 17.0.14 and Benefactor 5.1 

-----Original Message-----

Good afternoon!

I am trying to generate an xml file for the NCAA CAi software. I am
building the file a little at a time using Download.
The schema says that the attribute "value' must appear on element
'year', which is the XML.GROUP.NAME for the award information.
But every time I try to add it, it goes to a place somewhere else. Can
you please advise on how to make <year value ='2006' >  appear with the
group name as an attribute?
Thank you very much!


005: SELECT SA.2006 WITH @ID EQ
'0237931'
006: DOWNLOAD SA.2006
\
007: SA.SSN XML.NAME 'schoolSidNumber' XML.ATTRIBUTE \
008: LITERAL 'save' XML.NAME 'action' XML.ATTRIBUTE \
009: SA.AWARD XML.GROUP.NAME "year" XML.ASSOC.NAME 'award' XML.NAME
'fundCode' X ML.ATTRIBUTE \
010: SA.AMOUNT XML.NAME 'awardAmount' XML.ATTRIBUTE \
011: X.KG.SA.DATE XML.NAME 'awardDate' XML.ATTRIBUTE \
012: X.KG.SA.ACTION XML.NAME 'action' XML.ATTRIBUTE \
013: DEFAULT NUM.VALUES ALL
\
014: XML.FILE.NAME 'student' 
\
015: XML.ROOT.NAME 'import' 
\
016: XML.ROOT.ATTRIBUTE
'xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" x
si:noNamespaceSchemaLocation="http://web1.ncaa.org/compliance/import/imp
ort.xsd"
  orgId="xxxxxx" orgPassword="xxxxxx" userId="xxxxxx"
userPassword="xxxxxx"'
\ 

017: FORMAT
XML



Kevin L. Galloway '87
Database Support Analyst
Information Technology Services
Wheeling Jesuit University
Phone (304) 243-2423
E-mail: kgalloway at wju.edu