Hi,

 I am having a very similar problem, except it's slightly more complicated. I need to check the attribute value before deciding what to do with the inner text. I am converting a large xml file (100,000 lines) to a csv file, except i'm struggling with the custom attributes section - see below:

<product product-id="048002347">
    <display-name>Cotton crew-neck printed T-shirt</display-name>
    <long-description>Superdry cotton short-sleeved T-shirt with Osaka 6 print emblazoned across chest.</long-description>
    <online-flag>false</online-flag>
    <available-flag>true</available-flag>
    <searchable-flag>true</searchable-flag>
    <tax-class-id>default</tax-class-id>
    <brand>Superdry</brand>
    <manufacturer-name>Superdry</manufacturer-name>
    <custom-attributes>
      <custom-attribute attribute-id="Calendar Event">N/A</custom-attribute>
      <custom-attribute attribute-id="Care Instructions">Machine Wash 30°C</custom-attribute>
      <custom-attribute attribute-id="Colour">Black</custom-attribute>
      <custom-attribute attribute-id="Cuff Type">N/A</custom-attribute>
      <custom-attribute attribute-id="Exclusive">N/A</custom-attribute>
      <custom-attribute attribute-id="Fabric">Cotton</custom-attribute>
      <custom-attribute attribute-id="Fair Trade">N/A</custom-attribute>
      <custom-attribute attribute-id="Gender">Men</custom-attribute>
      <custom-attribute attribute-id="Guarantee">N/A</custom-attribute>
      <custom-attribute attribute-id="House of Fraser Magazine">No</custom-attribute>
      <custom-attribute attribute-id="Organic">No</custom-attribute>
      <custom-attribute attribute-id="Parent Colour">Black</custom-attribute>
      <custom-attribute attribute-id="Parent Style">TOPS</custom-attribute>
      <custom-attribute attribute-id="Range">PRE-SEASON/TRANSITIONAL</custom-attribute>
      <custom-attribute attribute-id="Recycled">N/A</custom-attribute>
      <custom-attribute attribute-id="Size">XL</custom-attribute>
      <custom-attribute attribute-id="Style">TOP- T-SHIRT</custom-attribute>
      <custom-attribute attribute-id="Television Line">No</custom-attribute>
      <custom-attribute attribute-id="Web Supply Lane">iForce Deliveries</custom-attribute>
      <custom-attribute attribute-id="qosListID">QOS1</custom-attribute>
      <custom-attribute attribute-id="sellByUnit">false</custom-attribute>
      <custom-attribute attribute-id="COMPOSITION">100% Cotton</custom-attribute>
    </custom-attributes>
  </product>

What I need to do is first check for the attribute-id value, i.e.

 
XmlNodeList attributeList = n.SelectNodes("custom-attributes/custom-attribute");
string calendar = "null";
foreach (XmlNode a in attributeList)
{
   if (a.Attributes["attribute-id"].Value == "Calendar Event") 
   { 
       calendar = a.InnerText; 
   }              
}
 

And then assign it the inner value if it exists, else leave the string as null. Now all that's happening is the string is returned as nul every single time.

I am using a textwriter to write the data to a textfile, so a shortened version of the code (with everything required for this purpose is below)

 
int id = 0;

            string CSVFile = "HOFProds.txt";
            TextWriter tw = new StreamWriter(CSVFile);
            tw.WriteLine("id|product-id|ean|display-name|long-description|online-flag|available-flag|" +
                "searchable-flag|tax-class-id|brand|manufacturer-name|Calendar Event|Care Instructions|Colour|" +
                "Cuff Type|Exclusive|Fabric|Fair Trade|Gender|Guarantee|House of Fraser Magazine|Organic|Parent Colour|" +
                "Parent Style|Range|Recycled|Size|Style|Television Line|Web Supply Lane|qosListID|sellByUnit|COMPOSITION|" +
                "PrimaryImage|SecondaryImage1|SecondaryImage2|Sizing|Finish|Material|Skin Type|Animal Tested|" +
                "WEIGHT|UnitMeasure|UnitQty|UnitQtyPrd|SecondaryImage3|SecondaryImage4|SecondaryImage5");

            XmlDocument hofProds = new XmlDocument();
            hofProds.Load("StagingHofCatalog.xml");

            XmlNodeList productList = null;
            productList = hofProds.GetElementsByTagName("product");

            foreach (XmlNode n in productList)
            {
                id = id + 1;
                string ean = "null";
                string displayName = "null";
                string longDescription = "null";
                string onlineFlag = "null";
                string availableFlag = "null";
                string searchableFlag = "null";
                string taxClass = "null";
                string brand = "null";
                string manufacturerName = "null";

                if (n["ean"] != null) { ean = n["ean"].InnerText; }

                if (n["display-name"] != null) { displayName = n["display-name"].InnerText; }

                if (n["long-description"] != null) { longDescription = n["long-description"].InnerText; }

                if (n["online-flag"] != null) { onlineFlag = n["online-flag"].InnerText; }

                if (n["available-flag"] != null) { availableFlag = n["available-flag"].InnerText; }

                if (n["searchable-flag"] != null) { searchableFlag = n["searchable-flag"].InnerText; }

                if (n["tax-class-id"] != null) { taxClass = n["tax-class-id"].InnerText; }

                if (n["brand"] != null) { brand = n["brand"].InnerText; }

                if (n["manufacturer-name"] != null) { manufacturerName = n["manufacturer-name"].InnerText; }

                string calendar = "null"; string care = "null"; string colour = "null"; string cuff = "null"; string exclusive = "null";
                string fabric = "null"; string fairtrade = "null"; string gender = "null"; string guarantee = "null";
                string hofmagazine = "null"; string organic = "null";
                string parentColour = "null"; string parentStyle = "null"; string range = "null"; string recycled = "null";
                string size = "null"; string style = "null"; string tvLine = "null"; string webSupplyLane = "null"; string qosListID = "null";
                string sellByUnit = "null";
                string composition = "null"; string primaryImage = "null"; string SecondaryImage1 = "null"; string SecondaryImage2 = "null"; string Sizing = "null";
                string Finish = "null"; string Material = "null"; string SkinType = "null"; string AnimalTested = "null";
                string WEIGHT = "null"; string UnitMeasure = "null"; string UnitQty = "null"; string UnitQtyPrd = "null";
                string SecondaryImage3 = "null"; string SecondaryImage4 = "null"; string SecondaryImage5 = "null";

                XmlNodeList attributeList = n.SelectNodes("custom-attributes/custom-attribute");
                foreach (XmlNode a in attributeList)
                {
                    if (a.Attributes["attribute-id"].Value == "Calendar Event") { calendar = a.InnerText; }
                }

                tw.WriteLine(id + "|" + n.Attributes["product-id"].Value + "|" + ean + "|" + displayName + "|" +
                    longDescription + "|" + onlineFlag + "|" +
                    availableFlag + "|" + searchableFlag + "|" +
                    taxClass + "|" + brand + "|" +
                    manufacturerName + "|" + calendar + "|" + care + "|" + colour + "|" + cuff + "|" + exclusive + "|" + fabric + "|" +
                    fairtrade + "|" + gender + "|" + guarantee + "|" + hofmagazine + "|" + organic + "|" + parentColour + "|" +
                    parentStyle + "|" + range + "|" + recycled + "|" + size + "|" + style + "|" + tvLine + "|" +
                    webSupplyLane + "|" + qosListID + "|" + sellByUnit + "|" + composition + "|" +
                    primaryImage + "|" + SecondaryImage1 + "|" + SecondaryImage2 + "|" + Sizing + "|" +
                    Finish + "|" + Material + "|" + SkinType + "|" + AnimalTested + "|" + WEIGHT + "|" + UnitMeasure + "|" +
                    UnitQty + "|" + UnitQtyPrd + "|" + SecondaryImage3 + "|" + SecondaryImage4 + "|" + SecondaryImage5);
            }
            tw.Close();
 

 Just to clarify that before we get to the custom-attributes section, the program works fine because the data is output correctly. It's only when I get to analyzing the custom-attributes section that does the data become construed.

I have tried to use a separate node list and insert the attributes that way except this doesn't have no binding or sequence then as sometimes the attributes may not exist, this is why i have to allow for them all and check them, if they are there then insert them, if not then insert null.

 Hopefully I have been clear,

Many thanks for any help in advance,

ChanandCo