Urgent Opion wanted.

[Don Grover]

I have this xml file provided by a supplier, and although it validates I
think it is wrong.
I need to find out if it is wrong and get them to correct it
The 2001 - 2005 are field names I thing they are putting them in the wrong
place and should be in replace of the <name> tag if so where should the
values go ?.
I would appreciate a xml guru looking at this and commenting as may need as
i said to get them to do it properly.
Regards Don
<?xml version="1.0" encoding="UTF-8"?>
<methodResponse>
<params>
<param>
<value><struct>
<member><name>0</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN99i</string></value>
</member>
<member><name>2002</name>
<value><string>30380</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/29/2003 10:25:30</string></value>
</member>
<member><name>2010</name>
<value><string>29103cci</string></value>
</member>
<member><name>2011</name>
<value><string>29103cci</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>29103cci</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>1</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN103Wi</string></value>
</member>
<member><name>2002</name>
<value><string>30190</string></value>
</member>
<member><name>2003</name>
<value><string>04.64.A </string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/16/2003 13:54:06</string></value>
</member>
<member><name>2010</name>
<value><string>16103iCC</string></value>
</member>
<member><name>2011</name>
<value><string>16103iCC</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>16103iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>2</name>
<value><struct>
<member><name>2001</name>
<value><string>CCS57i</string></value>
</member>
<member><name>2002</name>
<value><string>10000948</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>10/03/2003 13:46:54</string></value>
</member>
<member><name>2009</name>
<value><string>10/03/2003 13:46:54</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>3103iCC</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>3103iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>3</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN120i</string></value>
</member>
<member><name>2002</name>
<value><string>10000950</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>10/07/2003 09:26:21</string></value>
</member>
<member><name>2009</name>
<value><string>10/07/2003 09:26:21</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>61033CC</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>61033CC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>4</name>
<value><struct>
<member><name>2001</name>
<value><string>CCS69i</string></value>
</member>
<member><name>2002</name>
<value><string>10000942</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2009</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>5</name>
<value><struct>
<member><name>2001</name>
<value><string>CCS69i</string></value>
</member>
<member><name>2002</name>
<value><string>10000943</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2009</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>6</name>
<value><struct>
<member><name>2001</name>
<value><string>CCS69i</string></value>
</member>
<member><name>2002</name>
<value><string>10000944</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2009</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>7</name>
<value><struct>
<member><name>2001</name>
<value><string>6020i</string></value>
</member>
<member><name>2002</name>
<value><string>30350</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value>/value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/26/2003 11:26:51</string></value>
</member>
<member><name>2010</name>
<value><string>24103i</string></value>
</member>
<member><name>2011</name>
<value><string>6020i</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>24103i</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>8</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN118i</string></value>
</member>
<member><name>2002</name>
<value><string>30170</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/14/2003 09:57:39</string></value>
</member>
<member><name>2010</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2011</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>9</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN119i</string></value>
</member>
<member><name>2002</name>
<value><string>30160</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/14/2003 09:57:39</string></value>
</member>
<member><name>2010</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2011</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>10</name>
<value><struct>
<member><name>2001</name>
<value><string>6014i</string></value>
</member>
<member><name>2002</name>
<value><string>30290</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 16:09:12</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi3</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi3</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi3</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>11</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN102Wi</string></value>
</member>
<member><name>2002</name>
<value><string>30200</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 10:21:04</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi1</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi1</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi1</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>12</name>
<value><struct>
<member><name>2001</name>
<value><string>CCG16i</string></value>
</member>
<member><name>2002</name>
<value><string>30210</string></value>
</member>
<member><name>2003</name>
<value><string>04.60.A</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 10:38:39</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>13</name>
<value><struct>
<member><name>2001</name>
<value><string>CCG16i</string></value>
</member>
<member><name>2002</name>
<value><string>30220</string></value>
</member>
<member><name>2003</name>
<value><string>04.61.A</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 10:38:39</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>14</name>
<value><struct>
<member><name>2001</name>
<value><string>CCG17i</string></value>
</member>
<member><name>2002</name>
<value><string>30230</string></value>
</member>
<member><name>2003</name>
<value><string>04.62.A</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 10:38:39</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
</struct></value>
</param>
</params>
</methodResponse>

[Scott Mohekey]

That xml document is a method response of the xmlrpc protocol, as such
it is not likely that you will be able to get them to change it.

The name element defines the name of that member of the structure, where
as the value element defines the value of that member.

Don Grover wrote:

I have this xml file provided by a supplier, and although it validates I
think it is wrong.
I need to find out if it is wrong and get them to correct it
The 2001 - 2005 are field names I thing they are putting them in the wrong
place and should be in replace of the <name> tag if so where should the
values go ?.
I would appreciate a xml guru looking at this and commenting as may need as
i said to get them to do it properly.
Regards Don
<?xml version="1.0" encoding="UTF-8"?>
<methodResponse>
<params>
<param>
<value><struct>
<member><name>0</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN99i</string></value>
</member>
<member><name>2002</name>
<value><string>30380</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/29/2003 10:25:30</string></value>
</member>
<member><name>2010</name>
<value><string>29103cci</string></value>
</member>
<member><name>2011</name>
<value><string>29103cci</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>29103cci</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>1</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN103Wi</string></value>
</member>
<member><name>2002</name>
<value><string>30190</string></value>
</member>
<member><name>2003</name>
<value><string>04.64.A </string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/16/2003 13:54:06</string></value>
</member>
<member><name>2010</name>
<value><string>16103iCC</string></value>
</member>
<member><name>2011</name>
<value><string>16103iCC</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>16103iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>2</name>
<value><struct>
<member><name>2001</name>
<value><string>CCS57i</string></value>
</member>
<member><name>2002</name>
<value><string>10000948</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>10/03/2003 13:46:54</string></value>
</member>
<member><name>2009</name>
<value><string>10/03/2003 13:46:54</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>3103iCC</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>3103iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>3</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN120i</string></value>
</member>
<member><name>2002</name>
<value><string>10000950</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>10/07/2003 09:26:21</string></value>
</member>
<member><name>2009</name>
<value><string>10/07/2003 09:26:21</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>61033CC</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>61033CC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>4</name>
<value><struct>
<member><name>2001</name>
<value><string>CCS69i</string></value>
</member>
<member><name>2002</name>
<value><string>10000942</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2009</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>5</name>
<value><struct>
<member><name>2001</name>
<value><string>CCS69i</string></value>
</member>
<member><name>2002</name>
<value><string>10000943</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2009</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>6</name>
<value><struct>
<member><name>2001</name>
<value><string>CCS69i</string></value>
</member>
<member><name>2002</name>
<value><string>10000944</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2009</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>7</name>
<value><struct>
<member><name>2001</name>
<value><string>6020i</string></value>
</member>
<member><name>2002</name>
<value><string>30350</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNGS</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/26/2003 11:26:51</string></value>
</member>
<member><name>2010</name>
<value><string>24103i</string></value>
</member>
<member><name>2011</name>
<value><string>6020i</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>24103i</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>8</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN118i</string></value>
</member>
<member><name>2002</name>
<value><string>30170</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/14/2003 09:57:39</string></value>
</member>
<member><name>2010</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2011</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>9</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN119i</string></value>
</member>
<member><name>2002</name>
<value><string>30160</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/14/2003 09:57:39</string></value>
</member>
<member><name>2010</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2011</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>10</name>
<value><struct>
<member><name>2001</name>
<value><string>6014i</string></value>
</member>
<member><name>2002</name>
<value><string>30290</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 16:09:12</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi3</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi3</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi3</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>11</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN102Wi</string></value>
</member>
<member><name>2002</name>
<value><string>30200</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 10:21:04</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi1</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi1</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi1</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>12</name>
<value><struct>
<member><name>2001</name>
<value><string>CCG16i</string></value>
</member>
<member><name>2002</name>
<value><string>30210</string></value>
</member>
<member><name>2003</name>
<value><string>04.60.A</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 10:38:39</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>13</name>
<value><struct>
<member><name>2001</name>
<value><string>CCG16i</string></value>
</member>
<member><name>2002</name>
<value><string>30220</string></value>
</member>
<member><name>2003</name>
<value><string>04.61.A</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 10:38:39</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>14</name>
<value><struct>
<member><name>2001</name>
<value><string>CCG17i</string></value>
</member>
<member><name>2002</name>
<value><string>30230</string></value>
</member>
<member><name>2003</name>
<value><string>04.62.A</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 10:38:39</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
</struct></value>
</param>
</params>
</methodResponse>

[Don Grover]

Thanks Scott
But I need to get this into sql server using vbscript if possibel, Do you
know how I can achieve this.
Any help would be most appreciated.
Don

"Scott Mohekey" <sm********@SPAMinsightful.co.nz> wrote in message
news:3f******@news.iconz.co.nz...

That xml document is a method response of the xmlrpc protocol, as such
it is not likely that you will be able to get them to change it.

The name element defines the name of that member of the structure, where
as the value element defines the value of that member.

Don Grover wrote:

I have this xml file provided by a supplier, and although it validates I
think it is wrong.
I need to find out if it is wrong and get them to correct it
The 2001 - 2005 are field names I thing they are putting them in the wrong place and should be in replace of the <name> tag if so where should the
values go ?.
I would appreciate a xml guru looking at this and commenting as may need as i said to get them to do it properly.
Regards Don
<?xml version="1.0" encoding="UTF-8"?>
<methodResponse>
<params>
<param>
<value><struct>
<member><name>0</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN99i</string></value>
</member>
<member><name>2002</name>
<value><string>30380</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/29/2003 10:25:30</string></value>
</member>
<member><name>2010</name>
<value><string>29103cci</string></value>
</member>
<member><name>2011</name>
<value><string>29103cci</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>29103cci</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>1</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN103Wi</string></value>
</member>
<member><name>2002</name>
<value><string>30190</string></value>
</member>
<member><name>2003</name>
<value><string>04.64.A </string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/16/2003 13:54:06</string></value>
</member>
<member><name>2010</name>
<value><string>16103iCC</string></value>
</member>
<member><name>2011</name>
<value><string>16103iCC</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>16103iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>2</name>
<value><struct>
<member><name>2001</name>
<value><string>CCS57i</string></value>
</member>
<member><name>2002</name>
<value><string>10000948</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>10/03/2003 13:46:54</string></value>
</member>
<member><name>2009</name>
<value><string>10/03/2003 13:46:54</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>3103iCC</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>3103iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>3</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN120i</string></value>
</member>
<member><name>2002</name>
<value><string>10000950</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>10/07/2003 09:26:21</string></value>
</member>
<member><name>2009</name>
<value><string>10/07/2003 09:26:21</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>61033CC</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>61033CC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>4</name>
<value><struct>
<member><name>2001</name>
<value><string>CCS69i</string></value>
</member>
<member><name>2002</name>
<value><string>10000942</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2009</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>5</name>
<value><struct>
<member><name>2001</name>
<value><string>CCS69i</string></value>
</member>
<member><name>2002</name>
<value><string>10000943</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2009</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>6</name>
<value><struct>
<member><name>2001</name>
<value><string>CCS69i</string></value>
</member>
<member><name>2002</name>
<value><string>10000944</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2009</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>7</name>
<value><struct>
<member><name>2001</name>
<value><string>6020i</string></value>
</member>
<member><name>2002</name>
<value><string>30350</string></value>
</member>
<member><name>2003</nam>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/26/2003 11:26:51</string></value>
</member>
<member><name>2010</name>
<value><string>24103i</string></value>
</member>
<member><name>2011</name>
<value><string>6020i</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>24103i</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>8</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN118i</string></value>
</member>
<member><name>2002</name>
<value><string>30170</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/14/2003 09:57:39</string></value>
</member>
<member><name>2010</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2011</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>9</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN119i</string></value>
</member>
<member><name>2002</name>
<value><string>30160</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/14/2003 09:57:39</string></value>
</member>
<member><name>2010</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2011</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>10</name>
<value><struct>
<member><name>2001</name>
<value><string>6014i</string></value>
</member>
<member><name>2002</name>
<value><string>30290</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 16:09:12</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi3</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi3</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi3</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>11</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN102Wi</string></value>
</member>
<member><name>2002</name>
<value><string>30200</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 10:21:04</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi1</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi1</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi1</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>12</name>
<value><struct>
<member><name>2001</name>
<value><string>CCG16i</string></value>
</member>
<member><name>2002</name>
<value><string>30210</string></value>
</member>
<member><name>2003</name>
<value><string>04.60.A</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 10:38:39</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>13</name>
<value><struct>
<member><name>2001</name>
<value><string>CCG16i</string></value>
</member>
<member><name>2002</name>
<value><string>30220</string></value>
</member>
<member><name>2003</name>
<value><string>04.61.A</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 10:38:39</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>14</name>
<value><struct>
<member><name>2001</name>
<value><string>CCG17i</string></value>
</member>
<member><name>2002</name>
<value><string>30230</string></value>
</member>
<member><name>2003</name>
<value><string>04.62.A</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 10:38:39</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
</struct></value>
</param>
</params>
</methodResponse>

[Scott Mohekey]

Don,
How are your tables defined? Or are you yet to define them? I think a
workable approach would be to treat the structure as a table, and the
members as rows in this table. Therefore you would need to iterate over
the content of the xml using DOM (does vb script support SAX, anyone?)
inserting each member into the table, something like this (pseudo-code):

foreach member
executesql "INSERT INTO TableName ( 'Name', 'Value' ) VALUES ( '" &
member("name") & "', '" & member("value") & "' );" );
next member

I should mention that it is a while since I have used vb script.

I hope this helps.

Scott.

Don Grover wrote:

Thanks Scott
But I need to get this into sql server using vbscript if possibel, Do you
know how I can achieve this.
Any help would be most appreciated.
Don

"Scott Mohekey" <sm********@SPAMinsightful.co.nz> wrote in message
news:3f******@news.iconz.co.nz...

That xml document is a method response of the xmlrpc protocol, as such
it is not likely that you will be able to get them to change it.

The name element defines the name of that member of the structure, where
as the value element defines the value of that member.

Don Grover wrote:

I have this xml file provided by a supplier, and although it validates I
think it is wrong.
I need to find out if it is wrong and get them to correct it
The 2001 - 2005 are field names I thing they are putting them in the
wrong
place and should be in replace of the <name> tag if so where should the
values go ?.
I would appreciate a xml guru looking at this and commenting as may need
as
i said to get them to do it properly.
Regards Don
<?xml version="1.0" encoding="UTF-8"?>
<methodResponse>
<params>
<param>
<value><struct>
<member><name>0</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN99i</string></value>
</member>
<member><name>2002</name>
<value><string>30380</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/29/2003 10:25:30</string></value>
</member>
<member><name>2010</name>
<value><string>29103cci</string></value>
</member>
<member><name>2011</name>
<value><string>29103cci</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>29103cci</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>1</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN103Wi</string></value>
</member>
<member><name>2002</name>
<value><string>30190</string></value>
</member>
<member><name>2003</name>
<value><string>04.64.A </string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/16/2003 13:54:06</string></value>
</member>
<member><name>2010</name>
<value><string>16103iCC</string></value>
</member>
<member><name>2011</name>
<value><string>16103iCC</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>16103iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>2</name>
<value><struct>
<member><name>2001</name>
<value><string>CCS57i</string></value>
</member>
<member><name>2002</name>
<value><string>10000948</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>10/03/2003 13:46:54</string></value>
</member>
<member><name>2009</name>
<value><string>10/03/2003 13:46:54</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>3103iCC</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>3103iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>3</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN120i</string></value>
</member>
<member><name>2002</name>
<value><string>10000950</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>10/07/2003 09:26:21</string></value>
</member>
<member><name>2009</name>
<value><string>10/07/2003 09:26:21</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>61033CC</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>61033CC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>4</name>
<value><struct>
<member><name>2001</name>
<value><string>CCS69i</string></value>
</member>
<member><name>2002</name>
<value><string>10000942</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2009</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>5</name>
<value><struct>
<member><name>2001</name>
<value><string>CCS69i</string></value>
</member>
<member><name>2002</name>
<value><string>10000943</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2009</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>6</name>
<value><struct>
<member><name>2001</name>
<value><string>CCS69i</string></value>
</member>
<member><name>2002</name>
<value><string>10000944</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2009</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>

<value><string>1</string></value>

</member>
</struct></value>
</member>
<member><name>7</name>
<value><struct>
<member><name>2001</name>
<value><string>6020i</string></value>
</member>
<member><name>2002</name>
<value><string>30350</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/26/2003 11:26:51</string></value>
</member>
<member><name>2010</name>
<value><string>24103i</string></value>
</member>
<member><name>2011</name>
<value><string>6020i</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>24103i</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>8</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN118i</string></value>
</member>
<member><name>2002</name>
<value><string>30170</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/14/2003 09:57:39</string></value>
</member>
<member><name>2010</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2011</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>9</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN119i</string></value>
</member>
<member><name>2002</name>
<value><string>30160</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/14/2003 09:57:39</string></value>
</member>
<member><name>2010</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2011</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>10</name>
<value><struct>
<member><name>2001</name>
<value><string>6014i</string></value>
</member>
<member><name>2002</name>
<value><string>30290</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 16:09:12</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi3</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi3</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi3</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>11</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN102Wi</string></value>
</member>
<member><name>2002</name>
<value><string>30200</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 10:21:04</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi1</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi1</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi1</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>12</name>
<value><struct>
<member><name>2001</name>
<value><string>CCG16i</string></value>
</member>
<member><name>2002</name>
<value><string>30210</string></value>
</member>
<member><name>2003</name>
<value><string>04.60.A</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 10:38:39</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>13</name>
<value><struct>
<member><name>2001</name>
<value><string>CCG16i</string></value>
</member>
<member><name>2002</name>
<value><string>30220</string></value>
</member>
<member><name>2003</name>
<value><string>04.61.A</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 10:38:39</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>14</name>
<value><struct>
<member><name>2001</name>
<value><string>CCG17i</string></value>
</member>
<member><name>2002</name>
<value><string>30230</string></value>
</member>
<member><name>2003</name>
<value><string>04.62.A</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 10:38:39</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
</struct></value>
</param>
</params>
</methodResponse>

[Don Grover]

Tables are defined but I could create a tmp table built to the xml
structure,.
ie. 2001, 2002 etc.. and fill it with data from xml file.

The problem is this is from a XML-RPC Protocol and downloaded as a string,
and a file does not exist as it may reside latter on a co-hosted sql server.

If I could work out how to get a XML-RPC text stream into a table I could
work with that.
Another problem is the xml structure is not changable I cant get them to
change how they put xml tags in as its fixed.

"Scott Mohekey" <sm*********@SPAM.insightful.co.nz> wrote in message
news:3f******@news.iconz.co.nz...

Don,
How are your tables defined? Or are you yet to define them? I think a
workable approach would be to treat the structure as a table, and the
members as rows in this table. Therefore you would need to iterate over
the content of the xml using DOM (does vb script support SAX, anyone?)
inserting each member into the table, something like this (pseudo-code):

foreach member
executesql "INSERT INTO TableName ( 'Name', 'Value' ) VALUES ( '" &
member("name") & "', '" & member("value") & "' );" );
next member

I should mention that it is a while since I have used vb script.

I hope this helps.

Scott.

Don Grover wrote:

Thanks Scott
But I need to get this into sql server using vbscript if possibel, Do you know how I can achieve this.
Any help would be most appreciated.
Don

"Scott Mohekey" <sm********@SPAMinsightful.co.nz> wrote in message
news:3f******@news.iconz.co.nz...

That xml document is a method response of the xmlrpc protocol, as such
it is not likely that you will be able to get them to change it.

The name element defines the name of that member of the structure, where
as the value element defines the value of that member.

Don Grover wrote:

I have this xml file provided by a supplier, and although it validates Ithink it is wrong.
I need to find out if it is wrong and get them to correct it
The 2001 - 2005 are field names I thing they are putting them in the

wrong

place and should be in replace of the <name> tag if so where should the
values go ?.
I would appreciate a xml guru looking at this and commenting as may

need
as

i said to get them to do it properly.
Regards Don
<?xml version="1.0" encoding="UTF-8"?>
<methodResponse>
<params>
<param>
<value><struct>
<member><name>0</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN99i</string></value>
</member>
<member><name>2002</name>
<value><string>30380</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/29/2003 10:25:30</string></value>
</member>
<member><name>2010</name>
<value><string>29103cci</string></value>
</member>
<member><name>2011</name>
<value><string>29103cci</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>29103cci</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>1</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN103Wi</string></value>
</member>
<member><name>2002</name>
<value><string>30190</string></value>
</member>
<member><name>2003</name>
<value><string>04.64.A </string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/16/2003 13:54:06</string></value>
</member>
<member><name>2010</name>
<value><string>16103iCC</string></value>
</member>
<member><name>2011</name>
<value><string>16103iCC</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>16103iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>2</name>
<value><struct>
<member><name>2001</name>
<value><string>CCS57i</string></value>
</member>
<member><name>2002</name>
<value><string>10000948</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>10/03/2003 13:46:54</string></value>
</member>
<member><name>2009</name>
<value><string>10/03/2003 13:46:54</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>3103iCC</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>3103iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>3</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN120i</string></value>
</member>
<member><name>2002</name>
<value><string>10000950</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>10/07/2003 09:26:21</string></value>
</member>
<member><name>2009</name>
<value><string>10/07/2003 09:26:21</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>61033CC</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>61033CC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>4</name>
<value><struct>
<member><name>2001</name>
<value><string>CCS69i</string></value>
</member>
<member><name>2002</name>
<value><string>10000942</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2009</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>5</name>
<value><struct>
<member><name>2001</name>
<value><string>CCS69i</string></value>
</member>
<member><name>2002</name>
<value><string>10000943</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2009</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>6</name>
<value><struct>
<member><name>2001</name>
<value><string>CCS69i</string></value>
</member>
<member><name>2002</name>
<value><string>10000944</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string></string></value>
</member>
<member><name>2008</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2009</name>
<value><string>09/24/2003 17:16:15</string></value>
</member>
<member><name>2010</name>
<value><string></string></value>
</member>
<member><name>2011</name>
<value><string>2493iCC</string></value>
</member>
<mmber><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>2493iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>7</name>
<value><struct>
<member><name>2001</name>
<value><string>6020i</string></value>
</member>
<member><name>2002</name>
<value><string>30350</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/26/2003 11:26:51</string></value>
</member>
<member><name>2010</name>
<value><string>24103i</string></value>
</member>
<member><name>2011</name>
<value><string>6020i</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>24103i</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>8</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN118i</string></value>
</member>
<member><name>2002</name>
<value><string>30170</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/14/2003 09:57:39</string></value>
</member>
<member><name>2010</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2011</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>9</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN119i</string></value>
</member>
<member><name>2002</name>
<value><string>30160</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/14/2003 09:57:39</string></value>
</member>
<member><name>2010</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2011</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2012</name>
<value><string>INT</string></value>
</member>
<member><name>2013</name>
<value><string>13103iCC</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>10</name>
<value><struct>
<member><name>2001</name>
<value><string>6014i</string></value>
</member>
<member><name>2002</name>
<value><string>30290</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 16:09:12</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi3</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi3</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi3</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>11</name>
<value><struct>
<member><name>2001</name>
<value><string>CCN102Wi</string></value>
</member>
<member><name>2002</name>
<value><string>30200</string></value>
</member>
<member><name>2003</name>
<value><string>FLOOR</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 10:21:04</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi1</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi1</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi1</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>12</name>
<value><struct>
<member><name>2001</name>
<value><string>CCG16i</string></value>
</member>
<member><name>2002</name>
<value><string>30210</string></value>
</member>
<member><name>2003</name>
<value><string>04.60.A</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 10:38:39</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>13</name>
<value><struct>
<member><name>2001</name>
<value><string>CCG16i</string></value>
</member>
<member><name>2002</name>
<value><string>30220</string></value>
</member>
<member><name>2003</name>
<value><string>04.61.A</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 10:38:39</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
<member><name>14</name>
<value><struct>
<member><name>2001</name>
<value><string>CCG17i</string></value>
</member>
<member><name>2002</name>
<value><string>30230</string></value>
</member>
<member><name>2003</name>
<value><string>04.62.A</string></value>
</member>
<member><name>2004</name>
<value><string>DNG/S</string></value>
</member>
<member><name>2005</name>
<value></value>
</member>
<member><name>2006</name>
<value></value>
</member>
<member><name>2007</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2008</name>
<value><string>01/01/2099 00:00:00</string></value>
</member>
<member><name>2009</name>
<value><string>10/21/2003 10:38:39</string></value>
</member>
<member><name>2010</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2011</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2012</name>
<value><string>IMC</string></value>
</member>
<member><name>2013</name>
<value><string>21103CCi2</string></value>
</member>
<member><name>2014</name>
<value></value>
</member>
<member><name>2015</name>
<value><string>1</string></value>
</member>
</struct></value>
</member>
</struct></value>
</param>
</params>
</methodResponse>

[Scott Mohekey]

Don,
What language are you using?
You should be able to pass the text stream to a DOM implementation
parser, and then process the structure from there.
Scott.

Don Grover wrote:

Tables are defined but I could create a tmp table built to the xml
structure,.
ie. 2001, 2002 etc.. and fill it with data from xml file.

The problem is this is from a XML-RPC Protocol and downloaded as a string,
and a file does not exist as it may reside latter on a co-hosted sql server.

If I could work out how to get a XML-RPC text stream into a table I could
work with that.
Another problem is the xml structure is not changable I cant get them to
change how they put xml tags in as its fixed.