How to import Account Information with a Single Contact (includes sample data file)

We can use the Account Information with a Single Contact import to add single Contact entries to new or existing accounts. In addition to importing the Contact entries, we can also import User Defined Fields on the Contact entry, Account or Personas pages.
Required Fields
  • Account Name
  • Sort Name
  • Last Name (individuals only)
  • Country (all accounts in the CSV file must be from the same country)
  • Persona Type
  • Name Format
  • Date
  • Contact Method- this must match and existing value in the database; for additional information, please see How to Add a new Contact Method
  • Contact Subject
  • Note

What we can include on the Account Information with a Single Contact Import: 
  • New Constituent accounts
  • Updated Persona or account information for existing accounts
  • User Defined Fields stored on the Persona or Constituent pages for new or existing Constituents
  • User Defined Fields stored on Contacts
What we cannot include on the Account Information with a Single Contact Import:
  • Relationships
  • Team, User, or Tribute accounts
  • New Personas
Steps to import:
  1. Click Management
  2. Click Import
  3. Select the category where you'd like to store the import
  4. Click New Import
  5. Enter a name for the import template
  6. Click Browse Files/Choose File
  7. Select the appropriate CSV file for this import
  8. In the Type of Information to Import drop down menu, select Account Information with a Single Contact
  9. Select your preference from the Name Format drop down menu
    • If you have multiple types of Name Formats in your CSV file, select "Map from your import file" and select the appropriate column
    • If you have only one Name Format in your CSV file, assign that Name Format to all accounts
  10. Select the Country from the drop down menu (all accounts in the file must be from the same country)
  11. Select your Multi Select Delimiter from the drop down menu; for more information please see What is the function of the Multi Select Delimiter?
  12. Click Next
  13. Click the green arrow icon next to the name of the field
  14. Select the corresponding column from the CSV file
  15. Repeat for all of the fields in your import file (we will not import fields for Name Format or Country on this page since we did that on the first page)
    • Please note that we can select "Use auto-generated Data Entry Rules" for the Sort Name and Salutations (we can also do this for the Account Name on the Individual names)
  16. Click the link that says Import Another eTapestry Field at the bottom of the screen
  17. Click the names of the additional fields you'd like to import (for example, Email)
  18. Click the green arrow icon next to the names of these fields
  19. Select the corresponding column from the CSV file
  20. Mark the checkboxes for the Import Keys; please see What is the function of the Import Key? for additional information
  21. Click Next
  22. Preview the layout of the information
  23. Click Next
  24. Preview the duplicates and select how you would like to handle the information (if there are no duplicates, the database will skip this step)
    • Only Import Into Empty Fields (Merge) will only add new information from the CSV file, but it will not replace any existing information
    • Don't Modify Any Account Info (Trust) will not change anything on the existing accounts, it will also not add any new information
    • Replace eTapestry Info (Replace) will override the existing information in eTapestry with the information in the CSV file
    • Create New Account (Create) will indicate that these are not duplicate accounts and we should create a new eTapestry account for the information in the CSV file
    • Ignore this Line (Ignore) will not import any information from this line in the CSV file to eTapestry
  25. Click Next
  26. Click Run to process the import
  Account Info with Single Contact.csv

Was this article helpful?