Posts Tagged ‘Tech Tuesday’
Tech Tuesday: Troubleshooting Folder Data Source
The folder data source within SmartConnect is a great way to automate an integration where the name of the file is not known at integration time or there are many files that need to be integrated throughout the workday. However, since the integration typically runs on a schedule, troubleshooting why some documents don’t process can…
[Read More]
Tech Tuesday: Setting up the NetSuite Connector in SmartConnect.com
We use two different authentication methods for setting up our NetSuite connector in SmartConnect.com. The first method is User Credential (SuiteSignOn) authentication. This method uses a user’s email address and password in combination with an application id, role id, and account id. The second, and preferred method, is Token Based Authentication. This method requires a…
[Read More]
Tech Tuesday: Integrating Record Notes in Dynamics GP with SmartConnect
Notes! Who doesn’t love record level notes in Dynamics GP? What’s not to love about having a freeform text field to enter 32k of information into?Long time GP users know that the (almost) universal field for a note is the NOTEINDX field in the table for that GP record. For a RM Sales Transaction, the…
[Read More]
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]