Tech Tuesday : Changing the Column Names on an Excel File Destination

  Tuesday, May 23, 2017   /     Patrick Roth   /     0 Comments
In a previous column, I had discussed how we could change the column names of the text output file that SmartConnect had created. … [Read More]

Can SmartConnect integrate with _____?

  Wednesday, May 17, 2017   /     Katie Soderberg   /     0 Comments
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… [Read More]

Tech Tuesday : Sorting An Excel Source in SmartConnect

  Wednesday, February 22, 2017   /     admin   /     0 Comments
If you need to sort and group an excel file after it has been imported as a source your options to sort aren't as clear as some of the other options. Below are some examples that explore how sorting an excel input works in the SmartConnect connector. … [Read More]

Tech Tuesday: Using ODBC Connection to Query Data from an Excel File

  Tuesday, August 23, 2016   /     Jared Dux   /     0 Comments
Most often when a user needs to use an Excel file for their source data in SmartConnect they choose Microsoft Excel as their Data Source and then choose the Sheet that contains the data they need. This sample pulls all the records from the selected sheet. Another option that will allow more… [Read More]

This application is not configured to run with this operating system

  Friday, July 22, 2016   /     Lorren Zemke   /     0 Comments
We just installed Excel 2016 and when we open a SmartConnect map that uses Excel as a Data Source we receive the error "This application is not configured to run with this operating system"This is due to running Office applications in compatibility mode or by a corrupted installation of Microsoft… [Read More]

Tech Tues: Update to Automatically Refreshing Pivot Tables in Excel Refreshable Reports

  Tuesday, July 12, 2016   /     Nicole Albertson   /     0 Comments
There has been some discussion lately on the refreshing of the Pivot Tables in Excel Refreshable Reports.  I previously had written a Tech Tuesday post about how to get a Pivot Table pulling data from an Excel Refreshable Report.  You can view that post here:With this post brought many different… [Read More]

Unable to load odbcji32.dll

  Wednesday, June 1, 2016   /     Lorren Zemke   /     0 Comments
A user is trying to open a map with an Excel data source or an ODBC Data source pointing to an Excel file and getting the error message "Unable to load odbcji32.dll". This is caused by an update to Excel or office on the individual machine and can be resolved by reloading the Excel Drivers that… [Read More]

Tech Tuesday: Calling the SmartConnect REST Web Service from VBA in Excel

  Tuesday, February 16, 2016   /     Chris Dew   /     1 Comment
Today’s Tech Tuesday is going to be very focused on the topic of running a SmartConnect Map from VBA for Excel. In this article we will show you how to run a map in two ways, one by using the configured datasource and another by overwriting the datasource with data from the Excel workbook. These… [Read More]

Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports

  Tuesday, December 1, 2015   /     Nicole Albertson   /     23 Comments
Using the refreshable Excel Reports is a great option to be able to view your Microsoft Dynamics GP data in a tool we all love.  Whether they are the default refreshable ones that can be deployed from Microsoft Dynamics GP or ones you create using eOne's Excel Report Builder, getting the list and… [Read More]

Tech Tuesday: Working with values in Excel with VBA

  Wednesday, November 5, 2014   /     Chris Dew   /     0 Comments
Recently the eOne team was working on releasing some new Excel templates for SmartConnect and ran across a unique issue. In the General Ledger template we have code that compares the Sum of the Debits and Credits to ensure they match before submitting the transaction to Dynamics GP. What we were… [Read More]


open all | close all