Product: ImportOmatic
Description: This solution describes how to resolve the error: Error: Action Must be Completed Before a Completed Date is Set
Environment: All
Version: 3.0 and above

Answer:

There are two options for resolution: 


1. Add a column to the data file and populate it with a value of "Yes" for every applicable row. This column must also be added to the IOM profile. You will map the Raiser's Edge Field in the profile as Action > Completed. 


OR


2. Add this field as a virtual field and use a function of "Static Field". For mapping, the Virtual Field will be populated with a value of "Yes" and 

the Raiser's Edge Field is mapped as Action > Completed. 


(virtual field option shown below) 

image