How to Resolve Errors for Online Giving File Imports

When you import a contribution and pledge file into ParishSOFT Offering, you may receive an error message. A problem in the file can prevent it from being imported. This topic shows you how to resolve common error messages.


Common Import Errors

If the system cannot import the file, it issues a message. If one of these messages or warnings is displayed, follow the suggestions in the Corrective Action column to resolve the issue.

 

Message

Corrective Action

The file exceeds maximum file size limit of 2 MB.

The maximum size of the import file is limited to 2 MB. To resolve this issue, go back to Online Giving and export the file with fewer records. Then, retry the import.

One method you can use to create a smaller export file is to decrease the number of funds in the file. Another method is to specify a shorter date range.

The file you are trying to import is of an incorrect file type. Please verify the file is correct and retry.

The system recognizes and imports .csv files only.

Make sure that the file ends with .csv as the extension. Then, retry the import.

The file does not contain the standard
export data.

If the file has no data or contains unrecognized elements, such as unreadable characters or columns, the system cannot process it. This issue can occur if the file was edited and the change is unreadable, or if changes took place during processing that caused the file to become corrupted. To resolve this issue, go back to Online Giving and export the file again. Do not edit the contents of the export file. Then, retry the import.

The file you are trying to import belongs to <organization name>. Please verify the file organization ID and retry.

The system cannot accept the file if the organization ID in the file you are importing does not match the ID of the organization you are importing the file into. Check that the organization ID in the file matches the organization ID for your organization. Then, retry the import.

You do not have permissions to <number of funds> of the <total number of funds> funds.

This is an information-only message. If you have permissions for at least one fund in the file, the system allows you to proceed with the import, but be aware that the system imports data only for the funds you have permission to access. 

Pledge does not belong to family.

The pledge ID must match a pledge that currently exists for a family. If the envelope number or sdiocesan ID in the contribution record does not match the envelope number or sdiocesan ID in the pledge record, the contribution is rejected and this message is displayed. Make sure the envelope number or sdiocesan IDs in both records match. Then, retry the import.

<number of funds> of the <total number of funds> are not enabled for import. Any data for <number of funds> will not be imported.

If at least one fund in the file is enabled for import, the system allows you to import the file, but be aware that the system imports data only enabled funds. If you need instructions on how to enable a fund for import, go to How to Enable a Fund for Import. After you enable the funds in the file for import, retry the import.

Export Report

After an import, the system generates an export report summarizing which records failed and succeeded. To download the report, select the CSV or PDF link in The last import occurred on section. Failed records are listed in the report along with a message describing the problem. Consult the table below for corrective actions.

 

Message

Corrective Action

Fund requires pledges

The fund that the contribution is being imported into accepts pledges only. Remove any contribution records from the file and re-import the file.

Invalid or nonexistent family envelope number.

The family envelope number associated with the pledge or contribution record does not exist in the ParishSOFT system. Go back to the Online Giving application, correct the family envelope number, and then re-export the file.

Invalid or nonexistent fund ID

The fund ID associated with the contribution record does not exist in the ParishSOFT system. Go back to the Online Giving application and fix the fund ID. Then re-export the file.

Insufficient Fund Permissions

The user does not have the appropriate permissions to the ParishSOFT fund into which he or she is trying to import contribution records. Contact your administrator to obtain the required fund permissions.

Duplicate Contribution Records

The contribution external contribution ID already exists in the ParishSOFT system. The system probably imported the duplicate record. You can either leave the duplicate record in your system (not recommended) or display the Contribution List page, locate the duplicate record, and delete it.

 

Related Topics

<Back to top>