Posted inOff-topic

SQL – Search for special characters

Sometimes it may happen that by importing data from external sources (even with Web Services), some special characters are written and then uploaded to NAV \ Business Central. These characters (even if accepted) could then give problems to searches, XML exports, blocking the sending of documents.…
Posted inOff-topic

PowerShell Duration

This is a really quick tip just for myself to save the script where I can easily get to it, this time a quick way to output the duration of a PowerShell script. When a script takes longer than expected, in my mind I am waiting…
Posted inOff-topic

Upload Files to SFTP via Powershell

I was asked how to upload files to SFTP from Business Central, there are several ways to do it and several posts published about it for Business Central. In this case, without going through other Azure services, PowerApps etc., it is possible to do it directly…
Posted inOff-topic

Export SQL data to CSV or XML File via Powershell

Sometimes it may be useful or necessary to use powershell to read data from SQL Server to export it to other formats This can also be used with older versions of Dynamics NAV which do not have access to the integrated powershell. Using standard powershell commands…