Exporting Exceptions from BP to Excel

[AndyK16]

Hi All is there a way to export the Exceptions report from the control room to excel showing the reason for the exception

 

[anisjolly]

Hi @AndyK16

Yes you can. You'd need to use the Work Queues object to Get Exception Items, which you would then use with the Get Item Data action to extract the Case Data for each case. You would then need to use the MS Excel VBO to Write Collection - which writes the Case Data you have collected / filtered to a nominated Excel Spreadsheet.

You would then need to use the Save Current Workbook As action to save the Excel spreadsheet.

Hope that helps.

 

[AndyK16]

Hi @AndyK16

Yes you can. You'd need to use the Work Queues object to Get Exception Items, which you would then use with the Get Item Data action to extract the Case Data for each case. You would then need to use the MS Excel VBO to Write Collection - which writes the Case Data you have collected / filtered to a nominated Excel Spreadsheet.

You would then need to use the Save Current Workbook As action to save the Excel spreadsheet.

Hope that helps.

thank you for the quick reply

 

[anisjolly]

Do let us know how you get on so we can mark this thread as solved

 

[Jayaprakashkm]

Thanks for reply, its not working, shall I send my bot?

 

[AndyK16]

Do let us know how you get on so we can mark this thread as solved

yes you can close