Download the PHP package thibitisha/kmpdc-seeder without Composer

🩺 KMPDC Seeder

A Laravel 12+ package for scraping, cleaning, and importing practitioner data from the Kenya Medical Practitioners and Dentists Council (KMPDC) master register.

This package is designed for:

• 🧑‍🏫 Teaching structured data ingestion and seeding in Laravel

🚀 Features

✅ Scrapes KMPDC register HTML into structured CSVs
✅ Extracts & normalizes:

• Practitioner details, qualifications, degrees, institutions
  ✅ Imports structured data into related tables
  ✅ Works seamlessly with Eloquent models

📦 Installation

`

🧩 Database Schema

The package models relationships between practitioners, qualifications, degrees, institutions, and related entities.

📝 Notes

• All inserts and relationships are handled via Eloquent models

🧩 Model Setup & Relationships

Before running the import commands, ensure that all Eloquent models and their respective relationships are correctly defined according to the database schema provided above.

Each model should reflect its table structure and foreign key relationships.

⚠️ Note: the $fillable propery should also be defined in each model

For example:

• Practitioner

  • belongsTo → Status, Speciality, SubSpeciality
  • hasMany → Contact, License, Qualification, PractitionerDocument, VerificationLog

• Qualification

  • belongsTo → Practitioner, Degree, Institution

• SubSpeciality

  • belongsTo → Speciality

• License

  • belongsTo → Practitioner
  • hasMany → Payment

These relationships are essential for the import command to correctly associate records during data seeding. Ensure that:

• Foreign keys are properly defined in migrations.
• Model relationships use typed relationship methods (as required in Laravel 12).
• Nullable foreign keys (e.g., speciality_id, sub_speciality_id) are handled gracefully to avoid integrity constraint violations.

⚠️ Note: The package assumes these model relationships exist and are correctly implemented. Missing or incorrectly defined relationships may cause the import process to fail or produce inconsistent data.

🔁 Workflow Overview

This package processes practitioner data in three main stages:

🧩 Run in this order: sync → extract → import

🧭 Step 1 — Sync (Generate CSV)

The sync command crawls the KMPDC register and saves a timestamped CSV file to your Laravel storage directory.

`

Output Example:

Each run produces a uniquely named file based on the timestamp, ensuring previous syncs remain preserved.

Included columns:

• Fullname
• Registration Number
• Address
• Qualifications
• Discipline / Speciality
• Sub-speciality
• Status
• Profile link

🧮 Step 2 — Extract (Generate JSON)

The extract command reads the latest timestamped CSV and produces clean, structured JSON files.

📥 Step 3 — Import (Save to Database)

Imports the normalized JSON into your relational schema.

🧠 Verify Imports

You can verify successful import via Tinker:

Examples

🤝 Contributing

1. Fork the repository
2. Create your feature branch (git checkout -b feature/my-feature)
3. Commit your changes (git commit -m 'Add my feature')
4. Push to your branch (git push origin feature/my-feature)
5. Open a Pull Request 🎉

🏛️ Acknowledgement & Disclaimer

This package utilizes publicly accessible practitioner data from the
official Kenya Medical Practitioners and Dentists Council (KMPDC) website.

The author, KDBZ, is not affiliated with, endorsed, or sponsored by KMPDC.
All practitioner data, formats, and associated intellectual property remain the exclusive property of KMPDC.

This project is provided solely for educational, analytical, and research purposes.
It is not intended for redistribution, resale, or use in any commercial or official capacity.

Users are responsible for ensuring that their use of this tool complies with:

• The KMPDC website’s terms of service
• Applicable data protection and privacy laws
• Relevant ethical and professional standards

For any commercial or institutional use, explicit authorization should be sought directly from KMPDC.

📜 License

This package is open-sourced software licensed under the MIT license.

Author: KDBZ Repository: https://github.com/kdbz/kmpdc-seeder