RPA with Blue Prism Class Room Demos 2017-11-28 07:34:48Z 2 RPA with Blue Prism Training admin -150-441.25-285-1956030abe4f2cc-3915-43ce-a1fc-fdfacf267cac1351056030-510-19515090-285-1356030

05b42f54-7361-471f-bcc3-2158ea942f77-120-756030number-285-906030

0333259b-c78a-4c4e-a9cc-2676c61f2e99-120-306030text-285-456030

6d6c65df-11bd-43af-8a21-574369a6499a-120156030collection4510560303bcfcd41-449b-4630-b3ee-9deb718fb125-1201056030b916f7b2-2d07-48bb-b068-7139c6a7ca73-451056030445d73c3-4565-41f6-86a1-d903949faaac-28506030cb473e06-3f87-4e39-9b78-37526f087c9694c98db2-adf0-4f9f-8ecc-e68914b925aaForEachData-2851056030583efcfb-168a-4ee6-b5f2-f402fa39eba794c98db2-adf0-4f9f-8ecc-e68914b925aa-285456030

ad6a3c03-b7f4-43ea-b7dd-81855c35571b-195105603014ac62aa-94ce-4ddb-93eb-406bd715ac6e-120-1206030textC:\BluePrism\Training\Applications\CurrencyConverter\CurrencyInfo.xlsx 001.2515-1056030b7171326-aef7-4cc7-81fa-0b530df0e61c15906030-195-10515090150-756030number0150-306030number0150156030number015-459030e72bdfbd-0a37-414c-8866-738b40cb5b751509030f550a5ac-4287-42ba-9e05-e068f034f83215456030f3a97008-1ffb-4859-9727-d7f6e203b308 001.25ReadExcel001.25Add Collection to Queue001.25Open OrderSystem Application001.25Sedning Queue Elements To Business Object4011.2515-105603067347094-bd12-46b0-88c6-c0fa7cbce45b151206030-195-105150903772917e-8353-48a2-9bd2-bbe6e667b9b7-195-105150903772917e-8353-48a2-9bd2-bbe6e667b9b715-10560305f451b17-ba89-439c-b48d-5fbfced946993772917e-8353-48a2-9bd2-bbe6e667b9b71515060303772917e-8353-48a2-9bd2-bbe6e667b9b715-456030

d3da385e-e90b-4c20-b02c-894a1977c1513772917e-8353-48a2-9bd2-bbe6e667b9b7135-456030number3772917e-8353-48a2-9bd2-bbe6e667b9b71506030

7abe83cc-97dd-4aef-a91c-6467cafa5a5c3772917e-8353-48a2-9bd2-bbe6e667b9b713506030text3772917e-8353-48a2-9bd2-bbe6e667b9b7135-906030textC:\BluePrism\Training\Applications\Windows\Orders.csv3772917e-8353-48a2-9bd2-bbe6e667b9b715456030

ed316da2-c8f1-4838-b432-b50f3449d9fd3772917e-8353-48a2-9bd2-bbe6e667b9b7135456030collection15-6060302918436d-04a8-44b1-a5cb-5750a510b3f93772917e-8353-48a2-9bd2-bbe6e667b9b73772917e-8353-48a2-9bd2-bbe6e667b9b715906030e4930b9c-b591-4e4c-acc9-727eb14c836d3ca6f789-5ca1-482d-a4fe-853f44275c27-195-105150903ca6f789-5ca1-482d-a4fe-853f44275c2715-1056030c6db317e-b3a0-43b5-9e50-01f6674a30213ca6f789-5ca1-482d-a4fe-853f44275c27159060303ca6f789-5ca1-482d-a4fe-853f44275c2715-306030

b478e75d-6e93-464a-b158-3c43685296223ca6f789-5ca1-482d-a4fe-853f44275c27120-306030collection2e8e8517-b00e-4862-a2f2-a00e09f18579-330-105150902e8e8517-b00e-4862-a2f2-a00e09f18579-15-16560300af69b6d-ad92-4b3d-a339-a496bacb4d272e8e8517-b00e-4862-a2f2-a00e09f18579-135-6060305b2031eb-8030-4795-a2b0-758cd1988d1b-195-105150905b2031eb-8030-4795-a2b0-758cd1988d1b15-1056030c687f425-6617-4476-8973-6041144602f45b2031eb-8030-4795-a2b0-758cd1988d1b159060305b2031eb-8030-4795-a2b0-758cd1988d1b15-306030c600eea9-0a26-45e2-bb97-99573de754e42e8e8517-b00e-4862-a2f2-a00e09f18579-1506030cdedaab3-4f79-4306-b2c6-5b977cfc18092e8e8517-b00e-4862-a2f2-a00e09f18579-15-1056030

90f8376c-dd13-4582-a8e4-9c2a372921602e8e8517-b00e-4862-a2f2-a00e09f18579255-456030collection2e8e8517-b00e-4862-a2f2-a00e09f18579-15606030969bdb0c-035a-4bb5-9013-2df8b6675e5a2e8e8517-b00e-4862-a2f2-a00e09f18579-151056030

9f029bbc-2846-47ee-85bc-620512b8b0872e8e8517-b00e-4862-a2f2-a00e09f18579225909030text2e8e8517-b00e-4862-a2f2-a00e09f18579-151506030aa933763-1f3e-4231-9296-a2f306b4b8432e8e8517-b00e-4862-a2f2-a00e09f18579180-456030text2e8e8517-b00e-4862-a2f2-a00e09f18579-15-60603053a01c0e-1cb8-4f9a-9cef-4998b107b7437790d08f-f769-429d-9646-5982447a635a15-156030c40a45fe-d096-4103-9281-f5054c0c45e83ca6f789-5ca1-482d-a4fe-853f44275c2715306030a5ff74f9-6486-47a0-871f-acfa8c71e1e75b2031eb-8030-4795-a2b0-758cd1988d1b1575603073262fda-6e34-46d9-850a-4eb8e3a6d79e2e8e8517-b00e-4862-a2f2-a00e09f18579135-156030textQueue12e8e8517-b00e-4862-a2f2-a00e09f1857990-10510100af69b6d-ad92-4b3d-a339-a496bacb4d272e8e8517-b00e-4862-a2f2-a00e09f185799015010104285420c-af35-432e-8a54-99122231ef48 001.2515-105603078b5a90c-3d82-4199-b763-769b2bb2dfc0151356030-195-10515090120156030e669acb4-68b5-4d71-be3e-fb2d907d78e8-120159030timeEnvironment151560303bdadf09-58b2-4b99-bde5-43d273d07920cb44fb61-9a04-4726-b35f-8c7bbd09c251120-60101078b5a90c-3d82-4199-b763-769b2bb2dfc015-6010104b96c0dc-ca34-4f0e-9f6b-0ab4da4260e2 001.2515-105603078b5a90c-3d82-4199-b763-769b2bb2dfc0151356030-195-10515090120156030e669acb4-68b5-4d71-be3e-fb2d907d78e8-120159030time14:27:00Session151560303bdadf09-58b2-4b99-bde5-43d273d07920cb44fb61-9a04-4726-b35f-8c7bbd09c251120-60101078b5a90c-3d82-4199-b763-769b2bb2dfc015-6010104b96c0dc-ca34-4f0e-9f6b-0ab4da4260e2 001.2515-10560306f9f1395-1206-4ba5-9c2a-139392b17d4215906030-195-1051509015-15603053340787-3136-4597-b4ea-47f596e24b5a-120-156030number 001.2515-1056030ff260f5b-da0b-49cc-a27a-6eae948d812115906030-195-10515090-120012060text"Welcome to Blueprism Foundation Training"-120606030number015-156030

590792a9-7b97-4f68-8882-c6ecdbd9346b 001.2515-1056030bcf4b115-bcef-4bbf-8182-2aad5b1e027115906030-195-1051509015-156030bc5cf62b-7bfb-439a-9ec4-ea56a9a2ff1d 0541.2515-10560304f947927-f780-4d16-adc2-95485416887a1352106030-165-7515090240-9012030textWelcome To Blueprism15-3012030cc192180-9dd3-455d-805a-f3dbff3bad3f240-3012030number025521012030number1240456030number015451206010d61482-1990-4eda-9a4e-6f3259f03396ccb97c47-b78e-4bf9-9dd2-030b5438ac2c1521060302455fcd7-a313-4e0b-8c5b-9a8b79ddfbbe1513512060fec2d574-e890-4673-a699-e9a77b4ad7372455fcd7-a313-4e0b-8c5b-9a8b79ddfbbe135135101008d142bf-d0aa-4944-bfd0-bef374e0cfba-1351356030cc192180-9dd3-455d-805a-f3dbff3bad3f 001.2515-105603022cdb6f2-167d-49d8-86b5-e96110b42e32151356030-150-9015090180012060collection15-4560307a0550c8-8a46-453f-9315-b84f3687de57e91e4d9f-2fc4-489a-b78d-7fd592075f76ForEachEmployee Details15906030d85462b7-5560-41f8-b24d-cc0ca2f75ea3e91e4d9f-2fc4-489a-b78d-7fd592075f76180-609030number2180609030text150903054058144-ce78-4252-a398-a5a95193b18606672f54-d376-4695-80c8-80412424be07-105451503006672f54-d376-4695-80c8-80412424be07 801.2515-105603013edc473-10c3-4ecd-be3e-9ff92075c15015906030-195-1051509015-1560305022c1d1-92b3-4c8e-af24-8a661aea4fee90-306030number195-301203085ba4d1f-7aba-4be3-957c-86724905733b195-105603078664594-c50c-4621-b02e-a28be11270b01959060305022c1d1-92b3-4c8e-af24-8a661aea4fee19530603082b9caed-9407-4ed2-a7b5-9449002f9c5890156030text -8201.25-75-12060309cf4e4b1-69b1-49d5-9e35-0e6946e7d25b-75756030-345-12015090-75060305022c1d1-92b3-4c8e-af24-8a661aea4fee-1506030number150-120603085ba4d1f-7aba-4be3-957c-86724905733b1507560305022c1d1-92b3-4c8e-af24-8a661aea4fee150-45603082b9caed-9407-4ed2-a7b5-9449002f9c5819506030text-75-60120307f18b660-56e9-46ad-ad8b-db96bfd6a1d313edc473-10c3-4ecd-be3e-9ff92075c150-180-606030number10-18006030number045-606030 -18301.25Square a Number -282-1211.25-345-16560300da860b2-fd61-4fd5-a466-f0c3eb9ebb30-3451206030-105-120150906749e506-2ba5-430a-a7bf-bba99dfa369fSub page which calculates Square for the given input number-525-240150906749e506-2ba5-430a-a7bf-bba99dfa369f-330-2706030d81feef2-9fba-4ab8-8c50-15a0bdfc09796749e506-2ba5-430a-a7bf-bba99dfa369f-330-756030

6749e506-2ba5-430a-a7bf-bba99dfa369f-210-2259030number6749e506-2ba5-430a-a7bf-bba99dfa369f-210-1206030number6749e506-2ba5-430a-a7bf-bba99dfa369f-330-1806030aa8a2f00-8248-4728-b8a1-1a455a5609e3-345-306030

e4a2652a-7984-4fa0-ac85-89fa6b29f8f76749e506-2ba5-430a-a7bf-bba99dfa369f-225-306030number-495-306030number5-345-9090607d6a6633-531a-48a8-84d0-17015b6388a726ca6b7c-a52a-4434-8f57-8289b31077e5-210609030number0-495-756030number1-345156030b3823c71-b63b-4ee0-b2d2-af9349834188-345606030af223c84-827f-4aa4-b282-c0ed2a3277fe-270601010f57e1a88-ac5a-41f4-a3f9-d615d5ca2360-270-9010100da860b2-fd61-4fd5-a466-f0c3eb9ebb30-435-9010105775a295-bf59-471c-bebf-c53074e51f9b-435120101095db83f4-a468-40dc-b5e0-a87f9438b884 001.2515-10560307ba2bc5b-bb39-4bfe-b174-eee0dfab5e0115306030-195-1051509015-456030dc51d6a8-332f-4571-b90c-5c4335e261bb 001.25Find Quotient001.25-60-15060302e7f7bb4-bd2d-48b3-b73c-b1d0cb196de2-60456030-195-10515090c2056986-8d52-4637-bb13-e82ab9b1f602-195-10515090c2056986-8d52-4637-bb13-e82ab9b1f60215-756030450f7c36-b537-4724-b051-3e45eb438058c2056986-8d52-4637-bb13-e82ab9b1f60215906030c2056986-8d52-4637-bb13-e82ab9b1f602151560305dd2e076-01d8-42a0-99f7-73d9df31c5d8c2056986-8d52-4637-bb13-e82ab9b1f602-60156030number-60-6060306bd7c5c3-41d4-4262-b914-4ae60f71d115c2056986-8d52-4637-bb13-e82ab9b1f602c2056986-8d52-4637-bb13-e82ab9b1f602120-1206030d58ef8f4-48d2-4d54-86f7-e285efc23d3dc2056986-8d52-4637-bb13-e82ab9b1f6021209060305dd2e076-01d8-42a0-99f7-73d9df31c5d8135-156030text60-6060304d1e32fe-fa2e-4f03-a752-89e90f2cc75d604560306bd7c5c3-41d4-4262-b914-4ae60f71d11560-15603003950d5d-2205-4655-a716-d81df2ae99b8c2056986-8d52-4637-bb13-e82ab9b1f602120-606030335cb0f7-8a36-42b0-9391-9ea8eb6be3669904f222-dad6-4098-9bd2-195fd73cee47c2056986-8d52-4637-bb13-e82ab9b1f602210-606030c2056986-8d52-4637-bb13-e82ab9b1f602120156030e01c3ad2-4d2d-4b13-8720-63fe744c88c9c2056986-8d52-4637-bb13-e82ab9b1f602195156030text -25-191.25-300-150150900-1356030450f7c36-b537-4724-b051-3e45eb43805801206030Divide by zero0-759030cbfd1356-5976-4c07-9543-2a444ce56b85195156030number105-7560309904f222-dad6-4098-9bd2-195fd73cee47105156030cbfd1356-5976-4c07-9543-2a444ce56b85105-306030e01c3ad2-4d2d-4b13-8720-63fe744c88c91659015090text195-756030number10195-306030number001560305dd2e076-01d8-42a0-99f7-73d9df31c5d8-1201560305530aaf3-189a-49fc-a0b2-ccc3da253a50-12012060305dd2e076-01d8-42a0-99f7-73d9df31c5d8-180-1522560-1207560303c0e2def-75a6-4995-afbe-b875b73315ba 001.25ReadExcel001.25Add Collection to Queue001.25Open OrderSystem Application001.25Sedning Queue Elements To Business Object6731.2515-105603067347094-bd12-46b0-88c6-c0fa7cbce45b151206030-195-105150903772917e-8353-48a2-9bd2-bbe6e667b9b7-195-105150903772917e-8353-48a2-9bd2-bbe6e667b9b715-10560305f451b17-ba89-439c-b48d-5fbfced946993772917e-8353-48a2-9bd2-bbe6e667b9b71515060303772917e-8353-48a2-9bd2-bbe6e667b9b715-456030

d3da385e-e90b-4c20-b02c-894a1977c1513772917e-8353-48a2-9bd2-bbe6e667b9b7135-456030number3772917e-8353-48a2-9bd2-bbe6e667b9b71506030

7abe83cc-97dd-4aef-a91c-6467cafa5a5c3772917e-8353-48a2-9bd2-bbe6e667b9b713506030text3772917e-8353-48a2-9bd2-bbe6e667b9b7135-906030textC:\BluePrism\Training\Applications\TrainingOrderSystem\Orders.csv3772917e-8353-48a2-9bd2-bbe6e667b9b715456030

ed316da2-c8f1-4838-b432-b50f3449d9fd3772917e-8353-48a2-9bd2-bbe6e667b9b7135456030collection15-6060302918436d-04a8-44b1-a5cb-5750a510b3f93772917e-8353-48a2-9bd2-bbe6e667b9b73772917e-8353-48a2-9bd2-bbe6e667b9b715906030e4930b9c-b591-4e4c-acc9-727eb14c836d3ca6f789-5ca1-482d-a4fe-853f44275c27-195-105150903ca6f789-5ca1-482d-a4fe-853f44275c2715-1056030c6db317e-b3a0-43b5-9e50-01f6674a30213ca6f789-5ca1-482d-a4fe-853f44275c27159060303ca6f789-5ca1-482d-a4fe-853f44275c2715-306030

b478e75d-6e93-464a-b158-3c43685296223ca6f789-5ca1-482d-a4fe-853f44275c27120-306030collection2e8e8517-b00e-4862-a2f2-a00e09f18579-330-105150902e8e8517-b00e-4862-a2f2-a00e09f18579-15-16560300af69b6d-ad92-4b3d-a339-a496bacb4d272e8e8517-b00e-4862-a2f2-a00e09f18579-135-6060305b2031eb-8030-4795-a2b0-758cd1988d1b-195-105150905b2031eb-8030-4795-a2b0-758cd1988d1b15-1056030c687f425-6617-4476-8973-6041144602f45b2031eb-8030-4795-a2b0-758cd1988d1b159060305b2031eb-8030-4795-a2b0-758cd1988d1b15-306030c600eea9-0a26-45e2-bb97-99573de754e42e8e8517-b00e-4862-a2f2-a00e09f18579-1506030cdedaab3-4f79-4306-b2c6-5b977cfc18092e8e8517-b00e-4862-a2f2-a00e09f18579-15-1056030

90f8376c-dd13-4582-a8e4-9c2a372921602e8e8517-b00e-4862-a2f2-a00e09f18579255-456030collection2e8e8517-b00e-4862-a2f2-a00e09f18579-15606030969bdb0c-035a-4bb5-9013-2df8b6675e5a2e8e8517-b00e-4862-a2f2-a00e09f18579-151056030

9f029bbc-2846-47ee-85bc-620512b8b0872e8e8517-b00e-4862-a2f2-a00e09f18579225909030text2e8e8517-b00e-4862-a2f2-a00e09f18579-151506030aa933763-1f3e-4231-9296-a2f306b4b8432e8e8517-b00e-4862-a2f2-a00e09f18579180-456030text2e8e8517-b00e-4862-a2f2-a00e09f18579-15-60603053a01c0e-1cb8-4f9a-9cef-4998b107b7437790d08f-f769-429d-9646-5982447a635a15-156030c40a45fe-d096-4103-9281-f5054c0c45e83ca6f789-5ca1-482d-a4fe-853f44275c2715306030a5ff74f9-6486-47a0-871f-acfa8c71e1e75b2031eb-8030-4795-a2b0-758cd1988d1b1575603073262fda-6e34-46d9-850a-4eb8e3a6d79e2e8e8517-b00e-4862-a2f2-a00e09f18579135-159030textQueue12e8e8517-b00e-4862-a2f2-a00e09f1857990-10510100af69b6d-ad92-4b3d-a339-a496bacb4d272e8e8517-b00e-4862-a2f2-a00e09f185799015010104285420c-af35-432e-8a54-99122231ef48 175-61.25-15-1956030a7ced5b3-aa8e-463c-b339-21590ed975d2-152256030-195-10515090195456030collection-15756030

dec82ccb-7a94-4707-85fc-946458b3e0af195-156030textC:\BluePrism\Training\Applications\EnvironmentLock\Test.txt-15156030d992598c-7e7b-444d-aac2-17c10638167aa72634cb-962f-4925-b7dd-83d3d68f2733ForEachCustomer Details-15135603053b199a9-161c-4d31-a4e2-0dd02958f061a72634cb-962f-4925-b7dd-83d3d68f2733-15-1356030

c6b831b8-43ac-49a7-890c-3842f38cb8a8150-1356030textUser Defined Lock Name240-1356030flag-15-756030d1b80f3e-c653-4c6b-8f22-e69dd383fdd95a9ad49d-8fd8-4ad4-9a55-073cbacb997a60-1051010a7ced5b3-aa8e-463c-b339-21590ed975d2-15-306030

6d18c16a-61a9-4afe-9dce-6029fe547fa7315-1356030text-1518060305a8bc7f6-a086-4ef7-87b6-024e0704a94f7545603002b30031-5b9b-4ecb-b84f-a68ae4da31af 1301041.2515-105603030977b25-b740-47b2-bec0-9eab1a34989d-195-10515090153006030151506030

3f2c4951-fbcf-4d6d-8733-e8c9060f9243151056030903064e6-f5ac-4eed-9743-d5eaab9d3421745e4f7c-8c45-48e1-bad1-edf657c4378eForEachCustomer Details1519560309e4725eb-49de-4cf2-a7e8-48652cf84a61745e4f7c-8c45-48e1-bad1-edf657c4378e15-606030

25016fa7-05ed-43bb-948e-74f053bf76e11506030e25b4169-ea2c-41e9-af5c-c1d2c913d774554218cc-7998-4585-86f2-aba871b7b5e590-30101030977b25-b740-47b2-bec0-9eab1a34989d15456030

817e9f6e-8826-4fdf-9629-5f0bf15cdd391524060304a7387f1-5608-43c9-9c8c-51a7bfdda0e3240756030collection240156030textC:\BluePrism\Training\Applications\EnvironmentLock\Test.txt195-606030textUser Defined Lock Name270-606030flag360-606030text 001.25Populate Queue (add items all at once)0561.25Populate Queue (add items one at a time)0841.25Populate Queue (add items with a new key field)0421.25Populate Queue (add items with a tag)01041.25Populate Queue (add items with a status)01681.25Populate Queue (add items with a priority)512960.8Populate Queue (add items with a deferral date)0620.8Populate Queue (add items using different collections)111940.8Populate Queue (ignore blank rows)512131.2Populate Queue (ignore duplicate item key)511651.1Populate Queue (mark duplicate item key)511171.2Populate Queue (check duplicate item key)51-321.1Populate Queue (with permission)20660.9Populate Queue (use transaction tag)51131.115-105603048f031c8-4f88-4a29-94ba-ccab421cc186-195-105150906ff74152-eba4-44cb-97d7-eb691c7455b2In this example the source data is used to repeatedly populate a 1 row collection in order to add new irems to the queue one at a time.-195-105150906ff74152-eba4-44cb-97d7-eb691c7455b215-105603002ed8665-2a36-477e-a41f-cb536fd5538d6ff74152-eba4-44cb-97d7-eb691c7455b2-195-1515060collection6ff74152-eba4-44cb-97d7-eb691c7455b215-30150303cd05bdb-c85d-4c3b-ae96-536d075de07ffbed749a-531c-44d3-852d-3bbfcb870064ForEachSource Data6ff74152-eba4-44cb-97d7-eb691c7455b21522515030be7b9156-94ee-4e7d-96af-f0875c400e3ffbed749a-531c-44d3-852d-3bbfcb8700646ff74152-eba4-44cb-97d7-eb691c7455b2-1956015060collection6ff74152-eba4-44cb-97d7-eb691c7455b21515903095be1cd4-6d17-418e-8ae8-1f896636ffc16ff74152-eba4-44cb-97d7-eb691c7455b215180903058a2b391-0805-4585-9efd-47b030ffccd66ff74152-eba4-44cb-97d7-eb691c7455b2157590600835b2bf-ff16-4a60-b07e-8d42d9de37576ff74152-eba4-44cb-97d7-eb691c7455b21528560306ff74152-eba4-44cb-97d7-eb691c7455b2151359030

ef79e476-98d6-439a-aa2c-b762a614485e6ff74152-eba4-44cb-97d7-eb691c7455b2-19513515030textMy Queue01ebfcac-c1a9-4bd5-be3d-a65068ac9dbcIn this example the source data is used to build a collection of new items to be added to the queue in one go.-195-1051509001ebfcac-c1a9-4bd5-be3d-a65068ac9dbc15-10560309b7fdb6b-496e-4cb5-b2fd-220cd8b4cc6001ebfcac-c1a9-4bd5-be3d-a65068ac9dbc15-301503066bac3a0-2784-43df-95c1-0b88507fe615467e680c-a248-434a-992c-df9fc9e297e8ForEachSource Data01ebfcac-c1a9-4bd5-be3d-a65068ac9dbc151351503003e71ca0-53aa-448c-b2d0-5baabffbd306467e680c-a248-434a-992c-df9fc9e297e801ebfcac-c1a9-4bd5-be3d-a65068ac9dbc151590302367c7e4-ef82-48d1-8cb9-6d121ebe1ee201ebfcac-c1a9-4bd5-be3d-a65068ac9dbc15255603001ebfcac-c1a9-4bd5-be3d-a65068ac9dbc-19519515030textMy Queue01ebfcac-c1a9-4bd5-be3d-a65068ac9dbc151959030

a0de7747-9a60-49c1-9dd9-385141c4c7739393ea8b-0143-410d-b266-ccb025a1ac82In this example the source data is used to create a 'key' field in the new item data collection.-195-1051509001ebfcac-c1a9-4bd5-be3d-a65068ac9dbc-195-1515060collection9393ea8b-0143-410d-b266-ccb025a1ac8215-105603097e7d9df-85de-43e7-b95a-9068be04181a9393ea8b-0143-410d-b266-ccb025a1ac82-195-1515060collection9393ea8b-0143-410d-b266-ccb025a1ac8215-301503026d3df39-48a8-45f5-a2d3-59088cd159b8dab10c34-8fd1-4b2e-b419-668298401aeaForEachSource Data9393ea8b-0143-410d-b266-ccb025a1ac821522515030912c2df7-f542-4497-a13a-ae437eaa1037dab10c34-8fd1-4b2e-b419-668298401aea9393ea8b-0143-410d-b266-ccb025a1ac82-1956015060collection9393ea8b-0143-410d-b266-ccb025a1ac821515903060b12c78-47c5-4d71-b1c9-8d76389b3afa9393ea8b-0143-410d-b266-ccb025a1ac8215180903037e031ec-c112-4fa0-b231-88298bad9c859393ea8b-0143-410d-b266-ccb025a1ac82157590603d8659ab-1e7a-42f8-ba84-bebd001f275c9393ea8b-0143-410d-b266-ccb025a1ac821528560309393ea8b-0143-410d-b266-ccb025a1ac82151359030

5f48a5e2-f8d0-4771-bb33-9a3ea462ea219393ea8b-0143-410d-b266-ccb025a1ac82-19513515030textMy Queue9393ea8b-0143-410d-b266-ccb025a1ac82** NB A combination of source data has been used in the key field of the new item collection22510518012060b12c78-47c5-4d71-b1c9-8d76389b3afa6ff74152-eba4-44cb-97d7-eb691c7455b2** NB the new item collection does not have to use the same field names as the source21010518012095be1cd4-6d17-418e-8ae8-1f896636ffc101ebfcac-c1a9-4bd5-be3d-a65068ac9dbc-1956015060collection01ebfcac-c1a9-4bd5-be3d-a65068ac9dbc15759060a680837c-c66a-4c16-b8da-8678e0c9015e01ebfcac-c1a9-4bd5-be3d-a65068ac9dbc** NB the new item collection does not have to use all the fields from the source2251201801202367c7e4-ef82-48d1-8cb9-6d121ebe1ee26da72cc7-81b7-481e-93de-9f5b8f3c0796In this example the source data is used to determine what label (tag) to give new queue items.-195-10515090020feaff-d29c-47af-bef4-a6272df073d3In this example the source data is used to determine what status to give new queue items.-195-1051509079a39e7a-3b75-49a0-af37-d13ff918c434In this example the source data is used to determine how to prioritise new queue items.-195-10515090756db72c-cee4-4f4b-a658-d3061b7679d2In this example not all source data might be loaded - items with existing keys are ignored and not added to the queue.-195-105150906ff74152-eba4-44cb-97d7-eb691c7455b2** NB Once the new item has been added the collection row is removed to prevent the item being added again on the next loop.210240180120ef79e476-98d6-439a-aa2c-b762a614485e9393ea8b-0143-410d-b266-ccb025a1ac82** NB Once the new item has been added the collection row is removed to prevent the item being added again on the next loop.2252401801205f48a5e2-f8d0-4771-bb33-9a3ea462ea216da72cc7-81b7-481e-93de-9f5b8f3c079615-1056030e7eed557-4b5e-40a2-a8ae-d5d97ba0f5756da72cc7-81b7-481e-93de-9f5b8f3c0796-195-1515060collection6da72cc7-81b7-481e-93de-9f5b8f3c079615-3015030187ed79d-6cd4-475d-95a9-60fb49bcb5beb1b53956-fc44-4109-afd7-2d516e795260ForEachSource Data6da72cc7-81b7-481e-93de-9f5b8f3c0796153601503098607d70-e445-4a54-ab6c-ea6e6d9f6b22b1b53956-fc44-4109-afd7-2d516e7952606da72cc7-81b7-481e-93de-9f5b8f3c0796-1956015060collection6da72cc7-81b7-481e-93de-9f5b8f3c0796151590306ebf6291-0741-4eae-8891-3e881b6510986da72cc7-81b7-481e-93de-9f5b8f3c0796153009030c82dfe2b-f268-4db1-b808-199f6b57b6d66da72cc7-81b7-481e-93de-9f5b8f3c0796157590606d97ae18-4b3e-4059-a8c2-7b14031e38286da72cc7-81b7-481e-93de-9f5b8f3c07961542060306da72cc7-81b7-481e-93de-9f5b8f3c07961352409030

9a468e94-93f4-4d0e-babe-6bf1aa0bd2ed6da72cc7-81b7-481e-93de-9f5b8f3c0796-19524015030textMy Queue6da72cc7-81b7-481e-93de-9f5b8f3c0796** NB A combination of source data has been used in the key field of the new item collection3301051801206ebf6291-0741-4eae-8891-3e881b6510986da72cc7-81b7-481e-93de-9f5b8f3c0796** NB Once the new item has been added the collection row is removed to prevent the item being added again on the next loop.330375180120140d6315-6691-4062-a786-9ce5c16802876da72cc7-81b7-481e-93de-9f5b8f3c0796151659060ff92db18-e948-4dcb-8478-cb3e67b485595602edee-87cf-48f9-ac61-014122a1ce3d6da72cc7-81b7-481e-93de-9f5b8f3c07961351656030fa305f72-4518-4527-98c4-1b9962d8c89e6da72cc7-81b7-481e-93de-9f5b8f3c0796-19516515030text6da72cc7-81b7-481e-93de-9f5b8f3c0796152406030fa305f72-4518-4527-98c4-1b9962d8c89e6da72cc7-81b7-481e-93de-9f5b8f3c07961353001010140d6315-6691-4062-a786-9ce5c16802876da72cc7-81b7-481e-93de-9f5b8f3c0796** NB The source data is used to decide how to tag the new item3302401801206d97ae18-4b3e-4059-a8c2-7b14031e3828020feaff-d29c-47af-bef4-a6272df073d315-10560307fb17b52-9a27-4903-b293-aa1d9a5059d4020feaff-d29c-47af-bef4-a6272df073d3-195-1515060collection020feaff-d29c-47af-bef4-a6272df073d315-30150309fa51185-39bb-45b3-a3b1-4356a46c11e4fb93d6db-7872-41ef-9194-7a08aa96e973ForEachSource Data020feaff-d29c-47af-bef4-a6272df073d31536015030fc50f452-17b9-4243-8a9d-bba6085272c1fb93d6db-7872-41ef-9194-7a08aa96e973020feaff-d29c-47af-bef4-a6272df073d3-1956015060collection020feaff-d29c-47af-bef4-a6272df073d31515903033a24cfd-995b-48ff-a6b1-eb6b4d6720aa020feaff-d29c-47af-bef4-a6272df073d3153009030506d4640-8980-41f9-9c9c-913c88a1ad9a020feaff-d29c-47af-bef4-a6272df073d3157590608df37666-0e47-4953-bbb3-2aa2a990199d020feaff-d29c-47af-bef4-a6272df073d3154206030020feaff-d29c-47af-bef4-a6272df073d31352409030

2657bff8-34b7-4ee2-906d-f69a6d8ca876020feaff-d29c-47af-bef4-a6272df073d3-19524015030textMy Queue020feaff-d29c-47af-bef4-a6272df073d3** NB A combination of source data has been used in the key field of the new item collection33010518012033a24cfd-995b-48ff-a6b1-eb6b4d6720aa020feaff-d29c-47af-bef4-a6272df073d3** NB Once the new item has been added the collection row is removed to prevent the item being added again on the next loop.33037518012051d5de49-02bb-4612-b171-6e197c28de01020feaff-d29c-47af-bef4-a6272df073d31516590605e9114fb-47a1-4abd-aae5-d69c7602ce782855e374-0229-40c2-92d3-13d40666795f020feaff-d29c-47af-bef4-a6272df073d3135165603026fabdb2-b0d1-40d8-ba47-ebc1d71da59f020feaff-d29c-47af-bef4-a6272df073d3-19516515030text020feaff-d29c-47af-bef4-a6272df073d3135300101051d5de49-02bb-4612-b171-6e197c28de01020feaff-d29c-47af-bef4-a6272df073d3** NB The source data is used to decide what status to give the new item3302401801208df37666-0e47-4953-bbb3-2aa2a990199d020feaff-d29c-47af-bef4-a6272df073d315240603026fabdb2-b0d1-40d8-ba47-ebc1d71da59f79a39e7a-3b75-49a0-af37-d13ff918c43415-1056030015f1b63-0d84-4bc1-bea2-a23230f491b679a39e7a-3b75-49a0-af37-d13ff918c434-195-1515060collection79a39e7a-3b75-49a0-af37-d13ff918c43415-3015030b5b2dcd7-9acb-4846-9075-3c27327982d3455f994a-5def-4e54-8a5c-f9f48fc7aba3ForEachSource Data79a39e7a-3b75-49a0-af37-d13ff918c4341545015030d04bbb73-7289-4a72-8b7f-624121d70e43455f994a-5def-4e54-8a5c-f9f48fc7aba379a39e7a-3b75-49a0-af37-d13ff918c434-1956015060collection79a39e7a-3b75-49a0-af37-d13ff918c43415309030b09ed02a-a592-4743-a110-2561a593322379a39e7a-3b75-49a0-af37-d13ff918c43415390903030254304-7bf9-4196-8a57-4c9790dba7bb79a39e7a-3b75-49a0-af37-d13ff918c43415909060b904cab9-7de0-4718-b7db-d128149e518179a39e7a-3b75-49a0-af37-d13ff918c43415510603079a39e7a-3b75-49a0-af37-d13ff918c4341803909030

e10c9e99-c8f3-4fc8-bbbf-596060bee93279a39e7a-3b75-49a0-af37-d13ff918c434-19539015030textMy Queue79a39e7a-3b75-49a0-af37-d13ff918c434** NB A combination of source data has been used in the key field of the new item collection315120180120b09ed02a-a592-4743-a110-2561a593322379a39e7a-3b75-49a0-af37-d13ff918c434** NB Once the new item has been added the collection row is removed to prevent the item being added again on the next loop.315495180120e10c9e99-c8f3-4fc8-bbbf-596060bee93279a39e7a-3b75-49a0-af37-d13ff918c43415180906050cff276-0f0b-4eb3-b754-f555de995e0fdf9b6d77-dac3-403c-9081-a093600367a979a39e7a-3b75-49a0-af37-d13ff918c434120180603000505032-66f3-4898-9655-4a40e4921d6379a39e7a-3b75-49a0-af37-d13ff918c43418033010109a74e615-4f45-444f-8def-e4834ab2766679a39e7a-3b75-49a0-af37-d13ff918c4341525590603e6bebdc-4b49-4f58-b031-fb99c1a9f3bdac123758-79fd-4629-beda-38b9b28b03bc79a39e7a-3b75-49a0-af37-d13ff918c434-19518015030number79a39e7a-3b75-49a0-af37-d13ff918c434120255603097d19c57-abc1-4d93-8676-424c6ba9f64c79a39e7a-3b75-49a0-af37-d13ff918c434180180101097d19c57-abc1-4d93-8676-424c6ba9f64c79a39e7a-3b75-49a0-af37-d13ff918c43418025510108f62d721-b4c5-4343-ac7c-afb53476f9cf79a39e7a-3b75-49a0-af37-d13ff918c434Use default priority153309030dae8266a-df94-4b2e-8826-775bb98b085f79a39e7a-3b75-49a0-af37-d13ff918c43412033060308f62d721-b4c5-4343-ac7c-afb53476f9cf79a39e7a-3b75-49a0-af37-d13ff918c434** NB The source data is used to decide what priority to give the new item31528518012050cff276-0f0b-4eb3-b754-f555de995e0f756db72c-cee4-4f4b-a658-d3061b7679d215-10560305d30af94-572e-46b7-8f71-2913186d84f4756db72c-cee4-4f4b-a658-d3061b7679d2-195-1515060collection756db72c-cee4-4f4b-a658-d3061b7679d215-3015030cea912d5-a5b9-4375-8584-ed8ddf25b89ec044514b-a461-44fc-974a-fc2b104a8841ForEachSource Data756db72c-cee4-4f4b-a658-d3061b7679d21548015030694718c5-d95f-49e1-acaf-84c9b5d6d688c044514b-a461-44fc-974a-fc2b104a8841756db72c-cee4-4f4b-a658-d3061b7679d2-1956015060collection756db72c-cee4-4f4b-a658-d3061b7679d2152409030c9b486b1-bb7f-41da-a835-5c14e8b50a47756db72c-cee4-4f4b-a658-d3061b7679d21542090309a68f429-c546-4618-a675-ac6c8ad3d858756db72c-cee4-4f4b-a658-d3061b7679d21531590604fe70f83-ee53-4b37-8dec-4dfdf3711d94756db72c-cee4-4f4b-a658-d3061b7679d2155406030756db72c-cee4-4f4b-a658-d3061b7679d2153759030

305de629-d00d-4c8c-a95a-b1fe93da1b2a756db72c-cee4-4f4b-a658-d3061b7679d2-19531515030textMy Queue756db72c-cee4-4f4b-a658-d3061b7679d2** NB A combination of source data has been used in the key field240105180120cea912d5-a5b9-4375-8584-ed8ddf25b89e756db72c-cee4-4f4b-a658-d3061b7679d2** NB Once the new item has been added the collection row is removed to prevent the item being added again on the next loop.240390180120305de629-d00d-4c8c-a95a-b1fe93da1b2a756db72c-cee4-4f4b-a658-d3061b7679d215909030

64b52ed2-008c-4ab2-ba41-17f2b00be969756db72c-cee4-4f4b-a658-d3061b7679d2-19516515030flag756db72c-cee4-4f4b-a658-d3061b7679d21516590600cdd4430-57c3-443f-bd04-6b8c3a24207177f815c2-8597-427d-8e91-f61f9494ce7c756db72c-cee4-4f4b-a658-d3061b7679d2** NB If the item key is found in the queue the new item is not added24024018012064b52ed2-008c-4ab2-ba41-17f2b00be9695eda4475-74e9-4ec9-89cd-cf7ee636ce4aIn this example the source data is used to determine whether to add new items as 'deferred', ie unavailable until a certain date.-195-105150905eda4475-74e9-4ec9-89cd-cf7ee636ce4a15-1056030b0ee2e59-8afa-4348-9f3e-3b945db26f935eda4475-74e9-4ec9-89cd-cf7ee636ce4a-195-1515060collection5eda4475-74e9-4ec9-89cd-cf7ee636ce4a15-3015030fcfc8ad2-2369-4dd1-b6c0-0d213b846a2a16551e0f-65e2-4cba-b4f1-f40c5be1243fForEachSource Data5eda4475-74e9-4ec9-89cd-cf7ee636ce4a154501503064c5492e-fd3c-4461-a121-ba6bf5cebf0a16551e0f-65e2-4cba-b4f1-f40c5be1243f5eda4475-74e9-4ec9-89cd-cf7ee636ce4a-1956015060collection5eda4475-74e9-4ec9-89cd-cf7ee636ce4a1530903083a38c02-1a3f-454b-974c-ad8ed9e0f8bd5eda4475-74e9-4ec9-89cd-cf7ee636ce4a1539090309ee5ee90-4845-4943-a0b5-79f478c8593c5eda4475-74e9-4ec9-89cd-cf7ee636ce4a159090600c214419-514d-4afe-a30a-1a39b475bb265eda4475-74e9-4ec9-89cd-cf7ee636ce4a1551060305eda4475-74e9-4ec9-89cd-cf7ee636ce4a153309030

3fb0d741-6554-4762-920b-fe24485005ba5eda4475-74e9-4ec9-89cd-cf7ee636ce4a-19539015030textMy Queue5eda4475-74e9-4ec9-89cd-cf7ee636ce4a** NB A combination of source data has been used in the key field of the new item collection34512018012083a38c02-1a3f-454b-974c-ad8ed9e0f8bd5eda4475-74e9-4ec9-89cd-cf7ee636ce4a** NB Once the new item has been added the collection row is removed to prevent the item being added again on the next loop.3454801801203fb0d741-6554-4762-920b-fe24485005ba5eda4475-74e9-4ec9-89cd-cf7ee636ce4a151809060e5175a95-7bab-4192-ba6e-52ca852c24776580e9bd-634f-4ee3-b992-9eeb9162b8165eda4475-74e9-4ec9-89cd-cf7ee636ce4a152559060c79570a0-7973-4ce6-82fa-8e5d7eddde11a4d2286f-da87-4bdb-a7f8-740b8adeb6955eda4475-74e9-4ec9-89cd-cf7ee636ce4a18018010109dc736f9-3318-4391-8c60-b2155174f7235eda4475-74e9-4ec9-89cd-cf7ee636ce4a18025510100514d106-94eb-434b-ba15-1405b6a03fb55eda4475-74e9-4ec9-89cd-cf7ee636ce4a** NB The source data is used to decide whether to defer the new item3453451801206580e9bd-634f-4ee3-b992-9eeb9162b8165eda4475-74e9-4ec9-89cd-cf7ee636ce4a1803909030

3fb0d741-6554-4762-920b-fe24485005ba5eda4475-74e9-4ec9-89cd-cf7ee636ce4a120180603075d0190f-9568-4d99-80a0-5c79d9bb44e05eda4475-74e9-4ec9-89cd-cf7ee636ce4a-19525515030date5eda4475-74e9-4ec9-89cd-cf7ee636ce4a-19533015030datetime5eda4475-74e9-4ec9-89cd-cf7ee636ce4a12025560309dc736f9-3318-4391-8c60-b2155174f7235eda4475-74e9-4ec9-89cd-cf7ee636ce4a1803306030d534af98-ccfc-4a8e-a0cf-01d4872f8f769a801d71-045e-4cf6-94b5-6474d7a34a65In this example not all source data might be loaded - existing items with matching key values are checked first. If an existing item is recent, a new item is not added; if the existing item is old, a new item is added.-195-10515090756db72c-cee4-4f4b-a658-d3061b7679d215306030ce7ddf0b-c35e-4cd8-9185-237554510106756db72c-cee4-4f4b-a658-d3061b7679d2-19513515030text756db72c-cee4-4f4b-a658-d3061b7679d2-9016510103c3d53c3-ef51-47ab-bbb9-de6b0e8ac00e756db72c-cee4-4f4b-a658-d3061b7679d2-9048010109a68f429-c546-4618-a675-ac6c8ad3d8589a801d71-045e-4cf6-94b5-6474d7a34a6515-1056030894025f5-4208-4bf0-a147-b8858f2436cd9a801d71-045e-4cf6-94b5-6474d7a34a65-195015060collection9a801d71-045e-4cf6-94b5-6474d7a34a6515-45150306f4dec3d-0328-4857-8dc7-46b45e1389946e0abf9d-6590-4f3d-bd42-0dd687059341ForEachSource Data9a801d71-045e-4cf6-94b5-6474d7a34a6515825150309c8b3bfe-cff6-4c43-9204-920d648b2f0e6e0abf9d-6590-4f3d-bd42-0dd6870593419a801d71-045e-4cf6-94b5-6474d7a34a65-1957515060collection9a801d71-045e-4cf6-94b5-6474d7a34a651588560309a801d71-045e-4cf6-94b5-6474d7a34a65-19560015030textMy Queue9a801d71-045e-4cf6-94b5-6474d7a34a6515759030

ab5b2d23-063b-482d-be70-f9f3d3da47f39a801d71-045e-4cf6-94b5-6474d7a34a65-19518015030flag9a801d71-045e-4cf6-94b5-6474d7a34a65151509060e56cdea9-0f14-4549-a264-16f241fd583b91bc3e3a-339a-44cc-9537-dafd8cd287719a801d71-045e-4cf6-94b5-6474d7a34a65151560309683f829-673d-4531-9b48-38f38482fcfb9a801d71-045e-4cf6-94b5-6474d7a34a65-19515015030text9a801d71-045e-4cf6-94b5-6474d7a34a65150780101046ef2465-de29-493b-8dd7-a3dcb89ccf159a801d71-045e-4cf6-94b5-6474d7a34a651501509030

1f552cd5-1175-41b1-bf2a-3e2958046e119a801d71-045e-4cf6-94b5-6474d7a34a651502259060bb3f4532-11a8-4b72-8dbe-eb58d56650c3178b5250-533c-4644-b0c0-f09fdd4860649a801d71-045e-4cf6-94b5-6474d7a34a651505709030aaefba51-ba84-4703-8fb2-bc85e4fcb46c9a801d71-045e-4cf6-94b5-6474d7a34a65150735903041122edb-dc24-4889-b11e-b4cd975d5c969a801d71-045e-4cf6-94b5-6474d7a34a65150630906001d0000c-9e21-477f-be2b-6887b7cac1aa9a801d71-045e-4cf6-94b5-6474d7a34a651506909030

75bbf6b1-d7c0-4f21-98ea-2b94c03ad0519a801d71-045e-4cf6-94b5-6474d7a34a65An item with the same key exists and is currently incomplete, so do not add another.153151206046ef2465-de29-493b-8dd7-a3dcb89ccf159a801d71-045e-4cf6-94b5-6474d7a34a65An item with the same key does not exist in the queue, so add the new item.150315120603a2d5706-4928-4164-9910-7018ea8ace3a9a801d71-045e-4cf6-94b5-6474d7a34a65157801010689dfb32-347d-4e0f-946e-3436d289415c9a801d71-045e-4cf6-94b5-6474d7a34a6548025515060collection9a801d71-045e-4cf6-94b5-6474d7a34a65300285120304ae6b460-d9dc-4147-8f04-26e3f69623239d5bf8f4-6f13-472c-9668-f305ed88e6a8ForEachItem IDs9a801d71-045e-4cf6-94b5-6474d7a34a653004951203078a47f2a-f65e-4d95-aa9c-c8b85d9245ce9d5bf8f4-6f13-472c-9668-f305ed88e6a89a801d71-045e-4cf6-94b5-6474d7a34a653003459030

9b6f06b3-86cc-41b2-8c34-84c7aaad69979a801d71-045e-4cf6-94b5-6474d7a34a653004209060b1337f0f-1ab8-4845-a8bc-5e78df9f84d0a59c9018-59f0-4d17-931a-019ee0a900b99a801d71-045e-4cf6-94b5-6474d7a34a6548034515030timespan90.00:00:009a801d71-045e-4cf6-94b5-6474d7a34a6548031515030datetime9a801d71-045e-4cf6-94b5-6474d7a34a65An item with the same key has been worked previously, so check how long ago.30022512060332faab6-3c11-4f2d-bbdb-ac42bb14cdbd9a801d71-045e-4cf6-94b5-6474d7a34a65An item with the same key has been worked previously but not recently, so add the new item.300570120603a2d5706-4928-4164-9910-7018ea8ace3a9a801d71-045e-4cf6-94b5-6474d7a34a6545042010101e3e9d29-5e05-4aab-844b-0a48132860e39a801d71-045e-4cf6-94b5-6474d7a34a65450780101041122edb-dc24-4889-b11e-b4cd975d5c969a801d71-045e-4cf6-94b5-6474d7a34a65An item with the same key has been worked recently, so do not add another.4505701206096a716b1-8731-4c58-9a77-67c61083f80c9a801d71-045e-4cf6-94b5-6474d7a34a65** NB A combination of source data has been used in the key field270-601801206f4dec3d-0328-4857-8dc7-46b45e1389949a801d71-045e-4cf6-94b5-6474d7a34a65** NB Once the new item has been added the collection row is removed to prevent the item being added again on the next loop.30087018012075bbf6b1-d7c0-4f21-98ea-2b94c03ad0519a801d71-045e-4cf6-94b5-6474d7a34a65** NB In this example if the item key is found in the queue the new item will only be added if the existing item is not recent.315901801201f552cd5-1175-41b1-bf2a-3e2958046e119a801d71-045e-4cf6-94b5-6474d7a34a65** NB This page assumes the source collection has been filled from elsewhere.225-195180120894025f5-4208-4bf0-a147-b8858f2436cd756db72c-cee4-4f4b-a658-d3061b7679d2** NB This page assumes the source collection has been filled from elsewhere.240-601801205d30af94-572e-46b7-8f71-2913186d84f45eda4475-74e9-4ec9-89cd-cf7ee636ce4a** NB This page assumes the source collection has been filled from elsewhere.345-60180120b0ee2e59-8afa-4348-9f3e-3b945db26f9379a39e7a-3b75-49a0-af37-d13ff918c434** NB This page assumes the source collection has been filled from elsewhere.315-60180120015f1b63-0d84-4bc1-bea2-a23230f491b6020feaff-d29c-47af-bef4-a6272df073d3** NB This page assumes the source collection has been filled from elsewhere.330-601801207fb17b52-9a27-4903-b293-aa1d9a5059d46da72cc7-81b7-481e-93de-9f5b8f3c0796** NB This page assumes the source collection has been filled from elsewhere.330-60180120e7eed557-4b5e-40a2-a8ae-d5d97ba0f5759393ea8b-0143-410d-b266-ccb025a1ac82** NB This page assumes the source collection has been filled from elsewhere.225-6018012097e7d9df-85de-43e7-b95a-9068be04181a01ebfcac-c1a9-4bd5-be3d-a65068ac9dbc** NB This page assumes the source collection has been filled from elsewhere.225-601801209b7fdb6b-496e-4cb5-b2fd-220cd8b4cc606ff74152-eba4-44cb-97d7-eb691c7455b2** NB This page assumes the source collection has been filled from elsewhere.210-6018012002ed8665-2a36-477e-a41f-cb536fd5538dc3151635-b6fc-4ce0-b2ed-c3eb440e4b09In this example all source data is added to the queue - items with existing keys are marked duplicates. Instead of ignoring duplicate cases, all input cases are accounted for and any duplicates are identified.-195-10518090c3151635-b6fc-4ce0-b2ed-c3eb440e4b0915-10560305abfee54-943d-4fd1-a413-63ea02d3635dc3151635-b6fc-4ce0-b2ed-c3eb440e4b09-195-1515060collectionc3151635-b6fc-4ce0-b2ed-c3eb440e4b0915-301503001b7443f-1cea-45d2-a0e0-44034acced62e0d6caf5-06f4-44bc-830d-acc5f490a5d8ForEachSource Datac3151635-b6fc-4ce0-b2ed-c3eb440e4b091539015030fc4052b5-f00c-423a-9bd4-e024c85f6541e0d6caf5-06f4-44bc-830d-acc5f490a5d8c3151635-b6fc-4ce0-b2ed-c3eb440e4b09-1956015060collectionc3151635-b6fc-4ce0-b2ed-c3eb440e4b0915150903017c5b743-d50b-4dd8-b125-3301d12e6defc3151635-b6fc-4ce0-b2ed-c3eb440e4b0915330903053fb01a1-1ca8-483f-bb95-da87fb935de8c3151635-b6fc-4ce0-b2ed-c3eb440e4b09152109060a9c91632-cf3a-4257-afba-f1e9509bb82cc3151635-b6fc-4ce0-b2ed-c3eb440e4b09154506030c3151635-b6fc-4ce0-b2ed-c3eb440e4b09152859030

5d138ca4-812c-421e-8556-89545895d836c3151635-b6fc-4ce0-b2ed-c3eb440e4b09-19528515030textMy Queuec3151635-b6fc-4ce0-b2ed-c3eb440e4b09** NB A combination of source data has been used in the key field24010518012001b7443f-1cea-45d2-a0e0-44034acced62c3151635-b6fc-4ce0-b2ed-c3eb440e4b09** NB Once the new item has been added the collection row is removed to prevent the item being added again on the next loop.2403901801205d138ca4-812c-421e-8556-89545895d836c3151635-b6fc-4ce0-b2ed-c3eb440e4b0915909030

21a52a85-2ad4-425e-923d-461cb2a788d4c3151635-b6fc-4ce0-b2ed-c3eb440e4b09-19516515030flagc3151635-b6fc-4ce0-b2ed-c3eb440e4b09** NB The new item is added even if the item key already exists in the queue. However the new item data contains a flag indicating whether the item is a duplicate or not.24024018012017c5b743-d50b-4dd8-b125-3301d12e6defc3151635-b6fc-4ce0-b2ed-c3eb440e4b0915306030b9d00f15-1a61-4401-b090-a6f5f541baa8c3151635-b6fc-4ce0-b2ed-c3eb440e4b09-19513515030textc3151635-b6fc-4ce0-b2ed-c3eb440e4b09** NB This page assumes the source collection has been filled from elsewhere.240-601801205abfee54-943d-4fd1-a413-63ea02d3635df32dda70-fb05-4de5-8fe5-2f8e0e561f2aIn this example not all source data might be loaded - blank rows in the source collection are ignored and not added to the queue.-195-10515090f32dda70-fb05-4de5-8fe5-2f8e0e561f2a15-1056030ca632a39-7bdc-469f-ac4c-24ff2d28fa54f32dda70-fb05-4de5-8fe5-2f8e0e561f2a-195-1515060collectionf32dda70-fb05-4de5-8fe5-2f8e0e561f2a15-301503094d2ea0a-ea23-4d03-95f9-3b2db5e940f91c640047-eacd-4e5b-a426-cf6ba65642f7ForEachSource Dataf32dda70-fb05-4de5-8fe5-2f8e0e561f2a15360150301ade38f9-e850-4dfd-b075-ab8b9c7547061c640047-eacd-4e5b-a426-cf6ba65642f7f32dda70-fb05-4de5-8fe5-2f8e0e561f2a-1956015060collectionf32dda70-fb05-4de5-8fe5-2f8e0e561f2a1512090300c614af6-ea98-445e-bfcd-d853cebc49f6f32dda70-fb05-4de5-8fe5-2f8e0e561f2a1530090300cb8d5fe-98dd-4681-ac5c-de8c74720d18f32dda70-fb05-4de5-8fe5-2f8e0e561f2a1519590607c5d947b-967f-40ab-9a56-4492c66c18f5f32dda70-fb05-4de5-8fe5-2f8e0e561f2a154206030f32dda70-fb05-4de5-8fe5-2f8e0e561f2a152559030

c4a4c3bb-ea59-4b59-8a1f-091a0e510d20f32dda70-fb05-4de5-8fe5-2f8e0e561f2a-19519515030textMy Queuef32dda70-fb05-4de5-8fe5-2f8e0e561f2a** NB A combination of source data has been used in the key field2402251801200c614af6-ea98-445e-bfcd-d853cebc49f6f32dda70-fb05-4de5-8fe5-2f8e0e561f2a** NB Once the new item has been added the collection row is removed to prevent the item being added again on the next loop.240390180120c4a4c3bb-ea59-4b59-8a1f-091a0e510d20f32dda70-fb05-4de5-8fe5-2f8e0e561f2a15459060ec4cf7e7-c632-4712-ab04-04fc85c2c6f1f28ad9df-49f7-4817-bffe-84891aa6eef9f32dda70-fb05-4de5-8fe5-2f8e0e561f2a** NB If the source collection contains a blank row, a new item is not added.2407518012094d2ea0a-ea23-4d03-95f9-3b2db5e940f9f32dda70-fb05-4de5-8fe5-2f8e0e561f2a-90451010f43fb9bb-0de0-4ea8-8869-80de16c4b79ff32dda70-fb05-4de5-8fe5-2f8e0e561f2a-9036010100cb8d5fe-98dd-4681-ac5c-de8c74720d18f32dda70-fb05-4de5-8fe5-2f8e0e561f2a** NB This page assumes the source collection has been filled from elsewhere.240-60180120ca632a39-7bdc-469f-ac4c-24ff2d28fa5443c65934-a5a6-4d89-9e30-a0e85aa4dc24In this example an environment lock is used to ensure that multiple machines do not populate the queue at the same time. This is useful way to prevent a data source (eg a spreadsheet) being simultaneously read by two machines. The lock represents 'permission' to load the queue, and only one machine can ever have the lock at one time. Once the queue loading is complete, the lock is released to enable other machines to get permission. An exception block is used to enable the lock to be released in the event of a problem.-195-10527015043c65934-a5a6-4d89-9e30-a0e85aa4dc2415-1056030d0620d99-5390-4130-a5bf-fe5c29f6346943c65934-a5a6-4d89-9e30-a0e85aa4dc2415159030

d3aa11c4-88dc-42b9-9efd-8671c9ab766343c65934-a5a6-4d89-9e30-a0e85aa4dc241590906082adb55f-b202-421a-9ca4-43ac12dd991f41a13165-f563-4583-9a1f-dc5214abda0443c65934-a5a6-4d89-9e30-a0e85aa4dc24The lock is held elsewhere, probably because this work is currently being done on another machine.1509012090bf6525d1-a5d6-414b-9282-c57466df72db43c65934-a5a6-4d89-9e30-a0e85aa4dc24-1954515030text43c65934-a5a6-4d89-9e30-a0e85aa4dc24-19510515030text43c65934-a5a6-4d89-9e30-a0e85aa4dc2415-45603031f0e5ad-7b07-475f-b813-e6848d8dc8fc43c65934-a5a6-4d89-9e30-a0e85aa4dc24-1957515030timespan0.00:05:0043c65934-a5a6-4d89-9e30-a0e85aa4dc24-195015030textMy Queue43c65934-a5a6-4d89-9e30-a0e85aa4dc2415585603043c65934-a5a6-4d89-9e30-a0e85aa4dc24135465603006fef0e4-bcaa-4696-8972-a485dda4a9ed43c65934-a5a6-4d89-9e30-a0e85aa4dc241355259030101abd1e-c251-4ba5-84b8-01cf346929d343c65934-a5a6-4d89-9e30-a0e85aa4dc24135585603043c65934-a5a6-4d89-9e30-a0e85aa4dc24155259030aa0d7115-4875-4305-b177-cd9bbd507f9843c65934-a5a6-4d89-9e30-a0e85aa4dc24The lock has been obtained, meaning permission to populate queue is granted.1521012090b0233cfb-d727-41cf-951c-2faebf84bbd743c65934-a5a6-4d89-9e30-a0e85aa4dc24-6028525521043c65934-a5a6-4d89-9e30-a0e85aa4dc24** NB In the event of an exception the lock must be released.33063018012006fef0e4-bcaa-4696-8972-a485dda4a9ed43c65934-a5a6-4d89-9e30-a0e85aa4dc24** NB After populating the queue, the lock is released.-180630180120c2d1b1f0-9aab-4d62-8c4f-74128a10f62b43c65934-a5a6-4d89-9e30-a0e85aa4dc2427090603043c65934-a5a6-4d89-9e30-a0e85aa4dc24Logic to poulate the queue goes here, inside the exception block.1537512090c2d1b1f0-9aab-4d62-8c4f-74128a10f62b43c65934-a5a6-4d89-9e30-a0e85aa4dc24** NB In this example, if the lock does not become available the process will continue.390195180120bf6525d1-a5d6-414b-9282-c57466df72dbbf0bd98c-a671-44c0-b5ea-bcc27c806e93-195-10515090bf0bd98c-a671-44c0-b5ea-bcc27c806e9315-1056030d553d2ac-66ca-4aec-894f-0d406010a252bf0bd98c-a671-44c0-b5ea-bcc27c806e93-1954515030textMy Queuebf0bd98c-a671-44c0-b5ea-bcc27c806e9315609030

c5b494f4-be90-4a79-bd18-a097e8b9c542bf0bd98c-a671-44c0-b5ea-bcc27c806e93-195-1515060collectionbf0bd98c-a671-44c0-b5ea-bcc27c806e93-19510515060collectionbf0bd98c-a671-44c0-b5ea-bcc27c806e931536015030472df0bc-9eec-42c2-b506-30b80ed01b9b43ba656c-2be9-4f82-bc68-5ff71d22408eForEachNew Item IDsbf0bd98c-a671-44c0-b5ea-bcc27c806e9315450150307feb1876-f532-44bc-bf3b-5d7ffec251a143ba656c-2be9-4f82-bc68-5ff71d22408ebf0bd98c-a671-44c0-b5ea-bcc27c806e9315405903061bb6da7-a738-42ac-8d27-a565c25da09ebf0bd98c-a671-44c0-b5ea-bcc27c806e93156306030bf0bd98c-a671-44c0-b5ea-bcc27c806e932101956030aa55cb0b-9a1f-4c3d-b06a-116b22337cfebf0bd98c-a671-44c0-b5ea-bcc27c806e9321036015030d2c250bd-ad87-466c-baf5-50c8795cf1593e7d2a50-f0ac-474b-9716-fd229a0bcacbForEachNew Item IDsbf0bd98c-a671-44c0-b5ea-bcc27c806e9321045015030b3fd0205-bf63-4aae-9459-6a9a268da34d3e7d2a50-f0ac-474b-9716-fd229a0bcacbbf0bd98c-a671-44c0-b5ea-bcc27c806e932104059030c6f3d69d-d405-435a-8da6-24f8ef585b69bf0bd98c-a671-44c0-b5ea-bcc27c806e932105106030bf0bd98c-a671-44c0-b5ea-bcc27c806e93Complete the transaction by marking the source as read (eg move spreadsheet to an archive folder).151651509022a15319-93dd-4e90-9afd-fce88a5b532abf0bd98c-a671-44c0-b5ea-bcc27c806e93-7590375135bf0bd98c-a671-44c0-b5ea-bcc27c806e93Begin a transaction by reading data source (eg a spreadsheet).15-1515090d342d5fa-6356-4312-9839-e14116a843a7bf0bd98c-a671-44c0-b5ea-bcc27c806e93** NB This example assumes the New Item Data collection has been filled from elsewhere.2100180120d342d5fa-6356-4312-9839-e14116a843a7bf0bd98c-a671-44c0-b5ea-bcc27c806e93Once the transaction is complete, the new items are marked to indicate that they can be worked, in this example with the tag 'Ready'.152851509073faea4f-dc2e-4efa-8152-63f237b9065cbf0bd98c-a671-44c0-b5ea-bcc27c806e93This example assumes that only items tagged as 'Ready' will be worked and that any item not tagged will be ignored (eg the 'Tag Filter' parameter will be used on the 'Get Next Item' action).1554015090fbfde68f-c240-4c82-88e3-f1863650fbb5bf0bd98c-a671-44c0-b5ea-bcc27c806e93Roll back the transaction in the event of a problem - the new items are deemed invalid and can be deleted.21028515090271b32f3-a52b-4001-8daf-6f580468dc6147332930-e6c1-484c-b26a-2ca9d8b881afIn this example the source data is used to determine the type of item to create ( Gas, Electrc or Dual Fuel) and what data collection to use.-195-1051509047332930-e6c1-484c-b26a-2ca9d8b881af15-105603092b1a623-dcde-4279-8e85-1b2f434d56c247332930-e6c1-484c-b26a-2ca9d8b881af-195-1515060collection47332930-e6c1-484c-b26a-2ca9d8b881af15-4515030bde1ada5-5d6b-4ec4-96f7-fa490670cdfa834b35cb-6108-4a34-ab8b-d7ffe8f1b1b6ForEachSource Data47332930-e6c1-484c-b26a-2ca9d8b881af154501503099aba44a-56d4-4da9-84da-54cd99794d19834b35cb-6108-4a34-ab8b-d7ffe8f1b1b647332930-e6c1-484c-b26a-2ca9d8b881af15390903049043f8d-c633-4cab-99e6-28636d733a6647332930-e6c1-484c-b26a-2ca9d8b881af15510603047332930-e6c1-484c-b26a-2ca9d8b881af153309030

2900cf57-d612-4cca-8d59-928cb99b2ac947332930-e6c1-484c-b26a-2ca9d8b881af-1957515030textMy Queue47332930-e6c1-484c-b26a-2ca9d8b881af** NB Once the new item has been added the collection row is removed to prevent the item being added again on the next loop.2104801801202900cf57-d612-4cca-8d59-928cb99b2ac947332930-e6c1-484c-b26a-2ca9d8b881af** NB This page assumes the source collection has been filled from elsewhere.210-9018012092b1a623-dcde-4279-8e85-1b2f434d56c247332930-e6c1-484c-b26a-2ca9d8b881af1530906050576105-96ab-44a2-a4c5-84229cf6d1e9b91a9f52-cc1e-4382-a178-37c97ee79c0c47332930-e6c1-484c-b26a-2ca9d8b881af180309060dc8cda74-2c10-4100-b6cc-d0c81bb05f82340ca50f-cf1c-4566-a51d-4d76c81d938e47332930-e6c1-484c-b26a-2ca9d8b881af151059030bd7bac3c-f61e-46e7-afb6-ee44ad28396547332930-e6c1-484c-b26a-2ca9d8b881af151659060fd3d6475-b012-411c-95ec-c609cedb810447332930-e6c1-484c-b26a-2ca9d8b881af-19518015060collection47332930-e6c1-484c-b26a-2ca9d8b881af-19530015060collection47332930-e6c1-484c-b26a-2ca9d8b881af18010590302d68f144-5129-4a69-8f83-fc98631faa7747332930-e6c1-484c-b26a-2ca9d8b881af180165906092e53ef2-1709-49f9-8495-a978701f819a47332930-e6c1-484c-b26a-2ca9d8b881af18039010102900cf57-d612-4cca-8d59-928cb99b2ac947332930-e6c1-484c-b26a-2ca9d8b881af34510590303600397a-b9c8-4b2b-ad18-aea6e8de7e0d47332930-e6c1-484c-b26a-2ca9d8b881af3451659060c33f9978-f82f-4b18-8e11-7e2c315680b447332930-e6c1-484c-b26a-2ca9d8b881afMust be Dual Fuel345309060ceaf28e4-5f9d-4fab-a416-8906aa757e8547332930-e6c1-484c-b26a-2ca9d8b881af-19524015060collection47332930-e6c1-484c-b26a-2ca9d8b881af-19536015030text47332930-e6c1-484c-b26a-2ca9d8b881af345390101078d3da95-727b-4d04-a862-88966501507d47332930-e6c1-484c-b26a-2ca9d8b881af1525590602f1f75f4-f70b-4b30-b267-f91383eb809f47332930-e6c1-484c-b26a-2ca9d8b881af1802559060d65aef72-9875-448b-85f9-cebb2a74c4a947332930-e6c1-484c-b26a-2ca9d8b881af3452559060a3f9efc8-d513-47ee-b4c0-686ae5e4a04f47332930-e6c1-484c-b26a-2ca9d8b881af1803309030

78d3da95-727b-4d04-a862-88966501507d47332930-e6c1-484c-b26a-2ca9d8b881af3453309030

c6cb86fb-595d-4686-af97-cff3b8c654eb151656030This process has not been designed to run, it is merely a collection diagram fragments based on a common theme. Each page is an example intended to illustrate how a particular task might be acheived in Blue Prism. These examples may be copied into a new diagram and modified to suit your needs.1530270150d0d58eb1-a2b5-4164-a296-62cde8a1f525 001.25Add Rows0421.25Remove Rows0421.25Remove All Rows001.25Reuse Collection86401.25Copy Rows32841.25Append Rows0421.25Append Columns0841.25Copy Collection108421.25Sort Collection0841.25Filter Collection0841.25Empty Collection Test (1)0841.25Empty Collection Test (2)001.25Collection Structure Test (1)106421.25Collection Structure Test (2)213421.215-1056030ad83496c-8a27-448a-b3ba-a7f67d6cbaa1-195-10515090151656030This process has not been designed to run, it is merely a collection diagram fragments based on a common theme. Each page is an example intended to illustrate how a particular task might be acheived in Blue Prism. These examples may be copied into a new diagram and modified to suit your needs.153027015086738c0c-ee8f-4101-8662-fa88b0bd3242447be6f3-3a3d-4602-9289-b6a359736ae0This example checks whether the values on a row are all empty. If they are, the row is removed from the collection.-195-10515090447be6f3-3a3d-4602-9289-b6a359736ae015-10560303b2e17f0-fe23-4883-b433-f2b239311c32447be6f3-3a3d-4602-9289-b6a359736ae0151806030447be6f3-3a3d-4602-9289-b6a359736ae015-3012030b8846ba5-d636-4c60-9a91-e7fe926f902d0de75aec-9e57-43b9-b5ba-da0e8c605536ForEachMy Collection447be6f3-3a3d-4602-9289-b6a359736ae0151201203029ac50bf-502a-4fa2-9f23-5539ab79e3330de75aec-9e57-43b9-b5ba-da0e8c605536447be6f3-3a3d-4602-9289-b6a359736ae01351201010913fcee1-7156-4916-9c36-de181de9bb4e447be6f3-3a3d-4602-9289-b6a359736ae015459060c4c3e4a8-a922-4f72-b5f3-baa40e5b858a913fcee1-7156-4916-9c36-de181de9bb4e447be6f3-3a3d-4602-9289-b6a359736ae0135459030900f5dbe-46c3-445e-90a4-0a0942b5b1c6447be6f3-3a3d-4602-9289-b6a359736ae0-195-1515060collectionb2a746ec-3c8d-451f-a1e2-40445ab4c063This example repeatedly adds a new row to the collection.-195-10515090b2a746ec-3c8d-451f-a1e2-40445ab4c06315-10560300df63a2d-eb01-492a-8b99-08f18b88d22ab2a746ec-3c8d-451f-a1e2-40445ab4c063151956030b2a746ec-3c8d-451f-a1e2-40445ab4c063-195015060collectionb2a746ec-3c8d-451f-a1e2-40445ab4c063135-4510100df63a2d-eb01-492a-8b99-08f18b88d22ab2a746ec-3c8d-451f-a1e2-40445ab4c06315-4590305dd06a58-7864-475e-b3e5-e1bba78ca851b2a746ec-3c8d-451f-a1e2-40445ab4c06315309060f7539327-238a-4a3c-be7f-badf3bf817e4b2a746ec-3c8d-451f-a1e2-40445ab4c063-1957515030number1b2a746ec-3c8d-451f-a1e2-40445ab4c0631512090609c0d7693-356f-46bf-91b6-56008e3e1cfa4db53388-791f-42df-8d1a-83f8df01a5eeb2a746ec-3c8d-451f-a1e2-40445ab4c063135120906044942c17-fbaf-4052-b0a9-a47c716cab60b2a746ec-3c8d-451f-a1e2-40445ab4c063-19510515030number10ea3944df-29d7-4242-82a8-af59bd1d5a7eThis example removes all rows from the collection.-195-10515090ea3944df-29d7-4242-82a8-af59bd1d5a7e15-105603009e057ee-9a34-4ee1-9451-67744357b381ea3944df-29d7-4242-82a8-af59bd1d5a7e15906030ea3944df-29d7-4242-82a8-af59bd1d5a7e15-1590305dc0941c-ba3f-4ca1-9add-ae528a2ef04dea3944df-29d7-4242-82a8-af59bd1d5a7e-195-1515060collectioncdd44f21-cbbb-4199-b9df-a802f8c35662This example erases all values from a collection before adding a new, clean row that is then filled with data.-195-10515090cdd44f21-cbbb-4199-b9df-a802f8c3566215-1056030cbec19b2-4c3e-46f6-b016-905dfe6091ddcdd44f21-cbbb-4199-b9df-a802f8c35662151956030cdd44f21-cbbb-4199-b9df-a802f8c3566215-30120304c1b5fdd-5d23-4ac7-8550-6a7013033c8fcdd44f21-cbbb-4199-b9df-a802f8c35662-195-1515060collectioncdd44f21-cbbb-4199-b9df-a802f8c35662153012030c5e49d6e-ad98-4e02-91b0-a6fcd5a46eb9cdd44f21-cbbb-4199-b9df-a802f8c35662151059060fcf6a2c2-282a-4d79-8860-5ca56b423f30cdd44f21-cbbb-4199-b9df-a802f8c35662** NB Although the existing row could simply be overwitten with the new data, the safest way to ensure the old data is not used is to remove the old row and then populate a new one.210135180120c5e49d6e-ad98-4e02-91b0-a6fcd5a46eb975b229cc-66bc-4341-aead-208935e2f394This example copies a subset of rows from a collection.-195-1051509075b229cc-66bc-4341-aead-208935e2f39415-1056030dbb9934a-f705-455f-99ac-85e906cd382175b229cc-66bc-4341-aead-208935e2f39415135603075b229cc-66bc-4341-aead-208935e2f394-195-1515060collection75b229cc-66bc-4341-aead-208935e2f39415-3012030

d1209530-cc97-4dd6-8d4a-edfaaaef0dcf75b229cc-66bc-4341-aead-208935e2f394-1957515060collection75b229cc-66bc-4341-aead-208935e2f394156012030

39245a15-3e57-46b0-8980-655202f824bf75b229cc-66bc-4341-aead-208935e2f394-19516515060collection75b229cc-66bc-4341-aead-208935e2f394** NB Collection B has no defined fields but is able to store the copied rows. This is an example of an undefined collection.285-7530060dbb9934a-f705-455f-99ac-85e906cd382175b229cc-66bc-4341-aead-208935e2f394** NB The row numbers start a zero, ie the first row is 0, the second 1, etc.28510530060d1209530-cc97-4dd6-8d4a-edfaaaef0dcf77e79fff-ba01-488e-a08f-9b3d807aa339This example simply uses a calculation to copy collections.-195-1051509077e79fff-ba01-488e-a08f-9b3d807aa33915-1056030ad8b1976-9729-44b7-b077-8b46e5e9180277e79fff-ba01-488e-a08f-9b3d807aa33915180603077e79fff-ba01-488e-a08f-9b3d807aa339-195-1515060collection77e79fff-ba01-488e-a08f-9b3d807aa339-19513515060collection77e79fff-ba01-488e-a08f-9b3d807aa339-1956015060collection77e79fff-ba01-488e-a08f-9b3d807aa33915-15906055a039fc-dcbe-4fba-b9c7-10bd7dabde4777e79fff-ba01-488e-a08f-9b3d807aa339159090607bbe0e62-7701-4f78-ab1a-4d27280eb9a075b229cc-66bc-4341-aead-208935e2f394** NB Collection C has fields defined but these must match the fields in Collection A exactly.2851530060d1209530-cc97-4dd6-8d4a-edfaaaef0dcf77e79fff-ba01-488e-a08f-9b3d807aa339** NB Collection B has no defined fields but can still be used as the 'Store In' value in the calculation. This is an example of an undefined collection.270-4530060ad8b1976-9729-44b7-b077-8b46e5e9180277e79fff-ba01-488e-a08f-9b3d807aa339** NB Collection C has fields defined but these must match the fields in Collection A exactly.2701203006055a039fc-dcbe-4fba-b9c7-10bd7dabde475944210c-9a30-46f6-a8b9-7c151279c0daThis example sorts the rows in a collection.-195-105150905944210c-9a30-46f6-a8b9-7c151279c0da15-10560308b523a97-95f9-4ac4-a439-7a45a2607ba65944210c-9a30-46f6-a8b9-7c151279c0da1516560305944210c-9a30-46f6-a8b9-7c151279c0da-195-1515060collection5944210c-9a30-46f6-a8b9-7c151279c0da15-3012030

5329fee4-dedf-4de0-b370-d2e5d6c303475944210c-9a30-46f6-a8b9-7c151279c0da-1956015060collection5944210c-9a30-46f6-a8b9-7c151279c0da-19513515060collection5944210c-9a30-46f6-a8b9-7c151279c0da159012030

4a6fe075-4899-46f4-8f78-d3a5c110106b5944210c-9a30-46f6-a8b9-7c151279c0da-19519515030flag5944210c-9a30-46f6-a8b9-7c151279c0da-19522515030text5944210c-9a30-46f6-a8b9-7c151279c0da** NB Collection B has no defined fields but can still be used as the output from the sort action. This is an example of an undefined collection.270-75300608b523a97-95f9-4ac4-a439-7a45a2607ba65944210c-9a30-46f6-a8b9-7c151279c0da** NB Collection C is used as both the input to and the output from the sort action.270120300605329fee4-dedf-4de0-b370-d2e5d6c30347dddf6dfa-465c-4b6c-86fe-e9ea9fbf6c53This example filters rows in a collection.-195-10515090dddf6dfa-465c-4b6c-86fe-e9ea9fbf6c5315-1056030c873b68e-7953-4cbe-894c-2254e475d44cdddf6dfa-465c-4b6c-86fe-e9ea9fbf6c53-195-1515060collectiondddf6dfa-465c-4b6c-86fe-e9ea9fbf6c5315-3012030

dbc77c79-6efb-4c59-b4cc-400ac8dff597dddf6dfa-465c-4b6c-86fe-e9ea9fbf6c53-1956015060collectiondddf6dfa-465c-4b6c-86fe-e9ea9fbf6c53-19519515030flagdddf6dfa-465c-4b6c-86fe-e9ea9fbf6c53-19522515030textdddf6dfa-465c-4b6c-86fe-e9ea9fbf6c53** NB Collection B has no defined fields but can still be used as the output from the filter action. This is an example of an undefined collection.270-6030060c873b68e-7953-4cbe-894c-2254e475d44cdddf6dfa-465c-4b6c-86fe-e9ea9fbf6c53** NB Collection C is used as both the input to and the output from the filter action.27012030060dbc77c79-6efb-4c59-b4cc-400ac8dff597dddf6dfa-465c-4b6c-86fe-e9ea9fbf6c53-19513515060collectiondddf6dfa-465c-4b6c-86fe-e9ea9fbf6c53159012030

7cead5f3-fad5-4b61-a4ac-9a15717168a7dddf6dfa-465c-4b6c-86fe-e9ea9fbf6c53151656030851d80ad-6d5e-4070-ac9b-7d6a0ca49a56This example combines collections by appending rows.-195-10515090851d80ad-6d5e-4070-ac9b-7d6a0ca49a5615-10560307bcf60d0-4f83-4e11-bab0-abe40d524c5d851d80ad-6d5e-4070-ac9b-7d6a0ca49a56151656030851d80ad-6d5e-4070-ac9b-7d6a0ca49a56-195-1515060collection851d80ad-6d5e-4070-ac9b-7d6a0ca49a56-19521015060collection851d80ad-6d5e-4070-ac9b-7d6a0ca49a5615-3012030

5cf9f7c0-f758-4ec1-b7b9-357fc83a6bc1851d80ad-6d5e-4070-ac9b-7d6a0ca49a56-19513515060collection851d80ad-6d5e-4070-ac9b-7d6a0ca49a56159012030

75cd06a3-bc0b-4589-bcee-e374b096d03c851d80ad-6d5e-4070-ac9b-7d6a0ca49a56-1956015060collection851d80ad-6d5e-4070-ac9b-7d6a0ca49a56** NB Collection B has no defined fields but can still be used as the output from the sort action. This is an example of an undefined collection.270-75300607bcf60d0-4f83-4e11-bab0-abe40d524c5d851d80ad-6d5e-4070-ac9b-7d6a0ca49a56** NB Collection D is used as both the input to and the output from the action.270135300605cf9f7c0-f758-4ec1-b7b9-357fc83a6bc1bf91e119-c6ab-49ad-ab0d-c0eab1c78402This example combines collections by appending columns.-195-10515090bf91e119-c6ab-49ad-ab0d-c0eab1c7840215-1056030dec6b8d3-cfa9-428a-9edf-f0c8819e4cf8bf91e119-c6ab-49ad-ab0d-c0eab1c78402151656030bf91e119-c6ab-49ad-ab0d-c0eab1c78402-195-1515060collectionbf91e119-c6ab-49ad-ab0d-c0eab1c78402-1956015060collectionbf91e119-c6ab-49ad-ab0d-c0eab1c78402-19513515060collectionbf91e119-c6ab-49ad-ab0d-c0eab1c7840215-3012030

2af7db27-dd95-445b-a929-82ea6370c87fbf91e119-c6ab-49ad-ab0d-c0eab1c78402159012030

1dd22ae2-9acf-419b-9823-217398442b7cbf91e119-c6ab-49ad-ab0d-c0eab1c78402-19521015060collectionbf91e119-c6ab-49ad-ab0d-c0eab1c78402** NB Collection D has no defined fields but can still be used as the output from the action. This is an example of an undefined collection.27060300602af7db27-dd95-445b-a929-82ea6370c87fbf91e119-c6ab-49ad-ab0d-c0eab1c78402** NB Collection C has fields defined fields but they must match the fields in A and B.270-6030060dec6b8d3-cfa9-428a-9edf-f0c8819e4cf8ab6c92e2-2818-41b7-a4c1-b1a9210a6812This example counts the rows in the collection and then checks if the number is zero.-195-10515090ab6c92e2-2818-41b7-a4c1-b1a9210a681215-10560304a020e2e-0e5c-4eb9-a31a-845452e8aa40ab6c92e2-2818-41b7-a4c1-b1a9210a6812285306030ab6c92e2-2818-41b7-a4c1-b1a9210a6812-195015060collectionab6c92e2-2818-41b7-a4c1-b1a9210a6812If we get here, the collection has at least 1 row.1653012060d6384a0c-6519-4c17-bc1e-a8d2a6e526d8ab6c92e2-2818-41b7-a4c1-b1a9210a6812151956030ab6c92e2-2818-41b7-a4c1-b1a9210a6812If we get here, the collection has no rows.1512012060f1cbef90-27c2-4037-a51c-0b56b66f563b8a5011b9-e536-4145-870c-d1f049ab4a47This example uses a collection to determine if the collection has rows.-195-105150908a5011b9-e536-4145-870c-d1f049ab4a4715-1056030ef71dc3c-8755-423a-912c-fb46faa9b6828a5011b9-e536-4145-870c-d1f049ab4a47285-4560308a5011b9-e536-4145-870c-d1f049ab4a47-195-1515060collection8a5011b9-e536-4145-870c-d1f049ab4a4715-4512030c230979f-9057-4953-a1e0-95f9a117f5ae299ac155-4531-49ba-95bb-6aa04c18e66aForEachCollection A8a5011b9-e536-4145-870c-d1f049ab4a47150120308a2b11ac-abbf-4cb7-bdc1-f3f3eeb3d6ab299ac155-4531-49ba-95bb-6aa04c18e66a8a5011b9-e536-4145-870c-d1f049ab4a47If we get here, the collection has at least 1 row.165-4512060e85c2714-a59e-4041-97eb-70f20d7936718a5011b9-e536-4145-870c-d1f049ab4a471515060308a5011b9-e536-4145-870c-d1f049ab4a47If we get here, the collection has no rows.157512060dad733c8-34eb-4f4f-b5ca-8809108b2ccdab6c92e2-2818-41b7-a4c1-b1a9210a681215-459030

8a213970-b24c-4024-a525-14e1af535636ab6c92e2-2818-41b7-a4c1-b1a9210a6812-1956015030numberab6c92e2-2818-41b7-a4c1-b1a9210a681215309060cdcacba2-878c-49ce-bdab-c5471844d687e54ec4c1-aea6-4205-8048-5a63fa67ac85e97d31d8-35a5-48e8-91fd-7e6b2dd4c0eeThis example uses a calculation where a 'template' collection is used as the 'Store In' value. If the calculation does not generate an exception, the test collection matches the template.-195-105210905c6f0c0b-2368-4b00-b63a-d730243a4056This example uses a multi-calculation to repeated assign a test value. If the calculations do not generate an exception, the test collection contains the required fields.-195-10521090e97d31d8-35a5-48e8-91fd-7e6b2dd4c0ee15-10560304533159f-28cf-4615-bdb2-3a1a2df7e321e97d31d8-35a5-48e8-91fd-7e6b2dd4c0ee1951806030e97d31d8-35a5-48e8-91fd-7e6b2dd4c0ee-195015060collectione97d31d8-35a5-48e8-91fd-7e6b2dd4c0ee-1959015060collectione97d31d8-35a5-48e8-91fd-7e6b2dd4c0ee195-3090600bea76b8-a355-4084-9458-cc91a86439e7e97d31d8-35a5-48e8-91fd-7e6b2dd4c0eeIf we get here, the collection has the same structure of the template.1959015090e2b65c37-035d-4a55-a598-32b1cc44b0cae97d31d8-35a5-48e8-91fd-7e6b2dd4c0eeIf we get here, the collection does not have the same structure of the template.3759015090ea44cde5-8a88-4ffa-866d-ce2fdd3b6423e97d31d8-35a5-48e8-91fd-7e6b2dd4c0ee3751806030e97d31d8-35a5-48e8-91fd-7e6b2dd4c0ee15-30120303635055e-ffe7-4eee-b413-4bbedcf65892edacf5a7-106b-4f20-8803-db571416c51fForEachTest Collectione97d31d8-35a5-48e8-91fd-7e6b2dd4c0ee151512030b41e3261-3e2b-4808-85f6-6c31541497ededacf5a7-106b-4f20-8803-db571416c51fe97d31d8-35a5-48e8-91fd-7e6b2dd4c0eeIf we get here, the collection has no rows and the structure cannot be verified.159015090be1d2bbc-e5f5-4dec-91a9-93894f655997e97d31d8-35a5-48e8-91fd-7e6b2dd4c0ee151806030e97d31d8-35a5-48e8-91fd-7e6b2dd4c0ee375-3060304fb09719-5b10-447e-972f-39945e4777dbe97d31d8-35a5-48e8-91fd-7e6b2dd4c0ee120-75300905c6f0c0b-2368-4b00-b63a-d730243a405615-105603027ae6453-a74e-4744-a842-86012f2d22c15c6f0c0b-2368-4b00-b63a-d730243a405619519560305c6f0c0b-2368-4b00-b63a-d730243a4056375-30603094438616-e639-4e57-9790-d1f5b3ffbb0f5c6f0c0b-2368-4b00-b63a-d730243a4056120-75300905c6f0c0b-2368-4b00-b63a-d730243a4056If we get here, the collection does not contain the required fields.37510515090cf7d2706-d3ec-4d0a-9a29-0754018836a05c6f0c0b-2368-4b00-b63a-d730243a4056-1957515030text5c6f0c0b-2368-4b00-b63a-d730243a4056195-3090604f19dd9d-040c-46f1-a9bc-0d4bf54397d95c6f0c0b-2368-4b00-b63a-d730243a4056If we get here, the collection contains the required fields.195105150902f26c127-3866-4015-bda0-1a0b2ef624625c6f0c0b-2368-4b00-b63a-d730243a405615-3012030103de2b0-6848-405c-af52-313ba821abc7d9d12ac3-b11e-439c-8d0c-45174d129fa3ForEachTest Collection5c6f0c0b-2368-4b00-b63a-d730243a4056151512030e1fcbd2d-536b-4273-b4a6-0ef2fa0b53f6d9d12ac3-b11e-439c-8d0c-45174d129fa35c6f0c0b-2368-4b00-b63a-d730243a4056If we get here, the collection has no rows and the structure cannot be verified.15105150900fa5749c-fb48-4f62-9931-4d84244450b05c6f0c0b-2368-4b00-b63a-d730243a40561519560305c6f0c0b-2368-4b00-b63a-d730243a4056-195015060collection5c6f0c0b-2368-4b00-b63a-d730243a405637519560305c6f0c0b-2368-4b00-b63a-d730243a4056** NB Because the Test Value data item is data type Text, any other data types in the collection will be cast to text.390-13530060103de2b0-6848-405c-af52-313ba821abc7 001.25Read SQL Server (basic)02101.25Read OLEDB (basic)01101.25Update SQL Server (basic)001.25Read SQL Server (into a work queue)150331.25Update SQL Server (from a work queue)50.83354090.815-1056030becb77eb-aaa2-4010-b3fd-10b73ac6d9b1-195-1051509030fb5d0a-2581-49e9-adc2-dc0dbc760336In this example a SQL statement is used to fill a collection.-195-1051509030fb5d0a-2581-49e9-adc2-dc0dbc76033615-1056030881b738c-4e95-4c34-8f36-9ccd870a51f730fb5d0a-2581-49e9-adc2-dc0dbc76033615330603030fb5d0a-2581-49e9-adc2-dc0dbc76033615-459030ed961f94-786b-40a8-b919-2518ceea6b3130fb5d0a-2581-49e9-adc2-dc0dbc760336-195-1515030textMy Server30fb5d0a-2581-49e9-adc2-dc0dbc760336-1951515030textMy Database30fb5d0a-2581-49e9-adc2-dc0dbc760336-1954515030textMy User Name30fb5d0a-2581-49e9-adc2-dc0dbc760336-1957515030password12,12,84,96,12,71,7,18,46,7,1630fb5d0a-2581-49e9-adc2-dc0dbc7603361590906016ef194b-0a39-4b52-89f6-bdaf54f057d330fb5d0a-2581-49e9-adc2-dc0dbc760336-19512015030text30fb5d0a-2581-49e9-adc2-dc0dbc760336151509030

041a16e8-17f4-4800-94d8-b7dd6d543a4630fb5d0a-2581-49e9-adc2-dc0dbc760336-19516515030flag30fb5d0a-2581-49e9-adc2-dc0dbc760336-19519515030text30fb5d0a-2581-49e9-adc2-dc0dbc760336-19524015060collection30fb5d0a-2581-49e9-adc2-dc0dbc7603361509030

6f1fa3b0-f4be-45bc-aef5-94db102bb2ee30fb5d0a-2581-49e9-adc2-dc0dbc760336152709030

7013b126-2a75-4de9-84d5-72c3de6c7714eaa87818-4c0b-42c3-8767-5f6856f75b04In this example a SQL statement is used to fill a collection.-195-10515090eaa87818-4c0b-42c3-8767-5f6856f75b0415-10560303f594820-0b6b-49f0-a685-7a964cd124b8eaa87818-4c0b-42c3-8767-5f6856f75b0415-4590308d8406d2-1c98-42ab-a0f4-d49a93667d24eaa87818-4c0b-42c3-8767-5f6856f75b04152556030eaa87818-4c0b-42c3-8767-5f6856f75b04-195-1515030textMy Servereaa87818-4c0b-42c3-8767-5f6856f75b04-1951515030textMy Databaseeaa87818-4c0b-42c3-8767-5f6856f75b04-1957515030textMy User Nameeaa87818-4c0b-42c3-8767-5f6856f75b04-19510515030password12,12,84,96,12,71,7,18,46,7,16eaa87818-4c0b-42c3-8767-5f6856f75b04157590606f6b212d-fdb9-40cb-8b49-d68f52594353eaa87818-4c0b-42c3-8767-5f6856f75b04-19515015030texteaa87818-4c0b-42c3-8767-5f6856f75b04151359030

56784dee-8fc3-43c4-9535-ebe2592290b3eaa87818-4c0b-42c3-8767-5f6856f75b04-19519515030flageaa87818-4c0b-42c3-8767-5f6856f75b04-19522515030texteaa87818-4c0b-42c3-8767-5f6856f75b04-19527015060collectioneaa87818-4c0b-42c3-8767-5f6856f75b041509030311a02a8-0d7b-4b1a-96d1-20172887ef44eaa87818-4c0b-42c3-8767-5f6856f75b04151959030d74e6463-2b6f-4731-b684-693b113300f4eaa87818-4c0b-42c3-8767-5f6856f75b04-1954515030textMy Providereaa87818-4c0b-42c3-8767-5f6856f75b0419513560308f327c00-7d43-40a6-89a3-32d6b4241eadeaa87818-4c0b-42c3-8767-5f6856f75b0419519590305605e2ae-6b2b-4efd-8882-d3b2a616645ceaa87818-4c0b-42c3-8767-5f6856f75b041952556030eaa87818-4c0b-42c3-8767-5f6856f75b04-603031513530fb5d0a-2581-49e9-adc2-dc0dbc76033615210603015aaab21-a655-40ba-a348-68fd32c8c40154fba4a5-5683-494c-b4ad-6fdeab29b48e30fb5d0a-2581-49e9-adc2-dc0dbc76033610521060307b69d790-c467-454e-adbe-ef13cbcf8922In this example a SQL statement is used to update a table.-195-105150907b69d790-c467-454e-adbe-ef13cbcf892215-10560302a1238ca-98e0-4c46-b0f4-03fda6b41a837b69d790-c467-454e-adbe-ef13cbcf892215-4590305731ad7b-caf9-49a6-a7b2-2193977665d97b69d790-c467-454e-adbe-ef13cbcf8922-195-1515030textMy Server7b69d790-c467-454e-adbe-ef13cbcf8922-1951515030textMy Database7b69d790-c467-454e-adbe-ef13cbcf8922-1954515030textMy User Name7b69d790-c467-454e-adbe-ef13cbcf8922-1957515030password12,12,84,96,12,71,7,18,46,7,167b69d790-c467-454e-adbe-ef13cbcf892215909060f32c9f43-38f5-41be-b5da-b614db34081f7b69d790-c467-454e-adbe-ef13cbcf8922-19512015030text7b69d790-c467-454e-adbe-ef13cbcf8922151509030

1f915d5b-319d-46c6-86f9-039cb9f13a207b69d790-c467-454e-adbe-ef13cbcf8922-19516515030flag7b69d790-c467-454e-adbe-ef13cbcf8922-19519515030text7b69d790-c467-454e-adbe-ef13cbcf89221509030

7bf95304-ee66-46d4-a52f-b933484fb5117fd86ab4-6159-40aa-bb10-8d76dd83de0dIn this example the results from a database query are used to load a work queue. Each new item is added individually so the corresponding row in the database can be updated with detail from the new item.-195-1052101207fd86ab4-6159-40aa-bb10-8d76dd83de0d15-1056030b4fa73ca-3d3f-4499-93a7-7a2af16803ea7fd86ab4-6159-40aa-bb10-8d76dd83de0d15-45903012bccd09-9d47-4b13-b75c-d68abbc7f5f47fd86ab4-6159-40aa-bb10-8d76dd83de0d-195-1515030textMy Server7fd86ab4-6159-40aa-bb10-8d76dd83de0d-1951515030textMy Database7fd86ab4-6159-40aa-bb10-8d76dd83de0d-1954515030textMy User Name7fd86ab4-6159-40aa-bb10-8d76dd83de0d-1957515030password12,12,84,96,12,71,7,18,46,7,167fd86ab4-6159-40aa-bb10-8d76dd83de0d159090607dc3bc9d-609f-48aa-b937-e518912af62a7fd86ab4-6159-40aa-bb10-8d76dd83de0d-19512015030text7fd86ab4-6159-40aa-bb10-8d76dd83de0d151509030

f81f5660-031f-471c-a938-ce4b2e25a8617fd86ab4-6159-40aa-bb10-8d76dd83de0d-19516515030flag7fd86ab4-6159-40aa-bb10-8d76dd83de0d-19519515030text7fd86ab4-6159-40aa-bb10-8d76dd83de0d1509030

a29e1201-f709-4c3e-8e80-9e44a339ee677fd86ab4-6159-40aa-bb10-8d76dd83de0d15225906001f243a6-4698-413d-a600-0d0d0f4d863c3b587caa-4269-4613-b0e0-6a5a6a3e5a667fd86ab4-6159-40aa-bb10-8d76dd83de0d12022560307fd86ab4-6159-40aa-bb10-8d76dd83de0d1591560307fd86ab4-6159-40aa-bb10-8d76dd83de0d157359030

a3be94c0-6d0f-4f71-b7b2-990ca2ee324d7fd86ab4-6159-40aa-bb10-8d76dd83de0d15300120305500f54e-b658-4553-8ec1-d38d34522d3263028273-43fc-4b45-acd3-cbfc99dd4e81ForEachSource Data7fd86ab4-6159-40aa-bb10-8d76dd83de0d1560012030887ec17e-8d0b-48b0-a708-44ced81f34b263028273-43fc-4b45-acd3-cbfc99dd4e817fd86ab4-6159-40aa-bb10-8d76dd83de0d15049590607e3e22ee-e941-4f59-8d48-07cd1859701b7fd86ab4-6159-40aa-bb10-8d76dd83de0d-19536015060collection7fd86ab4-6159-40aa-bb10-8d76dd83de0d150375903023b27463-67ef-4991-803f-98cd202cd98c7fd86ab4-6159-40aa-bb10-8d76dd83de0d51037590302da84235-7fc9-4e08-bbe6-4c42f297389a7fd86ab4-6159-40aa-bb10-8d76dd83de0d27037590607ea9c763-2345-41f1-80f9-7bcc41cbd4e17fd86ab4-6159-40aa-bb10-8d76dd83de0d3903759030

e724a124-f89c-4065-8658-3ebd68c634ae7fd86ab4-6159-40aa-bb10-8d76dd83de0d-19543515030textMy Queue7fd86ab4-6159-40aa-bb10-8d76dd83de0d-19525515060collection7fd86ab4-6159-40aa-bb10-8d76dd83de0d-19549515060collection7fd86ab4-6159-40aa-bb10-8d76dd83de0d2704959030

65cebb3b-272d-47e1-b61c-c7688e0ff1607fd86ab4-6159-40aa-bb10-8d76dd83de0d3904959060d70839d4-dec2-4193-85fc-beb16a19db53c606b907-8b1c-4930-b7e6-6a5c1602fde77fd86ab4-6159-40aa-bb10-8d76dd83de0d61549560307fd86ab4-6159-40aa-bb10-8d76dd83de0d5104351010f3c479c2-80bb-4f60-a794-66b3a59438e07fd86ab4-6159-40aa-bb10-8d76dd83de0d1543510100d5d2c75-2a00-459a-9d86-e4206dba08477fd86ab4-6159-40aa-bb10-8d76dd83de0d510495903052d46bca-c7b4-4ab2-85b8-a12b6f01f7157fd86ab4-6159-40aa-bb10-8d76dd83de0d-19557015030textReady30fb5d0a-2581-49e9-adc2-dc0dbc760336** NB The connection to the database is closed in the event of a problem.420180180120df43b852-d350-4f91-9d5b-19fba3690e6aeaa87818-4c0b-42c3-8767-5f6856f75b04** NB The connection to the database is closed in the event of a problem.3901201801208f327c00-7d43-40a6-89a3-32d6b4241ead7fd86ab4-6159-40aa-bb10-8d76dd83de0d** NB If the database could not be updated the new item is deleted.780390180120c606b907-8b1c-4930-b7e6-6a5c1602fde77fd86ab4-6159-40aa-bb10-8d76dd83de0d** NB Once the new item has been added the collection row is removed to prevent the item being added again on the next loop.570255180120e724a124-f89c-4065-8658-3ebd68c634ae7fd86ab4-6159-40aa-bb10-8d76dd83de0dA single-row collection is assembled to create a new work queue item.15375120609afc911b-ca76-42be-a44a-b0118627f5527fd86ab4-6159-40aa-bb10-8d76dd83de0dOnce the new item is added the corresponding row in the database is updated.1549512060ff5a11ef-ce3f-4d59-bb32-16aae6762eae7fd86ab4-6159-40aa-bb10-8d76dd83de0d** In this example the database table has columns used to identify rows that have not been added to the work queue.255-30180120a29e1201-f709-4c3e-8e80-9e44a339ee677fd86ab4-6159-40aa-bb10-8d76dd83de0dOnce the transaction is complete, the new item is marked to indicate that it can be worked, in this example with the tag 'Ready'.39060018090c6ea6887-0a0e-4d8c-958f-78d1f5c350537fd86ab4-6159-40aa-bb10-8d76dd83de0dThis example assumes that only items tagged as 'Ready' will be worked and that any item not tagged will be ignored (eg the 'Tag Filter' parameter will be used on the 'Get Next Item' action).1582518090cbfefe28-0040-4d8d-826a-05d5cb0e83277fd86ab4-6159-40aa-bb10-8d76dd83de0d2256009030d219985a-d1af-4da0-a2d6-1e27e19307a95a940b40-36e6-48c7-aef2-f224b948aac2In this example queue results are used to update the database from where the queue was originally loaded. After each row is updated, the corresponding queue item is tagged so the update cannot be repeated. If the database row cannot be found, the queue item is tagged differently so it can be dealt with separately.-195-1052701205a940b40-36e6-48c7-aef2-f224b948aac215-10560301d2a57d4-8552-4a69-9b88-a6eec7e293695a940b40-36e6-48c7-aef2-f224b948aac2-19536015060collection5a940b40-36e6-48c7-aef2-f224b948aac215270150307a428f7d-db04-4d47-918f-acca6fc8a8ece2c10847-5f4e-431a-aa6b-824f6518bba8ForEachItem IDs5a940b40-36e6-48c7-aef2-f224b948aac21551015030a129731b-5f54-4a5e-8f5f-a7003f6edceae2c10847-5f4e-431a-aa6b-824f6518bba85a940b40-36e6-48c7-aef2-f224b948aac2152259030

df4a2d52-ffdd-4cbb-abb7-28a90674cb975a940b40-36e6-48c7-aef2-f224b948aac2151206030ba13553b-a9f1-4740-a5bd-7b56b81e59fa5a940b40-36e6-48c7-aef2-f224b948aac2-19515015030timespan7.00:00:005a940b40-36e6-48c7-aef2-f224b948aac2-19518015030datetime5a940b40-36e6-48c7-aef2-f224b948aac2-19521015030datetime5a940b40-36e6-48c7-aef2-f224b948aac2151656030994c33e6-ee6f-422d-bed0-a4c984c1c64d5a940b40-36e6-48c7-aef2-f224b948aac2-19525515030textSynchronised5a940b40-36e6-48c7-aef2-f224b948aac2-19512015030textMy Queue5a940b40-36e6-48c7-aef2-f224b948aac215-30903086e22067-1a19-4087-b411-eeb4449851285a940b40-36e6-48c7-aef2-f224b948aac2-195-1515030textMy Server5a940b40-36e6-48c7-aef2-f224b948aac2-1951515030textMy Database5a940b40-36e6-48c7-aef2-f224b948aac2-1954515030textMy User Name5a940b40-36e6-48c7-aef2-f224b948aac2-1957515030password12,12,84,96,12,71,7,18,46,7,165a940b40-36e6-48c7-aef2-f224b948aac2-19546515030text5a940b40-36e6-48c7-aef2-f224b948aac2-19549515030flag5a940b40-36e6-48c7-aef2-f224b948aac2-19552515030text5a940b40-36e6-48c7-aef2-f224b948aac215159030

1f8a7631-6666-4f39-b707-d70706f8603b5a940b40-36e6-48c7-aef2-f224b948aac263034560305a940b40-36e6-48c7-aef2-f224b948aac22853459060d19cc95b-9712-4dfd-a01c-7821ca2c594c5a940b40-36e6-48c7-aef2-f224b948aac24053459030

3a3568df-331c-488b-962b-14b8eeb8da665a940b40-36e6-48c7-aef2-f224b948aac2525345906034435619-ed08-419f-a32e-14b3485ef760e9f81534-2fef-4c45-9669-3d409f13dc955a940b40-36e6-48c7-aef2-f224b948aac2Update the corresponding row in the database with detail from the completed item.150345120909bae7d6a-7728-4fc8-8169-041356b8ef2e5a940b40-36e6-48c7-aef2-f224b948aac2Once the update is complete, the item is tagged accordingly.3904351206013fac008-f7df-4d35-a46e-f623d8bd522a5a940b40-36e6-48c7-aef2-f224b948aac225543590302362e8bb-f46b-4751-b2f5-ffd98fa558095a940b40-36e6-48c7-aef2-f224b948aac2** NB A 'negative' tag filter is used here, ie to find items that are not tagged.225150180120994c33e6-ee6f-422d-bed0-a4c984c1c64d30fb5d0a-2581-49e9-adc2-dc0dbc7603362252106030df43b852-d350-4f91-9d5b-19fba3690e6a30fb5d0a-2581-49e9-adc2-dc0dbc7603362252709030

836b3738-839a-4975-8269-d71e2dc1f8ce30fb5d0a-2581-49e9-adc2-dc0dbc760336225330603030fb5d0a-2581-49e9-adc2-dc0dbc760336-60303452107b69d790-c467-454e-adbe-ef13cbcf89221533060307b69d790-c467-454e-adbe-ef13cbcf8922152709030

1f58ec36-404c-48e0-b7a6-682e60bd1e917b69d790-c467-454e-adbe-ef13cbcf8922152106030998daa06-7d37-41c7-b83a-ad6c9573a3029d158651-a3eb-4dbd-aa0f-cd586d5b324d7b69d790-c467-454e-adbe-ef13cbcf892210521060307b69d790-c467-454e-adbe-ef13cbcf8922** NB The connection to the database is closed in the event of a problem.4201801801204440075a-b396-4518-88d3-a36e862ce5e47b69d790-c467-454e-adbe-ef13cbcf892222521060304440075a-b396-4518-88d3-a36e862ce5e47b69d790-c467-454e-adbe-ef13cbcf89222252709030

2179f00d-a8f1-4f51-a28a-0318d3a04c457b69d790-c467-454e-adbe-ef13cbcf892222533060307b69d790-c467-454e-adbe-ef13cbcf8922-60303452107fd86ab4-6159-40aa-bb10-8d76dd83de0d-75457506607fd86ab4-6159-40aa-bb10-8d76dd83de0d** NB The connection to the database is closed in the event of a problem.36079518012059cf6779-4cfa-4485-9815-e5d1771ed9787fd86ab4-6159-40aa-bb10-8d76dd83de0d180675603059cf6779-4cfa-4485-9815-e5d1771ed9787fd86ab4-6159-40aa-bb10-8d76dd83de0d1807359030

9b478c76-4eac-4c49-90de-48e36e32f0697fd86ab4-6159-40aa-bb10-8d76dd83de0d18079560305a940b40-36e6-48c7-aef2-f224b948aac2** NB A time period to search is defined here, in this case the last 7 days.22501801201f8a7631-6666-4f39-b707-d70706f8603b5a940b40-36e6-48c7-aef2-f224b948aac2156159030

b3e9a240-fe19-4c70-99eb-91a0ec3d36435a940b40-36e6-48c7-aef2-f224b948aac21510509030

8f766006-cdd6-4951-904c-d8fbfaa473fd5a940b40-36e6-48c7-aef2-f224b948aac215111060305a940b40-36e6-48c7-aef2-f224b948aac2156601503002c5c6ab-0355-4290-ba4e-d065fd15bebd9293ae78-1d94-46f2-948f-c4aa76292c06ForEachItem IDs5a940b40-36e6-48c7-aef2-f224b948aac21590015030ac9bbf20-db34-4b2d-9e24-bc65bfb27c449293ae78-1d94-46f2-948f-c4aa76292c065a940b40-36e6-48c7-aef2-f224b948aac263073560305a940b40-36e6-48c7-aef2-f224b948aac22857359060fdbf2fb8-60e0-4ba3-a97b-c25d442c193e5a940b40-36e6-48c7-aef2-f224b948aac25257359060e8565a19-86c5-4633-b652-7b2a322bfce8974bc000-5520-4233-812a-9d9212c7ed875a940b40-36e6-48c7-aef2-f224b948aac2Update the corresponding row in the database with detail from the exception item.1507351209095e1eef2-bfe1-445b-971b-7a75683032af5a940b40-36e6-48c7-aef2-f224b948aac2153459030

1bf4c6b6-ffdf-4cf9-8296-5879a9134a145a940b40-36e6-48c7-aef2-f224b948aac2157359030

8944235a-b0be-43db-baff-d41804ca6cf25a940b40-36e6-48c7-aef2-f224b948aac2-19573515030datetime5a940b40-36e6-48c7-aef2-f224b948aac2-19576515030text5a940b40-36e6-48c7-aef2-f224b948aac2-19540515030datetime5a940b40-36e6-48c7-aef2-f224b948aac2** NB The connection to the database is closed in the event of a problem.3601125180120c3b44593-3d28-4a57-8b79-e106090632f05a940b40-36e6-48c7-aef2-f224b948aac21509906030c3b44593-3d28-4a57-8b79-e106090632f05a940b40-36e6-48c7-aef2-f224b948aac215010509030

6161ca68-217b-4c08-bc84-abe54af9fbfd5a940b40-36e6-48c7-aef2-f224b948aac2150111060305a940b40-36e6-48c7-aef2-f224b948aac2-90757809455a940b40-36e6-48c7-aef2-f224b948aac2** In this example the database table has columns for data from the work queue.4502251801209bae7d6a-7728-4fc8-8169-041356b8ef2e7fd86ab4-6159-40aa-bb10-8d76dd83de0d** In this example the database table has columns for data from the work queue.300240180120ff5a11ef-ce3f-4d59-bb32-16aae6762eae5a940b40-36e6-48c7-aef2-f224b948aac2-19555515030number5a940b40-36e6-48c7-aef2-f224b948aac25254359060dc522856-a8cb-4a71-ad56-377e96590edafb250103-a068-4040-b4d4-8473748010ee5a940b40-36e6-48c7-aef2-f224b948aac2525510101071b1c711-0fa5-40b2-bdaf-45756ad20cde5a940b40-36e6-48c7-aef2-f224b948aac2If the item is found to be an orphan it is tagged accordingly.39051012060ffb96626-d87f-49ba-bd09-4b2afd15f8f75a940b40-36e6-48c7-aef2-f224b948aac22555109030a4995444-0978-45bf-ba13-c673e1503dc85a940b40-36e6-48c7-aef2-f224b948aac21504351010a4995444-0978-45bf-ba13-c673e1503dc85a940b40-36e6-48c7-aef2-f224b948aac21505101010eb070447-bae7-458d-9179-decde34ddbaa5a940b40-36e6-48c7-aef2-f224b948aac2-19528515030textOrphaned5a940b40-36e6-48c7-aef2-f224b948aac2Once the update is complete, the item is tagged accordingly.39082512060680fcaf4-5253-4a75-80da-0f5ed99d1ccd5a940b40-36e6-48c7-aef2-f224b948aac225582590309a38d386-01ae-40c7-b72f-e39d094bba4f5a940b40-36e6-48c7-aef2-f224b948aac2525825906006dd937f-a3dc-4771-87ac-a180785378d87877ead2-ad85-45a5-8e24-fa5a4a85c4a25a940b40-36e6-48c7-aef2-f224b948aac252590010102bd81770-46a0-40b4-802d-5cb9f37e38c95a940b40-36e6-48c7-aef2-f224b948aac2If the item is found to be an orphan it is tagged accordingly.390900120604ffecb20-9323-4584-bd66-b845d0fbfc455a940b40-36e6-48c7-aef2-f224b948aac22559009030350b06c9-37aa-49dd-8cb3-5938b660fc6f5a940b40-36e6-48c7-aef2-f224b948aac21508251010350b06c9-37aa-49dd-8cb3-5938b660fc6f5a940b40-36e6-48c7-aef2-f224b948aac215090010103666986a-c372-472b-b12b-4ccd3e8619a95a940b40-36e6-48c7-aef2-f224b948aac24057359030

f77a2ae8-ecce-499e-a7e3-e3f6e8ba89e8151656030This process has not been designed to run, it is merely a collection diagram fragments based on a common theme. Each page is an example intended to illustrate how a particular task might be acheived in Blue Prism. These examples may be copied into a new diagram and modified to suit your needs.15302701508051564c-8931-4a3e-859b-8917cad6bdcc 0421.2Send Email (basic)0841.25Get Mail (basic)0841.25Send Mail (using a work queue)2294301.2Get Mail (using a work queue)512970.699999915-10560305748fd09-966c-4217-b701-e6e5a0d81b62-195-10515090eee09152-56a1-47e9-9d1c-5d4ef8186839-195-10515090eee09152-56a1-47e9-9d1c-5d4ef818683915-1056030e45957db-932d-4dc1-8f1b-01c091cd7e5ceee09152-56a1-47e9-9d1c-5d4ef818683915906030eee09152-56a1-47e9-9d1c-5d4ef818683915-45903028543f54-9d0e-4233-9338-8a3d4f1a7ed4eee09152-56a1-47e9-9d1c-5d4ef8186839-195-3015030textMy Servereee09152-56a1-47e9-9d1c-5d4ef8186839-195015030number25eee09152-56a1-47e9-9d1c-5d4ef8186839-1956015030textMy User Nameeee09152-56a1-47e9-9d1c-5d4ef8186839-1959015030password12,12,84,96,12,71,7,18,46,7,16eee09152-56a1-47e9-9d1c-5d4ef8186839-1953015030flagFalseeee09152-56a1-47e9-9d1c-5d4ef8186839151590303a13e8c5-099e-422d-b2bf-eaeb8cfc8267eee09152-56a1-47e9-9d1c-5d4ef8186839-19516515030textyou@there.comeee09152-56a1-47e9-9d1c-5d4ef8186839-19522515030textHelloeee09152-56a1-47e9-9d1c-5d4ef8186839-19525515030textHow are you?eee09152-56a1-47e9-9d1c-5d4ef8186839-19519515030textyou@overthere.comeee09152-56a1-47e9-9d1c-5d4ef8186839-19530015060collectioneee09152-56a1-47e9-9d1c-5d4ef8186839-19513515030textme@here.com90bf9d70-7b74-463a-a04c-162494b3357d-195-1051509090bf9d70-7b74-463a-a04c-162494b3357d15-1056030165c8a52-59f8-400d-aace-88015fef199b90bf9d70-7b74-463a-a04c-162494b3357d15-4590301da02c4c-8c87-45b3-823c-7dcff6a3918e90bf9d70-7b74-463a-a04c-162494b3357d-195-3015030textMy Server90bf9d70-7b74-463a-a04c-162494b3357d-195015030number11090bf9d70-7b74-463a-a04c-162494b3357d-1956015030textMy User Name90bf9d70-7b74-463a-a04c-162494b3357d-1959015030password12,12,84,96,12,71,7,18,46,7,1690bf9d70-7b74-463a-a04c-162494b3357d-1953015030flagFalse90bf9d70-7b74-463a-a04c-162494b3357d15159030

f6e835ec-d715-458a-b9c2-8168b62ffa6990bf9d70-7b74-463a-a04c-162494b3357d-19515015060collection90bf9d70-7b74-463a-a04c-162494b3357d15906030cb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c-195-105150909093dead-8b8b-4f1d-8c62-d22d9874b40f-195-105150909093dead-8b8b-4f1d-8c62-d22d9874b40f15-10560305f75adde-cf9a-4b1b-8554-661e2ed0d0069093dead-8b8b-4f1d-8c62-d22d9874b40f156756030cb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c15-105603088b0e52f-2569-44d4-97d7-9c084722c367cb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c3004206030cb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c-390-3015030textMy Servercb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c-390015030number25cb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c-3906015030textMy User Namecb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c-3909015030password12,12,84,96,12,71,7,18,46,7,16cb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c-3903015030flagFalsecb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c-195015030textyou@there.comcb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c-1956015030textHellocb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c-1959015030textHow are you?cb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c-1953015030textyou@overthere.comcb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c-19513515060collectioncb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c-195-3015030textme@here.comcb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c-19521015030textMy Email Queuecb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c-19524015030textMy Processcb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c-19527015030textcb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c1803459030

139ece7f-931b-44ec-bfb0-c607e54928c7cb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c18042090606ce0acb3-bf62-4b97-b6c7-735b288af16760a96d4f-c35b-44b0-b791-e9aa71e43527cb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c152259030

3dfd7e5a-0cae-4bd4-87e7-a9e29b211b4fcb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c1518060303341f7c6-c9d2-4cc8-b56d-24641dcf2da7cb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c156090305b6ae2ee-920d-4695-baaf-59f128b280a2cb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c-19543515060collectioncb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c151209060d559c9d0-43ca-401d-b3f4-b59fccf3d96bcb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c-19533015030textcb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c-19536015030textcb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c-19539015030numbercb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c18049590300a60a03b-4729-4980-9485-f3646e98bc0bcb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c180555903044bb0104-073f-4143-8028-fe62574fbf5bcb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c905551010f79ef0d6-1630-4c42-9a1d-3a1b56727b63cb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c90345101034a83544-6dce-46c3-b62a-a8b705307febcb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c90600101044bb0104-073f-4143-8028-fe62574fbf5bcb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c3005559030

eabb6af8-5f59-406b-948d-c12660e108ffcb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c30049560304e5119f9-8bec-4074-8547-16e9ed284a98cb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c300600603002adf6c2-9457-44ff-ac5d-a4d8dfbcd6cccb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c12046524060cb23ee89-074b-4aa5-9e0d-fbaf7a64ac3cBefore sending the mail add an item to a work queue15-1512090da7fb6c8-face-4713-bfc8-5ee4f147ae90cb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c180300903034a83544-6dce-46c3-b62a-a8b705307febcb23ee89-074b-4aa5-9e0d-fbaf7a64ac3cThen proceed to 'work' the item by sending the mail and marking the item complete.180225120905a2f6ded-c809-4804-bd03-47a91660c10ccb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c** In this example tags are applied to help catagorise items by process and machine name.2259015090d559c9d0-43ca-401d-b3f4-b59fccf3d96bcb23ee89-074b-4aa5-9e0d-fbaf7a64ac3c** The same tags are used to specify which new items to 'get'; if other processes are also adding new items to the email queue, this process will only send its own mail.3902551509034a83544-6dce-46c3-b62a-a8b705307feb9093dead-8b8b-4f1d-8c62-d22d9874b40f1509030

225aeb59-4e4c-44ce-9248-ef45fe4769c69093dead-8b8b-4f1d-8c62-d22d9874b40f-19516515060collection9093dead-8b8b-4f1d-8c62-d22d9874b40f1560120302454b576-b288-44d1-aa35-1ad5a9eee6f5d54c0158-0e18-4e99-84d4-d1c5dacd2ab6ForEachMail9093dead-8b8b-4f1d-8c62-d22d9874b40f15615120302a47ca9f-dfd7-4192-8646-aa5c9d87543dd54c0158-0e18-4e99-84d4-d1c5dacd2ab69093dead-8b8b-4f1d-8c62-d22d9874b40f151509030

9d5cde7a-8bee-44c3-9a7a-47ab850f29b29093dead-8b8b-4f1d-8c62-d22d9874b40f-19528515030flag9093dead-8b8b-4f1d-8c62-d22d9874b40f152259060eda21b52-ce2b-4ab3-bf5c-d842ba51cadf451de040-24ca-4bff-a1e5-0e69e075bf889093dead-8b8b-4f1d-8c62-d22d9874b40f-19522515030textMy Email Queue9093dead-8b8b-4f1d-8c62-d22d9874b40f40542090305410088b-db2d-4c82-9fbf-184fe80a3dd39093dead-8b8b-4f1d-8c62-d22d9874b40f151056030a95324c8-0c47-4b90-ab6a-f03e1161bcad9093dead-8b8b-4f1d-8c62-d22d9874b40f-19525515030text9093dead-8b8b-4f1d-8c62-d22d9874b40f-19545015030textC:\Temp\Email Attachments\9093dead-8b8b-4f1d-8c62-d22d9874b40f4053759030fb6b8240-f0ca-4a6f-893a-269e72edf33f9093dead-8b8b-4f1d-8c62-d22d9874b40f405315906055905ede-4f14-4916-b470-90253e3c764c9093dead-8b8b-4f1d-8c62-d22d9874b40f-19548015030text9093dead-8b8b-4f1d-8c62-d22d9874b40f6453009030

318c2099-d389-4f73-9a46-6b65fccbdacc9093dead-8b8b-4f1d-8c62-d22d9874b40f-19557015060collection9093dead-8b8b-4f1d-8c62-d22d9874b40f-19561515030flag9093dead-8b8b-4f1d-8c62-d22d9874b40f-19564515030text9093dead-8b8b-4f1d-8c62-d22d9874b40f1653609060fec31aaf-b377-4420-887d-e80c41f906659093dead-8b8b-4f1d-8c62-d22d9874b40f1656159030

9311b2ba-1f81-4af9-b060-964968dd96ff9093dead-8b8b-4f1d-8c62-d22d9874b40f1653009030f6b3b607-7efc-4257-a631-14b459f8f94c9093dead-8b8b-4f1d-8c62-d22d9874b40f645450120307c30676e-2604-4ffb-b05c-b5495426744afa986148-5a11-419d-b486-982a6ae53acaForEachFiles9093dead-8b8b-4f1d-8c62-d22d9874b40f64561512030d1d57dfe-77ce-44ff-a8f6-2a3b67535eaafa986148-5a11-419d-b486-982a6ae53aca9093dead-8b8b-4f1d-8c62-d22d9874b40f64549590300131348a-4156-413c-8f5d-6d41174b024f9093dead-8b8b-4f1d-8c62-d22d9874b40f6455559060a90df94f-65c7-41e3-93eb-4f28301984cd9093dead-8b8b-4f1d-8c62-d22d9874b40fPrepare a new queue item by collecting the mail details16522512090c264da0c-82e9-40f8-860b-1255ecae1aee9093dead-8b8b-4f1d-8c62-d22d9874b40fDownload any attchments to a new folder40522512090c98a0da9-9b81-465e-8595-bb30fba802959093dead-8b8b-4f1d-8c62-d22d9874b40fAppend the attachment file path to the new queue item6452251209043f94bcf-b3eb-4ade-b9b7-32a01acba7d59093dead-8b8b-4f1d-8c62-d22d9874b40f52542010102411bfe3-dc2c-4cd9-bdff-01ac0e8c04899093dead-8b8b-4f1d-8c62-d22d9874b40f5252251010af526fc8-5dd4-42e4-8aac-4fc911dcc10f9093dead-8b8b-4f1d-8c62-d22d9874b40f6453759060ce1f099d-10cc-4f24-aae5-21d4fe0c0d0e245bfa97-4f3f-4bcf-9f38-331ffd9b65b19093dead-8b8b-4f1d-8c62-d22d9874b40f75037560309093dead-8b8b-4f1d-8c62-d22d9874b40f2853601010a4ae26a9-9396-4d25-b938-6f1728d1256c9093dead-8b8b-4f1d-8c62-d22d9874b40f2852251010fdf28e1c-b254-4272-909b-c655d7541c1b9093dead-8b8b-4f1d-8c62-d22d9874b40fAdd the new item to the queue300615120905df038b5-4dbf-4fd6-ad56-2d78c4b946939093dead-8b8b-4f1d-8c62-d22d9874b40fThe message has already been loaded into the queue.15330120909311b2ba-1f81-4af9-b060-964968dd96ff9093dead-8b8b-4f1d-8c62-d22d9874b40f-19536015060collection9093dead-8b8b-4f1d-8c62-d22d9874b40f15-45903090fc2b4c-6034-4083-bfe1-bf6d938135af9093dead-8b8b-4f1d-8c62-d22d9874b40f-195-3015030textMy Server9093dead-8b8b-4f1d-8c62-d22d9874b40f-195015030number259093dead-8b8b-4f1d-8c62-d22d9874b40f-1956015030textMy User Name9093dead-8b8b-4f1d-8c62-d22d9874b40f-1959015030password12,12,84,96,12,71,7,18,46,7,169093dead-8b8b-4f1d-8c62-d22d9874b40f-1953015030flagFalse151656030This process has not been designed to run, it is merely a collection diagram fragments based on a common theme. Each page is an example intended to illustrate how a particular task might be acheived in Blue Prism. These examples may be copied into a new diagram and modified to suit your needs.153027015085a45880-b66b-4fa4-a8dd-d7dc66b46f25 001.25Font Smoothing001.25Screen Resolution-6301.2Folder Existance001.2File Existance001.2515-105603092591677-52c5-4dad-8316-407d57089a82-195-10515090597e3fcb-4e0a-498a-8c4d-7c95af0232b0In this example a check is made to see if Font Smoothing is switched on. Character matching is dependant on smoothing being off, so an exception is thrown if it is found to be enabled.-195-10521090597e3fcb-4e0a-498a-8c4d-7c95af0232b015-1056030e077542e-3eb0-4382-aef7-7a1c35855fbf597e3fcb-4e0a-498a-8c4d-7c95af0232b0151206030597e3fcb-4e0a-498a-8c4d-7c95af0232b015-3012030

4b9ed8b6-a5a2-4d2f-9c15-2b1732307aa6597e3fcb-4e0a-498a-8c4d-7c95af0232b0-195-3015030flag597e3fcb-4e0a-498a-8c4d-7c95af0232b01545906071682972-25a6-4435-9d65-1ac207e795ca1fd83885-4352-4782-a75e-ac5bc3b7a95b597e3fcb-4e0a-498a-8c4d-7c95af0232b013545906020a60c0a-44d0-49e2-8764-38564a7d703aIn this example a check is made to see what the current screen resolution is. Some integration techniques may rely on a specific resolution, so here an exception is thrown if the resolution is not set correctly.-195-1052109020a60c0a-44d0-49e2-8764-38564a7d703a15-1056030317caafb-b84d-4513-91d0-054c17cf827720a60c0a-44d0-49e2-8764-38564a7d703a15120603020a60c0a-44d0-49e2-8764-38564a7d703a15-3012030

73bc50e3-eebd-467e-9fe5-15c64b6cde1720a60c0a-44d0-49e2-8764-38564a7d703a-195-3015030number20a60c0a-44d0-49e2-8764-38564a7d703a-195015030number20a60c0a-44d0-49e2-8764-38564a7d703a15459060d9fc9d9a-880c-4ea1-b47d-6f3f3421740dbcd5f0bb-116b-47e5-a499-c59fe85901d220a60c0a-44d0-49e2-8764-38564a7d703a1354590605c945ed8-44c2-4315-921f-f9066191e80a-195-105150905c945ed8-44c2-4315-921f-f9066191e80a15-10560307902d944-e7cf-4a89-b7df-8ced7057c49b5c945ed8-44c2-4315-921f-f9066191e80a1512060305c945ed8-44c2-4315-921f-f9066191e80a15-3012030

864c58b0-91f8-4ee6-8410-f47c9c54caaa5c945ed8-44c2-4315-921f-f9066191e80a-195015030flag5c945ed8-44c2-4315-921f-f9066191e80a-195-3015030textZ:\My Data5c945ed8-44c2-4315-921f-f9066191e80a154590601910932d-197a-4c03-896a-c831a2a2434c29ad8391-3c16-45ac-9bb7-40d6f5a038355c945ed8-44c2-4315-921f-f9066191e80a1354590608ffc4053-a008-42f3-a64c-0e0ffeea14ba-195-105150908ffc4053-a008-42f3-a64c-0e0ffeea14ba15-105603048789700-0153-4713-bfca-cb49608e5d608ffc4053-a008-42f3-a64c-0e0ffeea14ba1512060308ffc4053-a008-42f3-a64c-0e0ffeea14ba15-3012030

89de18b8-6dbb-41c8-8ab8-caac6a0597b98ffc4053-a008-42f3-a64c-0e0ffeea14ba-195015030flag8ffc4053-a008-42f3-a64c-0e0ffeea14ba-195-3015030textZ:\My Data\My File.txt8ffc4053-a008-42f3-a64c-0e0ffeea14ba1545906056c6f743-69ad-498e-8be8-ff1a751ce3eac7aa7ddc-2d16-4c8b-8493-0ec55b55912b8ffc4053-a008-42f3-a64c-0e0ffeea14ba135459060151656030This process has not been designed to run, it is merely a collection diagram fragments based on a common theme. Each page is an example intended to illustrate how a particular task might be acheived in Blue Prism. These examples may be copied into a new diagram and modified to suit your needs.1530270150c8f14ba1-0141-40ac-b9be-d750972c8d02 001.25Read CSV File-83421.25Read Excel File511301.25Read XML File51-230.5999999Validate File Structure0841.25Remove Blank Rows0421.25Sort File Data0-841.25Read Files (basic)03901.25Read Files (intermediate)51541.1Read Files (advanced)213930.8Read Files (with permission)51731.1Move File513781.25Maintain Folder2005040.699999915-10560300d9cbd32-0851-457f-b32c-8179a90e4aa4-195-105150901ce41d9e-d7cb-4c8a-970c-8147679984d3-195-10515090fb5551e4-348d-437d-a4a0-648950b51223-195-10515090fb5551e4-348d-437d-a4a0-648950b5122315-10560309d7eb037-8f20-490b-946a-54086d6e35a7fb5551e4-348d-437d-a4a0-648950b51223-195-3015030textC:\Temp\My File.csvfb5551e4-348d-437d-a4a0-648950b5122315-459030

46c327b5-508c-4e20-abff-6bd5f3a13faefb5551e4-348d-437d-a4a0-648950b51223-1953015030numberfb5551e4-348d-437d-a4a0-648950b51223151590302e10de37-ba3e-4ad1-bc15-7855afb37bb9fb5551e4-348d-437d-a4a0-648950b5122315609030

dd2d8578-a817-4c6f-b493-c405440df7cdfb5551e4-348d-437d-a4a0-648950b51223-1956015030textfb5551e4-348d-437d-a4a0-648950b51223151059030

cbe612f4-99be-49d9-9648-85f81af67c0b1ce41d9e-d7cb-4c8a-970c-8147679984d315-1056030e9b30ece-129e-4a3b-bbf0-a2eefbea3d881ce41d9e-d7cb-4c8a-970c-8147679984d315-159030

75f15580-6821-4db4-ac69-61b85e82d2061ce41d9e-d7cb-4c8a-970c-8147679984d3-1956015060collection1ce41d9e-d7cb-4c8a-970c-8147679984d3-1951515030flagTrue1ce41d9e-d7cb-4c8a-970c-8147679984d3-195-1515030textC:\Temp\My File.csv1ce41d9e-d7cb-4c8a-970c-8147679984d3** Copy and paste the text below into Notepad to create an example CSV file-40515210901ce41d9e-d7cb-4c8a-970c-8147679984d3ACC_NO,NAME1,NAME2,STAFF,JOINED 1001,Dagless,Rick,TRUE,21/01/2001 2002,Reed,Thornton,FALSE,22/02/2002 3003,Sanchez,Lucien,FALSE,23/03/2003 4004,Asher,Liz,TRUE,24/04/2004-405120210901ce41d9e-d7cb-4c8a-970c-8147679984d3151806030fb5551e4-348d-437d-a4a0-648950b51223-19512015060collectionfb5551e4-348d-437d-a4a0-648950b51223153456030fb5551e4-348d-437d-a4a0-648950b51223151659030701e80b6-b1b3-43e6-ab00-e3b3179dc1fcfb5551e4-348d-437d-a4a0-648950b51223-60-15300150fb5551e4-348d-437d-a4a0-648950b51223180105603004715383-7c8b-46a8-a484-4a3d85e94e65fb5551e4-348d-437d-a4a0-648950b512231801659030d769e5d8-bf5e-4667-b934-59d29bdd439afb5551e4-348d-437d-a4a0-648950b512231802256030fb5551e4-348d-437d-a4a0-648950b51223** In the event of a problem Excel is shut down before releasing the exception.37510518012004715383-7c8b-46a8-a484-4a3d85e94e658342a743-6109-4f11-b50f-210734aa2af7This example searches for files in a folder and then reads them one by one. Once a file has been read it is renamed to exclude it from any future searches.-195-105150908342a743-6109-4f11-b50f-210734aa2af715-1056030b94bb6f1-1fc0-4541-abd9-fcb2dfcee3bf8342a743-6109-4f11-b50f-210734aa2af71563060308342a743-6109-4f11-b50f-210734aa2af715-459030

abf67322-82de-4503-8838-b128dd31b81e8342a743-6109-4f11-b50f-210734aa2af7-19513515030flag8342a743-6109-4f11-b50f-210734aa2af7-19516515030text8342a743-6109-4f11-b50f-210734aa2af7-1957515060collection8342a743-6109-4f11-b50f-210734aa2af7-195-1515030textC:\Temp8342a743-6109-4f11-b50f-210734aa2af7-1951515030text*.csv8342a743-6109-4f11-b50f-210734aa2af715105180309f15e40a-abdd-4f78-9ed8-279fa43f075e403d41b3-6f83-42db-aa86-ed5af2e8025dForEachFiles8342a743-6109-4f11-b50f-210734aa2af71557018030c3abd1f3-52ea-45da-8044-2f2a4f7c1ab2403d41b3-6f83-42db-aa86-ed5af2e8025d8342a743-6109-4f11-b50f-210734aa2af715390603012ea26d8-a364-45be-be59-96ceda01f4d08342a743-6109-4f11-b50f-210734aa2af7-19539015030text8342a743-6109-4f11-b50f-210734aa2af7154359030

25706306-084a-441e-a524-94230eb208b18342a743-6109-4f11-b50f-210734aa2af7153090600080b8d3-854c-4580-bdec-4e1369e91d155ca944f5-469c-4d84-9ac2-e53d2d47170c8342a743-6109-4f11-b50f-210734aa2af71203060308342a743-6109-4f11-b50f-210734aa2af715495906049764843-7cdd-472f-b860-29d73977a52b5db1dfce-9358-465c-9d49-dda6bdebb6628342a743-6109-4f11-b50f-210734aa2af712049560304f6cd6e1-fdd8-4f40-a4b0-8e7553d7e8b4This example simply reads the first row of data in the file to check the column names are as expected. The exception handling will show us if the file is not as it should be.-195-105180904f6cd6e1-fdd8-4f40-a4b0-8e7553d7e8b415-1056030b0249df8-fb91-42db-adcb-b8de111bc0ad4f6cd6e1-fdd8-4f40-a4b0-8e7553d7e8b44051206030fdc9f197-033f-4d47-b654-37b089ea6969This example checks for blanks by testing whether all the values on each row are empty. If they are, the row is removed from the collection.-195-10515090fdc9f197-033f-4d47-b654-37b089ea696915-105603076df1695-6f0d-4f86-8c0f-30facd21ac1e33f4386b-f636-4d85-b88f-5012e04682cd-195-1051509033f4386b-f636-4d85-b88f-5012e04682cd15-1056030208d9ae4-f887-4afc-a2bb-8a6d840bac1833f4386b-f636-4d85-b88f-5012e04682cd1512060304f6cd6e1-fdd8-4f40-a4b0-8e7553d7e8b415-3012030e0d8bcf5-35e0-42ec-9298-cd907816f5260d60218f-7c56-4e1b-8119-a01f24eadf25ForEachFile Data4f6cd6e1-fdd8-4f40-a4b0-8e7553d7e8b41519512030bf077156-3c7d-4e28-b074-0c2738408a1c0d60218f-7c56-4e1b-8119-a01f24eadf254f6cd6e1-fdd8-4f40-a4b0-8e7553d7e8b41545906044816708-4337-4bd2-a1fa-cd90f9aaf0534f6cd6e1-fdd8-4f40-a4b0-8e7553d7e8b440519560304f6cd6e1-fdd8-4f40-a4b0-8e7553d7e8b4-19513515030text4f6cd6e1-fdd8-4f40-a4b0-8e7553d7e8b4At this point we know the file columns are as expected and there is no need to continue looping through the file data.270120150608abe0230-f67f-47e5-ba40-626f4c0503134f6cd6e1-fdd8-4f40-a4b0-8e7553d7e8b4-600225904f6cd6e1-fdd8-4f40-a4b0-8e7553d7e8b41204560308ef84151-6c21-4dd4-a18e-11fb7b91296a4f6cd6e1-fdd8-4f40-a4b0-8e7553d7e8b4At this point we know the file does not contain the columns we want.2704515060c193bb15-f566-47fb-b597-1750862641e14f6cd6e1-fdd8-4f40-a4b0-8e7553d7e8b44054560304f6cd6e1-fdd8-4f40-a4b0-8e7553d7e8b4If we reach this point the collection must be empty.2701951506070828168-692a-4cc0-9141-5624083283084f6cd6e1-fdd8-4f40-a4b0-8e7553d7e8b415120101090e757a8-0106-4fe4-96d6-8e3ee4d84ae3fdc9f197-033f-4d47-b654-37b089ea696915-3012030dc959711-93ee-4093-847d-1cd6cae087be68eb13ba-9435-4d43-96f1-8b58ffcbb7cfForEachFile Datafdc9f197-033f-4d47-b654-37b089ea696915120120308a8960e0-2572-489f-9e22-cabf090e790b68eb13ba-9435-4d43-96f1-8b58ffcbb7cffdc9f197-033f-4d47-b654-37b089ea6969-1954515030textfdc9f197-033f-4d47-b654-37b089ea696913512010103c0b945d-1f71-40cc-a7d1-a406f8122516fdc9f197-033f-4d47-b654-37b089ea696915459060c5e49b29-0150-4983-8421-bc524f02716b3c0b945d-1f71-40cc-a7d1-a406f8122516fdc9f197-033f-4d47-b654-37b089ea696913545903021831053-8acd-4582-bfea-c50f7c047d8ffdc9f197-033f-4d47-b654-37b089ea696915180603033f4386b-f636-4d85-b88f-5012e04682cd15-309030

89f26e07-89ea-4f80-a8eb-467e7bc0185433f4386b-f636-4d85-b88f-5012e04682cd-1957515030flag33f4386b-f636-4d85-b88f-5012e04682cd-19510515030text33f4386b-f636-4d85-b88f-5012e04682cd15459060c6bcaeef-a96b-4be6-a37e-8eec542829356699fd33-71f4-42ef-a710-a40e54a92d7233f4386b-f636-4d85-b88f-5012e04682cd1204560308342a743-6109-4f11-b50f-210734aa2af7Logic to read the file goes here.1519515090bf70ad2c-aae2-4a29-9682-b9c1fb7fe3f21ce41d9e-d7cb-4c8a-970c-8147679984d3Logic to add data to a work queue could go here. See other templates for examples of populating a queue.159015090daa4d802-1e08-4e06-8282-7943f7aaba6d41dde786-7d93-4f2f-9260-33cb30d468b6This example searches for files in a folder and then reads them one by one. If a file is read successfully it is moved to an archive folder, otherwise it is moved to an exception folder.-195-1051809041dde786-7d93-4f2f-9260-33cb30d468b615-1056030d70bef37-d1c9-4122-9ded-bf12aad1e79033f4386b-f636-4d85-b88f-5012e04682cd-195-1515060collection33f4386b-f636-4d85-b88f-5012e04682cd** NB This page assumes the source collection has been filled from elsewhere.195-90180120208d9ae4-f887-4afc-a2bb-8a6d840bac18fdc9f197-033f-4d47-b654-37b089ea6969-195-1515060collectionfdc9f197-033f-4d47-b654-37b089ea6969** NB This page assumes the source collection has been filled from elsewhere.210-9018012076df1695-6f0d-4f86-8c0f-30facd21ac1e4f6cd6e1-fdd8-4f40-a4b0-8e7553d7e8b4** NB This page assumes the source collection has been filled from elsewhere.210-90180120b0249df8-fb91-42db-adcb-b8de111bc0ad4f6cd6e1-fdd8-4f40-a4b0-8e7553d7e8b4-195-1515060collection41dde786-7d93-4f2f-9260-33cb30d468b615870603041dde786-7d93-4f2f-9260-33cb30d468b615-309030

94ab3937-030a-45b8-bca1-041eb88028c441dde786-7d93-4f2f-9260-33cb30d468b6-19513515030flag41dde786-7d93-4f2f-9260-33cb30d468b6-19516515030text41dde786-7d93-4f2f-9260-33cb30d468b6-1957515060collection41dde786-7d93-4f2f-9260-33cb30d468b6-195-1515030textC:\Temp41dde786-7d93-4f2f-9260-33cb30d468b6-1951515030text*.csv41dde786-7d93-4f2f-9260-33cb30d468b6151202103004b5eff3-e9c4-4c0a-b32a-a60e959e135a3a857090-0462-469f-b3a4-c025b580ddcbForEachFiles41dde786-7d93-4f2f-9260-33cb30d468b61570521030a16f3041-efcb-4291-8a55-7180bab3b3993a857090-0462-469f-b3a4-c025b580ddcb41dde786-7d93-4f2f-9260-33cb30d468b6154590607136394b-d1ef-42ab-87b2-affb156c612030dfb691-5026-4a36-96fe-b5011c1254a641dde786-7d93-4f2f-9260-33cb30d468b612045603041dde786-7d93-4f2f-9260-33cb30d468b6Logic to read the file goes here, within the exception block.1521015090223978e7-9fad-4128-89df-ea41a3ee3abeaf416131-3116-4e14-9549-34607339061dThis example is an attempt to mitigate against potential problems when moving a file. Although this page may at first seem convoluted, moving a file is not always as straight forward as it may seem. For example, a large file may take some time to move. Similarly, if the destination folder contains many files the operating system (Windows) may take some time to check the folder does not already contain a file with the same name.-195-12027015041dde786-7d93-4f2f-9260-33cb30d468b621034560300f9704b6-5575-44a4-81c2-3d5c33a8191741dde786-7d93-4f2f-9260-33cb30d468b6-19561515030textC:\Temp\Archive41dde786-7d93-4f2f-9260-33cb30d468b6-19564515030textC:\Temp\Exceptionaf416131-3116-4e14-9549-34607339061d15-1056030736c188e-bbff-4adc-a326-eece206c3bfcaf416131-3116-4e14-9549-34607339061d157056030af416131-3116-4e14-9549-34607339061d-1951515030textaf416131-3116-4e14-9549-34607339061d-19515015030flagaf416131-3116-4e14-9549-34607339061d15309060449340c0-173d-4fb2-b8ea-fa8fa92e22f76c8dfc63-a741-403a-8035-d2588ed301f3af416131-3116-4e14-9549-34607339061d15-456030

d050b030-159b-433c-80ec-19ff5db49193af416131-3116-4e14-9549-34607339061d120306030af416131-3116-4e14-9549-34607339061d152409060c36ea3e0-7738-46c9-8a97-6ff2d6626b4ff0bee048-5bfa-4edf-ba33-30da5c58fd95af416131-3116-4e14-9549-34607339061d151656030

723bed4d-2b52-49dc-b694-cc5481e27205af416131-3116-4e14-9549-34607339061d153156030

3c919cef-9ccf-4025-8390-14faa5cebffbaf416131-3116-4e14-9549-34607339061d-19518015030textaf416131-3116-4e14-9549-34607339061d15390906005b3bdeb-fc84-4f01-8b6f-b113ff038ef916249db7-dabc-4cad-a4e7-0e56e3955f8aaf416131-3116-4e14-9549-34607339061d-19525515030flagaf416131-3116-4e14-9549-34607339061d-19528515030textaf416131-3116-4e14-9549-34607339061d1203906030af416131-3116-4e14-9549-34607339061d-19522515030textaf416131-3116-4e14-9549-34607339061d1203156030f0bee048-5bfa-4edf-ba33-30da5c58fd95af416131-3116-4e14-9549-34607339061d1554090601221abce-498f-4b9c-9bfb-04fe1a599e5049a85682-a0a0-4a73-9127-0e67235911f0af416131-3116-4e14-9549-34607339061d154656030

171e4c24-616a-4f6a-8427-d910a82eaea4af416131-3116-4e14-9549-34607339061d3305406030af416131-3116-4e14-9549-34607339061d-1954515030textaf416131-3116-4e14-9549-34607339061d15105603057f60874-d949-4c2c-b7f2-2999c5e11cd6af416131-3116-4e14-9549-34607339061d-195-1515030textaf416131-3116-4e14-9549-34607339061d2253156030b0c30ab9-6368-46e8-804b-a67383fbc2f7af416131-3116-4e14-9549-34607339061d1206306030

ff771aae-5aa6-4d28-896c-b1a5ccd407c1af416131-3116-4e14-9549-34607339061d1207059060e2690484-8c9d-4425-b2da-e08e89528ebc4c4278ad-d900-4a41-9f17-3135cca65cffaf416131-3116-4e14-9549-34607339061d2257056030af416131-3116-4e14-9549-34607339061d120465603005b3bdeb-fc84-4f01-8b6f-b113ff038ef9af416131-3116-4e14-9549-34607339061d22554090604466041a-6958-491b-9e97-60bec9e42f83ee7b53ad-5a60-46ed-bdeb-0f0e44b5ef14af416131-3116-4e14-9549-34607339061d22546560302cd77b09-2266-42da-8662-b52e360dabb3af416131-3116-4e14-9549-34607339061d-19546515030number30af416131-3116-4e14-9549-34607339061dFile may be in transit1205406030b8c21671-ceba-4d81-8281-3406034e683aaf416131-3116-4e14-9549-34607339061d-1957515030flagFalseaf416131-3116-4e14-9549-34607339061d156309060e2690484-8c9d-4425-b2da-e08e89528ebcce931f17-6d42-4e20-b1b1-6f6e19911652af416131-3116-4e14-9549-34607339061d-19510515030flagTrueaf416131-3116-4e14-9549-34607339061d22524090606c97aabd-7e98-4092-a60e-bac7a2ae787044ba00bd-417c-4b9e-9778-781873212c1faf416131-3116-4e14-9549-34607339061d330240603041dde786-7d93-4f2f-9260-33cb30d468b61563090604b015dfd-196c-47dc-98e9-b378f550aa74af416131-3116-4e14-9549-34607339061d41dde786-7d93-4f2f-9260-33cb30d468b621063090604e9bbb09-6d63-4268-b449-14105d0d601eaf416131-3116-4e14-9549-34607339061d41dde786-7d93-4f2f-9260-33cb30d468b6-7515033022541dde786-7d93-4f2f-9260-33cb30d468b621070510104b015dfd-196c-47dc-98e9-b378f550aa7441dde786-7d93-4f2f-9260-33cb30d468b6An exception occurred reading the file, so move it to an exception folder so it is not read again. Make a note of the exception detail and keep going.21043515090dfc9f4f8-a0dd-44aa-a016-1d0543c29b6241dde786-7d93-4f2f-9260-33cb30d468b6The file was read successfully, so move it to an archive folder so it is not read again.1543515090a3049310-493e-4a28-86bc-927c6fb4c2408e1d0d46-3a1b-4c0e-957b-a19357d70246This example searches for files in a folder and then reads them one by one. If a file is read successfully it is moved to an archive folder, otherwise it is moved to an exception folder. The key assumption here is that items added to the queue will only be worked if they have a certain tag, and the tag is only applied once the file has been moved to the archive folder. In the event of an exception any new items that have not been tagged will be deleted.-195-10527015041dde786-7d93-4f2f-9260-33cb30d468b6-19551015030text41dde786-7d93-4f2f-9260-33cb30d468b6157959060831f8d82-0166-4c36-81e5-16a9d0e037fe42d7fa41-52c6-4c13-89dd-f1625abc571d41dde786-7d93-4f2f-9260-33cb30d468b621055560303130ba93-b105-4eb0-bfee-7ead873055ea41dde786-7d93-4f2f-9260-33cb30d468b621051060305dc72943-6ad1-4550-b0b3-4dcdb092846141dde786-7d93-4f2f-9260-33cb30d468b6There was an issue reading a file, so throw a new exception to signal the problem.1657951509032ec5ccf-0430-4bac-8ec3-b27422cb59ae41dde786-7d93-4f2f-9260-33cb30d468b63007956030fb5551e4-348d-437d-a4a0-648950b51223Logic to add data to a work queue could go here. See other templates for examples of populating a queue.1525515090235a8d63-958a-4245-bc95-d5ee19fa54368342a743-6109-4f11-b50f-210734aa2af7Logic to add data to a work queue goes here. See other templates for examples of populating a queue.15300150902bb08a03-6e68-4f41-a32c-e3aec7fe8f0c8342a743-6109-4f11-b50f-210734aa2af7** One technique to prevent the file being read again is to rename it in such a way that 'Get Files' will not pick it up again.2703151801202bb08a03-6e68-4f41-a32c-e3aec7fe8f0c86f7766e-af93-4e99-ad0c-496642868bfdIn this example an environment lock is used to ensure that multiple machines do not try to read files at the same time. The lock represents 'permission' to read files, and only one machine can ever have the lock at one time. Once the reading is complete, the lock is released to enable other machines to get permission. An exception block is used to enable the lock to be released in the event of a problem.-195-10527012086f7766e-af93-4e99-ad0c-496642868bfd15-1056030739547e6-6168-46da-845c-f52c96db88c886f7766e-af93-4e99-ad0c-496642868bfd15825603086f7766e-af93-4e99-ad0c-496642868bfd2855556030cdf2a266-e12e-4ccb-971e-fe922e05f92b86f7766e-af93-4e99-ad0c-496642868bfd165750903040b436da-b8b1-41fd-b915-ea0b90e0da6d86f7766e-af93-4e99-ad0c-496642868bfd285825603086f7766e-af93-4e99-ad0c-496642868bfd285750906029db7af1-f937-4989-84bd-4e2aca50852503b107d5-83f5-4753-afa9-a5971dbc91e986f7766e-af93-4e99-ad0c-496642868bfd165825101003b107d5-83f5-4753-afa9-a5971dbc91e986f7766e-af93-4e99-ad0c-496642868bfdAn exception has occurred somewhere on this page, so check to see if the lock needs to be release before letting the exception go.28564515090afc477db-7ac1-4eb9-a99b-a6dd003a120386f7766e-af93-4e99-ad0c-496642868bfd15-459030

9c707e72-e502-4a09-af1e-ec43751210bc86f7766e-af93-4e99-ad0c-496642868bfd153090605ddc2ff2-bcee-48ef-9456-583b09718209eaed4c0a-3105-4bf1-9415-dfc32087a7e286f7766e-af93-4e99-ad0c-496642868bfd-195-1515030textRead Files86f7766e-af93-4e99-ad0c-496642868bfd-1954515030text86f7766e-af93-4e99-ad0c-496642868bfd-1951515030timespan0.00:00:3086f7766e-af93-4e99-ad0c-496642868bfdThe lock is held elsewhere, probably because another machine is reading files.1653015090ba15a370-5215-4e62-a7d8-008945c48c9086f7766e-af93-4e99-ad0c-496642868bfd31530603086f7766e-af93-4e99-ad0c-496642868bfd157509030ebfd4ea4-1440-4f37-84da-2407b5e6fedc86f7766e-af93-4e99-ad0c-496642868bfdLogic to read files goes here.154051806306ec0520c-a4cd-423e-b830-35599362a02a8e1d0d46-3a1b-4c0e-957b-a19357d7024615-105603077434acb-2774-410f-a780-5f16d839934a8e1d0d46-3a1b-4c0e-957b-a19357d7024615-309030

7a42abd1-c5a0-4024-b529-134bd08e71b28e1d0d46-3a1b-4c0e-957b-a19357d70246-19515015030flag8e1d0d46-3a1b-4c0e-957b-a19357d70246-19518015030text8e1d0d46-3a1b-4c0e-957b-a19357d70246-1959015060collection8e1d0d46-3a1b-4c0e-957b-a19357d70246-195015030textC:\Temp8e1d0d46-3a1b-4c0e-957b-a19357d70246-1953015030text*.csv8e1d0d46-3a1b-4c0e-957b-a19357d702461512021030611861b7-c7eb-4dee-8fdb-555ceee5e91abc74b64d-e257-4157-a65b-9dea3bbc69c6ForEachFiles8e1d0d46-3a1b-4c0e-957b-a19357d702461511252103017b26d82-4323-4992-b3d4-e68e3acaf5cfbc74b64d-e257-4157-a65b-9dea3bbc69c68e1d0d46-3a1b-4c0e-957b-a19357d702461545906038a901df-627f-4043-9edd-e18d14d59f8c7541e373-db1c-4602-a195-2667b5c256868e1d0d46-3a1b-4c0e-957b-a19357d702461204560308e1d0d46-3a1b-4c0e-957b-a19357d70246Logic to read the file goes here, within the exception block.1521015090db7eef87-abb3-40f6-81b2-e4599144adbc8e1d0d46-3a1b-4c0e-957b-a19357d7024621034560302f4bb52f-4768-4824-bd5d-d69781fd9b428e1d0d46-3a1b-4c0e-957b-a19357d70246-19561515030textC:\Temp\Archive8e1d0d46-3a1b-4c0e-957b-a19357d70246-19564515030textC:\Temp\Exception8e1d0d46-3a1b-4c0e-957b-a19357d70246156309060f6479c96-aa58-4d14-9035-e1ab8cb4a54caf416131-3116-4e14-9549-34607339061d8e1d0d46-3a1b-4c0e-957b-a19357d70246210630906053c731db-b8bb-4ff6-95cf-90ffd44590caaf416131-3116-4e14-9549-34607339061d8e1d0d46-3a1b-4c0e-957b-a19357d70246-751503452258e1d0d46-3a1b-4c0e-957b-a19357d702462109751010e7206234-fe71-4b72-a0b9-5076321e05448e1d0d46-3a1b-4c0e-957b-a19357d70246An exception occurred reading the file, so move it to an exception folder so it is not read again. Make a note of the exception detail and keep going.210435150906a62963f-b11e-4856-a9e6-aed79026b3778e1d0d46-3a1b-4c0e-957b-a19357d70246The file was read successfully, so move it to an archive folder so it is not read again.15435150907cb68133-6a19-421f-a20b-aa6ec5b565298e1d0d46-3a1b-4c0e-957b-a19357d70246-19551015030text8e1d0d46-3a1b-4c0e-957b-a19357d702461512159060d80447c3-cbe0-4432-b89f-2e79528821490633ba3d-c131-4196-9fea-067199319f938e1d0d46-3a1b-4c0e-957b-a19357d702462105556030a0b594f7-343e-47b9-b846-aca5f61fad4a8e1d0d46-3a1b-4c0e-957b-a19357d70246210510603063c393ae-82ab-42b0-8167-c0afa71392ff8e1d0d46-3a1b-4c0e-957b-a19357d70246There was an issue reading a file, so throw a new exception to signal the problem.1651215150903d5538c2-3542-4be0-9032-cbf7c1bc9bea8e1d0d46-3a1b-4c0e-957b-a19357d70246300121560308e1d0d46-3a1b-4c0e-957b-a19357d70246-19528515060collection8e1d0d46-3a1b-4c0e-957b-a19357d70246157951503083e1b3c0-5286-4b6d-a2e9-ae969921707c707836cb-0107-43b0-a30d-a060a10146fbForEachNew Item IDs8e1d0d46-3a1b-4c0e-957b-a19357d702461588515030e7206234-fe71-4b72-a0b9-5076321e0544707836cb-0107-43b0-a30d-a060a10146fb8e1d0d46-3a1b-4c0e-957b-a19357d70246158409030935b4f45-e974-4aa2-8885-c2d11e8d813e8e1d0d46-3a1b-4c0e-957b-a19357d70246210795150303165fe6e-63aa-4e25-8eb6-6008823db31830108271-5b5b-4cd5-b976-410f00242a19ForEachNew Item IDs8e1d0d46-3a1b-4c0e-957b-a19357d7024621088515030a13aec52-f23d-4bf1-b9cb-af6c7caa5d6d30108271-5b5b-4cd5-b976-410f00242a198e1d0d46-3a1b-4c0e-957b-a19357d70246210840903048be2009-aad6-4433-8380-1762131048eb8e1d0d46-3a1b-4c0e-957b-a19357d70246Once the file has been sucessfully moved, the new items are marked to indicate that they can be worked, in this example with the tag 'Ready'.157201509053c29cd1-0450-4e98-9121-e6882b85c6cc8e1d0d46-3a1b-4c0e-957b-a19357d70246In the event of a problem any new items are deemed invalid and can be deleted.21072015090547e7bfc-0c3e-4cf5-8b72-fc0a935f8c4f8e1d0d46-3a1b-4c0e-957b-a19357d7024615105090302bfc10d1-704d-4f0d-b420-1889d8acc28c41dde786-7d93-4f2f-9260-33cb30d468b6Logic to add data to a work queue goes here, within the exception block.153151509051242e74-bef5-48b1-aedf-46c3a7dbcf1d8e1d0d46-3a1b-4c0e-957b-a19357d70246Logic to add data to a work queue goes here, within the exception block.1531515090de0e4edc-5189-41c9-85ba-18369064ac5f8e1d0d46-3a1b-4c0e-957b-a19357d70246** NB This page assumes the output from adding new work to a queue will be the 'New Item IDs' collection.-375360180120db7eef87-abb3-40f6-81b2-e4599144adbc8e1d0d46-3a1b-4c0e-957b-a19357d70246This example assumes that only items tagged as 'Ready' will be worked and that any item not tagged will be ignored (eg the 'Tag Filter' parameter will be used on the 'Get Next Item' action).15132015090dbda8e7d-2428-4d99-b45a-00cba51993028e1d0d46-3a1b-4c0e-957b-a19357d7024615141060308e1d0d46-3a1b-4c0e-957b-a19357d70246510126015030b6ce0e5f-e89f-4fda-950c-c93e83e96b1d16d15a98-5076-409a-b026-c9f7f08271f7ForEachNew Item IDs8e1d0d46-3a1b-4c0e-957b-a19357d70246510135015030685bcb40-312b-4188-af4f-e42468c4364216d15a98-5076-409a-b026-c9f7f08271f78e1d0d46-3a1b-4c0e-957b-a19357d7024651013059030acc892f8-46a5-4808-ab5d-024570a872948e1d0d46-3a1b-4c0e-957b-a19357d7024651011106030cf8611a2-5c76-40ce-bf51-d633d8a2f4208e1d0d46-3a1b-4c0e-957b-a19357d70246An exception has occurred somewhere on this page. In the unlikely event that there are new items yet to be tagged, delete them before letting the exception go.5101185150909fe7d35e-4a33-4143-9f32-f878eda19c0a8e1d0d46-3a1b-4c0e-957b-a19357d70246510141060308e1d0d46-3a1b-4c0e-957b-a19357d70246Reset the 'New Item IDs' collection once it has been dealt with.159751509071ed5eb4-4e53-4960-9285-32cb5040307bfb5551e4-348d-437d-a4a0-648950b51223** Copy and paste the text below into Notepad to create an example CSV file-405021090fb5551e4-348d-437d-a4a0-648950b51223ACC_NO,NAME1,NAME2,STAFF,JOINED 1001,Dagless,Rick,TRUE,21/01/2001 2002,Reed,Thornton,FALSE,22/02/2002 3003,Sanchez,Lucien,FALSE,23/03/2003 4004,Asher,Liz,TRUE,24/04/2004-40510521090ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6In this example a folder is cleaned of old files. All the sub-folders are found first, then the 'created' date of all the files are checked against a date threshold value. If all the files in a sub-folder are deleted the subfolder is deleted too. This sort of logic could be used to keep a archive folder from growing too big.-195-105240150ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff615-1056030e9aa118c-5b27-4950-8d99-4b9a5739dc03ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6-19542015030flagee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6-19545015030textee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff682512015060collectionee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6-1956015030text*.*ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff68251515030datetimeee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6-1953015030timespan180.00:00:00ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6Used as a date baseline.825-1515030datetime1900-01-01 00:00:00Zee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff65704209060202f1cb9-54b7-4e83-8ea1-57075e0cc6f86a7f65ee-a18c-4f0a-b9e8-3d34190b8aa8ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6-19537515060collectionee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6153609030

8a328e1a-a087-4236-80b7-a8e91a39d73fee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6-195015030textC:\Tempee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6-19512015060collectionee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff615495120300622bbb2-73ef-43a2-9197-0b1469808b508ac719b2-75b6-4e9a-a1b5-882deac43213ForEachTemp Foldersee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6156601203084bd287f-4fd0-4eed-a07c-dfa751b7e3aa8ac719b2-75b6-4e9a-a1b5-882deac43213ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff61554090301d99b773-fa19-4991-9d6d-37b62fb84c64ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff61521015030e0363b1f-007f-4432-89fe-c075f87d7878bc58b403-4e2a-4ede-8fce-60ff67da6edeForEachFolder Pathsee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff61572015030897cb8d6-5723-4f5d-a297-a88da80b084cbc58b403-4e2a-4ede-8fce-60ff67da6edeee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff615759030a3729e6d-3445-4d94-a3cd-45761a30f51dee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6151359060716e6184-efb7-45b3-b672-801969fc8997ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff61560090606ad56d40-28da-4895-8298-ac400c23a5deee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6152859060a898014f-45fa-43d0-bd9d-5394486727a962d1d65c-995e-41c1-841e-f9df75a3fedeee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6-19564515030number1ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6-902851010229a7597-98b3-4d5b-8326-0327e1a8c53eee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6-90720101084bd287f-4fd0-4eed-a07c-dfa751b7e3aaee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff61952101010716e6184-efb7-45b3-b672-801969fc8997ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6-19552515060collectionee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff619558590304e88ed69-1bb5-44f5-868a-eae9efdc19bcee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6-19561515030flagFalseee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff61955259060fef5cb45-6a19-4c64-a1a1-843259737613ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6195720906081191eaf-b55f-478d-99c2-68ee1a27006f2d151946-3bce-4013-8617-8d74a6a1c865ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff657045120309b53e9e6-7aa1-435e-997e-8d9032c8dc4eba2ad8d7-616e-4ff5-8aa7-f644393897d1ForEachFolder Pathsee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff657094512030a01cffb1-36a5-436c-8a1e-4cc0fda5b0f7ba2ad8d7-616e-4ff5-8aa7-f644393897d1ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff65701059030

c6cb00d6-2564-4c28-ab3a-29d16088c8d9ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6570-159060a4b0df7a-6004-41d8-bd9e-b7fa22d90f68ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff65701809060c49c7b7a-44d6-4ccb-9e89-da68ab0aa0476ae95977-07a2-4e6e-b038-e725a841bdcfee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff66751806030ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff615420906085f864ff-1a40-4470-84ef-b9a835963bd6d05c0e8e-eaa0-4921-a942-621ae5c716e1ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff61204206030ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff657057090605e197063-7a68-4bed-863f-37e39358b38a52fbe5ef-d658-4f87-9f2e-ac0e915af66dee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff66755706030ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff645064510105e197063-7a68-4bed-863f-37e39358b38aee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff657010056030ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff65703459030c5797170-ee17-46db-977b-8929008f7bf7399f50f9-d5a2-4095-bba4-ac1a6d778122ForEachFilesee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff657064590304c5ac6c9-262b-4a1c-8052-478867a78290399f50f9-d5a2-4095-bba4-ac1a6d778122ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff645042090605583c5f2-9317-4e3e-a778-dce48214cb45ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff682542015030flagTrueee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff65707209060a1d754f5-f31d-4a55-916f-7a231954ffd423fe0b02-1d89-45c3-a76d-40232add9863ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6690270906055effe7e-82ff-481c-b03b-840a9a089e4aee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff657027090603ca5c226-d10d-4fc1-bb4d-a57fa5f86ec975a01270-034d-4c67-92d5-d60af942e2caee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6450270906055effe7e-82ff-481c-b03b-840a9a089e4aee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff645072010105c7a51b1-a696-45ee-ab10-807ab9a8f8e1ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff64509451010dcbbae05-ee29-41bd-8b8c-2c1a435624c6ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff65708709060dcbbae05-ee29-41bd-8b8c-2c1a435624c6ab559ce6-0b74-403b-9c27-9dda124f32daee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff66758706030ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff65707959030

664a56de-d10d-4db8-9b90-72e8ef9a4474ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff65704959030

8ee236d2-fd2d-47da-910c-ff92e7a382fbee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff61956309030

80c5d354-1aa9-4ebe-a657-78c54d82e84eee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff63157209030

bc1115fc-f909-4f99-8175-f26b0266ef16ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6Find the paths of all the sub folders15-151509076a7a1f0-1fa7-41a9-929b-3dc089ed47adee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6Work up from the lowest sub folder looking for old files.315-1515090f27cd0d0-07b2-4dee-95e9-69f23bb78669ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6** NB This collection of paths is reversed so that the lowest level sub-folders are looked at first.2408701801202d151946-3bce-4013-8617-8d74a6a1c865ee910a61-0a3a-40c0-b9a7-7c9c7b9f9ff6** NB Sub-folders are only deleted if they are empty7806901801204c5ac6c9-262b-4a1c-8052-478867a78290b68ddea0-fff8-4c67-bc1b-243d448f9faa-195-10515090b68ddea0-fff8-4c67-bc1b-243d448f9faa15-105603020190540-cb52-44cf-aa3c-7eba50d8c705b68ddea0-fff8-4c67-bc1b-243d448f9faa159756030b68ddea0-fff8-4c67-bc1b-243d448f9faa15-459030

49c6cf8d-db28-49e8-8060-80377bb6d6f2b68ddea0-fff8-4c67-bc1b-243d448f9faa-195-1515030textC:\Temp\My File.xmlb68ddea0-fff8-4c67-bc1b-243d448f9faa-1953015030textb68ddea0-fff8-4c67-bc1b-243d448f9faa15759030

465c18b2-5c3a-4d09-a5d7-eb68e9fa3c8cb68ddea0-fff8-4c67-bc1b-243d448f9faa-1959015060collectionb68ddea0-fff8-4c67-bc1b-243d448f9faa15360180306d33e70d-9c10-45fc-9159-af6115d8013293ba754f-f84c-49c3-83aa-df42faa5d1acForEachContactsb68ddea0-fff8-4c67-bc1b-243d448f9faa1591518030806576d2-3c28-4fb8-9036-4bb1cd7f6e7493ba754f-f84c-49c3-83aa-df42faa5d1acb68ddea0-fff8-4c67-bc1b-243d448f9faa153159030

9dd16be7-d656-46e4-ad9d-5026c514bab8b68ddea0-fff8-4c67-bc1b-243d448f9faa-19533015060collectionb68ddea0-fff8-4c67-bc1b-243d448f9faa-19551015060collectionb68ddea0-fff8-4c67-bc1b-243d448f9faa1540560304e9dd78d-96ab-4afb-9bb6-7a5dd37c6899b68ddea0-fff8-4c67-bc1b-243d448f9faa-19540515030number0b68ddea0-fff8-4c67-bc1b-243d448f9faa151659030

2f2fedff-5a93-4fff-bdef-f72cf1f596e0b68ddea0-fff8-4c67-bc1b-243d448f9faa-19518015060collectionb68ddea0-fff8-4c67-bc1b-243d448f9faa1512018030b4ba99c8-2df2-4e90-8ebf-db7c005d9a51e5a04fa6-733e-4d6b-98a4-9bc203332120ForEachClinicianb68ddea0-fff8-4c67-bc1b-243d448f9faa1521018030532363d7-9cb7-49cb-b654-8babcd7dda98e5a04fa6-733e-4d6b-98a4-9bc203332120b68ddea0-fff8-4c67-bc1b-243d448f9faa155401203071e58d45-dd28-4e55-acfd-cffed03edc6cd101d510-f12d-43ec-975b-8b517617ea2dForEachContactb68ddea0-fff8-4c67-bc1b-243d448f9faa15630120303fafc65b-20a3-4527-b9cd-b29d5112f5e7d101d510-f12d-43ec-975b-8b517617ea2db68ddea0-fff8-4c67-bc1b-243d448f9faa155859030

c2a4cf57-b97e-4072-b846-00a4fec8a3b8b68ddea0-fff8-4c67-bc1b-243d448f9faa-19560015060collectionb68ddea0-fff8-4c67-bc1b-243d448f9faa156909030

7d28add6-d348-4264-9bcf-b87dfe551d0fb68ddea0-fff8-4c67-bc1b-243d448f9faa-19575015060collectionb68ddea0-fff8-4c67-bc1b-243d448f9faa154509030594230d7-113c-4621-a944-5cdeec261100b68ddea0-fff8-4c67-bc1b-243d448f9faa1530903060322ceb-b4bf-44ce-86e8-93554d6c094bb68ddea0-fff8-4c67-bc1b-243d448f9faa154959030

6b32c2c8-e47b-453b-8d96-971b034d42b2b68ddea0-fff8-4c67-bc1b-243d448f9faa157359030

046dc213-7c52-432b-bef7-c0571f998c38b68ddea0-fff8-4c67-bc1b-243d448f9faaLogic to add data to a work queue could go here. See other templates for examples of populating a queue.158251509033a67993-41f6-4e2a-8612-3adabe9ade4fb68ddea0-fff8-4c67-bc1b-243d448f9faa** Copy and paste the text below into Notepad to create an example XML file-4051521090b68ddea0-fff8-4c67-bc1b-243d448f9faa<?xml version="1.0" encoding="UTF-8" ?> <NHS> <HomeVisit> <Clinician> <ClinicianID>ABC123</ClinicianID> <ClinicianFirstName>GLADYS</ClinicianFirstName> <ClinicianSurname>EMMANUEL</ClinicianSurname> <Speciality>DISTRICT NURSING</Speciality> <VisitDate>02012013</VisitDate> </Clinician> <Contacts> <Contact> <PatientID>100000001</PatientID> <PatientFirstName>ROGER</PatientFirstName> <PatientSurname>MELLIE</PatientSurname> <DateOfBirth>17021973</DateOfBirth> <StartTime>1035</StartTime> <EndTime>1105</EndTime> <Purpose>Assessment</Purpose> <Outcome>Referred to GP</Outcome> </Contact> <Contact> <PatientID>200000002</PatientID> <PatientFirstName>PAUL</PatientFirstName> <PatientSurname>WHICKER</PatientSurname> <DateOfBirth>19121952</DateOfBirth> <StartTime>1140</StartTime> <EndTime>1200</EndTime> <Purpose>Treatment</Purpose> <Outcome>Discharged</Outcome> </Contact> <Contact> <PatientID>300000003</PatientID> <PatientFirstName>FINBAR</PatientFirstName> <PatientSurname>SAUNDERS</PatientSurname> <DateOfBirth>10071984</DateOfBirth> <StartTime>1300</StartTime> <EndTime>1340</EndTime> <Purpose>Medication</Purpose> <Outcome>Future Appointment</Outcome> </Contact> </Contacts> </HomeVisit> </NHS>-40512021090b68ddea0-fff8-4c67-bc1b-243d448f9faa** Columns are added to the 'New Item Clinician' collection to hold data from the xml elements240150180120b4ba99c8-2df2-4e90-8ebf-db7c005d9a51b68ddea0-fff8-4c67-bc1b-243d448f9faa** Columns are added to the 'New Item Contact' collection to hold data from the xml elements24057018012071e58d45-dd28-4e55-acfd-cffed03edc6cb68ddea0-fff8-4c67-bc1b-243d448f9faa** A 'New Item Data' collection is formed by merging the 'New Item Clinician' and 'New Item Contact' collections.2407051801203fafc65b-20a3-4527-b9cd-b29d5112f5e7b68ddea0-fff8-4c67-bc1b-243d448f9faa** An additional 'Item Key' field is created to be able to help identify the item in the queue.2408251801207d28add6-d348-4264-9bcf-b87dfe551d0f151656030This process has not been designed to run, it is merely a collection diagram fragments based on a common theme. Each page is an example intended to illustrate how a particular task might be acheived in Blue Prism. These examples may be copied into a new diagram and modified to suit your needs.15302701509b09bf76-73bd-444c-8cdc-5e367ddfd6dc 001.25Get Next Item (simple)0421.25Get Next Item (using a key filter)7001.25Get Next Item (using a tag filter)8841.25Get Next Item (using successive tag filters)146701.25Get Next Item (using different collections)01761.25Check For Pending Items51841.115-1056030e813c6d9-0875-4d22-872c-d8be7d13e3f0-195-1051509088c08118-0cec-44ef-97b6-064ce8bc4464This example simply asks the queue for the next available item. If the Item ID is returned as blank text it means no item is available.-195-1051509088c08118-0cec-44ef-97b6-064ce8bc446415-105603007f43c9d-23ee-4ba1-9f33-7fde97a9a0c488c08118-0cec-44ef-97b6-064ce8bc446415-459030

4d22f0ee-7d62-43b2-945a-6f1ee365780a88c08118-0cec-44ef-97b6-064ce8bc4464-1951515030text88c08118-0cec-44ef-97b6-064ce8bc4464-19512015060collection88c08118-0cec-44ef-97b6-064ce8bc4464-1954515030text88c08118-0cec-44ef-97b6-064ce8bc4464-1957515030number88c08118-0cec-44ef-97b6-064ce8bc4464153090609bbd7389-974d-47a8-92e7-10d689afa092d4f7ed44-ab95-4dfc-913e-31ef7546c64588c08118-0cec-44ef-97b6-064ce8bc4464An item is available, so proceed to work it as normal.1513512090752e9de7-b0ad-4b38-a43a-b61c713025c488c08118-0cec-44ef-97b6-064ce8bc4464No item is available1503012090d0cd7559-9511-4210-81b1-1ccec6385bbd88c08118-0cec-44ef-97b6-064ce8bc4464270306030122b08f5-ac44-44d1-b211-97f88d40366fThis example asks the queue for the next available item that has a specific tag. If the Item ID is returned as blank text it means no item is available.-195-10515090a65d4b41-ee1c-4eb4-bebb-bd80e94478caThis example asks the queue for the next available item that has a specific key value. If the Item ID is returned as blank text it means no item is available.-195-10515090a65d4b41-ee1c-4eb4-bebb-bd80e94478ca15-1056030a287a2a5-4ed9-4750-b13b-ff68dca4c832e123b65a-32b2-40d5-a03b-84eb02922a93This example uses successive tag filters to work items in a controlled order - Gas items first, Electric items second and Dual Fuel items last.-195-10518090a65d4b41-ee1c-4eb4-bebb-bd80e94478ca15-459030

135e3e3b-4315-4427-8791-ff8abd998f2ca65d4b41-ee1c-4eb4-bebb-bd80e94478ca-1956015030texta65d4b41-ee1c-4eb4-bebb-bd80e94478ca-19516515060collectiona65d4b41-ee1c-4eb4-bebb-bd80e94478ca-1959015030texta65d4b41-ee1c-4eb4-bebb-bd80e94478ca-19512015030numbera65d4b41-ee1c-4eb4-bebb-bd80e94478ca15309060fb71739a-c29f-4c4f-9933-aa5f7ef4851e6f9d5537-208b-45b3-ac7a-451fc8db17c1a65d4b41-ee1c-4eb4-bebb-bd80e94478caAn item is available, so proceed to work it as normal.1513512090fef7d0c1-763b-4cb5-a5a8-6a9ca102867fa65d4b41-ee1c-4eb4-bebb-bd80e94478caNo item with this key is available.150301209003e77eef-1ee7-4d58-97ef-7f938044e197a65d4b41-ee1c-4eb4-bebb-bd80e94478ca270306030a65d4b41-ee1c-4eb4-bebb-bd80e94478ca-1951515030textABC-123122b08f5-ac44-44d1-b211-97f88d40366f15-1056030dbbc37d7-27f5-44a6-8da4-ffd2d0a5b64a122b08f5-ac44-44d1-b211-97f88d40366f15-459030

55c8b211-70a2-4b9a-b7bf-4a46aaff3bb5122b08f5-ac44-44d1-b211-97f88d40366f-1956015030text122b08f5-ac44-44d1-b211-97f88d40366f-19516515060collection122b08f5-ac44-44d1-b211-97f88d40366f-1959015030text122b08f5-ac44-44d1-b211-97f88d40366f-19512015030number122b08f5-ac44-44d1-b211-97f88d40366f153090605a1edb8d-38ba-4b9d-bc47-efd58788e8e64458fa7f-8011-451d-8779-dd5485556d12122b08f5-ac44-44d1-b211-97f88d40366fAn item is available, so proceed to work it as normal.1513512090ba31be13-6c89-4f3b-94a9-56d50c44a595122b08f5-ac44-44d1-b211-97f88d40366fNo item with this tag is available.15030120909738d3d9-53e9-46cc-81ef-fbd128995332122b08f5-ac44-44d1-b211-97f88d40366f270306030122b08f5-ac44-44d1-b211-97f88d40366f-1951515030textPAYG88c08118-0cec-44ef-97b6-064ce8bc4464152259030979a70d6-4d9d-4754-b8b1-de253d673bc988c08118-0cec-44ef-97b6-064ce8bc4464-7522510103fbbc482-7e2d-489e-98f0-a10c200d615588c08118-0cec-44ef-97b6-064ce8bc4464-75-45101007f43c9d-23ee-4ba1-9f33-7fde97a9a0c4a65d4b41-ee1c-4eb4-bebb-bd80e94478ca1522590304eedffeb-4d91-4217-971f-4aad3442a6f0a65d4b41-ee1c-4eb4-bebb-bd80e94478ca-75225101028c30ed1-c6f1-4279-8944-4eb3cd2b5533a65d4b41-ee1c-4eb4-bebb-bd80e94478ca-75-451010a287a2a5-4ed9-4750-b13b-ff68dca4c832122b08f5-ac44-44d1-b211-97f88d40366f15225903007db0a3b-9304-41f0-9e18-2aafd85af52c122b08f5-ac44-44d1-b211-97f88d40366f-752251010c1d1cb9f-342e-484a-81db-d4af32e0764a122b08f5-ac44-44d1-b211-97f88d40366f-75-451010dbbc37d7-27f5-44a6-8da4-ffd2d0a5b64ae123b65a-32b2-40d5-a03b-84eb02922a9315-105603096a0bd7a-4979-40e6-856e-ed156bd525f1e123b65a-32b2-40d5-a03b-84eb02922a9315-309030

7c0edf74-85ca-4f48-bfdd-7422ce9e3631e123b65a-32b2-40d5-a03b-84eb02922a93-1951515030texte123b65a-32b2-40d5-a03b-84eb02922a93-19513515060collectione123b65a-32b2-40d5-a03b-84eb02922a93-1954515030texte123b65a-32b2-40d5-a03b-84eb02922a93-1957515030numbere123b65a-32b2-40d5-a03b-84eb02922a9315459060c7b7eb2e-7c70-46e3-83a4-a1f02e25b6723070cff1-6607-4d61-87fb-4035c79dd236e123b65a-32b2-40d5-a03b-84eb02922a93A gas item is available, so proceed to work it as normal.151501209001ee25eb-b05b-4d19-9d6b-f5af1ebed42be123b65a-32b2-40d5-a03b-84eb02922a931524090305f04868e-fb2d-48a5-b5b1-e21062ee262ce123b65a-32b2-40d5-a03b-84eb02922a93-752401010e1189bbc-6462-4003-8e8f-1ae9bf167e02e123b65a-32b2-40d5-a03b-84eb02922a93-75-30101096a0bd7a-4979-40e6-856e-ed156bd525f1e123b65a-32b2-40d5-a03b-84eb02922a93No item with any of the tags is available.60045120904d4188e3-0829-4bc9-bfc8-84c201d7bff7e123b65a-32b2-40d5-a03b-84eb02922a93720456030e123b65a-32b2-40d5-a03b-84eb02922a93240-309030

7cd507d3-3b97-40c2-8109-ae168e83c6ace123b65a-32b2-40d5-a03b-84eb02922a93240459060353669cc-c4d2-4d30-a3f3-e4a2900bed226f691b2b-c957-478c-9819-401376c32f41e123b65a-32b2-40d5-a03b-84eb02922a93An electric item is available, so proceed to work it as normal.240150120902842f13f-4b76-41da-871f-e4402406716ee123b65a-32b2-40d5-a03b-84eb02922a932402409030e6c62945-19c0-4db3-b35e-8ea35b5b7d93e123b65a-32b2-40d5-a03b-84eb02922a9315024010103070cff1-6607-4d61-87fb-4035c79dd236e123b65a-32b2-40d5-a03b-84eb02922a93150-3010105a78e963-5c3a-4778-9c40-c10097499e96e123b65a-32b2-40d5-a03b-84eb02922a931504510102f1b7396-34a0-4f3d-88ef-5552879e13eae123b65a-32b2-40d5-a03b-84eb02922a93465-309030

a7066676-fb02-4863-a5ec-8f2029bfc698e123b65a-32b2-40d5-a03b-84eb02922a934654590609bbdd952-bf3d-4025-85ea-9d79afa3e70f40ef30d7-dbbf-4ebc-a653-2e87631cfa36e123b65a-32b2-40d5-a03b-84eb02922a93A dual fuel item is available, so proceed to work it as normal.46515012090cc92e9a8-f13b-4f43-90d4-123535e3a25be123b65a-32b2-40d5-a03b-84eb02922a93465240903076c63f9e-b014-458c-b9ad-8ad88fc0f775e123b65a-32b2-40d5-a03b-84eb02922a9337524010106f691b2b-c957-478c-9819-401376c32f41e123b65a-32b2-40d5-a03b-84eb02922a93375-3010100f7512ce-14b6-4bf9-93c5-87e282e1d21de123b65a-32b2-40d5-a03b-84eb02922a9337545101082bd2b1e-a052-4e09-93c2-125f219ac6cbe123b65a-32b2-40d5-a03b-84eb02922a93** In this example each type of item uses its own data collection150-1201509096a0bd7a-4979-40e6-856e-ed156bd525f1e123b65a-32b2-40d5-a03b-84eb02922a93-19519515060collectione123b65a-32b2-40d5-a03b-84eb02922a93-19525515060collection49c30113-d924-4dcd-a75f-6c9ed51809aeThis example asks for the next available item, but uses a dynamic collection because the queue contains items with different data collection structures. In this example all collections have a common field called 'Fuel Type', and this is used to apply the values in the dynamic collection to the appropriate structured collection.-195-10521012049c30113-d924-4dcd-a75f-6c9ed51809ae15-10560301fdee236-2c76-47f7-a43a-8e95d070f1b249c30113-d924-4dcd-a75f-6c9ed51809ae15-459030

7516a80e-4e14-4486-87d5-d8c77fcf777b49c30113-d924-4dcd-a75f-6c9ed51809ae-19512015030text49c30113-d924-4dcd-a75f-6c9ed51809ae-1954515060collection49c30113-d924-4dcd-a75f-6c9ed51809ae-19515015030text49c30113-d924-4dcd-a75f-6c9ed51809ae-19518015030number49c30113-d924-4dcd-a75f-6c9ed51809ae15309060cf1a4bfe-331c-4037-992e-6b0b6e666a8b27569728-d266-4fda-a9db-b37ef9c9c9b949c30113-d924-4dcd-a75f-6c9ed51809aeNo item is available15030120904dd4fc3a-0cf1-436b-b4d2-3a3b9b23655a49c30113-d924-4dcd-a75f-6c9ed51809ae27030603049c30113-d924-4dcd-a75f-6c9ed51809ae1542090304131d2be-719b-45d1-8edb-02009c6e202449c30113-d924-4dcd-a75f-6c9ed51809ae-604201010e70ff955-f2b4-4755-a0b4-5540b31bc1ad49c30113-d924-4dcd-a75f-6c9ed51809ae-60-4510101fdee236-2c76-47f7-a43a-8e95d070f1b249c30113-d924-4dcd-a75f-6c9ed51809ae151359060fe854d55-8891-4bc5-854b-9fb41eca23a95757cd88-858f-4959-a210-3301a292b1f049c30113-d924-4dcd-a75f-6c9ed51809ae-19525515060collection49c30113-d924-4dcd-a75f-6c9ed51809ae-19531515060collection49c30113-d924-4dcd-a75f-6c9ed51809aeA gas item is available, so proceed to work it as normal.153301209028d55df4-93eb-481c-8d9d-f584845452c449c30113-d924-4dcd-a75f-6c9ed51809aeAn electric item is available, so proceed to work it as normal.180330120905217cce3-4d4c-41c2-bf18-ff6f4b8a5e0549c30113-d924-4dcd-a75f-6c9ed51809ae1522590604ad35eb4-0f55-482f-8290-9d0e8b41558e49c30113-d924-4dcd-a75f-6c9ed51809ae18022590605842d8dc-0087-4cb4-9de7-217e24e3454549c30113-d924-4dcd-a75f-6c9ed51809ae180420101028d55df4-93eb-481c-8d9d-f584845452c449c30113-d924-4dcd-a75f-6c9ed51809aeMust be Dual Fuel3451359060f1f51205-ee2e-4f1f-b87f-a1cfc80cd34949c30113-d924-4dcd-a75f-6c9ed51809ae1801359060e1f19b32-8010-4f99-b56c-e9eafb626aabd47b80e5-a2e3-45e4-b108-7ed94bbcbefb49c30113-d924-4dcd-a75f-6c9ed51809aeA dual fuel item is available, so proceed to work it as normal.34533012090fff1cc86-ef4b-4dd8-b6c4-047172ef8c3b49c30113-d924-4dcd-a75f-6c9ed51809ae345225906087e098da-c754-4ffb-9753-d78e77666aee49c30113-d924-4dcd-a75f-6c9ed51809ae34542010105217cce3-4d4c-41c2-bf18-ff6f4b8a5e0549c30113-d924-4dcd-a75f-6c9ed51809ae-19537515060collection88c08118-0cec-44ef-97b6-064ce8bc4464-195-3015030textMy Queuea65d4b41-ee1c-4eb4-bebb-bd80e94478ca-195-3015030textMy Queue122b08f5-ac44-44d1-b211-97f88d40366f-195-3015030textMy Queuee123b65a-32b2-40d5-a03b-84eb02922a93-195-3015030textMy Queue49c30113-d924-4dcd-a75f-6c9ed51809ae-195-1515030textMy Queue79dd79c8-0870-4e5f-818d-86a6d4f1b423This example gets the IDs of pending items and uses a loop to test if the collection is empty or not.-195-1051509079dd79c8-0870-4e5f-818d-86a6d4f1b42315-1056030d67caacc-25ce-4edb-990d-9e229d0c933f79dd79c8-0870-4e5f-818d-86a6d4f1b423If we reach this point the collection has at least 1 row and pending items were found1656012090b605b57c-4178-4aee-813a-802ce68aa0c579dd79c8-0870-4e5f-818d-86a6d4f1b42315270603079dd79c8-0870-4e5f-818d-86a6d4f1b423-195-3015030textMy Queue79dd79c8-0870-4e5f-818d-86a6d4f1b42315-459030

77d48d85-2c23-4fd3-bf64-607e9ef8102679dd79c8-0870-4e5f-818d-86a6d4f1b423-1954515060collection79dd79c8-0870-4e5f-818d-86a6d4f1b423151512030e519a36f-9372-4b90-9e35-7679aca5be39c967fd89-e72f-4f5f-ad3a-7100ae176866ForEachPending Items79dd79c8-0870-4e5f-818d-86a6d4f1b42315105120308ea8e25c-98d9-478c-9f92-4789eb426d80c967fd89-e72f-4f5f-ad3a-7100ae17686679dd79c8-0870-4e5f-818d-86a6d4f1b423If we reach this point the collection must be empty and no pending items were found151801209095a11795-9fb8-4539-b439-844e5ccdf72879dd79c8-0870-4e5f-818d-86a6d4f1b423156010107c7f1db3-1a7f-4a40-b40f-d6730bf8ba9979dd79c8-0870-4e5f-818d-86a6d4f1b423285606030151656030This process has not been designed to run, it is merely a collection diagram fragments based on a common theme. Each page is an example intended to illustrate how a particular task might be acheived in Blue Prism. These examples may be copied into a new diagram and modified to suit your needs.1530270150ce1b6612-cb1f-47ca-a139-718b26ffeeee 001.25Maintain Queue (delete old items)51481.1Maintain Queue (delete pending items)512631.25Maintain Queue (check for locked items)50.83356900.8Maintain Queue (synchronise two queues)513990.8Maintain Queue (synchronise many queues)2013490.915-10560303fc46209-031d-45a7-b716-5c8b530d0d09-195-1051509088485c9f-8ea2-4d08-99e6-3168fb8e7f18In this example the queue is automatically cleaned of old items by calculating a 'data threshold' and then deleting any items older than that date. Note that an environment lock is used to ensure only one machine does this work at any one time.-195-10521012088485c9f-8ea2-4d08-99e6-3168fb8e7f1815-10560307cf88dc8-c4cb-414d-9e56-3aeae5b15b5b88485c9f-8ea2-4d08-99e6-3168fb8e7f1815690603088485c9f-8ea2-4d08-99e6-3168fb8e7f18152409030

a2856a7a-a70c-407d-b944-65603cddbeee88485c9f-8ea2-4d08-99e6-3168fb8e7f18-19530015060collection88485c9f-8ea2-4d08-99e6-3168fb8e7f18152859030abc4b097-8ab4-4b29-8651-ab4bac31b6acad08e768-bc94-4810-ab2d-9e35405132afForEachItem IDs88485c9f-8ea2-4d08-99e6-3168fb8e7f1815375903041bc86ff-e1bc-4137-bc5c-c79ae8c9e532ad08e768-bc94-4810-ab2d-9e35405132af88485c9f-8ea2-4d08-99e6-3168fb8e7f181533060301c6d4f17-da64-466c-ab39-875bbacc983788485c9f-8ea2-4d08-99e6-3168fb8e7f18154359030

81298af2-6a3d-485f-b021-839ba1597dd788485c9f-8ea2-4d08-99e6-3168fb8e7f18154809030a95ebc30-874a-4f72-b05c-2872cc817ed5ff2717d2-d826-4fb1-b95d-35de064ac694ForEachItem IDs88485c9f-8ea2-4d08-99e6-3168fb8e7f181557090303616a82a-ae7a-4acb-8900-268995fc8b85ff2717d2-d826-4fb1-b95d-35de064ac69488485c9f-8ea2-4d08-99e6-3168fb8e7f18155256030755a4d9d-261b-470e-be87-5368dc9cdf7b88485c9f-8ea2-4d08-99e6-3168fb8e7f181590906086e15b0e-baee-4f16-bab0-55472b55c1dd08fdebbf-fb78-46e7-b9b7-23720b3b0cd388485c9f-8ea2-4d08-99e6-3168fb8e7f18-1953015030text88485c9f-8ea2-4d08-99e6-3168fb8e7f18-1959015030text88485c9f-8ea2-4d08-99e6-3168fb8e7f1827090603088485c9f-8ea2-4d08-99e6-3168fb8e7f1815-456030c53cbb84-f6f1-4e17-bfcc-2892726eb41f88485c9f-8ea2-4d08-99e6-3168fb8e7f18-6019525540588485c9f-8ea2-4d08-99e6-3168fb8e7f1813557060302bec9a04-ddae-40bc-a82a-54693654c94b88485c9f-8ea2-4d08-99e6-3168fb8e7f181356309030978cb292-4de8-4e77-8701-e321bed14a4f88485c9f-8ea2-4d08-99e6-3168fb8e7f18135690603088485c9f-8ea2-4d08-99e6-3168fb8e7f18156309030a740a960-f44f-437c-866a-3f2f747909fa88485c9f-8ea2-4d08-99e6-3168fb8e7f181516560304c67eb28-7f7e-499d-8300-363083c7c80888485c9f-8ea2-4d08-99e6-3168fb8e7f18-19521015030datetime88485c9f-8ea2-4d08-99e6-3168fb8e7f18Used to determine the threshold date for deleting old queue items.-19518015030timespan180.00:00:0088485c9f-8ea2-4d08-99e6-3168fb8e7f18-195-1515030textMy Queue88485c9f-8ea2-4d08-99e6-3168fb8e7f18The lock is held elsewhere, probably because this work is currently being done on another machine.150901209059c45adf-5ae6-4f5b-a1d3-98cab2217b5388485c9f-8ea2-4d08-99e6-3168fb8e7f1815159030

6b220437-5335-48a1-82a7-f04c2db42ad688485c9f-8ea2-4d08-99e6-3168fb8e7f18-1956015030timespan0.00:00:0088485c9f-8ea2-4d08-99e6-3168fb8e7f18Used as a date baseline.-19515015030datetime1900-01-01 00:00:00Z88485c9f-8ea2-4d08-99e6-3168fb8e7f18** NB In the event of an exception the lock must be released.3157351801202bec9a04-ddae-40bc-a82a-54693654c94b88485c9f-8ea2-4d08-99e6-3168fb8e7f18** NB After maintaining the queue, the lock is released.-1807351801203616a82a-ae7a-4acb-8900-268995fc8b8588485c9f-8ea2-4d08-99e6-3168fb8e7f18** NB A date threshold is calculated to use as a 'cut off' point. Any queue items older than this date are deemed redundant and are deleted.33018018012086e15b0e-baee-4f16-bab0-55472b55c1dd88485c9f-8ea2-4d08-99e6-3168fb8e7f18** NB A collection of IDs of items completed between 'year zero' and 'date threshold' is retrieved here.3153301801204c67eb28-7f7e-499d-8300-363083c7c80888485c9f-8ea2-4d08-99e6-3168fb8e7f18** NB Each old item is deleted individually315465180120abc4b097-8ab4-4b29-8651-ab4bac31b6acaf0b997f-1398-44db-a72e-de2aba33eea8In this example the queue is cleaned of pending items - in some situations it is desirable to remove all unworked items prior to loading new work. Note that an environment lock is used to ensure only one machine does this at any one time, and a substantial time out is used to keep any other machines waiting while the queue is being maintained.-195-105270120af0b997f-1398-44db-a72e-de2aba33eea815-1056030d3606e3f-6f39-48a5-b41b-ce97d06617ceaf0b997f-1398-44db-a72e-de2aba33eea8154506030af0b997f-1398-44db-a72e-de2aba33eea8151959030

9ac84aef-fec0-44a1-98da-0e6bb62b96f4af0b997f-1398-44db-a72e-de2aba33eea8-19521015060collectionaf0b997f-1398-44db-a72e-de2aba33eea8152409030e924391e-616c-4d68-8805-59c8a42d56630060df43-33be-4d0f-b530-8b307a5c0e68ForEachItem IDsaf0b997f-1398-44db-a72e-de2aba33eea81533090300b04867f-8666-4c59-bca6-e444ee9824570060df43-33be-4d0f-b530-8b307a5c0e68af0b997f-1398-44db-a72e-de2aba33eea815285603084ef8aac-326c-4147-80de-93c1e18e3022af0b997f-1398-44db-a72e-de2aba33eea8159090603fed1299-6a0a-4a48-a7b2-53642ac0ab462534483b-87de-46a9-97c7-1445d33b1311af0b997f-1398-44db-a72e-de2aba33eea8-1953015030textaf0b997f-1398-44db-a72e-de2aba33eea8-1959015030textaf0b997f-1398-44db-a72e-de2aba33eea815-4560309db5822c-cf2d-4410-9655-75ecc7f04e6aaf0b997f-1398-44db-a72e-de2aba33eea8-60150240210af0b997f-1398-44db-a72e-de2aba33eea8135330603002b0716b-bcd8-4890-9c3c-74e96b2e2348af0b997f-1398-44db-a72e-de2aba33eea81353909030e642908e-de6e-44ca-bf5b-0ed92039d107af0b997f-1398-44db-a72e-de2aba33eea81354506030af0b997f-1398-44db-a72e-de2aba33eea815390903005875f66-f4fb-46f3-8937-899b8de53e19af0b997f-1398-44db-a72e-de2aba33eea8-195-1515030textMy Queueaf0b997f-1398-44db-a72e-de2aba33eea8The lock is held elsewhere, probably because this work is currently being done on another machine.15090120900cec21e8-daa4-42e1-a790-9c3fd602c537af0b997f-1398-44db-a72e-de2aba33eea815159030

8a192b2d-1039-4bc6-929b-b7ced71847c0af0b997f-1398-44db-a72e-de2aba33eea8-1956015030timespan0.00:05:00af0b997f-1398-44db-a72e-de2aba33eea8** NB In the event of an exception the lock must be released.33043518012002b0716b-bcd8-4890-9c3c-74e96b2e2348af0b997f-1398-44db-a72e-de2aba33eea8** NB After maintaining the queue, the lock is released.-1804351801200b04867f-8666-4c59-bca6-e444ee982457af0b997f-1398-44db-a72e-de2aba33eea8** NB Each old item is deleted individually330240180120e924391e-616c-4d68-8805-59c8a42d5663af0b997f-1398-44db-a72e-de2aba33eea8270906030af0b997f-1398-44db-a72e-de2aba33eea8** Here it might be prudent to throw an exception rather than continuing as normal. There could be a risk of this machine causing disruption if it goes on to consume new items while another machine is still attempting to maintain the queue.435301801200cec21e8-daa4-42e1-a790-9c3fd602c53773088449-bfbc-4b95-ab5d-e769c2839b59In this example a check is made for items that have been (wrongly) left locked. Items that are still locked after a certain period of time are deemd to be exceptions.-195-1051509073088449-bfbc-4b95-ab5d-e769c2839b5915-1056030eef5ad67-20ff-4bfc-a4c1-3aa8e08c7309f341d164-7e83-4dfd-a6d5-8a418082351dIn this example completed items in one queue require that a corresponding item is created in another queue. This arrangement could be used to manage 'Day 1' and 'Day 2' queues.-195-1051509073088449-bfbc-4b95-ab5d-e769c2839b591590906006aec5d8-f96a-412f-b985-123365be2575c5947168-060b-4277-bb59-99583d7912e373088449-bfbc-4b95-ab5d-e769c2839b59-1953015030text73088449-bfbc-4b95-ab5d-e769c2839b59-1959015030text73088449-bfbc-4b95-ab5d-e769c2839b5927090603073088449-bfbc-4b95-ab5d-e769c2839b5915-4560307f6ee8f2-a03e-4263-a41d-70dc71f5c6b373088449-bfbc-4b95-ab5d-e769c2839b59-195-1515030textMy Queue73088449-bfbc-4b95-ab5d-e769c2839b59The lock is held elsewhere, probably because this work is currently being done on another machine.1509012090b5dceaf4-3953-4d6e-aea5-6d5c2b2236dd73088449-bfbc-4b95-ab5d-e769c2839b5915159030

16fbfb95-1d09-4c74-9af4-2eae4379c7cf73088449-bfbc-4b95-ab5d-e769c2839b59-1956015030timespan0.00:00:0073088449-bfbc-4b95-ab5d-e769c2839b59152409030

43a61663-4c9f-410a-8ea9-65e9f62064db73088449-bfbc-4b95-ab5d-e769c2839b59-19525515060collection73088449-bfbc-4b95-ab5d-e769c2839b5915390150304d771982-ed08-4777-b07a-b66abdb73cde59d4a8bd-f4e1-41aa-a5db-1e98a1e74976ForEachLocked Items73088449-bfbc-4b95-ab5d-e769c2839b5915690150301c891bd5-7491-4ab9-af1d-caead89a218c59d4a8bd-f4e1-41aa-a5db-1e98a1e7497673088449-bfbc-4b95-ab5d-e769c2839b59151020603073088449-bfbc-4b95-ab5d-e769c2839b59-19546515030flag73088449-bfbc-4b95-ab5d-e769c2839b591358259030

192e0ac4-89ff-4f30-890b-14901f47232b73088449-bfbc-4b95-ab5d-e769c2839b59-19575015030text73088449-bfbc-4b95-ab5d-e769c2839b59157509030

1b5b42dc-b47f-44f4-a27d-34e93606603f73088449-bfbc-4b95-ab5d-e769c2839b59158259060547fc90a-f431-4412-a744-efa7f2494208beeb9ee8-b47a-4d02-8720-62fe9cfa2a7873088449-bfbc-4b95-ab5d-e769c2839b5913575010101c891bd5-7491-4ab9-af1d-caead89a218c73088449-bfbc-4b95-ab5d-e769c2839b59-19569015030textUnlocked73088449-bfbc-4b95-ab5d-e769c2839b591354659030

a3f1220e-9f83-4cf8-82a8-c34cc4c40e7e73088449-bfbc-4b95-ab5d-e769c2839b5925546590600e49a2d7-369f-4250-80d0-b07f737e341ecd575a45-5bbc-4a45-b1e5-babc9daaa67673088449-bfbc-4b95-ab5d-e769c2839b592556459030970345e7-d563-4056-9f05-2c22ef65aae373088449-bfbc-4b95-ab5d-e769c2839b594056901010970345e7-d563-4056-9f05-2c22ef65aae373088449-bfbc-4b95-ab5d-e769c2839b59The item must have been worked just now, since the 'Get Lock Items' stage. NB This is unlikely to happen.405570120908b0845c7-8110-43db-bade-ba5aae29b55773088449-bfbc-4b95-ab5d-e769c2839b59The item was locked some time ago and was successfully unlocked, so assume it to be an exception.255570120904599cd81-f350-4e48-82c3-6ad8862a007273088449-bfbc-4b95-ab5d-e769c2839b591531590602c2686d7-378d-4d1b-af45-c93e5bab6a8b73088449-bfbc-4b95-ab5d-e769c2839b59-19531515030datetime73088449-bfbc-4b95-ab5d-e769c2839b59154659060b927e328-54c6-4a85-b164-e2d3f7e7698450acf9b1-9929-454c-8ca4-8a8ebc13b8f973088449-bfbc-4b95-ab5d-e769c2839b59This item was locked recently and may be in the process of being worked, so leave it alone.1557012090485f4dd3-c568-444d-bc42-8d689c66144d73088449-bfbc-4b95-ab5d-e769c2839b592556901010485f4dd3-c568-444d-bc42-8d689c66144d73088449-bfbc-4b95-ab5d-e769c2839b594054651010c5804292-69b5-430f-80b4-9cdd34ae25c273088449-bfbc-4b95-ab5d-e769c2839b59** NB A date threshold is calculated to use as a 'cut off' point. Any locked items older than this date are deemed to be exceptions.21027018012043a61663-4c9f-410a-8ea9-65e9f62064db73088449-bfbc-4b95-ab5d-e769c2839b59** NB The item cannot be marked as an exception immediately, so a tag is used to identify the item an unlocked.6007051801204599cd81-f350-4e48-82c3-6ad8862a007273088449-bfbc-4b95-ab5d-e769c2839b59** NB Any item with the tag is marked as an exception.330855180120547fc90a-f431-4412-a744-efa7f2494208f341d164-7e83-4dfd-a6d5-8a418082351d15-105603073c89f51-ebce-400f-b15d-8f094e061e92f341d164-7e83-4dfd-a6d5-8a418082351d15909060e0d712b4-72dc-4210-bd10-0cf5491ddcfde70e0b1e-a234-4b6f-8d45-26a09c4a97c1f341d164-7e83-4dfd-a6d5-8a418082351d-1956015030textf341d164-7e83-4dfd-a6d5-8a418082351d-19512015030textf341d164-7e83-4dfd-a6d5-8a418082351d270906030f341d164-7e83-4dfd-a6d5-8a418082351d15-456030198bec65-5f24-4761-b69c-4256fdfbbb88f341d164-7e83-4dfd-a6d5-8a418082351d-195-1515030textMy Queue Af341d164-7e83-4dfd-a6d5-8a418082351dThe lock is held elsewhere, probably because this work is currently being done on another machine.150901209012627896-e772-48c0-9e37-e3b8dbab777ef341d164-7e83-4dfd-a6d5-8a418082351d15159030

7301c52b-e44e-4923-860d-21ae91951c73f341d164-7e83-4dfd-a6d5-8a418082351d-1959015030timespan0.00:00:00f341d164-7e83-4dfd-a6d5-8a418082351d153009030

52beb92e-2f9f-4d76-a1d0-d7f5a7b36082f341d164-7e83-4dfd-a6d5-8a418082351d-19540515060collectionf341d164-7e83-4dfd-a6d5-8a418082351d1536012030660f8b29-7109-4a72-a0dd-0f01904b93d7c69ba3e6-fecb-4600-962c-c1bec9e071ecForEachItem IDsf341d164-7e83-4dfd-a6d5-8a418082351d15630120309df4cc1a-f0d0-4960-8437-5bd4e49013a0c69ba3e6-fecb-4600-962c-c1bec9e071ecf341d164-7e83-4dfd-a6d5-8a418082351d152106030a72c8c78-7a04-46d0-b72a-859ba7de0d52f341d164-7e83-4dfd-a6d5-8a418082351d-19522515030timespan7.00:00:00f341d164-7e83-4dfd-a6d5-8a418082351d-19525515030datetimef341d164-7e83-4dfd-a6d5-8a418082351d-19528515030datetimef341d164-7e83-4dfd-a6d5-8a418082351d152556030153f5e28-83a9-4fb4-a86d-f9adc59ceaa6f341d164-7e83-4dfd-a6d5-8a418082351d-1951515030textMy Queue Bf341d164-7e83-4dfd-a6d5-8a418082351d154809030

aa6b2ada-1155-4ec4-9c1f-f0a659d62337f341d164-7e83-4dfd-a6d5-8a418082351d-19557015030flagf341d164-7e83-4dfd-a6d5-8a418082351d1555590602996d1c3-baae-4085-ac94-314dc8c59bb6e108b2f5-9a25-40f1-a1af-48fa4ad5fed4f341d164-7e83-4dfd-a6d5-8a418082351d154209030

43d891fa-4954-4c48-aa6b-c7fa6551ab23f341d164-7e83-4dfd-a6d5-8a418082351d-19546515030textf341d164-7e83-4dfd-a6d5-8a418082351dThe case has completed this stage but does not exist in the next queue. So add a new item to the next queue and tag the original item to indicate case has been promoted to the next stage.15055512090be8ec692-1f50-4ead-8767-f8fd78fb4b8ff341d164-7e83-4dfd-a6d5-8a418082351d-19551015060collectionf341d164-7e83-4dfd-a6d5-8a418082351d2855559030

edba450e-6f12-47ec-807c-54a76af5fac2f341d164-7e83-4dfd-a6d5-8a418082351d-19531515030textPromotedf341d164-7e83-4dfd-a6d5-8a418082351d28563090302996d1c3-baae-4085-ac94-314dc8c59bb6f341d164-7e83-4dfd-a6d5-8a418082351d** NB Dates are calculated to create a time period in which to look for items, in this example the last 7 days.465105180120e0d712b4-72dc-4210-bd10-0cf5491ddcfdf341d164-7e83-4dfd-a6d5-8a418082351d** NB It is assumed the same 'key value' will be used in both queues.21043518012043d891fa-4954-4c48-aa6b-c7fa6551ab23f341d164-7e83-4dfd-a6d5-8a418082351d** NB In this example the 'item data' collection is re-used to create the new item. This does not have to be the case, the new item could have its own collection with different columns from the first collection.465495180120be8ec692-1f50-4ead-8767-f8fd78fb4b8ff341d164-7e83-4dfd-a6d5-8a418082351d** NB A 'negative' tag filter is used here, ie to find items that do not have the specified tag.210270180120153f5e28-83a9-4fb4-a86d-f9adc59ceaa6d5635c6a-b62c-4ab2-bc41-b33ac79c21dcIn this example a collection of queue names is used to move cases through a sequence of stages. Here both completed items and exception items are used to move cases on.-195-10518012088485c9f-8ea2-4d08-99e6-3168fb8e7f18** NB An environment lock is used to ensure only one machine does this work at any one time.225-60180120c53cbb84-f6f1-4e17-bfcc-2892726eb41faf0b997f-1398-44db-a72e-de2aba33eea8** NB An environment lock is used to ensure only one machine does this work at any one time.225-601801209db5822c-cf2d-4410-9655-75ecc7f04e6a73088449-bfbc-4b95-ab5d-e769c2839b59** NB An environment lock is used to ensure only one machine does this work at any one time.210-751801207f6ee8f2-a03e-4263-a41d-70dc71f5c6b3f341d164-7e83-4dfd-a6d5-8a418082351d** NB An environment lock is used to ensure only one machine does this work at any one time.210-60180120198bec65-5f24-4761-b69c-4256fdfbbb88d5635c6a-b62c-4ab2-bc41-b33ac79c21dc15-1056030aeda9bc2-750a-4303-93a3-d5f8acec2755d5635c6a-b62c-4ab2-bc41-b33ac79c21dc-19518015060collectiond5635c6a-b62c-4ab2-bc41-b33ac79c21dc1524015030011cf1ea-1122-4ab3-ad76-793b8c649d3118552619-c327-406e-9f94-61a3df17b4c8ForEachQueue Namesd5635c6a-b62c-4ab2-bc41-b33ac79c21dc1511101503095465138-b795-4105-b240-75670cb558e618552619-c327-406e-9f94-61a3df17b4c8d5635c6a-b62c-4ab2-bc41-b33ac79c21dc2853159030

3d03dfcc-e6c6-4fbb-8aaf-473e980424fdd5635c6a-b62c-4ab2-bc41-b33ac79c21dc151506030fe65280e-e06c-4be9-9a9d-2cdb4fa989abd5635c6a-b62c-4ab2-bc41-b33ac79c21dc-19524015030timespan7.00:00:00d5635c6a-b62c-4ab2-bc41-b33ac79c21dc-19527015030datetimed5635c6a-b62c-4ab2-bc41-b33ac79c21dc151956030df8a2299-8967-4d1d-98f3-d91649ebbfd2d5635c6a-b62c-4ab2-bc41-b33ac79c21dc-19542015060collectiond5635c6a-b62c-4ab2-bc41-b33ac79c21dc285360120309a31ca28-3df2-4274-a4a0-1f76c89b6317d9899048-7061-4255-8c74-9b1552556f5eForEachItem IDsd5635c6a-b62c-4ab2-bc41-b33ac79c21dc2856301203040375afb-ca95-4a05-918d-d9496a3f6ba6d9899048-7061-4255-8c74-9b1552556f5ed5635c6a-b62c-4ab2-bc41-b33ac79c21dc2854809030

3202f7b6-3a24-44d7-88cc-89dbd6ca5421d5635c6a-b62c-4ab2-bc41-b33ac79c21dc-19558515030flagd5635c6a-b62c-4ab2-bc41-b33ac79c21dc2855559060b585960a-36a5-49e4-ae98-2ed6e9414894eb135ddd-fb93-4c11-afbc-e26cfd114b1ed5635c6a-b62c-4ab2-bc41-b33ac79c21dc2854209030

ed979e17-e78c-4cfc-abe7-b32817efe9c8d5635c6a-b62c-4ab2-bc41-b33ac79c21dc-19548015030textd5635c6a-b62c-4ab2-bc41-b33ac79c21dc-19552515060collectiond5635c6a-b62c-4ab2-bc41-b33ac79c21dc-19533015030textPromotedd5635c6a-b62c-4ab2-bc41-b33ac79c21dcThe case has completed this stage but does not exist in the next queue. So add a new item to the next queue and tag the original item to indicate case has been promoted to the next stage.40555512090ee571fd9-9ada-4d5c-af70-f2e68da9b2e3d5635c6a-b62c-4ab2-bc41-b33ac79c21dc5405559030

38cf0049-68f4-49a8-b086-6da0b95758f1d5635c6a-b62c-4ab2-bc41-b33ac79c21dc5406309030b585960a-36a5-49e4-ae98-2ed6e9414894d5635c6a-b62c-4ab2-bc41-b33ac79c21dc** NB It is assumed the same 'key value' will be used in all queues.465390180120ed979e17-e78c-4cfc-abe7-b32817efe9c8d5635c6a-b62c-4ab2-bc41-b33ac79c21dc** NB In this example the 'item data' collection is re-used to create the new item. This does not have to be the case, the new item could have its own collection with different columns from the first collection.720450180120ee571fd9-9ada-4d5c-af70-f2e68da9b2e3d5635c6a-b62c-4ab2-bc41-b33ac79c21dc2857209030

23ca1d6f-ba1a-41eb-bae4-86b88a911edfd5635c6a-b62c-4ab2-bc41-b33ac79c21dc15315906046d47952-db42-4843-95fe-658f947304ed41e66301-58b2-404f-960b-8687836dce85d5635c6a-b62c-4ab2-bc41-b33ac79c21dc157209060fbff3378-f5fa-49c0-8875-d482067584d7644475bf-5d39-40e1-bc5c-3a9320932e02d5635c6a-b62c-4ab2-bc41-b33ac79c21dcThere is no next queue in the sequence154201209040375afb-ca95-4a05-918d-d9496a3f6ba6d5635c6a-b62c-4ab2-bc41-b33ac79c21dc156301010f343c1a3-fbb4-4f47-9350-8b5b392a2161d5635c6a-b62c-4ab2-bc41-b33ac79c21dcThere is no exception queue in the sequence.15825120909ea492b7-5848-4721-80e4-29d953c9572ad5635c6a-b62c-4ab2-bc41-b33ac79c21dc285765120303bc0410a-e2c4-4baa-9d1f-ca576791dfe48c0f9dbf-b37e-4f96-81cd-3c70d2dbc058ForEachItem IDsd5635c6a-b62c-4ab2-bc41-b33ac79c21dc2851035120309ea492b7-5848-4721-80e4-29d953c9572a8c0f9dbf-b37e-4f96-81cd-3c70d2dbc058d5635c6a-b62c-4ab2-bc41-b33ac79c21dc2858859030

631fbb9e-cdbd-45e2-80c5-94026280e93bd5635c6a-b62c-4ab2-bc41-b33ac79c21dc2859609060f02fb666-fe7b-4270-8236-5a71ef9bd186d329569d-8766-48dc-9b80-6b1125cf763ed5635c6a-b62c-4ab2-bc41-b33ac79c21dc2858259030

57f78a25-460d-4e9c-9001-27e8d562288ad5635c6a-b62c-4ab2-bc41-b33ac79c21dcThe case has completed this stage but does not exist in the next queue. So add a new item to the next queue and tag the original item to indicate case has been promoted to the next stage.405960120906079a185-3711-4402-8fa2-1bb51c4d778cd5635c6a-b62c-4ab2-bc41-b33ac79c21dc5409609030

cfa4851a-b43e-4151-84e7-e1227513643cd5635c6a-b62c-4ab2-bc41-b33ac79c21dc54010359030f02fb666-fe7b-4270-8236-5a71ef9bd186d5635c6a-b62c-4ab2-bc41-b33ac79c21dc** NB It is assumed the same 'key value' will be used in all queues.46581018012057f78a25-460d-4e9c-9001-27e8d562288ad5635c6a-b62c-4ab2-bc41-b33ac79c21dc** NB In this example the 'item data' collection is re-used to create the new item. This does not have to be the case, the new item could have its own collection with different columns from the first collection.7208401801206079a185-3711-4402-8fa2-1bb51c4d778cd5635c6a-b62c-4ab2-bc41-b33ac79c21dc15103510106802c43b-0690-4166-83e7-7a6528b6c021d5635c6a-b62c-4ab2-bc41-b33ac79c21dc-19530015030datetimed5635c6a-b62c-4ab2-bc41-b33ac79c21dcEnsure that each complettion in the current queue (within the specified period) has a corresponding item in the next queue.15031512090465caa3b-879a-4791-8400-75324324a788d5635c6a-b62c-4ab2-bc41-b33ac79c21dcEnsure that each exception in the current queue (within the specified period) has a corresponding item in the next queue.150720120908825c477-cd81-4a0b-9eed-afe1cf29a624d5635c6a-b62c-4ab2-bc41-b33ac79c21dc154590600db5f65f-75b4-4d74-912e-953d693923c8751eb923-6b04-4dcb-906e-95b58c86091dd5635c6a-b62c-4ab2-bc41-b33ac79c21dc-195-1515030textSynchronise Queuesd5635c6a-b62c-4ab2-bc41-b33ac79c21dc-1954515030textd5635c6a-b62c-4ab2-bc41-b33ac79c21dc270456030d5635c6a-b62c-4ab2-bc41-b33ac79c21dcThe lock is held elsewhere, probably because this work is currently being done on another machine.15045120906648b68d-560b-4e9a-941e-5499dfc29aa4d5635c6a-b62c-4ab2-bc41-b33ac79c21dc15-309030

646f5dc2-618e-4093-88d6-86193b272222d5635c6a-b62c-4ab2-bc41-b33ac79c21dc-1951515030timespan0.00:00:00d5635c6a-b62c-4ab2-bc41-b33ac79c21dc** NB An environment lock is used to ensure only one machine does this work at any one time.225-105180120aeda9bc2-750a-4303-93a3-d5f8acec275573088449-bfbc-4b95-ab5d-e769c2839b5915960903090fea2f5-b80e-481f-a0c1-c6cbc82be6a073088449-bfbc-4b95-ab5d-e769c2839b59** NB After maintaining the queue, the lock is released.-1801005180120beeb9ee8-b47a-4d02-8720-62fe9cfa2a7873088449-bfbc-4b95-ab5d-e769c2839b59-9016558576573088449-bfbc-4b95-ab5d-e769c2839b59135900603060878dcc-3d5a-46dd-88b1-567b04ee9de473088449-bfbc-4b95-ab5d-e769c2839b5913596090301390052f-3da3-4323-b9c3-1a8dbafa273d73088449-bfbc-4b95-ab5d-e769c2839b591351020603073088449-bfbc-4b95-ab5d-e769c2839b59** NB In the event of an exception the lock must be released.330100518012060878dcc-3d5a-46dd-88b1-567b04ee9de4f341d164-7e83-4dfd-a6d5-8a418082351d158256030f341d164-7e83-4dfd-a6d5-8a418082351d1576590307e8ca434-b96c-4f75-ab18-453747e0560ff341d164-7e83-4dfd-a6d5-8a418082351d** NB After maintaining the queue, the lock is released.-1808101801209df4cc1a-f0d0-4960-8437-5bd4e49013a0f341d164-7e83-4dfd-a6d5-8a418082351d135705603061122d48-a8f1-426f-83c7-8b0c4b947b1ff341d164-7e83-4dfd-a6d5-8a418082351d135765903098e13b9f-9c6f-4b23-a879-717cd751c024f341d164-7e83-4dfd-a6d5-8a418082351d1358256030f341d164-7e83-4dfd-a6d5-8a418082351d** NB In the event of an exception the lock must be released.33081018012061122d48-a8f1-426f-83c7-8b0c4b947b1ff341d164-7e83-4dfd-a6d5-8a418082351d-75150435585d5635c6a-b62c-4ab2-bc41-b33ac79c21dc1512306030d5635c6a-b62c-4ab2-bc41-b33ac79c21dc15117090309ffa4a88-4b71-4d97-b683-bfa1afa3aa89d5635c6a-b62c-4ab2-bc41-b33ac79c21dc** NB After maintaining the queue, the lock is released.-180121518012095465138-b795-4105-b240-75670cb558e6d5635c6a-b62c-4ab2-bc41-b33ac79c21dc15011106030549aa66a-8ea4-493d-bc0b-2bdfa795ddd3d5635c6a-b62c-4ab2-bc41-b33ac79c21dc150117090302d004d52-fadf-4101-a4d2-fcf5b1be5257d5635c6a-b62c-4ab2-bc41-b33ac79c21dc15012306030d5635c6a-b62c-4ab2-bc41-b33ac79c21dc** NB In the event of an exception the lock must be released.3451215180120549aa66a-8ea4-493d-bc0b-2bdfa795ddd3d5635c6a-b62c-4ab2-bc41-b33ac79c21dc-901057051035151656030This process has not been designed to run, it is merely a collection diagram fragments based on a common theme. Each page is an example intended to illustrate how a particular task might be acheived in Blue Prism. These examples may be copied into a new diagram and modified to suit your needs.15302701503a83c039-a985-45b4-8c6f-623fc1a181da