eValid™ -- Automated Web Quality Solution Browser-Based, Client-Side, Functional Testing & Validation, Load & Performance Tuning, Page Timing, Website Analysis, and Rich Internet Application Monitoring.

Summary
This page presents another one of eValid's demonstration of functional/regression testing inside the SkyDrive environment using the Microsoft Excel workbook application. The scripting was done by recording where possible "from life" followed by manual script adjustment by use of eValid structural (index/motion) commands.

The scripts below are organized as follows:

• goExcel1.evs: This script is the "top level" script that invokes the next three in order. You could only run the newexcel.evs script several times, each run creating a new SpreadSheet, assuming that you are already logged in.
• login.evs: This script accomplishes the login process.
• newexcel.evs: This script creates a new SpreadSheet workbook, into which it enters various "INPUT data" within the rows/columns found.
• signout.evs: This script accomplishes the signout process.
• delete.evs: After several repetitions of goExcel1.evs (which means several repetitions of newexcel.evs) you can optionally use this script to delete a Book(s) in the Public folder.

Scripts
Here is the complete set of scripts used in this example.

• Top Level Script
  Click To Load goExcel1.evs

  # # Recording by eValid™ V9 Build #292, Build Date: (Oct 20 2009) # Copyright © 2009 by Software Research, Inc. # Recording made on: Microsoft Windows Vista Service Pack 1 (IE 7.0.6001.18000), HostName "aruba" # Recording started at: <2010/01/07 13:47:01> # ProjectID "Project" GroupID "microsoft" TestID "goExcel1" LogID "AUTO" CallScript "login.evs" CallScript "newexcel.evs" CallScript "signout.evs"

• Login Script - (REUSED from prior Example#2)
  Click To Load login.evs

  # # Recording by eValid™ V9 Build #292, Build Date: (Oct 20 2009) # Copyright © 2009 by Software Research, Inc. # Recording made on: Microsoft Windows Vista Service Pack 1 (IE 7.0.6001.18000), HostName "aruba" # Recording started at: <2009/12/09 12:15:56> # ProjectID "Project" GroupID "microsoft" TestID "login" LogID "AUTO" ScreenSize 1440 900 FontSize 2 DeleteCache DeleteCookies InitLink "http://login.live.com/login.srf?" SyncOnText 0 "Sign in" "" # # Modified to INDEX MOTION to avoid different login id session assignments... # #Wait 1576 #FollowLink 0 137 "Sign in" "http://login.live.com/login.srf?wa=wsignin1.0&rpsnv=11&ct=1260402405&rve" \ # "r=5.5.4177.0&wp=MBI&wreply=http:%2F%2Fskydrive.live.com%2Fwelcome.aspx&l" \ # "c=1033&id=250206&mkt=en-US" "" # # Added Sync to await login screen... # SyncOnText 0 "E-mail address:" "" # # Input login details and submit... # InputValue 0 92 "TEXT" "i0116" "login" "evalid2009@live.com" "" "" ElementBlur 0 92 "i0116" "" "" Wait 1884 InputValue 0 107 "TEXT" "i0118" "passwd" "evalid+test" "" "" Wait 2018 InputValue 0 97 "RADIO" "i0138" "LoginOptions" "3" "TRUE" "" Wait 2304 SubmitClick 0 80 "i0011" "SI" " Sign in " "" NAV Wait 2493 FollowLink 0 58 "More ?" "https://account.live.com/#" "" NO_NAV Wait 2761 FollowLink 0 68 "SkyDrive" "http://g.live.com/9uxp9en-us/hdr_more2??su=http://shared.live.com/Live.A" \ "ccountManagement" "" # Recording stopped at: <2009/12/09 12:16:38>

• Construct Excel workbook
  Click To Load newexcel.evs
  

  # # Recording by eValid™ V9 Build #292, Build Date: (Oct 20 2009) # Copyright © 2009 by Software Research, Inc. # Recording made on: Microsoft Windows Vista Service Pack 1 (IE 7.0.6001.18000), HostName "aruba" # Recording started at: <2010/01/05 14:28:59> # ProjectID "Project" GroupID "microsoft" TestID "newexcel" LogID "AUTO" ScreenSize 1440 900 FontSize 2 DeleteCache DeleteCookies Wait 1468 # # Go inside the "Public" folder area... # FollowLink 0 244 "Public" "http://cid-636721b33b1d7b0a.skydrive.live.com" \ "/browse.aspx/.Public" "" Wait 2588 # # Click "New" for available selections... # NOTE:(enhanced with INDEX MOTION sequences, otherwise Adaptive Playback kicks-in...) # #FollowLink 0 152 "New ?" "http://cid-636721b33b1d7b0a.skydrive.live.com/" \ # "browse.aspx/.Public#" "" IndexSet 0 IndexFindElement 0 DOWN "innerText" "New" "" IndexElementClick 0 "" Wait 2278 # # Selected "Microsoft Excel workbook" option... # FollowLink 0 157 "Microsoft Excel workbook" "http://cid-636721b33b1d7b0a.skydrive.live.com/" \ "newdocument.aspx/.Public?x" \ "t=xlsx&ref=1" "" Wait 2671 # # Accepted "DEFAULT" input Name: and Clicked "Create"... # SubmitClick 0 166 "actionPageSubmit" "Create" "Create" "" NAV # # Added Syncs to wait for Microsoft Excel workbook to fully appear (load)... # SyncOnText 0 "Loading" "number:0" Wait 100 # (Below represents the GREEN "File" tab rendered.) SyncOnURL "http://s1-excel.vo.msecnd.net:80/1447231000__layouts/1033/images/ewaboot.png" # (Below represents not to proceed if the "Loading..." signal present.) SyncNotOnElementProperty 0 "innerText" "Loading" "number:0" # (Below represents the Sheet# tabs displayed at the bottom.) SyncOnElementProperty 0 "id" "m_excelWebRenderer_ewaCtl_sheetContentDiv_Sheet1_0_0" "number:0" # (Below represents the "1 person editing" indicator displayed at the bottom.) SyncOnElementProperty 0 "innerText" "People editing this workbook" "number:0" # (Below represents the row/column markers appearing in the middle.) SyncOnElementProperty 0 "innerText" "ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD" "number:0" Wait 1000 # # Find the "Fx" Formula Bar TEXTAREA in the middle and input data... # NOTE: (Added some real time Waits so that you can see the text INPUT flows.) # IndexSet 0 IndexFindElement 0 DOWN "id" "m_excelWebRenderer_ewaCtl_formulaBarTextArea" "number:0" Wait 1000 IndexFindElement 0 DOWN "tagName" "TEXTAREA" "number:0" Wait 1000 IndexInputValue 0 "TEXTAREA" "lemon" "" "number:0" Wait 1000 KeySys 0 13 0 1 # # REPEAT input data as desired, using ENTER/TAB/SHIFT-TAB to maneuver abouts... # IndexSet 0 IndexFindElement 0 DOWN "tagName" "TEXTAREA" "number:0" Wait 1000 IndexInputValue 0 "TEXTAREA" "ade" "" "number:0" KeySys 0 13 0 1 Wait 1000 KeySys 0 9 0 1 IndexSet 0 IndexFindElement 0 DOWN "tagName" "TEXTAREA" "number:0" Wait 1000 IndexInputValue 0 "TEXTAREA" "apple" "" "number:0" Wait 1000 KeySys 0 13 0 1 IndexSet 0 IndexFindElement 0 DOWN "tagName" "TEXTAREA" "number:0" Wait 1000 IndexInputValue 0 "TEXTAREA" "pie" "" "number:0" Wait 1000 KeySys 0 13 0 1 Wait 1000 KeySys 0 9 1 1 Wait 1245 IndexSet 0 IndexFindElement 0 DOWN "tagName" "TEXTAREA" "number:0" Wait 1000 IndexInputValue 0 "TEXTAREA" "ice" "" "number:0" Wait 1000 KeySys 0 13 0 1 IndexSet 0 IndexFindElement 0 DOWN "tagName" "TEXTAREA" "number:0" Wait 1000 IndexInputValue 0 "TEXTAREA" "cream" "" "number:0" Wait 1000 KeySys 0 13 0 1 Wait 5574 # Recording stopped at: <2010/01/05 14:34:09>

• Signout Account - (REUSED from prior Example#2)
  Click To Load signout.evs
  

  # # Recording by eValid™ V9 Build #292, Build Date: (Oct 20 2009) # Copyright © 2009 by Software Research, Inc. # Recording made on: Microsoft Windows Vista Service Pack 1 (IE 7.0.6001.18000), HostName "aruba" # Recording started at: <2009/12/09 15:45:22> # ProjectID "Project" GroupID "microsoft" TestID "signout" LogID "AUTO" # Simple recorded "Sign out" actions... # Wait 2617 FollowLink 0 62 "sign out" "http://login.live.com/logout.srf?ct=1260402302&rver=5.5.4177.0&lc=1033&i" \ "d=250206&ru=http:%2F%2Fcid-636721b33b1d7b0a.skydrive.live.com%2Fedit.asp" \ "x%2F.Public%2FPresentation11.excelx%3Fnd%3D1&mkt=en-US" "" Wait 2651 ElementBlur 0 92 "i0116" "" "" # # Can use the following to verify/validate signing out... # #Wait 3058 #ValidateSelectedText 0 72 0 "Sign in" "" #Wait 4852 SyncOnText 0 "Sign in" "" # Recording stopped at: <2009/12/09 15:45:47>

• Cleanup Prior Book - (REUSED from prior Example#2)
  Click To Load delete.evs
  

  # # Recording by eValid™ V9 Build #292, Build Date: (Oct 20 2009) # Copyright © 2009 by Software Research, Inc. # Recording made on: Microsoft Windows Vista Service Pack 1 (IE 7.0.6001.18000), HostName "aruba" # Recording started at: <2009/12/10 13:31:56> # ProjectID "Project" GroupID "microsoft" TestID "delete" LogID "AUTO" ScreenSize 1440 900 FontSize 2 DeleteCache DeleteCookies # # Call login.evs script file actions, to get Signed in... # CallScript "login.evs" Wait 1000 # # Go to the "Public" folder... # FollowLink 0 245 "Public" "http://cid-636721b33b1d7b0a.skydrive.live.com" \ "/browse.aspx/.Public" "" Wait 4276 #FollowLink 0 309 "Presentation1" "http://cid-636721b33b1d7b0a.skydrive.l" \ # "ive.com/self.aspx/.Public/Presentation1.excelx" "" # # Replaced the above with INDEX MOTION sequences, need to be flexible with # Book# file(s)... # NOTE: (Deletion process will always start from the THIRD item forward...) # IndexSet 0 IndexFindElementEx 0 DOWN "name:title" "value:stuff" "name:tagName" "value:IMG" "" IndexMove +1 IndexFindElement 0 DOWN "tagName" "A" "" IndexMove +1 IndexFindElement 0 DOWN "tagName" "A" "" IndexFollowLink 0 "" # # Added Synchronization to await opening of the options panel before trying # to Delete... # Wait 2317 SyncOnElementProperty 0 "id" "c_PageTitle" "" ElementFocus 0 352 "" "" "" Wait 1350 # # Added a "NO_NAV" to this out-of-box recorded script command so that eValid # will not await javascript navigation complete signals, that may or may not # arrive... # FollowLink 0 160 "Delete" "javascript:void(0)" "" NO_NAV # # Relying on default Settings to automatically CLOSE out modal confirmation # delete pop-up window, otherwise the following script command alternatives # modal actions necessary... # #ModalDialogWait 1000 #ModalDialogEnter 0 Wait 4856 FollowLink 0 130 "sign out" "http://login.live.com/logout.srf?ct=1260480729&rver=5.5.4177.0&lc=1033&i" \ "d=250206&ru=http:%2F%2Fcid-636721b33b1d7b0a.skydrive.live.com%2Fbrowse.a" \ "spx%2F.Public&mkt=en-US" "" # Recording stopped at: <2009/12/10 13:32:45>

Screen Shots
Here are screen shots that show the progress of the playback of the goExcel1.evs script and the scripts it calls. All of the images show up in a separate window.

• Login1: Where the script begins playback.

  

• Login2: The Windows Live ID login page.

  

• Excel0: Right after logging into the account.

  

• Excel1: Select "SkyDrive" under the drop-down More... menu item.

  

• Excel2: Available working folders area.

  

• Excel3: Moving into the Public folder area.

  

• Excel4: Select to create a New.. Microsoft Excel workbook option.

  

• Excel5: Input the "Book2" name or accept "Default"...

  

• Excel6: Fully rendered and ready for "INPUT data" into the Excel workbook.

  

• Excel7 Adding "INPUT data" to the Excel workbook.

  

• Excel8: Maneuvering rows/columns and adding more "INPUT data" to the SpreadSheet.

  

• Signout: Excel working Book# is automatically saved upon signing out.

  

• Endplay: Playback Data Summary showing "Yellow Screen" Success

  

Additional Notes

1. The above scripts were recorded from life and then augmented to handle the SpreadSheet's cell text entry area. From life commands are left in the script as comments so you can see where they were replaced/augmented.

2. Playback is slightly depending on allowing the Waits to run as recorded. Improving the scripts so that you do not depend on Waits at all is technically possible but requires finding each de-synchronization point and replacing it with the appropriate signal's DOM processing command.

3. Playback is dependent upon TAB/SHIFT-TAB/ENTER to maneuver between each cell's row and column positionally, before text input is determined. To deviate from keyboard movements would require being able to uniquely find each cell's unique element attribute(s).

4. It appears that the SpreadSheet is not available for input until it is fully rendered... Thus relying on instances of a SyncOnText for the "Loading" signal is not enough, so various other synchronization points also included.