Skip to content
+1-888-319-3663

COMMUNITY FORUM

Map Data Checks

Kayla Worley asked 9 years ago
I would like to check data for gl account errors and email the list of gl accounts not valid and stop the map.

I have tried map data checks and it does stop the map but will not email a list or a failure?

I tried the checkglaccount script as a restriction and it does indeed check but still allows good data to be imported.  Therefore I have to delete the batch in Great plains before importing the fixed records.

My desire is to check for valid gl accounts and not run the map if invalid accounts exist.  Then email that there are invalid accounts
Answers
Best Answer
kevin answered 9 years ago
Hi Kayla,

Unfortunately at the moment there is no way to email the validation errors when a map fails validation. However if the map is run manually, and validation fails, a Validation Errors button will be enabled on the map process screen. Clicking the button will give a list of all data lines that failed validation.

Kevin
kevin replied 8 years ago

I have logged a request for the ability to include the process and validation errors in emails that are sent from SmartConnect. It will be included in the SmartConnect 2013 SP1 release.

Kevin

sbasye replied 7 years ago

Has the ability to email notification of data check been added?

Lorren Zemke replied 6 years ago

The ability to email validation errors has been added to Smartconnect 20.15 and newer.

Dominic replied 4 years ago

is it inside the SQL validation task that the email of validation errors is?

where do we create the task to send the email on the data checks error?

I see there is a “save validation errors” box but what to do with it?


If you would like to submit an answer or comment, please sign in to the eOne portal.