Software Quality Assurance & Testing Stack Exchange is a question and answer site for software quality control experts, automation engineers, and software testers. It only takes a minute to sign up.
Sign up to join this community
I need to download the CSV files from this page but i am not able to do so. PFA the screenshot of the page from where the files has to be downloaded :
I have tried the below code but it doesn't work
JavascriptExecutor js = (JavascriptExecutor) wd;
js.executeScript("arguments[0].click();",wd.findElement(By.xpath("//*[@id='ctrl2016284712']/tbody/tr/td/table/tbody/tr/td/table/tbody/tr[24]/td[7]/a")));
I guess you could get the 'href' attribute from the anchor tag and just append your base url to it. Then do driver.get(baseURL + href). Also if you face any difficulty creating an xpath then do let me know, I will explain it more in detail.
Updated answer:
Try this xpath since you want to download only csv type of file: //table[@class='lcb']/tbody/tr/td/table[@class='ibody']/tbody/tr/td[contains(translate(text(), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz'),'csv')]/parent::tr/td[7]
//table[@class='ibody']/tbody/tr[24]/td[7]/a . Let me know if that works
Nov 29, 2018 at 6:14
I would not go from the structure in your case but rather from a content. Here is the example of html:
<html>
<body>
<table class="table table-condensed">
<tbody>
<tr>
<th>h1</th>
<th>h2</th>
<th>h3</th>
</tr>
<tr>
<td>28112706.CSV</td>
<td>12</td>
<td>28/11/2018 09:13</td>
<td>
<a hef="asdfsdf">
<img/>
</a>
</td>
</tr>
</tbody>
</table>
</body>
</html>
and here is the example of xpath:
//tbody/tr[./td[text()='28112706.CSV']|./td[text()='28/11/2018 09:13']]/td/a
that returns a element that resides in the table row where we have the cell with 28112706.CSV AND the cell with 28112706.CSV
So your challenge is to define the row you want to use and describe the conditionss for the content in xPath expression.
If you are looking at downloading all the CSV files, you may want to use findElements() to get all the links and click each one. Looking at the image and HTML snippet, looks like you have a single link in each row pointing to the CSV file.
List<WebElement> allLinks = wd.findElements(By.cssSelector("tr a"));
Should return all the links. Now you can loop through the list and click on each element. Something like:
for(WebElement e: allLinks)
e.click()
