Nikshay Automation

🏢 Pre-select Facility (Global Override)

Select a facility here to apply it to ALL rows in your Excel file. Doing this will ignore any facility columns in the Excel.

Enrollment Test Updation All-In-One

ℹ️ Required Excel Format

Your Excel file must have these exact column headers (you can manually edit your file to match):

PhiName (optional: content must exactly match one of the PHI names from the available list)
FirstName (Text, e.g. Rahul)
LastName (Text, e.g. Ghandhi)
Age (Numeric, e.g. 54)
Sex (e.g. Male / Female / Transgender)
PhoneNo (10-digit number)
Address (Text)
Key Population/Risk factors (optional, default: Other)
Pincode (optional, default: 135745)
Symptom (optional)
TypeOfCaseFinding (optional)

📥 Download Sample Excel File (line_listing.xlsx)

💡 Insight: The sample file contains two sheets:
• Sample Header: Shows the exact Header format.
• Sample Row: Demonstrates the approved Form Value formats.

🔍 Priority Selection Hierarchy

1st Priority (Override): Global Hierarchy selected at the top.
2nd Priority (Excel): PhiName / VillageName from your file.
3rd Priority (Default): Falls back to Headquarters Village if unspecified.

🛠️ Auto-format raw Excel file (Optional)

Upload a raw Excel file to automatically convert it to the required structure. The modified file will download instantly.

Test Updation Format

Your Excel file must contain these columns:

Id (Patient ID numeric)
Lab (content must exactly match one of the PHI names from the available list above, e.g. CHC DELHI)
Date Of Reporting (Format: DD-MM-YYYY)

📥 Download Sample Excel File (test_file.xlsx)

💡 Insight: The sample file contains two sheets:
• Sample Header: Shows the exact Header format.
• Sample Row: Demonstrates the approved Form Value formats.

🔍 Priority Selection Hierarchy

1st Priority (Override): Lab selected in the dropdown below.
2nd Priority (Excel): Lab / Testing Facility column in your file.
3rd Priority (Default): Uses the Login TU/Facility if no other data exists.

Select Test Type

Lab Override

Select from List Manual ID

Result Override

Default Logic Manual Result Absent (No Result)

Upload Excel File for Test Updation

Nikshay Automation

🏢 Pre-select Facility (Global Override)

ℹ️ Required Excel Format

🔍 Priority Selection Hierarchy

Test Updation Format

🔍 Priority Selection Hierarchy

All-In-One Automation

🔍 Priority Selection Hierarchy

Select Tests to Auto-Update:

Chest X Ray

Truenat (MTB)

Cy-Tb

Processing Log

Process Summary