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

Incoming Documents instead of Links

If you want to add files to a nav document like orders, then you normally use the link factbox. For that you have to link files on file shares, local paths are not allowed (not reachable from other systems). That only works, if the current user has the needed permission and the network path is… Continue reading Incoming Documents instead of Links

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

How to display sum value in factbox on base of multiple line selection

Typical issue is to show a calculated value in a factbox on base of the currently selected line in a list page or the lines in a subpage. Is it possible to get a calculated value on base of more than one selected line? Let’s check out. Let’s say we want to display the sum… Continue reading How to display sum value in factbox on base of multiple line selection

Simple Read/Write Excel Data

In a Nav forum there was a question, how to read data from an excel document, change the data in Nav, write data back to the excel document without changing the existing cell formatting. With table ExcelBuffer and the helper assemblies delivered with Nav this cannot be done, because the Write functions e.g. SetCellValueText work… Continue reading Simple Read/Write Excel Data