Import Data

Import Manufacturers

Upload an Excel file to import multiple manufacturers at once.

Download Template
Required columns: name, bis_license, cml_number, license_validity
Supported formats: .xlsx, .xls, .csv
Max file size: 10MB
Import QR Codes

Upload an Excel file to generate multiple QR codes at once.

Download Template
Required columns: manufacturer_name, mi_type, batch_number, qr_type
Optional columns: lateral_length (required for secondary drip QR codes)
Supported formats: .xlsx, .xls, .csv
Max file size: 10MB
Import Instructions
Manufacturer Import Format:
name bis_license cml_number license_validity
Jain Irrigation Systems Ltd. BIS-2024-001 CML-JIS-2024-001 2025-12-31
QR Code Import Format:
manufacturer_name mi_type batch_number qr_type lateral_length
Jain Irrigation Systems Ltd. drip BATCH-2025-001 primary
Jain Irrigation Systems Ltd. drip BATCH-2025-001 secondary 150.50
Important Notes:
  • The first row should contain column headers exactly as shown above
  • Manufacturer names in QR Code import must exactly match existing manufacturers
  • MI Type values: drip or sprinkler
  • QR Type values: primary or secondary
  • Lateral length is required only for secondary QR codes of drip irrigation
  • License validity date format: YYYY-MM-DD
  • Import manufacturers first, then import QR codes
QR Code Types & Purposes:
Primary QR Codes:
  • Drip: On laterals every 150m
  • Sprinkler: On HDPE pipe near coupler
  • Purpose: Quality assessment only
Secondary QR Codes:
  • Drip: On lateral bundles with length
  • Sprinkler: Not applicable
  • Purpose: Quality + quantity assessment