Posts Tagged ‘Tech Tuesday’
Tech Tuesday: Adjust the Max Message Size in Dynamics NAV
The default Max Message Size for web service requests in NAV is set to 1024kb. If you are using SmartConnect to process a large amount of data, you may run into a “413: Request Entity Too Large” error. When this happens, you might need to adjust the Max Message Size in Dynamics NAV.If we trace…
[Read More]
Tech Tuesday: Fix Missing GP Accelerator Keys with Extender Enterprise
I’ve seen this question several times over the last few months and typically happens after a customer updates their GP from 2010 to a newer version.I’ll get a screenshot like this (boxes added by me for later clarification)Fig 1: GP 2010 with Accelerator keys visible for GP windowsand a message similar to this:I have just…
[Read More]
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]