Databases
StackOverflow2013
Postsdbo
POHow to get specific attributes from all xml files in directory?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to get specific attributes from all xml files in directory?
    primarykey
    data
    text
    <p>I have a folder full of xml files. In these files many of them share a common attribute (Name), but have a secondary attribute that is different. I want to get a list of the unique entries based off reading these xml files. Below is an example of what the various xml files will contain.</p> <p><strong>File 1</strong></p> <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;results date="2013-12-29"&gt; &lt;A uniqueId="1234" Name="My-Machine"/&gt; &lt;error number="555"&gt; &lt;description&gt;&lt;![CDATA[House on Fire]]&gt;&lt;/description&gt; &lt;/error&gt; &lt;/results&gt; </code></pre> <p><strong>File 2</strong></p> <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;results date="2013-12-29"&gt; &lt;A uniqueId="1234" Name="My-Machine"/&gt; &lt;error number="556"&gt; &lt;description&gt;&lt;![CDATA[House in flood]]&gt;&lt;/description&gt; &lt;/error&gt; &lt;/results&gt; </code></pre> <p><strong>File 3</strong></p> <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;results date="2013-12-29"&gt; &lt;A uniqueId="1234" Name="My-Machine"/&gt; &lt;error number="556"&gt; &lt;description&gt;&lt;![CDATA[House in flood]]&gt;&lt;/description&gt; &lt;/error&gt; &lt;/results&gt; </code></pre> <p>I need to be able to read all the files, add each Name and description to a list (or possibly array). Output from example would look like this:</p> <pre><code>Name="MyMachine", description="![CDATA[House is flooding]]"; Name="MyMachine", description="![CDATA[House on fire]]"; Name="MyMachine", description="![CDATA[House on fire]]"; </code></pre> <p>It seems LINQ may be the best way to handle this since the files are very small in content.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMarcinJuraszek
    1. USFuzz Evans
    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
    1. This table or related slice is empty.
    1. COLINQ is convenient, but it's not recommendable if you expect these files to be big. LINQ parses the entire xml file at once. You can use `XmlReader` instead to read them sequentially... To me, you are asking at least two different questions at once right now: how to read the files in, and how to process their contents. The answer to the latter depends on the former.
      singulars
      1. POHow to get specific attributes from all xml files in directory?
      1. USKonrad Morawski
    2. COThe files will not be big (the example is roughly the size of the actual files) except that there may be thousands of xml files. Would LINQ then be ill advised due to this? I might be asking multiple questions at once, if for no other reason than I don't know enough about reading xml to ask it simply enough.
      singulars
      1. POHow to get specific attributes from all xml files in directory?
      1. USFuzz Evans
    3. COLINQ will be fine here. Your question is definitely asking a lot. I might post up an answer with pieces of a complete solution but I probably won't write the whole thing. You need to iterate over every file in the dir reading them one by one and adding all the name-description pairs to a list. After that you can use LINQ's group by function to group by name (and produce counts).
      singulars
      1. POHow to get specific attributes from all xml files in directory?
      1. USevanmcdonnal
 

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