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:- Open the CSV file in your spreadsheet application
- Confirm the Service Id column is present and hasn’t been renamed or removed
- Save the file using File → Save As and select CSV (Comma delimited) as the file type
- 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:- Open the CSV file and locate the Pay Rate and Charge Rate columns
- Remove any text, symbols, or blank cells - every row needs a valid number
- Save the file as CSV (Comma delimited)
- 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:- Open the CSV file and review the Service Code and Service Description columns
- Remove any special characters (for example, symbols like @, #, %, &, accented letters, or brackets)
- Save the file as CSV (Comma delimited)
- 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:- 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)
- Remove or replace any invalid characters with plain text equivalents
- 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:- Press Ctrl + Shift + Delete to open your browser’s clear browsing data tool (works in Chrome and Edge)
- Set the time range to All time
- Untick Browsing history
- Tick Cookies and other site data and Cached images and files
- Click Clear data
- 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:- Reduce the date range or filter the export so each batch contains 40 or fewer items
- 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:- Remove any special characters from the note - avoid @, #, %, &, (), and accented letters
- Check whether the note contains the word “system(” and remove it if present - this combination triggers the error
- Shorten the note if it’s very long, as there’s a character limit
- Ensure the note uses plain text throughout
- Save again
Running into issues?
If your issue isn’t listed here, contact the Visualcare helpdesk.Related articles
Import CSV
How to import data using CSV files in Visualcare
Service management
Managing services and service codes in Visualcare
Bulk edit tools
Using bulk update tools to edit multiple records at once
Client expenses
Managing and importing client expense records
