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

# ProductLine (Type 2)

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

## Overview

ProductLine Import loads product line 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 the records already set up for your institution in the `InstitutionProductLine` table.

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

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

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

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

**3. Give it a label**

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

![Import Label](https://mintcdn.com/neuroncx/AFalqsHve-0PrBW0/images/import_label.png?fit=max\&auto=format\&n=AFalqsHve-0PrBW0\&q=85\&s=022eae2b44ae853ff7560e2fa17ed3b3)

**4. Add the Google Sheet ID**

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

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

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

**6. Select the import type**

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

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

**7. Create the import**

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

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

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

![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.

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 `InstitutionProductLine` for your institution — rows with unrecognised IDs are skipped.
* This import does not create new product line 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.