title: Parse XML in python and add it to database
body: <p>I'm trying to write a Python script that will go through Rows and put them into my database</p>
  
  <p>This is a structure of my xml:</p>
  
  <pre><code>Root&gt;
      -&lt;SvcNf&gt;
          -&lt;PersonNf&gt;
              -&lt;PersonList&gt;
                  -&lt;Row&gt;
                      &lt;SysName&gt;MI6&lt;/SysName&gt;
                       &lt;ServerDt&gt;2016-10-28 03:00:12 +03:00&lt;/ServerDt&gt;
                       &lt;UID&gt;9457A55E17341AA7ASDEDS057A8BFFF3&lt;/UID&gt;
                       &lt;PersID&gt;007&lt;/PersID&gt;
                       &lt;Emp_name&gt;James Bond&lt;/Emp_name&gt;
                       &lt;EventID&gt;25&lt;/EventID&gt;
                       &lt;EventTXT&gt;Drinking alcohol&lt;/EventTXT&gt;
                       &lt;CauseEventID&gt;03&lt;/CauseEventID&gt;
                       &lt;CauseEventTXT&gt;Martini with vodka&lt;/CauseEventTXT&gt;
                       &lt;EventBegda&gt;2017-10-18&lt;/EventBegda&gt;
                       &lt;EventEndda&gt;2017-10-18&lt;/EventEndda&gt;
                       &lt;AccrualsSum&gt;171.0&lt;/AccrualsSum&gt;
                       &lt;AccrualsProz&gt;0.0&lt;/AccrualsProz&gt;
                       &lt;AccrualsName&gt;Chinees_&lt;/AccrualsName&gt;
                       &lt;OrderNum&gt;P-336&lt;/OrderNum&gt;
                       &lt;Perg&gt;0&lt;/Persg&gt;
                       &lt;Perk&gt;15&lt;/Persk&gt;
                       &lt;Awart/&gt;
                   &lt;/Row&gt;
                   -&lt;Row&gt;
                       .....
                   &lt;/Row&gt;
                  &lt;Row/&gt;
              &lt;/PersonList&gt;
          &lt;/PersonNf&gt;
      &lt;/SvcNf&gt;
  &lt;/Root&gt;
  </code></pre>
  
  <p>So, when i use this code to Parse XML:</p>
  
  <pre><code>ResultSet_Py_List = []
  
  root = ET.parse(events)
  nodes = root.findall('.//Row')
  
  for node in nodes:
      for child in node:
          ResultSet_Py_List.append(child.text)
  </code></pre>
  
  <p>The nominal Row value, which I want, is </p>
  
  <p><strong><em>['MI6', '2016-10-28 03:00:12 +03:00', '9457A55E17341AA7ASDEDS057A8BFFF3', etc]</em></strong></p>
  
  <p><strong><em>[Row2]</em></strong></p>
  
  <p><strong><em>[Row3]</em></strong></p>
  
  <p>Now, its like:
  <strong><em>[Row1,Row2,Row3]</em></strong></p>
  
  <p>[<strong>EDIT</strong>]
   All characters is like <code>&amp;#1060</code>.<br>
  To heal it:</p>
  
  <pre><code>tostring(doc.getroot(), 'unicode')
  </code></pre>
  
  <p>[<strong>EDIT</strong>]</p>
  
  <p>I used 2nd example but now i have Oracle error: ORA-01704: string literal too long.</p>