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><struc t>
<member><name>0 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN99i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30380</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/29/2003 10:25:30</string></value>
</member>
<member><name>2 010</name>
<value><string> 29103cci</string></value>
</member>
<member><name>2 011</name>
<value><string> 29103cci</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 29103cci</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN103Wi</string></value>
</member>
<member><name>2 002</name>
<value><string> 30190</string></value>
</member>
<member><name>2 003</name>
<value><string> 04.64.A </string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/16/2003 13:54:06</string></value>
</member>
<member><name>2 010</name>
<value><string> 16103iCC</string></value>
</member>
<member><name>2 011</name>
<value><string> 16103iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 16103iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>2 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCS57i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000948</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 10/03/2003 13:46:54</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/03/2003 13:46:54</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 3103iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 3103iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>3 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN120i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000950</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 10/07/2003 09:26:21</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/07/2003 09:26:21</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 61033CC</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 61033CC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>4 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCS69i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000942</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 009</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>5 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCS69i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000943</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 009</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>6 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCS69i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000944</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 009</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>7 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> 6020i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30350</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value>/value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/26/2003 11:26:51</string></value>
</member>
<member><name>2 010</name>
<value><string> 24103i</string></value>
</member>
<member><name>2 011</name>
<value><string> 6020i</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 24103i</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>8 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN118i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30170</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/14/2003 09:57:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 011</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>9 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN119i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30160</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/14/2003 09:57:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 011</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 0</name>
<value><struc t>
<member><name>2 001</name>
<value><string> 6014i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30290</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 16:09:12</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi3</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi3</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi3</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 1</name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN102Wi</string></value>
</member>
<member><name>2 002</name>
<value><string> 30200</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 10:21:04</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi1</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi1</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi1</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 2</name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCG16i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30210</string></value>
</member>
<member><name>2 003</name>
<value><string> 04.60.A</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 10:38:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 3</name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCG16i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30220</string></value>
</member>
<member><name>2 003</name>
<value><string> 04.61.A</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 10:38:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 4</name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCG17i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30230</string></value>
</member>
<member><name>2 003</name>
<value><string> 04.62.A</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 10:38:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</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><struc t>
<member><name>0 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN99i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30380</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/29/2003 10:25:30</string></value>
</member>
<member><name>2 010</name>
<value><string> 29103cci</string></value>
</member>
<member><name>2 011</name>
<value><string> 29103cci</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 29103cci</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN103Wi</string></value>
</member>
<member><name>2 002</name>
<value><string> 30190</string></value>
</member>
<member><name>2 003</name>
<value><string> 04.64.A </string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/16/2003 13:54:06</string></value>
</member>
<member><name>2 010</name>
<value><string> 16103iCC</string></value>
</member>
<member><name>2 011</name>
<value><string> 16103iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 16103iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>2 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCS57i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000948</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 10/03/2003 13:46:54</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/03/2003 13:46:54</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 3103iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 3103iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>3 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN120i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000950</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 10/07/2003 09:26:21</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/07/2003 09:26:21</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 61033CC</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 61033CC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>4 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCS69i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000942</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 009</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>5 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCS69i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000943</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 009</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>6 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCS69i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000944</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 009</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>7 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> 6020i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30350</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNGS</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/26/2003 11:26:51</string></value>
</member>
<member><name>2 010</name>
<value><string> 24103i</string></value>
</member>
<member><name>2 011</name>
<value><string> 6020i</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 24103i</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>8 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN118i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30170</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/14/2003 09:57:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 011</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>9 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN119i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30160</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/14/2003 09:57:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 011</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 0</name>
<value><struc t>
<member><name>2 001</name>
<value><string> 6014i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30290</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 16:09:12</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi3</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi3</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi3</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 1</name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN102Wi</string></value>
</member>
<member><name>2 002</name>
<value><string> 30200</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 10:21:04</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi1</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi1</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi1</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 2</name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCG16i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30210</string></value>
</member>
<member><name>2 003</name>
<value><string> 04.60.A</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 10:38:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 3</name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCG16i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30220</string></value>
</member>
<member><name>2 003</name>
<value><string> 04.61.A</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 10:38:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 4</name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCG17i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30230</string></value>
</member>
<member><name>2 003</name>
<value><string> 04.62.A</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 10:38:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</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********@SPA Minsightful.co. nz> wrote in message
news:3f******@n ews.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><struc t>
<member><name>0 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN99i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30380</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/29/2003 10:25:30</string></value>
</member>
<member><name>2 010</name>
<value><string> 29103cci</string></value>
</member>
<member><name>2 011</name>
<value><string> 29103cci</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 29103cci</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN103Wi</string></value>
</member>
<member><name>2 002</name>
<value><string> 30190</string></value>
</member>
<member><name>2 003</name>
<value><string> 04.64.A </string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/16/2003 13:54:06</string></value>
</member>
<member><name>2 010</name>
<value><string> 16103iCC</string></value>
</member>
<member><name>2 011</name>
<value><string> 16103iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 16103iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>2 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCS57i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000948</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 10/03/2003 13:46:54</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/03/2003 13:46:54</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 3103iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 3103iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>3 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN120i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000950</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 10/07/2003 09:26:21</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/07/2003 09:26:21</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 61033CC</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 61033CC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>4 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCS69i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000942</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 009</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>5 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCS69i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000943</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 009</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>6 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCS69i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000944</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 009</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>7 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> 6020i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30350</string></value>
</member>
<member><name>2 003</nam>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/26/2003 11:26:51</string></value>
</member>
<member><name>2 010</name>
<value><string> 24103i</string></value>
</member>
<member><name>2 011</name>
<value><string> 6020i</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 24103i</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>8 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN118i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30170</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/14/2003 09:57:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 011</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>9 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN119i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30160</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/14/2003 09:57:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 011</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 0</name>
<value><struc t>
<member><name>2 001</name>
<value><string> 6014i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30290</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 16:09:12</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi3</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi3</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi3</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 1</name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN102Wi</string></value>
</member>
<member><name>2 002</name>
<value><string> 30200</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 10:21:04</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi1</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi1</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi1</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 2</name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCG16i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30210</string></value>
</member>
<member><name>2 003</name>
<value><string> 04.60.A</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 10:38:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 3</name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCG16i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30220</string></value>
</member>
<member><name>2 003</name>
<value><string> 04.61.A</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 10:38:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 4</name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCG17i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30230</string></value>
</member>
<member><name>2 003</name>
<value><string> 04.62.A</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 10:38:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</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********@SPA Minsightful.co. nz> wrote in message
news:3f******@n ews.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><struc t>
<member><name>0 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN99i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30380</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/29/2003 10:25:30</string></value>
</member>
<member><name>2 010</name>
<value><string> 29103cci</string></value>
</member>
<member><name>2 011</name>
<value><string> 29103cci</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 29103cci</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN103Wi</string></value>
</member>
<member><name>2 002</name>
<value><string> 30190</string></value>
</member>
<member><name>2 003</name>
<value><string> 04.64.A </string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/16/2003 13:54:06</string></value>
</member>
<member><name>2 010</name>
<value><string> 16103iCC</string></value>
</member>
<member><name>2 011</name>
<value><string> 16103iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 16103iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>2 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCS57i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000948</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 10/03/2003 13:46:54</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/03/2003 13:46:54</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 3103iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 3103iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>3 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN120i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000950</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 10/07/2003 09:26:21</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/07/2003 09:26:21</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 61033CC</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 61033CC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>4 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCS69i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000942</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 009</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>5 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCS69i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000943</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 009</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>6 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCS69i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000944</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 009</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>

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

</member>
</struct></value>
</member>
<member><name>7 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> 6020i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30350</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/26/2003 11:26:51</string></value>
</member>
<member><name>2 010</name>
<value><string> 24103i</string></value>
</member>
<member><name>2 011</name>
<value><string> 6020i</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 24103i</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>8 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN118i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30170</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/14/2003 09:57:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 011</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>9 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN119i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30160</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/14/2003 09:57:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 011</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 0</name>
<value><struc t>
<member><name>2 001</name>
<value><string> 6014i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30290</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 16:09:12</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi3</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi3</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi3</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 1</name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN102Wi</string></value>
</member>
<member><name>2 002</name>
<value><string> 30200</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 10:21:04</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi1</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi1</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi1</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 2</name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCG16i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30210</string></value>
</member>
<member><name>2 003</name>
<value><string> 04.60.A</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 10:38:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 3</name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCG16i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30220</string></value>
</member>
<member><name>2 003</name>
<value><string> 04.61.A</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 10:38:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 4</name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCG17i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30230</string></value>
</member>
<member><name>2 003</name>
<value><string> 04.62.A</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 10:38:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</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*********@SP AM.insightful.c o.nz> wrote in message
news:3f******@n ews.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********@SPA Minsightful.co. nz> wrote in message
news:3f******@n ews.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><struc t>
<member><name>0 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN99i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30380</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/29/2003 10:25:30</string></value>
</member>
<member><name>2 010</name>
<value><string> 29103cci</string></value>
</member>
<member><name>2 011</name>
<value><string> 29103cci</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 29103cci</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN103Wi</string></value>
</member>
<member><name>2 002</name>
<value><string> 30190</string></value>
</member>
<member><name>2 003</name>
<value><string> 04.64.A </string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/16/2003 13:54:06</string></value>
</member>
<member><name>2 010</name>
<value><string> 16103iCC</string></value>
</member>
<member><name>2 011</name>
<value><string> 16103iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 16103iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>2 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCS57i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000948</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 10/03/2003 13:46:54</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/03/2003 13:46:54</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 3103iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 3103iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>3 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN120i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000950</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 10/07/2003 09:26:21</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/07/2003 09:26:21</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 61033CC</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 61033CC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>4 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCS69i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000942</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 009</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>5 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCS69i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000943</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 009</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>6 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCS69i</string></value>
</member>
<member><name>2 002</name>
<value><string> 10000944</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> </string></value>
</member>
<member><name>2 008</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 009</name>
<value><string> 09/24/2003 17:16:15</string></value>
</member>
<member><name>2 010</name>
<value><string> </string></value>
</member>
<member><name>2 011</name>
<value><string> 2493iCC</string></value>
</member>
<mmber><name>20 12</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 2493iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>7 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> 6020i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30350</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/26/2003 11:26:51</string></value>
</member>
<member><name>2 010</name>
<value><string> 24103i</string></value>
</member>
<member><name>2 011</name>
<value><string> 6020i</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 24103i</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>8 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN118i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30170</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/14/2003 09:57:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 011</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>9 </name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN119i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30160</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/14/2003 09:57:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 011</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 012</name>
<value><string> INT</string></value>
</member>
<member><name>2 013</name>
<value><string> 13103iCC</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 0</name>
<value><struc t>
<member><name>2 001</name>
<value><string> 6014i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30290</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 16:09:12</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi3</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi3</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi3</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 1</name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCN102Wi</string></value>
</member>
<member><name>2 002</name>
<value><string> 30200</string></value>
</member>
<member><name>2 003</name>
<value><string> FLOOR</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 10:21:04</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi1</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi1</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi1</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 2</name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCG16i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30210</string></value>
</member>
<member><name>2 003</name>
<value><string> 04.60.A</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 10:38:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 3</name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCG16i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30220</string></value>
</member>
<member><name>2 003</name>
<value><string> 04.61.A</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 10:38:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</name>
<value><string> 1</string></value>
</member>
</struct></value>
</member>
<member><name>1 4</name>
<value><struc t>
<member><name>2 001</name>
<value><string> CCG17i</string></value>
</member>
<member><name>2 002</name>
<value><string> 30230</string></value>
</member>
<member><name>2 003</name>
<value><string> 04.62.A</string></value>
</member>
<member><name>2 004</name>
<value><string> DNG/S</string></value>
</member>
<member><name>2 005</name>
<value></value>
</member>
<member><name>2 006</name>
<value></value>
</member>
<member><name>2 007</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 008</name>
<value><string> 01/01/2099 00:00:00</string></value>
</member>
<member><name>2 009</name>
<value><string> 10/21/2003 10:38:39</string></value>
</member>
<member><name>2 010</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 011</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 012</name>
<value><string> IMC</string></value>
</member>
<member><name>2 013</name>
<value><string> 21103CCi2</string></value>
</member>
<member><name>2 014</name>
<value></value>
</member>
<member><name>2 015</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.