Posts Tagged ‘Tech Tuesday’
Tech Thursday: SmartConnect and Windows Platform FIPS Encryption Policy
We haven’t seen it a lot, but more often lately and interesting enough a problem that I thought I’d write a blog article on this issue. In this blog article, we’ll define what the Windows Platform FIPS Encryption Policy is and then how we can make SmartConnect work with this policy enabled. So, the easy…
[Read More]
Tech Tuesday: How to manually activate and deactivate SalesForce Apex Triggers
Real time SalesForce data sources make use of what are called Apex Triggers. When you register the map, it creates an Apex Trigger, when you unregister the map, it removes the Apex Trigger. However, on occasion, you might want to activate and deactivate these triggers manually instead of going into SmartConnect and registering and unregistering…
[Read More]
Tech Tuesday: Accessing the Real-time Request Log in SmartConnect.com
In SmartConnect.com, the Realtime Request Log will give a user a summary of the result of a Realtime Process run. The log will show whether the process ran successfully or failed. It will also allow the user to see all or a snippet of the data sent from the real time data source.To access the…
[Read More]
Tech Thursday: New Field Types in Extender
We have added two new field types to Extender, Website and Email Address. As you can see in the screenshot below the 2 new field types were added to an Extender window. One for the Vendor Website and one for the Contact email address.These new fields will work on an Extender form as well, just…
[Read More]
Tech Tuesday: SmartView Aged Trial Balance Cannot Be Modified
SmartView has a great feature to give you a Receivables Aged Trial Balance as well as a Payables Aged Trial Balance. If you are unfamiliar with this feature, you can find more information on it here.Need a Better Aged Trial Balance? Check Out SmartView.The one big question we get on these lists is if they…
[Read More]
Tech Tuesday: Getting a Hyper-V Virtual Machine Online
If you’ve ever had to troubleshoot networking issues on a virtual machine, I share your pain. I recently had a several day battle with my VM that eventually ended in win for me, but not without changing everything up to a wired connection and reading more than I wanted to about switches. The problem with…
[Read More]
Tech Tuesday: Connecting to SmartConnect and SmartConnect Online From Excel
It’s no secret that getting a hold of your data in Excel is important (and sometimes absolutely necessary) for many businesses. Excel is unmatched in terms of data manipulation capabilities for everyday tasks, but it can be a huge pain point getting data into/out of the systems we use. Getting data into and out of…
[Read More]
Tech Tuesday: Using Power Query to Merge Worksheets for the Excel Addin
If you have multiple sheets in an Excel file that need to be integrated with the SmartConnect Excel Addin, this process will help to get all the data into one sheet for the addin.In Excel, the first step is to create a data connection for each sheet containing the data we need. Select any cell in…
[Read More]
Tech Thursday: Source File Name from Excel Folder Data Source
In my last blog post, we discussed the problem of a folder data source and not knowing the source file name was that each row of data in the map came from.In that post, the source file type was a text file, so it wasn’t terribly difficult to use .NET to read the folder file…
[Read More]
Tech Thursday: Resetting the web client password in SmartConnect
One question I’ve seen come in a few times recently is “how do I reset the web client password in SmartConnect?” It’s easy. Simply follow my steps below and you’ll be well on your way. Open SmartConnect, hit the “Setup” tab, and then click on the “Security” button. Highlight the user you want to change the password…
[Read More]