Description: This solution describes how to export to date fields from The Raisers Edge in Luminate Online

Environment: All

Versions: All

Answer:

The date format required by the Luminate Online API is YYYY-MM-DDT00:00:00 and the format provided by The Raisers Edge is MM/DD/YYYY. When sending dates from RE to LO, 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 Luminate Online

Refer to the ImportOmatic User Guide for additional information.