Showing posts with label Econnect. Show all posts
Showing posts with label Econnect. Show all posts

Wednesday, July 2, 2014

Tech Tuesday: What version is what in SmartConnect?

We have recently released SmartConnect 2014; for more information on the initial release, check out our blog post on it from last week here. Chris Dew, our Director of Product Management, will ease any confusion when it comes to different SmartConnect versions below.
 
We have quite a few people that ask what version of SmartConnect is needed for a specific version of Microsoft Dynamics GP or Microsoft Dynamics CRM. The new architecture we introduced in 2010 has allowed us to remain independent of specific versions of products for the most part. As with many ETL tools, we are always introducing new technologies as they are made available. For example, SQL Server 2014, gets added to our list of supported datasource and destinations.

Below I have prepared a couple of key releases you will want to note for the major versions:

SmartConnect 2014
  • Microsoft Dynamics GP 2013 R2, 2013, 2010, 10
  • Microsoft Dynamics CRM 2013, 2011, 4.0 and Online
  • Salesforce.com
  • SQL Server 2014, 2012, 2008, 2005
  • Webservices as datasource and destination
  • Excel add-in for Excel 2013, 2010

As you can see the newest version of SmartConnect should have you covered for most versions of Dynamics GP and Dynamics CRM. We have seen a few customers using SmartConnect to migrate from older versions of Dynamics GP (5 and 6) or from Dynamics CRM 4.0 to 2013 or the Online edition. You won't need to worry about loading any older versions of SmartConnect to go back this far. The only thing I would point out is that we do require SmartConnect to be loaded on a SQL Server 2005 or greater database when you are migrating.

As we look to the near future where we can make additional connectors available, we are especially excited about the "DexNext" services oriented approach. When we add this connector for Dynamics GP 2015 it will open up many more integration points to Dynamics GP and ISV products ensuring that the same business logic is used whether you enter the data inside of Dynamics GP or from SmartConnect. Will eConnect still be around for a while? Absolutely, but Microsoft will be pushing the architecture and I think it will make Dynamics GP have the best integration story with SmartConnect out there!


Interested in SmartConnect? Have further questions regarding versions? Email us at sales@eonesolutions.com and we will be happy to assist you!

Wednesday, May 28, 2014

Microsoft releases R2 for Dynamics GP Today

It is great to see Microsoft keeps enhancing Dynamics GP and the release today has some nice features added. At eOne we have been busy testing SmartList Builder, Extender, Flexicoder, SmartConnect and SmartPost on the pre-release builds from Microsoft. Everything is looking good and as we do our final Quality Assurance regressions on the released build we will be releasing new builds next week.

We will have additional blogs on the new features we are adding in this release.

Thanks,
Chris Dew

Tuesday, May 27, 2014

Tech Tuesday: How to Determine if eConnect is Installed or Running on a Machine.

We try to cover questions and issues in our Tech Tuesday articles that we see frequently to equip you before you even think of the question, allowing you to use our products more efficiently and seamlessly. This week our Support Guru, Dave Youngquist, will walk you through determining if eConnect is installed or running on a machine for SmartConnect.

1. Press the Windows + R keys on your keyboard (will open the Run command)

2. Type in services.msc and click the OK button

3. The Services window will open. Scroll down until you see an entry that says “eConnect for Microsoft Dynamics GP 20XX Integration Service”. It may say 2010 or 2013 depending on the version of Microsoft Dynamics GP you are on.  


4. SmartConnect requires that the eConnect runtime be installed on every machine that has SmartConnect installed on it. If you do not see it listed in Services, it is not installed. Rerun the SmartConnect installer, and pick a version of eConnect to install on the machine.  eConnect 10 is for GP 10, eConnect 2010 is for GP 2010, and eConnect 2013 is for GP 2013. 

5. If eConnect appears in this window, then look in the column that says “Status” make sure that the status is set to “Started”. If the status is not set to started, then right click on the eConnect for Microsoft Dynamics GP 20XX Integration Service and select “Start” from the drop down menu. 

6. Watch the service for about 15 seconds. It should start and stay started. If it starts, and then stops within 15 seconds it means either the password is wrong, or the user is not a local machine administrator. 


7. To retype the password, right click on the eConnect service, and select Properties from the drop down menu. In the properties window, go to the “Log On” tab.  


8. Retype the password there and click OK. After clicking OK, right click on the service again and tell it to start again. 

9. If the service still stop, you need to make sure the service user is in the local machine administrators group. In the screenshot above, the user is “eonedemo\Administrator”

10. Click on the Windows + R keys again and in the Run command type in lusrmgr.msc


11. In the Local Users and Groups window, double click on Groups, then double click Administrators. Make sure the service account you found in step 7 is in the Administrators group. If they are not, they need to be added.   


12. After adding them to the Administrators group, right click on the service and select Start.  The service should start and stay running this time. 


Do you have any product features you'd like us to feature on our next Tech Tuesday article? If so please email me at danielle.erickson@eonesolutions.com.

Tuesday, April 29, 2014

Tech Tuesday: Working with Date and Time Fields in Integration between Microsoft Dynamics CRM and Microsoft Dynamics GP using SmartConnect

Today's Tech Tuesday article comes right from the trenches of working in the world of integration. In this article we are going to focus on date fields from Microsoft Dynamics CRM.

Oftentimes when customers need to transform date fields from one format to another they will just use the standard SmartConnect Date Calculation (under Additional Fields in the mapping).


This will normally allow you to transform a date field from any format to any format. In the case of this specific customer we ran into two unique issues.

1) The first hurdle was that sometimes the date field coming from Microsoft Dynamics CRM would be NULL. This presents challenges as you have to make assumptions on how you handle NULLS. 

2) The second challenge was that we had multiple regions involved. In this specific example, we had Microsoft Dynamics CRM Online (hosted in a US locale) and Microsoft Dynamics GP on premise in the UK.

This customer had a Dynamics GP field that needed that date value along with another Extender window that needed the date value. What we were able to do to accomplish this task was to provide a calculated field to meet the criteria for both scenarios. Here is the calculated field that was used below in VB.NET form:

'Use the date field from your CRM Entity below
Dim dateString as string = _CUSTOMENTITY_STARTDATE 
Dim provider as System.Globalization.CultureInfo = System.Globalization.CultureInfo.InvariantCulture
'substitute the "en-US" below with the locale of the source data
Provider = New System.Globalization.CultureInfo("en-US")

'Handle NULL/Blank value of date/datetime field 
if dateString ="" then
     return "1900-01-01"
else
     'Convert the datestring provided to a date field in locale, then convert to desired locale
     return (Convert.ToDateTime(dateString,provider)).ToString("yyyy-MM-dd")

end if

In this script we are using an interesting .NET feature. The CultureInfo class allows us to determine the locale of the date format. This in turn can be used to convert the dateString from Microsoft Dynamics CRM to the format of any locale. In our specific example we converted a US format date into the format that most of the world uses (in this specific instance, the UK). Additionally, we simply indicated that a blank value would return a standard date in the format that Microsoft Dynamics GP likes.

This script could be used to change any date/datetime field into a format suitable for Microsoft Dynamics CRM or Microsoft Dynamics GP.

Hope this helps you with any date calculation issues you may be trying to solve.

Thanks,
Chris Dew

Want more information on SmartConnect and the features it offers? Please contact sales@eonesolutions.com for more information!

Thursday, December 12, 2013

New SmartConnect Build Available

SmartConnect 2013 Service Pack 1 HF3 Updates
We have a new build for everyone today!
This release of SmartConnect enhances existing features and fixes a couple of outstanding bugs. It is available for immediate download on our website: http://www.eonesolutions.com/Downloads/SmartConnect.aspx

This update for SmartConnect 2013 has addressed the following areas:
Global Variables – In previous versions of SmartConnect 2013 you would need to initialize at least one Global Variable in order to work with any of the others. With this release, you are able to access any of the System or User Defined Global Variables in any Task or Calculated field.
Run SQL Task Parameters – You can now add multiple parameters or data source fields into a Run SQL Task. Previously it would only read the first occurrence.
WCF REST Web Service – We added some additional functionality to report errors back via the return XML coming from our web service calls.
Custom Nodes – Some customers have experienced an issue when they upgrade from a version previous to SmartConnect 2013, indicating that the mapping for their custom eConnect nodes will be removed. With this new version, all you will need to do is run the System Maintenance a second time and all custom nodes will be available.
Excel 2013 32bit and 64bit Add-in – These new Excel Add-ins were actually released last month but I wanted to highlight them again as many of you may not know they exist. They offer some great features like pulling back your existing maps and the ability to pull back data or the columns you need from the map setup. We will present a video on the new Excel Add-in in the coming months.

Our next Service Pack, slated for the first quarter of 2014, has over 30 features and I’ll tell you more in an upcoming article. As always, I love to hear your feedback on what we should put into our next versions of SmartConnect or any of the eOne products.

Thanks,

Chris Dew
Director of Product Management