📋 SYSTEM USER GUIDE & TROUBLESHOOTING

🎯 PURPOSE OF THIS SYSTEM

Police Violator Master Processing System is designed to:

  • Upload and process traffic violator Excel data
  • Filter records by village/location
  • Move processed records from REMAINING to PROCESSED
  • Maintain audit trail of all actions
  • Generate multi-sheet Excel reports
  • Prevent duplicate processing of same violator

📌 STEP-BY-STEP USAGE

  1. Login: Use admin/admin123 or officer/officer123
  2. Upload Excel: Click "UPLOAD & PARSE" (Admin only)
  3. Search Villages: Enter village names (comma separated) and click SEARCH
  4. Preview Results: Check matching records (shows first 50)
  5. Process Records: Enter village name in PROCESS & REMOVE panel
  6. Check Counters: Watch TOTAL, REMAINING, PROCESSED update
  7. Download Reports: Use FINAL MASTER EXCEL for complete report

📊 EXCEL FORMAT REQUIREMENTS

Your Excel file MUST have these columns:

  • Challan Number - Unique challan ID
  • Vehicle Number - Vehicle registration
  • Violator Address - Primary address for village search
  • Violator Owner Address - Secondary address for village search

Other columns are optional but preserved

🔧 TROUBLESHOOTING

IssueSolution
No records found after searchCheck village spelling, use uppercase, ensure address columns exist
Process button not workingLogin as Admin (officer cannot process)
Duplicate records in countSystem auto-prevents duplicates using Challan+Vehicle
Excel not uploadingEnsure .xlsx or .xls format, first sheet contains data
Preview shows 0 recordsVerify Excel has "Violator Address" column

1 EXCEL UPLOAD

2 LIVE COUNTERS

TOTAL RECORDS

0

REMAINING

0

PROCESSED

0

3 MANUAL FILTER (Preview Only - Does NOT remove data)

✓ Searches in both "Violator Address" AND "Violator Owner Address" fields ✓ Duplicate records are counted only once

Use SEARCH to preview records (max 50 rows)

4 PROCESS & REMOVE (Moves from REMAINING → PROCESSED)

✓ Searches in both "Violator Address" AND "Violator Owner Address" fields ✓ Duplicate records are processed only once

✓ Searches only in REMAINING data ✓ Removes matched records ✓ Adds to PROCESSED data ✓ Updates counters ✓ Logs to summary

5 FINAL EXPORT

6 PROCESSING SUMMARY LOG

Search KeywordMatchedRemaining AfterDate & TimeAction