Posts Tagged ‘Map’

SmartConnect – Extra Source Records

Why does my map run show more records being processed than exist in the data source? This mistake can easily be made in SmartConnect map setup. This article will show how to find the problem and correct it.  Create Map We are going to start by creating a map with an Excel data source.  When…

[Read More]

SmartConnect – Zip File as Source

Using a Zip file as a SmartConnect Source By default, we can’t use a zip file within SmartConnect as a data source directly, however we can write a pre-map script to extract the contents of the zip file. This article is for the on-premise version of SmartConnect only and has only been verified with SmartConnect…

[Read More]

Unable to retrieve the Map Lines for the selected service. Not a valid destination NAV Page Service.

When attempting to select a NAV Page service in the destination area of a Map you receive the message “Unable to retrieve the Map Lines for the selected service. Not a valid destination NAV Page Service”.As the message indicates the Service Page is not a valid service you can use as a destination and you…

[Read More]

Map hangs at “Retrieving data…” when importing Payroll transactions with SmartConnect

When importing payroll transaction with SmartConnect, the map hangs on “Retrieving data…”, however the record count is correct and the “Done” button is enabled down in the lower right corner of the progress window. This will happen if the name of one of your source file parameters exactly matches one of the eConnect parameters.  With Payroll…

[Read More]
Tech Tuesday

Defaulting Non-imported Distributions With SmartConnect

I’ve been working with SmartConnect for a few years now and eConnect for another ten more before that and one fairly common thing I run into is users often want to bring in a specific distribution (typically SALES or PURCH distribution) and let the rest default.As it turns out, that even while Microsoft Integration Manager…

[Read More]

Connection could not be validated. Could not load file or assembly ‘eOne.SmartConnect.Remote.Loader’

When running a map in SmartConnect via the web service, receiving an error that says “Could not load file or assembly eOne.Smartconnect.RemoteLoader or one of its dependencies.  The system cannot find the file specified. This occurs when the web service cannot locate the eOne.Smartconnect.RemoteLoader.dll file. In order to resolve it, perform the following steps on…

[Read More]

Failed to convert parameter value from a String to a Decimal

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 are added to the…

[Read More]

SmartConnect scheduled maps stop on February 29th.

SmartConnect maps that were scheduled to run on February 29th have stopped running and have not resumed.This is caused by an issue with SmartConnect not recognizing February 29th as a valid date time. To resolve the issue do the following. 1. Open the SmartConnect Scheduler Master Maintenance window. (Maps – Scheduled Maps). The window will…

[Read More]


Use the REST Connector to parse nested Value Arrays
SmartConnect email task fails with error: An invalid character was found in the email header
Does SmartConnect import into Avalara Avatax software
Could not initialize a collection when launching SmartConnect
ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key when you open a SmartConnect map.


SSL Security error using OLEDB Connection
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms
The server process could not be started because the configured identity is incorrect.
Using WINSCP and a task to upload or download files from an SFTP site



open all | close all


Business Central CRM D365 Business Central 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 integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SmartConnect SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training