EONE
BLOG
Tech Thursday : Query data in SmartConnect with .NET scripting
Thursday, August 24, 2017 /
Lorren Zemke /
0 Comments
This article will show the basics of using a SmartConnect scripting to query additional data during an integration with the focus on the MSSQL ADO.NET Provider. With the capabilities of .NET in a SmartConnect calculated field or script task, almost any piece of data can be read or updated, if one of… [Read More]
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: Extender Update SQL View Display Names
Tuesday, July 11, 2017 /
Mark Anderson /
0 Comments
In our latest release of Extender (16.00.0050), we have added the ability to change the Display Name of the SQL Views created for Extender objects. In previous versions, the display names were created for you. IF you do not change the display names, it will default to the exact same way it did in… [Read More]
Tech Tuesday: Running a Process as a Pre-Map Task and ensuring it finishes before moving on to the next task
Wednesday, June 21, 2017 /
Chris Dew /
0 Comments
This last week I was approached by a customer that wanted to run an SSIS package (that created the data for the Map) but sometimes that task wasn't finishing before SmartConnect needed to use the result of that task as a data source. In this instance, the desired result wasn't to run the tasks as… [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]
Tech Tuesday: SOP with Header Level Taxes
Tuesday, May 16, 2017 /
David Youngquist /
2 Comments
This week’s Tech Tuesday will give an example of how to do a SOP Transaction with header level taxes. The most common scenario we run into is allowing the sales transaction to use the default tax engine inside of GP. However, the second most common request is how to import a sales transaction… [Read More]
Tech Tuesday: Extender Filter Lookups on Detail Windows
Tuesday, April 25, 2017 /
Mark Anderson /
1 Comment
In a previous Tech Tuesday article, we discussed how to add restrictions to lookups on forms and windows. This article will discuss how to apply this to fields on a detail window or a detail form. This is currently only available in our latest Extender 2016 version (build 16.00.0030 or higher). In… [Read More]
Tech Tuesday: Removing Unwanted CRM Entities From SmartConnect Mapping
Tuesday, April 11, 2017 /
Chris Dew /
0 Comments
I've often seen customers that have begun an integration or migration process to Dynamics CRM and have added entities that they really didn't want as part of that map or maybe are no longer needed as business requirements have changed. In the following article, we will walk through the steps to… [Read More]
Tech Tuesday: Using a Script to Replicate a Folder Data Source
Wednesday, April 5, 2017 /
Chris Hanson /
2 Comments
A request that we have seen occasionally from different clients is that they want the flexibility of a folder data source, but the functionality of an ODBC connection when using a flat file as a data source. We’ve written a script that can be applied to any flat file (Excel, text, XML, etc.) which… [Read More]
Tech Tuesday: Using XSL Transforms in SmartConnect
Tuesday, March 28, 2017 /
Lorren Zemke /
0 Comments
While there are a lot of applications that use XML files as a way to describe the data that is being exported out of their system there is no industry standard on the format in which XML documents are created. I have seen some pretty crazy file layouts that make it almost impossible to import using… [Read More]