> ## 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.

# Category Import (Type 4)

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

## Overview

Category Import loads category 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 `ConnectInstCommonConvEntities` table for your institution.

Use this import when you need to populate or refresh category 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 `ConnectInstCommonConvEntities` table for your institution. This import does not create new category 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 `ConnectInstCommonConvEntities` ID for your institution |
| `Value` | ✅ Yes | The value to set against that category record |

![Category Sheet Format](https://mintlify.s3.us-west-1.amazonaws.com/neuroncx/images/category_sheet_format.png)

> [!TIP]
>
> To find the correct IDs for your institution, check the `ConnectInstCommonConvEntities` table joined against `CommonConvEntitiesMaster` and `CommonConvEntityType`, filtered by your `IId`. 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.

![Import Button 3](https://mintcdn.com/neuroncx/AFalqsHve-0PrBW0/images/import_button-3.png?fit=max\&auto=format\&n=AFalqsHve-0PrBW0\&q=85\&s=33860e8cbac8fb3122bdc76b9c001e69)

**3. Give it a label**

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

![Label 2](https://mintcdn.com/neuroncx/AFalqsHve-0PrBW0/images/label-2.png?fit=max\&auto=format\&n=AFalqsHve-0PrBW0\&q=85\&s=6abb174ad3d491b34cd2b91b1976c96a)

**4. Add the Google Sheet ID**

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

![Sheet Id 2](https://mintcdn.com/neuroncx/AFalqsHve-0PrBW0/images/sheet_id-2.png?fit=max\&auto=format\&n=AFalqsHve-0PrBW0\&q=85\&s=272d57b68a0678b0f6865ded2b7163cb)

**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 4](https://mintcdn.com/neuroncx/AFalqsHve-0PrBW0/images/verify-4.png?fit=max\&auto=format\&n=AFalqsHve-0PrBW0\&q=85\&s=7243e2245798451b030b95d9debbd402)

**6. Select the import type**

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

![Import Type](https://mintcdn.com/neuroncx/AFalqsHve-0PrBW0/images/import-type.png?fit=max\&auto=format\&n=AFalqsHve-0PrBW0\&q=85\&s=5201f7a72d528c0cfc630c2cd724b7e7)

**7. Create the import**

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

![Create Import 3](https://mintcdn.com/neuroncx/AFalqsHve-0PrBW0/images/create_import-3.png?fit=max\&auto=format\&n=AFalqsHve-0PrBW0\&q=85\&s=06e56787d5b219bb1907aa51325901bb)

### 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.

![Import List Legacy Filter](https://mintlify.s3.us-west-1.amazonaws.com/neuroncx/images/import_list_legacy_filter.png)

**2. Click Import**

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

![Import Button](https://mintcdn.com/neuroncx/YQLY19__ssBpkd6m/images/import_button.png?fit=max\&auto=format\&n=YQLY19__ssBpkd6m\&q=85\&s=fc3388fc3482680d5fb36ddb0023d5aa)

***

## 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.

![Category Run History](https://mintlify.s3.us-west-1.amazonaws.com/neuroncx/images/category_run_history.png)

> [!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 `ConnectInstCommonConvEntities` for your institution — rows with unrecognised IDs are skipped.
* This import does not create new category 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.