Databases
StackOverflow2013
Postsdbo
POread data form xml to list
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POread data form xml to list
    primarykey
    data
    text
    <p>I have a python script that reads data from an xml file</p> <pre><code>import xml.etree.ElementTree as ET MAX_VALUE = 20 PATH_IN = "sweep.xml" tree = ET.parse(PATH_IN) root = tree.getroot() projects = [""]*MAX_VALUE designs = [""]*MAX_VALUE params = [""]*MAX_VALUE for i, project in enumerate(root): projects[i] = project print(project.get('name')) for u, design in enumerate(project): designs[u] = design print(design.get('name')) for x, param in enumerate(design): params[x] = param print(param.get('name')) for x, info in enumerate(param): print(info.text) raw_input() </code></pre> <p>Here's the xml</p> <pre><code>&lt;xml&gt; &lt;project name="testProj"&gt; &lt;design name="des1"&gt; &lt;param name="mag_d"&gt; &lt;value&gt;3mm&lt;/value&gt; &lt;start&gt;1&lt;/start&gt; &lt;stop&gt;5&lt;/stop&gt; &lt;step&gt;1&lt;/step&gt; &lt;/param&gt; &lt;param name="mag_x"&gt; &lt;value&gt;3mm&lt;/value&gt; &lt;start&gt;2&lt;/start&gt; &lt;stop&gt;7&lt;/stop&gt; &lt;step&gt;1&lt;/step&gt; &lt;/param&gt; &lt;param name="mag_y"&gt; &lt;value&gt;3mm&lt;/value&gt; &lt;start&gt;1&lt;/start&gt; &lt;stop&gt;2&lt;/stop&gt; &lt;step&gt;0.1&lt;/step&gt; &lt;/param&gt; &lt;/design&gt; &lt;design name="des2"&gt; &lt;param name="mag_d"&gt; &lt;value&gt;3mm&lt;/value&gt; &lt;start&gt;1&lt;/start&gt; &lt;stop&gt;5&lt;/stop&gt; &lt;step&gt;1&lt;/step&gt; &lt;/param&gt; &lt;param name="mag_x"&gt; &lt;value&gt;3mm&lt;/value&gt; &lt;start&gt;2&lt;/start&gt; &lt;stop&gt;7&lt;/stop&gt; &lt;step&gt;1&lt;/step&gt; &lt;/param&gt; &lt;param name="mag_y"&gt; &lt;value&gt;3mm&lt;/value&gt; &lt;start&gt;1&lt;/start&gt; &lt;stop&gt;2&lt;/stop&gt; &lt;step&gt;0.1&lt;/step&gt; &lt;/param&gt; &lt;/design&gt; &lt;/project&gt; &lt;/xml&gt; </code></pre> <p>What I want to do now is to add the information I'm reading into a list. It should look somthing like this:</p> <pre><code>Input=[['testProj','des1',[['mag_d',[1,2,3]],['mag_x',[2,3,4]]]], ['testProj','des2'[['mag_d',[1,2,3]],['mag_x',[2,3,4]]]]] </code></pre> <p>I don't really know how to create a list like that. Can someone point me in the right direction?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USYui
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COThis seems a fairly simple problem, which makes me think that you've tried something which didn't work as expected. Post your attempt to create such a list, and we'll be able to help you out much better
      singulars
      1. POread data form xml to list
      1. USinspectorG4dget
    2. COI tried to save the information in the lists projects, designs and params and use them as values to create the bigger list. Since that dind't work out quite well i've scraped that attempt
      singulars
      1. POread data form xml to list
      1. USYui
    3. COLooking at the list that you say you want, to me it doesn't look very useful in that it wouldn't be very accessible. It seems it would be better to model it as a dict or JSON document. Unless of course you've a very good reason to make it look like a list.
      singulars
      1. POread data form xml to list
      1. USsotapme
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload