Posts

Showing posts from 2017

Convert Chrome recording to Vugen Script

Image
Hello All, Today we will learn how we can convert a chrome recording to VuGen script. Simply turn on the F12 [developer tools] in chrome and go to network Click Record [Auto turned on] Record your steps Now Right click on any of the request in dev tools and say save a HAR. the content will be saved in JSON format as HAR file open the HAR file in vugen Script ready. ----------------------------------------------------------------------------------------------------------------- Even you can read the data in easy format  by following below steps: Use any tool to convert JSON format to XML format. and you can now easily read all the request and their response.

VBA Code to Copy Files from one folder to another

FilesPath=inputbox("Enter Sourcepath for  files to be copied as C:\RootFilesPath") FileToCopyPath=inputbox("Enter destination  folderpath to copy files Sample as C:\ODC Data Compare\ODC File Compare\Prod Data") Set FileObj=createobject("Scripting.FileSystemObject") If  FileObj.FolderExists(FIlesPath) Then Set oFolder=FileObj.GetFolder(FIlesPath) Set oFiles=oFolder.Files For each oFile in oFiles FileName=oFile.name FLName=split(FileName,"-") FName=trim(FindRecid(FLName(0))) If FileObj.FolderExists(FileToCopyPath) Then Set DestRootFolder=FileObj.GetFolder(FileToCopyPath) Set SubFolder=DestRootFolder.SubFolders For each oFolder in SubFolder SubFolderName=trim(oFolder.Name) If  SubFolderName=FName  Then SourcePath=FIlesPath & "\" &  FileName DestinationPath=FileToCopyPath & "\" & SubFolderName & "\" FileObj.CopyFile SourcePat...

Performance Testing prep

TCP vs HTTP TCP and UDP are the "trucks" on the highway, and the "load" they are carrying are protocols such as HTTP , File Transfer Protocol (FTP) and more. As you can understand, TCP and UDP are transport protocols used by protocols such as FTP, HTTP, and SMTP. While both TCP and UDP are used to transport other protocols, they have one significant difference; TCP offers guaranteed data transportation, whereas UDP doesn't. What this means is that TCP has a special mechanism that ensures data is safely transferred without errors from one point to another, whereas UDP doesn't provide any such insurance. HTTP (HyperText Transfer Protocol) is a protocol that utilizes TCP to transfer its information between computers (usually Web servers and clients). The client makes an HTTP request to the Web server using a Web browser, and the Web server sends the requested information (website) to the client. -------------------------------------------------...

Install Mac OS on Windows Virtual Machine

PreRequiste: Latest preview: 10.13 Final (17A365). September 25, 2017. Google Drive (One Full):  https://goo.gl/ZEB4vB Google Drive (6 of 6):  https://goo.gl/dJe4CV Fix Download Limit:  https://techsviewer.com/fix-download-limit Code for VirtualBox (New):  https://goo.gl/GvhfVS VirtualBox:  https://goo.gl/MztVe5 Steps to Install macOS 10.13 High Sierra on VirtualBox on Windows Step 1: Extract Virtual Machine Image File Step 2: Install VirtualBox Step 3: Create New Virtual Machine Name: macOS 10.13 High Sierra Type: Mac OS X Version: macOS 10.13 or 10.12 Memory size: 3GB to 6GB ( 65% of your Ram) Virtual disk file: macOS high Sierra 10.13.vmdk Select Expert mode Choose OS file location  Choose RAM and all. Step 5: Add Code to VirtualBox with Command Prompt (cmd) Code for Virtualbox 5.x: cd "C:\Program Files\Oracle\VirtualBox\" VBoxManage.exe modifyvm " Your VM Name " --cpuidset 00000001 000106e5 00100800 0098e3fd bfebfbff...

Enable LAN Setting via registery

under HKEY_LOCAL_MACHINE>SOFTWARE>POLICIES>INTERNET EXPLORER>CONTROL PANEL there were AutoConfig Reg_DWord 1, and Proxy REG_DWord 1.  If these are set to 1 they grey out both options and the user whether an administrator or not cannot change them.  This prevent a novice user from messing up the selections.  I deleted both of these reg_dwords and the options were then selectable/changeable. 

Jmeter Authorization | NTLM

While Testing with Jmeter, you might be trying to script a application which do not have a login page. But it does authenticate the user by Single Sign on (SSO) or Through a pop up. SSO: When Your Request is transferred to some 3rd party application to validate your credentials through which you have logged into your device . Example : Your Intranet application in your company which authorizes and display your personalized homepage for the person who has logged into the device. Pop-UP : While working with Loadrunner you might be using web_set_user function to fulfill your need. Whereas in Jmeter, it is done using HTTP Authorization manager. where you mention the external server link, User name, password and domain. Although just adding this part and executing the Homepage still might return 401 unauthorized. Well now you have to look if your request need some Authorization Key, which is generated by HTTP Authorization manager. It might be requiring that in header of th...

How to Change the IE setting using Registry Editor[RedEdit]

Disable Proxy Settings in Registry Step 1 Click "Start," type "regedit" in the search field and press "Enter." Step 2 Expand the "HKEY_CURRENT_USER" hive by clicking on the "+" sign next to it. Continue expanding "Software," "Microsoft," "Windows" and "CurrentVersion," then click on the "Internet Settings" subkey or folder. Step 3 View the contents of the Internet Settings folder on the right pane. Double-click on the "ProxyEnable" DWORD value to open the "Edit DWORD Value" window. Change "Value data" to "1" and press "OK" to confirm. Step 4 Double-click on the "ProxyServer" string value. Back Up a Registry Key Step 5 Locate the Registry key or subkey you will modify. For this case, locate the "Internet Settings" subkey. Step 6 Right-click on the "Internet Settings" subkey or fol...

Run Stored Procedure from JAVA program and see the output

How to Call a stored procedure using JAVA code: package com.qa.conf; import java.io.*; import java.sql.*; import java.time.LocalDateTime; import java.time.ZonedDateTime;  public class DBConnection { public static void main(String args []){                System. out .println( "Started" );               String OPTSCHK = "INTERNAL" ,                        CHASEMEDIUM = "EMAIL" ,        try {         //step1 load the driver class         Class. forName ( "oracle.jdbc.driver.OracleDriver" );                  //step2 create  the connect...

How to write a PL/SQL procedure

How to write PL/SQL Procedure Initialize input and output variables. input variables are those which dynamic values which needs to be updated whenever Procedure is called Output variables are those in which you need to store the output of query For Single Result set, we use Output Variable But when output is of Many Line it is recommended to use Cursers else you might end up with exception: TOO_MANY_ROWS The Select Query is modified with little insertions so that result can be stored in an variable which can there is used for further action. Example : create or replace PROCEDURE TESTPROC1 (   U_MATCHSYSTEM IN VARCHAR2  -- Declare Input Variable   ,R_RESULT_TEXT OUT VARCHAR2  -- Declare Output Variable   AS BEGIN select txn_proc_id,counterparty_id,TXN_ID into R_TXN_PRC_ID,R_CPTYID,R_TXN_ID from table1 where MATCHSYSTEM= U_MATCHSYSTEM ; R_RESULT_TEXT := CONCAT (R_RESULT_TEXT, 'Process Started');  -- You can Store...

Automation WinSCP | How to Read/Write files from/to SFTP location

Create a text file which contains the step for connecting to SFTP open sftp://username:password@ServerName/ -hostkey="ssh-rsa 2048 b2:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx" # Change the remote directory cd serverPath # Upload the file to current working directory get -filemask="*>=1H"  DestinationLocation # Disconnect close # Exit WinSCP exit Save this Code as File1.txt and place this in the folder where WINSCP.EXE is present. OPEN : Open Connection Username: your Username for SFTP server Password: Password for SFTP server ServerName : Server IP or Server Host name hostkey: Its a key required to make connection to that server: How to get HostKey : Run the Code Without entering the hostkey value/Tag Command line will itself show you the hostkey. serverPath: Example:  cd /opt/app/ : Go to Required Path DestinationLocation : Destination where you need to download the files get -filemask="*>=1H"  C:\TEMP\ : Get the files fro...

How to Navigate to Network path using CMD

Image
To navigate to the network path using cmd. please use the below command : pushd