Thursday, July 31, 2014

eOne SmartConnect Support Update

Please take a look at a special notice from our Director of Services, Lorren Zemke:

Effective December 31, 2014, eOne Solutions will discontinue support for all versions of SmartConnect prior to Version 2011. SmartConnect will be supported when required to upgrade to the latest released version. SmartConnect 2013 and 2014 are compatible with Dynamics GP Versions 10, 2010 and 2013 and will continue to be supported. Extended Support can be purchased for an additional fee. For information on Extended Support options please contact your eOne Representative. 

If you are ready to upgrade to the latest version of SmartConnect and need assistance, please contact your Dynamics reseller or reach out to our team at

Wednesday, July 30, 2014

Why Every Company Owner Should Answer Web Chat

I have always been a reluctant user of web chat on any website I visit - which stems back to the first few times I tried to use web chat as a customer.

The first time I used web chat there was simply no one on the other end. After 15 minutes I got a response but then each response took about 15 minutes. I gave up.
My second attempt got an immediate response - but it became clear that the responder was in no way going to be able to help me. In fact I am confident that the chat responder was outsourced and had no idea about any of the product and existed to collect details.
My third time - there simply was no one available and it asked for my email address so they could get back to me. (That is not web chat - that is web annoying!)

So when we looked at the web chat feature for eOne there were a couple of key requirements: 
1. If no eOne staff were available to chat - then chat did not appear as an option on our website. 
2. We hved to have good, knowledgeable people answering chat.
3. The person taking the chat had to own that question through to successful answer - even if it was referred to support/consulting.
4. Chat like all other communications needed to integrate with our Microsoft CRM.

So we selected the Contivio Chat System that is hooked into our Contivio Soft Phone and call center solution. This means that just like logging into your soft phone - you could log into chat. Contivio had an out-of-the-box integration to Microsoft CRM activities. 

For the first few days I decided I would be the dedicated Chat Manager to see if anyone wanted to use chat and get a feel for the systems. When we launched I was astounded that our first real chat came in 90 seconds after we went live. I was able to answer the question and had a happy customer. A good start. 

Since then we are taking 10-15 chats per day and it has been very successful. The questions vary significantly but include "I need to place and order", "What is the price", "Where can I download ...", "I am getting a strange error message", "I have an issue with license keys" and many variations on these topics. What chat has meant is that these customers are getting much much faster answers than if they were to send in an email. Web Chat for eOne has been super successful. 

Weirdly one of the funnest parts of my day is when I accept web chats! Why?

1. First of all I love the reaction of our partners and customers when they see someone called Martin answering their Chat. I always get "Is that really your Martin Olsen? Why are you on Chat? You're the Owner/CEO?" Then they apologize for bothering me!! But is there a better way to say to a customer that we care about them - when the CEO answers their pricing questions?
TimeOut!: Just took a chat call right then from Leanne - in the middle of writing this blog.  A long time reseller was unaware of our online manual and documentation. Easy answer, 30 seconds and happy customer. 

2. There is no better way for me to know what our resellers and customers are experiencing than to talk to them? A couple of things I have been learning about my own company in the last few weeks: 
  • That we have the best and easiest to use Website of all Microsoft ISV's.
  • That we can make the ordering process easier and navigation on our website can be clunky (we are on to it). 
  • That people tend not to use our Knowledge Base. I am often answering questions by sending links to the answer. 
  • Despite the worlds simplest pricing model and clear pricing displayed on our online store - people still like to ask/confirm the price!
  • Email response is too slow and unacceptable in 2014.
  • Many customers are helping themselves and bypassing the traditional 'ask your VAR first model'.
  • That people need immediate responses and support queues are so yesterday. 
  • Our resellers have a lot to learn about our products and we need to ramp up our training and education efforts. 

So for these two reasons alone - I would encourage all Business Owners to spend some time answering web chat. It might be the best few hours you spend all week. 


Tuesday, July 29, 2014

Tech Tuesday: SmartConnect Addin Office 2013 Integration Fails on Date Fields

This week is the first Tech Tuesday from our new Product Specialist, Pat Roth. His article highlights how to correct a few errors that could pop up when using our SmartConnect Addin Office 2013.

With a new version, there are always a few “gotchas” to watch out for and the eOne Support team always likes to get the things that we see out in front of things allowing our users to resolve their own issues.

The topic today is something that has cropped up when using the SmartConnect Addin Office 2013.

Using the Dynamics GP General Ledger Transaction destination, a simple transaction was created and a map created for it.

The map was tested and runs from SmartConnect 2014 and successfully creates a 3 line journal entry.

When running the map from Excel via the SmartConnect Excel Addin 2013, the following errors are presented.

Figure 1: Failed to convert parameter value from a String to a DateTime.

As this is the same spreadsheet that the map runs from, the error is unexpected.

Looking at the TrxDate column, we see the date is unrecognizable – it is being displayed as a numeric value instead of a familiar date.

What is going on?

A previous blog article from Jared shows an example (in reverse) of this process and where a report was published from Excel Report Builder and the date isn’t exported as a formatted date and instead is a numeric value.

This is how Excel stores dates internally – the formats that people are used to seeing are just human readable formats. The format is actually stored as an “OLE Automate Date” or “OADate” for short. The trick to getting the integration to run successfully from both Excel Addin and from SmartConnect directly is to know when and how to convert this “OA Date” to a date format that SmartConnect is expecting.

The solution to this issue is to create a new Calculation that will test the TrxDate field and either convert the OADate to the expected date format or else leave it the same as the integrated data field.

Figure 2: VB.Net code for calculated TrxDate converting from OADate if required

The VB.Net code in the screenshot reads

dim fromDataSource as String

'capture the input date as a string
fromDataSource = _TRXDATE

'If the value is numeric, then the data is coming from
'the Excel addin as OADate.  Convert to ShortDate and return
if  (fn.ISNUMERIC(fromDataSource))  then
                return DateTime.FromOADate(fromDataSource).ToShortDateString()
                'Not a numeric date, return the value from the datasource
                return fromDataSource
end if

Once the Additional Column for the Calculation is created, now use the new CALC_TRXDATE instead of the previous TrxDate column.

Figure 3: New CALC_TRXDATE used in the SmartConnect mapping

Running the integration from Excel now shows the integration running successfully.

Figure 4: Integration from Excel Addin is successful

Looking for the SmartConnect Addin Office 2013? Download it here and select "SmartConnect" for the product and "Add-ins" for the Download Category.

Interested in learning more about the latest version of SmartConnect? Please email your questions to our sales team at!