Doctor Medicine Master

Overview

Every doctor has their own medicine master — the list of medicines they prescribe regularly, each with the frequency, duration, instruction and route they usually use. When the doctor writes a prescription, this list is what they pick from, so a consultation can be filled in without typing each line.

The list belongs to one doctor. It is not a hospital-wide catalogue, and it does not touch stock, prices or pharmacy items.

Getting there

Sidebar → Doctor → (select the doctor) → ID opens the doctor's management page, /admin/doctor/doctor-mangement/{doctorId}.

Three actions sit at the top of that page:

Who can do this

Everything imported is owned by the doctor, not by whoever uploaded it — so an admin can load the list and the doctor can still edit and delete the entries afterwards.

Adding medicines one at a time

1. Open the doctor's management page.
2. Select Create Medicine.
3. Fill in Medicine, Frequency, Duration, Instruction and Route. All five are required, and each is free text — there is no fixed list of values.
4. Save. The medicine appears straight away in the table on the same page.

A medicine that is already on the list with the same frequency and duration is refused as a duplicate. The same medicine with a different frequency or duration is a separate entry and is allowed — for example Tab Paracetamol 500mg / 1-0-1 / 5 days and Tab Paracetamol 500mg / SOS / 3 days are two legitimate entries.

Bulk upload

Use this when a doctor joins with a list of a few hundred medicines, or when the list needs updating in one go.

1. Open the doctor's management page.
2. Select Bulk Upload Medicine.
3. Select Download the template and open it in Excel. It contains the header row only — no sample rows.
4. Add one medicine per row, starting on row 2.
5. Choose the file, decide whether to skip existing medicines (below), then select Import medicines.

The sheet

• The header row must be row 1. Headers are matched ignoring case and surrounding spaces; extra columns are ignored.
• The file must be .xlsx, .xls or .csv.
• Every cell is limited to 255 characters.
• There is no Doctor column — the doctor is the page you opened.

Skip existing medicines

The checkbox is on by default and decides what happens to a row whose medicine name is already on this doctor's list:

The comparison uses the medicine name only — trimmed and ignoring case, so Tab Paracetamol 500mg matches tab paracetamol 500mg . Frequency and duration are not part of this comparison. This is deliberate: re-uploading a master file that has grown over time should add the new lines without arguing about the ones you already have. Clear the checkbox when you want to be shown every line that overlaps instead.

Limits

• 1,000 rows per file, hard. A larger sheet is refused — split it.
• 1,000 medicines per doctor, in total. Search and Edit Medicine shows at most 1,000 rows, so anything beyond that would be invisible.
• Skipped rows do not count toward the total, so a full list can still be re-uploaded with the checkbox ticked.

Nothing is written unless the whole sheet is clean

All checks run before a single row is saved. If any row fails, the page lists every problem at once in a Row · Medicine · Column · Value · Reason table, which you can download as a CSV, and the list is left exactly as it was.

Two things are always errors, whichever way the checkbox is set:

• the same medicine appearing twice in one file with the same frequency and duration;
• a required cell left blank, or a cell longer than 255 characters.

Common issues

Related guides

• Creating a Patient Prescription — the list is what the prescription screen picks from
• Creating Doctors — adding a doctor before their list can be loaded