EONE BLOG

eOne’s Greatest Hits of 2019: Tech Tuesday


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.

Leave a Comment





RECENT POSTS


Tech Tuesday: Making sure GP is active for SmartPost
Throwback Thursday: Troubleshooting Scheduled Maps
Employee Spotlight: Sandy Westman, Senior Consultant
eOne Offices Closed for Labor Day - Monday, September 7th
eOne Presenting at DynamicsCon 2020 - Free Virtual Conference

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

ARCHIVES

open all | close all

TAGS

Business Central CRM 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 SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartView SOP SQL Support Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.