| Task ID | Entry Date | Case Number | Company / Client | Contact | Industrial Camera | Vision Software | Issue Description | Solution Provided | Status | Priority | Solve Timing | Sales Follow-up | Actions |
|---|
Sales & Commercial Follow-up Hub
Track industrial camera leads, spare parts inquiries, quotation follow-ups, and AMC contracts.
Pending Work & SLA Reminder Center
Real-time alerts for unresolved machine vision issues, overdue client visits, and pending deadlines.
Weekly & Monthly Analytics Dashboard
Machine vision support performance, camera brand reliability metrics, and team resolution statistics.
Daily Case Inflow (Last 7 Days)
Case Status Distribution
Industrial Camera Brand Breakdown
Vision Software / SDK Breakdown
Field Service & Travel Expense Hub
Track customer site visits, distance KM allowances, daily meals, hotel stay, and manage bill vouchers with Excel sync.
| Expense ID | Travel Dates & Days | Customer / Plant | Field Engineer | Travel & Distance | Food Breakdown | Hotel & Tolls | Total Amount (₹) | Status | Bill Receipt | Actions |
|---|
Master Databases & System Control Hub
Manage customer directory, industrial cameras & accessories, vision software & AI tools, user credentials, and 6 independent live Excel databases.
| Customer ID | Company / Client Name | Contact Person | Phone / Mobile | Plant / Site Address | Industry Segment | Actions |
|---|
| Item ID | Category & Type | Brand | Model Name & Code | Sensor / Specifications | Interface / Mount | Notes & Application Specs | Actions |
|---|
| Software ID | Vendor / Brand | Software / Vision SDK | Category | Version | Notes & Platforms | Actions |
|---|
Dedicated Live Excel Databases
Each module writes directly to its own independent .xlsx database file in real-time. Download or export below.
Tasks & Support Cases
tasks_database.xlsxMaster log of all daily machine vision tasks, case tickets, client issues, camera models, solutions, and SLA timing.
Field Travel Expenses
expenses_database.xlsxSeparate log tracking engineer customer visits, distance KM allowances, meals, hotel stay, toll charges, and claim status.
Customer Directory Master
customers_database.xlsxMaster client directory for auto-filling company names, plant sites, contact persons, phones, emails, and GST numbers.
Industrial Cameras Catalog
cameras_database.xlsxMaster database of Basler, Hikrobot, Cognex, Keyence, FLIR, Baumer cameras with sensor types, resolutions, and mounts.
Vision Software & SDKs
software_database.xlsxMaster catalog of OpenCV, HALCON, VisionPro, In-Sight, Pylon SDK, MVS client, and custom machine vision applications.
Users & Login Credentials
users_database.xlsxMaster credentials database storing engineers, managers, and admin accounts, passwords, roles, and authorization status.
| User ID | Username | Password / Token | Full Name | Role & Access | Phone | Status | Actions |
|---|