-
-
Data Migration and Import: Using field delimiter characters in the source files
To run data import and data migration, you have to prepare a source file that contains the data you want to import. The data source files must be formatted as comma-separated values (CSV) files. The field values in the source file can be separated by commas, tabs, or other characters that are defined in the -
Microsoft Dynamics CRM, Email correlation and smart matching
What is correlation and why is it required. One of the important scenarios in email management within CRM is to have the incoming email get associated with the correct object it’s regarding to. Consider the scenario where you have created an email related to a case and sent to a customer. The customer responds to -
Basic SQL – Creating users in NAV on SQL
This post is part of “Overview of NAV-specific SQL features for application consultants”. Before you can set up a user in Microsoft Dynamics NAV on SQL Server, you must create the user on SQL Server first. If you try to create a user which does not exist on SQL Server, you will get this error -
Basic SQL – How to create a new NAV database for restoring a NAV backup
This post is part of “Overview of NAV-specific SQL features for application consultants”. This post describes the steps needed to create a new NAV database from a NAV backup (.fbk) file. All the steps are done from a NAV client: 1)Â Â Â Â Start a NAV client (finsql.exe), then go to File -> Database -> New. In -
Basic SQL – Enable trace flag 4616 on SQL Server
This post is part of “Overview of NAV-specific SQL features for application consultants”. The newest versions of Microsoft Dynamics NAV require trace flag 4616 to be enabled on SQL Server. If not, then you will get this error message when you try to connect: === The trace flag 4616 is not set on the server -
Basic SQL – Creating Extended Stored Procedure / xp_ndo.dll
This post is part of “Overview of NAV-specific SQL features for application consultants”. Microsoft Dynamics NAV requires two extended stored procedures from xp_ndo.dll to exist on SQL Server if Windows logins are used. If these extended stored procedures do not exist, you will get this error when trying to log on using Windows Authentication: The -
Performance – memo/ntext fields
Performance issues in AX can be some of the most difficult to troubleshoot. Particularly as there’s so many different areas which can potentially be the cause/solution to the issue. This post will just talk about one of the potential causes of bad performance, no doubt we’ll cover some more performance issues in later posts. One -
Microsoft Dynamics CRM Plug-in Template for Visual Studio
The Microsoft Dynamics CRM User Experience team is always looking to improve our customers’ experience when using the SDK. Past examples of our work in this area include publishing the Plug-in Developer tool and the Plug-in Registration tool for registering plug-ins and custom workflow activities. This blog is about another useful tool for your development -
Storing Configuration Data for Microsoft Dynamics CRM Plug-ins
CRM MVP Mitch Milam returns as a guest blogger. One of the benefits to the plug-in architecture of CRM 4.0 is the ability to store plug-ins in the CRM database so they may be used by multiple CRM servers. This introduces a slight complication regarding the storage of configuration information. Because the plug-in assembly doesn’t -
Debugging in NAV 2009
UPDATE 25 August 2010! You cannot use the Express version of Visual Studio 2008 SP1 to debug Microsoft Dynamics NAV 2009. UPDATE: Debugging is not available in the Marketing Beta, so if you have access to a later build you can try this out. If not you will have to wait for RTM. Also note -
Business Data Catalogue (BDC) and Microsoft Dynamics CRM
Business Data Catalogue (BDC) is one of the very exciting features of SharePoint. It got introduced in SharePoint 2007. This gives a declarative way to connect SharePoint to business applications such as standard ERPs, CRM, home grown apps etc. It supports direct DB access as well as access through Web services. You can find good