ROBOTICSAUTOMATIONPROCESS
Phase2–WorkflowandToolsUsed EVENTALIGNMENTWITHIQAC NityaGupta[24112513]
OmPrakashSamal[24112514]
1. UiPathTools/ComponentsUsed
A.Sequence-Useinthisprojectfor:
● Readingeventdata
● Checkingkeywords
● Assigningcategories
● WritingresultstoExcel
B.Flowchart-Useinthisprojectfor:
● Checkingifaneventmatchesacategory
● RoutingeventtocorrecttheIQACcategory
● Handlingexceptions
C.Variables-Usedtostoretemporarydata,suchas:
● EventTitle
● EventDescription
● CategoryName
● EventCount
D.Arguments-Usedwhenpassingdatabetweenworkflows
E.DataTables-UsedtostoreandprocessExceleventrecords
2. UiPathActivitiesUsed
A. ExcelActivities-
● ExcelApplicationScope
● ReadRange
● WriteRange
● AppendRange
● SaveWorkbook
B. DataProcessingActivities-
● ForEachRow
● Assign
● FilterDataTable
C DecisionActivities
● IfActivity
D. TextProcessingActivities-
● Contains
● StringMatching
● Regex
E. LoggingActivities-
● LogMessage
F. ExceptionHandling-
● TryCatch
START
1 InitializeSystem
2.OpenExcelFile(Event Data.xlsx)
3.ReadalleventrecordsintoDataTable
4.FOReachrowinDataTable
ReadEventTitle
ReadEventDescription
ReadDepartment
Convertdescriptiontolowercase
IFdescriptioncontains"un"OR"sustainability"THEN Category←"SDG"
ELSEIFdescriptioncontains"interview"OR"resume"THEN Category←"Placement"
ELSEIFdescriptioncontains"speaker"OR"guestlecture"THEN Category←"GuestLecture"
ELSE Category←"Other"
ENDIF
WriteCategorybacktoExcel
ENDFOR
5.Countthenumberofeventsperdepartment
6.GenerateSummaryReport TotalEvents