error-in-imports

Scenario 1

During the import; when you choose:

                 a.    Add new records and make updates to existing records

                 b.    Update only empty Maximizer fields with data from the import file

This will result in the error Opportunity -> The row did not cause an update because there is no existing record that matches the duplicate check.

Scenario 2  

During the import process when you choose:

                 a.    Only update existing Maximizer records with new data from the import file

                 b.    Update only empty Maximizer records with data from the import file

This will result in the error Company -> Inserting to the database failed.  The error returned from Maximizer.Web.Data is AbEntry: failed to create AbEntry. Maximizer.Data message: Unable to perform an operation without the setting of a mandatory field.

The Resolution

In the import process; there any many variations that can cause an error. The resolution comes down to:

1. Matching the basic fields.
2. Any additional fields that need to be matched must be stated as Don’t Import on the destination in Maximizer fields.
3. Clarifying the exact data that will determine the type of entry type; lead; opportunity or account.
4. Ensuring the numeric values are not combined with alphabetic values (ex. "CAD 100.00" will result in an error).
5. Making sure to not leave blank fields on the spreadsheet.