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]Object Reference not set to an instance of an object on SmartConnect map validate
I have an existing SmartConnect map that is pointing to an Excel file. If I add a new column to that file, I receive the error message ‘Object reference not set to an instance of an object’ when I click validate or preview. The map was working until I added the new column. The issue…
[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]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]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]Analyzing and troubleshooting why a map will not run scheduled.
Tips for troubleshooting a map that will run when manually started, but fails when you schedule it.
[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]