Web Automation Tips and Tricks

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

Using Web Automation to Login Gmail

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

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.

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

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

Right click on Button Login select click.

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.....