[Download-List] Download XML question..., multi-value output
Davis Kriss P
kpdavis at ilstu.edu
Mon Dec 22 13:50:42 EST 2003
Hello list folks...
I have tried several things and just can't quite get what I need. It
may not be possible to get... Anyone with any ideas???
Below is a DOWNLOAD statement to output various single value fields and
one pair of multi-value fields (MDEBIT/MCREDIT) in XML format. The
download runs just fine and farther below you will see the first bunch
of lines in the XML output. The MACTUALS structure in the XML (created
by lines 10 and 11) is where I am having a problem.
When I IMPORT this into MSACCESS (2003), ACCESS does a great job of
importing the GLS fields and even recognizes the MACTUALS as being a
separate table it needs to create. Very cool...
The final thing though I need is to get the @ID associated with the
appropriate set of MDEBITS and MCREDITS. As it works now. The MACTUALS
table in ACCESS has all the data, but no key to relate it back to the
GLS.2004 base table. I think I need a <id> </id> tag embedded with
each occurance of the MACTUALS XML structure. It would have the same
data in it as the <id> tag for the whole XML/GLS "record". Then either
ACCESS would recognize the key and create the link, or I could do it
after the import is complete.
Thanks I advance!
Kriss
PS. I will share the answer to the list if someone sends it to me
directly.
-------------------------
Kriss Davis, CCP
Illinois State University
kpdavis at ilstu.edu
-------------------------
001: PA
002: SELECT GLS.2004 SAMPLE 5
003: SAVE.LIST DOWNLOAD.GLS.2004A1
004: GET.LIST DOWNLOAD.GLS.2004A1
005: DOWNLOAD GLS.2004 \
006: @ID \
007: OPEN.BAL \
008: DEBITS.YTD \
009: CREDITS.YTD \
010: MDEBITS NUM.VALUES ALL \
011: MCREDITS NUM.VALUES ALL \
012: ACCOUNT.ID \
013: ACTIVITY.SEQ \
014: CLOSE.DEBITS \
015: CLOSE.CREDITS \
016: GLS.FSLVL \
017: GLS.FYR.ADD.OPERATOR \
018: GLS.FYR.ADD.DATE \
019: GLS.FYR.CHANGE.OPERATOR \
020: GLS.FYR.CHANGE.DATE \
021: B.ORIG.APPROVED.AMT \
022: B.APPR.DEBITS.YTD \
*--: P
023: B.APPR.CREDITS.YTD \
024: B.CONT.DEBITS.YTD \
025: B.CONT.CREDITS.YTD \
026: B.ALOC.DEBITS.YTD \
027: B.ALOC.CREDITS.YTD\
028: E.OPEN.BAL \
029: ENCUMBRANCES.YTD \
030: ENCUMBRANCES.RELIEVED.YTD \
031: ENCUMBRANCES.RELIEVED.YTD.CONV \
032: GLS.BUDGET.LINKAGE \
033: GLS.POOLED.TYPE \
034: GLS.ESTIMATED.OPEN.BAL \
035: FORMAT XML \
036: PROGRESS.INTERVAL 1000 \
037: PRINT.LAYOUT \
038: FILE DOWNLOAD.TEMP DOWNLOAD.GLS.2004 OVERWRITING
039: DELETE.LIST DOWNLOAD.GLS.2004A1
Bottom.
*--:
XML OUTPUT:
----------------------------------------------------------------
<?xml version="1.0"?>
<download>
<gls2004>
<id>10100_06_346000000_615100</id>
<openbal></openbal>
<debitsytd>12,975.00 </debitsytd>
<creditsytd>0.00 </creditsytd>
<mactuals>
<mdebits>4,325.00 </mdebits>
<mcredits>0.00 </mcredits>
</mactuals>
<mactuals>
<mdebits>4,325.00 </mdebits>
<mcredits>0.00 </mcredits>
</mactuals>
<mactuals>
<mdebits>4,325.00 </mdebits>
<mcredits>0.00 </mcredits>
</mactuals>
<mactuals>
<mdebits>4,325.00 </mdebits>
<mcredits>0.00 </mcredits>
</mactuals>
<mactuals>
<mdebits>4,325.00 </mdebits>
<mcredits>0.00 </mcredits>
</mactuals>
<mactuals>
<mdebits>4,325.00 </mdebits>
<mcredits>0.00 </mcredits>
</mactuals>
<accountid></accountid>
<activityseq>12</activityseq>
<closedebits></closedebits>
<closecredits></closecredits>
<glsfslvl></glsfslvl>
<glsfyraddoperator>DATATEL</glsfyraddoperator>
<glsfyradddate>11/04/02</glsfyradddate>
<glsfyrchangeoperator>MTSHADI</glsfyrchangeoperator>
<glsfyrchangedate>12/17/03</glsfyrchangedate>
<borigapprovedamt></borigapprovedamt>
<bapprdebitsytd>0.00 </bapprdebitsytd>
<bapprcreditsytd>0.00 </bapprcreditsytd>
<bcontdebitsytd>0.00 </bcontdebitsytd>
<bcontcreditsytd>0.00 </bcontcreditsytd>
<balocdebitsytd>0.00 </balocdebitsytd>
<baloccreditsytd>0.00 </baloccreditsytd>
<eopenbal></eopenbal>
<encumbrancesytd>0.00 </encumbrancesytd>
<encumbrancesrelievedytd>0.00 </encumbrancesrelievedytd>
<encumbrancesrelievedytdconv>0</encumbrancesrelievedytdconv>
<glsbudgetlinkage>10100_06_346000000_991120</glsbudgetlinkage>
<glspooledtype>P</glspooledtype>
<glsestimatedopenbal></glsestimatedopenbal>
</gls2004>
<gls2004>
<id>10601_08_260003002_545508</id>
<openbal></openbal>
<debitsytd>1,083.26 </debitsytd>
<creditsytd>37,467.50 </creditsytd>
<mactuals>
<mdebits>170.00 </mdebits>
<mcredits>1,640.52 </mcredits>
</mactuals>
<mactuals>
<mdebits>133.26 </mdebits>
<mcredits>3,060.66 </mcredits>
</mactuals>
<mactuals>
<mdebits>780.00 </mdebits>
<mcredits>32,766.32 </mcredits>
</mactuals>
<mactuals>
<mdebits>170.00 </mdebits>
<mcredits>84,486.13 </mcredits>
</mactuals>
<mactuals>
<mdebits>65.00 </mdebits>
<mcredits>91,535.40 </mcredits>
</mactuals>
<mactuals>
<mdebits>60.00 </mdebits>
<mcredits>92,860.79 </mcredits>
</mactuals>
<accountid></accountid>
<activityseq>224</activityseq>
<closedebits></closedebits>
<closecredits></closecredits>
<glsfslvl></glsfslvl>
<glsfyraddoperator>JBAHNSE</glsfyraddoperator>
<glsfyradddate>07/02/03</glsfyradddate>
<glsfyrchangeoperator>JBAHNSE</glsfyrchangeoperator>
<glsfyrchangedate>12/19/03</glsfyrchangedate>
<borigapprovedamt>600,000.00-</borigapprovedamt>
<bapprdebitsytd>0.00 </bapprdebitsytd>
<bapprcreditsytd>0.00 </bapprcreditsytd>
<bcontdebitsytd>0.00 </bcontdebitsytd>
<bcontcreditsytd>0.00 </bcontcreditsytd>
<balocdebitsytd>0.00 </balocdebitsytd>
<baloccreditsytd>600,000.00 </baloccreditsytd>
<eopenbal></eopenbal>
<encumbrancesytd>0.00 </encumbrancesytd>
<encumbrancesrelievedytd>0.00 </encumbrancesrelievedytd>
<encumbrancesrelievedytdconv>0</encumbrancesrelievedytdconv>
<glsbudgetlinkage></glsbudgetlinkage>
<glspooledtype></glspooledtype>
<glsestimatedopenbal></glsestimatedopenbal>
</gls2004>
...
--------------------------------------------------------------------
More information about the download-list
mailing list