Troubleshooting CSV Import

How to resolve common errors when importing People records.

Randalin Ward avatar
Written by Randalin Ward
Updated yesterday

Need help to figure out why your CSV file won't upload? This support document provides helpful notes to troubleshoot common issues encountered while importing a CSV file of People Records into Text In Church. By following these guidelines, you can ensure a successful import of contact records into Text In Church and avoid potential errors.

  1. Check the CSV file header:

    • Verify that the CSV file includes a header row containing column titles.

    • Ensure that the necessary columns, such as First Name and Last Name, are present.

  2. Separate First Name and Last Name columns:

    • Ensure that the First Name and Last Name data are in separate columns within the CSV file.

    • Verify that the data in these columns is correctly formatted.

  3. Match column titles to Text In Church data fields:

    • When matching column titles to the Text In Church data fields, ensure that each data field is used only once.

    • The "Ignore" data field is the only one that can be assigned to multiple columns.

  4. Toggle Permissions option:

    • When uploading the CSV file, ensure that the Permissions option is toggled on.

    • Failure to enable this option will result in all imported records being opted out of text messaging and email, making it impossible to contact them through Text In Church.

    • If you accidentally import without toggling Permissions on, you can re-import the file and ensure the Permissions option is enabled to update the records and set them as opted in. This process will not create duplicates.

  5. Verify the correct file:

    • Double-check that you are attempting to upload the correct CSV file that contains the desired contact information.

    • Ensure the file is not corrupted or missing any required data.

Contact Support For Additional Errors:

  • If you have followed all the troubleshooting steps and are still encountering errors, please reach out to our Member Experience team via chat or email support@textinchurch.com for further assistance.

  • Please include any error messages received, helpful details, and a copy of the CSV file you are working with.

Did this answer your question?