Welcome to the Exact Product Blog

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

Author Archive

Exact Lightweight Integration Server now in Controlled Release

Written by Sander van Triet on . Posted in Exact Globe, Exact Synergy

As of this week Exact Lightweight Integration Server (ELIS) is in Controlled Release. This means that customers who participate in the controlled release phase can now benefit from this new technology.

ELIS is a brand new technical framework for the integration between Exact Globe Next and Exact Synergy Enterprise and supports solutions that exchange data between these two products as well as with third-party solutions.

Via the ELIS control center you can centrally install, activate and manage these solutions (such as Exact Integration, CMDM, Shop Floor Control, Word Merge, Exchange Integration). The framework offers central and pro-active logging, which means that you can manage all integrations from one central location and send them again in case errors occur. Even better, ELIS will send you a notification via mail or workflow, so you can act and resend immediately.

Another important enhancement is that the framework supports multiple instances as well as multi-tenancy, for optimal performance and scalability. It also means you can for example manage multiple 1-1 Globe-Synergy integrations from a single management console.

Soon we will also enable third-parties to base integration solutions on the ELIS framework to benefit from the built-in functionality and central manageability. Our ultimate goal is to have one central place for managing all integrations, greatly reducing the TCO of managing your Exact environment.

The ELIS framework will be available with Exact Globe version 409, and Synergy Enterprise version 254. Initially we will go into Controlled Release with the add-ons Exact Integration, Word Merge and Shop Floor Control. For Shop Floor Control there is an added bonus, as running Exact Integration is no longer a precondition, we will now also support it in combination with CMDM or XML integration.

In the coming months we will be migrating other solutions to make use of the ELIS framework as well, among others CMDM, Exchange Integration, and Service Management. Keep an eye on the product blog as we will be posting updates on a regular basis.

Please contact your account manager in case you wish to participate in the Controlled Release, or me in case you have any questions regarding the ELIS framework.

 

Rafiki’s Corner – Exact Event Manager 1.8R2 – A Maintenance Release

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

Good day to you all! Many of you will have heard of the imminent release of Exact Event Manager 1.8. Well, that day has come. On Thursday, June 7, Exact Event Manager 1.8 R2 will be Generally Available around the world.

This release of Exact Event Manager is purely a maintenance release. We have fixed a little over 35 issues, ranging from User Interface / Experience issues, down to low level behavioural issues that have been reported to us. This release has undergone extensive testing prior to being tested under what we call Region Testing. This phase in the release cylce is where we put Exact Event Manager 1.8R2 through its’ paces for three weeks by colleagues from the various regions within Exact. This builds on an already stable set of product in the orginal Exact Event Manager 1.8. In fact, we had only one bug reported during the Region Testing! Now that is not bad at all.

As stated, this is a maintenance release only. However, there is one additional “feature” that may be of interest to everyone. In fact, it is more of a utility than a feature. To be more precise, this is a Stored Procedure that we set against the required table. This little nugget is a Purge Utility that will assist in cleaning up the EEMResultDetails table, selected by date range. This will assist in ensuring that this table does not get too bloated with often redundant data. Remember, if you turn on logging for an event that runs every minute, we are recording and storing all the results of those events, and this table will morph into a little monster in no time at all. Now why do we store all this data you may ask? Well, right from the onset of the design phase, we were asked to provide information that allows users to analyze the results to determine if anything went wrong. So, the need to report and filter on results means we need to store it somewhere. This is the old “Which came first, the chicken or the egg” situation. Anyway, be that as it may, we have now provided a user driven Stored Procedure that will aid you in managing the size of this important table.

So, for those of you who have Exact Event Manager 1.8, I urge you to update to Exact Event Manager 1.8R2 and experience the benefits of a protracted and thorough testing / quality control cycle. For those of you who do not have Exact Event Manager 1.8, well, what are you waiting for! Exact Event Manager 1.8R2 is solid, robust, feature rich solution that is of extreme business value in any business, no matter the industry.

Should you have any questions on how to obtain this update, please contact your account manager or Exact support. Of course, I am always available.

Cheers for now!

Rafiki’s Corner – Have you heard the one about?

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

With the ever expanding footprint of Exact Event Manager around the world, we are fast gaining insight into some of the effective and meaningful uses of the high-value  business solution. I have recently started contacting customers that I know and asking them for some examples of how they have deployed Exact Event Manager. This is a fascinating exercise and I thought it is relevant to share some of these experiences with the larger community through this Product Blog. I will regularly post blogs on some of the real-life uses of Exact Event Manager, in the hope that ideas being to flow.

So, yesterday, Wednesday March 28, I went to spend some time with a customer not too far from my office. This is a customer that I have known for a long time but have never visited their new Head office digs here in Cambridge, Ontario, Canada. Company ABC is a Canadian company with many divisions and locations across the country, classified in the food processing industry. They use a number of Exact’s solutions to assist in driving their business forward and have done so since 1998. Exact Event Manager, along with Exact Synergy Enterprise, are their newest additions to their solution set from Exact.

Their plan was to implement Exact Synergy Enterprise to solve some challenges they faced with Quality Assurance and related documentation (Certificates of Analysis etc). This would have been accomplished with Exact Synergy Enterprsie and Exact Event Manager. The plans and ideas were well mapped out and timelines defined. Then reality poked its ugly head up like a gopher on a newly dressed golf green, right when the final goal was in line. In this case, the gopher was a well publicized strike by Canada Post employees. Hmm, you might say. How is it possible that in todays’ technology driven world would a postal strike affect business? Especially in a country such as Canada eh!! Well, it does have a huge impact, both for folk at home and for businesses.

On the 3rd June, 2011, a rolling strike was initiated across the country by the members of the Canada Post delivery services. From that point on, you had more chance of seeing the Toronto Maple Leafs making the play off’s than receiving a bill in the mail!! And therein lies the rub, as well as the opportunity! As we all know, these days in business (and at home as well!) Cash is King! However, without customers receiving invoices for products and services, no one is going to get paid. The old adage of “Your cheque is in the mail”, was not one that was going to work this time!!

So, Company ABC responded to this challenge laid down by reality and looked into their box of tricks and solutions provided by Exact, seeking ways to mitigate this potentially crippling business interruption. Low and behold, they came across Exact Event Manager!! They henceforth, postponed their other projects and focused on looking for a solution that lay within Exact Event Manager. “What if we could email all our invoices to customers?” This was the high level solution that presented itself. However, remembering to select the correct email address at the time an invoice was processed, save the invoice to disk in a .pdf format, and then attach it to the email was open to mistakes. Sending an invoice to the wrong person or customer is not necessarily a business practice supported by any college business program. Well, “what if we could have this done automatically after we have posted a whole bunch of invoices and spooled the documents to disk?” This line of questioning prompted some thought of previsously hearing in the corridors somewhere at an Exact Engage Conference that Exact Event Manager is the “Automatically” part of the solution.

So, the team at ABC Company, set about creating a single event within Exact Event Manager that would automatically send out customer invoices, a couple of times a day, taking all the batch created invoices and emailing them as attachments to the correct contacts at the correct customer. Simple, efficient and problem solved! Move forward almost a year since the strike, and all their customers still get their invoices eletronically via email, their postage costs have gone down significantly, cash flow from sales operations remains positive and the Toronto Maple Leafs still have not made the play off’s!!!!!

The deployment of Exact Event Manager within Company ABC to solve this business challenge of sending invoices automatically may seem simple and innocuous. Yes, Exact Event Manager was designed with way more horse power than simply automating a manual operation of sending invoices via email. However, the issue at hand here is that a simple, but vital business challenge was solved very quickly with some imagination and Exact Event Manager. At the same time, there are real cost savings with the reduction in postage costs, which is not trivial when you send out thousands of invoices a month! What does a single Event cost with Exact Event Manager? It is somewhere around $300 per event when you break it down. Add some time to create the event and test it out, and you are at around say $600 per event. (For complete and formal pricing, please contact your representative. These values are merely illustrative in nature) Well, it looks like this specific business challenge saved a whole lot more, not only preserved cash flow, than $600 (the price of a ticket to watch the Maple Leafs by the way!). I call that a good return on investment and an even better time to value.

There are many, many such cases where Exact Event Manager will drive significant value within your business. Some cases you haven’t even thought of yet. However, I am sure the time will come when the need arises to solve a last minute, reality based business issue and you may well find Exact Event Manager sitting in the corner waiting to help you to a long lasting resolution. More ideas and uses to come….have a great weekend!

Rafiki’s Corner – Feel like doing some “renovations” to Exact Event Manager?

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

Greetings from the frozen North! It has been a while since I put “finger to keys”, but I have not forgotten about the ever growing Exact Event Manager community!! I have spent the past few weekends renovating some of my rooms in my house, which got me thinking about the topic of this blog.

As you know, Exact Event Manager 1.8 has been out in the field since December 15, 2011, being implemented in all corners of the globe. I have heard of some interesting applications that Exact Event Manager is being used for, about which I will write in a subsequent blog. In the meantime, I wanted to provide some insight into one of the less than known capabilities of Exact Event Manager. I stress capabilities here, and not features for a good reason.

I have often had questions posed to me such as “When will Exact Event Manager support the creation of Opportunities in Synergy Enterprise?”. In response to the question, what if I were to say that it will support this functionality when YOU want it to!? Hmm, what does that mean you are probably thinking to yourself right now!?

Okay, here is it…. Exact Event Manager 1.8 has a “built-in” Software Developers’ Kit (SDK), or more accurately, an Application Programming Interface (API). This was added to Exact Event Manager to “untether” some of the development requirements from your specific internal needs and requirements. We understood early on that we would never cover 100% of all that may be requested of us and are mindful of the fact that a Third Party ecosystem is a powerful validation of the commercial value of a solution. The intent of the API to to allow you to create your own actions that create / modify data in Synergy Enterprise. (If, and only if, there is no User Interface Change needed). Furthermore, the way this API was built means that all “interaction” with Synergy Enterprise is channelled through the entities of Synergy Enterprise which means all data is validated and flows through the correct business logic.

So, what does this mean for your solution? Well, plain and simple, it frees you up from a pre-defined development schedule, allowing you to create your own action(s) for Synergy Enterprise. For example, you may want to have Exact Event Manager create an Item in Synergy Enterprise, based on the creation of an item in some external QA database. In this case, you would use the API to interact with the Items entity in Synergy Enterprise, and that is pretty much it! I know I am simplifying this, but it is not all that tough to do. You could also create an Opportunity in Synergy Enterprise, based on a quotation stored, say, in an external CRM solution.

What skills do I need to accomplish this? This is a good question…. Aside from a good imagination and patience, you need to have C#.net skills as well as an understanding of how the entities (web services) of Synergy Enterprise work and how to consume them. Basically, you will code the action, compile a .dll file, drop the .dll into the <bin> directory of Exact Event Manager, register the .dll and off you go. You do not need to perform a complete installation again. The code you would have written is independent of the core code base, further de-coupling your efforts from core development.

When we developed the API, we needed to find a test bed for the solution, so that we could prove it out prior to releasing it. We thought using the API to develop some of the existing Synergy Enterprise actions would be the perfect enviroment. So, we put one of the development team members, who had no experience with the core code development, into action(he was responsible for the installation side of the solution), and tasked him with building the Resource Action and the Accounts Action. When they were done, we simply added them to the install process. So, if you are using the Resource or Accounts actions, those are actually API developed actions. I have not seen any bugs come through on these two items, so I presume they are working well!?

How do I get hold of the API? You already have it! It is simply deployed along with the installation of Exact Event Manager. Now, there is no public documentation for this yet, but I have a set of electronic documents (help files) and some samples that provide an idea of what to do and how to go about it. If you would like to take a peek at these, please let me know and I will make sure you get the relevant files. One point to be aware of: The actions that you build for Synergy Enterprise will function correctly, assuming your code is good, but also if there are no User Interface changes required. There should be none, but just in case. Any UI changes require that core code be worked on, which of course you cannot do!

I am going to take an active interest in the activity that will evolve from the use of the API. I know that there are many ideas that I have never even come close to thinking about and I look forward to hearing some of your uses. Please keep me posted. Have a wonderful weekend and week ahead!

 

Rafiki’s Corner – Exact Event Manager 1.8 Goes to Market

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

The Red Carpet is out, all in place for the lastest release, Exact Event Manager 1.8. Effective Tuesday, November 1, Exact Event Manager 1.8 is Generally Available for Exact in North America (US & Canada) and in formal Controlled Release for the Benelux and International regions of Exact. The expected General Release for these two regions is December 1, pending the outcome of the Controlled Release cycle.

Why do we have a dual release cycle going on with Exact Event Manager 1.8? you may well ask. Well, there are many reasons, but the most practical reason is due to the status of Exact Globe Next and the fact that Exact Event Manager 1.8 is also installed with Exact Globe Next as a core solution. Consumers of the technology provided by Exact Event Manager in the USA and Canada, where we have solutions other than Globe, are able to take advantage of the significant benefits of this latest release, without any further delay. It is all about providing what the market wants and needs!

Just to re-cap, here is a list of key features that this new release provides:

  • Simple Grouping (Single level)
  • Tables in emails (for Grouping)
  • Embedded images within the Rich text Editor
  • Support for Stored Procedures as an Action and Source
  • Creation of Exact Synergy Enterprise Projects as an Action
  • Creation of Exact Synergy Enterprise Accounts (Customers) as an Action
  • Creation of Exact Synergy Enterprise Employees (Resources) as an Action
  • Simplified Alert Summary Tab
  • Queue Now (Run Now**) Option
  • New Languages (Russian, Polish and Czech)
  • Installation (Silent) with Exact Globe Next with basic Auto Configuration

These are but a few of the new capabilities of the solution. I would highly recommend updating to this solution when appropriate! You will not be disappointed…No referendum is required to determine the power of this solution!!

Tip of the Day

One aspect of Exact Event Manager that I would like to highlight here, now, relates to the installation process of Exact Event Manager.

When you install the solution, for the first time, as well as update, please make sure that you have Administrator rights to the database and server. If you do not, the installation WILL fail and you will not be able to access or run the system. This is very important, and it has been well documented.

Second Tip of the Day

You will shortly see some cool help functions within Exact Event Manager that will assist you in learning some finer details. We have embraced new technologies in every aspect of the solution, and this is also true of the Help functions. You will soon see an option for “Show Me!” within the solution. We have expanded the capabilities to now access on-line Show Me videos that will walk you through that specific topic. Initially, there are 7 Show Me videos that are being embedded into the help. These will be ready within the next week!

Request for the Day

We are looking to obtain / earn Customers who are willing and able to act as a Reference Customer for Exact Event Manager. This aspect of any solution is an extrememly important part of the product life cycle, with benefits for both the Customer and Exact. I am taking names and numbers…..

Enjoy the release and the rest of the week!

 

 

Exact CRM App for Android now available in the Play Store

Written by Sander van Triet on . Posted in Exact Synergy

After a succesful Controlled Release period, we are very pleased to announce the Exact CRM App for Android is now available in the Play Store.

This app has been especially designed with the sales rep in mind. It provides them with all the information they need to be fully prepared for the next meeting, and all the tools to ensure follow-up activities are initiated and performed within the agreed timelines.

The app was built on the latest technology, and provides you with valuable real-time information from Exact Synergy Enterprise, release 252 or higher. Not on release 252 yet? We also provide a demo mode, so you can already gain some hands on experience with the App(s).

Android_AccountCard Android_Opportunities

A short summary of what the App has to offer:

Agenda

The clear newly designed agenda offers direct insight in your upcoming appointments, and allows you to instantly schedule new ones.

Inbox

Any and all activities that require your attention will appear here, in your workflow inbox. Very busy? We added several options tot sort and organize your work, so you’re always in control.

Opportunities

Keep track of all your current sales opportunities, and by using the end- and follow-up dates you’ll never miss a deadline. Not using opportunities? This overview will also list all requests marked as ‘Sales Forecast’.

Reports

Whether you want to keep track of your personal KPI’s, the latest customer intelligence or company performance, with the integration of Reporting Services you can have it all. Simply go to your personal preferences in Exact Synergy, and choose the reports you want to have available anywhere, anytime and anyplace.

And much more

Of course, the app helps you find customer and contact information, or the right colleague to help you out. Also included are your complete workflow and document history.

Download the app today, and discover its rich functionality and ease of use yourself. The app is supported for Exact Synergy Enterprise release 252 or higher, and for Android version 4.0 and higher.

Rafiki’s Corner – Quality Systems and Exact Event Manager

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

Every organization has a defined set of Quality & Compliance systems in place. These may be official and governed by principles found in ISO9000 guidelines, or FDA regulations and even SOX Compliance levels. They may even be unofficial, guided by the owners need and desire to ensure the final delivery of quality products and services to customers. From interviewing customers on their deployment of Exact Event Manager and the challenges they face with maintaining these quality systems, it is quite clear that Exact Event Manager has a “golden key” when it comes to enforcing and automating many of these procedures. Lets’ take a look at some ISO9000 procedures deployed within a real-life distributor of high tech flow control equipment.

Firstly, it is important to understand that software is NOT ISO compliant. No software is. The compliance with ISO is centered on the organization and its’ defined policies and procedures. In short

      • Document what you do
      • Do what you document
      • Is it effective?

I know this may seem simplistic, but it really does help understand the definitions of ISO9000 (and other certifications within ISO such as ISO 14001).

So, the point in case under discussion today also makes use of this “definition” of ISO. Here we go….

Davis Controls (www.daviscontrols.com) is a distributor of high tech flow control measuring equipment, among other things. They are ISO9001:2008 Certified throughout their organization. They use Exacts’ products and solutions to assist them in maintaining their high level of commitment to quality and adherence to their QSM (Quality Systems Manual). They have many procedures that define pretty much all of what they do, that assist in bringing products and services of the highest quality to their customers, all the while seeking ways to continuously improve those very processes and quality. In the loose definition above, “Document what you do”, Davis Controls has a defined and documented policy which states that any Sales Order over $10,000 in value requires authorization from a manager before it can be confirmed and delivered. This helps them mitigate any financial risk on higher value orders, which is an imprtant part of their procedures in today’s economically challenged era.

So, the policy simply defines what they need to adhere to. Every order that meets this criteria is then sent over to the manager for sign off and approval. This can be an arduous and time consuming task, open to potential slips and delays if attention is not paid carefully. Davis Controls’ challenge was to find a way to remove any risk in the procedure and automate it where possible, so that the element of human effort is removed from the equation. Having had signifcant experience with Exact Event Manager, they immediately turned to the solutions offered within the solution. A simple query was built, looking for any Sales Orders over $10,000 in total. This would run periodically on a defined schedule. The moment Exact Event Manager finds such a Sales Order, it will proceed to create a Workflow Request within Exact Synergy Enterprise with all the necessary information tied to the request, that would be routed to the Sales Manager. The sales manager would perform the evaluation of the sales order, and then either approve or reject the request. Upon approval, the Sales Order is then updated to an Approved status and life can continue normally.

Once again, this may seem like a fairly innocuous and simple use for Exact Event Manager. However, this use of the toolset allows for the automation of a highly repetitive activity that is fundamental to their financial controls and mitigates any risk associated with potential slips from a manual process. This policy, and subsequent procedure is then documented in their QSM and they can unequivocally trust that this is one policy that they no longer need to worry about. The ultimately make Exact Event Manager take care of the “Do what you document” part of ISO.

One of the key success factors here is keeping it simple. Davis Controls has identified a highly repetitive, yet important procedure that can, and should be, automated. Exact Event Manage provides them the tools to get the job done in a “fire-and-forget” mode. Oh yes, the Sales Manager obtains a summary, via email, weekly of all those Sales Orders over $10,000, driven automatically by Exact Event Manager!

As the world of Exact Event Manager grows, I am constantly looking for cool uses of the solution within real-life situations. If you have any, please feel free to contact me and let me know.

Rafiki’s Corner – Calling All Exact Event Manager Evangelists!!

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

Are you a user of Exact Event Manager? (if not why not ?!) The solution has now been out in the market, globally, for almost a year now and the growing number of users point to a measured level of success. All is good! We are hard at work on the next release of Exact Event Manager, that promises to be an awesome release and at the same time, we are working on a Maintenance Release that will include various software corrections.

Now, the time has come to take the solution to all corners of the earth, ensuring all Exact customers benefit from the huge business potential built into the DNA of Exact Event Manager. However, to do so, we need your help. Here is how you can help….

As everyone in business knows, the most effective form of marketing is not campaigns or branding, but word of mouth referrals and references. It is here that we need your help. We are looking to recruit customers who are willing to act as a reference for Exact and Exact Event Manager. These references may be called upon to talk to prospective users of the technology and answer some of their questions, based on your own experiences. This is an extremely important cog in the gears of a product life cycle. We have a large pool of customers already embracing the technology and we would like to hear about you. We would like you to tell your story, and provide other users and prospects with insight into the rewards and benefits that Exact Event Manager brings to the Exact solution stack and potentially to your business. When I say “Story”, I mean exactly that, in your own words. You have bragging rights over your successes and we would like very much to hear those stories and share them with a broader, global community.

If this is something that interests you, please contact me and we can get together and chat about what the program involves and what the benefits on your side are for joining such an important program.

Cheers!

Rafiki’s Corner – Christmas Comes Early with Event Manager 1.8

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

Well, here we are at the end of another bumper year. To ring in the Festive Season, I bring to you Exact Event Manager 1.8, now in General Availability, around the entire globe!!! For those of you who have yet to experience Exact Event Manager 1.8, may I suggest that you take a look at what this pivotal release brings you? For those of you who have a prior version of Exact Event Manager, please feel free to update to this release and you will open a stocking of delightful surprises.

So far, the adoption of Exact Event Manager has been extremely pleasing. Now is the chance to further expand on that footprint around the globe, as Santa and his reindeer travel from country to country bringing solutions that are sure to please. In summary again, herewith a brief listing of the latest features that benefit all entrepreneurial spirits….

  • Support for Stored Procedures as an action and source
  • Creation of Exact Synergy Enterprise Projects, Accounts and Resources
  • Embedding of Images within the newly updated Rich Text Editor
  • Integration and delivery with Exact Globe Next
  • Simple Grouping *** of data to provide one result set for multiple grouped rows
  • Tables in emails for grouped data
  • Queue Now (Run Now) option to immediately set off an Event into the Queue, regardless of schedule
  • New embedded “Show Me!” videos for specific new features, over and above on-line help
  • New Summary Tab allowing simple changes to schedule and parameters

There are also additional smaller improvements provided as “stocking stuffers” within the release.

So, as the year winds down and many of us head out to our favourite relaxation spots diving in the Seychelles, snorkling in Montego Bay, skiiing in the Alps or just basking in the sun, make sure that you can do all these activities without having to worry about business back home. Event Manager 1.8 is that very tool that will provide you peace of mind whilst you enjoy your well deserved rest!

To the extremely dedicated Exact Event Manager team, congratulations on this important milestone. A job very well done, and thank you!

Merry Christmas to you all!

 

Matthew

Rafiki’s Corner: The Art of Grouping with Exact Event Manager

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

Exact Event Manager 1.8 is now in Controlled Release around the world. Folks are testing the solution against real life use cases and things are looking up. In this edition of Rafiki’s Corner, I want to deviate slightly from my normal approach of information broadcasting to functional insights into a specific feature. This is more of a How To type blog, and the attention now turns to The Art of Grouping…. using the Grouping capabilities within Exact Event Manager that are now embedded into the core solution.

The Grouping capabilities with Exact Event Manager comprise a mini collection of functionalities.

  • Simple Data Grouping at the Query Level – Single Level Grouping
  • Tables inserted into emails for grouped data
  • eMail Repeats – one email for grouped data
  • Summation on Columns in tables

Each one of these items represents a Product Backlog item based on market driven requirements. However, they are combined together into the simple title of Grouping (Single Level). What this really means is that Exact Event Manager is capable of performing a query, grouping data, then sending this data to an action, such as email, and then insert this grouped data into the ONE action (e.g. email). Gone are the days where one row of data from a query would create one action, resulting in potentially multiple emails going to the same recipient. You also no longer have to perform your grouping inside SAP Crystal Reports or SQL Server Reporting Services! So, lets’ take a look at how to go about creating a Grouping based Event within Exact Event Manager 1.8. We will start with a Use Case…

Once upon a time, there was a sales manager, Tommy, who really liked to know what was going on within his revered customer base. He prided himself on knowing the very pulse of what was happening and when. However, those were the days when we had lots and lots of assistants whose sole job it was to provide you with that sort of information. Today, Tommy no longer has any of those assistants, and has no idea to operate his Business Intelligence tool that his father recently had implemented in their aviation supplies company. This meant that Tommy had to reliquish his daily golf game and park his Diamond DA40 in the hanger! Oh, how unhappy Tommy was now that he was tied to his desk learning how to get information from the systems.

All this pain simply because Tommy wanted to know what Customers placed orders of $2,000 or more, and what those orders were, once a week. Once he had this information, he would always send them an email thanking them. Now, he has to try to figure out a way to extract this information, and without the help of a bevy of assisstants who had all been re-assigned. Surely his newly acquired iPhone 4S could help him with this task and he could fly to a new golf course every day? Then he heard about Exact Event Manager 1.8……. “Show me please!!!!” cried Tommy. Low and behold, Tommy found the instructions on how to set up Exact Event Manager 1.8 to handle exactly his needs. He took them to his IT Manager, his uncles’ brothers’ sister, Wanda and asked her to get to it. Here is what Wanda had to do….

1. Understand clearly what Tommy wanted and why (aside from being able to play golf and fly!)

2. Make sure she knew what data to extract from what tables

3. Go into Exact Event Manager 1.8 and create a new Event

4. Set up the Source and go into the Command Builder and build her query

5. Seeing that Wanda needed to create a Grouped Event, she has to make sure that she checks the Sort Type and Sort Order columns against the Customer Number. This turns on the Break On First Field (Grouping) Capability

6. Inside the Command Builder, Run the Query now to ensure there is accurate data coming back, and make sure the Query Type is set to Tracked

7. Click OK to Save and return to the Design Canvas

8. Select the email Action off the default templates on the right, and double click it to bring it onto the canvas.

9. You will notice that there is now a Check Box at the bottom of the Action box, called “Break On First Field”. Make sure this is Checked to indicate Grouping is in play.

Grouping Indicator on Action

10. Select the Connector between the Query and Action, so this it is red

11. Go down to the bottom right of the screen and select fields in the Property Grid, specifically the email address for the To field, and CUSTOM for the Body field.

12. Click on the ellipsis to the right of the Body field to bring up the Rich Text editor (with some cool new features in it!)

13. Start building the bosy of the email with tags being inserted.

14. Go to Insert on the top menu bar and insert a TWO (2) Row Table with as many columns as you need. You must have 2 Rows.

15. Lable the Columns of the Table and place the cursor in the second Row cells, inserting the data tags you need.

Insertion of Columns for Grouping of data

16. Click OK, exit out to the Design Canvas, click on the Save and Exit Icon

17. Don’t forget to set a schedule, or hit the Queue Now button to run this immediately!

18. Go give the good news to Tommy to get him out of your hair, along with a gift voucher for new golf balls.

Following these steps, Wanda was able to create a set of Events that would help Tommy with his hectic life. And so it came to pass, that both Wanda and Tommy were happy, and customers received weekly information and emails showing gratitude for their business.

And they all lived happily ever after. Tommy with his Golf and flying, and Wanda tending to her network and fish.