Skip to content
+1-888-319-3663
Tech Tuesday

Tech Tuesday: Adding Company ID to SmartList Builder Multicompany Summary Report

I recently ran into a scenario that I’ve seen a few times before that I thought I’d document in today’s blog article.We’ll document the problem we’re trying to solve, the troubleshooting steps, the underlying issue, and then the solution.The scenario is this:Customer has created a summary report in SmartList Builder that does <something> and they…

[Read More]

Can SmartConnect integrate with _____?

One of the most common questions we receive is “Can SmartConnect integrate with ____ ?”  You fill in the blank, and it ranges with everything from billing engines like Braintree to marketing solutions like Hubspot to SQL-based systems as well as eCommmerce. There is certainly a lot of variety out there.  To help clarify how…

[Read More]
Tech Tuesday

Tech Tuesday: Executing SmartConnect Maps from SQL

There are many ways to execute a SmartConnect map; through the interface, scheduled, called by the web service, etc. But one method that also works which isn’t talked about as much is executing a map directly from SQL. The SQL code below covers both the initial setup needed to run maps in this manner as…

[Read More]

Tech Tuesday: Importing into Extender Tables

The importing of data into Microsoft Dynamics GP can be a very useful tool. When using Extender in your Microsoft Dynamics GP, the likelihood that you would want to import that data is pretty high as well. So, what are the best practices for this? Extender Imports: Extender has an import function built into it just…

[Read More]

Tech Tuesday: How to Perform a SQL Trace to Debug eConnect Errors

This week’s Tech Tuesday article is from our Support Guru, David Youngquist, who will walk you through how to perform a SQL trace to debug eConnect errors. 1. Find out what user the eConnect service is running under. Press the Windows + R key on your keyboard to bring up the Run command. Type in “services.msc”…

[Read More]

Tech Tuesday: Differences in Real-Time and Change Sources

For today’s Tech Tuesday our Senior Technical Consultant, Chris Hanson, discusses the difference between the change based data sources and the real-time data sources within SmartConnect. Both of the options have their own advantages and uses when you are setting up integrations on your system. Change based data sources are always handled at the SQL…

[Read More]

SmartList Builder 2013 New Feature of the Day: SQL Scripting

SQL Scripting is a feature that will soon be available in SmartList Builder and Navigation List Builder with the next release.  You will no longer have to go to SQL Management Studio and create a SQL View to pull into SmartList Builder when you want to write SQL Scripts to get the data you need.The…

[Read More]

Tech Tuesday: SmartView and SQL

The built in Visual filter is really powerful with many more options that you would have in traditional SmartList. But there will be times that even with these filter options you can not get the exact data filters you need. If you have a complex query that you can’t enter with the built-in visual filter…

[Read More]

New Feature: SQL Destination

You ask, we listen. This is the theme of our new releases in 2011. The upcoming release of SC contains a brand new destination called SQL and Stored Procedures. Have you ever wanted to do a the equivalent of a table import using SmartConnect? Have you ever wanted to pass source data into a complex…

[Read More]

RECENT POSTS


Happy Thanksgiving from eOne! - US Office Closed November 25 & 26
Popdock: What is your Locale?
Q4 2021 Partner All Hands Call - Recording Now Available
An Announcement regarding SmartList Builder and SmartView from eOne Solutions
Join us for the Q4 2021 Partner All Hands Call!

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

TAGS

Business Central CRM D365 Business Central 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 SmartPost SmartView SQL Tech Tuesday Templates training