Hello,
I am trying to find an easy way to compare data in a table against a database of some sort, for this instance a CSV file. Specifically, I want to compare each data cell in a table with the CSV file, without the need to select everything in the table individually. Instead, I would like to select each cell the the first row, and compare the data in it against my CSV file, then move on to the next row of the table and repeat the process. I have had no problem binding the CSV to a single cell, but I can't seem to find a way to move to the next row on the site. Is such a thing possible, and if so could you point me in the right direction as to how to get started?
Thanks,
-Justin
I am trying to find an easy way to compare data in a table against a database of some sort, for this instance a CSV file. Specifically, I want to compare each data cell in a table with the CSV file, without the need to select everything in the table individually. Instead, I would like to select each cell the the first row, and compare the data in it against my CSV file, then move on to the next row of the table and repeat the process. I have had no problem binding the CSV to a single cell, but I can't seem to find a way to move to the next row on the site. Is such a thing possible, and if so could you point me in the right direction as to how to get started?
Thanks,
-Justin
6 Answers, 1 is accepted
0
Hello Justin,
Thanks for the question and your trial of WebUI Test Studio Dev Edition. Unfortunately, there is not a way to do what you are describing with any built in feature.
You would need to manually do the same data binding and test step verification on a single cell for each other cell you want to verify.
Alternatively, you can try a coded solution and it would require logic to skip over cells that don't have relevant content. Please let me know if your interested in a coded solution and what type of table you are trying to automate over: html, Rad, or Silverlight.
Greetings,
Nelson Sin
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Thanks for the question and your trial of WebUI Test Studio Dev Edition. Unfortunately, there is not a way to do what you are describing with any built in feature.
You would need to manually do the same data binding and test step verification on a single cell for each other cell you want to verify.
Alternatively, you can try a coded solution and it would require logic to skip over cells that don't have relevant content. Please let me know if your interested in a coded solution and what type of table you are trying to automate over: html, Rad, or Silverlight.
Greetings,
Nelson Sin
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
Justin
Top achievements
Rank 1
Rank 1
answered on 14 Jun 2010, 07:44 PM
Hi Nelson,
Thanks for the speedy response! I don't need a coded solution at this time, I was just curious if it could be done without the need to code anything. I may get back to you in the future if a coded solution becomes necessary, but for now this was all I need to know.
Thanks alot,
- Justin
Thanks for the speedy response! I don't need a coded solution at this time, I was just curious if it could be done without the need to code anything. I may get back to you in the future if a coded solution becomes necessary, but for now this was all I need to know.
Thanks alot,
- Justin
0
Hi again Justin,
Ok, sounds good and thanks for the feed back, I'll log a feature request for this. Please let us of anything else you run into and we'd be happy to help.
Regards,
Nelson
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Ok, sounds good and thanks for the feed back, I'll log a feature request for this. Please let us of anything else you run into and we'd be happy to help.
Regards,
Nelson
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
Kristine Ayson
Top achievements
Rank 1
Rank 1
answered on 15 Jun 2010, 03:45 AM
Hi Telerik team,
Apparently, I have the same predicament. I am testing a RadGrid, and need to compare its contents to a CSV file. Can you provide a coded solution that I can refer to?
Much thanks,
Kristine
Apparently, I have the same predicament. I am testing a RadGrid, and need to compare its contents to a CSV file. Can you provide a coded solution that I can refer to?
Much thanks,
Kristine
0
Hi Kristine,
Attached is a sample test that I think will work for you even though it was created in the internal WebUI build available online. Please let me know if you have any problems adding it as an existing test to your test project.
The test was created against this demo page. Please see the screenshot in the zip file to see how to highlight and add the GridTableView to your test project.
You should see the GridTableView option in the fan out menu options when highlighting your RadGrid. The sample code is written referencing the GridTableView added to the sample test.
Please note the following about the sample CSV file:
- The column names are numbers starting from 0 to the number of cells there are in a row minus 1
- The last cell in the row is empty due to the last row in the demo page row having invalid cell text content
- The number of rows in the CSV must also correspond to the number of rows in the RadGrid
Please reply back if you have any questions on the sample test.
Regards,
Nelson
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Attached is a sample test that I think will work for you even though it was created in the internal WebUI build available online. Please let me know if you have any problems adding it as an existing test to your test project.
The test was created against this demo page. Please see the screenshot in the zip file to see how to highlight and add the GridTableView to your test project.
You should see the GridTableView option in the fan out menu options when highlighting your RadGrid. The sample code is written referencing the GridTableView added to the sample test.
Please note the following about the sample CSV file:
- The column names are numbers starting from 0 to the number of cells there are in a row minus 1
- The last cell in the row is empty due to the last row in the demo page row having invalid cell text content
- The number of rows in the CSV must also correspond to the number of rows in the RadGrid
Please reply back if you have any questions on the sample test.
Regards,
Nelson
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
Kristine Ayson
Top achievements
Rank 1
Rank 1
answered on 16 Jun 2010, 03:32 AM
Hi Nelson,
Thanks so much for the sample code. It's a big help!
Thanks so much for the sample code. It's a big help!