EONE BLOG
Tech Tuesday: Difference between Excel Add-In and the Excel Template

By Ethan Sorenson Tuesday, July 25, 2017


Yes, there is a difference. Many times, we see users download our Excel Template and try to use the Excel Add-In to send data their destination. Unless some setting changes are made within the Excel Workbook, this will not work successfully.

Both methods are version neutral with SmartConnect so you can use all templates, and add-ins with any version of SmartConnect.
Both methods use web services you need to install on an IIS server. They use different web services so make sure you install the appropriate one for what you are trying to do.

Excel Templates

eOne has created a set of Excel Templates that are basically Excel files that allow for simple data entry for Dynamics GP transactions. These templates use VBA code in the background and submit to SmartConnect using the SmartConnect web service. This is the only web service that can be used for the Excel Templates. They are not compatible with the SmartConnect WCF web service.

On the  templates you click the SUBMIT button on the worksheet to run the map, as shown below.

The SmartConnect web service will typically have a url of http://myserver:5556/smartconnect/smartconnect.asmx. The server would be where the SmartConnect web service has been installed and uses the default port of 5556.

Any version of Excel, which supports Excel Macro-Enabled Workbooks, can be used for the Excel Templates.

Configuration Sheet

There is a hidden worksheet that contains the configuration information. This needs to be filled out initially before being used.

Excel Add-In

eOne has created an Excel Add-In that allows for any pre-defined Excel file, where data is in consistent rows of the same number of columns, to submit data to SmartConnect using the SmartConnect WCF web service. The SmartConnect WCF web service will typically have a URL of http://myserver:5557/smartconnect.svc. The server would be where the SmartConnect web service has been installed and uses the default port of 5557.

On the Excel Add-in you click the Run Map button to run the map, as shown below.

There are different versions of the Excel Add-In that were created for different versions of Excel.

Configuration Sheet

Like the Excel Template, there is a hidden worksheet that contains the configuration information.

Differences

The chart below highlights the difference between the two products

Excel Template

Excel Add-in

Pre-defined Excel File

User defined Excel file

Map is already provided

User created map

SmartConnect Web Service

SmartConnect WCF Web Service

Cannot be modified

Can be changed as needed (may require map changes)

One version of template for all versions of Excel and SmartConnect

Versions (2010, 2013, 2016) based on your version of Excel.


Why would I choose the Template instead of the Add-in?

The templates are restricted compared to the add-in, but as long as they meet your needs they will be easier to implement. They won’t require the anything be installed on work stations, and the map is already created for you.

Common Errors

The primary issue you will encounter when trying to use the Excel templates with the add-in is the configuration sheet for the template will be overwritten with the details from the add-in which make them invalid. You will see the below errors.

The parameter is incorrect

System error: -2147012890

The only way to correct this is to start over with a new version of the template, and do not use any features in the add-in.






Don't Be Greedy:Share on FacebookTweet about this on TwitterShare on Google+Pin on PinterestShare on LinkedInEmail this to someone

Written By Ethan Sorenson

Leave a Reply

Your email address will not be published. Required fields are marked *

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.