1. Introduction

The SMRP Automator is a Chrome Extension designed to streamline data entry for Dietetic modules within the Ministry of Health's SMRP Portal (MyHDW). It integrates directly with Google Sheets to eliminate manual double-entry, automates patient registration, and ensures data accuracy.

2. Installation Guide

You can install the SMRP Automator directly from the Chrome Web Store.

Step 1: Download from Store

1. Visit the Chrome Web Store Link.
2. Click the blue "Add to Chrome" button.
3. Confirm by clicking "Add extension" in the popup.

Figure 2.0: Clicking 'Add to Chrome'

Step 2: Troubleshooting "Access Denied" Errors

Figure 2.1: The Access Denied Error

Why is this happening?
Your browser is currently signed in with your official Ministry of Health account (@moh.gov.my). The system administrator for MOH has blocked access to the Chrome Web Store for security reasons.

The Solution:
You must switch to your personal Gmail account to perform the download.

1. Click your Profile Icon at the top right of the Chrome browser.
2. Select your personal account.
3. Once switched to the personal profile, reload the Web Store link.
4. You will now be able to click "Add to Chrome".

Figure 2.2: Switching Chrome Profiles

3. Initial Setup

1. Open Setup: Click the Gear Icon inside the extension.
2. Link Spreadsheet: Enter the Spreadsheet ID from your Google Sheet URL (the text between /d/ and /edit), then select the sheet name.
   

   Figure 4.1: Finding the Google Sheet ID
3. Practitioner Credentials:

   Enter your own IC Number or AHP Number into the "Dietitian IC/ AHP Number" field in the settings menu.

4. DT Prefix:

   Enter your department code (e.g., DT01, DT10, DT30).

   
   

   Figure 4.4: Configuring Registration Prefix and Sequence
5. Login: Click Login. A Google sign-in window will appear. You MUST log in using your official Workspace Email (@moh.gov.my). DO NOT use the personal email that you used to download the extension.
   
   

   Figure 4.5: Successful Connection using Workspace Email

4. Workflows

Before You Begin: Preparation

1. Locate Row Numbers: Find the row containing the desired patient data in your Google Sheet by checking the row index on the left (e.g., Row 4). Enter that row number into the workspace field.

Figure 5.0: Locating row index reference indices

2. Launch Point: Access your SMRP account portal. You MUST open the base Patient Search Page before clicking any execution buttons; the extension will start by auto search for patient IC number if you trigger it from this specific page.

Figure 5.1: The SMRP Patient Search view configuration

Workflow A: Add Clinical Support / RN Registration

Applies to new outpatient (P.LUAR) or group (MNT BERKUMPULAN) cases that require a valid sequential Registration Number (RN) generated beforehand.

1. Open the extension and change the target sheet name to P.LUAR or MNT BERKUMPULAN.
2. Enter the target patient's Row Number.
3. Click the green button: Add Clinical Support (RN Registration).

▶ How does the Automator works

The extension will automatically click "Add Clinical Support", fill in the Date (08:00 AM), generate the RN using your DT Prefix + Sequence, and submit the form.

Automator running registration process

• Self-Healing RN Adjustments: If the portal returns an error indicating the sequence code already exists (rn already exists / telah wujud), the script automatically increments the sequence number (for example, DT10001 → DT10002) and resubmits without interrupting the automation cycle.

Workflow B: Clinical Form Data Entry Automation

Processes complete clinical fields entries directly into the SMRP website

Scenario 1: Outpatient Modules (Individual Records)

1. Verify your extension is targeting the P.LUAR sheet parameter and specify the row number.
2. Click the blue button: Fetch & Fill Clinical Data.

▶ How does the Automator work?

The extension scans for "Sokongan Klinikal" and "SSDT" in the RN list, finds the visit row matching your Sheet Date, verifies the patient's IC matches, opens the form, and fills out all clinical data instantly.

Automator filling outpatient forms

Scenario 2: Inpatient Modules (Ward Records)

1. Change your configuration sheet target to P.DALAM and enter the row index.
2. Click the blue button: Fetch & Fill Clinical Data.

▶ How does the Automator works

The extension checks Column Q to ensure the patient is not marked "Unseen". It then scans for "Pesakit Dalam" rows earlier than your seen date in E-Pelaporan, verifies the patient's IC, and fills the clinical form.

Automator filling inpatient forms

Scenario 3: Group Counseling Modules (Classes Records)

1. Change your configuration sheet target to MNT BERKUMPULAN and enter the row index.
2. Click the blue button: Fetch & Fill Clinical Data.

▶ How does the Automator works

The extension finds the correct date row, verifies the IC, auto-sets "Consultation Type" to "Kumpulan / Kelas", and fills the rest of the form automatically.

Automator filling group forms

6. Troubleshooting Guide

Navigation & Safety Errors

Error / Symptom	Solution
Popup: "❌ IC Mismatch Guard!"	The IC number in your Google Sheet does not match the patient currently open in the MyHDW Portal. Verify you are on the correct patient's file. If the portal is genuinely missing the IC, you can bypass this by unchecking the Strict IC Match Guard in settings. Figure 6.0: IC Mismatch Guard Alert
Popup: "⏸️ The data in row is Unseen..."	Column Q in the P.DALAM sheet is marked as "True". The automator safely aborted to prevent filling out a blank form. Figure 6.1: Unseen Patient Bypass Alert
Popup: "No Inpatient Visit found earlier than ...... Check portal dates."	1. Check Dates: Ensure Sheet date matches Portal. 2. Expand View: Scroll down in SMRP and change items per page to All or 20 or Toggle the "Enable Auto-Expand Grid" option under setting. Figure 6.2: Expanding items per page in SMRP 3. Not Registered as Inpatient: If the error persists even after changing the items per page setting to 'All', it means the hospital registry didn't register this patient as 'Pesakit Dalam'. You are required to create an RN using the "Start Outpatient Registration" button. After creating the RN, toggle the "Inpatient: Data Entry Under "Sokongan Klinikal"" option, then click the "Fetch & Fill Clinical Data" button. Figure 6.3: Manually registering and entering Dietetic page
"⏳ Timeout: MyHDW Portal took too long..."	The portal took longer than 15 seconds to load the form. Refresh the portal page and try clicking the extension button again. Figure 6.4: Timeout Safety Alert

Data & Connection Errors

Error / Symptom	Solution
"Auth Failed" / Connection Failed	You authorized the wrong Google account. Click Sign Out button in the extension, then click Test Connection and select your @moh.gov.my email. Figure 6.5: Connection Failed Error

7. View Modes

You can customize how the extension appears on your screen.

Option A: Sidebar Mode (Recommended)

Best for continuous data entry. The panel stays open while you navigate.

1. Right-click the SMRP Automator icon.
2. Check "Open in Side Panel".
3. Click the icon to open the persistent side panel.

Figure 7.0: Sidebar Mode

Option B: Popup Mode (Default)

Best for quick, single-use actions.

1. Right-click the extension icon.
2. Uncheck "Open in Side Panel".
3. Click the icon to open as a floating window.

Figure 7.1: Popup Mode

9. Google Sheet Configuration

The automation is tailored according to the E-Pelaporan Google Sheet Layout. Based on the Sheet Name selected, the extension will read data from the following specific columns:

A. Inpatient Data (Sheet: P.DALAM)

• The extension reads data from Columns: C, E, G, H, J, K, L, M, O, Q

B. Outpatient Data (Sheet: P.LUAR)

• The extension reads data from Columns: B, C, E, F, G, H, I, K, N

C. Group Counseling Data (Sheet: MNT BERKUMPULAN)

• The extension reads data from Columns: B, D, E, F, H

10. Data Mapping Logic

The Automator uses a "Mapping Engine" to translate your Google Sheet terminology into the specific clinical categories required by the MyHDW portal.

A. Discipline Mapping

B. Diet Type Mapping

C. Specific Diet Codes

Multiple codes can be entered in one cell (e.g., DD, LSD).

D. Referral Source: Outpatient Clinic

11. Multi-Row Automation User Manual

This manual guides you step-by-step through operating the multi-row data entry system safely and efficiently.

🚀 1: Starting the Automatic Typing Sequence

Follow these simple clicks to hand your data-entry workload over to the bot:

1. Set the Starting Points: Type the row number where you want to begin into the Start Row box, and your final row number into the End Row box.
2. Launch the Tool: Click the orange Run Multi-Row Automation Button.
3. Let the bot work on its own: The bot will automatically open tabs, navigate pages, and type out your records. For it to work correctly, the SMRP Page must remain visible and active on your monitor screen. Do not minimize the window or switch to other Google Chrome tabs while the bot is running.

👁️ 2: Monitoring the Bot While It Works

You can watch the bot enter information in real-time right on your screen:

• Helpful colored status panels will display at the top of your web browser to show you exactly which row number the bot is currently typing out.
• Automatic Number Tracking: You do not need to keep track of case registration sequence numbers when using the automated system. The bot updates them by itself based on your record dates:
  • Same Date: If multiple patients share the same date, the bot counts upward step-by-step (such as 001, then 002, then 003).
  • New Date: The moment the bot reaches a row containing a new date, it drops the counter back to 001 for that new day automatically.

🛑 3: Using the Emergency Stop Button

If the SMRP page slows down, freezes for more than 35 seconds, or you need to take back control of your computer immediately, you can stop the bot safely at any time:

• Click the Kill Switch: Click the red STOP AUTOMATION Button inside the extension panel to halt the automated typing process instantly.
• Your Progress is Safe: Stopping the bot will never cause you to lose completed records. It immediately saves your position and locks in all rows that were successfully submitted up to that exact second.

Figure 11.1: Location of the Stop Automation button

📊 4: Reading the Final Success Report

Once the bot finishes typing out your list, it will show a summary of your session:

• Review the Logs Tab: Open the Activity Logs panel at the end of a run to check your results. It shows you exactly how many entries succeeded, along with a breakdown of rows that were skipped or encountered an error.
• Automatic Security Clean-up: To keep patient files private and secure, all temporary records held in the tool's volatile memory are permanently deleted the absolute moment you close your Google Chrome browser window.

Figure 11.2: Viewing row success logs inside the Activity History panel

🔄 5: Using the "Retry These Rows" Button

If a batch run completes and a few rows were skipped or failed due to network lag, you do not have to look up the missing patients or type their files manually!

• Targeted Error Recovery: Look directly at the Logs tab inside the helper window. You will find a button labeled Retry These Rows located directly under the "Action Required: Unresolved Row Failures" section.
• How It Works: When clicked, the tool scans the session logs, isolates only the rows that ran into issues, and rerun only the failed rows. Note: you are not require to manually type the failed row number.
• Protects Data and Saves Time: The bot automatically passes over any rows that were already completed successfully.

📋 6: Troubleshooting & Error Guide

While running multi-row automation, the bot might skip a row if it runs into an issue with the data or the SMRP Page. Below is the complete list of every error message you might see in your logs, why it happened, and exactly how to fix it: