Friday, November 1, 2019

AutoIT useful information

Some features:
  • Very easy to create/manage/publish AutoIt projects (compile)
  • Integrated GUI Editor (ISN Form Studio 2)
  • Integrated file & project manager
  • Extendable thanks to plugins and open source!
  • Available in several languages
  • trophies
  • AutoIt 3 Syntax Highlighting / Autocomplete / IntelliSense
  • macros
  • Change Manager for your AutoIt project
  • Detailed overview of your project (how long have you been working on it, total size, etc.)
  • Integrated to-do list for your project
  • Optimized for high-resolution display (High DPI)
  • And much, much more!
ISN AutoIt Studio is free and 100% written (except for some DLL's) in AutoIt!
The latest version of ISN AutoIt Studio can be found under `Downloads'!

For AutoIT script making download ISN Studio followed by below URL

Guides/Tutorials

  • Tutorials - There are many tutorials available for AutoIt. This page is an overview of a few known tutorials.
  • Best coding practices - a detailed explanation of what are to be considered the best coding practices within AutoIt. These recommendations are based on accepted coding practices common to a number of other programming languages. You do not need to follow them, but it is recommended that you do.
  • Snippets - generally single functions or small pieces of code that can be incorporated into a script to add extra functionality.

Videos

Books

Syntax Highlighter

Other Awesome Lists


Checkout below URL for more useful information

https://github.com/J2TEAM/awesome-AutoIt#browsers

How To Auto-Center Checkbox In Cell In Excel?



How To Auto-Center Checkbox In Cell In Excel?

To automatically center all checkboxes in cells in a current worksheet, please do as follows.
1. In the worksheet, you need to auto-center all checkboxes, press the Alt + F11 keys to open the Microsoft Visual Basic for Applications window.
2. In the Microsoft Visual Basic for Applications window, please click Insert > Module. Then copy and paste VBA code into the code window.
VBA code: Automatically center all checkboxes in cells
Sub CenterCheckbox ()
Dim xRg As Range
Dim chkBox As OLEObject
Dim chkFBox As CheckBox
On Error Resume Next
Application.ScreenUpdating = False
For Each chkBox In ActiveSheet.OLEObjects
If TypeName(chkBox.Object) = "CheckBox" Then
Set xRg = chkBox.TopLeftCell
chkBox.Width = xRg.Width * 2 / 3
chkBox.Height = xRg.Height
chkBox.Left = xRg.Left + (xRg.Width - chkBox.Width) / 2
chkBox.Top = xRg.Top + (xRg.Height - chkBox.Height) / 2
End If
Next
For Each chkFBox In ActiveSheet.CheckBoxes
Set xRg = chkFBox.TopLeftCell
chkFBox.Width = xRg.Width * 2 / 3
chkFBox.Height = xRg.Height
chkFBox.Left = xRg.Left + (xRg.Width - chkFBox.Width) / 2
chkFBox.Top = xRg.Top + (xRg.Height - chkFBox.Height) / 2
Next
Application.ScreenUpdating = True
End Sub
3. Press the F5 key. Then all checkboxes are moved into the center of the cells immediately as below screenshot shown.
Note: This VBA code can be applied to both CheckBox (ActiveX Control) and CheckBox (Form Control).
For more details kindly follow below URL:
Thank you very much for taking the time to reading this topic.

Monday, October 14, 2019

Visual testing using AI technology -Applitools for a Beginner

Intelligent Functional and Visual Testing Through Visual AI


Release perfect apps much faster at a reduced cost using incredibly accurate Visual AI

For more details about tool kindly follow below URL


At First,you have a registered into Applitools and it's free edition for a few days with some features.
After registered into Applitools,API key is generated which is used in all projects. If you forgot API key you can check on  'My API' option after login into account.


Above illustrated my testing by Applitools for a learning purpose and you can make professional by modifying some structure your own skills.

Screenshot -1 for Not exactly matching with Baseline visually selection pink marker as illustrated in below screenshot.

For more about Baseline refer below URL:




Screenshot -2 for Not exactly matching with Baseline visually selection pink marker as illustrated in below screenshot.




Some snippet code for above screenshots kindly refer below github URL:


Thank you very much for reading this post and take a some time for Automation testing.

Friday, October 4, 2019

XPath and CSS finder Chrome Extension Tool: Eskry

Eskry

Eskry is a free browser add-on/extension that helps automation testers and developers generating locators for HTML elements. 

From Chrome Web store find this tool and add to Chrome as plugin


For more details open above URL and type "ESKRY" in search box as followed by image:


After successfully adding this plugin,check for icon as illustrated in below image.


Then for testing purpose open a below URL in browser


After open url in chrome browser press F12 or Ctrl + Shift + I as Inspect element then look for a "Eskry " tab as illustrated in below image



Checkout below image for click on Title of the website and title of Register form 


Click on TEST button then it will be highlighted on screen as illustrated below


And then you can use for Automation Script for locator any specific elements in a browser.

Thank you very much for a reading this blog.
 


Thursday, September 26, 2019

AutoIT with Web Driver

Chrome support for AutoIT is here!  :D

This UDF includes a Chrome Extension (http://developer.chrome.com/extensions/getstarted.html) and Native Messaging Host (http://developer.chrome.com/extensions/messaging.html#native-messaging-hostthat integrate with a new Chrome UDF (Chrome.au3) to provide automation support for the Chrome browser.

Several steps are required to install the Chrome Extension and Native Messaging Host prior to using the UDF.  

Please read the INSTALLATION section below.

REQUIREMENTS:
  • Windows XP 32-bit, Windows 7 32-bit or Windows 7 64-bit
  • AutoIt3 3.2 or higher
  • Chrome v29 or later (earlier versions are untested)
  • AutoIT for Google Chrome (Chrome extension - see below)
  • AutoIT Chrome Native Messaging Host (see below)
INSTALLATION:

STEP 1: Install the AutoIT extension into Chrome.
Open the following link and download the file named AutoIT for Google Chrome.crx:


Note - you may be prompted to login with a Google account as this file is hosted on Google Drive.
In your Chrome browser click on the Chrome menu, then select Tools -> Extensions

Drag the AutoIT for Google Chrome.crx file that you downloaded above, from Windows Explorer, into this page in Chrome.  

You should now see AutoIT for Google Chrome listed in the Extensions page in Chrome.  Ensure that the Enabled checkbox next to AutoIT for Google Chrome is checked.  

Also make sure the Allow access to file URLs box is checked (very important to make EXAMPLE 2 work below)!!

STEP 2: Install the AutoIT Chrome Native Messaging Host.
Open the following link and download the file named autoit_chrome_native_messaging_host_install.exe:


Note - you may be prompted to login with a Google account as this file is hosted on Google Drive.

Run this file (autoit_chrome_native_messaging_host_install.exe).  An installation window will display.  Click the Install button.  

The window will display "Completed" and you can click the Close button.

STEP 3: Install the Chrome UDF into AutoIT.
Scroll to the DOWNLOAD section below, and save the Chrome.au3 file into your AutoIT Include folder (C:Program FilesAutoIt3Include).

Please close your Chrome browser once you've completed these steps.


EXAMPLE #1:

This following example starts up Chrome and navigates to the URL 


It then automatically completes the HTML form in this page (a series of text, radio, and checkbox input elements and select elements) and clicks the Send this survey button.  

The script waits for the next page to load and retrieves the various elements from the page to the AutoIT console.


EXAMPLE #2:

The following is an example of the automation of an offline HTML page (file URL).  First, download the file named chrome_udf_example_2.html to your 

C: folder:

Then run the following AutoIT script:

Note that you must have checked the Allow access to file URLs box in the Chrome extension to make this work!


Download URLs:

https://github.com/autom99/AutoIT-with-WebDriver




Friday, August 23, 2019

Install and Update All Your Programs at Once


Install and Update All Your Programs at Once


No toolbars. No clicking next. Just pick your apps and go.



1. Pick the apps you want

2. Download and run your custom installer/updater.


For more details refer below URL:


CSharpBeginner - Beginner of Dot NET Development in C#


  
**********Online compiler Microsoft of c#******************

Click on below link:
https://www.microsoft.com/net/learn/in-browser-tutorial/1
https://docs.microsoft.com/en-us/dotnet/csharp/language-reference/operators/index-operator
---------------------- About Access Modifier in C#:----------------------------------------
Public: Anywhere from the class
Private: Only within the class
Protected: Only within that class and the sub classes of that class
Internal: Within the assembly of the class
Protected Internal: Within that class, sub classes of that class and and assembly
**************************Web Session Management in C#****************************************
C:\Windows\Microsoft.NET\Framework\v4.0.30319>aspnet_regsql -S localhost -U root -P root -ssadd -sstype p (SQL server session mode)
****************************Session timeout:**************************************************
https://www.aspsnippets.com/Articles/Display-Session-Timeout-message-before-Session-expires-in-ASPNet.aspx
https://www.c-sharpcorner.com/UploadFile/225740/introduction-of-session-in-Asp-Net/
----------call in direcctly page_load() in <class-name>.cs :-------------------
HtmlMeta meta = new HtmlMeta();
meta.HttpEquiv = "Refresh";
meta.Content = Convert.ToString(Session.Timeout * 60) + ";url=LogIn.aspx";
this.Page.Header.Controls.Add(meta);
*****************Some useful links for C# Beginner .NET Development:*********************
https://www.1keydata.com/sql/sql.html
https://demo.aspnetawesome.com/
https://www.javatpoint.com/c-sharp-systemexception --> I Prefer this link as beginner.
https://www.youtube.com/watch?v=JhxC-K-Eehg
https://www.completecsharptutorial.com/
https://docs.microsoft.com/en-us/dotnet/csharp/language-reference/keywords/accessibility-levels
https://www.questpond.com/demo.html
https://www.youtube.com/watch?v=lx2tSY4joDg
---------------------------Registration Adult Validation URLs;------------------------------------------------------------
https://www.c-sharpcorner.com/UploadFile/cd7c2e/apply-client-side-validation-on-dob-selected-by-user/
https://www.c-sharpcorner.com/UploadFile/cd7c2e/apply-server-side-validation-on-dob-selected-by-user/
https://www.aspsnippets.com/Articles/Validate-Date-of-Birth-18-Minimum-Age-validation-in-ASPNet.aspx1
--------------------------------------FORGOT PWD:----------------------------------------------------------------
https://www.aspdotnet-suresh.com/2012/11/code-for-forgot-password-in-aspnet.html
-----------------------------------GIT HUB LINK:---------------------------------------------------------------
https://github.com/hb20007/miscellaneous-programs
https://github.com/DotnetMob/
https://github.com/dbugtime/Csharp-For-Beginners
https://github.com/MicrosoftDocs/visualstudio-docs/tree/master/docs/ide
https://github.com/dotnetcurry?utf8=%E2%9C%93&tab=repositories&q=&type=&language=c%23


Prefer below URL for more details:

             https://github.com/autom99/CSharpBeginner