XML Output is to long to Read

Author Message
bholmstrom

  • Total Posts : 10
  • Scores: 0
  • Reward points : 0
  • Joined: 10/15/2010
  • Location: NJ
  • Status: offline
XML Output is to long to Read Wednesday, October 20, 2010 2:52 AM (permalink)
0
Good morning, we have a VB program that calculates interest. The program works fine, the problem is sometimes the XML output from the program that we read back to an older database is too long if the number of paymens is real high.

The program loops thru the number of payments, calculates interest, first last payments etc...and throws out a xml string at the end so the other program can read it.
The other program can only read about 31,000 pieces then it dies.
Any way to cut it up into smaller chunks.
Here is the xml output:
 <paysched> 
 <parameters> 
 <title></title> 
 <loanamount>93456.65</loanamount> 
 <period>1005</period> 
 <interest>0.1</interest> 
 <paytype>1</paytype> 
 <frequency>3</frequency> 
 <schedulesetup>-1</schedulesetup> 
 <firstpayment>97.00</firstpayment> 
 <regpayment>97.00</regpayment> 
 <lastpayment>21.45</lastpayment> 
 <currentbalance>93456.65</currentbalance> 
 <startdate>20101120</startdate> 
 <diarycode>414</diarycode> 
 <diarydesc>DEBTOR OWES ME A PAYMENT</diarydesc> 
 <defaultdiarycode>414</defaultdiarycode> 
 <schedulechange>-1</schedulechange> 
 </parameters> 
 <schedule> 
 <record rec="1"><date>20101120 </date><payment>97 </payment></record><record rec="2"><date>20101220 </date><payment>97 </payment></record><record rec="3"><date>20110120 </date><payment>97 </payment></record><record rec="4"><date>20110220 </date><payment>97 </payment></record><record rec="5"><date>20110320 </date><payment>97 </payment></record><record rec="6"><date>20110420 </date><payment>97 </payment></record><record rec="7"><date>20110520 </date><payment>97 </payment></record><record rec="8"><date>20110620 </date><payment>97 </payment></record><record rec="9"><date>20110720 </date><payment>97 </payment></record><record rec="10"><date>20110820 </date><payment>97 </payment></record><record rec="11"><date>20110920 </date><payment>97 </payment></record><record rec="12"><date>20111020 </date><payment>97 </payment></record><record rec="13"><date>20111120 </date><payment>97 </payment></record><record rec="14"><date>20111220 </date><payment>97 </payment></record><record rec="15"><date>20120120 </date><payment>97 </payment></record><record rec="16"><date>20120220 </date><payment>97 </payment></record><record rec="17"><date>20120320 </date><payment>97 </payment></record><record rec="18"><date>20120420 </date><payment>97 </payment></record><record rec="19"><date>20120520 </date><payment>97 </payment></record><record rec="20"><date>20120620 </date><payment>97 </payment></record><record rec="21"><date>20120720 </date><payment>97 </payment></record><record rec="22"><date>20120820 </date><payment>97 </payment></record><record rec="23"><date>20120920 </date><payment>97 </payment></record><record rec="24"><date>20121020 </date><payment>97 </payment></record><record rec="25"><date>20121120 </date><payment>97 </payment></record><record rec="26"><date>20121220 </date><payment>97 </payment></record><record rec="27"><date>20130120 </date><payment>97 </payment></record><record rec="28"><date>20130220 </date><payment>97 </payment></record><record rec="29"><date>20130320 </date><payment>97 </payment></record><record rec="30"><date>20130420 </date><payment>97 </payment></record><record rec="31"><date>20130520 </date><payment>97 </payment></record><record rec="32"><date>20130620 </date><payment>97 </payment></record><record rec="33"><date>20130720 </date><payment>97 </payment></record><record rec="34"><date>20130820 </date><payment>97 </payment></record><record rec="35"><date>20130920 </date><payment>97 </payment></record><record rec="36"><date>20131020 </date><payment>97 </payment></record><record rec="37"><date>20131120 </date><payment>97 </payment></record><record rec="38"><date>20131220 </date><payment>97 </payment></record><record rec="39"><date>20140120 </date><payment>97 </payment></record><record rec="40"><date>20140220 </date><payment>97 </payment></record><record rec="41"><date>20140320 </date><payment>97 </payment></record><record rec="42"><date>20140420 </date><payment>97 </payment></record><record rec="43"><date>20140520 </date><payment>97 </payment></record><record rec="44"><date>20140620 </date><payment>97 </payment></record><record rec="45"><date>20140720 </date><payment>97 </payment></record><record rec="46"><date>20140820 </date><payment>97 </payment></record><record rec="47"><date>20140920 </date><payment>97 </payment></record><record rec="48"><date>20141020 </date><payment>97 </payment></record><record rec="49"><date>20141120 </date><payment>97 </payment></record><record rec="50"><date>20141220 </date><payment>97 </payment></record><record rec="51"><date>20150120 </date><payment>97 </payment></record><record rec="52"><date>20150220 </date><payment>97 </payment></record><record rec="53"><date>20150320 </date><payment>97 </payment></record><record rec="54"><date>20150420 </date><payment>97 </payment></record><record rec="55"><date>20150520 </date><payment>97 </payment></record><record rec="56"><date>20150620 </date><payment>97 </payment></record><record rec="57"><date>20150720 </date><payment>97 </payment></record><record rec="58"><date>20150820 </date><payment>97 </payment></record><record rec="59"><date>20150920 </date><payment>97 </payment></record><record rec="60"><date>20151020 </date><payment>97 </payment></record><record rec="61"><date>20151120 </date><payment>97 </payment></record><record rec="62"><date>20151220 </date><payment>97 </payment></record><record rec="63"><date>20160120 </date><payment>97 </payment></record><record rec="64"><date>20160220 </date><payment>97 </payment></record><record rec="65"><date>20160320 </date><payment>97 </payment></record><record rec="66"><date>20160420 </date><payment>97 </payment></record><record rec="67"><date>20160520 </date><payment>97 </payment></record><record rec="68"><date>20160620 </date><payment>97 </payment></record><record rec="69"><date>20160720 </date><payment>97 </payment></record><record rec="70"><date>20160820 </date><payment>97 </payment></record><record rec="71"><date>20160920 </date><payment>97 </payment></record><record rec="72"><date>20161020 </date><payment>97 </payment></record><record rec="73"><date>20161120 </date><payment>97 </payment></record><record rec="74"><date>20161220 </date><payment>97 </payment></record><record rec="75"><date>20170120 </date><payment>97 </payment></record><record rec="76"><date>20170220 </date><payment>97 </payment></record><record rec="77"><date>20170320 </date><payment>97 </payment></record><record rec="78"><date>20170420 </date><payment>97 </payment></record><record rec="79"><date>20170520 </date><payment>97 </payment></record><record rec="80"><date>20170620 </date><payment>97 </payment></record><record rec="81"><date>20170720 </date><payment>97 </payment></record><record rec="82"><date>20170820 </date><payment>97 </payment></record><record rec="83"><date>20170920 </date><payment>97 </payment></record><record rec="84"><date>20171020 </date><payment>97 </payment></record><record rec="85"><date>20171120 </date><payment>97 </payment></record><record rec="86"><date>20171220 </date><payment>97 </payment></record><record rec="87"><date>20180120 </date><payment>97 </payment></record><record rec="88"><date>20180220 </date><payment>97 </payment></record><record rec="89"><date>20180320 </date><payment>97 </payment></record><record rec="90"><date>20180420 </date><payment>97 </payment></record><record rec="91"><date>20180520 </date><payment>97 </payment></record><record rec="92"><date>20180620 </date><payment>97 </payment></record><record rec="93"><date>20180720 </date><payment>97 </payment></record><record rec="94"><date>20180820 </date><payment>97 </payment></record><record rec="95"><date>20180920 </date><payment>97 </payment></record><record rec="96"><date>20181020 </date><payment>97 </payment></record><record rec="97"><date>20181120 </date><payment>97 </payment></record><record rec="98"><date>20181220 </date><payment>97 </payment></record><record rec="99"><date>20190120 </date><payment>97 </payment></record><record rec="100"><date>20190220 </date><payment>97 </payment></record><record rec="101"><date>20190320 </date><payment>97 </payment></record><record rec="102"><date>20190420 </date><payment>97 </payment></record><record rec="103"><date>20190520 </date><payment>97 </payment></record><record rec="104"><date>20190620 </date><payment>97 </payment></record><record rec="105"><date>20190720 </date><payment>97 </payment></record><record rec="106"><date>20190820 </date><payment>97 </payment></record><record rec="107"><date>20190920 </date><payment>97 </payment></record><record rec="108"><date>20191020 </date><payment>97 </payment></record><record rec="109"><date>20191120 </date><payment>97 </payment></record><record rec="110"><date>20191220 </date><payment>97 </payment></record><record rec="111"><date>20200120 </date><payment>97 </payment></record><record rec="112"><date>20200220 </date><payment>97 </payment></record><record rec="113"><date>20200320 </date><payment>97 </payment></record><record rec="114"><date>20200420 </date><payment>97 </payment></record><record rec="115"><date>20200520 </date><payment>97 </payment></record><record rec="116"><date>20200620 </date><payment>97 </payment></record><record rec="117"><date>20200720 </date><payment>97 </payment></record><record rec="118"><date>20200820 </date><payment>97 </payment></record><record rec="119"><date>20200920 </date><payment>97 </payment></record><record rec="120"><date>20201020 </date><payment>97 </payment></record><record rec="121"><date>20201120 </date><payment>97 </payment></record><record rec="122"><date>20201220 </date><payment>97 </payment></record><record rec="123"><date>20210120 </date><payment>97 </payment></record><record rec="124"><date>20210220 </date><payment>97 </payment></record><record rec="125"><date>20210320 </date><payment>97 </payment></record><record rec="126"><date>20210420 </date><payment>97 </payment></record><record rec="127"><date>20210520 </date><payment>97 </payment></record><record rec="128"><date>20210620 </date><payment>97 </payment></record><record rec="129"><date>20210720 </date><payment>97 </payment></record><record rec="130"><date>20210820 </date><payment>97 </payment></record><record rec="131"><date>20210920 </date><payment>97 </payment></record><record rec="132"><date>20211020 </date><payment>97 </payment></record><record rec="133"><date>20211120 </date><payment>97 </payment></record><record rec="134"><date>20211220 </date><payment>97 </payment></record><record rec="135"><date>20220120 </date><payment>97 </payment></record><record rec="136"><date>20220220 </date><payment>97 </payment></record><record rec="137"><date>20220320 </date><payment>97 </payment></record><record rec="138"><date>20220420 </date><payment>97 </payment></record><record rec="139"><date>20220520 </date><payment>97 </payment></record><record rec="140"><date>20220620 </date><payment>97 </payment></record><record rec="141"><date>20220720 </date><payment>97 </payment></record><record rec="142"><date>20220820 </date><payment>97 </payment></record><record rec="143"><date>20220920 </date><payment>97 </payment></record><record rec="144"><date>20221020 </date><payment>97 </payment></record><record rec="145"><date>20221120 </date><payment>97 </payment></record><record rec="146"><date>20221220 </date><payment>97 </payment></record><record rec="147"><date>20230120 </date><payment>97 </payment></record><record rec="148"><date>20230220 </date><payment>97 </payment></record><record rec="149"><date>20230320 </date><payment>97 </payment></record><record rec="150"><date>20230420 </date><payment>97 </payment></record><record rec="151"><date>20230520 </date><payment>97 </payment></record><record rec="152"><date>20230620 </date><payment>97 </payment></record><record rec="153"><date>20230720 </date><payment>97 </payment></record><record rec="154"><date>20230820 </date><payment>97 </payment></record><record rec="155"><date>20230920 </date><payment>97 </payment></record><record rec="156"><date>20231020 </date><payment>97 </payment></record><record rec="157"><date>20231120 </date><payment>97 </payment></record><record rec="158"><date>20231220 </date><payment>97 </payment></record><record rec="159"><date>20240120 </date><payment>97 </payment></record><record rec="160"><date>20240220 </date><payment>97 </payment></record><record rec="161"><date>20240320 </date><payment>97 </payment></record><record rec="162"><date>20240420 </date><payment>97 </payment></record><record rec="163"><date>20240520 </date><payment>97 </payment></record><record rec="164"><date>20240620 </date><payment>97 </payment></record><record rec="165"><date>20240720 </date><payment>97 </payment></record><record rec="166"><date>20240820 </date><payment>97 </payment></record><record rec="167"><date>20240920 </date><payment>97 </payment></record><record rec="168"><date>20241020 </date><payment>97 </payment></record><record rec="169"><date>20241120 </date><payment>97 </payment></record><record rec="170"><date>20241220 </date><payment>97 </payment></record><record rec="171"><date>20250120 </date><payment>97 </payment></record><record rec="172"><date>20250220 </date><payment>97 </payment></record><record rec="173"><date>20250320 </date><payment>97 </payment></record><record rec="174"><date>20250420 </date><payment>97 </payment></record><record rec="175"><date>20250520 </date><payment>97 </payment></record><record rec="176"><date>20250620 </date><payment>97 </payment></record><record rec="177"><date>20250720 </date><payment>97 </payment></record><record rec="178"><date>20250820 </date><payment>97 </payment></record><record rec="179"><date>20250920 </date><payment>97 </payment></record><record rec="180"><date>20251020 </date><payment>97 </payment></record><record rec="181"><date>20251120 </date><payment>97 </payment></record><record rec="182"><date>20251220 </date><payment>97 </payment></record><record rec="183"><date>20260120 </date><payment>97 </payment></record><record rec="184"><date>20260220 </date><payment>97 </payment></record><record rec="185"><date>20260320 </date><payment>97 </payment></record><record rec="186"><date>20260420 </date><payment>97 </payment></record><record rec="187"><date>20260520 </date><payment>97 </payment></record><record rec="188"><date>20260620 </date><payment>97 </payment></record><record rec="189"><date>20260720 </date><payment>97 </payment></record><record rec="190"><date>20260820 </date><payment>97 </payment></record><record rec="191"><date>20260920 </date><payment>97 </payment></record><record rec="192"><date>20261020 </date><payment>97 </payment></record><record rec="193"><date>20261120 </date><payment>97 </payment></record><record rec="194"><date>20261220 </date><payment>97 </payment></record><record rec="195"><date>20270120 </date><payment>97 </payment></record><record rec="196"><date>20270220 </date><payment>97 </payment></record><record rec="197"><date>20270320 </date><payment>97 </payment></record><record rec="198"><date>20270420 </date><payment>97 </payment></record><record rec="199"><date>20270520 </date><payment>97 </payment></record><record rec="200"><date>20270620 </date><payment>97 </payment></record><record rec="201"><date>20270720 </date><payment>97 </payment></record><record rec="202"><date>20270820 </date><payment>97 </payment></record><record rec="203"><date>20270920 </date><payment>97 </payment></record><record rec="204"><date>20271020 </date><payment>97 </payment></record><record rec="205"><date>20271120 </date><payment>97 </payment></record><record rec="206"><date>20271220 </date><payment>97 </payment></record><record rec="207"><date>20280120 </date><payment>97 </payment></record><record rec="208"><date>20280220 </date><payment>97 </payment></record><record rec="209"><date>20280320 </date><payment>97 </payment></record><record rec="210"><date>20280420 </date><payment>97 </payment></record><record rec="211"><date>20280520 </date><payment>97 </payment></record><record rec="212"><date>20280620 </date><payment>97 </payment></record><record rec="213"><date>20280720 </date><payment>97 </payment></record><record rec="214"><date>20280820 </date><payment>97 </payment></record><record rec="215"><date>20280920 </date><payment>97 </payment></record><record rec="216"><date>20281020 </date><payment>97 </payment></record><record rec="217"><date>20281120 </date><payment>97 </payment></record><record rec="218"><date>20281220 </date><payment>97 </payment></record><record rec="219"><date>20290120 </date><payment>97 </payment></record><record rec="220"><date>20290220 </date><payment>97 </payment></record><record rec="221"><date>20290320 </date><payment>97 </payment></record><record rec="222"><date>20290420 </date><payment>97 </payment></record><record rec="223"><date>20290520 </date><payment>97 </payment></record><record rec="224"><date>20290620 </date><payment>97 </payment></record><record rec="225"><date>20290720 </date><payment>97 </payment></record><record rec="226"><date>20290820 </date><payment>97 </payment></record><record rec="227"><date>20290920 </date><payment>97 </payment></record><record rec="228"><date>20291020 </date><payment>97 </payment></record><record rec="229"><date>20291120 </date><payment>97 </payment></record><record rec="230"><date>20291220 </date><payment>97 </payment></record><record rec="231"><date>20300120 </date><payment>97 </payment></record><record rec="232"><date>20300220 </date><payment>97 </payment></record><record rec="233"><date>20300320 </date><payment>97 </payment></record><record rec="234"><date>20300420 </date><payment>97 </payment></record><record rec="235"><date>20300520 </date><payment>97 </payment></record><record rec="236"><date>20300620 </date><payment>97 </payment></record><record rec="237"><date>20300720 </date><payment>97 </payment></record><record rec="238"><date>20300820 </date><payment>97 </payment></record><record rec="239"><date>20300920 </date><payment>97 </payment></record><record rec="240"><date>20301020 </date><payment>97 </payment></record><record rec="241"><date>20301120 </date><payment>97 </payment></record><record rec="242"><date>20301220 </date><payment>97 </payment></record><record rec="243"><date>20310120 </date><payment>97 </payment></record><record rec="244"><date>20310220 </date><payment>97 </payment></record><record rec="245"><date>20310320 </date><payment>97 </payment></record><record rec="246"><date>20310420 </date><payment>97 </payment></record><record rec="247"><date>20310520 </date><payment>97 </payment></record><record rec="248"><date>20310620 </date><payment>97 </payment></record><record rec="249"><date>20310720 </date><payment>97 </payment></record><record rec="250"><date>20310820 </date><payment>97 </payment></record><record rec="251"><date>20310920 </date><payment>97 </payment></record><record rec="252"><date>20311020 </date><payment>97 </payment></record><record rec="253"><date>20311120 </date><payment>97 </payment></record><record rec="254"><date>20311220 </date><payment>97 </payment></record><record rec="255"><date>20320120 </date><payment>97 </payment></record><record rec="256"><date>20320220 </date><payment>97 </payment></record><record rec="257"><date>20320320 </date><payment>97 </payment></record><record rec="258"><date>20320420 </date><payment>97 </payment></record><record rec="259"><date>20320520 </date><payment>97 </payment></record><record rec="260"><date>20320620 </date><payment>97 </payment></record><record rec="261"><date>20320720 </date><payment>97 </payment></record><record rec="262"><date>20320820 </date><payment>97 </payment></record><record rec="263"><date>20320920 </date><payment>97 </payment></record><record rec="264"><date>20321020 </date><payment>97 </payment></record><record rec="265"><date>20321120 </date><payment>97 </payment></record><record rec="266"><date>20321220 </date><payment>97 </payment></record><record rec="267"><date>20330120 </date><payment>97 </payment></record><record rec="268"><date>20330220 </date><payment>97 </payment></record><record rec="269"><date>20330320 </date><payment>97 </payment></record><record rec="270"><date>20330420 </date><payment>97 </payment></record><record rec="271"><date>20330520 </date><payment>97 </payment></record><record rec="272"><date>20330620 </date><payment>97 </payment></record><record rec="273"><date>20330720 </date><payment>97 </payment></record><record rec="274"><date>20330820 </date><payment>97 </payment></record><record rec="275"><date>20330920 </date><payment>97 </payment></record><record rec="276"><date>20331020 </date><payment>97 </payment></record><record rec="277"><date>20331120 </date><payment>97 </payment></record><record rec="278"><date>20331220 </date><payment>97 </payment></record><record rec="279"><date>20340120 </date><payment>97 </payment></record><record rec="280"><date>20340220 </date><payment>97 </payment></record><record rec="281"><date>20340320 </date><payment>97 </payment></record><record rec="282"><date>20340420 </date><payment>97 </payment></record><record rec="283"><date>20340520 </date><payment>97 </payment></record><record rec="284"><date>20340620 </date><payment>97 </payment></record><record rec="285"><date>20340720 </date><payment>97 </payment></record><record rec="286"><date>20340820 </date><payment>97 </payment></record><record rec="287"><date>20340920 </date><payment>97 </payment></record><record rec="288"><date>20341020 </date><payment>97 </payment></record><record rec="289"><date>20341120 </date><payment>97 </payment></record><record rec="290"><date>20341220 </date><payment>97 </payment></record><record rec="291"><date>20350120 </date><payment>97 </payment></record><record rec="292"><date>20350220 </date><payment>97 </payment></record><record rec="293"><date>20350320 </date><payment>97 </payment></record><record rec="294"><date>20350420 </date><payment>97 </payment></record><record rec="295"><date>20350520 </date><payment>97 </payment></record><record rec="296"><date>20350620 </date><payment>97 </payment></record><record rec="297"><date>20350720 </date><payment>97 </payment></record><record rec="298"><date>20350820 </date><payment>97 </payment></record><record rec="299"><date>20350920 </date><payment>97 </payment></record><record rec="300"><date>20351020 </date><payment>97 </payment></record><record rec="301"><date>20351120 </date><payment>97 </payment></record><record rec="302"><date>20351220 </date><payment>97 </payment></record><record rec="303"><date>20360120 </date><payment>97 </payment></record><record rec="304"><date>20360220 </date><payment>97 </payment></record><record rec="305"><date>20360320 </date><payment>97 </payment></record><record rec="306"><date>20360420 </date><payment>97 </payment></record><record rec="307"><date>20360520 </date><payment>97 </payment></record><record rec="308"><date>20360620 </date><payment>97 </payment></record><record rec="309"><date>20360720 </date><payment>97 </payment></record><record rec="310"><date>20360820 </date><payment>97 </payment></record><record rec="311"><date>20360920 </date><payment>97 </payment></record><record rec="312"><date>20361020 </date><payment>97 </payment></record><record rec="313"><date>20361120 </date><payment>97 </payment></record><record rec="314"><date>20361220 </date><payment>97 </payment></record><record rec="315"><date>20370120 </date><payment>97 </payment></record><record rec="316"><date>20370220 </date><payment>97 </payment></record><record rec="317"><date>20370320 </date><payment>97 </payment></record><record rec="318"><date>20370420 </date><payment>97 </payment></record><record rec="319"><date>20370520 </date><payment>97 </payment></record><record rec="320"><date>20370620 </date><payment>97 </payment></record><record rec="321"><date>20370720 </date><payment>97 </payment></record><record rec="322"><date>20370820 </date><payment>97 </payment></record><record rec="323"><date>20370920 </date><payment>97 </payment></record><record rec="324"><date>20371020 </date><payment>97 </payment></record><record rec="325"><date>20371120 </date><payment>97 </payment></record><record rec="326"><date>20371220 </date><payment>97 </payment></record><record rec="327"><date>20380120 </date><payment>97 </payment></record><record rec="328"><date>20380220 </date><payment>97 </payment></record><record rec="329"><date>20380320 </date><payment>97 </payment></record><record rec="330"><date>20380420 </date><payment>97 </payment></record><record rec="331"><date>20380520 </date><payment>97 </payment></record><record rec="332"><date>20380620 </date><payment>97 </payment></record><record rec="333"><date>20380720 </date><payment>97 </payment></record><record rec="334"><date>20380820 </date><payment>97 </payment></record><record rec="335"><date>20380920 </date><payment>97 </payment></record><record rec="336"><date>20381020 </date><payment>97 </payment></record><record rec="337"><date>20381120 </date><payment>97 </payment></record><record rec="338"><date>20381220 </date><payment>97 </payment></record><record rec="339"><date>20390120 </date><payment>97 </payment></record><record rec="340"><date>20390220 </date><payment>97 </payment></record><record rec="341"><date>20390320 </date><payment>97 </payment></record><record rec="342"><date>20390420 </date><payment>97 </payment></record><record rec="343"><date>20390520 </date><payment>97 </payment></record><record rec="344"><date>20390620 </date><payment>97 </payment></record><record rec="345"><date>20390720 </date><payment>97 </payment></record><record rec="346"><date>20390820 </date><payment>97 </payment></record><record rec="347"><date>20390920 </date><payment>97 </payment></record><record rec="348"><date>20391020 </date><payment>97 </payment></record><record rec="349"><date>20391120 </date><payment>97 </payment></record><record rec="350"><date>20391220 </date><payment>97 </payment></record><record rec="351"><date>20400120 </date><payment>97 </payment></record><record rec="352"><date>20400220 </date><payment>97 </payment></record><record rec="353"><date>20400320 </date><payment>97 </payment></record><record rec="354"><date>20400420 </date><payment>97 </payment></record><record rec="355"><date>20400520 </date><payment>97 </payment></record><record rec="356"><date>20400620 </date><payment>97 </payment></record><record rec="357"><date>20400720 </date><payment>97 </payment></record><record rec="358"><date>20400820 </date><payment>97 </payment></record><record rec="359"><date>20400920 </date><payment>97 </payment></record><record rec="360"><date>20401020 </date><payment>97 </payment></record><record rec="361"><date>20401120 </date><payment>97 </payment></record><record rec="362"><date>20401220 </date><payment>97 </payment></record><record rec="363"><date>20410120 </date><payment>97 </payment></record><record rec="364"><date>20410220 </date><payment>97 </payment></record><record rec="365"><date>20410320 </date><payment>97 </payment></record><record rec="366"><date>20410420 </date><payment>97 </payment></record><record rec="367"><date>20410520 </date><payment>97 </payment></record><record rec="368"><date>20410620 </date><payment>97 </payment></record><record rec="369"><date>20410720 </date><payment>97 </payment></record><record rec="370"><date>20410820 </date><payment>97 </payment></record><record rec="371"><date>20410920 </date><payment>97 </payment></record><record rec="372"><date>20411020 </date><payment>97 </payment></record><record rec="373"><date>20411120 </date><payment>97 </payment></record><record rec="374"><date>20411220 </date><payment>97 </payment></record><record rec="375"><date>20420120 </date><payment>97 </payment></record><record rec="376"><date>20420220 </date><payment>97 </payment></record><record rec="377"><date>20420320 </date><payment>97 </payment></record><record rec="378"><date>20420420 </date><payment>97 </payment></record><record rec="379"><date>20420520 </date><payment>97 </payment></record><record rec="380"><date>20420620 </date><payment>97 </payment></record><record rec="381"><date>20420720 </date><payment>97 </payment></record><record rec="382"><date>20420820 </date><payment>97 </payment></record><record rec="383"><date>20420920 </date><payment>97 </payment></record><record rec="384"><date>20421020 </date><payment>97 </payment></record><record rec="385"><date>20421120 </date><payment>97 </payment></record><record rec="386"><date>20421220 </date><payment>97 </payment></record><record rec="387"><date>20430120 </date><payment>97 </payment></record><record rec="388"><date>20430220 </date><payment>97 </payment></record><record rec="389"><date>20430320 </date><payment>97 </payment></record><record rec="390"><date>20430420 </date><payment>97 </payment></record><record rec="391"><date>20430520 </date><payment>97 </payment></record><record rec="392"><date>20430620 </date><payment>97 </payment></record><record rec="393"><date>20430720 </date><payment>97 </payment></record><record rec="394"><date>20430820 </date><payment>97 </payment></record><record rec="395"><date>20430920 </date><payment>97 </payment></record><record rec="396"><date>20431020 </date><payment>97 </payment></record><record rec="397"><date>20431120 </date><payment>97 </payment></record><record rec="398"><date>20431220 </date><payment>97 </payment></record><record rec="399"><date>20440120 </date><payment>97 </payment></record><record rec="400"><date>20440220 </date><payment>97 </payment></record><record rec="401"><date>20440320 </date><payment>97 </payment></record><record rec="402"><date>20440420 </date><payment>97 </payment></record><record rec="403"><date>20440520 </date><payment>97 </payment></record><record rec="404"><date>20440620 </date><payment>97 </payment></record><record rec="405"><date>20440720 </date><payment>97 </payment></record><record rec="406"><date>20440820 </date><payment>97 </payment></record><record rec="407"><date>20440920 </date><payment>97 </payment></record><record rec="408"><date>20441020 </date><payment>97 </payment></record><record rec="409"><date>20441120 </date><payment>97 </payment></record><record rec="410"><date>20441220 </date><payment>97 </payment></record><record rec="411"><date>20450120 </date><payment>97 </payment></record><record rec="412"><date>20450220 </date><payment>97 </payment></record><record rec="413"><date>20450320 </date><payment>97 </payment></record><record rec="414"><date>20450420 </date><payment>97 </payment></record><record rec="415"><date>20450520 </date><payment>97 </payment></record><record rec="416"><date>20450620 </date><payment>97 </payment></record><record rec="417"><date>20450720 </date><payment>97 </payment></record><record rec="418"><date>20450820 </date><payment>97 </payment></record><record rec="419"><date>20450920 </date><payment>97 </payment></record><record rec="420"><date>20451020 </date><payment>97 </payment></record><record rec="421"><date>20451120 </date><payment>97 </payment></record><record rec="422"><date>20451220 </date><payment>97 </payment></record><record rec="423"><date>20460120 </date><payment>97 </payment></record><record rec="424"><date>20460220 </date><payment>97 </payment></record><record rec="425"><date>20460320 </date><payment>97 </payment></record><record rec="426"><date>20460420 </date><payment>97 </payment></record><record rec="427"><date>20460520 </date><payment>97 </payment></record><record rec="428"><date>20460620 </date><payment>97 </payment></record><record rec="429"><date>20460720 </date><payment>97 </payment></record><record rec="430"><date>20460820 </date><payment>97 </payment></record><record rec="431"><date>20460920 </date><payment>97 </payment></record><record rec="432"><date>20461020 </date><payment>97 </payment></record><record rec="433"><date>20461120 </date><payment>97 </payment></record><record rec="434"><date>20461220 </date><payment>97 </payment></record><record rec="435"><date>20470120 </date><payment>97 </payment></record><record rec="436"><date>20470220 </date><payment>97 </payment></record><record rec="437"><date>20470320 </date><payment>97 </payment></record><record rec="438"><date>20470420 </date><payment>97 </payment></record><record rec="439"><date>20470520 </date><payment>97 </payment></record><record rec="440"><date>20470620 </date><payment>97 </payment></record><record rec="441"><date>20470720 </date><payment>97 </payment></record><record rec="442"><date>20470820 </date><payment>97 </payment></record><record rec="443"><date>20470920 </date><payment>97 </payment></record><record rec="444"><date>20471020 </date><payment>97 </payment></record><record rec="445"><date>20471120 </date><payment>97 </payment></record><record rec="446"><date>20471220 </date><payment>97 </payment></record><record rec="447"><date>20480120 </date><payment>97 </payment></record><record rec="448"><date>20480220 </date><payment>97 </payment></record><record rec="449"><date>20480320 </date><payment>97 </payment></record><record rec="450"><date>20480420 </date><payment>97 </payment></record><record rec="451"><date>20480520 </date><payment>97 </payment></record><record rec="452"><date>20480620 </date><payment>97 </payment></record><record rec="453"><date>20480720 </date><payment>97 </payment></record><record rec="454"><date>20480820 </date><payment>97 </payment></record><record rec="455"><date>20480920 </date><payment>97 </payment></record><record rec="456"><date>20481020 </date><payment>97 </payment></record><record rec="457"><date>20481120 </date><payment>97 </payment></record><record rec="458"><date>20481220 </date><payment>97 </payment></record><record rec="459"><date>20490120 </date><payment>97 </payment></record><record rec="460"><date>20490220 </date><payment>97 </payment></record><record rec="461"><date>20490320 </date><payment>97 </payment></record><record rec="462"><date>20490420 </date><payment>97 </payment></record><record rec="463"><date>20490520 </date><payment>97 </payment></record><record rec="464"><date>20490620 </date><payment>97 </payment></record><record rec="465"><date>20490720 </date><payment>97 </payment></record><record rec="466"><date>20490820 </date><payment>97 </payment></record><record rec="467"><date>20490920 </date><payment>97 </payment></record><record rec="468"><date>20491020 </date><payment>97 </payment></record><record rec="469"><date>20491120 </date><payment>97 </payment></record><record rec="470"><date>20491220 </date><payment>97 </payment></record><record rec="471"><date>20500120 </date><payment>97 </payment></record><record rec="472"><date>20500220 </date><payment>97 </payment></record><record rec="473"><date>20500320 </date><payment>97 </payment></record><record rec="474"><date>20500420 </date><payment>97 </payment></record><record rec="475"><date>20500520 </date><payment>97 </payment></record><record rec="476"><date>20500620 </date><payment>97 </payment></record><record rec="477"><date>20500720 </date><payment>97 </payment></record><record rec="478"><date>20500820 </date><payment>97 </payment></record><record rec="479"><date>20500920 </date><payment>97 </payment></record><record rec="480"><date>20501020 </date><payment>97 </payment></record><record rec="481"><date>20501120 </date><payment>97 </payment></record><record rec="482"><date>20501220 </date><payment>97 </payment></record><record rec="483"><date>20510120 </date><payment>97 </payment></record><record rec="484"><date>20510220 </date><payment>97 </payment></record><record rec="485"><date>20510320 </date><payment>97 </payment></record><record rec="486"><date>20510420 </date><payment>97 </payment></record><record rec="487"><date>20510520 </date><payment>97 </payment></record><record rec="488"><date>20510620 </date><payment>97 </payment></record><record rec="489"><date>20510720 </date><payment>97 </payment></record><record rec="490"><date>20510820 </date><payment>97 </payment></record><record rec="491"><date>20510920 </date><payment>97 </payment></record><record rec="492"><date>20511020 </date><payment>97 </payment></record><record rec="493"><date>20511120 </date><payment>97 </payment></record><record rec="494"><date>20511220 </date><payment>97 </payment></record><record rec="495"><date>20520120 </date><payment>97 </payment></record><record rec="496"><date>20520220 </date><payment>97 </payment></record><record rec="497"><date>20520320 </date><payment>97 </payment></record><record rec="498"><date>20520420 </date><payment>97 </payment></record><record rec="499"><date>20520520 </date><payment>97 </payment></record><record rec="500"><date>20520620 </date><payment>97 </payment></record><record rec="501"><date>20520720 </date><payment>97 </payment></record><record rec="502"><date>20520820 </date><payment>97 </payment></record><record rec="503"><date>20520920 </date><payment>97 </payment></record><record rec="504"><date>20521020 </date><payment>97 </payment></record><record rec="505"><date>20521120 </date><payment>97 </payment></record><record rec="506"><date>20521220 </date><payment>97 </payment></record><record rec="507"><date>20530120 </date><payment>97 </payment></record><record rec="508"><date>20530220 </date><payment>97 </payment></record><record rec="509"><date>20530320 </date><payment>97 </payment></record><record rec="510"><date>20530420 </date><payment>97 </payment></record><record rec="511"><date>20530520 </date><payment>97 </payment></record><record rec="512"><date>20530620 </date><payment>97 </payment></record><record rec="513"><date>20530720 </date><payment>97 </payment></record><record rec="514"><date>20530820 </date><payment>97 </payment></record><record rec="515"><date>20530920 </date><payment>97 </payment></record><record rec="516"><date>20531020 </date><payment>97 </payment></record><record rec="517"><date>20531120 </date><payment>97 </payment></record><record rec="518"><date>20531220 </date><payment>97 </payment></record><record rec="519"><date>20540120 </date><payment>97 </payment></record><record rec="520"><date>20540220 </date><payment>97 </payment></record><record rec="521"><date>20540320 </date><payment>97 </payment></record><record rec="522"><date>20540420 </date><payment>97 </payment></record><record rec="523"><date>20540520 </date><payment>97 </payment></record><record rec="524"><date>20540620 </date><payment>97 </payment></record><record rec="525"><date>20540720 </date><payment>97 </payment></record><record rec="526"><date>20540820 </date><payment>97 </payment></record><record rec="527"><date>20540920 </date><payment>97 </payment></record><record rec="528"><date>20541020 </date><payment>97 </payment></record><record rec="529"><date>20541120 </date><payment>97 </payment></record><record rec="530"><date>20541220 </date><payment>97 </payment></record><record rec="531"><date>20550120 </date><payment>97 </payment></record><record rec="532"><date>20550220 </date><payment>97 </payment></record><record rec="533"><date>20550320 </date><payment>97 </payment></record><record rec="534"><date>20550420 </date><payment>97 </payment></record><record rec="535"><date>20550520 </date><payment>97 </payment></record><record rec="536"><date>20550620 </date><payment>97 </payment></record><record rec="537"><date>20550720 </date><payment>97 </payment></record><record rec="538"><date>20550820 </date><payment>97 </payment></record><record rec="539"><date>20550920 </date><payment>97 </payment></record><record rec="540"><date>20551020 </date><payment>97 </payment></record><record rec="541"><date>20551120 </date><payment>97 </payment></record><record rec="542"><date>20551220 </date><payment>97 </payment></record><record rec="543"><date>20560120 </date><payment>97 </payment></record><record rec="544"><date>20560220 </date><payment>97 </payment></record><record rec="545"><date>20560320 </date><payment>97 </payment></record><record rec="546"><date>20560420 </date><payment>97 </payment></record><record rec="547"><date>20560520 </date><payment>97 </payment></record><record rec="548"><date>20560620 </date><payment>97 </payment></record><record rec="549"><date>20560720 </date><payment>97 </payment></record><record rec="550"><date>20560820 </date><payment>97 </payment></record><record rec="551"><date>20560920 </date><payment>97 </payment></record><record rec="552"><date>20561020 </date><payment>97 </payment></record><record rec="553"><date>20561120 </date><payment>97 </payment></record><record rec="554"><date>20561220 </date><payment>97 </payment></record><record rec="555"><date>20570120 </date><payment>97 </payment></record><record rec="556"><date>20570220 </date><payment>97 </payment></record><record rec="557"><date>20570320 </date><payment>97 </payment></record><record rec="558"><date>20570420 </date><payment>97 </payment></record><record rec="559"><date>20570520 </date><payment>97 </payment></record><record rec="560"><date>20570620 </date><payment>97 </payment></record><record rec="561"><date>20570720 </date><payment>97 </payment></record><record rec="562"><date>20570820 </date><payment>97 </payment></record><record rec="563"><date>20570920 </date><payment>97 </payment></record><record rec="564"><date>20571020 </date><payment>97 </payment></record><record rec="565"><date>20571120 </date><payment>97 </payment></record><record rec="566"><date>20571220 </date><payment>97 </payment></record><record rec="567"><date>20580120 </date><payment>97 </payment></record><record rec="568"><date>20580220 </date><payment>97 </payment></record><record rec="569"><date>20580320 </date><payment>97 </payment></record><record rec="570"><date>20580420 </date><payment>97 </payment></record><record rec="571"><date>20580520 </date><payment>97 </payment></record><record rec="572"><date>20580620 </date><payment>97 </payment></record><record rec="573"><date>20580720 </date><payment>97 </payment></record><record rec="574"><date>20580820 </date><payment>97 </payment></record><record rec="575"><date>20580920 </date><payment>97 </payment></record><record rec="576"><date>20581020 </date><payment>97 </payment></record><record rec="577"><date>20581120 </date><payment>97 </payment></record><record rec="578"><date>20581220 </date><payment>97 </payment></record><record rec="579"><date>20590120 </date><payment>97 </payment></record><record rec="580"><date>20590220 </date><payment>97 </payment></record><record rec="581"><date>20590320 </date><payment>97 </payment></record><record rec="582"><date>20590420 </date><payment>97 </payment></record><record rec="583"><date>20590520 </date><payment>97 </payment></record><record rec="584"><date>20590620 </date><payment>97 </payment></record><record rec="585"><date>20590720 </date><payment>97 </payment></record><record rec="586"><date>20590820 </date><payment>97 </payment></record><record rec="587"><date>20590920 </date><payment>97 </payment></record><record rec="588"><date>20591020 </date><payment>97 </payment></record><record rec="589"><date>20591120 </date><payment>97 </payment></record><record rec="590"><date>20591220 </date><payment>97 </payment></record><record rec="591"><date>20600120 </date><payment>97 </payment></record><record rec="592"><date>20600220 </date><payment>97 </payment></record><record rec="593"><date>20600320 </date><payment>97 </payment></record><record rec="594"><date>20600420 </date><payment>97 </payment></record><record rec="595"><date>20600520 </date><payment>97 </payment></record><record rec="596"><date>20600620 </date><payment>97 </payment></record><record rec="597"><date>20600720 </date><payment>97 </payment></record><record rec="598"><date>20600820 </date><payment>97 </payment></record><record rec="599"><date>20600920 </date><payment>97 </payment></record><record rec="600"><date>20601020 </date><payment>97 </payment></record><record rec="601"><date>20601120 </date><payment>97 </payment></record><record rec="602"><date>20601220 </date><payment>97 </payment></record><record rec="603"><date>20610120 </date><payment>97 </payment></record><record rec="604"><date>20610220 </date><payment>97 </payment></record><record rec="605"><date>20610320 </date><payment>97 </payment></record><record rec="606"><date>20610420 </date><payment>97 </payment></record><record rec="607"><date>20610520 </date><payment>97 </payment></record><record rec="608"><date>20610620 </date><payment>97 </payment></record><record rec="609"><date>20610720 </date><payment>97 </payment></record><record rec="610"><date>20610820 </date><payment>97 </payment></record><record rec="611"><date>20610920 </date><payment>97 </payment></record><record rec="612"><date>20611020 </date><payment>97 </payment></record><record rec="613"><date>20611120 </date><payment>97 </payment></record><record rec="614"><date>20611220 </date><payment>97 </payment></record><record rec="615"><date>20620120 </date><payment>97 </payment></record><record rec="616"><date>20620220 </date><payment>97 </payment></record><record rec="617"><date>20620320 </date><payment>97 </payment></record><record rec="618"><date>20620420 </date><payment>97 </payment></record><record rec="619"><date>20620520 </date><payment>97 </payment></record><record rec="620"><date>20620620 </date><payment>97 </payment></record><record rec="621"><date>20620720 </date><payment>97 </payment></record><record rec="622"><date>20620820 </date><payment>97 </payment></record><record rec="623"><date>20620920 </date><payment>97 </payment></record><record rec="624"><date>20621020 </date><payment>97 </payment></record><record rec="625"><date>20621120 </date><payment>97 </payment></record><record rec="626"><date>20621220 </date><payment>97 </payment></record><record rec="627"><date>20630120 </date><payment>97 </payment></record><record rec="628"><date>20630220 </date><payment>97 </payment></record><record rec="629"><date>20630320 </date><payment>97 </payment></record><record rec="630"><date>20630420 </date><payment>97 </payment></record><record rec="631"><date>20630520 </date><payment>97 </payment></record><record rec="632"><date>20630620 </date><payment>97 </payment></record><record rec="633"><date>20630720 </date><payment>97 </payment></record><record rec="634"><date>20630820 </date><payment>97 </payment></record><record rec="635"><date>20630920 </date><payment>97 </payment></record><record rec="636"><date>20631020 </date><payment>97 </payment></record><record rec="637"><date>20631120 </date><payment>97 </payment></record><record rec="638"><date>20631220 </date><payment>97 </payment></record><record rec="639"><date>20640120 </date><payment>97 </payment></record><record rec="640"><date>20640220 </date><payment>97 </payment></record><record rec="641"><date>20640320 </date><payment>97 </payment></record><record rec="642"><date>20640420 </date><payment>97 </payment></record><record rec="643"><date>20640520 </date><payment>97 </payment></record><record rec="644"><date>20640620 </date><payment>97 </payment></record><record rec="645"><date>20640720 </date><payment>97 </payment></record><record rec="646"><date>20640820 </date><payment>97 </payment></record><record rec="647"><date>20640920 </date><payment>97 </payment></record><record rec="648"><date>20641020 </date><payment>97 </payment></record><record rec="649"><date>20641120 </date><payment>97 </payment></record><record rec="650"><date>20641220 </date><payment>97 </payment></record><record rec="651"><date>20650120 </date><payment>97 </payment></record><record rec="652"><date>20650220 </date><payment>97 </payment></record><record rec="653"><date>20650320 </date><payment>97 </payment></record><record rec="654"><date>20650420 </date><payment>97 </payment></record><record rec="655"><date>20650520 </date><payment>97 </payment></record><record rec="656"><date>20650620 </date><payment>97 </payment></record><record rec="657"><date>20650720 </date><payment>97 </payment></record><record rec="658"><date>20650820 </date><payment>97 </payment></record><record rec="659"><date>20650920 </date><payment>97 </payment></record><record rec="660"><date>20651020 </date><payment>97 </payment></record><record rec="661"><date>20651120 </date><payment>97 </payment></record><record rec="662"><date>20651220 </date><payment>97 </payment></record><record rec="663"><date>20660120 </date><payment>97 </payment></record><record rec="664"><date>20660220 </date><payment>97 </payment></record><record rec="665"><date>20660320 </date><payment>97 </payment></record><record rec="666"><date>20660420 </date><payment>97 </payment></record><record rec="667"><date>20660520 </date><payment>97 </payment></record><record rec="668"><date>20660620 </date><payment>97 </payment></record><record rec="669"><date>20660720 </date><payment>97 </payment></record><record rec="670"><date>20660820 </date><payment>97 </payment></record><record rec="671"><date>20660920 </date><payment>97 </payment></record><record rec="672"><date>20661020 </date><payment>97 </payment></record><record rec="673"><date>20661120 </date><payment>97 </payment></record><record rec="674"><date>20661220 </date><payment>97 </payment></record><record rec="675"><date>20670120 </date><payment>97 </payment></record><record rec="676"><date>20670220 </date><payment>97 </payment></record><record rec="677"><date>20670320 </date><payment>97 </payment></record><record rec="678"><date>20670420 </date><payment>97 </payment></record><record rec="679"><date>20670520 </date><payment>97 </payment></record><record rec="680"><date>20670620 </date><payment>97 </payment></record><record rec="681"><date>20670720 </date><payment>97 </payment></record><record rec="682"><date>20670820 </date><payment>97 </payment></record><record rec="683"><date>20670920 </date><payment>97 </payment></record><record rec="684"><date>20671020 </date><payment>97 </payment></record><record rec="685"><date>20671120 </date><payment>97 </payment></record><record rec="686"><date>20671220 </date><payment>97 </payment></record><record rec="687"><date>20680120 </date><payment>97 </payment></record><record rec="688"><date>20680220 </date><payment>97 </payment></record><record rec="689"><date>20680320 </date><payment>97 </payment></record><record rec="690"><date>20680420 </date><payment>97 </payment></record><record rec="691"><date>20680520 </date><payment>97 </payment></record><record rec="692"><date>20680620 </date><payment>97 </payment></record><record rec="693"><date>20680720 </date><payment>97 </payment></record><record rec="694"><date>20680820 </date><payment>97 </payment></record><record rec="695"><date>20680920 </date><payment>97 </payment></record><record rec="696"><date>20681020 </date><payment>97 </payment></record><record rec="697"><date>20681120 </date><payment>97 </payment></record><record rec="698"><date>20681220 </date><payment>97 </payment></record><record rec="699"><date>20690120 </date><payment>97 </payment></record><record rec="700"><date>20690220 </date><payment>97 </payment></record><record rec="701"><date>20690320 </date><payment>97 </payment></record><record rec="702"><date>20690420 </date><payment>97 </payment></record><record rec="703"><date>20690520 </date><payment>97 </payment></record><record rec="704"><date>20690620 </date><payment>97 </payment></record><record rec="705"><date>20690720 </date><payment>97 </payment></record><record rec="706"><date>20690820 </date><payment>97 </payment></record><record rec="707"><date>20690920 </date><payment>97 </payment></record><record rec="708"><date>20691020 </date><payment>97 </payment></record><record rec="709"><date>20691120 </date><payment>97 </payment></record><record rec="710"><date>20691220 </date><payment>97 </payment></record><record rec="711"><date>20700120 </date><payment>97 </payment></record><record rec="712"><date>20700220 </date><payment>97 </payment></record><record rec="713"><date>20700320 </date><payment>97 </payment></record><record rec="714"><date>20700420 </date><payment>97 </payment></record><record rec="715"><date>20700520 </date><payment>97 </payment></record><record rec="716"><date>20700620 </date><payment>97 </payment></record><record rec="717"><date>20700720 </date><payment>97 </payment></record><record rec="718"><date>20700820 </date><payment>97 </payment></record><record rec="719"><date>20700920 </date><payment>97 </payment></record><record rec="720"><date>20701020 </date><payment>97 </payment></record><record rec="721"><date>20701120 </date><payment>97 </payment></record><record rec="722"><date>20701220 </date><payment>97 </payment></record><record rec="723"><date>20710120 </date><payment>97 </payment></record><record rec="724"><date>20710220 </date><payment>97 </payment></record><record rec="725"><date>20710320 </date><payment>97 </payment></record><record rec="726"><date>20710420 </date><payment>97 </payment></record><record rec="727"><date>20710520 </date><payment>97 </payment></record><record rec="728"><date>20710620 </date><payment>97 </payment></record><record rec="729"><date>20710720 </date><payment>97 </payment></record><record rec="730"><date>20710820 </date><payment>97 </payment></record><record rec="731"><date>20710920 </date><payment>97 </payment></record><record rec="732"><date>20711020 </date><payment>97 </payment></record><record rec="733"><date>20711120 </date><payment>97 </payment></record><record rec="734"><date>20711220 </date><payment>97 </payment></record><record rec="735"><date>20720120 </date><payment>97 </payment></record><record rec="736"><date>20720220 </date><payment>97 </payment></record><record rec="737"><date>20720320 </date><payment>97 </payment></record><record rec="738"><date>20720420 </date><payment>97 </payment></record><record rec="739"><date>20720520 </date><payment>97 </payment></record><record rec="740"><date>20720620 </date><payment>97 </payment></record><record rec="741"><date>20720720 </date><payment>97 </payment></record><record rec="742"><date>20720820 </date><payment>97 </payment></record><record rec="743"><date>20720920 </date><payment>97 </payment></record><record rec="744"><date>20721020 </date><payment>97 </payment></record><record rec="745"><date>20721120 </date><payment>97 </payment></record><record rec="746"><date>20721220 </date><payment>97 </payment></record><record rec="747"><date>20730120 </date><payment>97 </payment></record><record rec="748"><date>20730220 </date><payment>97 </payment></record><record rec="749"><date>20730320 </date><payment>97 </payment></record><record rec="750"><date>20730420 </date><payment>97 </payment></record><record rec="751"><date>20730520 </date><payment>97 </payment></record><record rec="752"><date>20730620 </date><payment>97 </payment></record><record rec="753"><date>20730720 </date><payment>97 </payment></record><record rec="754"><date>20730820 </date><payment>97 </payment></record><record rec="755"><date>20730920 </date><payment>97 </payment></record><record rec="756"><date>20731020 </date><payment>97 </payment></record><record rec="757"><date>20731120 </date><payment>97 </payment></record><record rec="758"><date>20731220 </date><payment>97 </payment></record><record rec="759"><date>20740120 </date><payment>97 </payment></record><record rec="760"><date>20740220 </date><payment>97 </payment></record><record rec="761"><date>20740320 </date><payment>97 </payment></record><record rec="762"><date>20740420 </date><payment>97 </payment></record><record rec="763"><date>20740520 </date><payment>97 </payment></record><record rec="764"><date>20740620 </date><payment>97 </payment></record><record rec="765"><date>20740720 </date><payment>97 </payment></record><record rec="766"><date>20740820 </date><payment>97 </payment></record><record rec="767"><date>20740920 </date><payment>97 </payment></record><record rec="768"><date>20741020 </date><payment>97 </payment></record><record rec="769"><date>20741120 </date><payment>97 </payment></record><record rec="770"><date>20741220 </date><payment>97 </payment></record><record rec="771"><date>20750120 </date><payment>97 </payment></record><record rec="772"><date>20750220 </date><payment>97 </payment></record><record rec="773"><date>20750320 </date><payment>97 </payment></record><record rec="774"><date>20750420 </date><payment>97 </payment></record><record rec="775"><date>20750520 </date><payment>97 </payment></record><record rec="776"><date>20750620 </date><payment>97 </payment></record><record rec="777"><date>20750720 </date><payment>97 </payment></record><record rec="778"><date>20750820 </date><payment>97 </payment></record><record rec="779"><date>20750920 </date><payment>97 </payment></record><record rec="780"><date>20751020 </date><payment>97 </payment></record><record rec="781"><date>20751120 </date><payment>97 </payment></record><record rec="782"><date>20751220 </date><payment>97 </payment></record><record rec="783"><date>20760120 </date><payment>97 </payment></record><record rec="784"><date>20760220 </date><payment>97 </payment></record><record rec="785"><date>20760320 </date><payment>97 </payment></record><record rec="786"><date>20760420 </date><payment>97 </payment></record><record rec="787"><date>20760520 </date><payment>97 </payment></record><record rec="788"><date>20760620 </date><payment>97 </payment></record><record rec="789"><date>20760720 </date><payment>97 </payment></record><record rec="790"><date>20760820 </date><payment>97 </payment></record><record rec="791"><date>20760920 </date><payment>97 </payment></record><record rec="792"><date>20761020 </date><payment>97 </payment></record><record rec="793"><date>20761120 </date><payment>97 </payment></record><record rec="794"><date>20761220 </date><payment>97 </payment></record><record rec="795"><date>20770120 </date><payment>97 </payment></record><record rec="796"><date>20770220 </date><payment>97 </payment></record><record rec="797"><date>20770320 </date><payment>97 </payment></record><record rec="798"><date>20770420 </date><payment>97 </payment></record><record rec="799"><date>20770520 </date><payment>97 </payment></record><record rec="800"><date>20770620 </date><payment>97 </payment></record><record rec="801"><date>20770720 </date><payment>97 </payment></record><record rec="802"><date>20770820 </date><payment>97 </payment></record><record rec="803"><date>20770920 </date><payment>97 </payment></record><record rec="804"><date>20771020 </date><payment>97 </payment></record><record rec="805"><date>20771120 </date><payment>97 </payment></record><record rec="806"><date>20771220 </date><payment>97 </payment></record><record rec="807"><date>20780120 </date><payment>97 </payment></record><record rec="808"><date>20780220 </date><payment>97 </payment></record><record rec="809"><date>20780320 </date><payment>97 </payment></record><record rec="810"><date>20780420 </date><payment>97 </payment></record><record rec="811"><date>20780520 </date><payment>97 </payment></record><record rec="812"><date>20780620 </date><payment>97 </payment></record><record rec="813"><date>20780720 </date><payment>97 </payment></record><record rec="814"><date>20780820 </date><payment>97 </payment></record><record rec="815"><date>20780920 </date><payment>97 </payment></record><record rec="816"><date>20781020 </date><payment>97 </payment></record><record rec="817"><date>20781120 </date><payment>97 </payment></record><record rec="818"><date>20781220 </date><payment>97 </payment></record><record rec="819"><date>20790120 </date><payment>97 </payment></record><record rec="820"><date>20790220 </date><payment>97 </payment></record><record rec="821"><date>20790320 </date><payment>97 </payment></record><record rec="822"><date>20790420 </date><payment>97 </payment></record><record rec="823"><date>20790520 </date><payment>97 </payment></record><record rec="824"><date>20790620 </date><payment>97 </payment></record><record rec="825"><date>20790720 </date><payment>97 </payment></record><record rec="826"><date>20790820 </date><payment>97 </payment></record><record rec="827"><date>20790920 </date><payment>97 </payment></record><record rec="828"><date>20791020 </date><payment>97 </payment></record><record rec="829"><date>20791120 </date><payment>97 </payment></record><record rec="830"><date>20791220 </date><payment>97 </payment></record><record rec="831"><date>20800120 </date><payment>97 </payment></record><record rec="832"><date>20800220 </date><payment>97 </payment></record><record rec="833"><date>20800320 </date><payment>97 </payment></record><record rec="834"><date>20800420 </date><payment>97 </payment></record><record rec="835"><date>20800520 </date><payment>97 </payment></record><record rec="836"><date>20800620 </date><payment>97 </payment></record><record rec="837"><date>20800720 </date><payment>97 </payment></record><record rec="838"><date>20800820 </date><payment>97 </payment></record><record rec="839"><date>20800920 </date><payment>97 </payment></record><record rec="840"><date>20801020 </date><payment>97 </payment></record><record rec="841"><date>20801120 </date><payment>97 </payment></record><record rec="842"><date>20801220 </date><payment>97 </payment></record><record rec="843"><date>20810120 </date><payment>97 </payment></record><record rec="844"><date>20810220 </date><payment>97 </payment></record><record rec="845"><date>20810320 </date><payment>97 </payment></record><record rec="846"><date>20810420 </date><payment>97 </payment></record><record rec="847"><date>20810520 </date><payment>97 </payment></record><record rec="848"><date>20810620 </date><payment>97 </payment></record><record rec="849"><date>20810720 </date><payment>97 </payment></record><record rec="850"><date>20810820 </date><payment>97 </payment></record><record rec="851"><date>20810920 </date><payment>97 </payment></record><record rec="852"><date>20811020 </date><payment>97 </payment></record><record rec="853"><date>20811120 </date><payment>97 </payment></record><record rec="854"><date>20811220 </date><payment>97 </payment></record><record rec="855"><date>20820120 </date><payment>97 </payment></record><record rec="856"><date>20820220 </date><payment>97 </payment></record><record rec="857"><date>20820320 </date><payment>97 </payment></record><record rec="858"><date>20820420 </date><payment>97 </payment></record><record rec="859"><date>20820520 </date><payment>97 </payment></record><record rec="860"><date>20820620 </date><payment>97 </payment></record><record rec="861"><date>20820720 </date><payment>97 </payment></record><record rec="862"><date>20820820 </date><payment>97 </payment></record><record rec="863"><date>20820920 </date><payment>97 </payment></record><record rec="864"><date>20821020 </date><payment>97 </payment></record><record rec="865"><date>20821120 </date><payment>97 </payment></record><record rec="866"><date>20821220 </date><payment>97 </payment></record><record rec="867"><date>20830120 </date><payment>97 </payment></record><record rec="868"><date>20830220 </date><payment>97 </payment></record><record rec="869"><date>20830320 </date><payment>97 </payment></record><record rec="870"><date>20830420 </date><payment>97 </payment></record><record rec="871"><date>20830520 </date><payment>97 </payment></record><record rec="872"><date>20830620 </date><payment>97 </payment></record><record rec="873"><date>20830720 </date><payment>97 </payment></record><record rec="874"><date>20830820 </date><payment>97 </payment></record><record rec="875"><date>20830920 </date><payment>97 </payment></record><record rec="876"><date>20831020 </date><payment>97 </payment></record><record rec="877"><date>20831120 </date><payment>97 </payment></record><record rec="878"><date>20831220 </date><payment>97 </payment></record><record rec="879"><date>20840120 </date><payment>97 </payment></record><record rec="880"><date>20840220 </date><payment>97 </payment></record><record rec="881"><date>20840320 </date><payment>97 </payment></record><record rec="882"><date>20840420 </date><payment>97 </payment></record><record rec="883"><date>20840520 </date><payment>97 </payment></record><record rec="884"><date>20840620 </date><payment>97 </payment></record><record rec="885"><date>20840720 </date><payment>97 </payment></record><record rec="886"><date>20840820 </date><payment>97 </payment></record><record rec="887"><date>20840920 </date><payment>97 </payment></record><record rec="888"><date>20841020 </date><payment>97 </payment></record><record rec="889"><date>20841120 </date><payment>97 </payment></record><record rec="890"><date>20841220 </date><payment>97 </payment></record><record rec="891"><date>20850120 </date><payment>97 </payment></record><record rec="892"><date>20850220 </date><payment>97 </payment></record><record rec="893"><date>20850320 </date><payment>97 </payment></record><record rec="894"><date>20850420 </date><payment>97 </payment></record><record rec="895"><date>20850520 </date><payment>97 </payment></record><record rec="896"><date>20850620 </date><payment>97 </payment></record><record rec="897"><date>20850720 </date><payment>97 </payment></record><record rec="898"><date>20850820 </date><payment>97 </payment></record><record rec="899"><date>20850920 </date><payment>97 </payment></record><record rec="900"><date>20851020 </date><payment>97 </payment></record><record rec="901"><date>20851120 </date><payment>97 </payment></record><record rec="902"><date>20851220 </date><payment>97 </payment></record><record rec="903"><date>20860120 </date><payment>97 </payment></record><record rec="904"><date>20860220 </date><payment>97 </payment></record><record rec="905"><date>20860320 </date><payment>97 </payment></record><record rec="906"><date>20860420 </date><payment>97 </payment></record><record rec="907"><date>20860520 </date><payment>97 </payment></record><record rec="908"><date>20860620 </date><payment>97 </payment></record><record rec="909"><date>20860720 </date><payment>97 </payment></record><record rec="910"><date>20860820 </date><payment>97 </payment></record><record rec="911"><date>20860920 </date><payment>97 </payment></record><record rec="912"><date>20861020 </date><payment>97 </payment></record><record rec="913"><date>20861120 </date><payment>97 </payment></record><record rec="914"><date>20861220 </date><payment>97 </payment></record><record rec="915"><date>20870120 </date><payment>97 </payment></record><record rec="916"><date>20870220 </date><payment>97 </payment></record><record rec="917"><date>20870320 </date><payment>97 </payment></record><record rec="918"><date>20870420 </date><payment>97 </payment></record><record rec="919"><date>20870520 </date><payment>97 </payment></record><record rec="920"><date>20870620 </date><payment>97 </payment></record><record rec="921"><date>20870720 </date><payment>97 </payment></record><record rec="922"><date>20870820 </date><payment>97 </payment></record><record rec="923"><date>20870920 </date><payment>97 </payment></record><record rec="924"><date>20871020 </date><payment>97 </payment></record><record rec="925"><date>20871120 </date><payment>97 </payment></record><record rec="926"><date>20871220 </date><payment>97 </payment></record><record rec="927"><date>20880120 </date><payment>97 </payment></record><record rec="928"><date>20880220 </date><payment>97 </payment></record><record rec="929"><date>20880320 </date><payment>97 </payment></record><record rec="930"><date>20880420 </date><payment>97 </payment></record><record rec="931"><date>20880520 </date><payment>97 </payment></record><record rec="932"><date>20880620 </date><payment>97 </payment></record><record rec="933"><date>20880720 </date><payment>97 </payment></record><record rec="934"><date>20880820 </date><payment>97 </payment></record><record rec="935"><date>20880920 </date><payment>97 </payment></record><record rec="936"><date>20881020 </date><payment>97 </payment></record><record rec="937"><date>20881120 </date><payment>97 </payment></record><record rec="938"><date>20881220 </date><payment>97 </payment></record><record rec="939"><date>20890120 </date><payment>97 </payment></record><record rec="940"><date>20890220 </date><payment>97 </payment></record><record rec="941"><date>20890320 </date><payment>97 </payment></record><record rec="942"><date>20890420 </date><payment>97 </payment></record><record rec="943"><date>20890520 </date><payment>97 </payment></record><record rec="944"><date>20890620 </date><payment>97 </payment></record><record rec="945"><date>20890720 </date><payment>97 </payment></record><record rec="946"><date>20890820 </date><payment>97 </payment></record><record rec="947"><date>20890920 </date><payment>97 </payment></record><record rec="948"><date>20891020 </date><payment>97 </payment></record><record rec="949"><date>20891120 </date><payment>97 </payment></record><record rec="950"><date>20891220 </date><payment>97 </payment></record><record rec="951"><date>20900120 </date><payment>97 </payment></record><record rec="952"><date>20900220 </date><payment>97 </payment></record><record rec="953"><date>20900320 </date><payment>97 </payment></record><record rec="954"><date>20900420 </date><payment>97 </payment></record><record rec="955"><date>20900520 </date><payment>97 </payment></record><record rec="956"><date>20900620 </date><payment>97 </payment></record><record rec="957"><date>20900720 </date><payment>97 </payment></record><record rec="958"><date>20900820 </date><payment>97 </payment></record><record rec="959"><date>20900920 </date><payment>97 </payment></record><record rec="960"><date>20901020 </date><payment>97 </payment></record><record rec="961"><date>20901120 </date><payment>97 </payment></record><record rec="962"><date>20901220 </date><payment>97 </payment></record><record rec="963"><date>20910120 </date><payment>97 </payment></record><record rec="964"><date>20910220 </date><payment>97 </payment></record><record rec="965"><date>20910320 </date><payment>97 </payment></record><record rec="966"><date>20910420 </date><payment>97 </payment></record><record rec="967"><date>20910520 </date><payment>97 </payment></record><record rec="968"><date>20910620 </date><payment>97 </payment></record><record rec="969"><date>20910720 </date><payment>97 </payment></record><record rec="970"><date>20910820 </date><payment>97 </payment></record><record rec="971"><date>20910920 </date><payment>97 </payment></record><record rec="972"><date>20911020 </date><payment>97 </payment></record><record rec="973"><date>20911120 </date><payment>97 </payment></record><record rec="974"><date>20911220 </date><payment>97 </payment></record><record rec="975"><date>20920120 </date><payment>97 </payment></record><record rec="976"><date>20920220 </date><payment>97 </payment></record><record rec="977"><date>20920320 </date><payment>97 </payment></record><record rec="978"><date>20920420 </date><payment>97 </payment></record><record rec="979"><date>20920520 </date><payment>97 </payment></record><record rec="980"><date>20920620 </date><payment>97 </payment></record><record rec="981"><date>20920720 </date><payment>97 </payment></record><record rec="982"><date>20920820 </date><payment>97 </payment></record><record rec="983"><date>20920920 </date><payment>97 </payment></record><record rec="984"><date>20921020 </date><payment>97 </payment></record><record rec="985"><date>20921120 </date><payment>97 </payment></record><record rec="986"><date>20921220 </date><payment>97 </payment></record><record rec="987"><date>20930120 </date><payment>97 </payment></record><record rec="988"><date>20930220 </date><payment>97 </payment></record><record rec="989"><date>20930320 </date><payment>97 </payment></record><record rec="990"><date>20930420 </date><payment>97 </payment></record><record rec="991"><date>20930520 </date><payment>97 </payment></record><record rec="992"><date>20930620 </date><payment>97 </payment></record><record rec="993"><date>20930720 </date><payment>97 </payment></record><record rec="994"><date>20930820 </date><payment>97 </payment></record><record rec="995"><date>20930920 </date><payment>97 </payment></record><record rec="996"><date>20931020 </date><payment>97 </payment></record><record rec="997"><date>20931120 </date><payment>97 </payment></record><record rec="998"><date>20931220 </date><payment>97 </payment></record><record rec="999"><date>20940120 </date><payment>97 </payment></record><record rec="1000"><date>20940220 </date><payment>97 </payment></record><record rec="1001"><date>20940320 </date><payment>97 </payment></record><record rec="1002"><date>20940420 </date><payment>97 </payment></record><record rec="1003"><date>20940520 </date><payment>97 </payment></record><record rec="1004"><date>20940620 </date><payment>97 </payment></record><record rec="1005"><date>20940720 </date><payment>21.45 </payment></record></schedule> 

The program is like this:
If (lCounter = lNumPayments) Or (lMonth = 12) Then
WriteLineToDatabase dtWeekDate, dBalance, dIntBalance, dTotalIntAcc, dIntYTD:=dTotalYTD, dPayment:=dPayment
If lCounter = lNumPayments Then WriteTotalsToDatabase dPayment, dTotalPaid, mdMthPayment
Else
WriteLineToDatabase dtWeekDate, dBalance, dIntBalance, dTotalIntAcc, dPayment:=dPayment
End If
 
TNO: added code block
<message edited by TNO on Saturday, October 23, 2010 6:47 AM>
 
#1
    ebgreen

    • Total Posts : 8227
    • Scores: 98
    • Reward points : 0
    • Joined: 7/12/2005
    • Status: offline
    Re:XML Output is to long to Read Wednesday, October 20, 2010 3:01 AM (permalink)
    0
    Just to be clear, the code that you are using is VB not VBScript.
    "... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
    Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
    http://www.visualbasicscript.com/m_47117/tm.htm
     
    #2
      bholmstrom

      • Total Posts : 10
      • Scores: 0
      • Reward points : 0
      • Joined: 10/15/2010
      • Location: NJ
      • Status: offline
      Re:XML Output is to long to Read Wednesday, October 20, 2010 3:25 AM (permalink)
      0
      Code is in a VB form and project.
       
      #3
        bholmstrom

        • Total Posts : 10
        • Scores: 0
        • Reward points : 0
        • Joined: 10/15/2010
        • Location: NJ
        • Status: offline
        Re:XML Output is to long to Read Wednesday, October 20, 2010 4:34 AM (permalink)
        0
        After some thought, what I really need to do is just put a carriage return when the output file string gets too long........anyone with any ideas???
         
         
        #4
          ebgreen

          • Total Posts : 8227
          • Scores: 98
          • Reward points : 0
          • Joined: 7/12/2005
          • Status: offline
          Re:XML Output is to long to Read Wednesday, October 20, 2010 6:02 AM (permalink)
          0
          I suspect that we would need to see the code from the function that does the actual writing.
          "... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
          Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
          http://www.visualbasicscript.com/m_47117/tm.htm
           
          #5
            TNO

            • Total Posts : 2094
            • Scores: 36
            • Reward points : 0
            • Joined: 12/18/2004
            • Location: Earth
            • Status: offline
            Re:XML Output is to long to Read Wednesday, October 20, 2010 2:36 PM (permalink)
            0
            Why is the XML step needed at all if its being fed directly to the old database?  Could you not just have the first program send the data as it becomes available?
             
            Is the XML being used as a serialization format, or is it actually being built up into a giant DOM tree for some other purpose as well?
            To iterate is human, to recurse divine. -- L. Peter Deutsch
             
            #6
              bholmstrom

              • Total Posts : 10
              • Scores: 0
              • Reward points : 0
              • Joined: 10/15/2010
              • Location: NJ
              • Status: offline
              Re:XML Output is to long to Read Thursday, October 21, 2010 2:57 AM (permalink)
              0
              Here is the code, its only purpose is to push it out to a flat database.
                      If mbHasSchedule Then
                     
                          lRecCounter = 1
                          moRS.MoveFirst
                         
                          Do While Not moRS.EOF
                             
                              Dim oNewRec As IXMLDOMNode
                              Set oNewRec = oDocument.createNode(1, "record", "")
                              oRecNode.appendChild oNewRec
                             
                              Dim oAttrib As IXMLDOMNode
                              Set oAttrib = oDocument.createAttribute("rec")
                              oAttrib.Text = CStr(lRecCounter)
                              oNewRec.Attributes.setNamedItem oAttrib
                              Set oAttrib = Nothing
                             
                              For lCount = 1 To 2
                                  Dim oNewNode As IXMLDOMNode
                                  Set oNewNode = oDocument.createNode(1, msFieldNames(lCount), "")
                                  If msFieldNames(lCount) = "Payment" Then
                                      oNewNode.Text = Format(moRS.Fields(msFieldNames(lCount)) & " ", "########0.00")
                                  Else
                                      oNewNode.Text = moRS.Fields(msFieldNames(lCount)) & " "
                                  End If
                                  oNewRec.appendChild oNewNode
              NOTE: I think this is place for the code ????? maybe CRLF or VB Equiv ??
                              Next lCount
                             
                              moRS.MoveNext
                              lRecCounter = lRecCounter + 1
                          Loop
                         
                      End If      ' End  of mbhasSchedule
               
              #7
                TNO

                • Total Posts : 2094
                • Scores: 36
                • Reward points : 0
                • Joined: 12/18/2004
                • Location: Earth
                • Status: offline
                Re:XML Output is to long to Read Saturday, October 23, 2010 6:43 AM (permalink)
                0
                bholmstrom

                Here is the code, its only purpose is to push it out to a flat database.
                ...


                Yes, but the question is WHAT is being pushed to the database? Is it the full XML, one record element at a time, or is it the text from the XML? For instance, here is a quick blurb rewrite of your ode above in  XML LINQ (assuming this is VB.NET):

                 If mbHasSchedule Then 
                 lRecCounter = 1 
                 moRS.MoveFirst 
                 
                 Do While Not moRS.EOF 
                 Dim record As XElement = <record rec=<%= CStr(lRecCounter) %> /> 
                 Dim payment As XElement = <payment><%= Format(moRS.Fields("Payment"), "########0.00") %> </payment> 
                Dim date As XElement = <date>moRS.Fields("date") </date> 
                 
                 oRecNode.AppendChild(record) 
                 'send oRecNode to database at this point? 
                 moRS.MoveNext 
                 lRecCounter = lRecCounter + 1 
                 Loop 
                 
                 End If 

                 
                Disclaimer: Untested code
                 
                <message edited by TNO on Saturday, October 23, 2010 6:45 AM>
                To iterate is human, to recurse divine. -- L. Peter Deutsch
                 
                #8

                  Online Bookmarks Sharing: Share/Bookmark

                  Jump to:

                  Current active users

                  There are 0 members and 1 guests.

                  Icon Legend and Permission

                  • New Messages
                  • No New Messages
                  • Hot Topic w/ New Messages
                  • Hot Topic w/o New Messages
                  • Locked w/ New Messages
                  • Locked w/o New Messages
                  • Read Message
                  • Post New Thread
                  • Reply to message
                  • Post New Poll
                  • Submit Vote
                  • Post reward post
                  • Delete my own posts
                  • Delete my own threads
                  • Rate post

                  2000-2012 ASPPlayground.NET Forum Version 3.9