Posts Tagged ‘Tech Tuesday’
Tech Tuesday: Issues to be aware of when creating maps that use text ODBC drivers
I get a lot of calls from people saying that SmartConnect isn’t working right. It’s either not reading their data correctly, or it’s not reading all the columns from their source file, or it’s actually saying that the source file is completely blank, when in fact it does have data in it. Most of these…
[Read More]
Tech Tuesday: Creating a Popdock endpoint to use with Power BI
Today’s Tech Tuesday blog comes from our team at Popdock. We’ve had so many requests & questions around how to get Popdock into Power BI that we thought we’d share our step by step guide. Take a look at the guide here. If you have any questions, please don’t hesitate to reach out support@popdock.com.
[Read More]
Tech Tuesday: We want to hear from you!
Each Tuesday (and let’s be honest, sometimes Thursdays instead), we share tips and tricks around one of our products. The topics often come from common things we hear in our support queue or deal with on the services side of the house. Well, this week, we want to hear from you! Are there tips and tricks…
[Read More]
Tech Thursday: Referencing a SmartConnect Calculated Field
SmartConnect On-premise utilizes .NET scripting for creating data transformations that are more complex than can be used for the Translation Table, Date Translation or Rolling Column additional columns. However, while it is not capable of creating functions or methods to be used between integrations, calculated fields can be referenced and used within the same map.…
[Read More]
Tech Tuesday: Connecting to Sales 365 with Multi Factor Authentication
If your Office 365 account is using multi factor authentication and you want to use it to connect to Sales 365 with SmartConnect, you will need to do a few extra steps within your Office 365 account to make the connection. Login to your Office 365 account – https://portal.office.com/account Navigate to Security & privacy>>Additional security…
[Read More]
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]