# PushIt — CSV Data Source Guide

## Overview

The CSV data source lets you load room data from a comma-separated values (`.csv`) file stored on your local machine or a network path. This is the simplest data source option and requires no credentials or network connection beyond file access.

---

## Accessing the CSV Configuration

1. In the main PushIt window, click **⚙ Settings** in the header banner.
2. The Settings view opens. In the **Data Source** dropdown, select **CSV**.
3. The CSV configuration panel appears below the dropdown.

---

## CSV Configuration Panel

The panel contains a single file path field.

| Control | Description |
|---|---|
| Path to SoA label | Identifies the field as the path to your Schedule of Accommodation CSV file |
| File path text box | Displays the currently selected file path. You can type or paste a path directly, or use the Browse button |
| Browse button | Opens a file picker dialog filtered to `.csv` files |

### Entering a File Path

**Option A — Browse:**
1. Click **Browse**.
2. Navigate to your CSV file in the file picker dialog.
3. Select the file and click **Open**.
4. The file path populates automatically in the text box.

**Option B — Type directly:**
1. Click in the file path text box.
2. Type or paste the full path to your CSV file (e.g., `C:\Projects\Hospital\SoA.csv`).

The path is validated in real time as you type.

---

## Validation

The file path field enforces three rules:

| Rule | Error message behaviour |
|---|---|
| Field must not be empty | Error shown if the field is blank |
| File must exist at the specified path | Error shown if the path points to a non-existent location |
| File must have a `.csv` extension | Error shown if a different file type is selected |

Validation errors appear as red text directly below the file path field. While any error is present, the **Load Data** button in the Settings view remains disabled.

---

## CSV File Requirements

PushIt reads column headers from the first row of the CSV. Each header becomes a column in the mock rooms grid. Ensure your file meets the following requirements:

- The file must be saved with a `.csv` extension.
- The first row must contain column headers.
- One column must contain the room ID values that correspond to mock room identifiers in your Revit model.
- The file must be accessible (not locked by another application such as Microsoft Excel).

> **Tip:** If the file is open in Excel, close it before clicking **Load Data** to avoid file-locking errors.

---

## Loading Data

Once a valid file path is entered:

1. Click **Load Data** at the bottom of the Settings view.
2. PushIt reads the CSV, populates the mock rooms grid with one row per data row in the file, and returns to the main window.
3. Column headers from the CSV are added as dynamic columns in the grid.

The file path setting is saved automatically when the PushIt window is closed, so the same file is pre-selected the next time you open PushIt.

---

## Typical CSV Setup Workflow

1. Click **⚙ Settings** in the main window header.
2. Select **CSV** in the Data Source dropdown.
3. Click **Browse** and select your Schedule of Accommodation CSV file, or type the path directly into the text box.
4. Confirm that no validation errors appear below the path field.
5. Click **Load Data** at the bottom of the Settings view.
6. Review the mock rooms grid — each row from the CSV appears as an entry with the Count column reflecting matches in the current Revit document.