Posts Tagged ‘Tech Tuesday’
Tech Tuesday: SmartConnect.com Multi Data Sources
There are times when we need to leverage data from multiple connectors in one data source. When this need arises we can leverage the querying power of Popdock to pull data from an unlimited number of connectors. Table of Contents Popdock Connector List Types Compare Lists Join Lists Merge lists Create a Popdock Data Source…
[Read More]
Tech Tuesday: SmartConnect Setup for Office 365 E-Mail with TLS
Recently we have encountered multiple customers who have TLS turned on for communication with their Office 365 Email system instead of SSL. This in turn prevents their SmartConnect system from sending emails on map tasks.Just in case you are not aware of the ability to send emails within SmartConnect, click here for a refresher on…
[Read More]
Tech Tuesday: Using Variables in a Web Service Action Endpoint
Many web services require the use of a path parameter to complete a request. For example, the Teamwork Add Time Entry endpoint requires a project id to be able to add time an invoice: base_url/invoices/{id}/lineitems.json. If we entered the project id path parameter directly in the url, the endpoint will only work for one project.…
[Read More]
Tech Tuesday: Business Central Item Image Web Service
Today we will look at how to use SmartConnect to import/export files with NAV/Business Central. These files can be several different types including JPG/PNG/PDF/MP3/MP4, you can find a full list of supported types here. The most common requirement we see is to import image files or attach invoices and receipts. I will show how I…
[Read More]
Tech Tuesday: Export to File Destinations in SmartConnect.com
Recently, we have added the option to export to file destinations in Smartconnect.com. This option allows for us to send data to an excel or text file. There are also options to include headings, overwrite files, append data/time, create separate files per key field, append the key field to the filenames, and enclose column values…
[Read More]
Tech Tuesday: Create a Simple Action in Popdock
When you are on a sales call, there might be times you want to know more information about your customer. It could be something simple like you want to know more about their geographic location, such as the state they are in or their complete address. Another option is to do an internet search for…
[Read More]
Tech Tuesday: SmartView Favorite Tracking
I have previously talked about tracking your SmartList Favorites using a feature in SmartList Builder. This can help you track the favorites in your system and help you clean up all the unused ones that you have and don’t need any longer.Well, now you will have the same option in SmartView (Internal). Today we released…
[Read More]
Tech Thursday: SmartConnect Configuration Utility
Within the SmartConnect executable folder, there is a wonderful tool called eOne.SmartConnect.Config.exe. This tool allows for corrections to the SmartConnect configuration file. By default, the SmartConnect configuration file is encrypted so we cannot manually modify it and this utility gives us that option. Typical SituationsHere is a list of typical items the Configuration Utility will…
[Read More]
Tech Tuesday: Multi-Tenant Destinations
Last week multi-tenant options were added to Smartconnect.com destinations. This will allow you to have one integration run to several different destinations. This is available for Business Central/NAV, Dynamics 365 Customer Engagement/CRM, Microsoft SQL Server, NetSuite, and Salesforce.The setup for multi-tenant can be found on the Target tab while setting up an integration process. There…
[Read More]
Tech Tuesday: Using CDATA tag in SmartConnect to avoid leading spaces from being removed
A common error that we see when doing any kind of GP documents that have an account number is:The Account Number (ACTNUMST) does not exist in the Account Index Master Table. When eConnect does account validation, it takes the Account Number that you give it and query the GL00105 table – GL00105.ACTNUMSTR – to find the…
[Read More]