EONE BLOG

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]

TechTuesday : Connecting to Spark Pay using the REST Connector

  Tuesday, March 21, 2017   /     Jared Dux   /     0 Comments
This week we are going to take a look at using SmartConnect to integrate to Spark Pay using the REST connector.  SmartConnect can be used to get data from Spark Pay and create or update data in Spark Pay.  This will not go through completely setting up the connector from scratch as there will be… [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]

CATEGORIES

ARCHIVES
open all | close all