Databases
StackOverflow2013
Postsdbo
POComparing two xmlfiles, adding missing elements
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POComparing two xmlfiles, adding missing elements
    primarykey
    data
    text
    <p>Here comes a tricky question.</p> <p>I got one file, MainFile.XML that looks like this:</p> <pre><code>&lt;xml&gt; &lt;header&gt; &lt;some&gt;&lt;/some&gt; &lt;addThis&gt;&lt;/addThis&gt; &lt;/header&gt; &lt;footer&gt;&lt;/footer&gt; &lt;this&gt; &lt;is&gt; &lt;deep&gt; &lt;like&gt;&lt;/like&gt; &lt;/deep&gt; &lt;/is&gt; &lt;/this&gt; &lt;test&gt;&lt;/test&gt; &lt;page&gt;&lt;/page&gt; &lt;addThis&gt;&lt;/addThis&gt; </code></pre> <p></p> <p>And my other file, LangFile.XML looks like this.</p> <pre><code>&lt;xml&gt; &lt;header&gt; &lt;some&gt;English file&lt;/some&gt; &lt;/header&gt; &lt;footer&gt;Footer&lt;/footer&gt; &lt;this&gt; &lt;is&gt; &lt;deep&gt; &lt;like&gt;Hey&lt;/like&gt; &lt;/deep&gt; &lt;/is&gt; &lt;/this&gt; &lt;test&gt;Something&lt;/test&gt; &lt;/xml&gt; </code></pre> <p>I want to update my LangFile.XML so that it matches my MainFile.XML but I need to keep all Text values in the LangFile. </p> <p>I want the LangFile to look like this after an update: <strong>EXPECTED OUTPUT</strong></p> <pre><code>&lt;xml&gt; &lt;header&gt; &lt;some&gt;English file&lt;/some&gt; &lt;addThis&gt;&lt;/addThis&gt; &lt;/header&gt; &lt;footer&gt;Footer&lt;/footer&gt; &lt;this&gt; &lt;is&gt; &lt;deep&gt; &lt;like&gt;Hey&lt;/like&gt; &lt;/deep&gt; &lt;/is&gt; &lt;/this&gt; &lt;test&gt;Something&lt;/test&gt; &lt;page&gt;&lt;/page&gt; &lt;addThis&gt;&lt;/addThis&gt; &lt;/xml&gt; </code></pre> <p>I've looked at this answer but I need to update the file and keep the values... <a href="https://stackoverflow.com/questions/14370070/compare-two-text-files-line-by-line">Compare two text files line by line</a></p> <p>The tricky part is the nesting, it can be anything between 1 level up to X levels deep...</p> <p>My problem is that I dont know how to compare the rows row by row when going deeper in the tree, I've tried something like this but im stuck... I dont know how to add the specific descendant to the new list.</p> <pre><code>String directory = @"C:\Utv\XmlTest"; var mainFile = XDocument.Load(Path.Combine(directory, "MainFile.XML")); var langFile = XDocument.Load(Path.Combine(directory, "LangFile.XML")); //Get all descendant nodes var mainFileDesc = mainFile.Root.Descendants().ToList(); var langFileDesc = langFile.Root.Descendants().ToList(); //Loop through the mainfile for(var i = 0; i &lt; mainFileDesc.Count(); i++) { var mainRow = mainFileDesc[i]; var langRow = langFileDesc[i]; //Compare the rows descendants, if not the same, add the mainRow to the langRow if(mainRow.Descendants().Count() != langRow.Descendants().Count()) { //Here I want to check if the mainRow != the langRow //if not, add the mainRow to the langFile list if(mainRow != langRow) { langFileDesc.Insert(i, mainRow); } } } </code></pre> <p>Im getting the following error now: </p> <pre><code>var langRow = langFileDesc[i]; Message Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index </code></pre> <p>That's because the lists doesn't have the same length, that's why I need to add it to the list...</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USJOSEFtw
    plurals
    1. PL
      singulars
      1. LTLinked
    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. VO
      singulars
      1. POComparing two xmlfiles, adding missing elements
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHow many items can there be? How much nesting? Any ID values? Whhat if when 2 text values are diffeent?
      singulars
      1. POComparing two xmlfiles, adding missing elements
      1. USHenk Holterman
    2. COThe mainfile will never have any text values. The nesting is flexible, it can be anything between 1 -1000 levels...
      singulars
      1. POComparing two xmlfiles, adding missing elements
      1. USJOSEFtw
    3. CO1000 levels? You should NOT be using XML there, and you're probably looking at a recursive solution here.
      singulars
      1. POComparing two xmlfiles, adding missing elements
      1. USIt'sNotALie.
 

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