Posts

Handling Azure Data Classification in MS Excel/Word/PDFs

By
Image
In this article we will see how to set azure classification label to an excel/word/pdf file at the time of its creation during runtime programmatically. This solution is targeted for developers, architects, COE working on automating business processes that involves MS Office documents Background Organizations are now adopting Microsoft Azure Information Protection services to enable its operations to have all MS office documents, PDFs and email being classified based on the sensitivity of data these documents or email are holding. Meaning if you are creating an excel report, it will be mandatory to classify the same before saving. This situation will impact all automation running across the organization. Azure Information Protection allows labeling/ protecting via PowerShell cmdlet When you install the  Azure Information Protection  unified labeling client, PowerShell commands are automatically installed as part of the  Azure Information Protection  module, with cmdl...
3 comments
Read more

RPA Technical Story: Our production BOT system went down

By
Image
In this technical story, we will be answering the below questions and would understand the problem first before before jumping on the solution What was the issue ? .      In the middle of BOT execution, we saw that system went down and later got disconnected from the server We could not take remote into this BOT runner system and therefore were forced to involve client IT server maintenance team. Server maintenance team performed a restart on the said system and remote connection was restored How this issue occurred ? BOT was executing VbScript on an bulky excel file (rows > 100k) extracted from an ERP system VbScript/Excel calculation caused CPU usage to reach 100% and maxing out of the system resources To prevent further damages, system went down and disconnected itself from server Note:  We were unaware about the impact of high CPU usage on the BOT execution and on the system. Than...
1 comment
Read more

Working with EML files in Pega Robotics Solution

By
Working with EML files in Pega Robotics Solution In my recent RPA project for an insurance & finance major, we caught up with situation where the format for the input found to be different in production environment with respect to the UAT. This deviation was mainly the change of the input file type from MSG to EML. Let’s talk about EML file format; EML is file extension for an email message saved to a file in the MIME RFC 822 standard format by Microsoft Outlook Express as well as some other email programs. It contains email header, subject, body, hyperlinks and attachments etc. MSG is file extension for email message used as default by Microsoft outlook and exchange. It contains email header, subject, sender, body, hyperlinks, attachments etc. Earlier during the development phase, it was only MSG files we received from the source application and we were able to parse it using Microsoft Office Interoperability framework. However during go-live we discovered tha...
7 comments
Read more