Was this helpful?
Was this helpful?
In this Article
  • Created

Article CSV Export Truncating Long Notes Fields

Summary

When exporting work orders or service reports to CSV format, text entered into Notes fields that exceeds 32,767 characters is being silently truncated, resulting in incomplete data in the exported file.

Symptoms

You may notice this issue if:

  • Exported CSV files contain notes that appear to end abruptly with no closing punctuation or complete thought
  • Comparing the exported data against the original record in FieldPulse reveals that the final portions of lengthy notes are missing
  • Character counts in exported cells consistently stop at or near 32,767
  • No error or warning is displayed during the export process

Affected Versions and Platforms

This behavior has been observed across:

  • FieldPulse Web Application versions 3.1 through 3.2.2
  • All supported browsers (Chrome, Firefox, Safari, Edge)
  • Both standard and custom report exports

Cause

In my experience, this limitation stems from the underlying CSV generation library used by FieldPulse's reporting engine, which enforces a maximum cell length of 32,767 characters to maintain compatibility with older spreadsheet applications, particularly Microsoft Excel. While this was originally implemented as a safeguard, it does not account for modern use cases where technicians may enter extensive diagnostic notes, multi-step repair procedures, or detailed customer interaction logs.

What I typically recommend is understanding that the data itself is not lost in FieldPulse — the full notes remain intact in the database and are visible within the application. The truncation occurs only at the point of CSV generation.

Resolution

There are several approaches to address this depending on your specific needs:

Option 1: Use PDF or Excel Format (Recommended)

For reports containing lengthy notes, I generally advise selecting Excel (.xlsx) or PDF as your export format rather than CSV. These formats do not impose the 32,767 character limitation and will preserve complete notes.

  1. Navigate to Reports > Work Orders (or your desired report)
  2. Click Export
  3. Select Excel (.xlsx) from the format dropdown
  4. Complete the export

Option 2: Split Long Notes Before Export

If CSV format is strictly required for downstream processing, consider establishing a workflow where technicians break lengthy entries into multiple shorter notes or use structured fields for detailed information rather than free-form notes.

Option 3: API Retrieval

For automated integrations where CSV is the expected format, what I typically recommend is retrieving the data via the FieldPulse API, which returns complete field values without truncation. You can then transform this data into your required format using your own tooling.

Workaround

Until a permanent fix is implemented, if you must use CSV exports and cannot switch formats:

  1. Export to Excel (.xlsx) format first
  2. Open in Excel or compatible spreadsheet application
  3. Save or export as CSV from that application

This two-step process preserves the full content because Excel's export handles the conversion differently than FieldPulse's native CSV generator.

Status

This issue has been logged with our engineering team. A fix targeted for release 3.3 will increase or remove the character limit for CSV exports. I will update this article when additional information becomes available.

In the meantime, if you have specific reporting workflows that are blocked by this limitation, please reach out through your normal support channels and reference this article. We want to make sure you're set up for success, and there may be additional configuration options depending on your account setup.