Posts Tagged ‘Tech Tuesday’
Tech Tuesday: Conditionally Auto Opening an Extender Window with Extender Enterprise
The initial question was straightforward:I have an Extender window based on the Item Number in the Sales Transaction Entry scrolling window, is there a way to conditionally automatically open the Extender window based on that Item Number?We can start with the “easy” answer (ignoring the “conditionally” parameter).Extender can be configured to auto open an Extender…
[Read More]
Tech Tuesday: Unable to retrieve the next number in the sequence
SmartConnect makes use of stored procedures in each company database to retrieve default document numbers from GP. If these stored procedures are not present, you will receive errors saying, “Could not retrieve the next number in the sequence.” The stored procedures get created when you run the system maintenance in SmartConnect. Normally the solution to…
[Read More]
Tech Tuesday: Understanding SalesForce queries in SmartConnect
This week we are going to go over something that can be very challenging for someone that doesn’t come from a SalesForce background. We will go into detail about how to build a SOQL query using the developer console in SalesForce and how to join multiple SalesForce Objects. Where to build a SalesForce querySmartConnect on-premise has…
[Read More]
Tech Tuesday: Easily Run Multiple Maps from 1 Excel workbook
Tech Tuesday: Easily Run Multiple Maps from 1 Excel workbook The Excel Add-in lets you replace a SmartConnect map’s data source with an Excel table, which already allows for many possibilities. A problem comes up if you want to run several different maps all from the same workbook. This functionality is pretty simple to set…
[Read More]
Tech Tuesday: Useful Javascript Commands
With the launch of SmartConnect.com, another scripting language has been introduced for users to create new calculated columns and scripts. We’re going to take a quick look at a couple useful scripts and commands that will assist in building out integrations. For these examples I’ll describe what each script should help with, then list out…
[Read More]
Tech Tuesday: SmartConnect WCF REST Service Methods – runmap
One of the components of SmartConnect is the WCF REST service that may be installed on a machine where IIS is also installed. This document is a series of KnowledgeBase Articles that are written to show how the use and execute existing SmartConnect API methods. runmap The runmap method allows you to run a map…
[Read More]
Tech Tuesday: Could not retrieve the next number in the sequence
I ran across something interesting the other day that I can’t say that I’ve heard of happening in about 15 years of experience. While I don’t know that we’ll see this again for another 15 years, the troubleshooting process was interesting, and I thought would be worthwhile to look at. To set the stage: The…
[Read More]
Tech Tuesday: Why Extender Security is Company Specific
I talk to many people who have issues setting up security for Extender windows. The main thing that people must remember when setting up security for Extender is that Extender security is always company specific. Therefore, you need to setup a security task per company and not globally. Standard GP security is global, the same…
[Read More]
Tech Tuesday: Getting Extender Data to Appear in SmartList
An issue popped up recently where a customer was not getting Extender data to appear in SmartList. They do not have SmartList Builder (though we would recommend it) and the data was being populated previously. The issue turned out to be that the Auto-update SmartLists option checkbox in the Extender Options window had been unchecked. To turn…
[Read More]
Tech Tuesday: Using GETMAPXML/VAR to pass in parameters to a map and getting the data back
While we position SmartConnect as a tool where you don’t need to be a developer to create integrations, we have quite a few developers that want to take advantage of our interface but have all of the power to call a map whenever needed. In the example below we will explore using the GETMAPXML funtion…
[Read More]