How to: Get record count for all tables

In newer Nav versions the tables overview in development environment/database information has gone. So how to get that list back ? Let’s got to SSMS (Sql Server Management Studio). There select the database, for which you want that information. Right click on database -> Reports -> Standard Reports -> Disk usage by Top Tables There we… Continue reading How to: Get record count for all tables

How to work with big item descriptions

Sometimes it’s needed to save very long descriptions, but in Nav text fields can have only 250 characters. Additional you may want to search in these long text values. You can add a couple of these text fields to save long texts or save the text in text files and add them to the item.… Continue reading How to work with big item descriptions

Mass data import

There was an issue with importing all UK post codes from a csv file, about 3m post codes. Importing using rapidstart services (excel import) can cause buffer overflow messages. excel itself has row/size limitations. Increasing MaxNoOfXMLRecordsToSend in config file ClientUserSettings.config from default value 5000 to e.g. 20000 is no problem and can help. Also changing MaxUploadSize in server… Continue reading Mass data import

ReplaceString and a new SelectString

With function ConvertStr you can replace substrings in strings. The original substring and the replacement have to have the same length. So what to do, if the length is different? Here is a solution. ReplaceString(String : Text[250];OrigSubStr : Text[100];ReplSubStr : Text[100]) : Text[250] // StartPos : Integer StartPos := STRPOS(String,OrigSubStr); WHILE StartPos > 0 DO BEGIN String… Continue reading ReplaceString and a new SelectString

Convert Tab delimited strings

I had an issue to process a csv file with TAB delimited text lines. The existing code expected text lines with ; as delimiter. Character TAB has ASCII Code 9. So i wrote following code: ConvertTabString(line : Text[250]) : Text[250] ch := 9; // of type Char line := CONVERTSTR(line,FORMAT(ch),’;’); exit(line); test code: // set… Continue reading Convert Tab delimited strings

Textual Data Export by Configuration

An often by customers wanted feature is to get a data export to a text/csv file, which can then be edited in excel or text editor. Yes, you can use Rapidstart Services. But with that feature you can only export data in excel format, not in text format. That’s ok for editing in Excel and reimport the changed data back to… Continue reading Textual Data Export by Configuration

Dynamics NAV -Show table relations

In posting “The big picture” i published an upgraded version of Kamil Sacek’s tool to show all the table relations. This version needs a developer license. So it’s not useable for end users without developer license. For that kind of end users i developed a simplified solution, which does not need a developer license. But… Continue reading Dynamics NAV -Show table relations