Urgent Opion wanted.

[Don Grover]

I have this xml file provided by a supplier, and although it validates I think it is wrong. I need to find out if it is wrong and get them to correct it The 2001 - 2005 are field names I thing they are putting them in the wrong place and should be in replace of the <name> tag if so where should the values go ?. I would appreciate a xml guru looking at this and commenting as may need as i said to get them to do it properly.
Regards Don

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

 

[Scott Mohekey]

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

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

 

[Don Grover]

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" wrote:

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

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

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

wrong

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

as

> i said to get them to do it properly.
> Regards Don
>
>
> <?xml version="1.0" encoding="UTF-8"?>
> <methodResponse>
> <params>
> <param>
> <value><struct>
> <member><name>0</name>
> <value><struct>
> <member><name>2001</name>
...

 

[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" wrote:

>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.
>
...

 

[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" wrote:

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

...

you

> know how I can achieve this.
> Any help would be most appreciated.
> Don
>
> "Scott Mohekey" wrote:
>
>
>>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.
...

I

>>>think it is wrong.
>>>I need to find out if it is wrong and get them to correct it
>>>The 2001 - 2005 are field names I thing they are putting them in the
>
> wrong
>
>>>place and should be in replace of the <name> tag if so where should the
>>>values go ?.
>>>I would appreciate a xml guru looking at this and commenting as may

need

>
> as
>
>>>i said to get them to do it properly.
>>>Regards Don
>>>
>>>
>>><?xml version="1.0" encoding="UTF-8"?>
>>> <methodResponse>
>>> <params>
>>> <param>
>>> <value><struct>
...

 

[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.