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

# CategoryType Import (Type 3)

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

## Overview

CategoryType Import loads category type 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 `CommonConvEntityType` table for your institution.

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

![Google Sheet 1](https://mintcdn.com/neuroncx/AFalqsHve-0PrBW0/images/google_sheet-1.png?fit=max\&auto=format\&n=AFalqsHve-0PrBW0\&q=85\&s=2564c76e9e368fd3aab4baa0c3f613f1)

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

**2. Click + Import**

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

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

**3. Give it a label**

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

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

**4. Add the Google Sheet ID**

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

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

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

**6. Select the import type**

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

![Category Type](https://mintcdn.com/neuroncx/AFalqsHve-0PrBW0/images/category_type.png?fit=max\&auto=format\&n=AFalqsHve-0PrBW0\&q=85\&s=6a7f5d7049d449b549f9dc591b3a36fe)

**7. Create the import**

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

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

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