Posts by Lorren Zemke
Tech Tuesday: Using XSL Transforms in SmartConnect
While there are a lot of applications that use XML files as a way to describe the data that is being exported out of their system there is no industry standard on the format in which XML documents are created. I have seen some pretty crazy file layouts that make it almost impossible to import using…
[Read More]Calling MySQL Stored Procedures
How do I call a stored procedure in my MySQL database using SmartConnect? Once you have connected to your MySQL database using the ODBC Connection type, per this article Connecting to ODBC Datasources, you can use the syntax below. Call MyStoredProcedure(parameterList); If you need to find the name of the stored procedure you can use the…
[Read More]
Tech Tuesday: Understanding Dynamics GP eConnect Errors
It’s inevitable that when creating an integration to Dynamics GP there are going to be errors returned at some point in the process due source data differences, mapping data incorrectly or differences in eConnect business logic. We might have missing vendors or customers or distributions amounts don’t match documents amounts or we haven’t provided a…
[Read More]
Troubleshooting ODBC Data Source Errors in SmartConnect
*Only applies to versions of SmartConnect 20.18 and olderOne of the most common methods of integrating data using SmartConnect are Microsoft Excel Files or flat files such as comma or tab delimited. To make connecting to these files quicker and easier, SmartConnect contains a list of Excel versions that can be selected or we can…
[Read More]
Using SmartConnect to connect to ODBC Data Source
While SmartConnect has several default connectors for Microsoft Dynamics GP, Microsoft Dynamics CRM and Salesforce.com there are many more connections that can be created using an ODBC Data Source. Within the SmartConnect User Interface several ODBC connections have been listed by default as examples that can be used in SmartConnect.We are going to look at…
[Read More]
Next Dynamics GP Document Number with SmartConnect
When integrating transaction data into Dynamics GP many times the data source does not have a document number that can be used or should not be used. This requires users to either create their own document number scheme or retrieve the value from Dynamics GP setup tables. Thankfully, SmartConnect has a simple method to retrieve…
[Read More]
Applying Payables Documents in SmartConnect Integrations
One of the most common requests we receive at eOne is how someone can apply payments checks or documents using SmartConnect. After all, you can do it with Receivables, so why not Payables? SmartConnect uses Microsoft’s eConnect API to send data to Dynamics GP, which means the data available for update from SmartConnect are based…
[Read More]Tech Tuesday: Ask User for Input
Have you ever wanted to ask a user to enter values when they integrate data in SmartConnect? This week’s Tech Tuesday is from our Director of Professional Services, Lorren Zemke, who will lead you through an example of doing just that! Overview While most data integrations are executed on a scheduled basis or the…
[Read More]Tech Tuesday: SmartConnect Processing Sequence
Our Director of Professional Services, Lorren Zemke, will be taking you through the SmartConnect processing sequence for this week’s Tech Tuesday! In this article I am continuing my series of discussions on how SmartConnect processes data. Previously I’ve used examples on summing values and working with line sequence numbers. Today I will diagram the process…
[Read More]SmartConnect Windows Service
I hope to clear up some confusion about the One SmartConnect Windows Service functionality and where/how it should be installed for SmartConnect to function properly. The main purpose of the Windows Service is to execute SmartConnect maps on a scheduled basis but is also used to manage changed data source records and map logs. …
[Read More]