MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Web Automation Tips and Tricks

Published on 13 January 13
524
0
0

Web Automation have four sections:

  1. Menu file will help you use some of feature of program like login, logout, register...,
  2. ToolBar menu will help you work with some item you will usually using like record, run,...,
  3. Web Browser will display website when you suffering,
  4. Developer Tools that place will automate every of program by JavaScript language

Web Automation Tips and Tricks - Image 1

Using Web Automation to Login Gmail

Open program and enter link http://www.gmail.com and click button go

Web Automation Tips and Tricks - Image 2

Right click every where on Web Browser, click Go then it show question "Do you want go to website?", if you choose yes it will get current URL you enter on the textbox, else it will get XPath of location where you right click then go to the link of the xpath.


Web Automation Tips and Tricks - Image 3


Then it will show you Developer Tools with code JavaScript to control this function

Web Automation Tips and Tricks - Image 4


Right click on textbox username, click fill, enter username then click ok, repeat for password

Web Automation Tips and Tricks - Image 5

Right click on Button Login select click.

Web Automation Tips and Tricks - Image 6

You must enter two line to ensure website load done before you continue, then you click Run and then program will go to Gmail for you.

go("https://accounts.google.com/ServiceLogin?service=mail&passive=true&rm=false&continue=http://mail.google.com/mail/&scc=1&ltmpl=default&ltmplcache=2"); sleep(5,false); fill("/html/body/div/div[2]/div/div/form/div/input","thang@gmail.com"); fill("/html/body/div/div[2]/div/div/form/div[2]/input","password"); sleep(5,false); click("/html/body/div/div[2]/div/div/form/input[12]");

What do you do with Web Automation?

Here is function of Web Automation, you can try by write function bellow with your parameter then click run and see what happen, notes some function need authentication to work like function number: 59 to 64, rest of another function you don't need to login.

  1. Open new tab: tabnew();
  2. Close current tab: tabclose();
  3. Go to website by url or xpath: go(url); or go(xpath);
  4. Go back: back();
  5. Go next: next();
  6. Reload browser: reload();
  7. Stop browser: stop();
  8. Wait until Web Browser has loaded or timer to wait Web Browser load: sleep(seconds, isBreakWhenWBCompleted)
  9. Close application: exit();
  10. Click to element: click(xpath);
  11. Write log to Preview Tab: log(value);
  12. Clear log write on Preview: clearlog();
  13. Extract data from xpath: extract(xpath);
  14. Fill data to element on Web Browser: fill(xpath, value);
  15. Select dropdown value: filldropdown(xpath, index);
  16. Convert string to Object javascript: toObject(xpath);
  17. Get all link in the area of xpath, it will stop until program go all of link : browser(xpath);
  18. Reset list website to unread so program can go back and browser continue : resetlistwebsite();
  19. Take snapshot of website: takesnapshot(url);
  20. Create folder: createfolder(path);
  21. Get list folder from path: getfolders(path);
  22. Create file: save(content, location, isOverride);
  23. Get list file from path: getfiles(path);
  24. Download a file: download(url, location);
  25. Read file: read(path);
  26. Remove file: remove(path);
  27. Remove folder: removefolder(path);
  28. Open explorer and select file: explorer(path);
  29. Run code from string: excute(code);
  30. Logoff: logoff();
  31. Lockworkstation: lockworkstation();
  32. Forcelogoff: forcelogoff();
  33. Reboot: reboot();
  34. Shutdown: shutdown();
  35. Hibernate: hibernate();
  36. Standby: standby();
  37. Run application: runcommand(path);
  38. Get current url of current tab: getcurrenturl();
  39. Get browser height: getheight();
  40. Get title of website: gettitle();
  41. Get all link from xpath: getlinks(xpath);
  42. Get content of web browser: getCurrentContent();
  43. Get path of Web Automation: getCurrentPath();
  44. Read cell of excel file: readCellExcel(path, sheetname, row, column);
  45. Write excel file: writeCellExcel(path, sheetname, cellname, value);
  46. Load HTML file: loadHTML(path);
  47. Convert json string to Object: textToJSON(jsonstring);
  48. Login: login(username, password);
  49. Register: register(username, email, password, confirm);
  50. OCR: ocr(path, language);
  51. Mouse Up: MouseUp(mouseButton, lastTime);
  52. Mouse Down: MouseDown(mouseButton, lastTime);
  53. Mouse Click: MouseClick(mouseButton, lastTime);
  54. Mouse Doble Click: MouseDoubleClick(mouseButton, lastTime);
  55. Mouse Move: MouseMove(x, y, isShow, lastTime);
  56. Mouse Wheel: MouseWheel(delta, lastTime);
  57. Key Down: KeyDown(delta, lastTime);
  58. Key Up: KeyUp(delta, lastTime);
  59. Get Account By: getAccountBy(name);
  60. Get Database: getDatabases(name);
  61. Get Tables: getTables(name, dbName);
  62. Get Columns: getColumns(name, dbName, table);
  63. Get Rows: getRows(name, dbName, sql);
  64. Excute SQL Query: excuteQuery(name, dbName, sql);

That all function of Web Automation, every function is javascript function so it have return or not return value, some time you get value is string, some time you will get value is object, it base on my C# function.


By combine each function together you can automate alot of thing, automate fill textbox, click button, extract any kind of data, automate create, delete, file, folder, automate extract data from website and save it to excel file easily, update data to excel file, read data from excel file, control your mouse, your keyboard.....


I try to include all knowledge I learn on my program like OCR, Text To Speech, Speech To Text,... My program can be expand by add function on javascript then add function on C# to solve some algorithm.



---------
This article is brought to you by Äinh Công Thắng, Software Developer CSC Viet Nam. This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)









Web Automation have four sections:

  1. Menu file will help you use some of feature of program like login, logout, register...,
  2. ToolBar menu will help you work with some item you will usually using like record, run,...,
  3. Web Browser will display website when you suffering,
  4. Developer Tools that place will automate every of program by JavaScript language


Web Automation Tips and Tricks - Image 1

Using Web Automation to Login Gmail

Open program and enter link http://www.gmail.com and click button go

Web Automation Tips and Tricks - Image 2

Right click every where on Web Browser, click Go then it show question "Do you want go to website?", if you choose yes it will get current URL you enter on the textbox, else it will get XPath of location where you right click then go to the link of the xpath.

Web Automation Tips and Tricks - Image 3

Then it will show you Developer Tools with code JavaScript to control this function

Web Automation Tips and Tricks - Image 4

Right click on textbox username, click fill, enter username then click ok, repeat for password

Web Automation Tips and Tricks - Image 5

Right click on Button Login select click.

Web Automation Tips and Tricks - Image 6

You must enter two line to ensure website load done before you continue, then you click Run and then program will go to Gmail for you.

go("https://accounts.google.com/ServiceLogin?service=mail&passive=true&rm=false&continue=http://mail.google.com/mail/&scc=1&ltmpl=default&ltmplcache=2"); sleep(5,false); fill("/html/body/div/div[2]/div/div/form/div/input","thang@gmail.com"); fill("/html/body/div/div[2]/div/div/form/div[2]/input","password"); sleep(5,false); click("/html/body/div/div[2]/div/div/form/input[12]");What do you do with Web Automation?

Here is function of Web Automation, you can try by write function bellow with your parameter then click run and see what happen, notes some function need authentication to work like function number: 59 to 64, rest of another function you don't need to login.

  1. Open new tab: tabnew();
  2. Close current tab: tabclose();
  3. Go to website by url or xpath: go(url); or go(xpath);
  4. Go back: back();
  5. Go next: next();
  6. Reload browser: reload();
  7. Stop browser: stop();
  8. Wait until Web Browser has loaded or timer to wait Web Browser load: sleep(seconds, isBreakWhenWBCompleted)
  9. Close application: exit();
  10. Click to element: click(xpath);
  11. Write log to Preview Tab: log(value);
  12. Clear log write on Preview: clearlog();
  13. Extract data from xpath: extract(xpath);
  14. Fill data to element on Web Browser: fill(xpath, value);
  15. Select dropdown value: filldropdown(xpath, index);
  16. Convert string to Object javascript: toObject(xpath);
  17. Get all link in the area of xpath, it will stop until program go all of link : browser(xpath);
  18. Reset list website to unread so program can go back and browser continue : resetlistwebsite();
  19. Take snapshot of website: takesnapshot(url);
  20. Create folder: createfolder(path);
  21. Get list folder from path: getfolders(path);
  22. Create file: save(content, location, isOverride);
  23. Get list file from path: getfiles(path);
  24. Download a file: download(url, location);
  25. Read file: read(path);
  26. Remove file: remove(path);
  27. Remove folder: removefolder(path);
  28. Open explorer and select file: explorer(path);
  29. Run code from string: excute(code);
  30. Logoff: logoff();
  31. Lockworkstation: lockworkstation();
  32. Forcelogoff: forcelogoff();
  33. Reboot: reboot();
  34. Shutdown: shutdown();
  35. Hibernate: hibernate();
  36. Standby: standby();
  37. Run application: runcommand(path);
  38. Get current url of current tab: getcurrenturl();
  39. Get browser height: getheight();
  40. Get title of website: gettitle();
  41. Get all link from xpath: getlinks(xpath);
  42. Get content of web browser: getCurrentContent();
  43. Get path of Web Automation: getCurrentPath();
  44. Read cell of excel file: readCellExcel(path, sheetname, row, column);
  45. Write excel file: writeCellExcel(path, sheetname, cellname, value);
  46. Load HTML file: loadHTML(path);
  47. Convert json string to Object: textToJSON(jsonstring);
  48. Login: login(username, password);
  49. Register: register(username, email, password, confirm);
  50. OCR: ocr(path, language);
  51. Mouse Up: MouseUp(mouseButton, lastTime);
  52. Mouse Down: MouseDown(mouseButton, lastTime);
  53. Mouse Click: MouseClick(mouseButton, lastTime);
  54. Mouse Doble Click: MouseDoubleClick(mouseButton, lastTime);
  55. Mouse Move: MouseMove(x, y, isShow, lastTime);
  56. Mouse Wheel: MouseWheel(delta, lastTime);
  57. Key Down: KeyDown(delta, lastTime);
  58. Key Up: KeyUp(delta, lastTime);
  59. Get Account By: getAccountBy(name);
  60. Get Database: getDatabases(name);
  61. Get Tables: getTables(name, dbName);
  62. Get Columns: getColumns(name, dbName, table);
  63. Get Rows: getRows(name, dbName, sql);
  64. Excute SQL Query: excuteQuery(name, dbName, sql);
That all function of Web Automation, every function is javascript function so it have return or not return value, some time you get value is string, some time you will get value is object, it base on my C# function.

By combine each function together you can automate alot of thing, automate fill textbox, click button, extract any kind of data, automate create, delete, file, folder, automate extract data from website and save it to excel file easily, update data to excel file, read data from excel file, control your mouse, your keyboard.....

I try to include all knowledge I learn on my program like OCR, Text To Speech, Speech To Text,... My program can be expand by add function on javascript then add function on C# to solve some algorithm.

---------This article is brought to you by Äinh Công Thắng, Software Developer CSC Viet Nam. This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



This blog is listed under Development & Implementations and Quality Assurance & Testing Community

Related Posts:
Post a Comment

Please notify me the replies via email.

Important:
  • We hope the conversations that take place on MyTechLogy.com will be constructive and thought-provoking.
  • To ensure the quality of the discussion, our moderators may review/edit the comments for clarity and relevance.
  • Comments that are promotional, mean-spirited, or off-topic may be deleted per the moderators' judgment.
You may also be interested in
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top