> ## Documentation Index
> Fetch the complete documentation index at: https://support.visualcare.com.au/llms.txt
> Use this file to discover all available pages before exploring further.

# Data and CSV errors

> Common errors when importing or exporting CSV files and data in Visualcare, and how to fix them

This page covers errors that appear when importing or exporting CSV files, saving notes, or working with data in Visualcare.

## CSV import errors

### Issue: "Service Id column is missing" during bulk update services

**Symptoms:** Visualcare shows "Service Id column is missing" when you upload a bulk update services CSV.

**Cause:** The Service Id column has been deleted or renamed in the file, or the file was saved in the wrong CSV format (UTF-8, Macintosh, or MS-DOS encoding instead of standard comma-delimited).

**Fix:**

1. Open the CSV file in your spreadsheet application
2. Confirm the **Service Id** column is present and hasn't been renamed or removed
3. Save the file using **File** → **Save As** and select **CSV (Comma delimited)** as the file type
4. Re-upload the file

***

### Issue: "Column must contain a numeric character" during bulk update services

**Symptoms:** Visualcare shows "Column must contain a numeric character" when importing a bulk update services CSV.

**Cause:** The **Pay Rate** or **Charge Rate** column contains non-numeric values, such as text, currency symbols, or blank cells.

**Fix:**

1. Open the CSV file and locate the **Pay Rate** and **Charge Rate** columns
2. Remove any text, symbols, or blank cells - every row needs a valid number
3. Save the file as **CSV (Comma delimited)**
4. Re-upload the file

***

### Issue: Import gets stuck at 100% during bulk update services

**Symptoms:** The bulk update services import appears to complete (reaching 100%) but doesn't finish processing or apply the changes.

**Cause:** Special characters in the **Service Code** or **Service Description** fields are causing the import to stall.

**Fix:**

1. Open the CSV file and review the **Service Code** and **Service Description** columns
2. Remove any special characters (for example, symbols like @, #, %, &, accented letters, or brackets)
3. Save the file as **CSV (Comma delimited)**
4. Re-upload the cleaned file

***

### Issue: Lines missing after importing expenses CSV

**Symptoms:** After uploading an expenses CSV, some rows don't appear in Visualcare.

**Cause:** Special or unusual characters in the **Description** or other text fields prevent those rows from being processed.

**Fix:**

1. Open the CSV file and review the **Description** column and any other text fields for unusual characters (for example, ®, accented letters, or characters that don't display correctly)
2. Remove or replace any invalid characters with plain text equivalents
3. Save the file and re-upload the cleaned CSV

***

## Export errors

### Issue: Garbled text on the Export Reimbursements page

**Symptoms:** The **Export Reimbursements** page displays garbled or unreadable text when you open it.

**Cause:** Browser cache is interfering with how the page loads.

**Fix:**

1. Press **Ctrl + Shift + Delete** to open your browser's clear browsing data tool (works in Chrome and Edge)
2. Set the time range to **All time**
3. Untick **Browsing history**
4. Tick **Cookies and other site data** and **Cached images and files**
5. Click **Clear data**
6. Fully close the browser, reopen it, and navigate back to the **Export Reimbursements** page

***

### Issue: "FAIL null" error when exporting First Aid Allowances

**Symptoms:** Exporting First Aid Allowances returns a "FAIL null" error.

**Cause:** Too many items are included in a single export. Visualcare doesn't support large batches of First Aid Allowances in one go.

**Fix:**

1. Reduce the date range or filter the export so each batch contains 40 or fewer items
2. Export in multiple batches until all allowances have been exported

***

## Notes errors

### Issue: "Undefined" error when saving a note

**Symptoms:** Visualcare shows an "undefined" error when you try to save a note.

**Cause:** The note contains special characters, a restricted character combination (for example, "system("), or exceeds the character limit.

**Fix:**

1. Remove any special characters from the note - avoid @, #, %, &, (), and accented letters
2. Check whether the note contains the word "system(" and remove it if present - this combination triggers the error
3. Shorten the note if it's very long, as there's a character limit
4. Ensure the note uses plain text throughout
5. Save again

***

## Running into issues?

If your issue isn't listed here, contact the Visualcare helpdesk.

## Related articles

<CardGroup cols={2}>
  <Card title="Import CSV" icon="file-import" href="/operations/import-csv">
    How to import data using CSV files in Visualcare
  </Card>

  <Card title="Service management" icon="list-check" href="/operations/service-management">
    Managing services and service codes in Visualcare
  </Card>

  <Card title="Bulk edit tools" icon="pen-to-square" href="/operations/bulk-edit-tools">
    Using bulk update tools to edit multiple records at once
  </Card>

  <Card title="Client expenses" icon="receipt" href="/client-management/client-expenses">
    Managing and importing client expense records
  </Card>
</CardGroup>