> ## Documentation Index
> Fetch the complete documentation index at: https://docs.neuroncx.in/llms.txt
> Use this file to discover all available pages before exploring further.

# SubCategory Import (Type 6)

> Bulk-import subcategory records into NeuronCx from a Google Sheet using a simple Id and Value format.

## Overview

SubCategory Import loads subcategory records into NeuronCx in bulk from a Google Sheet. It's a legacy import type that uses a fixed two-column format — `Id` and `Value` — and writes directly against records in the `SubCategoryMaster` table for your institution.

Use this import when you need to populate or refresh subcategory values in bulk, without touching any other entity type.

> [!NOTE]
>
> This is a legacy import type. It supports the `Id | Value` format only and does not support attribute columns. If you need to import entity records with additional attribute data, use Trx Attribute Entity Import (Type 11) instead.

***

## Prerequisites

* Your Google Sheet must be shared with edit access so NeuronCx can read from it.
* The sheet must contain exactly two columns: `Id` and `Value`.
* The `Id` values in your sheet must match existing records in the `SubCategoryMaster` table for your institution. This import does not create new subcategory definitions — it only writes values against ones already set up.

***

## Preparing Your Sheet

Your sheet must follow this exact format. NeuronCx will reject or skip rows that don't conform.

| Column | Required | Notes |
| - | - | - |
| `Id` | ✅ Yes | Must match a valid `SubCategoryMaster` ID for your institution |
| `Value` | ✅ Yes | The value to set against that subcategory record |

> [!TIP]
>
> To find the correct IDs for your institution, check the `SubCategoryMaster` table filtered by your `InstitutionId`. Use only IDs that already exist — unrecognised IDs will be skipped.

***

## Running the Import

### Setting up a new import

**1. Open Imports**

Navigate to **Home > Ontology > Attribute Settings & Bulk Edit**, then click the **Imports** tab.

![Imports Tab](https://mintlify.s3.us-west-1.amazonaws.com/neuroncx/images/imports_tab.png)

**2. Click + Import**

Click the **+ Import** button in the top right to open the New Import modal.

![Plus Import Button](https://mintlify.s3.us-west-1.amazonaws.com/neuroncx/images/plus_import_button.png)

**3. Give it a label**

Enter a name that describes this import — for example, "SubCategory Bulk Import."

![Label 4](https://mintcdn.com/neuroncx/_AQBgdbbCYYHf24I/images/label-4.png?fit=max\&auto=format\&n=_AQBgdbbCYYHf24I\&q=85\&s=5d857b4ef5a95063baa9225a0709b3f8)

**4. Add the Google Sheet ID**

Paste the sheet ID or the full Google Sheets URL — NeuronCx will extract the ID automatically.

![Sheet Id](https://mintcdn.com/neuroncx/_AQBgdbbCYYHf24I/images/sheet-id.png?fit=max\&auto=format\&n=_AQBgdbbCYYHf24I\&q=85\&s=4124328fbf31fc4c70596d8508746101)

**5. Verify**

Click **Verify**. NeuronCx confirms it can read the sheet and shows you the row and column count — use this to catch an empty or wrong sheet before continuing.

![Verify 6](https://mintcdn.com/neuroncx/_AQBgdbbCYYHf24I/images/verify-6.png?fit=max\&auto=format\&n=_AQBgdbbCYYHf24I\&q=85\&s=e107d55550f171295677525b71df84fb)

**6. Select the import type**

In the Import type panel on the left, select **Legacy**. Then choose **SubCategory** (`#6`) from the list on the right.

![Import Type 1](https://mintcdn.com/neuroncx/_AQBgdbbCYYHf24I/images/import-type-1.png?fit=max\&auto=format\&n=_AQBgdbbCYYHf24I\&q=85\&s=074801fa590dfa3f9667dd88626d6878)

**7. Create the import**

Click **Create import**. The import now appears in your list under the Legacy category, ready to run.

![Create Import 5](https://mintcdn.com/neuroncx/_AQBgdbbCYYHf24I/images/create_import-5.png?fit=max\&auto=format\&n=_AQBgdbbCYYHf24I\&q=85\&s=e8f0c625d46097d19e7c193c89f2f8d0)

### Running the import

**1. Find the import**

From the Data Import list, locate the import you just created. You can filter by the **Legacy** tag to narrow the list.

**2. Click Import**

Click the arrow icon on the import row to open it, then click **Import** to run it.

***

## Checking the Result

Once the run completes, the history table shows how many rows were read and how many records were updated. Click a run's **Status** to open a detailed breakdown showing which rows succeeded, failed, or were skipped.

> [!TIP]
>
> Re-running the same sheet is safe — it will re-apply values without creating duplicates.

***

## Limits to Keep in Mind

* This import supports the `Id | Value` format only. No additional columns are read or imported.
* The `Id` in each row must match an existing record in `SubCategoryMaster` for your institution — rows with unrecognised IDs are skipped.
* This import does not create new subcategory definitions. All IDs must be set up in the platform before running the import.
* Only one import runs at a time. If another import is already running, this one will queue and wait its turn.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.