Clear CAIE Errors with EBPG and SLED

Step 1: Login to Colleague and run the mnemonic CAIE

Colleague CAIE image

Step 2: Click on the Export to Excel button at the top left corner.

Export to Excel button image

Step 3; Click the "Download" button, this will save to your Downloads in the File Explorer.

Download button image

Step 4: At the bottom of the computer screen,

click on the File Explorer icon (4a)
on the left hand side of the pop-up window, click on the Downloads (4b)
Finally double-click on the file to open (4c)

File explorer downloads folder image

Step 5: At the top of the excel workbook

right click the "B" Column (5a)
then click on Insert(5b)

Step 6: In order for Colleague to work, we need to remove the *1, the star is a wildcard in most applications. In Cell "A2" enter this formula =LEFT(A2,LEN(A2)-2)

=LEFT returns a specific number of characters
A2 is the cell we are using (Column A, Row 2)
LEN calculates the number of characters in the string
A2 is the cell we are using to subtract characters
-2 is the number of characters we are subtracting - to get rid of the *1

insert formula into excel image

Step 7: In the bottom right corner of cell A2

There is a small box (7a)
Using your mouse click and hold, drag it straight down (7b)

This will insert the formula from A2 into the following cells, automatically updating the formula (replacing A2 with A3, A4, A5 and so on)

dragging formula down image

Step 8: We need to copy all the information from Column B

If there are some items you do not want to copy or exclude, please delete them from the excel worksheet

Using your mouse highlight all the cells in Column B (8a)
Then either use Ctrl+c (keyboard shortcut to copy) OR right click an select Copy (8b)

Step 9: We need to create a saved list in Colleague.

Open Colleague and type the mnemonic SLED (9a)
Enter EBPG.(todays date) in the Savedlist LookUp field (9b)
Then finally click on Ok(9c)

saved list image

Step 10: Click on Add to create this Saved list

add saved list image

Step 11: Now to paste in the excel column B

Click on the Detail button (11a)
Click in the open area of the pop-up (11b)
Either use keyboard shortcut (Ctrl+v) or using your mouse, right click and Paste (11c)
Click on Save (11d)
Finally click on Save All(11e)

Step 12: Now that our saved lists is created

Enter the mnemonic EBPG (12a)
For the Saved list name enter EBPG... to search the Saved lists (12b)
Select the Saved list with today's date (12c)
then click on Open(12d)

EBPG select todays date image

Step 13: You should see all the Batch ID's that you copied from excel.

Click on Save All this will process all the records. (13a)
Select Y for yes to delete (13b)

Save all image

Step 14: Set the Output Device to H Hold/Browse File Output and click on Save All

Step 15: You have the option to Save As, to save the results to your computer otherwise;

ELF Batch Deletion - click the X at the top right (15a)
Batch Error Report - click on the X at the top right (15b)

Batch report images

You can now check CAIE to verify they have been removed.