Skip to content
+1-888-319-3663

Tech Thursday : Save an Excel File From a REST Service Response

Since SmartConnect 2015 we’ve been able to connect to a variety of REST services using the REST connector.  This requires the service to provide a JSON or XML payload.  I recently came across a service that doesn’t use JSON or XML.  The GoToWebinar Admin API will only give back an Excel file, so I could…

[Read More]
Tech Tuesday

Tech Tuesday:  Removing Blank Rows from an Excel Data Source

Excel is a very common data source for SmartConnect maps, but sometimes causes problems when SmartConnect reads blank lines from a worksheet.  This isn’t an issue with SmartConnect, but rather an issue with Excel not knowing what cells are being ‘used’.  After building a spreadsheet, sometimes Excel thinks that blank rows at the bottom of…

[Read More]
Tech Tuesday

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

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 trust…

[Read More]
Tech Tuesday

Tech Tuesday: Adding Parameters to Excel Report Builder report

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. With the core Excel Report Builder, this isn’t something that can be done. But, it can be added in Excel to the report you build…

[Read More]

Demo 2 win with the eOne Sandbox – Q2 2017 Update

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. When your client says something to the effect of: “I wish there was a way to automate…

[Read More]

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

In a previous column, I had discussed how we could change the column names of the text output file that SmartConnect had created. The main reason that we would want to do this is if the output file required specific column names and SmartConnect was changing them due to source column naming conventions that SmartConnect…

[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: Using ODBC Connection to Query Data from an Excel File

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 flexibility is to…

[Read More]
Tech Tuesday

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

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 questions from the community.  So, I…

[Read More]

RECENT POSTS


eOne Announces Partnership with Akita Intelligent Solutions
Happy Thanksgiving! - eOne's US Offices Closed November 24 & 25
Recording Now Available! - 2022 Q4 Partner All Hands Call
The Query Builder: Queries for the Non-Developer in D365 Business Central - Recording Now Available!
2023 eOne SmartConnect & Popdock Bootcamps

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 Partner All Hands Call Popdock promotions release SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training