-
In a previous blog I showed how to get the database name and the database server name for NAV 2009. I used Automation object to read the service configuration file and pull from there the required information. This method is obsolete for NAV 2013 but here is the required code to pick similar and more...
-
Microsoft Dynamics NAV is still using the old DOS code page for files. If you create a file with the file variable and write text to that file you will get a DOS file. The same thing happens when writing to a BLOB and exporting to a file. The Code example below handles the DOS code [...]
Posted to
Gunnar's Blog
by
thegunzo
on
2013-5-30
Filed under:
Filed under: Dynamics NAV, How-To's, NAV 2009 R2, XML, Data Transfer, C/Side Code, CSV File, Dotnet interoperability, Text File, NAV 2013, Stream
-
These days I keep busy upgrading Advania solutions to Dynamics NAV 2013. All the older solutions that have communicated with web services have DOM objects and manually created XML files. We had to add and remove namespace to be able to use XML ports but in the end this worked flawlessly. In NAV 2013...
-
I was scanning a TIF image into a BLOB field in Dynamics NAV. If the BLOB field is defined as an image I will see a thumbnail for the image in my Page. In my scanning code I wanted to create a record link for the record I was linking to and that link was supposed [...]
-
In NAV 2009 I used a custom control add-in to enable timers in the Role Tailored Client. NAV 2013 ships with a control add-in that is called PingPong. In upgrading one of my solution to NAV 2013 I wanted to remove the custom control and introduce the PingPong instead. The control requires a name and...
-
As I was reading the list of published platform updates for NAV 2013 I saw that Microsoft was fixing a bug where the content of a BLOB field is not transferred to a new record with the TRANSFERFIELDS function. I must admit that I have never counted on the TRANSFERFIELDS function to move the BLOB data...
-
I wrote a solution to log blocking in NAV with the help of Microsoft SQL Native Client. I wanted to be able to use this solution for a client but then ran into a problem with the SQL Native Client. There are three versions out there and the connection string must include the version installed [...]
-
I am using web services in a company that does not have the license to use the Mobile Document Dispatcher. In Codeunit 1 and trigger CompanyClose there are functions to stop listeners. This is causing problems in the web service so I changed the code to and the error is history.
-
In my current upgrade process I needed to copy the Record Link table from one database to another. I can use a copy-paste method for small number of records but in this case I needed something else. A Dataport or a XML Port was the way I choose to go. There is one problem though. [...]
-
In the Classic Client we had the C/AL command BEEP to sound an alert to the user. This function is not supported in the Role Tailored Client. Here we have a solution in .NET. Where Console is a RunOnClient DotNet variable ‘mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089′...
-
In the sales process NAV check for both credit limits and overdue balance on the customer. This is a needed process to inform the salesperson before posting the order or the invoice. However, the problem is that the warning is … Continue reading →
-
If you have worked on a Role Tailored Layout and wanted to show a report without decimals you have most likely seen that the AutoFormatType option that we have in the Dynamics NAV 2009 R2 Classic Client does not work … Continue reading →
-
I have been working with the dotnet interop and consuming soap web services. I wrote about a dotnet interop based way to communicate with soap web services in a previous blog but now I want to demonstrate another way that … Continue reading →
-
I am currently working on a solution that requires a Dynamics NAV client to communicate with Dynamics NAV web service. This I have done before with the classic client and have used automation objects for the job. Now I wanted … Continue reading →
-
On of the bigger tasks when upgrading to the Role Tailored Client is the report transformation. In big database there are houndreds of reports. Some of them might just be idle reports that are never used. This blog from ArcherPoint … Continue reading →