🚀 go-pugleaf

Hello,

I have a CSV file which I need to convert to XML, in a particular
format. It has been suggested that I use a XML template. I have never
used a template before, nor have I used XML before - great start, eh?

I have been given a sample XML and it seems that a part of the CSV will
need to be place into multiple <ITEM> </ITEM> section.

I know that in the future different CSVs files will be required to
created different XML structures, I would like some [generic] code to
take an template XML and populate the XML before sending it on, based on
the CSV definition.




For example (simplified but does cover what I need to do) :


If the header of the CSV is:

  memberid, sell1, sell2, sell3, buy1, buy2, buy3

the XML will need to be something like:

<account>
  <identifier>[memberid]</identifier>
</account>
<instructions>
  <instruction>
    <type>sell</type>
    <items>
      <item>
        <code>[sell1]</code>
      </item>
      <item>
        <code>[sell2]</code>
      </item>
      <item>
        <code>[sell3]</code>
      </item>
    </items>
  <instruction>
  <instruction>
    <type>buy</type>
    <items>
      <item>
        <code>[buy1]</code>
      </item>
      <item>
        <code>[buy2]</code>
      </item>
      <item>
        <code>[buy3]</code>
      </item>
    </items>
  <instruction>
</instructions>

Where the fields in [] are from the CSV


Any starting points, clues, components, URLs, anything...?

Many thanks in advance,
Nick

--