We have approximately 2500 individual XML files that we need to concatenate into 1 CSV. All of the XMLs, as far as we understand, have the exact same Fields and Structure, although, of course, some of the Nodes may have multiple entries (which we would want to just concatenate into a single row/column in the CSV). We need C# Code to run on our own Machine to translate these into the CSV. There are 60 Nodes in every XML; they're all standard data types, nothing crazy.
Here is a Sample XML (had to remove about 60% to fit here):
**<?xml version="1.0" encoding="utf-8"?>
<affiliate xmlns="[login to view URL]" xmlns:xsi="[login to view URL]" xsi:schemaLocation="[login to view URL] [login to view URL]" location="[login to view URL]">
<addCode><![CDATA[CD1]]></addCode>
<email><![CDATA[test@[login to view URL]]]></email>
<status>approved</status>
<approval>Sales/Leads and Clicks</approval>
<password />
<firstName><![CDATA[Test]]></firstName>
<lastName><![CDATA[Tester]]></lastName>
<company><![CDATA[Test LLC]]></company>
<address><![CDATA[1495 Test Ave]]></address>
<address2 />
<city><![CDATA[Test]]></city>
<state><![CDATA[CA]]></state>
<zip><![CDATA[92627]]></zip>
<country><![CDATA[Uganda]]></country>
<affiliateWebsites />
<filterWebsite>0</filterWebsite>
<category1><![CDATA[CAN Offers]]></category1>
<category2 />
<category3 />
<blanketCommissions />
<watchMe>0</watchMe>
<customFields>
<customField id="1" name="Source" />
<customField id="2" name="Fax" />
</customFields>
<accessID />
</affiliate>**