How to import Contacts
Regardless of the type or source, you can import contacts into your Sumac database. In this example, we'll import new contacts.
Before importing your spreadsheet, it is important to clean up the data. Use Sumac's Import Workspace to do this.
Only certain users are allowed to import data. If you are going to import data, your Sumac administrator must give you the Bulk Import capability in your user profile.
After cleaning up your spreadsheet, click Utilities, Import, and Import.
Indicate that you are importing contacts, and that they are new.
Choose the data file and click OK.
The data file appears on the right-hand side.
You must tell Sumac which contact record fields should hold which data. The left-hand side of the window holds a list of all the fields in contact records. Match field names to data columns by dragging field names and dropping them onto the data columns.
Once all the contact columns have been matched, you must check the data before you can import it. Click “Check Before Import” to tell Sumac to check all the data. Sumac checks every row in every column to make sure that the data is correct.
If something is wrong, perhaps an email address that is incorrectly formatted, Sumac highlights the incorrect cell and puts an error message at the start of the row.
If you encounter multiple records with errors, such as in the example below, fix the data in your original file and start again.
First, save your column choices so that you don't have to map the column choices to the data again. When you import the corrected data you can save some time by clicking Load Column Choices.
After correcting your data, go back to Utilities, Import, and Import. Choose your data file and tell Sumac you are importing Contacts. Then Load Columns.
Alternatively, if there appears to be something wrong with an entire column and that information is not needed in Sumac, you can select the column and click Clear Column Title to tell Sumac to not import that column.
If you encounter errors with a specific record, you can tell Sumac to ignore that row of data in the incoming file.
Then click Import.
Indicate if you would like to record the file of origin for the imported records. If you choose Yes, the name of the original file will be available in the Import File Name column in the Contacts list.
All the contact records are imported into Sumac. They turn from black to green to indicate successful importing.
If you now look at the contacts list, you see that the newly imported contacts have been added to the end of the list.
If you plan on importing on a routine basis, consider using Universal Import! This helpful tool allows you to save your import preferences so that it is quick and easy to import contacts any time. Check out this article to learn more about setting up Universal Import.
Related Articles
How to clean data using Import Workspace
If you have a spreadsheet full of contact information, like names and addresses, you can use Sumac to validate the information before importing. Sumac does not allow you to import incorrect information, so you must clean up and validate the data ...How to add new contacts
To add a new contact to your Sumac database, click Contacts in the main Sumac console window then click New. In the window that opens, enter some basic information about the new contact. You need to first specify whether you are adding a new ...How to enter a new Donation Record
To manually add donations to Sumac, you can either use Add to Contact from the Contact list, or you can use the Donations list. From the Contacts list To add a donation to a Contact from the Contacts list, select the donor and click Add To Contact. ...How to enter a new Pledge
In your Sumac console, expand Fundraising, and choose Pledges. Click New to open a new pledge record. Once the new pledge record opens, select the contact who is making this pledge by clicking the contact icon. The Commitment Date for this pledge is ...What is in a contact record
Contact records store core information for each contact in your database. To open a contact's record, double-click the contact in the Contacts list. You'll notice there are several tabs across the top of the contact record for storing different kinds ...
Societ Academy
Learn what you need to know, any time. Free!
- High quality training on demand - sessions are available every day, so you can access training that fits into your schedule.
- Training sessions that are easy to follow - helpful tips throughout each session, and access to training moderators ensure your questions get answered.
- A certificate of completion - you can request a certificate of completion for every session you attend.