Showing posts with label smartconnect. Show all posts
Showing posts with label smartconnect. Show all posts

Thursday, August 14, 2014

Press Release: Solver and eOne Announce Strategic Partnership

FARGO, ND, August 14, 2014 – Today, eOne Integrated Business Solutions and Solver, Inc. announced a global, strategic partnership to enhance the experience and ROI of their mutual customers and partners. Solver is the global leader in complete Business Intelligence suites for Microsoft Dynamics AX, GP, NAV, SL and other enterprise resource planning (ERP) systems. Fargo based eOne is the leading provider of integration, migration, and data productivity tools for Microsoft Dynamics systems as well as other platforms and web services including SQL Server, ODBC, and Salesforce.com.

“We are excited to partner with eOne, one of the most well-known and respected Independent Software Vendor’s in the Microsoft Dynamics space,” said Nils Rasmussen, CEO of Solver. “With this partnership our customers and partners using Dynamics GP or Microsoft CRM will immediately benefit because they can configure an integration using eOne’s SmartConnect and load data into our BI360 solution in record time and with no technical skills required.”

“This is a great example of a partnership aimed at putting customers and partners first, and at eOne we are excited to be working with Solver to enable higher productivity and better Corporate Performance Management for our joint customers,” said Martin Olsen, Director at eOne Integrated Business Solutions. 

The first stage of the partnership is an integration using the eOne SmartConnect extraction, transformation and loading (ETL) tool to populate the BI360 Data Warehouse. With Pre-built SmartConnect integration templates specifically for BI360, the partnership simplifies and automates the loading of data from Dynamics GP and Microsoft CRM.

A webinar overview will be held on August 19th to showcase the new functionality.

To register for online session or for more information, visit: http://eone.solutions/solver-webinar.


About eOne Solutions

Headquartered in Fargo, ND, eOne Solutions is the proud creator of smart, configurable, and integrated software tools for business platforms and web services including Microsoft Dynamics GP, CRM, Microsoft SQL, and Salesforce.com. Founded in 2001, eOne has a family of seven flagship products specifically designed to enable business users with the easiest way to view, automate, report, and take action on information. In 2005, Microsoft and eOne built one of the most successful OEM partnerships in the history of Dynamics. With more than 13,000 companies trusting eOne tools daily and over 21,000 installs worldwide, eOne helps more Dynamics customers and partners than any other ISV or service provider.

For any questions, visit eOne’s website, or contact info@eonesolutions.com.

About Solver

Solver provides BI360, the leading Business Intelligence suite for Microsoft Dynamics AX, GP, NAV, SL, Sage 500 and X3, Intacct, Acumatica and other ERP systems. Solver is a Microsoft Gold ISV Partner and the winner of the Microsoft BI Partner of Year Award and has a presence on the Gartner Group CPM Magic Quadrant. BI360 is sold through a world-wide network of resellers and is ideal for companies looking to find a user friendly, yet highly functional Reporting, Budgeting, Dashboard, Collaboration Portal, and Data Warehouse solution to give them deep insight and actionable information across all facets of their organization.


For any questions, visit Solver's website or contact Solver at info@solverusa.com.

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 10.0.0.51 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 sales@eonesolutions.com. 

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. 

Regards



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

dimfromDataSource 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()
else
                '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 sales@eonesolutions.com!