This is a migrated thread and some comments may be shown as answers.

Excel sheet data to web app

7 Answers 13 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Etl
Top achievements
Rank 1
Etl asked on 20 Nov 2018, 03:37 AM

Hello I am trying to retrieve data from excel sheet and save it in web app.

lets say I have set of data in excel sheet which I need to transfer or save into the web app where the data will be kept.

in other words we can migrate 

so any help will be much appreciated thanks.

 

7 Answers, 1 is accepted

Sort by
0
Elena
Telerik team
answered on 20 Nov 2018, 11:01 AM
Hi Etl,

Based on my understanding for the required scenario on your side, I assume that data driving the test will guide you in the right direction. Also, you can have a look how an excel sheet can be used as data source for a data driven test. Still, if this is not the case you are after, or you have questions about the content in those articles, please let me know with further details and I will assist you further.

I hope this helps.

Regards,
Elena Tsvetkova
Progress Telerik
 
The New Release of Telerik Test Studio Is Here! Download, install,
and send us your feedback!
0
Etl
Top achievements
Rank 1
answered on 20 Nov 2018, 11:33 AM
I will try it out and let ya know thanks 
0
Etl
Top achievements
Rank 1
answered on 20 Nov 2018, 11:42 AM

By using the methods which you shared I wil be able to save the data in the web app or not? 

The out come which I want is that the test studio gets the data from excel sheet which has a lot of rows and columns than saves the data into web app and keep running till the data is finished and it’s been entered in respective rows and columns. 

Thanks 

0
Elena
Telerik team
answered on 23 Nov 2018, 10:48 AM
Hi Etl,

Based on the description of the requirements you have, the data driven test seems to be the approach which should cover the scenario. Since I am not familiar in details with the application you are automating, I will share an example when a test can be data driven and what the result will be. 

Let's have an online shop web page for example and a web form to create an item in that shop. That form contains multiple fields to fulfill in order to describe the item to sell. To avoid preparing a test for each item to be uploaded, you can record the necessary actions once and then data drive the test with an Excel file, for example. The necessary steps are listed below:
1. Add a data source in the project
2. Bind the test to the data source
3. Attach the data source columns to Input or Verification steps. 
4. Execute the test - it will be run multiple iterations which amount corresponds to the rows in the Excel file. 

How to build a thorough example for data driven test is described for the case when using the built-in data source. Though, if switching the data source to any external, the main idea remains the same. 

I hope the above information provides sufficient information for your query. Of course, in case you have additional questions, please let me know. 

Regards,
Elena Tsvetkova
Progress Telerik
 
The New Release of Telerik Test Studio Is Here! Download, install,
and send us your feedback!
0
Si
Top achievements
Rank 1
answered on 05 Dec 2018, 08:47 PM

I am also trying to upload an excel sheet into my web app. However I don't want to have the data in the sheet be iterative. I want it to be able to save the entire sheet 1 into the web app. Is there a way to do this?

 

For Example:

Web application adds multiple lines per Item at 1 time. In order to satisfy the requirements, I must make sure that I can upload an excel sheet with multiple lines for 1 item. I don't want it to run 1x1 through the lines and add them 1 per test. I need them to all upload at 1 time. 

 

Is this possible?

 

Thanks

0
Elena
Telerik team
answered on 10 Dec 2018, 12:56 PM
Hello Si,

Thank you for the additional notes. 

Test Studio provides built-in dialog handlers to handle any dialogs triggered from the web page. Among these is the Upload dialog which I believe should work for you in this scenario. There is no limitation what the uploaded file will contain as long as the application under test accepts it. 

If still this is not covering the desired scenario, please prepare a sample test which demonstrates what the requirements are. It will be helpful if this can be executed against a public accessible page. However, even if the script cannot be executed on my end, it will still show the steps it goes through and thus, I will have more context about the case that is to be covered. 

Thanks in advance. 

Regards,
Elena Tsvetkova
Progress Telerik
 
The New Release of Telerik Test Studio Is Here! Download, install,
and send us your feedback!
0
Etl
Top achievements
Rank 1
answered on 10 Dec 2018, 08:21 PM
Thankyou for your help 
Tags
General Discussions
Asked by
Etl
Top achievements
Rank 1
Answers by
Elena
Telerik team
Etl
Top achievements
Rank 1
Si
Top achievements
Rank 1
Share this question
or