Universal Import - How to resolve errors when running a Universal Import
When running a Universal Import, you may encounter errors if the data in your spreadsheet doesn’t match what is required in your database (e.g. if mandatory fields are missing data, or if dates in your spreadsheet are formatted incorrectly).
If any errors are found when running your Universal Import, Sumac will produce an error file that tells you exactly what went wrong and how to fix it. Simply upload your .csv file, and if there are any errors, Sumac prompts you to save the error file before proceeding.
You can also open the error file from the Sumac window:
Each row of information that could not be imported will be displayed in the file. The very last column will give you a description of the error for that row. You can correct the error directly in the file, save your corrections, and run the Universal Import again to complete your import, using the same file.
Our products got an upgrade!
Some screenshots and help videos have been made using older versions of our products. Though your version's colours and themes may appear different than what you see here, the instructions, links and advice in this article are still accurate and useful!
Related Articles
Universal Import - How to create a new Universal Import Template
Sumac's Universal Import tool allows users to create their own Import Template to quickly import data from external applications. For example, If you use an external online donation collection tool (e.g. PayPal), you can download a report generated ...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 ...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 Video: Import Donations (8:50)
Script: https://sumac.com/assetswp/training-docs/Import%20Donations.pdf If you plan on importing donations 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 ...How-to Video: Import Data – Donations (8:50)
Script: https://sumac.com/assetswp/training-docs/Import%20Donations.pdf If you plan on importing donations 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 ...
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.