Tech Tuesday: Error when attempting to export SmartList data to Excel

  Tuesday, August 1, 2017   /     David Youngquist   /     0 Comments
I have run into issues in support where people are attempting to use the “Export to Excel” feature in SmartList, and receiving an error that says something like, “We found a problem with come content in “My File Name.XLSX”.  Do you want us to try and recover as much as we can?  If you… [Read More]

Tech Tuesday: Adding Parameters to Excel Report Builder report

  Wednesday, July 5, 2017   /     Nicole Albertson   /     0 Comments
We have been asked many times if you can have parameters in an Excel Report Builder built report so the end user can restrict down the data a little easier. … [Read More]

Demo 2 win with the eOne Sandbox – Q2 2017 Update

  Thursday, June 15, 2017   /     Katie Soderberg   /     0 Comments
There is no more critical way to make or break a sale than during the demo.  At eOne, we understand how important this is and that timing, showing a compelling scenario, and having a reliable, comprehensive environment is everything.  … [Read More]

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

  Tuesday, May 23, 2017   /     Patrick Roth   /     1 Comment
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   /     eOne Solutions   /     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]


open all | close all