Product: ImportOmatic Connector for Engaging Networks

Description: This solution describes how to export to date fields from The Raisers Edge to Engaging Networks

Environment: All

Versions: All

Answer:

The date format required by the Engaging Networks API is YYYY-MM-DD and the format provided by The Raisers Edge is MM/DD/YYYY. When sending dates from RE to EN, the date will need to be reformatted. A dictionary can be created to reformat the date during export.


1. In IOM Configuration, select Dictionaries and click Add to create a new dictionary



2. At the prompt to create the dictionary from a table, select No

3. Enter the following values:

**Please note that all 4 groups are needed and must be in this order


                Replacement Value line 1: $3-$1-0$2

                Value To Match On line 1: ^(\d{2})/(\d{1})/(\d{4})$

              

                Replacement Value line 2: $3-0$1-$2

                Value To Match On line 2: ^(\d{1})/(\d{2})/(\d{4})$

                               

                Replacement Value line 3: $3-0$1-0$2

                Value To Match On line 3: ^(\d{1})/(\d{1})/(\d{4})$

            

                Replacement Value line 4: $3-$1-$2

                Value To Match On line 4: ^(\d{1,2})/(\d{1,2})/(\d{4})$

            

4. Check the box to Use Regular Expressions for each row



5. Click Save

6. In the export profile, apply the dictionary to all date fields being sent to Engaging Networks



Refer to the ImportOmatic User Guide for additional information.