Hi, can anyone share me the code for this task.

#1
Process Use Case
  • Open the Data.xlsx file.
  • The file contains data for payment mode, bank, and RRN.

  • Open the Macro Sheet.xlsx file.
  • This file contains macro names for the Data file.

  • Develop a Bot to capture the right macro names and update the Data file.
Business Rules/Conditions to Automate the Process
The Bot you develop is expected to do the following:
  • The Bot needs to open the Data file.
  • In the Data file, the Bot needs to read payment mode, bank name, and RRN number row by row.

  • The Bot needs to check for all the given data in the Macro Sheet file.
  • If payment mode, bank name, and RRN number is a (Match) (Valid) then pick up the macro
  • name and dump it into the Data file in Column E.

  • If the bank name is SBI, Corporation Bank, HDFC, or ICICI then consider bank name in Macro sheet as – (Hyphen)

  • You may get multiple matches in the MacroSheet.xlsx file, if multiple matches are found, sum up the instances of matches found and log it in column “Number of Matches”– Very Important!
Files/Folders:
  • After files creation completed then all xlsx file will moved into output folder Location : C:\Users\Datta\Desktop\Use Case\Your Name\Output
Note : Naming convention of each file must be below format.
<Name of Candidate>_<Date of Test>.file-extension
  • Input files, Audit logs, Error Snapshots should be placed in proper folders in the below location:
  • C:\Users\Datta\Desktop\Use Case\Your Name\Input
  • C:\Users\Datta\Desktop\Use Case\Your Name\Audit logs
  • C:\Users\Datta\Desktop\Use Case\Your Name\Error Snapshots

*NOTE : Do not use any hard code in the script, use proper logs and error handling.
 
#6
Process Use Case
  • Open the Data.xlsx file.
  • The file contains data for payment mode, bank, and RRN.

  • Open the Macro Sheet.xlsx file.
  • This file contains macro names for the Data file.

  • Develop a Bot to capture the right macro names and update the Data file.
Business Rules/Conditions to Automate the Process
The Bot you develop is expected to do the following:
  • The Bot needs to open the Data file.
  • In the Data file, the Bot needs to read payment mode, bank name, and RRN number row by row.

  • The Bot needs to check for all the given data in the Macro Sheet file.
  • If payment mode, bank name, and RRN number is a (Match) (Valid) then pick up the macro
  • name and dump it into the Data file in Column E.

  • If the bank name is SBI, Corporation Bank, HDFC, or ICICI then consider bank name in Macro sheet as – (Hyphen)

  • You may get multiple matches in the MacroSheet.xlsx file, if multiple matches are found, sum up the instances of matches found and log it in column “Number of Matches”– Very Important!
Files/Folders:
  • After files creation completed then all xlsx file will moved into output folder Location : C:\Users\Datta\Desktop\Use Case\Your Name\Output
Note : Naming convention of each file must be below format.
<Name of Candidate>_<Date of Test>.file-extension
  • Input files, Audit logs, Error Snapshots should be placed in proper folders in the below location:
  • C:\Users\Datta\Desktop\Use Case\Your Name\Input
  • C:\Users\Datta\Desktop\Use Case\Your Name\Audit logs
  • C:\Users\Datta\Desktop\Use Case\Your Name\Error Snapshots

*NOTE : Do not use any hard code in the script, use proper logs and error handling.
Hi Rajasimha,

Can you send me ,Step by step process above Bot Use Case.I got this task for Master Certification.


,
 
#13
Process Use Case
  • Open the Data.xlsx file.
  • The file contains data for payment mode, bank, and RRN.

  • Open the Macro Sheet.xlsx file.
  • This file contains macro names for the Data file.

  • Develop a Bot to capture the right macro names and update the Data file.
Business Rules/Conditions to Automate the Process
The Bot you develop is expected to do the following:
  • The Bot needs to open the Data file.
  • In the Data file, the Bot needs to read payment mode, bank name, and RRN number row by row.

  • The Bot needs to check for all the given data in the Macro Sheet file.
  • If payment mode, bank name, and RRN number is a (Match) (Valid) then pick up the macro
  • name and dump it into the Data file in Column E.

  • If the bank name is SBI, Corporation Bank, HDFC, or ICICI then consider bank name in Macro sheet as – (Hyphen)

  • You may get multiple matches in the MacroSheet.xlsx file, if multiple matches are found, sum up the instances of matches found and log it in column “Number of Matches”– Very Important!
Files/Folders:
  • After files creation completed then all xlsx file will moved into output folder Location : C:\Users\Datta\Desktop\Use Case\Your Name\Output
Note : Naming convention of each file must be below format.
<Name of Candidate>_<Date of Test>.file-extension
  • Input files, Audit logs, Error Snapshots should be placed in proper folders in the below location:
  • C:\Users\Datta\Desktop\Use Case\Your Name\Input
  • C:\Users\Datta\Desktop\Use Case\Your Name\Audit logs
  • C:\Users\Datta\Desktop\Use Case\Your Name\Error Snapshots

*NOTE : Do not use any hard code in the script, use proper logs and error handling.
Hi, i hope you have a code for this task ,could you please send the code to my mail plzz ,,thanks in advance
 
Top