Troubleshooting Missing Data in Returned Files

Created by Matthew V, Modified on Wed, 8 Jan at 9:30 AM by Matthew V

If you experience a returned file with missing data, follow these steps to ensure the issue is identified and resolved efficiently:

Verify the Source File
- Confirm that the source file contains all the necessary data before submission. Missing or incomplete data in the source file will result in corresponding gaps in the returned file.
Check for Formatting Issues
- Review the file for improperly quoted fields. Misaligned or missing quotation marks in CSV files can cause data misinterpretation.
- Ensure the file adheres to proper CSV formatting standards, such as using the correct delimiter (e.g., commas), fields are properly quoted, and avoiding unnecessary spaces or special characters.
Validate the Header Row
- Ensure the file includes a valid header row. The header row should clearly define column names, such as:
  - Email
  - FName (First Name)
  - LName (Last Name)
- Missing or ambiguous headers can prevent the data from being processed correctly.

If this does not resolve your issue, please open a support ticket for more help from our team.

Pro Tip: Use a CSV validator tool to check your file before submission. These tools can quickly identify formatting issues and missing headers, saving time during troubleshooting.