Saving Response Data to a Excel -> DataSink

Hi!

hmm.. maybe you could create an XML DataSource from this response containing 2 columns (value and writable) with the row-xpath set to //multiRef and the column-xpaths to the two values respectively. Then create an Excel DataSink that saves these two properties and finally a DataSourceLoop for the data..

So all in all your testcase would be something like

1) The request that gives this response
2) DataSource (XML) as described above
3) DataSink (Excel) as descrbed above
4) DataSourceLoop that loops back to (3) for each row in (2)
5) .. ?

Makes sense?

regards!

/Ole
eviware.com

The DataSource says Got 16 rows in 15ms.  I am attaching the project.  What am I doing wrong???

Step 5 [getLiveData - CMS 2.11 PD-128 Test 10.3] OK: took 2336 ms
Step 6 [DataSource 10.3] OK: took 4 ms
-> Missing property values in DataSource Row
Step 7 [DataSink 10.3] OK: took 0 ms
Step 8 [DataSource Loop 10.3] OK: took 1 ms
Step 9 [DataSink 10.3] OK: took 0 ms
Step 10 [DataSource Loop 10.3] OK: took 1 ms
Step 11 [DataSink 10.3] OK: took 0 ms
Step 12 [DataSource Loop 10.3] OK: took 1 ms
Step 13 [DataSink 10.3] OK: took 0 ms
Step 14 [DataSource Loop 10.3] OK: took 1 ms
Step 15 [DataSink 10.3] OK: took 0 ms
Step 16 [DataSource Loop 10.3] OK: took 1 ms
Step 17 [DataSink 10.3] OK: took 0 ms
Step 18 [DataSource Loop 10.3] OK: took 1 ms
Step 19 [DataSink 10.3] OK: took 0 ms
Step 20 [DataSource Loop 10.3] OK: took 1 ms
Step 21 [DataSink 10.3] OK: took 0 ms
Step 22 [DataSource Loop 10.3] OK: took 3 ms
Step 23 [DataSink 10.3] OK: took 0 ms
Step 24 [DataSource Loop 10.3] OK: took 1 ms
Step 25 [DataSink 10.3] OK: took 0 ms
Step 26 [DataSource Loop 10.3] OK: took 1 ms
Step 27 [DataSink 10.3] OK: took 0 ms
Step 28 [DataSource Loop 10.3] OK: took 1 ms
Step 29 [DataSink 10.3] OK: took 0 ms
Step 30 [DataSource Loop 10.3] OK: took 1 ms
Step 31 [DataSink 10.3] OK: took 0 ms
Step 32 [DataSource Loop 10.3] OK: took 1 ms
Step 33 [DataSink 10.3] OK: took 0 ms
Step 34 [DataSource Loop 10.3] OK: took 1 ms
Step 35 [DataSink 10.3] OK: took 0 ms
Step 36 [DataSource Loop 10.3] OK: took 1 ms
Step 37 [DataSink 10.3] OK: took 0 ms
Step 38 [DataSource Loop 10.3] OK: took 0 ms
Step 39 [Delay 10.3] OK: took 3017 ms

Hi!

hmm.. can you attach or mail me (ole@eviware.com) the response-message you are selecting from?

regards!

/Ole
eviware.com

XML Response


 
     
       
           
           
           
           
           
           
           
           
           
           
           
           
           
           
           
           
       
     
     
       
        2008-06-16T19:20:31.239Z
        InternetGatewayDevice.ManagementServer.Username
        000FCC-31947664
     
     
       
        2008-06-16T19:20:31.239Z
        InternetGatewayDevice.ManagementServer.ManageableDeviceNumberOfEntries
        0
     
     
       
        2008-06-16T19:20:31.239Z
        InternetGatewayDevice.ManagementServer.Password
       
     
     
       
        2008-06-16T19:20:31.239Z
        InternetGatewayDevice.ManagementServer.ParameterKey
       
     
     
       
        2008-06-16T19:20:31.239Z
        InternetGatewayDevice.ManagementServer.PeriodicInformInterval
        86400
     
     
       
        2008-06-16T19:20:31.239Z
        InternetGatewayDevice.ManagementServer.X_0000C5_RemoteManagementTimeout
        0
     
     
       
        2008-06-16T19:20:31.239Z
        InternetGatewayDevice.ManagementServer.PeriodicInformTime
        1970-01-01T00:00:00
     
     
       
        2008-06-16T19:20:31.239Z
        InternetGatewayDevice.ManagementServer.URL
        http://cwmp.w05.qacms.2wire.com
     
     
       
        2008-06-16T19:20:31.239Z
        InternetGatewayDevice.ManagementServer.ConnectionRequestUsername
        31947664
     
     
       
        2008-06-16T19:20:31.239Z
        InternetGatewayDevice.ManagementServer.ConnectionRequestPassword
       
     
     
       
        2008-06-16T19:20:31.239Z
        InternetGatewayDevice.ManagementServer.X_0000C5_RemoteManagementNewPassword
       
     
     
       
        2008-06-16T19:20:31.239Z
        InternetGatewayDevice.ManagementServer.KickURL
        http://192.168.0.1:80/DslfKick
     
     
       
        2008-06-16T19:20:31.239Z
        InternetGatewayDevice.ManagementServer.X_0000C5_RemoteManagementEnable
        0
     
     
       
        2008-06-16T19:20:31.239Z
        InternetGatewayDevice.ManagementServer.PeriodicInformEnable
        1
     
     
       
        2008-06-16T19:20:31.239Z
        InternetGatewayDevice.ManagementServer.ConnectionRequestURL
        http://65.244.244.169:7547/XML/000FCC-31947664.xml
     
     
       
        2008-06-16T19:20:31.239Z
        InternetGatewayDevice.ManagementServer.UpgradesManaged
        1
     
 

Thanks!

Actually, I think the results you are getting are correct.. or are you not getting any data into the excel file?

regards!

/Ole
eviware.com

I am not getting any data into the datasource, datasink or the excel...

Hi,

duh.. thanks.. you've encountered a bug.. try changing the row xpath to the following:

declare namespace ns='blabla';
//multiRef

to get it working.. let me know..

regards,

/Ole
eviware.com

Much better, now I get the following:

DataSource
InternetGatewayDevice.ManagementServer.URL http://cwmp.w05.qacms.2wire.com
InternetGatewayDevice.ManagementServer.Username 000FCC-31947664
InternetGatewayDevice.ManagementServer.X_0000C5_RemoteManagementTimeout 0
InternetGatewayDevice.ManagementServer.UpgradesManaged 1
InternetGatewayDevice.ManagementServer.KickURL http://192.168.0.1:80/DslfKick
InternetGatewayDevice.ManagementServer.PeriodicInformInterval 86400
InternetGatewayDevice.ManagementServer.ConnectionRequestPassword
InternetGatewayDevice.ManagementServer.Password
InternetGatewayDevice.ManagementServer.PeriodicInformTime 1970-01-01T00:00:00
InternetGatewayDevice.ManagementServer.X_0000C5_RemoteManagementEnable 0
InternetGatewayDevice.ManagementServer.PeriodicInformEnable 1
InternetGatewayDevice.ManagementServer.X_0000C5_RemoteManagementNewPassword
InternetGatewayDevice.ManagementServer.ConnectionRequestUsername 31947664
InternetGatewayDevice.ManagementServer.ManageableDeviceNumberOfEntries 0
InternetGatewayDevice.ManagementServer.ConnectionRequestURL http://65.244.244.169:7547/XML/000FCC-31947664.xml
InternetGatewayDevice.ManagementServer.ParameterKey

DataSink
"",""
"",""
"",""
"",""
"",""
"",""
"",""
"",""
"",""
"",""
"",""
"",""
"",""
"",""
"",""
"",""

Progress is good!

Now set the values of the Name/Value properties in your DataSink to

Name = ${DataSource 10.3#Parameter Name}
Value = ${DataSource 10.3#Parameter Value}

this should set the correct values for these properties from the DataSource for each loop..

works ok?

regards!

/Ole
eviware.com

Works Great,

THANK YOU !!!!!

This is much better than having to write Groovy Scripts to try and pull data out..

THANK YOU !!