Announcements
Hi
I am currently trying to setup a mapping in Smart Connect to GP 2015
The Group is Wennsoft Shared and the Node Type is WS PM Transactions.
I am getting the following error when I run my map: Conversion failed when converting the varchar value 'vendor' to data type int.
Is anyone able to assist on how I get this working it would be greatly appreciated as I'm very new to Smart Connect?
Thanks in advance
Hayley
*This post is locked for comments
You should probably take a look at the eOne support forum, at www.eonesolutions.com/.../smartconnect-questions. If you need to open a support case with them, it's just support@eonesolutions.com.
Meanwhile, SmartConnect is reading your source data as varchar, which is probably what it should be. However, it's trying to convert it to an integer, which doesn't seem right. I wonder if your mapping is incorrect.
I don't have any Wennsoft products installed, so I'm not familiar with their nodes.
If you truly need to convert varchar to int, then you'll need a calculation to do so. Here is a lengthy article that describes various ways of using vb.net to accomplish this: www.dotnetheaven.com/.../how-to-convert-string-to-integer-using-vb.net
There is a shorter answer here: stackoverflow.com/.../how-do-i-convert-from-a-string-to-an-integer-in-visual-basic
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
