-
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...
-
As the Icelandic localization for NAV 2013 is supposed to land here in April it is now time to start moving the solutions to the new platform. One of the things that I have used are the automation variables for SQL server connection. In NAV 2013 I plan to replace all automation variables with dotnet...
-
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. [...]
-
XE.COM claims to be the world’s favorite currency site. They have XML data feed options that can be used to download the latest currency exchange rates into Dynamics NAV. I wrote a batch to import the current currency exchange rate from their data feed. … Continue reading →
-
To follow up the post about writing a text file with Automation I would also like to post about reading a text file with that same Automation. Now we add the automation automation ‘Windows Script Host Object Model’.File. First you … Continue reading →
-
I have been working on a solution for file download. I am now able to download both binary and text files both via http and ftp and both with Classic Client and Role Tailored Client. Attached is a codeunit that … Continue reading →
-
On several occasions I have needed to create a code to communicate with Soap Web Services. The manual labor in creating the functions and XML Ports is something that I would like to be rid of. On that node I … Continue reading →
-
In the process of importing data from MSSQL into NAV I needed to import a comment text. I wanted to import the text into the Note BLOB field in the Record Link table. It was not obvious how to do … Continue reading →
-
When starting a new company the needed data is in most cases accessible for Microsoft Excel. Do we want the user to be able to import data from Excel into Dynamics NAV ? This object allows import into any table … Continue reading →
-
Some of our clients are using LS Retail.That solution supports stand-alone POS terminals that are running Microsoft Dynamics NAV. It is therefore easy to allow these terminals to be used also as a punch clock. This punch clock starts up a … Continue reading →