HELP ARTICLES

Help Articles

  Friday, June 16, 2017   /     Nicole Albertson
General Questions:  … [Read More]
  Thursday, December 8, 2011   /     Kevin
When trying to import notes into CRM using SmartConnect, you receive the following error: The entity with a name = '1' was not found in the MetadataCache.This occurs when the Object Type attribute is incorrectly mapped in the entity mapping screen. In CRM the Object Type is a picklist, but the… [Read More]
  Wednesday, July 11, 2018   /     Patrick Roth
I have a Shopify REST connector set up in SmartConnect that has been working for some time.Now when I try to run a SmartConnect map using that Shopify REST connector as either a source or destination I get the error:Connection could not be validated.The underlying connection was closed: An… [Read More]
  Thursday, May 4, 2017   /     David Youngquist
Starting in Microsoft Dynamics GP 2013, there is a new option added to the SmartList window.  On a standard installation, pressing this button will open the Microsoft SmartList Designer product.  If you have SmartList Builder installed, pressing the button will open eOne SmartList Builder.   … [Read More]
  Thursday, August 9, 2018   /     Ethan Sorenson
Looking to integrate with Microsoft Dynamics 365 Business Central?  Your first step in SmartConnect will be to set up the connector, then you will be able to create your SmartConnect maps to set up your integrations.The Dynamics NAV/D365 Business Central Odata Connector is available in SmartConnect… [Read More]
  Thursday, December 8, 2011   /     Kevin
How to write a case statement in a data source query using the Microsoft ODBC Text driver. The syntax for a case statement using the Microsoft ODBC Text driver is different than it would be in SQL. This is an example of a case statement: iif(F15='DropShip','1661','2684') as ACCT This is… [Read More]
  Tuesday, March 28, 2017   /     David Youngquist
When launching SmartView internal, receiving an error that says "A network-related or instance-specific error occurred while establishing a connection to the SQL Server.  The server was not found or was not accessible.  Verify that the instance name is correct and that SQL Server is configured to… [Read More]
  Wednesday, March 26, 2014   /     David Youngquist
Running a map with dollar amounts mapped to it.  For each transaction that tries to get imported, receiving an error that says "Failed to convert parameter value from a String to a Decimal".  The odd thing is if the transaction amounts are integers, the map runs.  It's only when decimal places… [Read More]
  Tuesday, April 11, 2017   /     Lorren Zemke
I am trying to compare a Salesforce.com field with a string that contains a single quote character and I am receiving the error, ERROR at Row:1:Column:390 unexpected token: s … [Read More]
  Thursday, May 26, 2016   /     Brady Swenson
Running a map using the WCF Webservice returns the error message "The Request failed with HTTP status 405: Method Not Allowed".Typically, this indicates an issue with the Real time and SmartList web service URL, which is found under the SmartConnect Dynamics GP Connector.To correct this issue, log… [Read More]
  Thursday, July 23, 2020   /     Ethan Sorenson
The purpose of this post is to provide a thorough walk-through of Global Variables and how to use them when building … [Read More]
  Tuesday, July 14, 2020   /     Lorren Zemke
Recently we have encountered multiple customers who have TLS turned on for communication with their Office 365 Email system instead of SSL. This in turn prevents their SmartConnect system from sending emails on map tasks.Just in case you are not aware of the ability to send emails within… [Read More]
  Wednesday, April 1, 2020   /     David Youngquist
Using a SmartConnect map with an Excel data source.   Recently there have been issues opening the map, the error is telling me that the data source cannot be found, however if I close the map and reopen it, it will sometimes reconnect.  On the occasions when it fails, when I hit the validate… [Read More]
  Tuesday, March 24, 2020   /     Katie Soderberg
 
eOne resellers paying on behalf of their customers and customers who have a monthly subscription to eOne products and service offerings can add the subscription as an automatic payment when they are logged into the eOne website. Here are the steps to add a new automatic payment:Go… [Read More]
  Monday, February 24, 2020   /     David Youngquist
Attempting to install the SmartConnect Excel Add-In on a machine, receiving an error that says "Info 1625.  This installation is forbidden by system policy.  Contact your system administrator".  The error normally looks like thisThis will typically happen when you attempt to install the Excel… [Read More]
  Friday, December 27, 2019   /     Ethan Sorenson
OverviewSmartConnect will automatically find new Objects and fields added to SalesForce by parsing the metadata provided by the Salesforce web services. This article will go through the steps to resolve cases where an Object or field is not visible for use in SmartConnect.Connector SetupCheck the… [Read More]
  Thursday, December 12, 2019   /     Ethan Sorenson
Failed to retrieve data from source: Attempting to select a readonly publisher for solutionCauseThis error occurs when attempting to create a Dynamics 365 CRM Change Data Source. The cause is a publisher with the prefix eone already exists in CRM and is assigned to a managed… [Read More]
  Tuesday, December 10, 2019   /     Michelle Aune
eOne Solutions is delighted to offer a SmartConnect Solution Success Manager.Your Solution Success Manager is fully committed to your success using SmartConnect and wants to make sure you’re aware of the resources and benefits included with your SmartConnect purchase.Shortly after your purchase,… [Read More]
  Tuesday, December 10, 2019   /     Michelle Aune
eOne Solutions is committed to the success of each SmartConnect sale and provides a solution success manager, Michelle Aune, to assist in launching each SmartConnect project. We know some customers will want to hand you their integration project and let you manage it entirely. That’s great. In… [Read More]
  Thursday, October 31, 2019   /     Ethan Sorenson
For connectors that connect to a database on a local server, you will need to open a port to allow SmartConnect to access them. To protect your security, you can add firewall white list rules to only allow SmartConnect in. The IP addresses that require access vary depending on your app login… [Read More]

FILTER BY PRODUCT


ARCHIVES

open all | close all

TAGS

Business Central CRM Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP GPUG integration Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Office Relationships partners Popdock release Reporting SalesForce SalesForce.com scripting SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Support Tech Tuesday Templates training Zendesk