[RESOLVED] Basic Writing to XML

[SpyDa]

Hi everyone,

I have some data which I need to export into an XML file. The file syntax is:

<functions type="0">
  <plugin name="Astring">
     <plugindomain name="TEXT">
       <computer name="TEXT" optionstxt="TEXT" note="TEXT" /> 
       <computer name="TEXT" optionstxt="TEXT" note="TEXT" /> 
     </plugindomain>
  </plugin>
  <plugin name="Bstring">
     <plugindomain name="TEXT">
       <computer name="TEXT" optionstxt="TEXT" note="TEXT" /> 
       <computer name="TEXT" optionstxt="TEXT" note="TEXT" /> 
     </plugindomain>
  </plugin>
</functions>

The data I have is listed in an EXCEL sheet and I can loop through all the different data without problem. I just do not know how to write to XML with elements, nodes etc

The above shows two plugin sections, which will contain another child called plugindomain, under the plugindomain node I need to then add a load of computer nodes.

Is there a way to complete this? I have never used XML before progrmatically with VB2005, so any assistance is greatly received!

Thanks,

[jmcilhinney]

Using writer As XmlWriter = XmlWriter.Create("file path here")
    writer.WriteStartElement("functions")
    writer.WriteAttributeString("type", "0")
    writer.WriteStartElement("plugin")
    writer.WriteAttributeString("name", "Astring")
    writer.WriteStartElement("plugindomain")
    writer.WriteAttributeString("name", "TEXT")
    writer.WriteStartElement("computer")
    writer.WriteAttributeString("name", "TEXT")
    writer.WriteAttributeString("optionstxt", "TEXT")
    writer.WriteAttributeString("note", "TEXT")
    writer.WriteEndElement()
    writer.WriteStartElement("computer")
    writer.WriteAttributeString("name", "TEXT")
    writer.WriteAttributeString("optionstxt", "TEXT")
    writer.WriteAttributeString("note", "TEXT")
    writer.WriteEndElement()
    writer.WriteEndElement()
    writer.WriteEndElement()
    writer.WriteStartElement("plugin")
    writer.WriteAttributeString("name", "Bstring")
    writer.WriteStartElement("plugindomain")
    writer.WriteAttributeString("name", "TEXT")
    writer.WriteStartElement("computer")
    writer.WriteAttributeString("name", "TEXT")
    writer.WriteAttributeString("optionstxt", "TEXT")
    writer.WriteAttributeString("note", "TEXT")
    writer.WriteEndElement()
    writer.WriteStartElement("computer")
    writer.WriteAttributeString("name", "TEXT")
    writer.WriteAttributeString("optionstxt", "TEXT")
    writer.WriteAttributeString("note", "TEXT")
    writer.WriteEndElement()
    writer.WriteEndElement()
    writer.WriteEndElement()
    writer.WriteEndElement()
End Using

[jmcilhinney]

Just note that that code will specifically create the XML you posted. Obviously you'll need to generalise the code to handle the general case. For instance, you have multiple 'plugin' elements so you would need to use a loop to create them. You also have multiple 'computer' elements so you'd need to nest another loop to create them.

[SpyDa]

Thanks jmcilhinney!! Just what I was looking for.