Skip to content
+1-888-319-3663
Tech Tuesday

Tech Tuesday: Error when attempting to export SmartList data to Excel

I have run into issues in support where people are attempting to use the “Export to Excel” feature in SmartList, and receiving an error that says something like, “We found a problem with come content in “My File Name.XLSX”.  Do you want us to try and recover as much as we can?  If you trust…

[Read More]

ODBC Text File Connection

This week’s Tech Thursday will show you how to use a UNC pathname when you are writing your own query using the Microsoft Text ODBC driver.  Normally using a UNC pathname is preferable to using a mapped drive letter, since mapped drives can vary from machine to machine.  However once you are in the text ODBC…

[Read More]

Tech Tuesday: Modifying Default SmartLists

Today’s article is a simple tip, but can save you a lot of time troubleshooting SmartLists. I would estimate that I get close to 5 calls a day that start off with “My default GP SmartLists are broken or returning funny results and Microsoft said to call you”. Normally what has happened is that people…

[Read More]
Tech Tuesday

Tech Tuesday: How to Restart the SmartConnect Scheduling Service Using a Batch File

Have you ever wanted to restart your SmartConnect scheduling service without having to manually go into services and restarting it? This week’s article will show you how to create scheduled task that runs a batch file to restart the SmartConnect scheduling service. On the machine where the SmartConnect schedule service is running, create a folder…

[Read More]
Tech Tuesday

Tech Tuesday: How to Submit a Support Request

This is part 2 of my blog article “Basic Steps to Try Before Calling Support”. In my last article, I outlined some basic troubleshooting steps that anyone can do before they contact support. In this article I will give you tips for submitting a support request. Submit your support request through the proper channels. Emailing…

[Read More]
Tech Tuesday

Tech Tues: Adding MDA mapping to POP receipts

On some older versions of SmartConnect (prior to SmartConnect 2014) the MDA mapping for POP Receipts was either missing or spelled incorrectly. The Node was listed as taMdaUpdate_Items and should actually be taMdaUpdate. You can manually correct this by going into Node Maintenance in removing the node and adding it back in using the correct…

[Read More]
Tech Tuesday

Tech Tuesday: Encrypting the web.config file.

I have had numerous requests about encrypting the web.config file for the SmartConnect web service. By default a web.config file contains plain text passwords for the connection strings and impersonation account. Normally this isn’t a problem since the web.config file is hosted on an IIS server somewhere, with limited users having access to it, however…

[Read More]
Tech Tuesday

Tech Tuesday: How to Default the Account Category Description when Updating Existing GL Account Numbers

If you are trying to update an existing chart of accounts in SmartConnect, you will encounter the error that says “Sql procedure error codes returned:” followed by the information you mapped in the mapping. The error will look something like this:If you are updating posting accounts, the Account Category Description becomes a required field. The…

[Read More]

RECENT POSTS


Happy Thanksgiving from eOne! - US Office Closed November 25 & 26
Popdock: What is your Locale?
Q4 2021 Partner All Hands Call - Recording Now Available
An Announcement regarding SmartList Builder and SmartView from eOne Solutions
Join us for the Q4 2021 Partner All Hands Call!

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training