Post
Ask Question
Abraham Olatubosun

Abraham Olatubosun

  • NA
  • 471
  • 113.6k

How to write multiple XML files with nested to database

Jul 30 2018 6:41 AM
Dear Code Master
 
Blessed day to you all, and i believe the question meet you all in good health. i have a challange with my code and i really need your assistance.
 
The issue is that i develop an application that generate patient level records in XML format. some of the facilities that use the application have patient greater than 10,000.
 
Now i want to read the data below from it
 
ID
FacID
FacName
DOB
Sex
Age
ArtStartDate
ArtVisit
Nxt_App_Date
Drug_Reg
VL_Result
VL_Date
TestCode
 
i wrote the code below to see if i can read through each XML file and to get the above fields but i keep geting multiples record i thin the loops are the cause.
  1. Dim Enrol_idm As String = ""    
  2.     
  3.      Dim xMLDirectory As String = Server.MapPath(String.Format("~/{0}/", "NDRExport"))    
  4.      If Not Directory.Exists(xMLDirectory) Then    
  5.          ' Directory.CreateDirectory(xMLDirectory)    
  6.          fillClient.Show("Create NDRExport Folder before using this utility")    
  7.      End If    
  8.     
  9.      'Dim xMLName As New ArrayList    
  10.      'xMLName.Add(Directory.GetFiles(xMLDirectory, "*.xml"))    
  11.     
  12.      Dim xMLName() As String = Directory.GetFiles(xMLDirectory, "*.xml")    
  13.     
  14.      Dim ID As String = ""    
  15.      Dim FacID As String = ""    
  16.      Dim FacName As String = ""    
  17.      Dim DOB As String = ""    
  18.      Dim Sex As String = ""    
  19.      Dim Age As String = ""    
  20.      Dim AgeA As Integer    
  21.      Dim AgeP As Integer    
  22.      Dim ArtStartDate As String = ""    
  23.      Dim ArtVisit As String = ""    
  24.      Dim Nxt_App_Date As String = ""    
  25.      Dim Drug_Reg As String = ""    
  26.      Dim VL_Result As String = ""    
  27.      Dim VL_Date As String = ""    
  28.      Dim TestCode As String = ""    
  29.     
  30.      FC.Create_RADET_Table()    
  31.     
  32.      For Each _xml As String In xMLName    
  33.          Using reader As XmlReader = XmlReader.Create(_xml)    
  34.              While reader.Read()    
  35.                  Select Case reader.NodeType    
  36.                      Case XmlNodeType.Element    
  37.                          Select Case reader.Name    
  38.                              Case "PatientIdentifier"    
  39.                                  ID = reader.ReadElementContentAsString()    
  40.                                  If ID = "" Then    
  41.                                      Exit While    
  42.                                  End If    
  43.                                  'Case "FacilityName" use the textbox for facility name and id    
  44.                                  FacName = "Barau Dikko Specialist Hospital" 'reader.ReadElementContentAsString()    
  45.     
  46.                                  'Case "IDNumber"    
  47.                                  FacID = "aQTk0pRk6eY"   ' reader.ReadElementContentAsString()    
  48.                              Case "PatientDateOfBirth"    
  49.                                  DOB = reader.ReadElementContentAsString()    
  50.                              Case "PatientSexCode"    
  51.                                  Sex = reader.ReadElementContentAsString()    
  52.                              Case = "PatientAge"    
  53.                                  Age = reader.ReadElementContentAsString()    
  54.                                  If Convert.ToInt16(Age) >= 14 Then    
  55.                                      AgeA = Convert.ToInt32(Age)    
  56.                                  Else    
  57.                                      AgeP = Convert.ToInt32(Age)    
  58.                                  End If    
  59.                              Case = "ARTStartDate"    
  60.                                  ArtStartDate = reader.ReadElementContentAsString()    
  61.                              Case = "VisitDate"    
  62.                                  ArtVisit = reader.ReadElementContentAsString()    
  63.                              Case = "NextAppointmentDate"    
  64.                                  Nxt_App_Date = reader.ReadElementContentAsString()    
  65.                              Case = "CodeDescTxt"    
  66.                                  Drug_Reg = reader.ReadElementContentAsString()    
  67.                              Case = "ResultedTestDate"    
  68.                                  VL_Date = reader.ReadElementContentAsString()    
  69.                              Case = "Code"    
  70.                                  TestCode = reader.ReadElementContentAsString()    
  71.                              Case = "Value1"    
  72.                                  VL_Result = reader.ReadElementContentAsString()    
  73.     
  74.                          End Select    
  75.     
  76.                          If ID <> "" And DOB <> "" And Sex <> "" And Age <> "" Then    
  77.                              If TestCode = "80" Then    
  78.                                  FC.Process_Insert(ID, FacID, FacName, Sex, DOB, AgeA, AgeP, ArtStartDate, ArtVisit, Nxt_App_Date, Drug_Reg, "", "", VL_Result, VL_Date)    
  79.                              Else    
  80.                                  FC.Process_Insert1(ID, FacID, FacName, Sex, DOB, AgeA, AgeP, ArtStartDate, ArtVisit, Nxt_App_Date, Drug_Reg, "", "")    
  81.                              End If    
  82.                          End If
  83.                  End Select
  84.              End While
  85.          End Using
  86.      Next   
This is one of the Patient Xml file i try to read
  1. <?xml version="1.0" encoding="utf-8"?>    
  2. <Container xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">    
  3.   <MessageHeader>    
  4.     <MessageStatusCode>INITIAL</MessageStatusCode>    
  5.     <MessageCreationDateTime>2018-07-24T14:06:44.5685477</MessageCreationDateTime>    
  6.     <MessageSchemaVersion>1.2</MessageSchemaVersion>    
  7.     <MessageUniqueID> </MessageUniqueID>    
  8.     <MessageSendingOrganization>    
  9.       <FacilityName> </FacilityName>    
  10.       <FacilityID>CIHP</FacilityID>    
  11.       <FacilityTypeCode>IP</FacilityTypeCode>    
  12.     </MessageSendingOrganization>    
  13.   </MessageHeader>    
  14.   <IndividualReport>    
  15.     <PatientDemographics>    
  16.       <PatientIdentifier>5553</PatientIdentifier>    
  17.       <TreatmentFacility>    
  18.         <FacilityName> </FacilityName>    
  19.         <FacilityID> </FacilityID>    
  20.         <FacilityTypeCode>FAC</FacilityTypeCode>    
  21.       </TreatmentFacility>    
  22.       <OtherPatientIdentifiers>    
  23.         <Identifier>    
  24.           <IDNumber />    
  25.           <IDTypeCode>MR</IDTypeCode>    
  26.         </Identifier>    
  27.       </OtherPatientIdentifiers>    
  28.       <PatientDateOfBirth>1982-06-02</PatientDateOfBirth>    
  29.       <PatientSexCode>F</PatientSexCode>    
  30.       <PatientPrimaryLanguageCode>ENG</PatientPrimaryLanguageCode>    
  31.       <PatientEducationLevelCode>7</PatientEducationLevelCode>    
  32.       <PatientMaritalStatusCode>M</PatientMaritalStatusCode>    
  33.       <StateOfNigeriaOriginCode>Kaduna</StateOfNigeriaOriginCode>    
  34.       <PatientNotes>    
  35.         <Note>N/A</Note>    
  36.       </PatientNotes>    
  37.     </PatientDemographics>    
  38.     <Condition>    
  39.       <ConditionCode>86406008</ConditionCode>    
  40.       <ProgramArea>    
  41.         <ProgramAreaCode>HIV</ProgramAreaCode>    
  42.       </ProgramArea>    
  43.       <PatientAddress>    
  44.         <AddressTypeCode>H</AddressTypeCode>    
  45.         <WardVillage>U/SHAANU</WardVillage>    
  46.         <Town />    
  47.         <LGACode />    
  48.         <StateCode>23</StateCode>    
  49.         <CountryCode>NGA</CountryCode>    
  50.         <OtherAddressInformation>N01 BADARAWA RD U/SHANU</OtherAddressInformation>    
  51.       </PatientAddress>    
  52.       <CommonQuestions>    
  53.         <HospitalNumber />    
  54.         <DiagnosisFacility>    
  55.           <FacilityName> </FacilityName>    
  56.           <FacilityID> </FacilityID>    
  57.           <FacilityTypeCode>FAC</FacilityTypeCode>    
  58.         </DiagnosisFacility>    
  59.         <DateOfFirstReport>2009-07-09</DateOfFirstReport>    
  60.         <PatientAge>36</PatientAge>    
  61.       </CommonQuestions>    
  62.       <ConditionSpecificQuestions>    
  63.         <HIVQuestions>    
  64.           <CareEntryPoint>9</CareEntryPoint>    
  65.           <ARTStartDate>2009-07-09</ARTStartDate>    
  66.           <EnrolledInHIVCareDate>2009-07-09</EnrolledInHIVCareDate>    
  67.         </HIVQuestions>    
  68.       </ConditionSpecificQuestions>    
  69.       <Encounters>    
  70.         <HIVEncounter>    
  71.           <VisitID>148011</VisitID>    
  72.           <VisitDate>2010-08-05</VisitDate>    
  73.           <DurationOnArt>56</DurationOnArt>    
  74.           <Weight>49</Weight>    
  75.           <FunctionalStatus>W</FunctionalStatus>    
  76.           <WHOClinicalStage>1</WHOClinicalStage>    
  77.           <TBStatus>1</TBStatus>    
  78.           <ARVDrugRegimen>    
  79.             <Code>2d</Code>    
  80.             <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  81.           </ARVDrugRegimen>    
  82.           <NextAppointmentDate>2010-09-30</NextAppointmentDate>    
  83.         </HIVEncounter>    
  84.         <HIVEncounter>    
  85.           <VisitID>148012</VisitID>    
  86.           <VisitDate>2010-09-30</VisitDate>    
  87.           <DurationOnArt>84</DurationOnArt>    
  88.           <Weight>0</Weight>    
  89.           <FunctionalStatus>W</FunctionalStatus>    
  90.           <WHOClinicalStage>1</WHOClinicalStage>    
  91.           <TBStatus>1</TBStatus>    
  92.           <ARVDrugRegimen>    
  93.             <Code>2d</Code>    
  94.             <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  95.           </ARVDrugRegimen>    
  96.           <NextAppointmentDate>2010-12-23</NextAppointmentDate>    
  97.         </HIVEncounter>    
  98.         <HIVEncounter>    
  99.           <VisitID>148014</VisitID>    
  100.           <VisitDate>2010-12-23</VisitDate>    
  101.           <DurationOnArt>84</DurationOnArt>    
  102.           <Weight>48</Weight>    
  103.           <FunctionalStatus>W</FunctionalStatus>    
  104.           <WHOClinicalStage>1</WHOClinicalStage>    
  105.           <TBStatus>1</TBStatus>    
  106.           <ARVDrugRegimen>    
  107.             <Code>2d</Code>    
  108.             <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  109.           </ARVDrugRegimen>    
  110.           <NextAppointmentDate>2011-03-17</NextAppointmentDate>    
  111.         </HIVEncounter>    
  112.         <HIVEncounter>    
  113.           <VisitID>148015</VisitID>    
  114.           <VisitDate>2011-03-17</VisitDate>    
  115.           <DurationOnArt>63</DurationOnArt>    
  116.           <Weight>48</Weight>    
  117.           <FunctionalStatus>W</FunctionalStatus>    
  118.           <WHOClinicalStage>1</WHOClinicalStage>    
  119.           <TBStatus>1</TBStatus>    
  120.           <ARVDrugRegimen>    
  121.             <Code>2d</Code>    
  122.             <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  123.           </ARVDrugRegimen>    
  124.           <NextAppointmentDate>2011-05-19</NextAppointmentDate>    
  125.         </HIVEncounter>    
  126.         <HIVEncounter>    
  127.           <VisitID>148017</VisitID>    
  128.           <VisitDate>2011-05-19</VisitDate>    
  129.           <DurationOnArt>14</DurationOnArt>    
  130.           <Weight>0</Weight>    
  131.           <FunctionalStatus>W</FunctionalStatus>    
  132.           <WHOClinicalStage>1</WHOClinicalStage>    
  133.           <TBStatus>1</TBStatus>    
  134.           <ARVDrugRegimen>    
  135.             <Code>2d</Code>    
  136.             <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  137.           </ARVDrugRegimen>    
  138.           <NextAppointmentDate>2011-06-02</NextAppointmentDate>    
  139.         </HIVEncounter>    
  140.         <HIVEncounter>    
  141.           <VisitID>148019</VisitID>    
  142.           <VisitDate>2011-06-02</VisitDate>    
  143.           <DurationOnArt>89</DurationOnArt>    
  144.           <Weight>49</Weight>    
  145.           <FunctionalStatus>W</FunctionalStatus>    
  146.           <WHOClinicalStage>1</WHOClinicalStage>    
  147.           <TBStatus>1</TBStatus>    
  148.           <ARVDrugRegimen>    
  149.             <Code>2d</Code>    
  150.             <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  151.           </ARVDrugRegimen>    
  152.           <NextAppointmentDate>2011-08-30</NextAppointmentDate>    
  153.         </HIVEncounter>    
  154.         <HIVEncounter>    
  155.           <VisitID>148021</VisitID>    
  156.           <VisitDate>2011-09-29</VisitDate>    
  157.           <DurationOnArt>21</DurationOnArt>    
  158.           <Weight>48</Weight>    
  159.           <FunctionalStatus>W</FunctionalStatus>    
  160.           <WHOClinicalStage>1</WHOClinicalStage>    
  161.           <TBStatus>1</TBStatus>    
  162.           <ARVDrugRegimen>    
  163.             <Code>2d</Code>    
  164.             <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  165.           </ARVDrugRegimen>    
  166.           <NextAppointmentDate>2011-10-20</NextAppointmentDate>    
  167.         </HIVEncounter>    
  168.         <HIVEncounter>    
  169.           <VisitID>148023</VisitID>    
  170.           <VisitDate>2011-10-20</VisitDate>    
  171.           <DurationOnArt>90</DurationOnArt>    
  172.           <Weight>49</Weight>    
  173.           <FunctionalStatus>W</FunctionalStatus>    
  174.           <WHOClinicalStage>1</WHOClinicalStage>    
  175.           <TBStatus>1</TBStatus>    
  176.           <ARVDrugRegimen>    
  177.             <Code>2d</Code>    
  178.             <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  179.           </ARVDrugRegimen>    
  180.           <NextAppointmentDate>2012-01-19</NextAppointmentDate>    
  181.         </HIVEncounter>    
  182.         <HIVEncounter>    
  183.           <VisitID>148024</VisitID>    
  184.           <VisitDate>2012-01-19</VisitDate>    
  185.           <DurationOnArt>27</DurationOnArt>    
  186.           <Weight>54</Weight>    
  187.           <FunctionalStatus>W</FunctionalStatus>    
  188.           <WHOClinicalStage>1</WHOClinicalStage>    
  189.           <TBStatus>1</TBStatus>    
  190.           <ARVDrugRegimen>    
  191.             <Code>2d</Code>    
  192.             <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  193.           </ARVDrugRegimen>    
  194.           <NextAppointmentDate>2012-02-15</NextAppointmentDate>    
  195.         </HIVEncounter>    
  196.         <HIVEncounter>    
  197.           <VisitID>148025</VisitID>    
  198.           <VisitDate>2012-04-11</VisitDate>    
  199.           <DurationOnArt>63</DurationOnArt>    
  200.           <Weight>0</Weight>    
  201.           <FunctionalStatus>W</FunctionalStatus>    
  202.           <WHOClinicalStage>1</WHOClinicalStage>    
  203.           <TBStatus>1</TBStatus>    
  204.           <ARVDrugRegimen>    
  205.             <Code>2d</Code>    
  206.             <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  207.           </ARVDrugRegimen>    
  208.           <NextAppointmentDate>2012-06-13</NextAppointmentDate>    
  209.         </HIVEncounter>    
  210.         <HIVEncounter>    
  211.           <VisitID>148026</VisitID>    
  212.           <VisitDate>2012-06-13</VisitDate>    
  213.           <DurationOnArt>28</DurationOnArt>    
  214.           <Weight>54</Weight>    
  215.           <FunctionalStatus>W</FunctionalStatus>    
  216.           <WHOClinicalStage>1</WHOClinicalStage>    
  217.           <TBStatus>1</TBStatus>    
  218.           <ARVDrugRegimen>    
  219.             <Code>2d</Code>    
  220.             <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  221.           </ARVDrugRegimen>    
  222.           <NextAppointmentDate>2012-07-11</NextAppointmentDate>    
  223.         </HIVEncounter>    
  224.         <HIVEncounter>    
  225.           <VisitID>148028</VisitID>    
  226.           <VisitDate>2012-07-11</VisitDate>    
  227.           <DurationOnArt>61</DurationOnArt>    
  228.           <Weight>55</Weight>    
  229.           <FunctionalStatus>W</FunctionalStatus>    
  230.           <WHOClinicalStage>1</WHOClinicalStage>    
  231.           <TBStatus>1</TBStatus>    
  232.           <ARVDrugRegimen>    
  233.             <Code>2d</Code>    
  234.             <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  235.           </ARVDrugRegimen>    
  236.           <NextAppointmentDate>2012-09-10</NextAppointmentDate>    
  237.         </HIVEncounter>    
  238.         <HIVEncounter>    
  239.           <VisitID>148029</VisitID>    
  240.           <VisitDate>2012-09-10</VisitDate>    
  241.           <DurationOnArt>84</DurationOnArt>    
  242.           <Weight>51</Weight>    
  243.           <FunctionalStatus>W</FunctionalStatus>    
  244.           <WHOClinicalStage>1</WHOClinicalStage>    
  245.           <TBStatus>1</TBStatus>    
  246.           <ARVDrugRegimen>    
  247.             <Code>2d</Code>    
  248.             <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  249.           </ARVDrugRegimen>    
  250.           <NextAppointmentDate>2012-12-03</NextAppointmentDate>    
  251.         </HIVEncounter>    
  252.         <HIVEncounter>    
  253.           <VisitID>148030</VisitID>    
  254.           <VisitDate>2013-01-15</VisitDate>    
  255.           <DurationOnArt>90</DurationOnArt>    
  256.           <Weight>0</Weight>    
  257.           <FunctionalStatus>W</FunctionalStatus>    
  258.           <WHOClinicalStage>1</WHOClinicalStage>    
  259.           <TBStatus>1</TBStatus>    
  260.           <ARVDrugRegimen>    
  261.             <Code>2d</Code>    
  262.             <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  263.           </ARVDrugRegimen>    
  264.           <NextAppointmentDate>2012-02-12</NextAppointmentDate>    
  265.         </HIVEncounter>    
  266.         <HIVEncounter>    
  267.           <VisitID>148032</VisitID>    
  268.           <VisitDate>2013-02-27</VisitDate>    
  269.           <DurationOnArt>13</DurationOnArt>    
  270.           <Weight>54</Weight>    
  271.           <FunctionalStatus>W</FunctionalStatus>    
  272.           <WHOClinicalStage>1</WHOClinicalStage>    
  273.           <TBStatus>1</TBStatus>    
  274.           <ARVDrugRegimen>    
  275.             <Code>2d</Code>    
  276.             <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  277.           </ARVDrugRegimen>    
  278.           <NextAppointmentDate>2013-03-12</NextAppointmentDate>    
  279.         </HIVEncounter>    
  280.         <HIVEncounter>    
  281.           <VisitID>148033</VisitID>    
  282.           <VisitDate>2013-03-12</VisitDate>    
  283.           <DurationOnArt>28</DurationOnArt>    
  284.           <Weight>55</Weight>    
  285.           <FunctionalStatus>W</FunctionalStatus>    
  286.           <WHOClinicalStage>1</WHOClinicalStage>    
  287.           <TBStatus>1</TBStatus>    
  288.           <ARVDrugRegimen>    
  289.             <Code>2d</Code>    
  290.             <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  291.           </ARVDrugRegimen>    
  292.           <NextAppointmentDate>2013-04-09</NextAppointmentDate>    
  293.         </HIVEncounter>    
  294.         <HIVEncounter>    
  295.           <VisitID>148034</VisitID>    
  296.           <VisitDate>2013-04-09</VisitDate>    
  297.           <DurationOnArt>28</DurationOnArt>    
  298.           <Weight>55</Weight>    
  299.           <FunctionalStatus>W</FunctionalStatus>    
  300.           <WHOClinicalStage>1</WHOClinicalStage>    
  301.           <TBStatus>1</TBStatus>    
  302.           <ARVDrugRegimen>    
  303.             <Code>2d</Code>    
  304.             <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  305.           </ARVDrugRegimen>    
  306.           <NextAppointmentDate>2013-05-07</NextAppointmentDate>    
  307.         </HIVEncounter>    
  308.         <HIVEncounter>    
  309.           <VisitID>148035</VisitID>    
  310.           <VisitDate>2013-06-04</VisitDate>    
  311.           <DurationOnArt>28</DurationOnArt>    
  312.           <Weight>50</Weight>    
  313.           <FunctionalStatus>W</FunctionalStatus>    
  314.           <WHOClinicalStage>1</WHOClinicalStage>    
  315.           <TBStatus>1</TBStatus>    
  316.           <ARVDrugRegimen>    
  317.             <Code>2d</Code>    
  318.             <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  319.           </ARVDrugRegimen>    
  320.           <NextAppointmentDate>2013-07-02</NextAppointmentDate>    
  321.         </HIVEncounter>    
  322.         <HIVEncounter>    
  323.           <VisitID>148037</VisitID>    
  324.           <VisitDate>2013-08-06</VisitDate>    
  325.           <DurationOnArt>36</DurationOnArt>    
  326.           <Weight>50</Weight>    
  327.           <FunctionalStatus>W</FunctionalStatus>    
  328.           <WHOClinicalStage>1</WHOClinicalStage>    
  329.           <TBStatus>1</TBStatus>    
  330.           <ARVDrugRegimen>    
  331.             <Code>2d</Code>    
  332.             <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  333.           </ARVDrugRegimen>    
  334.           <NextAppointmentDate>2013-09-11</NextAppointmentDate>    
  335.         </HIVEncounter>    
  336.         <HIVEncounter>    
  337.           <VisitID>148038</VisitID>    
  338.           <VisitDate>2018-04-30</VisitDate>    
  339.           <DurationOnArt>90</DurationOnArt>    
  340.           <Weight>0</Weight>    
  341.           <FunctionalStatus>W</FunctionalStatus>    
  342.           <WHOClinicalStage>1</WHOClinicalStage>    
  343.           <TBStatus>1</TBStatus>    
  344.           <ARVDrugRegimen>    
  345.             <Code>2b</Code>    
  346.             <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  347.           </ARVDrugRegimen>    
  348.           <NextAppointmentDate>2018-07-30</NextAppointmentDate>    
  349.         </HIVEncounter>    
  350.         <HIVEncounter>    
  351.           <VisitID>148039</VisitID>    
  352.           <VisitDate>2018-02-26</VisitDate>    
  353.           <DurationOnArt>63</DurationOnArt>    
  354.           <Weight>60</Weight>    
  355.           <FunctionalStatus>W</FunctionalStatus>    
  356.           <WHOClinicalStage>1</WHOClinicalStage>    
  357.           <TBStatus>1</TBStatus>    
  358.           <ARVDrugRegimen>    
  359.             <Code>2b</Code>    
  360.             <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  361.           </ARVDrugRegimen>    
  362.           <NextAppointmentDate>2018-04-30</NextAppointmentDate>    
  363.         </HIVEncounter>    
  364.         <HIVEncounter>    
  365.           <VisitID>148040</VisitID>    
  366.           <VisitDate>2017-12-18</VisitDate>    
  367.           <DurationOnArt>70</DurationOnArt>    
  368.           <Weight>0</Weight>    
  369.           <FunctionalStatus>W</FunctionalStatus>    
  370.           <WHOClinicalStage>1</WHOClinicalStage>    
  371.           <TBStatus>1</TBStatus>    
  372.           <ARVDrugRegimen>    
  373.             <Code>2b</Code>    
  374.             <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  375.           </ARVDrugRegimen>    
  376.           <NextAppointmentDate>2018-02-26</NextAppointmentDate>    
  377.         </HIVEncounter>    
  378.         <HIVEncounter>    
  379.           <VisitID>148041</VisitID>    
  380.           <VisitDate>2017-08-21</VisitDate>    
  381.           <DurationOnArt>56</DurationOnArt>    
  382.           <Weight>0</Weight>    
  383.           <FunctionalStatus>W</FunctionalStatus>    
  384.           <WHOClinicalStage>1</WHOClinicalStage>    
  385.           <TBStatus>1</TBStatus>    
  386.           <ARVDrugRegimen>    
  387.             <Code>2b</Code>    
  388.             <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  389.           </ARVDrugRegimen>    
  390.           <NextAppointmentDate>2017-10-16</NextAppointmentDate>    
  391.         </HIVEncounter>    
  392.         <HIVEncounter>    
  393.           <VisitID>148042</VisitID>    
  394.           <VisitDate>2017-06-12</VisitDate>    
  395.           <DurationOnArt>70</DurationOnArt>    
  396.           <Weight>0</Weight>    
  397.           <FunctionalStatus>W</FunctionalStatus>    
  398.           <WHOClinicalStage>1</WHOClinicalStage>    
  399.           <TBStatus>1</TBStatus>    
  400.           <ARVDrugRegimen>    
  401.             <Code>2b</Code>    
  402.             <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  403.           </ARVDrugRegimen>    
  404.           <NextAppointmentDate>2017-08-21</NextAppointmentDate>    
  405.         </HIVEncounter>    
  406.         <HIVEncounter>    
  407.           <VisitID>148043</VisitID>    
  408.           <VisitDate>2017-05-27</VisitDate>    
  409.           <DurationOnArt>16</DurationOnArt>    
  410.           <Weight>0</Weight>    
  411.           <FunctionalStatus>W</FunctionalStatus>    
  412.           <WHOClinicalStage>1</WHOClinicalStage>    
  413.           <TBStatus>1</TBStatus>    
  414.           <ARVDrugRegimen>    
  415.             <Code>2b</Code>    
  416.             <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  417.           </ARVDrugRegimen>    
  418.           <NextAppointmentDate>2017-06-12</NextAppointmentDate>    
  419.         </HIVEncounter>    
  420.         <HIVEncounter>    
  421.           <VisitID>148044</VisitID>    
  422.           <VisitDate>2017-11-22</VisitDate>    
  423.           <DurationOnArt>39</DurationOnArt>    
  424.           <Weight>0</Weight>    
  425.           <FunctionalStatus>W</FunctionalStatus>    
  426.           <WHOClinicalStage>1</WHOClinicalStage>    
  427.           <TBStatus>1</TBStatus>    
  428.           <ARVDrugRegimen>    
  429.             <Code>2b</Code>    
  430.             <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  431.           </ARVDrugRegimen>    
  432.           <NextAppointmentDate>2017-12-31</NextAppointmentDate>    
  433.         </HIVEncounter>    
  434.         <HIVEncounter>    
  435.           <VisitID>148045</VisitID>    
  436.           <VisitDate>2016-09-20</VisitDate>    
  437.           <DurationOnArt>69</DurationOnArt>    
  438.           <Weight>52</Weight>    
  439.           <FunctionalStatus>W</FunctionalStatus>    
  440.           <WHOClinicalStage>1</WHOClinicalStage>    
  441.           <TBStatus>1</TBStatus>    
  442.           <ARVDrugRegimen>    
  443.             <Code>2b</Code>    
  444.             <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  445.           </ARVDrugRegimen>    
  446.           <NextAppointmentDate>2016-11-28</NextAppointmentDate>    
  447.         </HIVEncounter>    
  448.         <HIVEncounter>    
  449.           <VisitID>148046</VisitID>    
  450.           <VisitDate>2016-05-03</VisitDate>    
  451.           <DurationOnArt>70</DurationOnArt>    
  452.           <Weight>0</Weight>    
  453.           <FunctionalStatus>W</FunctionalStatus>    
  454.           <WHOClinicalStage>1</WHOClinicalStage>    
  455.           <TBStatus>1</TBStatus>    
  456.           <ARVDrugRegimen>    
  457.             <Code>2b</Code>    
  458.             <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  459.           </ARVDrugRegimen>    
  460.           <NextAppointmentDate>2016-07-12</NextAppointmentDate>    
  461.         </HIVEncounter>    
  462.         <HIVEncounter>    
  463.           <VisitID>148047</VisitID>    
  464.           <VisitDate>2016-05-03</VisitDate>    
  465.           <DurationOnArt>70</DurationOnArt>    
  466.           <Weight>0</Weight>    
  467.           <FunctionalStatus>W</FunctionalStatus>    
  468.           <WHOClinicalStage>1</WHOClinicalStage>    
  469.           <TBStatus>1</TBStatus>    
  470.           <ARVDrugRegimen>    
  471.             <Code>2b</Code>    
  472.             <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  473.           </ARVDrugRegimen>    
  474.           <NextAppointmentDate>2016-07-12</NextAppointmentDate>    
  475.         </HIVEncounter>    
  476.         <HIVEncounter>    
  477.           <VisitID>148048</VisitID>    
  478.           <VisitDate>2016-02-21</VisitDate>    
  479.           <DurationOnArt>72</DurationOnArt>    
  480.           <Weight>57</Weight>    
  481.           <FunctionalStatus>W</FunctionalStatus>    
  482.           <WHOClinicalStage>1</WHOClinicalStage>    
  483.           <TBStatus>1</TBStatus>    
  484.           <ARVDrugRegimen>    
  485.             <Code>2b</Code>    
  486.             <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  487.           </ARVDrugRegimen>    
  488.           <NextAppointmentDate>2016-05-03</NextAppointmentDate>    
  489.         </HIVEncounter>    
  490.         <HIVEncounter>    
  491.           <VisitID>148049</VisitID>    
  492.           <VisitDate>2015-12-08</VisitDate>    
  493.           <DurationOnArt>77</DurationOnArt>    
  494.           <Weight>56</Weight>    
  495.           <FunctionalStatus>W</FunctionalStatus>    
  496.           <WHOClinicalStage>1</WHOClinicalStage>    
  497.           <TBStatus>1</TBStatus>    
  498.           <ARVDrugRegimen>    
  499.             <Code>2b</Code>    
  500.             <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  501.           </ARVDrugRegimen>    
  502.           <NextAppointmentDate>2016-02-23</NextAppointmentDate>    
  503.         </HIVEncounter>    
  504.         <HIVEncounter>    
  505.           <VisitID>148050</VisitID>    
  506.           <VisitDate>2015-10-13</VisitDate>    
  507.           <DurationOnArt>56</DurationOnArt>    
  508.           <Weight>56</Weight>    
  509.           <FunctionalStatus>W</FunctionalStatus>    
  510.           <WHOClinicalStage>1</WHOClinicalStage>    
  511.           <TBStatus>1</TBStatus>    
  512.           <ARVDrugRegimen>    
  513.             <Code>2b</Code>    
  514.             <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  515.           </ARVDrugRegimen>    
  516.           <NextAppointmentDate>2015-12-08</NextAppointmentDate>    
  517.         </HIVEncounter>    
  518.         <HIVEncounter>    
  519.           <VisitID>148051</VisitID>    
  520.           <VisitDate>2015-08-04</VisitDate>    
  521.           <DurationOnArt>70</DurationOnArt>    
  522.           <Weight>0</Weight>    
  523.           <FunctionalStatus>W</FunctionalStatus>    
  524.           <WHOClinicalStage>1</WHOClinicalStage>    
  525.           <TBStatus>1</TBStatus>    
  526.           <ARVDrugRegimen>    
  527.             <Code>2b</Code>    
  528.             <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  529.           </ARVDrugRegimen>    
  530.           <NextAppointmentDate>2015-10-13</NextAppointmentDate>    
  531.         </HIVEncounter>    
  532.         <HIVEncounter>    
  533.           <VisitID>148052</VisitID>    
  534.           <VisitDate>2014-09-02</VisitDate>    
  535.           <DurationOnArt>70</DurationOnArt>    
  536.           <Weight>0</Weight>    
  537.           <FunctionalStatus>W</FunctionalStatus>    
  538.           <WHOClinicalStage>1</WHOClinicalStage>    
  539.           <TBStatus>1</TBStatus>    
  540.           <ARVDrugRegimen>    
  541.             <Code>2b</Code>    
  542.             <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  543.           </ARVDrugRegimen>    
  544.           <NextAppointmentDate>2014-11-11</NextAppointmentDate>    
  545.         </HIVEncounter>    
  546.         <HIVEncounter>    
  547.           <VisitID>148053</VisitID>    
  548.           <VisitDate>2014-07-15</VisitDate>    
  549.           <DurationOnArt>49</DurationOnArt>    
  550.           <Weight>0</Weight>    
  551.           <FunctionalStatus>W</FunctionalStatus>    
  552.           <WHOClinicalStage>1</WHOClinicalStage>    
  553.           <TBStatus>1</TBStatus>    
  554.           <ARVDrugRegimen>    
  555.             <Code>2b</Code>    
  556.             <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  557.           </ARVDrugRegimen>    
  558.           <NextAppointmentDate>2014-09-02</NextAppointmentDate>    
  559.         </HIVEncounter>    
  560.         <HIVEncounter>    
  561.           <VisitID>148054</VisitID>    
  562.           <VisitDate>2014-03-26</VisitDate>    
  563.           <DurationOnArt>55</DurationOnArt>    
  564.           <Weight>50</Weight>    
  565.           <FunctionalStatus>W</FunctionalStatus>    
  566.           <WHOClinicalStage>1</WHOClinicalStage>    
  567.           <TBStatus>1</TBStatus>    
  568.           <ARVDrugRegimen>    
  569.             <Code>2b</Code>    
  570.             <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  571.           </ARVDrugRegimen>    
  572.           <NextAppointmentDate>2014-05-20</NextAppointmentDate>    
  573.         </HIVEncounter>    
  574.         <HIVEncounter>    
  575.           <VisitID>148055</VisitID>    
  576.           <VisitDate>2014-01-29</VisitDate>    
  577.           <DurationOnArt>56</DurationOnArt>    
  578.           <Weight>0</Weight>    
  579.           <FunctionalStatus>W</FunctionalStatus>    
  580.           <WHOClinicalStage>1</WHOClinicalStage>    
  581.           <TBStatus>1</TBStatus>    
  582.           <ARVDrugRegimen>    
  583.             <Code>2b</Code>    
  584.             <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  585.           </ARVDrugRegimen>    
  586.           <NextAppointmentDate>2014-03-26</NextAppointmentDate>    
  587.         </HIVEncounter>    
  588.       </Encounters>    
  589.       <Regimen>    
  590.         <VisitID>148011</VisitID>    
  591.         <VisitDate>2010-08-05</VisitDate>    
  592.         <PrescribedRegimen>    
  593.           <Code>2d</Code>    
  594.           <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  595.         </PrescribedRegimen>    
  596.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  597.         <PrescribedRegimenDuration>56</PrescribedRegimenDuration>    
  598.         <PrescribedRegimenDispensedDate>2010-08-05</PrescribedRegimenDispensedDate>    
  599.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  600.       </Regimen>    
  601.       <Regimen>    
  602.         <VisitID>148012</VisitID>    
  603.         <VisitDate>2010-09-30</VisitDate>    
  604.         <PrescribedRegimen>    
  605.           <Code>2d</Code>    
  606.           <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  607.         </PrescribedRegimen>    
  608.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  609.         <PrescribedRegimenDuration>84</PrescribedRegimenDuration>    
  610.         <PrescribedRegimenDispensedDate>2010-09-30</PrescribedRegimenDispensedDate>    
  611.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  612.       </Regimen>    
  613.       <Regimen>    
  614.         <VisitID>148014</VisitID>    
  615.         <VisitDate>2010-12-23</VisitDate>    
  616.         <PrescribedRegimen>    
  617.           <Code>2d</Code>    
  618.           <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  619.         </PrescribedRegimen>    
  620.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  621.         <PrescribedRegimenDuration>84</PrescribedRegimenDuration>    
  622.         <PrescribedRegimenDispensedDate>2010-12-23</PrescribedRegimenDispensedDate>    
  623.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  624.       </Regimen>    
  625.       <Regimen>    
  626.         <VisitID>148015</VisitID>    
  627.         <VisitDate>2011-03-17</VisitDate>    
  628.         <PrescribedRegimen>    
  629.           <Code>2d</Code>    
  630.           <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  631.         </PrescribedRegimen>    
  632.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  633.         <PrescribedRegimenDuration>63</PrescribedRegimenDuration>    
  634.         <PrescribedRegimenDispensedDate>2011-03-17</PrescribedRegimenDispensedDate>    
  635.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  636.       </Regimen>    
  637.       <Regimen>    
  638.         <VisitID>148017</VisitID>    
  639.         <VisitDate>2011-05-19</VisitDate>    
  640.         <PrescribedRegimen>    
  641.           <Code>2d</Code>    
  642.           <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  643.         </PrescribedRegimen>    
  644.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  645.         <PrescribedRegimenDuration>14</PrescribedRegimenDuration>    
  646.         <PrescribedRegimenDispensedDate>2011-05-19</PrescribedRegimenDispensedDate>    
  647.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  648.       </Regimen>    
  649.       <Regimen>    
  650.         <VisitID>148019</VisitID>    
  651.         <VisitDate>2011-06-02</VisitDate>    
  652.         <PrescribedRegimen>    
  653.           <Code>2d</Code>    
  654.           <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  655.         </PrescribedRegimen>    
  656.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  657.         <PrescribedRegimenDuration>89</PrescribedRegimenDuration>    
  658.         <PrescribedRegimenDispensedDate>2011-06-02</PrescribedRegimenDispensedDate>    
  659.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  660.       </Regimen>    
  661.       <Regimen>    
  662.         <VisitID>148021</VisitID>    
  663.         <VisitDate>2011-09-29</VisitDate>    
  664.         <PrescribedRegimen>    
  665.           <Code>2d</Code>    
  666.           <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  667.         </PrescribedRegimen>    
  668.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  669.         <PrescribedRegimenDuration>21</PrescribedRegimenDuration>    
  670.         <PrescribedRegimenDispensedDate>2011-09-29</PrescribedRegimenDispensedDate>    
  671.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  672.       </Regimen>    
  673.       <Regimen>    
  674.         <VisitID>148023</VisitID>    
  675.         <VisitDate>2011-10-20</VisitDate>    
  676.         <PrescribedRegimen>    
  677.           <Code>2d</Code>    
  678.           <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  679.         </PrescribedRegimen>    
  680.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  681.         <PrescribedRegimenDuration>90</PrescribedRegimenDuration>    
  682.         <PrescribedRegimenDispensedDate>2011-10-20</PrescribedRegimenDispensedDate>    
  683.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  684.       </Regimen>    
  685.       <Regimen>    
  686.         <VisitID>148024</VisitID>    
  687.         <VisitDate>2012-01-19</VisitDate>    
  688.         <PrescribedRegimen>    
  689.           <Code>2d</Code>    
  690.           <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  691.         </PrescribedRegimen>    
  692.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  693.         <PrescribedRegimenDuration>27</PrescribedRegimenDuration>    
  694.         <PrescribedRegimenDispensedDate>2012-01-19</PrescribedRegimenDispensedDate>    
  695.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  696.       </Regimen>    
  697.       <Regimen>    
  698.         <VisitID>148025</VisitID>    
  699.         <VisitDate>2012-04-11</VisitDate>    
  700.         <PrescribedRegimen>    
  701.           <Code>2d</Code>    
  702.           <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  703.         </PrescribedRegimen>    
  704.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  705.         <PrescribedRegimenDuration>63</PrescribedRegimenDuration>    
  706.         <PrescribedRegimenDispensedDate>2012-04-11</PrescribedRegimenDispensedDate>    
  707.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  708.       </Regimen>    
  709.       <Regimen>    
  710.         <VisitID>148026</VisitID>    
  711.         <VisitDate>2012-06-13</VisitDate>    
  712.         <PrescribedRegimen>    
  713.           <Code>2d</Code>    
  714.           <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  715.         </PrescribedRegimen>    
  716.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  717.         <PrescribedRegimenDuration>28</PrescribedRegimenDuration>    
  718.         <PrescribedRegimenDispensedDate>2012-06-13</PrescribedRegimenDispensedDate>    
  719.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  720.       </Regimen>    
  721.       <Regimen>    
  722.         <VisitID>148028</VisitID>    
  723.         <VisitDate>2012-07-11</VisitDate>    
  724.         <PrescribedRegimen>    
  725.           <Code>2d</Code>    
  726.           <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  727.         </PrescribedRegimen>    
  728.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  729.         <PrescribedRegimenDuration>61</PrescribedRegimenDuration>    
  730.         <PrescribedRegimenDispensedDate>2012-07-11</PrescribedRegimenDispensedDate>    
  731.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  732.       </Regimen>    
  733.       <Regimen>    
  734.         <VisitID>148029</VisitID>    
  735.         <VisitDate>2012-09-10</VisitDate>    
  736.         <PrescribedRegimen>    
  737.           <Code>2d</Code>    
  738.           <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  739.         </PrescribedRegimen>    
  740.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  741.         <PrescribedRegimenDuration>84</PrescribedRegimenDuration>    
  742.         <PrescribedRegimenDispensedDate>2012-09-10</PrescribedRegimenDispensedDate>    
  743.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  744.       </Regimen>    
  745.       <Regimen>    
  746.         <VisitID>148030</VisitID>    
  747.         <VisitDate>2013-01-15</VisitDate>    
  748.         <PrescribedRegimen>    
  749.           <Code>2d</Code>    
  750.           <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  751.         </PrescribedRegimen>    
  752.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  753.         <PrescribedRegimenDuration>90</PrescribedRegimenDuration>    
  754.         <PrescribedRegimenDispensedDate>2013-01-15</PrescribedRegimenDispensedDate>    
  755.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  756.       </Regimen>    
  757.       <Regimen>    
  758.         <VisitID>148032</VisitID>    
  759.         <VisitDate>2013-02-27</VisitDate>    
  760.         <PrescribedRegimen>    
  761.           <Code>2d</Code>    
  762.           <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  763.         </PrescribedRegimen>    
  764.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  765.         <PrescribedRegimenDuration>13</PrescribedRegimenDuration>    
  766.         <PrescribedRegimenDispensedDate>2013-02-27</PrescribedRegimenDispensedDate>    
  767.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  768.       </Regimen>    
  769.       <Regimen>    
  770.         <VisitID>148033</VisitID>    
  771.         <VisitDate>2013-03-12</VisitDate>    
  772.         <PrescribedRegimen>    
  773.           <Code>2d</Code>    
  774.           <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  775.         </PrescribedRegimen>    
  776.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  777.         <PrescribedRegimenDuration>28</PrescribedRegimenDuration>    
  778.         <PrescribedRegimenDispensedDate>2013-03-12</PrescribedRegimenDispensedDate>    
  779.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  780.       </Regimen>    
  781.       <Regimen>    
  782.         <VisitID>148034</VisitID>    
  783.         <VisitDate>2013-04-09</VisitDate>    
  784.         <PrescribedRegimen>    
  785.           <Code>2d</Code>    
  786.           <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  787.         </PrescribedRegimen>    
  788.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  789.         <PrescribedRegimenDuration>28</PrescribedRegimenDuration>    
  790.         <PrescribedRegimenDispensedDate>2013-04-09</PrescribedRegimenDispensedDate>    
  791.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  792.       </Regimen>    
  793.       <Regimen>    
  794.         <VisitID>148035</VisitID>    
  795.         <VisitDate>2013-06-04</VisitDate>    
  796.         <PrescribedRegimen>    
  797.           <Code>2d</Code>    
  798.           <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  799.         </PrescribedRegimen>    
  800.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  801.         <PrescribedRegimenDuration>28</PrescribedRegimenDuration>    
  802.         <PrescribedRegimenDispensedDate>2013-06-04</PrescribedRegimenDispensedDate>    
  803.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  804.       </Regimen>    
  805.       <Regimen>    
  806.         <VisitID>148037</VisitID>    
  807.         <VisitDate>2013-08-06</VisitDate>    
  808.         <PrescribedRegimen>    
  809.           <Code>2d</Code>    
  810.           <CodeDescTxt>ABC/DDI/LPVr</CodeDescTxt>    
  811.         </PrescribedRegimen>    
  812.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  813.         <PrescribedRegimenDuration>36</PrescribedRegimenDuration>    
  814.         <PrescribedRegimenDispensedDate>2013-08-06</PrescribedRegimenDispensedDate>    
  815.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  816.       </Regimen>    
  817.       <Regimen>    
  818.         <VisitID>148038</VisitID>    
  819.         <VisitDate>2018-04-30</VisitDate>    
  820.         <PrescribedRegimen>    
  821.           <Code>2b</Code>    
  822.           <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  823.         </PrescribedRegimen>    
  824.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  825.         <PrescribedRegimenDuration>90</PrescribedRegimenDuration>    
  826.         <PrescribedRegimenDispensedDate>2018-04-30</PrescribedRegimenDispensedDate>    
  827.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  828.       </Regimen>    
  829.       <Regimen>    
  830.         <VisitID>148039</VisitID>    
  831.         <VisitDate>2018-02-26</VisitDate>    
  832.         <PrescribedRegimen>    
  833.           <Code>2b</Code>    
  834.           <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  835.         </PrescribedRegimen>    
  836.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  837.         <PrescribedRegimenDuration>63</PrescribedRegimenDuration>    
  838.         <PrescribedRegimenDispensedDate>2018-02-26</PrescribedRegimenDispensedDate>    
  839.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  840.       </Regimen>    
  841.       <Regimen>    
  842.         <VisitID>148040</VisitID>    
  843.         <VisitDate>2017-12-18</VisitDate>    
  844.         <PrescribedRegimen>    
  845.           <Code>2b</Code>    
  846.           <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  847.         </PrescribedRegimen>    
  848.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  849.         <PrescribedRegimenDuration>70</PrescribedRegimenDuration>    
  850.         <PrescribedRegimenDispensedDate>2017-12-18</PrescribedRegimenDispensedDate>    
  851.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  852.       </Regimen>    
  853.       <Regimen>    
  854.         <VisitID>148041</VisitID>    
  855.         <VisitDate>2017-08-21</VisitDate>    
  856.         <PrescribedRegimen>    
  857.           <Code>2b</Code>    
  858.           <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  859.         </PrescribedRegimen>    
  860.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  861.         <PrescribedRegimenDuration>56</PrescribedRegimenDuration>    
  862.         <PrescribedRegimenDispensedDate>2017-08-21</PrescribedRegimenDispensedDate>    
  863.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  864.       </Regimen>    
  865.       <Regimen>    
  866.         <VisitID>148042</VisitID>    
  867.         <VisitDate>2017-06-12</VisitDate>    
  868.         <PrescribedRegimen>    
  869.           <Code>2b</Code>    
  870.           <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  871.         </PrescribedRegimen>    
  872.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  873.         <PrescribedRegimenDuration>70</PrescribedRegimenDuration>    
  874.         <PrescribedRegimenDispensedDate>2017-06-12</PrescribedRegimenDispensedDate>    
  875.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  876.       </Regimen>    
  877.       <Regimen>    
  878.         <VisitID>148043</VisitID>    
  879.         <VisitDate>2017-05-27</VisitDate>    
  880.         <PrescribedRegimen>    
  881.           <Code>2b</Code>    
  882.           <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  883.         </PrescribedRegimen>    
  884.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  885.         <PrescribedRegimenDuration>16</PrescribedRegimenDuration>    
  886.         <PrescribedRegimenDispensedDate>2017-05-27</PrescribedRegimenDispensedDate>    
  887.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  888.       </Regimen>    
  889.       <Regimen>    
  890.         <VisitID>148044</VisitID>    
  891.         <VisitDate>2017-11-22</VisitDate>    
  892.         <PrescribedRegimen>    
  893.           <Code>2b</Code>    
  894.           <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  895.         </PrescribedRegimen>    
  896.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  897.         <PrescribedRegimenDuration>39</PrescribedRegimenDuration>    
  898.         <PrescribedRegimenDispensedDate>2017-11-22</PrescribedRegimenDispensedDate>    
  899.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  900.       </Regimen>    
  901.       <Regimen>    
  902.         <VisitID>148045</VisitID>    
  903.         <VisitDate>2016-09-20</VisitDate>    
  904.         <PrescribedRegimen>    
  905.           <Code>2b</Code>    
  906.           <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  907.         </PrescribedRegimen>    
  908.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  909.         <PrescribedRegimenDuration>69</PrescribedRegimenDuration>    
  910.         <PrescribedRegimenDispensedDate>2016-09-20</PrescribedRegimenDispensedDate>    
  911.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  912.       </Regimen>    
  913.       <Regimen>    
  914.         <VisitID>148046</VisitID>    
  915.         <VisitDate>2016-05-03</VisitDate>    
  916.         <PrescribedRegimen>    
  917.           <Code>2b</Code>    
  918.           <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  919.         </PrescribedRegimen>    
  920.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  921.         <PrescribedRegimenDuration>70</PrescribedRegimenDuration>    
  922.         <PrescribedRegimenDispensedDate>2016-05-03</PrescribedRegimenDispensedDate>    
  923.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  924.       </Regimen>    
  925.       <Regimen>    
  926.         <VisitID>148047</VisitID>    
  927.         <VisitDate>2016-05-03</VisitDate>    
  928.         <PrescribedRegimen>    
  929.           <Code>2b</Code>    
  930.           <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  931.         </PrescribedRegimen>    
  932.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  933.         <PrescribedRegimenDuration>70</PrescribedRegimenDuration>    
  934.         <PrescribedRegimenDispensedDate>2016-05-03</PrescribedRegimenDispensedDate>    
  935.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  936.       </Regimen>    
  937.       <Regimen>    
  938.         <VisitID>148048</VisitID>    
  939.         <VisitDate>2016-02-21</VisitDate>    
  940.         <PrescribedRegimen>    
  941.           <Code>2b</Code>    
  942.           <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  943.         </PrescribedRegimen>    
  944.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  945.         <PrescribedRegimenDuration>72</PrescribedRegimenDuration>    
  946.         <PrescribedRegimenDispensedDate>2016-02-21</PrescribedRegimenDispensedDate>    
  947.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  948.       </Regimen>    
  949.       <Regimen>    
  950.         <VisitID>148049</VisitID>    
  951.         <VisitDate>2015-12-08</VisitDate>    
  952.         <PrescribedRegimen>    
  953.           <Code>2b</Code>    
  954.           <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  955.         </PrescribedRegimen>    
  956.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  957.         <PrescribedRegimenDuration>77</PrescribedRegimenDuration>    
  958.         <PrescribedRegimenDispensedDate>2015-12-08</PrescribedRegimenDispensedDate>    
  959.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  960.       </Regimen>    
  961.       <Regimen>    
  962.         <VisitID>148050</VisitID>    
  963.         <VisitDate>2015-10-13</VisitDate>    
  964.         <PrescribedRegimen>    
  965.           <Code>2b</Code>    
  966.           <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  967.         </PrescribedRegimen>    
  968.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  969.         <PrescribedRegimenDuration>56</PrescribedRegimenDuration>    
  970.         <PrescribedRegimenDispensedDate>2015-10-13</PrescribedRegimenDispensedDate>    
  971.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  972.       </Regimen>    
  973.       <Regimen>    
  974.         <VisitID>148051</VisitID>    
  975.         <VisitDate>2015-08-04</VisitDate>    
  976.         <PrescribedRegimen>    
  977.           <Code>2b</Code>    
  978.           <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  979.         </PrescribedRegimen>    
  980.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  981.         <PrescribedRegimenDuration>70</PrescribedRegimenDuration>    
  982.         <PrescribedRegimenDispensedDate>2015-08-04</PrescribedRegimenDispensedDate>    
  983.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  984.       </Regimen>    
  985.       <Regimen>    
  986.         <VisitID>148052</VisitID>    
  987.         <VisitDate>2014-09-02</VisitDate>    
  988.         <PrescribedRegimen>    
  989.           <Code>2b</Code>    
  990.           <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  991.         </PrescribedRegimen>    
  992.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  993.         <PrescribedRegimenDuration>70</PrescribedRegimenDuration>    
  994.         <PrescribedRegimenDispensedDate>2014-09-02</PrescribedRegimenDispensedDate>    
  995.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  996.       </Regimen>    
  997.       <Regimen>    
  998.         <VisitID>148053</VisitID>    
  999.         <VisitDate>2014-07-15</VisitDate>    
  1000.         <PrescribedRegimen>    
  1001.           <Code>2b</Code>    
  1002.           <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  1003.         </PrescribedRegimen>    
  1004.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  1005.         <PrescribedRegimenDuration>49</PrescribedRegimenDuration>    
  1006.         <PrescribedRegimenDispensedDate>2014-07-15</PrescribedRegimenDispensedDate>    
  1007.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  1008.       </Regimen>    
  1009.       <Regimen>    
  1010.         <VisitID>148054</VisitID>    
  1011.         <VisitDate>2014-03-26</VisitDate>    
  1012.         <PrescribedRegimen>    
  1013.           <Code>2b</Code>    
  1014.           <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  1015.         </PrescribedRegimen>    
  1016.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  1017.         <PrescribedRegimenDuration>55</PrescribedRegimenDuration>    
  1018.         <PrescribedRegimenDispensedDate>2014-03-26</PrescribedRegimenDispensedDate>    
  1019.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  1020.       </Regimen>    
  1021.       <Regimen>    
  1022.         <VisitID>148055</VisitID>    
  1023.         <VisitDate>2014-01-29</VisitDate>    
  1024.         <PrescribedRegimen>    
  1025.           <Code>2b</Code>    
  1026.           <CodeDescTxt>ABC/FTC/LPVr</CodeDescTxt>    
  1027.         </PrescribedRegimen>    
  1028.         <PrescribedRegimenTypeCode>ART</PrescribedRegimenTypeCode>    
  1029.         <PrescribedRegimenDuration>56</PrescribedRegimenDuration>    
  1030.         <PrescribedRegimenDispensedDate>2014-01-29</PrescribedRegimenDispensedDate>    
  1031.         <DateRegimenStarted>2009-07-09</DateRegimenStarted>    
  1032.       </Regimen>    
  1033.     </Condition>    
  1034.   </IndividualReport>    
  1035. </Container>    
please help me to modify my code above to read this xml.
 
Thank you all

Answers (1)