cancel
Showing results for 
Search instead for 
Did you mean: 

Saving Response Data to a Excel -> DataSink

Contributor

Saving Response Data to a Excel -> DataSink

I need to save each of these "value" and "writeable" to an excel sheet with value and writeable as columns and their data as rows.

Can you assist?


 
     
       
           
           
           
           
           

           
           
           
           
       

     

     
        InternetGatewayDevice.WANDevice.1.WANConnectionDevice.1.WANPPPConnection.1.Stats.EthernetPacketsReceived
        false
     

     
        InternetGatewayDevice.WANDevice.1.WANConnectionDevice.1.WANDSLLinkConfig.
        false
     

     
        InternetGatewayDevice.WANDevice.1.WANConnectionDevice.1.WANPPPConnection.1.ConnectionType
        true
     


     
        InternetGatewayDevice.WANDevice.1.WANConnectionDevice.1.WANDSLLinkConfig.DestinationAddress
        true
     

 
19 REPLIES 19
Super Contributor

Re: 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
Contributor

Re: Saving Response Data to a Excel -> DataSink

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
Super Contributor

Re: Saving Response Data to a Excel -> DataSink

Hi!

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

regards!

/Ole
eviware.com
Contributor

Re: Saving Response Data to a Excel -> DataSink

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
     

 
Super Contributor

Re: Saving Response Data to a Excel -> DataSink

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
Contributor

Re: Saving Response Data to a Excel -> DataSink

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

Re: Saving Response Data to a Excel -> DataSink

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
Contributor

Re: Saving Response Data to a Excel -> DataSink

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
"",""
"",""
"",""
"",""
"",""
"",""
"",""
"",""
"",""
"",""
"",""
"",""
"",""
"",""
"",""
"",""
Super Contributor

Re: Saving Response Data to a Excel -> 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
New Here?
Join us and watch the welcome video:
6 / 7 API Testing Mistakes Video
Top Kudoed Authors