Jekib_70929_Consolidation_Exercise Jekib_70929_Consolidation_Exercise 2017-04-06 11:48:01Z 4 Jekib_70929_Consolidation_Exercise admin -4-1591.25Login To Order System301031.25Read CSV2105101.25Process Queue Data-85901.2515-3306030cd7fbd8a-1413-471b-91aa-13ece1b8305215306030-255-2851509096783d8e-8ef9-4668-9cb7-5d8335242a69Reading the Orders.csv file and adding the data to a work queue-195-1051509096783d8e-8ef9-4668-9cb7-5d8335242a6915-1656030e26ffb5b-d05c-4daa-9d34-c0257838c59596783d8e-8ef9-4668-9cb7-5d8335242a6915585603096783d8e-8ef9-4668-9cb7-5d8335242a69Create instance of the Excel file1560903061599498-3456-49b9-afe2-e9706cf32b2096783d8e-8ef9-4668-9cb7-5d8335242a69Opening the Order.csv WorkBook15120903062a01c69-bfcc-4ee9-8157-ef334d606ec496783d8e-8ef9-4668-9cb7-5d8335242a69285-1059030number96783d8e-8ef9-4668-9cb7-5d8335242a69390-1059030text96783d8e-8ef9-4668-9cb7-5d8335242a69Get data from Excel and save it to a collection151959030e2987f19-5381-475d-99c6-711286982f3a96783d8e-8ef9-4668-9cb7-5d8335242a69495-1059030collection96783d8e-8ef9-4668-9cb7-5d8335242a69Close the Excel file1551090304acdc94f-24d7-416e-940c-d7954d8f28a4For reading the Order.csv file and adding the data to queue15-240903047580424-0607-42a5-8aea-36f05ba5663296783d8e-8ef9-4668-9cb7-5d8335242a6996783d8e-8ef9-4668-9cb7-5d8335242a693301059030textEnvironment96783d8e-8ef9-4668-9cb7-5d8335242a69240-135300120Closing the order System15-459030128b19d5-90c5-484c-aa72-17f17200485c15164935-365d-4d6c-b242-a02ed5f7b54cProcess the data in the queue -420-1801509015164935-365d-4d6c-b242-a02ed5f7b54c-15-240603070e6ef3f-e77e-4011-a856-5076d8d0c8ed15164935-365d-4d6c-b242-a02ed5f7b54c135-45603096783d8e-8ef9-4668-9cb7-5d8335242a69270601509015164935-365d-4d6c-b242-a02ed5f7b54cGet the next item in the queue-15-13590304e92e1d4-cf42-48f0-8d6e-3e03e858c11a15164935-365d-4d6c-b242-a02ed5f7b54cCheck to see if the queue has any item-15-4590604ae5dddd-6eb1-4518-98a4-6ce6e25ca60a53bffae5-9e2a-4b83-926c-e7a6e6b8f1fd15164935-365d-4d6c-b242-a02ed5f7b54cMark the item as Completed -15495903028b1a0dc-60dd-4edd-b0c9-c9eb1c11d81615164935-365d-4d6c-b242-a02ed5f7b54c-27049510103d85b0cc-e488-4b88-a9b7-7a4b8443e63215164935-365d-4d6c-b242-a02ed5f7b54c-270-135101063096101-f780-4def-90f4-f3ac238a656096783d8e-8ef9-4668-9cb7-5d8335242a69Adding data to the queue1545090304bfe233e-8333-4ac9-bfec-b7abc605dc0596783d8e-8ef9-4668-9cb7-5d8335242a69285-456030collectionProcess the data from queue 15-10590304070a888-fe9a-4093-bd6e-9b159a3ef93915164935-365d-4d6c-b242-a02ed5f7b54c15164935-365d-4d6c-b242-a02ed5f7b54c-435-156030text15164935-365d-4d6c-b242-a02ed5f7b54c-360-156030collection15164935-365d-4d6c-b242-a02ed5f7b54c-435306030text15164935-365d-4d6c-b242-a02ed5f7b54c-435-606030number15164935-365d-4d6c-b242-a02ed5f7b54c-495-9018015015164935-365d-4d6c-b242-a02ed5f7b54c1351956030f6ff7ecd-bb53-4972-ad74-d1c099e8051315164935-365d-4d6c-b242-a02ed5f7b54c300-135603070e6ef3f-e77e-4011-a856-5076d8d0c8ed15164935-365d-4d6c-b242-a02ed5f7b54cMark the item as exception if exception occurs30019560303f06ac09-bdb8-4b02-9af2-7fd9a00a2db215164935-365d-4d6c-b242-a02ed5f7b54c-360306030text15164935-365d-4d6c-b242-a02ed5f7b54cNavigate to the New Order Screen -1519590305b53631b-2185-4e7b-b8b8-e68a95c1b0c415164935-365d-4d6c-b242-a02ed5f7b54cInput the details of the order and submit the order-1525590305864266c-c898-430a-b57b-1a40d75337e815164935-365d-4d6c-b242-a02ed5f7b54cGet the Order Reference Number-1531590307183effd-8cd5-4539-8a94-a3923c2013a015164935-365d-4d6c-b242-a02ed5f7b54c-360-606030text15164935-365d-4d6c-b242-a02ed5f7b54cAlert the reference number-1539060306eb2e431-fa15-447c-ab0b-3556f01e57bb15164935-365d-4d6c-b242-a02ed5f7b54c-9016527019515164935-365d-4d6c-b242-a02ed5f7b54cIf any data is blank or invalid then that row will be mark as exception-15909060b92f4f50-3204-400d-b0f1-06fa6add26246ba4b971-2aad-4dc3-b4de-5107428d3db115164935-365d-4d6c-b242-a02ed5f7b54c-18090603063096101-f780-4def-90f4-f3ac238a656015164935-365d-4d6c-b242-a02ed5f7b54c-180-135101070e6ef3f-e77e-4011-a856-5076d8d0c8ed96783d8e-8ef9-4668-9cb7-5d8335242a69Checking if the excel file exists or not15-1056030a481c75c-ac41-4426-8743-137c9493c58896783d8e-8ef9-4668-9cb7-5d8335242a69450-456030flag96783d8e-8ef9-4668-9cb7-5d8335242a6915-3060309abd0472-3af9-491e-9980-6ab879de40799fa955dc-29e3-4d01-bfc4-0fafd2598e8196783d8e-8ef9-4668-9cb7-5d8335242a69165-30903096783d8e-8ef9-4668-9cb7-5d8335242a69Checking if the excel file conatin any values or not1527090304ad2fb30-8c84-4c83-ac90-b8a08f72429496783d8e-8ef9-4668-9cb7-5d8335242a69375-456030number96783d8e-8ef9-4668-9cb7-5d8335242a691534560303a466553-6673-454a-b683-0379f5bc2db6efc1083d-7593-4e7d-a046-82ab0a73667796783d8e-8ef9-4668-9cb7-5d8335242a6916534590306895b879-b43c-464d-9e33-99e4c9e4f81eLogin to the Order System-495-105150906895b879-b43c-464d-9e33-99e4c9e4f81e15-10560305937eccb-39f4-4c14-9004-ca9194ef403c6895b879-b43c-464d-9e33-99e4c9e4f81e1531560306895b879-b43c-464d-9e33-99e4c9e4f81eLaunching the Order System151059030c5987ba1-666e-412d-85ca-2548d259dcef6895b879-b43c-464d-9e33-99e4c9e4f81eLog in to Order System152109030af62eb67-6765-45d3-9c1f-7de067ffa5b16895b879-b43c-464d-9e33-99e4c9e4f81eUsername that we get from the credentials-46506030textbp6895b879-b43c-464d-9e33-99e4c9e4f81ePassword that we get from the credentials-39006030password49,20,7,67,26,91,6,16895b879-b43c-464d-9e33-99e4c9e4f81e-12060315906895b879-b43c-464d-9e33-99e4c9e4f81e1351056030698c1f8a-e3f4-40ec-ba50-088842fd4d946895b879-b43c-464d-9e33-99e4c9e4f81e255060305937eccb-39f4-4c14-9004-ca9194ef403c6895b879-b43c-464d-9e33-99e4c9e4f81e255105603033230618-f47a-4f54-b6cf-2a74d0d100f916ee268f-f01c-46aa-9d35-0e54f6501c406895b879-b43c-464d-9e33-99e4c9e4f81e255606030979043c6-1164-4c8d-b4d2-85ff7f949d026895b879-b43c-464d-9e33-99e4c9e4f81eVariable for counter-465606060number16895b879-b43c-464d-9e33-99e4c9e4f81e40510590306895b879-b43c-464d-9e33-99e4c9e4f81e1501010e2460c87-50ee-4ba1-8bd7-4fbfeb06fb3cLogin to the order system15-1659030ed181e89-3964-4785-a7a7-b66f062596bf6895b879-b43c-464d-9e33-99e4c9e4f81e6895b879-b43c-464d-9e33-99e4c9e4f81e-525-30180135330-3159030number115164935-365d-4d6c-b242-a02ed5f7b54c-4201206030number270-34512010515164935-365d-4d6c-b242-a02ed5f7b54c-4809012060330-2709030number3 6d0538d0-a23f-4cdc-83b4-b053bf8be8f3c69b9533-cb46-4758-8a4f-723bc56b225f3d76d1a9-72e6-4278-86ae-d489098b4ef6EditEdittextFalsec4ec1ec8-df51-4491-9dc0-d1f3b23e460cEditEdittextFalse330fe616-5aa8-4c0e-baeb-d551cf641797ButtonButtontextFalseWindowWindowtextFalse31dd4368-0a08-463e-a4ce-93d17663a6856ecdd40a-e6c6-44ba-a9c8-57f8aadf9c82EditEdittextFalse450e36c1-eda7-4cc3-b8bd-829a051f2c8cButtonButtontextFalseWindowWindowtextFalsec73be845-4723-4394-a47d-8450690c02b399842d96-00d3-485c-93ea-f955e1e7c43dEditEdittextFalse4fc9475a-2b68-467e-a138-5a56160d0c15EditEdittextFalse51bc91c1-e7d4-456d-b731-1b40631b7c36EditEdittextFalse053394f2-c57c-4c14-afb3-9ed8559270a8EditEdittextFalsecfc67249-d531-44f9-a183-ca718e939b17ButtonButtontextFalseWindowWindowtextFalse735979cc-a2f8-4d9a-8e0e-a75d688c6ea7fe31d7ba-707c-4ef6-b16f-4020818535dcLabelLabeltextFalse1691f328-da01-4588-b13c-830a81da1ebfButtonButtontextFalseWindowWindowtextFalse67e26b42-b375-406f-ad9d-5c931c64ef82a4b688f4-11b3-4354-8758-2c6a5f7ac2caButtonButtontextFalseWindowWindowtextFalseApplicationApplicationunknownFalseWin32LaunchPathD:\Training\TrainingOrderSystem.exeCommandLineParamsWorkingDirectoryNonInvasiveTrueProcessModeInternal001.25Clean Up001.25Navigate Menu771011.25Terminate001.25Input Order-15151.25Order Confirmation0631.25Exit0501.25Launch208971.25Log In65211.2515-105603025a995f5-81e3-4db7-8146-fbc5d50e474c15906030-195-10515090System.Data.dllSystem.Xml.dllSystem.Drawing.dllSystemSystem.Drawingvisualbasic21a90e74-1fd6-46bb-abad-9bde09e3c6cf-195-1051509021a90e74-1fd6-46bb-abad-9bde09e3c6cf15-10560307d5c2502-ec3c-476a-9dc9-d0445cd3e45621a90e74-1fd6-46bb-abad-9bde09e3c6cf1590603059a5e9b5-6888-4c06-a2e1-bba726b9637cFor closing the system-195-1051509059a5e9b5-6888-4c06-a2e1-bba726b9637c15-1056030d9aca742-126b-4b26-a183-a243e4b2a24421a90e74-1fd6-46bb-abad-9bde09e3c6cfClean Up Page This is an optional page where you might choose to perform some finalisation (or "cleanup") tasks as your business object is closed down. The cleanup action will be called automatically immediately after closing your business object at the end of a business process. You will not be able to call this action from a business process, nor will it be called at any other time than before the disposal of the business object.-18060180230Initialise Page This is an optional page where you might choose to perform some initialisation tasks after your business object is loaded. The initialise action will be called automatically immediately after loading your business object. You will not be able to call this action from a business process, nor will it be called at any other time than after the creation of the object.-180601802305ffbc11b-56bc-4e46-a44c-37c2f3bc257eFor launching the Order system-195-105150905ffbc11b-56bc-4e46-a44c-37c2f3bc257e0-10560303d0c4c4c-e79b-45a4-b11c-c577016b6e0e4b9114af-262b-472f-a71d-01fb6915a303For logging into order system-195-105150904b9114af-262b-472f-a71d-01fb6915a30315-1506030ba7b5fc8-9cba-4b00-8a93-18d14264fcc14b9114af-262b-472f-a71d-01fb6915a30322513560304b9114af-262b-472f-a71d-01fb6915a303225-16512030text4b9114af-262b-472f-a71d-01fb6915a303225-10512030password4b9114af-262b-472f-a71d-01fb6915a30315-6090305946ca6a-dd16-4cb7-a2e2-30479608e7a64b9114af-262b-472f-a71d-01fb6915a3031509030fef60f89-f8d0-4ac1-ad97-704eee586b4bPress4b9114af-262b-472f-a71d-01fb6915a303151956060dacf9ad1-1311-4eb2-9c23-7b78e431d0a94edf3246-d9fe-48e4-acb3-1699ba2799574b9114af-262b-472f-a71d-01fb6915a303157560604edf3246-d9fe-48e4-acb3-1699ba279957Options Window Check Exists607f6416b6-4228-4261-8d16-65acee6655cbCheckExistsEqual[Timeout Global - M]4b9114af-262b-472f-a71d-01fb6915a3031527090305ffbc11b-56bc-4e46-a44c-37c2f3bc257e031560305ffbc11b-56bc-4e46-a44c-37c2f3bc257e0-30903096842dba-ca00-4fe8-ad5a-556e4f6f3f30IsConnected5ffbc11b-56bc-4e46-a44c-37c2f3bc257e255-909060flag5ffbc11b-56bc-4e46-a44c-37c2f3bc257e0759090136da7ad-d718-4b9f-9906-7c0e01947b5ba071f17a-dda1-4216-8e31-aa50245a3fc05ffbc11b-56bc-4e46-a44c-37c2f3bc257e1953151010136da7ad-d718-4b9f-9906-7c0e01947b5b5ffbc11b-56bc-4e46-a44c-37c2f3bc257e375756030cd751277-0d9f-42e8-845b-b6efb1f77f4c5ffbc11b-56bc-4e46-a44c-37c2f3bc257e375150603021a13240-45e5-486c-9d4e-470c130f1f62LaunchPathCommandLineParamsWorkingDirectoryNonInvasiveProcessMode5ffbc11b-56bc-4e46-a44c-37c2f3bc257e4353156030e8fd833c-7301-4c28-a54e-967e68e507e85ffbc11b-56bc-4e46-a44c-37c2f3bc257e49524060609701028f-e453-44bc-b41a-19e7ef4d6c6eb7181afe-9df3-4b5c-98be-63b61e3ea5215ffbc11b-56bc-4e46-a44c-37c2f3bc257e3752406060b7181afe-9df3-4b5c-98be-63b61e3ea521Log In Window Check Exists6082194494-ae2f-45b1-ba94-a2cf3ac3ccdaCheckExistsEqual[Timeout Global - M]5ffbc11b-56bc-4e46-a44c-37c2f3bc257e60024060305ffbc11b-56bc-4e46-a44c-37c2f3bc257e195756030e8fd833c-7301-4c28-a54e-967e68e507e8AttachApplicationWindowTitlesCollectionWindowTitle"Sign in"ProcessName"TrainingOrderSystem"ChildIndexe46aae75-3a07-4730-afe0-ccd3766178abBusiness object for putting value in option number and press go button-375-15015090e46aae75-3a07-4730-afe0-ccd3766178ab-135-16560307312d329-137b-4cb7-b2f6-4e59a59b67bde46aae75-3a07-4730-afe0-ccd3766178ab603606030e46aae75-3a07-4730-afe0-ccd3766178ab60-6060603ae2e471-c89a-4df5-940c-00fd5aa4d27bb90ee56b-e4b0-478b-9363-0a3828dc6145e46aae75-3a07-4730-afe0-ccd3766178abWait for Options Window-135-606060b90ee56b-e4b0-478b-9363-0a3828dc6145Options Window Check Exists105c4e8ad08-5963-4fb5-90ac-565f88c56f57CheckExistsEqual[Timeout Global - M]e46aae75-3a07-4730-afe0-ccd3766178abInput the value of Option Number-30135120303b9c7381-d99d-4db0-8e84-c719456cfae7e46aae75-3a07-4730-afe0-ccd3766178ab-30195120305fabd2c5-4133-4966-b0f7-ad81e48c8c64Presse46aae75-3a07-4730-afe0-ccd3766178abOptions Window doesnot exist210-6090303009012030number10300-3012030number13003012030number5225-75165225d9f51c7a-0b0c-45b4-849c-eb4c5373ef56Inputting the values in the new order screen and submit them-480-16515090d9f51c7a-0b0c-45b4-849c-eb4c5373ef56-270-1506030af5c4a28-ea0e-4afd-a088-3113da6d4198d9f51c7a-0b0c-45b4-849c-eb4c5373ef56-1053306030d9f51c7a-0b0c-45b4-849c-eb4c5373ef56-75-3060604a6f7b8d-7894-47cd-9c7a-1646744c8d0ddda81a52-ba9d-45cd-8b0b-dd2a136ab76ed9f51c7a-0b0c-45b4-849c-eb4c5373ef56-270-306060dda81a52-ba9d-45cd-8b0b-dd2a136ab76eNew Order Check Exists1055c2e7b3c-0b57-469b-b9cd-38160bd041e2CheckExistsEqual[Timeout Global - M]d9f51c7a-0b0c-45b4-849c-eb4c5373ef56Populate the input fields with values-1654512030e04ead18-37ac-47fd-9a98-8e4ce3d7379cd9f51c7a-0b0c-45b4-849c-eb4c5373ef56Click on Submit Order button-165105120303c2e78ee-e4d5-4baf-a9fc-3897ef622eacPressd9f51c7a-0b0c-45b4-849c-eb4c5373ef5675-30903073e1e56c-716e-4481-bf9f-806c1c3a082fFor getting the order reference number-195-1051509073e1e56c-716e-4481-bf9f-806c1c3a082f0-1656030b8a24fd5-51e7-4b68-b341-9e992ae333fc73e1e56c-716e-4481-bf9f-806c1c3a082f180390603073e1e56c-716e-4481-bf9f-806c1c3a082f21006060d75f93a4-5dbf-4d58-95c1-1d8f1da460edc1cee9b8-28e1-42d6-af47-04b416da691773e1e56c-716e-4481-bf9f-806c1c3a082fCheck to see if Order Confirmation Window is opened006060c1cee9b8-28e1-42d6-af47-04b416da6917Order Confirmation Check Exists1058638ab67-58c1-42ad-b054-9d4b433a411fCheckExistsEqual[Timeout Global - L]73e1e56c-716e-4481-bf9f-806c1c3a082f10590120308859e391-8574-44d8-be2c-fac27093c48dGetWindowText73e1e56c-716e-4481-bf9f-806c1c3a082f315-18012030text73e1e56c-716e-4481-bf9f-806c1c3a082f105165120308c4b2db6-ab42-4b12-8489-fed811d86b8173e1e56c-716e-4481-bf9f-806c1c3a082f25530060605a26fd32-b866-423f-84f1-9e375b28491b4c6f8cc5-1502-4905-a226-2cdd7df31e6173e1e56c-716e-4481-bf9f-806c1c3a082fCheck if order confirmation screen is closed10530060604c6f8cc5-1502-4905-a226-2cdd7df31e61Order Confirmation Check Exists7508c6a125-cce3-4166-b5c6-412abf0b0685CheckExistsEqual[Timeout Global - M]73e1e56c-716e-4481-bf9f-806c1c3a082f3600603073e1e56c-716e-4481-bf9f-806c1c3a082f375300603073e1e56c-716e-4481-bf9f-806c1c3a082f450-1806030text73e1e56c-716e-4481-bf9f-806c1c3a082fClick the button Continue10522512030d5fefbec-b02b-4247-9a73-ead58a84a7a4Presse46aae75-3a07-4730-afe0-ccd3766178ab-3060906061529075-de20-4a59-8315-dbb8daafc3a543081522-54a7-498a-90e5-e78b9e98977ae46aae75-3a07-4730-afe0-ccd3766178ab21060903059a5e9b5-6888-4c06-a2e1-bba726b9637c120195603059a5e9b5-6888-4c06-a2e1-bba726b9637c210-15606052a20039-e30c-4788-98d2-8c3df743bec32e9d494c-659e-4606-b3be-5b8d51b80c3d59a5e9b5-6888-4c06-a2e1-bba726b9637cWait for Options Window15-1560602e9d494c-659e-4606-b3be-5b8d51b80c3dOptions Window Check Exists1055a3d0d24-62a8-4e3e-b11c-5ad6adf5144eCheckExistsEqual[Timeout Global - M]59a5e9b5-6888-4c06-a2e1-bba726b9637cInput the value of Option Number1206012030a4eabc96-1736-4824-a42b-d9b0f798041d59a5e9b5-6888-4c06-a2e1-bba726b9637c1201201203080a0f9f1-c992-41e8-9b40-3697e3030dfaPress59a5e9b5-6888-4c06-a2e1-bba726b9637cOptions Window doesnot exist360-1590301fb2bada-e673-49d1-87f0-c6ba2cdc12daFor terminating the Order System-195-105150901fb2bada-e673-49d1-87f0-c6ba2cdc12da15-105603082c6d3c7-7249-4d32-813a-b691352c0fb41fb2bada-e673-49d1-87f0-c6ba2cdc12da159060301fb2bada-e673-49d1-87f0-c6ba2cdc12daTerminating the Order System15-156030c703b18e-aca4-48fc-8e2b-62421d7c39c5Terminate73e1e56c-716e-4481-bf9f-806c1c3a082f225-2251507573e1e56c-716e-4481-bf9f-806c1c3a082f390-2251057559a5e9b5-6888-4c06-a2e1-bba726b9637c270-150105605ffbc11b-56bc-4e46-a44c-37c2f3bc257e195-135135904b9114af-262b-472f-a71d-01fb6915a303150-19516512059a5e9b5-6888-4c06-a2e1-bba726b9637c315-1206030numbere46aae75-3a07-4730-afe0-ccd3766178ab135270606001e24361-cec6-46e9-a9fc-826c8acc93d7b5818afd-e0f9-4eb9-93c1-1be32a9eab2fe46aae75-3a07-4730-afe0-ccd3766178abWaiting for New Order Window-302706060b5818afd-e0f9-4eb9-93c1-1be32a9eab2fNew Order Check Exists9044971bb5-7e7a-479a-8cc1-2386fc61f4d1CheckExistsEqual[Timeout Global - M]e46aae75-3a07-4730-afe0-ccd3766178ab2402709030d9f51c7a-0b0c-45b4-849c-eb4c5373ef561501806060effa2d25-91bf-4c6d-a7c6-d67fc1049ad3fc88d041-223a-4c19-98c6-8754943942b7d9f51c7a-0b0c-45b4-849c-eb4c5373ef56Waiting for Order confirmation window and check for any warning -1651806060fc88d041-223a-4c19-98c6-8754943942b7Order Confirmation Check Exists605d9b6503-5f29-4fb2-8ca8-000c24d603d0CheckExistsEqualWarning Check Exists2252c1c7487-fb89-4178-9064-18ed821b37efCheckExistsEqual[Timeout Global - M]d9f51c7a-0b0c-45b4-849c-eb4c5373ef5625518090305ffbc11b-56bc-4e46-a44c-37c2f3bc257e1504527060d9f51c7a-0b0c-45b4-849c-eb4c5373ef56602556030a6697587-d075-4a28-9e3b-27a2a50e9a41Pressd9f51c7a-0b0c-45b4-849c-eb4c5373ef56603306030e46aae75-3a07-4730-afe0-ccd3766178ab375-13512030numbere46aae75-3a07-4730-afe0-ccd3766178ab285-18018090d9f51c7a-0b0c-45b4-849c-eb4c5373ef56Inputs to New Order90-195180105d9f51c7a-0b0c-45b4-849c-eb4c5373ef56135-1206030numberd9f51c7a-0b0c-45b4-849c-eb4c5373ef56210-1656030numberd9f51c7a-0b0c-45b4-849c-eb4c5373ef56135-1656030numberd9f51c7a-0b0c-45b4-849c-eb4c5373ef56210-1206030text The path to the Order.csv