Welcome to the Exact Product Blog

On this blog we will cover stories from all around the Exact ecosystem.

Rafiki’s Corner – Exact Event Manager 1.6 – A Bag of Tricks

Written by Sander van Triet on . Posted in Exact Event Manager

Effective Tuesday, May 4, Exact Event Manager 1.6 went into extended internal testing and QA (Regional Verification Testing). This exercise will take place in Columbus, OH where we are privileged to have 3 colleagues from Delft with us, who will assist in shaking the latest release out. By bringing people from around the world together into one room, we will further ensure that communications and ideas are consistent and focused. There is nothing like breaking down time-zone governed barriers!

Event Manager 1.6 is a cumulative release that contains a significant number of software corrections, some smaller user improvements and 2 new features:

  • Support for SQL Server Reporting Services as an action
  • Uploading of attachments into Synergy Enterprise as documents

These two enhancements were requested by groups across all regions and represent the growing trend of market / customer driven solutions.

Support for SQL Server Reporting Services

When setting up SSRS as an Action, you are able to define the format of the output as either

  • MS-Word
  • Excel
  • Adobe .pdf
  • HTML 4
  • CSV

So, what does this mean to everyone? Well, the attachments that are sent with the outbound email, as the action, mean that the user can take advantage of the significant features found within Excel, Word etc. For example team members here have been playing around with conditional formatting, which will be controlled by Excel or Word.

Uploading Documents as Attachments to Synergy Enterprise

Tapping into the extended opportunities provided to us by the entities exposed with Synergy Enterprise, you are now able to take a Crystal Report and upload that into Synergy Enterprise as a document with the the report attached to the document. Furthermore, making use of the power of SQL Server Reporting Services, the same holds true here. You are able to define an Event where the action is to create a Document, and you have the option to select a SSRS document to be uploaded into Synergy Enterprise, as an attachment. This means that you can select either a pdf, Word, Excel, HTML 4 or CSV attachment to Synergy.

The use of the Entities with Synergy Enterprise, further allows you to ensure that the document types and all properties associated with the document classification are exposed and correctly filled in within Exact Event Manager.

Exact Event Manager 1.6 is a major milestone for the solution. We are now stepping into new areas of capabilities never before seen, and embracing newer technologies and concepts such as SSRS and entity integration. For more information, keep watching my blog. I will not be silent and will continue to communicate!

Tags: , , ,

Comments (5)

  • Robert Klein

    |

    I am really excited about SSRS support, and Synergy Document creation, which are two major features I have been waiting for. Having tested 1.6 last week, I was able to save the SSRS report in 5 formats listed above, which I prefer the HTML. I think as more, and more companies are moving from Crystal to SSRS, they will appreciate this new feature!

    Reply

  • A User

    |

    Sounds very nice but does it work on SQL Triggers? or are the events still running on schedules?

    Reply

  • Erik de Meijer

    |

    Hi user,

    All the event are running on schedules, so indeed triggers are not used!

    Reply

  • Dennis Damen

    |

    Hi Eric,

    Is there a possibility that SQLtriggers will show up in future releases?

    Cheers!

    Dennis

    Reply

  • Peter Rliey

    |

    Hi

    Could I ask if this product is able to connect to website via a web service connection?

    Regards

    Peter

    Reply

Leave a comment