Sage 100

Does anyone know if Business Alerts can monitor the Windows Event Logs such as the Application Event Log? Client who is on MAS 4.50 and a heavy Business Alerts user, has a 3rd party .NET app that imports data from a CSV file (created out of MAS) into a CRM app (not Sage CRM). But this app logs its successful and failed imported records into the Application Event Log. I believe I can use Crystal Reports to view the Log but I still need a way of email alert notification. I suppose I could write a script to check the Log and email it with Chilkat (what Paperless uses), but if Business Alerts can already do it, it would be much better.

@AlnoorCassim - If you can configure an ODBC connection for the log file then it should be able to. Is this the full version of Business Alerts or the crippleware that was sold through Sage? Some of the crippleware versions will only read through the ProvideX ODBC. The customer may be able to upgrade to the full version for little or no cost if they sign up for maintenance from Globalsoft.

They bought Business Alerts Professional from Sage not the Select edition so I think they're okay there. I'll check out whether an ODBC or OLEDB connection can be made. Thanks!

You can hijack the sample access database provided by adding PTQ's to it so you could monitor the table even if there is not a direct front end link.

Test it on a simple ODBC before you do a lot of work - some of the newer Professional Editions are restricted to only PVX ODBC - it is not just the Select editions.

THAT was the workaround the ODBC limitation. You had to leave the Access DB name the same and leave it in the same folder location but there was no limitation to what you did INSIDE the sample database name.