DIFFCOUNT Configuration Tools
User Guide

The DIFFCOUNT SQL Config Editor is a browser-based tool for editing device configuration SQL backup files. It parses the SQL file into a structured interface, allows changes to users, modes, channels, and device settings, then re-exports a modified SQL file ready to load back onto the device.

The editor can modify user accounts, count modes and their channel assignments, channel name labels, Quick Select shortcuts, Quick Launch settings, and ABS name lists.

Importing a SQL Config File

1. 01

   Click ⬆ Import SQL in the toolbar. A file picker opens.

2. 02

   Select the .sql backup file exported from your DIFFCOUNT device.

3. 03

   The tool parses the file and populates all tabs. The toolbar status indicator turns green and shows the filename when the import is successful.

Toolbar at a Glance

The Users tab manages the operator accounts stored on the device. Each user has a name and an associated access level that determines which modes they can run.

Adding and Editing Users

1. 01

   Click + New to add a user. The new entry appears selected in the list.

2. 02

   Edit the user's name and properties in the User Properties panel on the right.

3. 03

   Changes apply immediately to the in-memory config. Nothing is written to disk until you click ⬇ Export SQL.

Duplicating and Deleting

Hover over any user to reveal the ⧉ Duplicate and ✕ Del buttons, or use the buttons in the card header when a user is selected. Deleted users move to the Recycle Bin — they can be restored before export.

Reordering

Grab the ⠿ drag handle on the left of any user row and drag it up or down to change display order.

Modes define the counting protocols available on the device. Each mode specifies which channels are active, how the WBC count is handled, NRBC threshold behavior, and printer layout.

Opening the Mode Editor

Click any mode in the list to select it, then double-click (or click + New for a new mode) to open it in the Mode Editor panel on the right.

Mode Editor Fields

Saving

Click Save Mode in the Mode Editor header to commit your changes back to the main config. Unsaved mode changes are not included in the SQL export.

Duplicating and Deleting Modes

Hover any mode in the list to reveal ⧉ Duplicate and ✕ Del. Deleted modes go to the Recycle Bin. Drag the ⠿ handle to reorder.

The Channels tab manages the display name labels assigned to each counting channel on the device. These names appear on the DIFFCOUNT screen and on printed reports.

Editing Channel Names

1. 01

   Click a channel in the list. Its properties appear in the Channel Properties panel on the right.

2. 02

   Edit the name field. Changes apply immediately to the in-memory config.

Adding, Duplicating, and Deleting

Use + New, ⧉ Duplicate, and ✕ Del in the card header. Deleted channels are held in the Recycle Bin for the current session — they are not preserved after closing the browser tab. Drag the ⠿ handle to reorder.

The Other tab contains three configuration areas: Quick Select slots, Quick Launch, and ABS Names.

Quick Select Slots (F1–F5)

Quick Select assigns a user-and-mode combination to each of the device's five function keys (F1–F5). F6 is reserved for COUNT and cannot be reassigned.

For each slot, set the Key label (the name shown on the function key button), then choose the User and Mode from the dropdowns. Slots can be dragged with the ⠿ handle to reorder. Leave a slot's user and mode unset to leave that function key unassigned.

Quick Launch

When enabled, Quick Launch causes the device to skip the home screen on boot and begin counting immediately with the specified user and mode. Toggle the enable switch, then select the target User and Mode from the dropdowns.

ABS Names

ABS Names are the labels used for absolute count reporting. Use + New, ⧉ Duplicate, and ✕ Del to manage the list. Click any name to edit it in the properties panel. Drag the ⠿ handle to reorder.

Deleted users and modes are moved to the Recycle Bin rather than being permanently removed immediately. This allows you to restore an item if you change your mind before exporting.

Restoring Items

Click the ♻ Recycle Bin tab, or expand the Recycle Bin section within the Users or Modes tab. Click Restore next to any item to return it to the active list.

Permanently Deleting

Click Delete next to a recycled item to remove it permanently from the session. This cannot be undone with Undo — the item is gone.

Channels and ABS Names

Deleted channels and ABS names appear in the Recycle Bin tab but are held for the current session only — they are not written to the exported SQL and will be lost if you close the browser tab without restoring them.

The editor maintains a full change history for the current session. There are two independent undo systems:

1. 01

   Click ⬇ Export SQL in the toolbar. The button is only enabled after a SQL file has been imported.

2. 02

   The tool validates the config before exporting. If any issues are found (blank mode names, missing Quick Select aliases, etc.) an error toast appears describing the problem — resolve it before retrying.

3. 03

   A .sql file is downloaded with _modified appended to the original filename, e.g. modulusdata_backup_modified.sql.

Once you have exported your edited configuration, follow these steps to load it back onto your DIFFCOUNT.

1. 01

   Rename the exported file back to its original name by removing the _modified suffix the editor added — i.e. rename modulusdata_backup_modified.sql to modulusdata_backup.sql.

2. 02

   Copy the renamed configuration file to a USB drive.

1. 03

   Insert the USB drive into the back of your DIFFCOUNT.

2. 04

   Under the settings menu accessed from the HOME screen (top left) select IMPORT/EXPORT.

3. 05

   Select USER/MODE IMPORT. The screen will let you know when the import of your configuration is complete.

The Comment Database Editor allows you to build and modify the comment table used by the DIFFCOUNT during differential counting. Comments are organized in a three-level hierarchy: Groups → Descriptors → Quantifiers. The finished database is exported as an .xlsx file and loaded onto the device via USB.

The Comments tab is divided into five zones. The diagram below shows each area and its function using a real example from the database: RBC Morphology → Poikilocytosis → 4+. Panels resize by dragging the ⠿ dividers between them.

Fig. 1 — Comment Database Editor interface annotated (example: RBC Morphology → Poikilocytosis → 4+). Drag ⠿ handles between panels to resize columns.

The browse tray expands below the Descriptors or Quantifiers panel to show items from other groups for copying (see Browsing & Copying).

The database uses a strict three-level hierarchy. Navigate by clicking left to right across the panels:

Resizing Panels

Drag the ⠿ grab handles between panels to resize them. Panels scale proportionally when the browser window is resized, and manual adjustments are preserved within the session.

Select any Group, Descriptor, or Quantifier to edit it in the Properties panel (D).

Adding Items

Click + Add in any panel header. A new blank item appears at the bottom of the list, selected and ready to name in the Properties panel. The Descriptors and Quantifiers buttons are only enabled once a parent item is selected.

Duplicating Items

Hover over any item to reveal the ⎘ duplicate button. The copy is inserted directly below the original, including all nested items.

Deleting Items

Hover over any item and click ✕. Deletion is immediate — use Ctrl Z to undo.

Reordering Items

Grab the ⠿ drag handle on the left of any item and drag it up or down. The exported file reflects the display order exactly, with all D and Q numbers reassigned sequentially.

Both the Descriptors and Quantifiers panels include a browse tray — a quick way to reuse existing entries from elsewhere in the database without re-typing them.

1. 01

   With a Group or Descriptor selected, click the ▲ Browse button at the bottom of the Descriptors or Quantifiers panel.

2. 02

   The tray expands showing all available items from other groups/descriptors, deduplicated by name. Use the filter box to search.

3. 03

   Click + Copy to duplicate the item into the active group or descriptor. Items already present are shown greyed with a ✓.

1. 01

   Click ⬇ Export XLSX in the toolbar.

2. 02

   A Save As dialog opens (Chrome/Edge) with the original filename pre-filled. Choose your save location and confirm. On Firefox/Safari the file downloads to your default downloads folder.

3. 03

   The exported file is a fully compatible .xlsx spreadsheet.

Once you have exported your edited comment table database, follow these steps to load it onto your DIFFCOUNT.

1. 01

   Copy the edited and exported comment table database to a USB drive.

1. 02

   Insert the USB drive into the back of your DIFFCOUNT.

2. 03

   Under the settings menu accessed from the HOME screen (top left) select IMPORT/EXPORT.

3. 04

   Select COMMENT IMPORT. The screen will let you know when the import of your new comment table database is complete.