Product: ImportOmatic
Description: This solution describes how to use dictionaries to skip rows that contain certain values
Environment: All
Version: 3.1 and higher

Answer:

For more information on how to create dictionaries, please see this Knowledgebase solution

A dictionary can be built to skip rows that have certain values. For example, if you would like to skip rows that have $0.00 in gift amount.

  1. In Values to match on, enter the value you would like skipped
  2. In Replacement values, enter the error message you would like to receive
  3. Select Create Exception (Skip Row)



  4. In your profile, apply the dictionary to the field

    In your error file, you will see the error you specified and the data from your file



For more information, please see the ImportOmatic User Guide.