Here at eOne, we are can’t wait to get rolling in 2020. However, we’re still excited about what we accomplished in 2019! It was a banner year, we added new partners, made improvements to your favorite products, and visited with partners across the globe. Before we flip the calendar, let’s look back at some of our greatest hits of 2019, starting with Tech Tuesday. Check them out below!

Top Tech Tuesday’s of 2019


10. Troubleshooting Folder Data Source

by Lorren Zemke

“The folder data source within SmartConnect is a great way to automate an integration where the name of the file is not known at integration time or there are many files that need to be integrated throughout the workday. However, since the integration typically runs on a schedule, troubleshooting why some documents don’t process can be a bit tricky. This article will provide some methods for handling that process.” Read More.

9. Adjust the Max Message Size in Dynamics NAV

by Jared Dux

“The default Max Message Size for web service requests in NAV is set to 1024 kb. If you are using SmartConnect to process a large amount of data, you may run into a “413: Request Entity Too Large” error. When this happens, you might need to adjust the Max Message Size in Dynamics NAV.” Read More.

8. Setting up the NetSuite Connector in SmartConnect.com

by Jared Dux

We use two different authentication methods for setting up our NetSuite connector in SmartConnect.com. The first method is User Credential (SuiteSignOn) authentication. This method uses a user’s email address and password in combination with an application id, role id, and account id. The second, and preferred method, is Token Based Authentication. This method requires a little more setup on the NetSuite side, but it does have its benefits.” Read More.

7. Referencing a SmartConnect Calculated Field

by Lorren Zemke

“SmartConnect On-premise utilizes .NET scripting for creating data transformations that are more complex than can be used for the Translation Table, Date Translation or Rolling Column additional columns. However, while it is not capable of creating functions or methods to be used between integrations, calculated fields can be referenced and used within the same map.” Read More.

6. Useful Javascript Commands

by Chris Hanson

“With SmartConnect.com, another scripting language has been introduced for users to create new calculated columns and scripts. We’re going to take a quick look at a couple useful scripts and commands that will assist in building out integrations.” Read More.

5. Integrating Record Notes in Dynamics GP with SmartConnect

by Pat Roth

“Notes! Who doesn’t love record-level notes in Dynamics GP? What’s not to love about having a freeform text field to enter 32 k of information? This is the perfect blog to learn about notes!” Read More.

4. Can You Really Upgrade your SmartList Designer Lists to SmartList Builder?

by Nicole Albertson

“The answer is certainly YES as long as you are using Microsoft Dynamics GP 2018. The answer is maybe if you are using Microsoft Dynamics GP 2016 or an earlier version.” Read More.

3. Setting up a Basic Authentication Service in SmartConnect.com

by Jared Dux

“A while back I wrote an article about connecting to Shopify with the REST Connector using SmartConnect on-prem. With SmartConnect.com, this process has been simplified and also has some additional features that make working with an API easier. Currently, REST Services are available as sources in SmartConnect.com. Destinations for these services will be released at a later date.” Read More.

2. Issues to be Aware of When Creating Maps that use Text ODBC Drivers

by David Youngquist

“I get a lot of calls from people saying that SmartConnect isn’t working right. It’s either not reading their data correctly, or it’s not reading all the columns from their source file, or it’s actually saying that the source file is completely blank, when in fact it does have data in it. Most of these issues are due to limitations in the Microsoft text ODBC drivers. There are certain conditions that need to be met when reading files with ODBC text drivers.” Read More.

1. Understanding Salesforce Queries in SmartConnect

by Ethan Sorenson

“We are going to review something that can be very challenging for someone that doesn’t come from a Salesforce background. We will go into detail about how to build a SOQL query using the developer console in Salesforce and how to join multiple Salesforce objects.” Read More.

Stay on the lookout for more of our greatest hits! In the meantime, you can read other Tech Tuesday articles, or send us an email at sales@eonesolutions.com if you have any questions.