Loading Employees For mGramSeva

Overview

This page provides a clear and concise guide for automating user creation in mGramSeva. It allows you to efficiently create users and manage their roles in the system.

Follow the steps provided on this page to create users for mGramSeva using a Python script. The process involves preparing an Excel sheet with user information, configuring the Python script, and executing it.

Pre-requisites

1. Python script for creating users for mGramSeva.The sample format of the Python script is attached below.

2. Excel sheet containing user data. The sample format of the Excel sheet is attached below. Make sure to populate the data in the same format.

   • Columns: tenant name, mobile no, father name, gender, date of birth (dd/mm/yyyy), type, and ward (fixed to "ward 1").

   • Types: Sarpanch, Secretory, Revenue Collector, Division User or State User

   • Roles for Sarpanch: COLLECTION_OPERATOR, EXPENSE_PROCESSING, BULK_DEMAND_PROCESSING, DASHBOARD_VIEWER, GP_ADMIN.

   • Roles for Secretory: EXPENSE_PROCESSING, BULK_DEMAND_PROCESSING, DASHBOARD_VIEWER, GP_ADMIN, COLLECTION_OPERATOR.

   • Roles for Revenue Collector: COLLECTION_OPERATOR, DASHBOARD_VIEWER.

   • Roles for Division User: HRMS_ADMIN, DIVISION_ADMIN

   • Roles for State User: HRMS_ADMIN, STATE_ADMIN

Steps

1. Prepare the Excel Sheet:

   Create an Excel sheet with the following columns and data in the given format:

   • Tenant Name (in lowercase)

   For State User tenant name will be pb

   • Mobile Number

   • Father's Name (Mandatory, use "NA" if not available)

   • Gender (M/F - this data is mandatory)

   • Date of Birth (in the format dd/mm/yyyy)

   • Type (Sarpanch, Secretory, Revenue Collector, Division User or State User)

   • Roles

     Based on the User Type, set corresponding roles:

     • Sarpanch: COLLECTION_OPERATOR, EXPENSE_PROCESSING, BULK_DEMAND_PROCESSING, DASHBOARD_VIEWER, GP_ADMIN

     • Secretary: EXPENSE_PROCESSING, BULK_DEMAND_PROCESSING, DASHBOARD_VIEWER, GP_ADMIN, COLLECTION_OPERATOR

     • Revenue Collector: COLLECTION_OPERATOR, DASHBOARD_VIEWER

     • Division User: HRMS_ADMIN, DIVISION_ADMIN

     • State User: HRMS_ADMIN, STATE_ADMIN

   • The 'Boundary' should be set to "Ward 1" as per mGramSeva standards.

2. Run the Python Script:

   • Open the Python script.

   • Provide the following information within the script:

     • Host URL: Specify the target environment (prod, qa, or uat).

     • Username and Password: As per your host URL.

     • Path to the Excel file: Ensure the Excel file is in the same location as the script.

   • Execute the script.

3. Post-Execution:

   • Do not open the Excel file until the script has completed its task.

   • After the script finishes, open the Excel file to review the results.

   • The Excel file will contain two columns:

     • User ID: If successful, the ID will be present.

     • Status: Will indicate either "Success" or "Failure." If failed, the reason for failure will be provided.

6KB

updated-user.xlsx

10KB

onBoarding.py