- 10
- 90 823
Tutor
ΠΡΠΈΡΠ΄Π½Π°Π²ΡΡ 6 ΠΆΠΎΠ² 2016
Tutor is a channel dedicated to teach programming for beginner`s.. π
vmrun commands to automate virtual machines.
This tutorial is dedicated to beginners who want to automate virtual machines using the vmrun command.
Also this tutorial will cover runprograminguest example.
To learn more about vmrun commands visit my blog:-
automation-tutorial.blogspot.in/2016/09/Vmware-automation.html
Also this tutorial will cover runprograminguest example.
To learn more about vmrun commands visit my blog:-
automation-tutorial.blogspot.in/2016/09/Vmware-automation.html
ΠΠ΅ΡΠ΅Π³Π»ΡΠ΄ΡΠ²: 18 820
ΠΡΠ΄Π΅ΠΎ
Basics of Batch(.bat) files
ΠΠ΅ΡΠ΅Π³Π»ΡΠ΄ΡΠ² 2668 ΡΠΎΠΊΡΠ² ΡΠΎΠΌΡ
In this video ill walk you through basics of batch file. For detailed steps you can visit my blog:- automation-tutorial.blogspot.in/2016/09/basics-of-batch-file.html?
Read data from excel in selenium webdriver c#
ΠΠ΅ΡΠ΅Π³Π»ΡΠ΄ΡΠ² 41 ΡΠΈΡ.8 ΡΠΎΠΊΡΠ² ΡΠΎΠΌΡ
This tutorial deals with reading data from an Excel sheet in C# and using the obtained data in Selenium WebDriver . To know more about the code you can visit my blog:- automation-tutorial.blogspot.in/2016/09/read-data-from-excel-sheet-for-webdriver.html?
implicit wait using Selenium C# Driver
ΠΠ΅ΡΠ΅Π³Π»ΡΠ΄ΡΠ² 3,1 ΡΠΈΡ.8 ΡΠΎΠΊΡΠ² ΡΠΎΠΌΡ
openQA.Selenium.NoSuchElementException can be resolved using Implicit wait method To know more about Implicit and Explicit wait in Selenium c# driver please visit my blog- automation-tutorial.blogspot.in/2016/09/implicit-and-explicit-wait-in-selenium.html
Selenium WebDriver C# - Inspect Elements+FindElement()+click()+sendKeys()
ΠΠ΅ΡΠ΅Π³Π»ΡΠ΄ΡΠ² 6 ΡΠΈΡ.8 ΡΠΎΠΊΡΠ² ΡΠΎΠΌΡ
To know more about inspecting elements please visit my blog- automation-tutorial.blogspot.in/2016/09/Inspect-Elements.html To know more about WebElements in selenium c# visit my blog- automation-tutorial.blogspot.in/2016/09/IwebElement.html To learn more about XPATH- ua-cam.com/video/GZ6e8-aQBEk/v-deo.html
Selenium C# Select value from Dropdown list
ΠΠ΅ΡΠ΅Π³Π»ΡΠ΄ΡΠ² 7 ΡΠΈΡ.8 ΡΠΎΠΊΡΠ² ΡΠΎΠΌΡ
For detailed description about select class and code please visit my blog- automation-tutorial.blogspot.in/2016/09/Select-Class-in-Selenium.html
Capture screenshot in Selenium C# WebDriver
ΠΠ΅ΡΠ΅Π³Π»ΡΠ΄ΡΠ² 2,1 ΡΠΈΡ.8 ΡΠΎΠΊΡΠ² ΡΠΎΠΌΡ
For detailed code please visit my blog- automation-tutorial.blogspot.in/2016/09/Capture-Screenshot-In-Selenium.html
Find XPATH using FireBug and FirePath
ΠΠ΅ΡΠ΅Π³Π»ΡΠ΄ΡΠ² 9 ΡΠΈΡ.8 ΡΠΎΠΊΡΠ² ΡΠΎΠΌΡ
For detailed description about Xpath please visit my blog- automation-tutorial.blogspot.in/2016/09/finding-xpath-using-firebug-and-firepath.html To Download Firebug use the below link: addons.mozilla.org/en-US/firefox/addon/firebug/ To Download FirePath use the below link: addons.mozilla.org/en-US/firefox/addon/firepath/
Selenium WebDriver - Setup + Hello World with Visual Studio,c#
ΠΠ΅ΡΠ΅Π³Π»ΡΠ΄ΡΠ² 3,3 ΡΠΈΡ.8 ΡΠΎΠΊΡΠ² ΡΠΎΠΌΡ
This tutorial will provide a step by step guide to Setup selenium in visual studio and also will teach you to automate. This video is great for beginners who are keen in learning Selenium. For more detailed steps to setup selenium in visual studio please visit my blog automation-tutorial.blogspot.in/2016/09/setup-selenium-in-visual-studio.html
Selenium C# WebDriver Navigation methods
ΠΠ΅ΡΠ΅Π³Π»ΡΠ΄ΡΠ² 6958 ΡΠΎΠΊΡΠ² ΡΠΎΠΌΡ
In this video ill walk you over through some of the most important Browser Navigation methods used in selenium. For more information about each methods please visit my blog - automation-tutorial.blogspot.in/2016/09/browser-navigation-in-selenium.html
I am getting the following Error CS0021 Cannot apply indexing with [] to an expression of type 'object' please assist me.
Hi I'm getting error > Cannot apply indexing with [] to an expression of type 'object' for line website= x1range.Cells[i][1].value2; please help, thank you TTTT
How can we find the length of dropdown , in case of day ,month ,year we know but if we dont know size of dropdown how can we find out..?
Could you please make a vedio on how to automate Power bi ui report using selenium c#
Thanks π
Thanks a lot! Great help. β€οΈ
very nice very very thanks
Hi, I'd like to know what should i type in command prompt to list all vm's then stop / reset them, without specify a way... a command as vmrun -t ws list | foreach (status eq running, stop) Is it possible ? I don't find any answer about that...
thank you! i make a clean sheet with your explanation!
Hello! Do you know how I can automate connection to remote vm desktop? I want to create a .bat file with writing IP of remote desktop, login and password. Can you help me? How I can do it? Excuse me for bad english.
16 vala workstation kese chalata hai
I am getting the following errors...Can you please assist excel._Worksheet x1worksheet = x1workbook.Sheets[1]; - Gives me an error which states that I must use: excel._Worksheet x1worksheet = (excel._Worksheet)x1workbook.Sheets[1]; website = x1range.Cells[i][1].value2; - Severity Code Description Project File Line Suppression State , Error CS0021 Cannot apply indexing with [] to an expression of type 'object' ReadDatafromFile ........repos\ReadDatafromFile\ReadDatafromFile\Program.cs 21
I am getting the following errors...Can you please assist excel._Worksheet x1worksheet = x1workbook.Sheets[1]; - Gives me an error which states that I must use: excel._Worksheet x1worksheet = (excel._Worksheet)x1workbook.Sheets[1]; website = x1range.Cells[i][1].value2; - Severity Code Description Project File Line Suppression State , Error CS0021 Cannot apply indexing with [] to an expression of type 'object' ReadDatafromFile ........repos\ReadDatafromFile\ReadDatafromFile\Program.cs 21 Active
As I run on local I have no issues but when I upload to Azure DevOps (CI/CD) and run remotely, build failed with below errors. I was wondering why Azure DevOps failing to download the packages? Any suggestion please! [INFO] Compiling 32 source files to d:\a\1\s\ExceleRATE\target\classes [INFO] ------------------------------------------------------------- [ERROR] COMPILATION ERROR : [INFO] ------------------------------------------------------------- [ERROR] /e:/a/1/s/ExceleRATE/src/main/java/com/qa/ExceleRATE/util/ReadExcelData.java:[8,35] package org.apache.poi.ss.usermodel does not exist [ERROR] /e:/a/1/s/ExceleRATE/src/main/java/com/qa/ExceleRATE/util/ReadExcelData.java:[9,37] package org.apache.poi.xssf.usermodel does not exist [ERROR] /e:/a/1/s/ExceleRATE/src/main/java/com/qa/ExceleRATE/util/ReadExcelData.java:[10,37] package org.apache.poi.xssf.usermodel does not exist [ERROR] /e:/a/1/s/ExceleRATE/src/main/java/com/qa/ExceleRATE/util/ReadExcelData.java:[18,9] cannot find symbol symbol: class XSSFWorkbook location: class com.qa.ExceleRATE.util.ReadExcelData [ERROR] /e:/a/1/s/ExceleRATE/src/main/java/com/qa/ExceleRATE/util/ReadExcelData.java:[20,9] cannot find symbol symbol: class XSSFSheet location: class com.qa.ExceleRATE.util.ReadExcelData [ERROR] /e:/a/1/s/ExceleRATE/src/main/java/com/qa/ExceleRATE/util/ReadExcelData.java:[31,34] cannot find symbol symbol: class XSSFWorkbook location: class com.qa.ExceleRATE.util.ReadExcelData [INFO] 6 errors
"ReadExcelData.java " Why it is calling Java ?
@@sharadranajava I created seperate java class called ReadExcelData.java where I read my data from excel, public String getCellDataString(String sheetName, int rowNum, int colNum) throws IOException { File file = new File(System.getProperty("user.dir")+"/excel/ExcelWorkBook.xlsx"); FileInputStream fis = new FileInputStream(file); wb = new XSSFWorkbook(fis); sheet = wb.getSheet(sheetName); String cellData = sheet.getRow(rowNum).getCell(colNum).getStringCellValue(); return cellData; }
how can i set a window size ?
Excel.Application.... It says this Application is not in microsoft.office.interop.. What refrence I should add
please create a video of reading two columns. username and password for instance.
Adding-second comment. good work Alexander-Tutor, The adolf hiter & martinson. will keep in touch.
Title suggest totally different topic...
Thank you
I'm getting an error saying "Cannot implicitly convert type 'object ' to Microsoft.office.interop.excel._worksheet"
I am getting an error saying "cannot implicitly convert type'object' to Microsoft.office.interop.excel._worksheet".. please reply
excel._Worksheet x1_worksheet = (Microsoft.Office.Interop.Excel.Worksheet)x1workbook.Sheets[1];
funciona perfecto!!! gracias!
Make video on 2 rows and 2 columns
You can avoid the error by using Driver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(5) syntax
i think xpath is not for currenlty available , please give us new add on to find out xpath
What is the reference for this operation?
The .ImplicitlyWait provides the error message ' Timeouts does not contain ImplicitlyWait'. I have all of the dlls's working. Anyone else having this issue?
i am getting unauthorised acess exception to the path given how to solve this.plz reply
Muy buena la explicacion pero tienes de casualidad alguna forma de crear las maquinas virtuales desde el cmd?
lo siento mi amigo no soy consciente
@@Tutor4ever ok amigo gracias
Thank you friend for explaining how to start using Selenium
welcome friend :)
System.InvalidCastException: 'Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Excel.Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' I am getting this error on first line --> Microsoft.Office.Interop.Excel.Application x1app = new Microsoft.Office.Interop.Excel.Application();
Please need your help This video is very good and easy to understand. but if they have numbers in excel they appear an error: 'You can not implicitly convert the type 'double' to 'string'. ' what can i do? thks my friend
Hi Jhonny, Have you tried the below flow? 1)Read data from cell 2)store in a variable 3)convert to double using Convert.ToDouble() method
@@Tutor4ever correct me if i'm wrong technically, even i was facing the abv issue when added mobile number in the excel (as a user name) then i added ' (single quotation) before the mobile number in the excel & run my code .. then the issue got resolved .
muy buena explicaciΓ³n
Muchas gracias :)
How do i write the result after finishing a test ?
Hi Shahriar, where do you want to write the result?
hi, do you know how to use connectNamedDevice command ? mainly for connecting USB device in guest vm from host machine
Can you please tell the ways by which we can get inspect elements code or its DOM elements when it is different from that of source code?
Thank you so much
Welcome Mohan :)
Hi , I am getting the below error CS0656 Missing compiler required member 'Microsoft.CSharp.RuntimeBinder.Binder.Convert' . Can anyone help me how to fix this issue
I know that I'm "late to the party", but in case anyone else has the same problem I will leave the solution here: You need to get "Microsoft.CSharp" and you get it the same way Tutor got the "Microsoft.Office.Interop.Excel".
Thanks cikarin3 :)
Hi, I have a below error: Cannot convert from 'System.Drawing.Imaging.ImageFormat' to 'OpenQA.Selenium.ScreenshotImageFormat' How can I solve this issue?
You need to change "ImageFormat" by "ScreenshotImageFormat".
How did you install file path on chrome? Thanks
The details are available in automation-tutorial.blogspot.com/2016/09/setup-selenium-in-visual-studio.html
I am getting this error - System.Runtime.InteropServices.COMException : Exception from HRESULT: 0x800A03EC
start from non-zero based indexing like start from 1 instead of zero
Hi , this is nagaveni, i want to know that how can we identify the angular js based kind of elements using firebug
Hi Nagaveni, Im sorry im not aware about angular js.
I am getting exception "Excel cannot access 'ExcelData'. The document may be read-only or encrypted." i Checked the excel file it is not in read only mode.I just created a simple excel sheet with two columns.
I'm getting this error : Error 1 A field initializer cannot reference the non-static field, method, or property 'UIL.UIL_Login.x1app'
Error 1 One or more types required to compile a dynamic expression cannot be found. Are you missing a reference? what type error is this?
Hi Ajay, Try removing the "Microsoft.Csharp" reference then add it back to your project. Also ensure that you have added selenium package to your solution.
yes got it Thank you
@Tutor, Thanks for putting up short and to the point videos. I have question regarding capturing screenshot. What should I do in case I have to take the screenshot of whole page as one image. Currently it takes only the portion which is displayed. Our webpage is quite long and we have scroll down to access it.
Hi Anirudh, Thank you very much for your feedback. As of now capturing the screenshot of the entire webpage is not yet implemented. As a work around you could scroll down your webpage to a particular web element and then take the screenshot. The code snippet for the same is: Using openqa.selenium.interactions; Iwebelement element =driver.Findelement(By.id("xyz")); Actions actions = new Actions(driver); actions.MoveToElement(element); actions.Perform(); //Capture screenshot code goes here
Es un gran video y se entiende muy bien por su simplicidad .Para pruebas en aplicaciones de escritorio(windows) ,como se usarΓa estas herramientas .Soy Tester y Coded UI es muy complejo mentener los casos de pruebas Gracias PerΓΊ
I just learnt Spanish to tell "gracias amigo"
i am getting Error like "starting chromeDriver 2.27.440174(e97a722caffc..............) on Port 7660 Only local connections are allowed. starting chromeDriver 2.27.440174(e97a722caffc..............) on port 7754 only local connections are allowed." my chrome opened 2 times and closed, but in url bar it showing like "data" instead of urls what is mentioned in excel sheet please tell me how to solve..
Hi Ashok, The data appears in the url bar if you have not appended the website url with "" Example: try using www.google.com instead of www.google.com
wow., Awesome now working as Expected Thank you and please make a video about instead of taking urls from excel sheet. system have a to take input data(name, address, ph number, email) from excel sheet and enter that data in respective fields like text boxes. i am requesting you.
Sure Ashok. Meanwhile to retrieve the value of a particular cell all you need to do is replace column and row value appropriately in the statement x1range.cells[row index][column index].Value2;
showing error as An unhandled exception of type 'System.InvalidCastException' occurred in DataDriven.exe Additional information: Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'.
It would be great if you share the statement where this error is occurring! Ensure that you have installed OpenQA.Selenium package to your current solution and also ensure that there is no case sensitivity issue. To know more about the code you could visit automation-tutorial.blogspot.in/2016/09/read-data-from-excel-sheet-for-webdriver.html?
no work run program inguest
Make sure you have setup password on your guest machine. The syntax is vmrun -gu username -gp password runprograminguest "<path to .vmx file>" -nowait -interactive "C:\Windows\system32\calc.exe"