How to import single contact by account number (includes sample data file)

We can use the Single Contact by Account Number import to add Contacts to the Journal of Constituents that already exist in the database.
Required Fields
  • Account Number
  • Contact Method- this must match and existing value in the database; for additional information, please see How to Add a new Contact Method
  • Date
  • Note
  • Subject

What we can include on a Single Contact by Account Number import
  • Contacts for existing Constituents
  • Contact User Defined Fields

What we cannot include on a Single Contact by Account Number import
  • Contacts for people who do not already have a Constituent account in the database
  • Account or Persona information, such as salutations, and email addresses
  • Information about User accounts
  • Relationships
  • Existing Contacts (importing the same information as a previous entry will not update the existing entry, this import can only create new journal entries)

Steps to Import
  1. Click Management
  2. Click Import
  3. Select the category where you'd like to store the import template
  4. Click New Import
  5. Fill in a name for the import template
  6. Click Choose File/Browse Files
  7. Select the CSV file from your computer
  8. Select Single Contact by Account Number from the Type of Information to Import drop down menu
  9. Select your Multi Select Delimiter from the drop down menu; for more information please see What is the function of the Multi Select Delimiter?
  10. Click Next
  11. Click the green arrow icon next to the name of the field
  12. Select the corresponding column from the CSV file
  13. Click the link that says Import Another eTapestry Field at the bottom of the screen to import Contact user defined fields
  14. Click the names of the additional fields you'd like to import
  15. Click the green arrow icon next to the names of these fields
  16. Select the corresponding column from the CSV file
  17. Click Next
  18. Preview the layout of the information
  19. Click Next
  20. Preview the duplicates and select how you would like to handle the information (if there are no duplicates, the database will skip this step
    • Don't Modify Any Account Info (Trust) will not change information or User Defined Fields for the existing account, it will only add the Contact to the Constituent's Journal)
    • Ignore this Line (Ignore) will not import any information from this line in the CSV file to eTapestry
  21. Click Next to run the import
Single Contact by Account No.csv

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.