Development Archives - FMT

Search Archive
Integrating Wayfair and NetSuite with Celigo: A Conveniently Efficient Solution
In today's fast-paced business environment, data integration has become crucial for companies to efficiently manage their operations. Wayfair, the e-commerce giant, and NetSuite, the cloud-based ERP solution, are two popular platforms that many businesses rely on for their daily operations. However, with data residing in different systems, it can become a tedious and time-consuming task to ensure that both systems are up-to-date and in sync. To address this challenge, businesses can leverage iPaaS (Integration Platform as a Service) solutions like Celigo, which provide a seamless integration between different systems. In this blog, we will explore how Celigo has been used by our FMT team to build a data integration between Wayfair and NetSuite, and the benefits it provides to businesses. If you aren’t familiar with Celigo, it is a powerful iPaaS solution that allows for rapid development of integrations through its published Integration Apps and templates available on the Integration […]
Microsoft Teams Is Becoming More Powerful with Power BI
Microsoft Teams provides several options for integrating popular services into tabs. One of these is a Power BI report tab. You can add a report from any workspace that you own or is shared with you as a tab on your team channel. This is awesome! We will show you how to start using this powerful function by adding the Power BI tab to Teams.   How to Add Power BI Report Tab to Microsoft Teams You can add a Power BI report tab in Teams by simply adding a tab in a channel or chat. Click here to learn more. At FMT Consultants, we took a different route since Power BI did not offer this capability previously. We needed to take it a step further and allow for some configuration of the report before adding it. Our requirement was to embed the report into a tab using user-specified criteria […]
How to Deal with eConnect Exceptions for Bank Transactions Integration in Dynamics GP
In this blog post, we are going to discuss how to deal with eConnect primary key exceptions. Let’s say there is a company called Fabrikam Inc. and they provided the data for Dynamics GP. We are going to leverage eConnect to integrate Bank Transactions into Dynamics GP. The eConnect Primary Key Exception When I try to integrate Bank Transactions into Dynamics GP, the eConnect throws an exception and the following message shows up "Violation of PRIMARY KEY constraint 'PKCM20100'. Cannot insert duplicate key in object 'dbo.CM20100'." This Primary Key error is thrown by the SQL Server whenever I tried to insert duplicate key values into the table. The primary key for the table dbo.CM20100 is a combination of two fields CMDNUMWK and VOIDED. Take a look at the screenshot below to view the schema of dbo.CM20100 table and highlighted the primary key. The Data Issue I analyzed the eConnect business […]
Why SmartConnect Is the Go-To Integration Tool for Dynamics GP
SmartConnect is a very sophisticated tool for integrations. With its high level of versatility, it does a great job of automating your integration needs. It is definitely one of my tools of choice! Data can be read from Dynamics GP, Dynamics CRM, OLEDB or ODBC, text files, Excel, XML and more. You can even use multiple data sources and then join the results from the multiple data source. This makes utilizing data sources from separate databases or even joining a database data source with a text file data source possible! You can also set a network folder as a data source. The files in the folder can be Excel, text, XML, or XmlQuery. As long as the files match a designated template (or schema for a text file), SmartConnect will be able to process all the files contained in the folder. You can designate folders to use for files that […]
Beyond WebAPI Conventions, Migrating to WebAPI 2
Trending @Microsoft: Routing, by Convention, is how ASP.NET WebAPI matches a URI String to an action. WebAPI 2 supports a new type of routing, which leverages attributes. As the name implies, attribute routing uses attributes to define routes rather than Parametrized Strings, as in WebAPI. Attribute routing provides more control over the URIs and scale of a web API. This implies… Support for Hierarchical URI schemes Eliminating magic route templates Intuitive route constraints HTTP Method attributes Route prefixes …And WebAPI 2 now provides the attributes to easily support application modeling. WebAPI and WebAPI 2 are complementing technologies and can be mixed and matched within the same API; let's look at the similarities, strengths, and weakness of the WebAPI versions… WebAPI by convention… Routing tables Routing templates Routing actions HTTP Methods OData query MapHttpRoute WebAPI 2 by attribute… Routing tables Routing attributes Routing actions HTTP attributes OData query MapHttpAttributeRoute Migrating from […]
FMT's Custom NetSuite Solutions: Serialized Number Tracking
Over the years FMT’s NetSuite team has produced a number of innovative solutions that can be characterized as a combination of configuration, custom scripting, and custom workflow development. Most of the time, these customizations are driven by real and unique customer needs that cannot be satisfied by NetSuite’s out-of-the-box functionality. The Need Recently, we were contacted by a client who was frustrated by their inability to track serial numbers in NetSuite. This client did not know how to manage warranties within their system and asked for our recommendation on how to solve this issue. We immediately scanned NetSuite for available Saved Searches/Reports relative to serial number tracking. Unfortunately, the results of our query were disappointing; there were no out-of-the-box reports related to serial numbers that we could find. We determined that we could build a Saved Search for our customer, but this solution proved to be lacking relative to their unique needs. […]
Creating a Visual Studio Extension Part 2 of 2
One of the reasons why Visual Studio is such a great development environment is its fluidity when it comes to customization. In my previous post, Creating a Visual Studio Extension Part 1, we discussed the preparation process for creating a Visual Studio Extension. In this post, I will explain the basic steps needed to create a very simple Visual Studio Extension to access text from the currently opened Editor on Visual Studio. If you have not installed the Visual Studio SDK, see my previous Blog post. Creating Your First Project Once the setup is complete, we are ready to get started. First, start your Visual Studio Version and create a new project. Next select VSIX Project under Extensibility, choose a name and location for your new extension and press ok. When done correctly, this is what you should see in Visual Studio 2015: You should also get this nice Getting […]
How to Expose a Custom Stored Procedure Within a Scribe Step
In this blog, we will discuss how a Stored Procedure can be exposed and called within a Scribe step from the Scribe Workbench. As a first step, we need to add a record into the table [dbo].[KSYNCTABLESBASE] in the database where the stored procedure that needs to be invoked exists. Once the record is added, it will show up under the Stored Procedures in the All Data Objects section as shown below. The below script exposes the stored procedure 'sp_fmtUpdateWireIntgStatus' by inserting a record into the [dbo].[KSYNCTABLESBASE] table. Note: - If the SQL objects for Scribe doesn’t exist in the database, it can be created by running the “ScribeMetaData.sql” script available in the Scribe installation folder. As a next step, we will discuss how parameter values can be passed from the Scribe Workbench. In order to expose the parameters for the Stored Procedure, we need to add one record per […]
Creating a Visual Studio Extension Part 1 of 2
Visual Studio is a great development environment with ever growing features, and getting better with each version. But there is always that one niche feature that you need that would help improve your productivity in a project - a menu item to start a custom process, an improved IntelliSense for a custom language, or an editor for a custom file type. With Visual Studio, you can easily unlock additional features with extensions. This post  will explain the basic steps needed to prepare your Visual Studio environment to create your own extensions. Installing the SDK Before you can start creating your own Visual Studio Extensions, you need to first install the Visual Studio SDK. The Visual Studio SDK is used to extend Visual Studio with new features. Learn more about Visual Studio SDK from Microsoft here. With Visual Studio 2015 the Visual Studio SDK is already included in the installer. For Visual […]
Optimizing SQL Server Files and File-Groups Made Easy
Recently I had the opportunity to work with a client on a very large Web Application; the database for this application was composed of hundreds of tables, indexes, file-groups, and files; including a dozen partition-functions and as many partition-schemes, spanning both clustered and non-clustered indexes. The client was requesting to improve performance in their database as they moved this massive application to Azure Services. In order to accomplish this, I had to complete three of the following tasks: Move all clustered indexes into fewer file-groups, with a minimal number of files in each group. With a current configuration of 150+ file-groups the client was looking for a better management strategy, which aligned the number of file-groups with their Azure hardware. Clean up the file and file-group naming conventions and make recommendations on best practices. Over the years many developers have created new SQL file-groups, with no clear convention in mind, […]
Microsoft Dynamics GP Integration Tools Guaranteed to Make Your Life Easier
Integration tools can be used to incorporate data from a variety of sources into Dynamics GP. They can also export data from Dynamics GP into many different file types such as text, Excel and XML. For some integrations, you will simply be moving data straight into Dynamics GP. For others, you will want to convert or manipulate the data prior to integrating it. Simple or complex, integration tools can make the whole process easier! The backbone of these tools is eConnect, a set of SQL stored procedures that can be installed for Dynamics GP. They are used to accept data and integrate it into the appropriate database tables. The eConnect stored procedures use business rules to validate the data before integrating it to GP, thus protecting the integrity of the data and only allowing you to insert valid data. Using eConnect without integration tools can be a complicated process. Which […]
Power View Data Visualizations - SQL 2012 Reporting Services
Power View, a feature of SQL Server 2012 Reporting Services, allows you to create reports and dashboards using a number of different data visualizations. With the ability to drag and drop data, and being able to easily switch between visualizations, Power View quickly becomes a powerful BI tool to illustrate, summarize, display and analyze your data. The following table is a list of data visualizations that come out of the box with Power View:   Click image to enlarge TABLE You can easily drag and drop fields onto a table. Columns can be easily reordered and all columns are automatically sortable. You can even include images files.   Click image to enlarge MATRIX Tables can be easily be converted into a matrix, with row and column groups. By default the matrix will have totals and subtotals for each of the groups. Additional columns can be easily added by dragging a […]
 FMT Consultants
Privacy Policy
Your Privacy Choices

Contact Us


Newsletter Sign-up

menu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram