Import Utility: Importing Individual Contacts Part VIII - Review
- After your import batch finishes processing, you will receive an e-mail notifying you that your import failed, was completed successfully, or had errors that will need to be reviewed & corrected. You will also see the batch status on the Import Utility index screen.
- If your batch failed (status = "Process Failed") this means there was a "catastrophic" issue with your data file that prevented it from being processed. The most common causes of import failure are:
- failure to delete the instructional row from the data file before uploading it
- inclusion of commas in any amount or numeric fields
- unexpected characters/symbols (especially in numeric fields or text only fields such as name fields)
- hard returns within cells (entering data on multiple separate lines within one cell)
- blank rows/lines in the data set.
- not following formatting instructions for Address Country
Review your data file to see if you can identify the issue and then try importing it again (you will need to create a new import batch). If you cannot identify the cause, send your data file to support@fundly.com for review.
- If your batch was successful (status = "Processing Completed"), on the Import Utility Index Screen, it is a good idea (and strongly encouraged) that you check the records over to make sure there are no issues.
- Click the drop down to the right of the batch name and select Review Records to bring up a list of the imported records so you can check them for accuracy.
- This will bring up the list of the records that were imported (the contact search results screen filtered by your batch name) (you can also manually search for your imported records using Advanced Search on the "Imports" category).
- Review the records (view or edit individual records) to make sure that all information imported correctly; if you have a large batch, check a representative sample (10-20 records for a moderately sized batch, 20-50 records for larger batches). Check that name, address, householding, etc., have imported correctly.
- In the screen shot below, you'll notice that Arthur Fonzarelli, Charles Cunningham, and Richie Cunningham are not showing a mailing address even though a partial address was included in the data file for each. However, because the required address part (address line 1) was not included, the other fields were ignored. So sometimes the import will proceed and will appear to be okay on the surface, but the data will not be imported in the way that you expect or data might be dropped because it does not pass validation. The verification step is critically important for ensuring that all data came through in the correct way.
- Additionally, verify the number of records in your system before and after import and use quick search on a handful of the imported contact records/names to verify that your import did not create unexpected duplicate records.
- If you are unsure as to why data ended up in a certain field or why duplicates were created or why records improperly matched to and updated the wrong existing records, you can view the field mapping and duplicate prevention settings you used in the import from the drop down to the right of the batch on the Import Index Screen.
- You can "back out"/delete the imported records by doing an Advanced Search for the records and then using the take action menu at the bottom of the search results screen to delete all of the records. You can search by batch name using the Imports category in advanced search. We strongly recommend using not only the batch name but also the "Created On" field in the Contact Information category as a filter/identifier to ensure you are only finding and deleting records CREATED during import and not also deleting existing records that were UPDATED during the import. If you delete existing records that were updated incorrectly (as in the example in the Part II tutorial of the client who improperly sorted the data in their data file and then imported the wrong data to contact records), you'll lose not only the import data but all data that existed before you conducted the import (such as donation and event attendance data).
- If you find that something has gone awry with your import, contact CRM support immediately. We cannot restore individual records to their pre-import state; instead, we can restore your entire database back to a point before the import. That means you'll lose any data entered after that point (in any part of the system, including any online transactions that took place after that point, any records entered by staff, or any data entered via a third-party sync such as Donor Search, Mail Chimp, and Fundly Connect) - this is why it's imperative to contact us immediately to avoid losing large amounts of post-import data. Having us delete imported records or restore your system to a point prior to the import are chargeable services.
- If your import processed but the status is "Validation Completed - [#] Errors", this indicates that some of your data processed successfully and some rows returned with validation errors.
- This happens when there are non-catastrophic data issues (that is, the file is able to proceed, some of the rows saved successfully, but there are errors in individual records instead of with the overall file).
- Your initial batch will have split into two batches: one with all the rows that have processed successfully (see instructions for Status = "Process Completed"). (Batch 1) will have been added to the title of the batch that processed successfully, while the batch with validation errors will have (Batch 2) added to the title.
- In the email you received notifying you that your batch has partially processed, you'll find a CSV file that includes all rows with validation errors. This file ONLY includes fields that were mapped; any columns you skipped in your initial field mapping will not be included in this file.
- To fix the errors and finish the import, click the drop down to the right of the batch name and select either Review to see the issues and fix them one at a time or upload a new file. You may also select Delete to delete the entire batch. If you choose to upload a new file or delete the batch and start over again, DO NOT re-import your original file but instead use the file you received in the notification when the batch failed. If you re-upload or re-import your original file without removing the rows that have already processed, you may create duplicates.
- After clicking Review, you will be taken to the Validation Error Overview screen. This screen will display the various categories/types of errors in the left hand column, a description of the issue in the middle column, and the number of records with this type of error in the far right hand column.
- To correct the records/issues one at a time, click the Edit invalid/missing records button in the lower right. If, instead of correcting the records one at a time, you wish to fix the issues in your data file and re-upload the file, click the Upload a New File Button instead (skip down to the "Upload a New File" step below).
- When correcting records one at a time, the first record that has an issue will display. The top of the screen will explain what the issue is. In the example below, we included an Organization Name (employer information) but left the "Consider as Organization Contact" field (which is required when including an organization name in the work info section) blank in the data file. The system is telling us we must enter a value in that field. Make the correction and then click the blue Save & Next button in the lower right. This will take you to the next record that needs to be corrected. Repeat this step until you have corrected all of the records with errors.
- Once you reach the end of the list of records with issues, you will receive a message that all records have been updated. Click the blue Re-Validate & Import button in the lower right corner.
- You will be taken back to the Import Utility index screen and you will receive the green validation message that your file has been sent for processing. The status will once again show as "importing data." Once the import completes, you will receive an email with the status. Repeat the steps in this tutorial based on what the new status ends up being.
- Uploading a New File: Sometimes, when there is a large number of errors in an import, it's easier to fix the issues in the data file rather than the import utility. For example, perhaps you forgot to include values in the Organization is Contact field for many organizations listed in the Work Info. It may be easier to, in Excel, sort by rows that have an Organization Name but no data in Organization is Contact and enter the data there rather than typing in TRUE/FALSE for each record. Or you may have included information that can't be fixed by correcting the errors one at a time. In the second example below, we've attempted to add a contact type to records that can't be added manually (School is a system automatic contact type that can only be added by the system). In these cases, on the "Review" screen, choose the option to Upload a New File.
- As mentioned above, make sure you are uploading the file you received in the notification that your batch failed rather than your original file. Re-uploading your original file without removing rows that already processed successfully may create duplicates, depending on the data.
- This will take you back into the import utility Tab #2: Upload the File. Make corrections to your file, upload the corrected file, and complete the rest of the import utility steps as usual.
Comments
0 comments
Article is closed for comments.