Fixing Errors

Understanding Error Messages

If something goes wrong, the system shows an error file.

Opening the Error File

Download and open the error Excel file.

Reading Error Columns

The file has three extra columns at the end:

Column	What it Means
_STATUS	SUCCESS, EXISTS, or FAILED
_STATUS_CODE	Number code (201=success, 400=error)
_ERROR_MESSAGE	What went wrong

Common Errors and Solutions

Error: "Department not found"

Solution: Check the department name spelling. It must match exactly.

---

Error: "Mobile number already exists"

Solution: This mobile number is already used. Enter a different number.

---

Error: "Invalid date format"

Solution: Use DD-MM-YYYY format (e.g., 01-01-2024)

---

Error: "Parent code not found"

Solution: The parent boundary does not exist. Check the parent code.

---

Steps To Fix and Re-upload

Step 1: Open the error file

Step 2: Find rows with FAILED status

Step 3: Fix the errors in those rows

Step 4: Save the file

Step 5: Upload again to the notebook of the specific phase

---

Quick Tips

Tip 1: Always Save Before Upload

Save your Excel file before uploading to avoid losing work.

Tip 2: Don't Change Column Names

Never rename or delete column headers in templates.

Tip 3: Check Spelling

Department names, codes, and references must match exactly.

Tip 4: One Phase at a Time

Complete each phase before moving to the next.

Tip 5: Keep Templates Safe

Save copies of your filled templates for future reference.

---

Getting Help

If You Are Stuck

1. Check this guide again
2. Look at the error message carefully
3. Contact your IT support team

---

Checklist

Use this checklist to track your progress:

Setup

• Jupyter Notebook is open
• DataLoader.ipynb is open
• I have my login credentials

Phase 0: Login

• Entered gateway URL
• Entered username and password
• Login successful ✅

Phase 1: Tenant & Branding

• Downloaded template
• Filled Tenant Info sheet
• Filled Branding Details sheet
• Uploaded and processed ✅

Phase 2: Boundaries

• Created/selected hierarchy
• Generated template
• Filled boundary data
• Uploaded and processed ✅

Phase 3: Common Masters

• Downloaded template
• Filled Departments & Designations
• Filled Complaint Types
• Uploaded and processed ✅

Phase 4: Employees

• Generated dynamic template
• Filled Employee Master
• Uploaded and processed ✅

Final Check

• All phases completed
• No errors remaining
• Data verified in the CRS application