CNFS Offering - Imports: How to resolve errors for contribution imports from non-parishSOFT systems

How to resolve errors for contribution imports from non-parishSOFT systems

This topic lists the error messages you may encounter when importing contributions and provides solutions you can try to fix the problem.


Common Import Errors

Export Report

.

Common Import Errors

If the system cannot import the file, it issues a message. The following table lists the common import errors and provides suggestions for resolving the problem.

 

Message

Corrective Action

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. 

<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 from funds enabled for import.

 

If you need instructions for enabling 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.

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, reduce the number of records in the file. 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, open the file and check to see if there are any odd characters or columns in it. Edit the file and then re-import it.

 

.

Export Report

After an import, the system generates an export report summarizing the problems encountered. To download the report, select the CSV or PDF link in The last import occurred on section. In some cases, even if it encounters a problem, the system will import the record. Consult the table below for corrective actions.

 

Message

Corrective Action

Invalid or nonexistent fund ID

The fund ID associated with the contribution record does not exist in the ConnectNow system. Open the file and correct the fund ID. Retry the import.

Invalid or nonexistent family envelope number

The family envelope number associated with the pledge or contribution record does not exist in the CN system. Open the file and correct the family envelope number. Retry the import.

Insufficient fund permissions

You do not have the appropriate permissions to the ConnectNow fund into which you are trying to import contribution records. Contact your administrator to obtain the required permissions to the fund.

Ext Contribution ID exists. Duplicate record found.

The external contribution ID already exists in the ConnectNow 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.

Missing required field

The contribution record is missing one or more required fields. Open the file and add the missing contribution data.

 

Related Topics

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.